Database Administrator II - SALT LAKE CITY, Utah, United States

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

Job description

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.  We work in a hybrid environment giving you flexibility to manage working from home and being in office.

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

JOB SUMMARY

Uses, maintains, and develops databases within a wide range of public, private, and enterprise databases. Designs, implements and maintains all functions of database systems while maintaining database policies and procedures, data integrity, data extraction, report customization, and analysis.

MINIMUM QUALIFICATIONS

Bachelor's degree from an accredited college or university in Information Technology, or other closely related field, plus two (2) years of related experience; OR an equivalent combination of six (6) years of related education and experience.

FOR DATABASE POSITIONS IN INFORMATION TECHNOLOGY PREFERRED CERTIFICATIONS: MCDBA, MTA (Data), MCSA (Data), MCSE (Data).

Due to the nature of this position, the successful applicant must pass a required background check through fingerprinting and enrollment in the continuous RAP Back (Record of Arrest and Prosecution Back) program in accordance with current County Human Resources policy requirements.

ESSENTIAL FUNCTIONS

• Creates databases, configures and manages system database files.
• Identifies available space on data volumes and identifies the cause of performance degradation.
• Resolves backup/restore incidents.
• Identifies problematic execution plans.
• Monitors current sessions, identifies sessions that cause blocking activity, identifies sessions that consume resources, and configures the data collector.
• Configures an audit on SQL Server, queries the SQL Server audit log, and manages a SQL Server audit.
• Creates an availability group, configures read-only routing, manages failover, and creates distributed availability groups.
• Configures database performance settings, configures max server memory, configures the database scope, and configures operators and alerts.
• Deploys Cloud SQL Database and creates databases and resources in the cloud.
• Works with user accounts and roles and secures database objects.
• Manages database object permissions, creates and maintains users, creates and maintains custom roles, and configures dynamic data masking.
• Implements database consistency checks, identifies database corruption, and recovers from database corruption.
• Assists with planning an IaaS or on-premises deployment, selecting the appropriate size for virtual machines, planning storage pools based on performance requirements, helps evaluate best practices for installation, and assists in the design of storage layout for SQL Server virtual machines.
• Manages deployments that support multiple tenants.
• Identifies and repairs index fragmentation, identifies and creates missing indexes, identifies and drops underutilized indexes, and manages existing column store indexes.
• Supports the migration of databases from one environment to another.
• Configures and monitors log shipping.
• Under supervision and direction, acts as a backup to assist with very large databases when needed, configures alerting for failed backups, manages the process to back up database operating systems, manages transaction log backups, configures database recovery models, and configures backup automation.
• Creates and manages operators, creates and manages SQL Agent alerts, defines custom alert actions, defines failure actions, configures database mail, and Policy-Based Management.
• Configures and manages cell-level encryption, implements Always Encrypted, implements backup encryption, configures transparent data encryption, configures encryption for connections, and troubleshoots encryption errors.
• Manages the Query Store, configures Extended Events, and trace events.
• Identifies and corrects outdated statistics, implements Auto Update Statistics, implements statistics for large tables
• Uses knowledge and understanding of SharePoint database structure, administration, optimization, and querying of content data to perform data optimizations. Fixes, and addresses SharePoint-identified database health concerns.

KNOWLEDGE, SKILLS AND ABILITIES (KSA)

Knowledge of: 

• Multiple databases and dashboards
• Microsoft Office products
• SQL programming language, with the ability to create SQL queries, stored procedures, and functions
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues
• Backups, restores, recovery models, database storage operations, clustering, mirroring, and replication

Skills and Abilities to:

• Communicate effectively both verbally and in writing
• Manage multiple projects simultaneously with a high degree of accuracy and attention to detail
• Think logically and systematically; solve complex problems; effectively apply general principles to specific conditions
• Facilitate projects and meetings as assigned, comfortable working with all levels of the organization
• Analyze business and technical processes and determine ways of making them more efficient
• Remain calm under stress and can quickly adjust, evolve, and multitask between several competing priorities at once
• Maintain confidentiality and professionalism

Due to the nature of this position, the successful applicant must pass a required background check through fingerprinting and enrollment in the continuous RAP Back (Record of Arrest and Prosecution Back) program in accordance with current County Human Resources policy requirements.