Description

You will own the full lifecycle of database administration, ensuring integrity, performance, and security for the Treasurer’s Office systems.

This role is on-site.

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.
• 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