Database Administrator Ii - Library

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 SERVICES

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

Due to the nature of this position, the successful applicant must pass a required pre-employment background check and subsequent mandatory background checks in accordance with current County Human Resources policy requirements.

Health Department only:

It is mandatory that all new hires receive the Tdap (Tetanus, Diphtheria, and Acellular Pertussis) vaccine before beginning employment or provide a copy of their immunization record prior to starting employment. The immunization record must show the vaccine name and date received. Upon hire, a two-step Tuberculosis skin test will be required. The first will need to be placed prior to starting employment.

ESSENTIAL FUNCTIONS

• Creates databases, configures, and manages system database files.
• Identifies available space on data volumes, 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, configures operators and alerts.
• Deploys cloud SQL Database, creates databases and resources in cloud.
• Works with user accounts and roles, 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 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 log shipping, 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, configures backup automation.

This position will work part-time, 30 hours per week.