Database Admin

Job Description

At Broadridge, weve built a culture where the highest goal is to empower others to accomplish more. If you re passionate about developing your career, while helping others along the way, come join the Broadridge team. Willing to work in 24X7 rotational shifts with on-call support. 5+ years of experience in Database Engineering role with primary expertise in SQL Server. Good to have knowledge\expertise in other DB platforms. Perform DB performance tuning and troubleshooting on Production DB systems as needed. Perform SQL Server query plan analysis and provide recommendations to development teams. Closely work with development teams in developing and testing database code, stored procedures, triggers etc. Troubleshoot and fix database latency, deadlocks, blockings, waits and resource utilization problems. Prepare RCA and provide recommendations. Design, architect, and implement new and existing SQL Server instances for scalability and reliability. Work in a technical role with other IT towers to develop and adopt a comprehensive SQL server strategy. Optimize Database performance by closely working with Development teams providing guidance and recommendations as needed. Work with Development and Product teams on data models. Perform day to day DBA tasks for production and non-production databases. Install and Perform DB upgrades and DB patching in a large DB farm following best practices. Understand the role of database and its integration points with the application and be able to advise on troubleshooting avenues during production troubleshooting bridges. Develop custom monitoring alerts and performance metrics for database servers. Develop automations using T-SQL, PowerShell, or any compatible programming languages. Good knowledge of Windows, SRE and system administration activities Architect and implement High Availability and Disaster Recovery solutions using SQL Server Always ON, replication, log shipping etc. .