Sr. SQL DBA - Genzeon (Hummelstown)

Compensation

: $83,690.00 - $125,470.00 /year *

Employment Type

: Full-Time

Industry

: Information Technology



Sr. Database Administrator job description:

Genzeon is currently seeking to hire a Sr. SQL Database Administrator out of our Exton PA office to support an ongoing, long term initiative that we have with one of our valued healthcare customers. This position is a long-term contract and could be a potential contract to hire for the appropriate resource. Genzeon is a Microsoft Gold Certified Partner company who builds customized Applications, Performance Engineering, Healthcare Information Technology (HIT), Partnered and Strategic Resourcing solutions to the healthcare industry throughout the United States and across the globe. We specialize in custom development in addition to cloud and database solutions using the latest Microsoft technologies.

Responsibilities/Requirements:

The nature of the position involves being responsible for operations support for a large scale SQL Server environment supporting platform in a Data Warehouse environment. The machines consist of 64 CPU's and 1 Terabyte of Ram and the main responsibilities of this individual will be to keep this environment running at an optimal level with strong performance in mind. When issues arise it will be this individuals responsibility to either personally rectify the issue or delegate it to appropriate development team and instruct them on how to fix the problem. The entire Data Warehouse is built on Column Store Indexes, so we are looking for someone with deep expertise in this area. In addition to this, candidates need to be well versed in:

SQL Queries and Transact Stored procedures to be used for performance tuning purposes.

Database Administration and Data Warehousing including:

Database Architecture & Design.

Data Warehousing including being capable of designing and maintaining schemas.

Performance optimization and tuning including detects performance bottlenecks using scripts.

High Availability and Disaster Recovery.

Restore databases.

Configure database backups

Configure 3rd party and in-house analytics tools.

A nice to have would be any experience with Service Broker Cues for parallel execution. (If you do not have this experience, our Sr. Architect will provide training on this.)

  • Data Warehouse feeds into TIBCO Spotfire so any experience with this would also be a nice to have but is not, by any means mandatory

  • Associated topics: data analyst, data engineer, data integration, data integrity, data manager, data management, data quality, mongo database administrator, sql, teradata * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

    Launch your career - Upload your resume now!

    Upload your resume

    Loading some great jobs for you...