Posted on: 17/12/2025
Description :
- Manage and maintain MS SQL Server, MySQL, and Azure SQL Managed Instance environments (production, UAT, and development).
- Install, configure, patch, and upgrade database servers and tools.
- Implement and manage database backup and recovery strategies (native backups, BCP,
export/import utilities, and automated backup jobs).
- Ensure databases are highly available, secure, and performant.
- Regularly perform health checks, index optimization, statistics updates, and space management.
Performance Monitoring & Troubleshooting :
- Monitor database performance using tools such as SQL Profiler, Azure Monitor, SSMS
Performance Dashboard, SolarWinds, Redgate SQL Monitor, Nagios, or similar.
- Identify and resolve performance bottlenecks, blocking/deadlock issues, and slow-running
queries.
- Perform root cause analysis (RCA) for database outages or performance issues and
implement preventive measures.
Development & Query Optimization :
- Write and optimize T-SQL queries, stored procedures, functions, views, and triggers.
- Collaborate with developers to ensure efficient database design and query performance
tuning.
- Support deployment of scripts and changes across environments following best practices.
Security & Compliance :
- Manage database users, roles, and permissions in alignment with company security policies.
Automation & Documentation :
- Automate routine DBA tasks (e.g., backups, monitoring, alerts,
and maintenance plans).
- Maintain up-to-date documentation for all databases, configurations, procedures, and change logs.
- Support disaster recovery planning and testing.
Required Skills & Experience :
- 4+ years of experience as a Database Administrator managing SQL Server and MySQL environments.
Strong expertise in :
- T-SQL (queries, stored procedures, triggers, views)
- Database backup/restore (native, maintenance plans, BCP, logical/physical)
- Performance tuning and query optimization
- SQL Agent Jobs and automation
- Working knowledge of Azure SQL Managed Instance or other cloud-based database services.
- Experience with monitoring and alerting tools (Redgate, SolarWinds DPA, Azure Monitor, etc.).
- Strong understanding of replication, mirroring, Always On Availability Groups, and log
shipping.
- Familiarity with MySQL administration, including replication and backup utilities.
- Ability to diagnose and troubleshoot complex database and performance issues.
Preferred Qualifications :
- Experience with PowerShell or Python scripting for automation.
- Familiarity with DevOps tools and CI/CD pipelines for database deployments.
- Knowledge of Linux/Windows Server administration related to DB operations.
Soft Skills :
- Strong analytical and problem-solving skills.
- Excellent communication and documentation abilities.
- Ability to work under pressure in production environments.
- Collaborative mindset with cross-functional teams (Developers, DevOps, Infrastructure).
Did you find something suspicious?
Posted by
Truetech Solutions Private Limited
Employee at Truetech Solutions Private Limited
Last Active: 18 Dec 2025
Posted in
Others
Functional Area
Database Admin / Development
Job Code
1591271
Interview Questions for you
View All