About the position
Salt Lake County invites you to explore our exciting career opportunities. We seek highly enthusiastic individuals to enrich our County with your experience and talent. If you enjoy working in a team environment that is committed to changing the lives of its community, please keep reading. At Salt Lake County our culture is woven into all aspects of our work and our employees' lives, from the way we treat each other to the way we support the community. To promote and foster a fun and healthy work environment, we appreciate employees through great benefits, a healthy work life balance and room to grow and develop. Working for Salt Lake County is more than just a paycheck. A career with Salt Lake County includes several benefits and perks. We support our employees with 12 Holidays, up to 24 vacation days, 12 sick days and one personal day every year. Some positions have a hybrid work environment giving you flexibility to manage working from home and being in office.
Responsibilities
- Uses, maintains and develops databases within a wide range of Salt Lake County and Information Technology, public and private databases.
- Designs, implements and maintains all functions of database systems while maintaining database policies and procedures, data integrity, data extraction, report customization and analysis.
- Acts as subject matter expert and assists other DBA's with complex issues.
- Manages the set up and configuration of partitioned tables and partitioned views; create indexed views.
- Implements deterministic or non-deterministic functions; implement CROSS APPLY by using UDFs; implement CLR functions.
- Monitors performance using Dynamic Management Views, collect output from the Database Engine Tuning Advisor, design Extended Events Sessions, review and interpret Extended Event logs.
- Develops and maintains procedures and strategies to utilize the right lock mechanism for a given task; handle deadlocks.
- Implements the proper data types and can select appropriate data types, including BLOBs, GUIDs, XML, and spatial data.
- Manages transactions; ensures data integrity by using transactions; manages distributed transaction escalations.
- Creates stored procedures and other programmatic objects; implements different types of stored procedure results.
- Develops optimal strategies for clustered indexes; analyzes index usage; optimizes indexes for workload.
- Creates constraints on tables, defines constraints, modifies constraints according to performance implications.
- Develops strategies to maximize concurrency; defines a locking and concurrency strategy.
- Tunes poorly performing queries, including avoiding unnecessary data type conversions.
- Implements data control language statements appropriately, troubleshoots connection issues.
Requirements
- Bachelor's degree from an accredited college or university in Information Technology, or other closely related field.
- Four (4) years of related experience; or an equivalent combination of eight (8) years of related education and experience.
Nice-to-haves
- MCDBA certification
- MTA(Data) certification
- MCSA(Data) certification
- MCSE(data) certification
Benefits
- 12 Holidays
- Up to 24 vacation days
- 12 sick days
- One personal day every year
- Retirement options for hybrid pension/401(k) or 401(k) only with a 10% contribution
- Medical coverage including a 100% county paid premium option
- Dental and Vision coverage including coverage for adult designees
- Health Savings account with a county contribution up to $1200/year
- Flexible Spending Account
- 100% county-paid Long-Term Disability and Short-Term Disability option
- Professional Development including professional membership fees paid
- Tuition Reimbursement
- Onsite medical clinic, childcare and gym
- Hospital insurance, pet insurance, auto and home insurance and discounts at County facilities.
