SQL Database Administrator

Role Overview:

We are looking for an experienced SQL Database Administrator (DBA) to provide 24x7 production support for enterprise database environments. The ideal candidate will be responsible for database administration, monitoring, performance tuning, backup and recovery, incident management, user access administration, and supporting database deployments and migrations. This role requires flexibility to work in rotational shifts and collaborate with L2/L3 support teams to ensure high availability and optimal database performance.

Key Responsibilities:

Database Administration:

• Administer and maintain SQL Server and Azure SQL Database environments.
• Create, modify, and manage database users, roles, and permissions.
• Perform database health checks and ensure database availability.
• Manage database space, storage utilization, and capacity planning.

Monitoring &

• Performance:
• Monitor database performance, availability, and system alerts.
• Investigate and resolve connectivity issues and service failures.
• Identify slow-running queries and perform basic query optimization.
• Monitor CPU, memory, disk usage, and database error logs.
• Support performance tuning and escalate complex issues to L2/L3 teams.

Backup &

• Recovery:
• Monitor scheduled database backups and verify successful completion.
• Support backup validation and recovery processes.
• Assist in disaster recovery and high-availability activities.

Incident &

• Change Management:
• Handle production incidents and service requests within SLA.
• Execute pre-approved SQL scripts for maintenance activities.
• Support database service restarts and failover notifications.
• Coordinate with L2/L3 teams for issue resolution and change implementation.

Security &

• Compliance:
• Manage database user access, password resets, and permission changes.
• Support SOX, HIPAA, and internal audit requests.
• Assist with vulnerability remediation and security patching.
• Ensure compliance with organizational security policies.

Deployment &

• Migration:
• Support database deployment activities for On-Premises and Azure PaaS environments.
• Assist with database migration activities and deployment validation.
• Support Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS) database deployments.

Continuous Improvement:

• Contribute to process improvements and operational automation.
• Maintain knowledge base articles, documentation, and standard operating procedures.
• Recommend improvements for database performance, monitoring, and operational efficiency.