Database Administrator III

Salt Lake County - Salt Lake City, UT

Full-time - Mid Level

Salt Lake City, UT

Executive, Legislative, and Other General Government Support

About the position

The Database Administrator (DBA) position involves the management, maintenance, and development of various databases for Salt Lake County and Information Technology. The role requires designing, implementing, and maintaining database systems while ensuring data integrity and compliance with policies. The DBA will act as a subject matter expert, assisting other DBAs with complex issues and optimizing database performance.

Responsibilities

• Manage the setup and configuration of partitioned tables and views.
• Implement deterministic and non-deterministic functions, including CROSS APPLY using UDFs.
• Monitor database performance and optimize settings using Dynamic Management Views and Extended Events.
• Modify scripts to enhance performance and optimize execution plans.
• Develop strategies for managing transactions and ensuring data integrity.
• Create and maintain stored procedures and programmatic objects using T-SQL and CLR.
• Design and implement appropriate indexing strategies for various workloads.
• Analyze and optimize database queries and performance issues.
• Implement data control language statements and manage database security roles.
• Design and enforce data integrity policies and constraints.

Requirements

• Bachelor's degree in Information Technology or a closely related field.
• Four years of related experience, or an equivalent combination of eight years of education and experience.
• Knowledge of multiple databases, specifically Microsoft SQL, Oracle, Informix, and DB2.
• Proficiency in SQL programming language, including creating queries, stored procedures, and functions.
• Experience with database integrity troubleshooting and performance optimization.

Nice-to-haves

• Certifications such as MCDBA, MTA(Data), MCSA(Data), MCSE(Data).

Benefits

• Health insurance
• Paid holidays
• Flexible scheduling
• Professional development opportunities