Description

Manage the integrity, performance, and security of database systems for the Treasurer’s Office. You will own the full lifecycle of database administration, from design and implementation to monitoring and optimization.

Responsibilities

• Design and implement database structures to meet organizational requirements.
• Monitor database environments to minimize downtime and ensure optimal efficiency.
• Define users and roles to enforce security policies and manage data access.
• Develop and maintain complex SQL scripts, stored procedures, and functions.
• Maintain complex replication setups and Always-On availability clusters.

Required Skills

• 5+ years of experience in Database Administration.
• Expertise in SQL Server administration, including backup, recovery, and security.
• Experience managing MS SQL replication and Availability Groups.
• Proficiency in T-SQL, including writing queries, stored procedures, and functions.
• Proven ability in database performance tuning.
• Experience working with development teams to facilitate data access.
• Background in database design and development using MS SQL.
• Bachelor’s degree in Information Technology, Computer Science, or equivalent.
• Ability to complete SQL Server 2019 Developer and Database Administrator assessments.

Preferred Skills

• Automation of repeatable tasks using PowerShell.
• Advanced ETL and SSIS package design and development.
• Reporting and dashboard development using SSRS, SSAS, and Power BI.

Key Skills

Education

Any Graduate