Senior SQL Server Database Engineer

Profile

This is a full-time position located in New York.
Publishers Clearing House (PCH), headquartered in Port Washington, NY, is currently seeking a highly motivated
full time
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
Requirements:
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
Qualifications:
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 and apply today!
This is an onsite, New York based position. Applicants must reside in the tri-state area.
PCH is an Equal Opportunity Employer
Position Type: Full Time Hire
*NO RECRUITERS PLEASE*
Publishers Clearing House
Port Washington, NY 11050
Web: ****

Company info

Sign Up Now - SQLCrossing.com