Lead Database Administrator
- Infinite Computer
- 6 - 8 years
- Bengaluru
- 14 days ago
- Email to a friend
- Report this job
Job Description
Senior Database Administrator / SQL Developer Job Summary: We are seeking a highly skilled and experienced Senior MS SQL Server Database Administrator to manage and support mission-critical, customer-facing environments. The role involves implementing and maintaining high-availability and disaster recovery solutions, including Always On Availability Group Cluster and replicated (OLTP/ODS) environments deployed in both private cloud datacenters (VMWare) and AWS EC2 instances. The candidate will ensure optimal performance, security, and scalability for our customers environments.Role and Responsibilities:
- Design, implement, and maintain MS SQL Server databases in a hybrid cloud environment.
- Support multiple hosted customer SQL Server environments from SQL Server 2014 -2019.
- Manage and support Always On Availability Groups for high availability and disaster recovery.
- Configure and manage OLTP (Online Transaction Processing) and ODS (Operational Data Store) replicated environments.
- Monitor database performance, identify bottlenecks, and apply optimizations to ensure high availability and scalability.
- Perform regular backups, restores, and database maintenance tasks to ensure data integrity and availability.
- Implement database security best practices to ensure data protection and compliance with industry standards (e.g., HIPAA, HITRUST).
- Collaborate with development, infrastructure, and DevOps teams to support database architecture, tuning, and deployment strategies.
- Troubleshoot and resolve complex database issues, providing 24x7 support for production environments as needed.
- Participate in on call support and after-hours rotations for customer upgrades, script executions, and maintenance.
- Create and maintain database documentation, including configuration, processes, and runbooks.
- Assist with ad hoc and custom reporting using T-SQL for customers including management and collaboration with offshore reporting team.
- Develop and implement automated processes for monitoring, backups, and failover to improve efficiency.
- Develop custom Stored Procedures and SQL Agent Jobs
- Automate repeated DBA tasks using SQL Agent Jobs and PowerShell.
- Respond to customer requests via Jira tickets and work directly with customers on solutions to issues and custom processes.
- Bachelor s degree in Computer Science, Information Technology, or related field (or equivalent experience).
- 7+ years Database Administration Experience.
- Extensive experience with MS SQL Server 2016/2019, including installation, configuration, and troubleshooting.
- Strong expertise with Always On Availability Groups and high-availability architectures.
- Proficient in managing large databases in a hybrid cloud environment.
- In-depth knowledge of database replication, performance tuning, and query optimization techniques.
- Experience with backup/recovery strategies and disaster recovery planning.
- Strong scripting skills (T-SQL, PowerShell) for automation and database maintenance.
- Familiarity with monitoring tools (e.g., SQL Sentry, DataDog, Prometheus, Grafana) and cloud management platforms (AWS RDS, EC2).
- Excellent problem-solving skills, with the ability to troubleshoot complex issues under pressure.
- Experience with security and compliance standards (HIPAA, HITRUST) is a plus.
- Strong communication and collaboration skills required as this is a customer facing position.
- Knowledge of Windows Server, command line, and PowerShell.
- Knowledge of SSIS and installing and executing SSIS packages.
- AWS Certified Solutions Architect or AWS Certified Database - Specialty.
- Familiarity with DevOps practices and CI/CD pipelines.
- Experience in database administration/management for large-scale, high-traffic environments.
Working Hours:
- US EST hrs (8 am - 5 pm EST)
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Administrator
Employement Type: Full time
Contact Details:
Company: Infinite ComputerLocation(s): Bengaluru
+ View Contact
Keyskills: VMware Performance tuning Automation MS SQL Senior Database Administrator Windows Stored procedures SSIS Troubleshooting SQL
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Infinite Computer
Infinite Computer Solutions India Ltd. Infinite Computer Solutions (India) Limited is a global service provider of Infrastructure Management, Intellectual Property (IP) leveraged solutions and IT services, with focus on Telecom, Media, Manufacturing and Healthcare Industries. Our services span f...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in