Job reference #6170_8523799

JOB PURPOSE: The primary role of the RUN Engineering DBA is to monitor, maintain and update SQL Clusters within a 24 X 7 Production environment. The DBA will diagnose database related application problems, perform root cause analysis and recommend corrective action in coordination with other Engineering DBAs and Application Developers. The candidate will also provide SQL support for other Non-production environments as required.

KEY RESPONSIBILITIES:

Optimize production system and identify bottlenecks, ensuring high levels of data availability.

To liaise with Developers and Engineers and provide SQL Server database expertise when needed.

KEY DUTIES/TASKS:

• Monitors business critical production SQL Server clusters during peak hours and respond to incidents to ensure high levels of availability
• Performs SQL Server 2008 R2 and 2014 cluster and standalone installation and configuration in accordance with documented standards
• Collects detailed SQL Servers performance metrics and makes tuning recommendations.
• Investigates root cause for database related application errors (SQL timeouts, deadlocks, unexpected data condition etc.), provides document explaining root cause and recommends fixes (including recommending changes to application stored procedures) to avoid future recurrences.
• Coordinates the database portion of the disaster recovery plan and participates in the planning, testing and implementation of recovery procedures.
• Manages SSRS data warehouse and provides guidance and assistance to reports developers working to meet business reporting requirements.
• Monitors and optimizes schedules for SQL Server Agent based maintenance jobs (backups, statistics maintenance, index maintenance, etc.)
• Coordinates with Senior DBA staff and Engineers to provide input for capacity planning.
• Coordinates with Senior DBA staff to establish and document standards for database administration relevant to the RUN application.
• Provides assistance and guidance to application developers with database schema and stored procedure optimization according to company conventions and best practices
• Writes or peer reviews DML scripts to correct data conditions and processes scripts through TeamTrack issue management system
• Ensures data security by enforcing ADP and team security standards
• Provides SQL Server DBA support for non-production SQL Server environments

 SKILLS AND KNOWLEDGE:

• Solid understanding of relational database concepts and best practices
• Intermediate level knowledge of 2008/2014 Database Administration.
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services
• SQL Clustering
• SQL Profiler
• Experience with scripted database maintenance
• Experience troubleshooting stored procedure performance (executions plans, IO statistic)
• Experience troubleshooting deadlocks
• Excellent knowledge of T-SQL, Stored Procedures, Functions, Triggers and Linked Servers
• Exposure to enterprise-level database systems with distributed data architectures.
• Excellent knowledge of database monitoring, SQL Server internals and root cause analysis
• Outstanding oral communication and writing skills.
• Strong analytical and business process skills.
• Ability to effectively prioritize and execute tasks under pressure to meet tight deadlines.
• Ability to work unsociable hours as needed.
• Experience working in a team-oriented collaborative environment
• Highly self motivated and directed
• Keen attention to detail.

EDUCATION AND EXPERIENCE:

• BS Degree in Computer Science or related area
• 3-5 years of experience supporting enterprise SQL Server 2008 (or newer) database applications with focus on Database Administration

Experience with ASP.Net, WCF MCITP or MCTS SQL Server certifications are a plus.

At ADP, we believe that diversity fuels innovation. ADP is committed to equal employment opportunities regardless of race, color, genetic information, creed, religion, sex, sexual orientation, gender identity, lawful alien status, national origin, age, marital status, non-job related physical or mental disability, or protected veteran status. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.