Role- Database Administrator (DBA)
Location : Mohali, Punjab
Shift : 4 pm-1 am
Experience : 5+years
We are seeking an experienced Database Administrator (DBA) to manage, maintain, and optimize all existing database systems — including Microsoft SQL Server , MySQL , and Azure SQL Managed Instances .
The ideal candidate will be responsible for ensuring high availability , performance , security , and data integrity across all database environments.
This role requires deep technical expertise in database administration, T-SQL development, backup / recovery strategies, and monitoring / troubleshooting .
Key Responsibilities
Database Administration & Maintenance
- 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.Ensure data encryption , auditing , and compliance with regulatory standards (e.g., GDPR, HIPAA if applicable).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
5+ 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 optimizationSQL Agent Jobs and automationWorking 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
Microsoft Certified : Azure Database Administrator Associate or SQL Server Database Administrator .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.