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 databasesMonitor database performance and identify areas of improvementTerminate high-cost or problematic queriesCommunicate and follow up with users executing resource-intensive operationsOptimize overall performance and query efficiencyRestore tables and perform recovery tasks as requiredGuide users and enforce best practices (naming conventions, query standards, etc.)Provide ad hoc support to users across the platformCollaborate with teams managing Alteryx and Fabric platformsContribute to the development and implementation of an upgraded governance modelAssist in the transition and decommissioning of the current database once the new solution is deployed