Senior SQL Server DBA

Chicago, Illinois 60606

Employment Type:
Date Added:
May 27, 2015

Palace Gate seeks a Senior SQL Server Database Administrator for our premier client in downtown Chicago, IL. This is a full-time opportunity in the financial services industry.

The Senior SQL Server DBA will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. The Senior SQL Server DBA will design, develop and standardize SSRS, SSAS and SSIS platforms as components of client’s MS SQL Server environment. The Senior SQL Server DBA will design and implement MS SQL Server data replication solutions which are used for operational and disaster recovery.

Technical Skills - Senior SQL Server DBA:

  • Deep and broad knowledge of full range of DBMS technologies, data replication, architectural patterns, design standards and options
  • Deep technical knowledge of database services systems management tools
  • Deep understanding of DBMS technologies: MS SQL Server 2008/2012
  • Experience with data architecture and design of OLTP, DSS, OLAP, data warehouse, Star Schema (Dimensional model) and relational databases. Enterprise data management architecture and design covering all aspects from exploratory data warehouses to user-facing business intelligence front-end and reporting services.
  • Excellent architecture, design, configuration, implementation, operations support and troubleshooting skills with database, data warehouse, data replication, OLTP, OLAP, DSS, reporting and analytical technologies
  • Extensive knowledge of Windows platforms, application and data integration. Five to 10 years of experience with database architecture, design, data replication, operations support and troubleshooting. Linux and PostgreSQL knowledge a plus.
  • Broad understanding and knowledge of data architecture and development of business intelligence environments, solutions delivery, integration and data management including data security technologies and best practices
  • Data modeling experience (PowerDesigner, ERwin)

Professional Experience and Background - Senior SQL Server DBA

· 7-12 years of relevant database architecture and administration experience required

· At least 7-12 years of experience in selecting, design engineering, solution engineering, project engineering, integrating and implementing database services architecture and related technologies in a matrixed corporate environment

· Demonstrated effective decision making that had significant impact on database technology direction and related business results

· Financial services background preferred

· Strong background and understanding of the technical direction and prevailing industry standards in the financial services space

Education and Certifications - Senior SQL Server DBA

· Bachelor’s degree in related field required; Master’s degree preferred

· MCDBA certification required

Interpersonal/Communication Attributes - Senior SQL Server DBA

  • Ability to explain complex technical detail and trade-offs to non-technical associates
  • Ability to interact with senior leadership team and influence peers and management in the decision-making process
  • Excellent communication skills including the ability to present complex presentations to large audiences and management
  • Ability to facilitate and conduct crucial conversations in an environment in which priorities quickly shift and emotions are high. Foster open, honest, two-way communication.
  • Ability to effectively communicate with service providers who may not report directly to this position
  • Ability to develop and present database architecture, standards and performance metrics

Qualified candidates should send their resumes to

Palace Gate Corporation is an information technology consulting firm that provides innovative staffing solutions to industry leading companies across the United States. Our experienced team uses new and unique approaches to deliver the right technology solutions and meet the most demanding enterprise needs. We strive to enable our clients to continue their success and achieve their business objectives by providing expert IT consultants. Our company approach is simple: Match the right people with the right opportunity.

Palace Gate Corporation offers full medical and dental insurance, 401(k) plus match and weekly direct deposit. For more information or to view our open jobs, please visit