SQL DBA

Responsibilities:

• Administer, maintain, and support Microsoft SQL Server databases
• Implement and manage high availability solutions including Database Mirroring, Always-On Availability Groups, and clustering
• Perform database migrations and upgrades (side-by-side and in-place) from lower to higher versions
• Monitor and maintain database performance, including query tuning and optimization
• Manage and troubleshoot replication, log shipping, blocking, and deadlock issues
• Handle large database environments including disaster recovery, backup, and restore operations
• Automate regular maintenance tasks using Windows PowerShell scripting
• Perform file and filegroup management, database file movement, and capacity planning
• Design and manage database backup and recovery strategies using DDBoost or equivalent tools
• Utilize SSIS and SSRS for data integration and reporting (preferred)
• Use tools like BMC Remedy and JIRA for incident and task management
• Perform server builds and SQL Server installations
• Proactively provide alternative solutions and escalate issues when required
• Work independently to manage and drive database-related activities and tasks

Requirements:

• Strong proficiency in SQL Server (20082019) administration
• Proven experience in high availability and disaster recovery setups
• Advanced knowledge in SQL scripting, performance tuning, and troubleshooting
• Experience with backup tools such as DDBoost
• Familiarity with PowerShell scripting for automation (preferred)
• Excellent problem-solving, communication, and analytical skills
• Capable of handling large-scale databases and working independently