Location
Mumbai | India
Job description
Job Description
Broadridge is growing! We are looking for our next Sr. Database Engineer to join our team. We are seeking a technical expert in designing, managing, and administering Databases on premise and in Cloud (AWS) to meet the shifting organizational demands. Candidate will be working closely with development team and key stakeholders and apply technical proficiency across various aspects of database support for our client using various tools to perform fault analysis, failure avoidance and diagnosis and resolution for any impacting issues. Are you looking for an impactful role where you can really make a difference See below!
This is a remote role where you will work off-site. Travel is limited and generally used for team learning and collaboration meetings. This is also an individual contributor role at this time
Qualifications - Minimum 8 years of recent hands-on experience in SQL development, SQL Database Administrator and Data Warehouse
- Extensive hands-on experience with SQL Server
- Education: BS/MS in Computer Science or equivalent
- Financial Industry experience is a plus
- Strong analytical abilities and problem-solving skills; strong communication skills
- Working knowledge of ETL techniques, tools, and processes
- Minimum five (5) years of experience in using tools to optimize database performance. SQL server is a must
- Knowledge and hands-on experience in cloud architecture, AWS, Jenkins, and deployment processes is a plus
Responsibilities - DBA, Automation and Performance expert
- SQL server Database Engineering role
- 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
- Support production and development databases
- Understand the role of database and its integration points with the application and be able to advise on troubleshooting avenues during production troubleshooting bridges
- Working knowledge of VMware, hands on experience working with Locks and Deadlocks
- Develop custom alerts and performance metrics for database servers
- Create scripting PowerShell and Jenkins automations for DEV/QA/PROD data migration and for many other types of tasks
- Perform data analysis and database management
- Working knowledge of SRE and system administration activities
- Solution and architect the enterprise Disaster Recovery and High Availability strategy to protect client database environments
- Knowledge of AWS based databases is preferred
- Troubleshoot database related latency, deadlocks, indexes, and resource utilization problems during batch cycles
- Optimize SQL queries for optimum performance by analyzing query plans
- Upgrade of large volume of SQL servers, working with Vendors and architects to execute large scale enterprise SQL upgrades
- Knowledge of SQL Server tools, (SSMS, Extended Events, SQL Profiler, Query Store etc.)
- Be very proficient with database monitoring tools, both off the shelf and home-grown scripts, be adept in forensic data collection and working with MS on severity 1 problems
- Analyze data models for inefficiencies to improve performance
- Be able to advice on performance tuning metrics as suggested by Microsoft best practices
- Assist the team in various phases of development, including design, implementation, integration, revision control, release and the maintenance of multiple products and systems which use database services
- Perform impact analysis of application changes performed that impact database performance
- Maintain documentation of business and functional requirements using confluence and Jira.
Working Hours: Rotating in below shifts Shift-A 6AM to 3 PM IST
Shift-B 1 PM to 10 Pm IST
Broadridge Financial Solutions (NYSE: BR), a global Fintech leader with $5 billion in revenues, provides the critical infrastructure that powers investing, corporate governance, and communications to enable better financial lives.
Itiviti was acquired by Broadridge in May 2021 and is now Broadridge Trading and Connectivity Solutions. Our combined offering enables simplification and streamlining of all front office, middle office, and post-trade functions — powering connectivity and multi-asset trading across global markets.
Job tags
Salary
