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
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
Publishers Clearing House - 2 years ago
If your doorbell rings unexpectedly, it's probably just your neighbor stopping by for a chat. But it could be the Publishers Clearing...