Senior SQL Server DBA | Codersbrain
Job Description
Senior Database Administrator
Company Overview
TCG Digital is the flagship data science and technology solutions company of ‘The Chatterjee Group’ (TCG), a multi-billion dollar global conglomerate. With ‘Velocity to Value’ as its mantra, TCG Digital accelerates enterprise digital transformation by delivering rapid, measurable ROI through its state-of-the-art advanced analytics platform – TCG MCube, leading businesses to successful and sustainable disruption. For more details, please visit TCG Digital.
Job Summary
We are seeking a Senior Database Administrator with over 8 years of experience to manage and optimize our database infrastructure. The purpose of this role is to ensure the performance, availability, and security of our SQL Server and MySQL databases, and to support our commitment to delivering high-quality data solutions.
Responsibilities
- Install, configure, and maintain SQL Server and MySQL instances.
- Manage and monitor database performance, availability, and security.
- Configure and support replication and clustering for high availability, automatic failover, and disaster recovery.
- Perform regular maintenance, including backups, index optimization, and patching.
- Troubleshoot database issues, including performance tuning and query optimization.
- Implement and monitor backup and recovery strategies.
- Support schema changes, data migrations, and upgrades.
- Review and approve all SQL changes submitted through GitHub pull requests to ensure code quality, performance, and best practices.
Qualifications
- Educational Qualifications: Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
- Proven experience administering MS SQL Server and MySQL in production environments.
- Strong knowledge of replication technologies and cluster configuration.
- Solid experience with performance tuning, query optimization, and indexing strategies.
- Familiarity with high availability and disaster recovery solutions.
- Hands-on experience with backup/restore strategies and monitoring tools.
- Knowledge of scripting/automation (PowerShell, Bash, Python, or similar).
- Understanding of cloud-hosted databases (AWS RDS) is required.
- Excellent problem-solving, troubleshooting, and communication skills.
Preferred Skills
- Exposure to DevOps/Infrastructure as Code (IaC) tools (Terraform) for database infrastructure.
- Familiarity with Continuous Integration/Continuous Deployment (CI/CD) integration for database changes.
- Knowledge of auditing, encryption, and compliance standards (e.g., GDPR, HIPAA, SOX).
- Experience with Power BI.
Experience
- Minimum of 8 years of experience in database administration.
Environment
- The position is full-time, located in Kolkata. Local candidates are preferred, with no relocation options available. Candidates from JNTU/Osmania and those from South India will not be considered.
Salary
- Estimated salary budget of 24 LPA.
Growth Opportunities
- Opportunities for advancement within TCG Digital as we continue to grow and innovate in the technology sector.
Benefits
- [Benefits information not provided; please consult company resources or inquire during the interview process.]