About this role
Role: Azure SQL DBA / Azure Database Administrator
Client: Carnival Cruise Line
Key Responsibilities
•
Administer and support Azure SQL Managed
Instance, Azure SQL Database, and SQL Server on Azure VMs.
•
Plan and execute database migrations between
Azure SQL MI, Azure SQL Database, Azure VM SQL Server, and on-premises SQL
Server.
•
Manage database backup, restore, recovery,
security, access, storage, capacity, and configuration.
•
Monitor and tune SQL performance using Query
Store, execution plans, DMVs, Extended Events, indexing, statistics, waits,
blocking, and deadlock analysis.
•
Troubleshoot production issues related to
performance, connectivity, TempDB, storage, backups, database availability, and
application/database interactions.
•
Perform Root Cause Analysis (RCA) for
critical production incidents and implement corrective/preventive actions.
•
Develop T-SQL and PowerShell automation for
health checks, maintenance, database refreshes, monitoring, backup validation,
and repetitive DBA activities.
•
Maintain operational procedures, migration
runbooks, technical documentation, database standards, and security controls.
Required Skills
•
Strong hands-on experience with Azure SQL
Managed Instance, Azure VM’s and Azure SQL Database.
•
Strong knowledge of SQL performance tuning,
Query Store, Extended Events, DMVs, indexing, locking/blocking, TempDB, and
execution-plan analysis.
•
Experience with backup/recovery, security,
patching, upgrades, and database maintenance.
•
Experience with Incident, Change, and Problem
Management processes.
•
Strong troubleshooting, communication,
documentation, and stakeholder-management skills.
Support Model
•
24/7 production support for Azure SQL MI,
Azure SQL Database, and SQL Server on Azure VM environments.
•
Approximately two weeks of night shift
support per month.
•
Participation in production incidents, RCA,
change implementation, database migrations, patching, maintenance, deployment
support, and on-call activities.