Clark Planetarium · 2 months ago
Database Administrator II
US-UT-SALT LAKE CITY
Full-time
Hybrid
Entry, Mid Level
$78K/yr - $117K/yr
2+ years expClark Planetarium is part of Salt Lake County and invites individuals to explore exciting career opportunities. The Database Administrator II role involves maintaining and developing databases, ensuring data integrity, and managing database systems while providing support for various database functions.
Museums & Institutions
Responsibilities
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
Qualification
Required
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
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
Knowledge of multiple databases and dashboards
Knowledge of Microsoft Office products
Knowledge of SQL programming language, with the ability to create SQL queries, stored procedures, and functions
Knowledge of troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues
Knowledge of backups, restores, recovery models, database storage operations, clustering, mirroring, and replication
Skills and Abilities to communicate effectively both verbally and in writing
Skills and Abilities to manage multiple projects simultaneously with a high degree of accuracy and attention to detail
Skills and Abilities to think logically and systematically; solve complex problems; effectively apply general principles to specific conditions
Skills and Abilities to facilitate projects and meetings as assigned, comfortable working with all levels of the organization
Skills and Abilities to analyze business and technical processes and determine ways of making them more efficient
Skills and Abilities to remain calm under stress and can quickly adjust, evolve, and multitask between several competing priorities at once
Skills and Abilities to maintain confidentiality and professionalism
Preferred
MCDBA, MTA (Data), MCSA (Data), MCSE (Data)
Benefits
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.
Company
Clark Planetarium
See what's out there! 🪐 We're open DAILY with three floors of FREE exhibits to explore! Follow for more info on space, our hours, events & more.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase