Job Description

Salt Lake County…A career with a purpose in the community you love!

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.

What it is like to work here:

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.

Surround yourself with:

Peers who are motivated to make a difference in the lives of those we serve. We serve Salt Lake County and envision a safe and beautiful place for all to live work and have fun. Salt Lake County is about connecting people and championing our community.  Community is more than a place….its our heart and service that bring us together.

We encourage a work life balance:

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.

Additional Benefits may include:

• 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
• Plus: Onsite medical clinic, childcare and gym; hospital insurance, pet insurance auto and home insurance and discounts at County facilities.

 

For Benefits information Click HERE 

 

JOB SUMMARY

 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.

MINIMUM QUALIFICATIONS

Bachelor’s degree from an accredited college or university in Information Technology, or other closely related field, plus four (4) years of related experience.; Or an equivalent combination of eight (8) years of related education and experience.

 

PREFERRED CERTIFICATIONS: MCDBA, MTA(Data), MCSA(Data), MCSE(data)

ESSENTIAL FUNCTIONS

• Manages the set up and configuration of partitioned tables and partitioned views; create indexed views
• Implement 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; optimize Extended Event session settings, use Activity Monitor to minimize server impact and determine IO bottlenecks, monitor In-Memory OLTP resources
• Modify scripts that use cursors and loops into a SET-based operation, design deterministic and non- deterministic functions
• Collects and reads execution plans, create an index based on an execution plan, batch or split implicit transactions, split large queries, consolidate smaller queries, review and optimize parallel plans
• Develops and maintains procedures and strategies to utilize the right lock mechanism for a given task; handle deadlocks; design index locking properties; fix locking and blocking issues; analyze a deadlock scenario; design appropriate isolation level, including Microsoft ActiveX data objects defaults; design for locks and lock escalation; design transactions that minimize locking; reduce locking contention; identify bottlenecks in data design; design appropriate concurrency control, such as pessimistic or optimistic
• Implements the proper data types and can select appropriate data types, including BLOBs, GUIDs, XML, and spatial data; develop a Common Language Runtime (CLR) data type; impleme