SQL Database Reliability Engineer

ADP is hiring a SQL Database Reliability Engineer. This is a hybrid role.

• Are you empathetic to client needs and inspired by transformation and impacting the lives of millions of people every day?
• Do you enjoy resolving issues and being the go-to person?
• Are you looking to join a dynamic, inclusive team environment with a culture of collaboration and belonging?

Well, this may be the role for you!
The SQL Database Reliability Engineer will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, ensuring the availability and consistent performance of the RUN application. The successful candidate will be responsible for monitoring, maintaining and updating SQL Server Clusters within a 24x7 Production environment. They must also be able to 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 DBA support for other non-production environments as required.
KEY RESPONSIBILITIES:

• Optimize production system and identify bottlenecks, ensuring high levels of data availability.
• 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 2017 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 (Blocking, SQL timeouts, deadlocks, unexpected data condition etc.) in real time, 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
• Assist application developers with complex query tuning, schema refinement, 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 issue management system
• Reviews other Database Developer's code for accuracy, standards, good coding practices, and adherence to documentation standards
• Ensures data security by enforcing ADP and team security standards
• Provides SQL Server DBA support for non-production SQL Server environments
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Create automation for repeating database tasks
• Provide 24x7 support for critical production systems
• Perform scheduled maintenance and support release deployment activities after hours

Skills and Qualifications:

• Solid understanding of relational database concepts and best practices
• Intermediate level knowledge of SQL 2017 Database Administration
  • SQL Server AlwaysOn Clusters
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services
  • SQL Profiler
  • Experience with scripted database maintenance
  • Experience troubleshooting stored procedure performance (executions plans, IO statistic)
  • Experience troubleshooting deadlocks
  • Experience with backups, restores and recovery models
• 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 (Spotlight and Splunk a plus)
• PowerShell and Unix shell scripting skills
• Outstanding oral communication and writing skills
• Strong analytical and business process skills
• Strong mathematical and statistical knowledge
• Ability to effectively prioritize and execute tasks under pressure to meet tight deadlines
• Flexible, team player, "get-it-done" personality. Ability to multi-task and context-switch effectively between different activities and teams
• Highly self-motivated and directed with an impeccable attention to detail
• Experience with MongoDB, MariaDB (MySQL/NoSQL), and Redis is a plus

EDUCATION AND EXPERIENCE:

• Bachelor's degree in computer science or a related field
• 3-5 years of experience supporting enterprise SQL Server 2014 (or newer) database applications with focus on Database Administration
• Experience with Azure, MongoDB, MariaDB (MySQL/NoSQL), and Redis is a plus
• MCSA SQL Server or MongoDB certifications

Base salary offers for this position may vary based on factors such as location, skills, and relevant experience. Some positions may include additional compensation in the form of bonus, equity or commissions. We offer the following benefits: Medical, Dental, Vision, Life Insurance, Matched Retirement Savings, Wellness Program, Short-and Long-Term Disability, Charitable Contribution Match, Holidays, Personal Days & Vacation, Paid Volunteer Time Off, and more. The compensation for this role is $75,600.00 - $202,590.00 / Year
Diversity, Equity, Inclusion & Equal Employment Opportunity at ADP: ADP affirms that inequality is detrimental to our associates, our clients, and the communities we serve. Our goal is to impact lasting change through our actions. Together, we unite for equality and equity. ADP is committed to equal employment opportunities regardless of any protected characteristic, including race, color, genetic information, creed, national origin, religion, sex, affectional or sexual orientation, gender identity or expression, lawful alien status, ancestry, age, marital status, or protected veteran status and will not discriminate against anyone on the basis of a disability. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.
Ethics at ADP: ADP has a long, proud history of conducting business with the highest ethical standards and full compliance with all applicable laws. We also expect our people to uphold our values with the highest level of integrity and behave in a manner that fosters an honest and respectful workplace. Click https://jobs.adp.com/life-at-adp/ to learn more about ADP's culture and our full set of values.