Database Administrator

Description: 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 :

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 :

- 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.