Senior SQL Server Database Engineer
Publishers Clearing House - Port Washington, NY

This job posting is no longer available on Publishers Clearing House. Find similar jobs: Publishers Clearing House jobs

Publishers Clearing House (PCH), headquartered in Port Washington, NY, is currently seeking a highly motivated Senior SQL Server database engineer with well rounded experience to join our team. Candidate will be working on development / operational support of high-volume 24/7 OLTP systems as well as SQL Server BI implementations at PCH.

Our audience is substantial, and highly performing, available and scalable systems are just as essential to our continued success and growth as the availability and accuracy of reporting and analytics data. This role requires a highly motivated individual with a strong sense of ownership, strong technical and analytical expertise as well as longer term planning abilities.

Duties & Responsibilities include but are not limited to:
Schema design, refactoring

Creating and / or optimizing Store Procedures to be executed against a high volume, high availability OLTP system / BI Implementations

Develop and implement ETL processes using SSIS

Database performance tuning

Participate in DB engineering architecture process

Develop performance metrics

Assist with report generation and Data Analysis

Support production and development databases

Support Network Operations team, both proactively and in crisis mode

Assist team with DBA support when needed

Required Skills

Ability to produce sophisticated stored procedures and functions

Manage data sources upwards of 100s of millions of rows of data

Constructed and optimized queries for high volume, high availability, real time deployments

Strong experience with database concepts and fundamentals

7+ years of experience in database administration and development on the Microsoft platform with SQL Server 2005/2008

Experience with high-volume, transactional web-based systems

Strong theoretical and practical data modeling skills

Strong skills in T-SQL / store procedure development

Strong skills with SQL Server Integration Services (SSIS)

Strong performance tuning and optimization skills, including procedure and query tuning and index management.

Experience with SQL Server Analysis Services (SSAS)

Experience with Source Control packages

Experience with SQL Server Reporting Services (SSRS)

Good written and verbal communication skills

Good general understanding of enterprise level software development and deployment lifecycles

Bonus : Degree in Engineering or Mathematics

Bonus : Strong skills in Data Analysis

Join our winning team & apply today!

This is a New York based position. Applicants must reside in the tri-state area.

PCH is an Equal Opportunity Employer

Required Experience

Publishers Clearing House - 2 years ago - save job
About this company
14 reviews
If your doorbell rings unexpectedly, it's probably just your neighbor stopping by for a chat. But it could be the Publishers Clearing...