Database Administrator III

UNAVAILABLE - Salt Lake City, UT

Full-time - Mid Level

Salt Lake City, UT

About the position

The Database Administrator (DBA) position is responsible for the design, implementation, and maintenance of database systems across various platforms, ensuring data integrity and optimal performance. The role involves acting as a subject matter expert, assisting other DBAs with complex issues, and managing the setup and configuration of database systems while adhering to established policies and procedures.

Responsibilities

• Manage the setup and configuration of partitioned tables and views.
• Implement deterministic and non-deterministic functions, including CLR functions.
• Monitor database performance and optimize settings using Dynamic Management Views and Activity Monitor.
• Modify scripts to enhance performance and reduce locking contention.
• Develop and maintain strategies for data integrity and transaction management.
• Create and optimize stored procedures and programmatic objects using T-SQL and CLR.
• Design and implement appropriate indexing strategies for various workloads.
• Analyze execution plans and optimize queries for performance.
• 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.
• Proficiency in SQL programming language and experience with multiple databases, including Microsoft SQL, Oracle, Informix, and DB2.

Nice-to-haves

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

Benefits

• Health insurance
• 401k retirement plan
• Paid holidays
• Professional development opportunities