Senior Database Administrator (MS SQL & AWS RDS) (Remote)

Job Title - Senior Database Administrator (MS SQL & AWS RDS)

Job Type - Remote

Experience - 6+ years

Job Description -

We are seeking an experienced Database Administrator (DBA) to support and maintain our long-standing data platform, ADA (Active Data Archive). ADA has been operational for nearly a decade, and while a new self-service data storage solution is being planned, we require continued support to ensure stability and seamless functioning of the current environment.

Technology Environment

The database platform runs on AWS RDS – MS SQL Server 2019 (v15) and integrates with the broader ADA ecosystem, which includes:

• MS SQL Server
• Alteryx
• Tableau
• Windows File Share

Key Responsibilities

• Manage and process access requests for restricted databases
• Monitor database performance and identify areas of improvement
• Terminate high-cost or problematic queries
• Communicate and follow up with users executing resource-intensive operations
• Optimize overall performance and query efficiency
• Restore tables and perform recovery tasks as required
• Guide users and enforce best practices (naming conventions, query standards, etc.)
• Provide ad hoc support to users across the platform
• Collaborate with teams managing Alteryx and Fabric platforms
• Contribute to the development and implementation of an upgraded governance model
• Assist in the transition and decommissioning of the current database once the new solution is deployed