The department is seeking an experienced Senior SQL Server Database Administrator to enable the delivery of the Commissions objectives and outcomes by undertaking the design, implementation, and operational support of database services infrastructure.
The role will be responsible for, but not limited to:
1. Delivering solutions and support for our evolving database environment which consists of SQL Server systems hosted on-prem, in the Azure Cloud, and in some legacy Linux hosted data platforms.
2. Overseeing compliance and health of the database fleet.
3. Driving database automation initiatives for repeatable requirements.
4. Developing service capabilities in the Azure cloud.
Mandatory:
1. Recent experience in operating and supporting SQL Server clustered implementations and Azure SQL Managed Instance systems.
2. Skilled Senior SQL Server DBA with a passion for data, automation, and designing robust, reliable systems.
3. Demonstrated experience in writing complex stored procedures and scripts with Microsoft SQL Server T-SQL.
4. Ability to performance tune, troubleshoot, and optimize SQL Server code for poor running queries.
5. Experience in standardization of database objects, design, naming, and documentation of databases and data dictionary including source of truth and data lineage.
6. Experience in Relational Database concepts, primarily based on Microsoft SQL Server 2017-2022.
7. Ability to design, build, maintain, and decommission database systems.
8. Management and maintenance of SQL Server HA and DR including Clustering, Availability Groups, Replication, and backup recovery.
9. Demonstrated knowledge and experience with On-Premise, Virtual, and cloud SQL offerings.
10. Data modeling and management.
11. Data visualization products including PowerBI.
12. Experience of other RDBMS products, for example, Postgres, Ingres, MySQL, Cosmos DB.
13. Experience working in Linux environments.
14. Ability to work with geographically dispersed teams.
15. Ability to work with technical and non-technical staff at all levels.
16. Ability to collaborate and mentor team members to promote team harmony.
#J-18808-Ljbffr