Sr. DBA
Sr. DBA
Sr. DBA
We are seeking a highly skilled and experienced Senior Database Administrator (DBA) with a minimum of 8+ years of experience specializing in MS SQL. The ideal candidate will have a deep understanding of database architecture, management, and optimization. You will be responsible for ensuring the performance, availability, and security of our databases.
Key Responsibilities:
Database Management:
- Install, configure, and maintain MS SQL database servers and
- Monitor system health and performance to ensure high levels of performance, availability, and security.
- Perform regular database maintenance tasks such as backups, restores, and
Log Shipping and Replication:
- Set up and manage MS SQL log shipping for high availability and disaster
- Implement and maintain replication strategies to ensure data redundancy and
- Monitor replication processes and resolve any issues promptly.
Performance Tuning and Optimization:
- Optimize database performance through indexing, query tuning, and schema
- Analyze and resolve database performance issues, bottlenecks, and
- Conduct regular performance tuning and capacity
Security and Compliance:
Implement and maintain database security measures to protect sensitive data.
- Ensure compliance with industry standards and regulations.
- Manage user access controls and permissions.
Backup and Recovery:
- Develop, implement, and maintain robust backup and recovery
- Conduct regular backups and perform test restores to ensure data
- Plan and execute disaster recovery
Automation and Scripting:
- Develop scripts to automate routine database tasks and improve operational
- Implement monitoring tools and automated alerts for proactive database
Documentation and Support:
- Create and maintain detailed documentation of database configurations, procedures, and best practices.
- Provide technical support and guidance to developers and other team members.
- Participate in on-call rotation and respond to database-related
Qualifications:
- MCA, Tech, M.Tech
- Minimum of 8+ years of experience as a Database Administrator, with a strong focus on
Skills:
- Proficiency in MS SQL database administration, including installation, configuration, and
- Experience with database backup and recovery, disaster recovery planning, and high availability
- Strong knowledge of SQL and experience with query optimization and performance