Database Administrator

**
* This job opportunity is not in the classified service and is not covered by the West Virginia Division of Personnel merit system.***

Position Title: Database Administrator 1

County/Counties Vacancy Covers: Kanawha

Work Location: Kanawha County, WV

We welcome you to join our WV Office of Technology team where we value work/life balance. We offer a great benefits package that includes paid holidays, insurance and flexible benefits, and ample annual and sick leave accrual. Various training opportunities are provided for our employees.

The location of this position will be in the following county: Kanawha

Requirements for this position include but are not limited to:

• A valid driver’s license OR State issued  dependable transportation are required.
• IF APPLICABLE:
  Travel to various State Agencies to perform work and maintain accurate mileage records.
• Regular attendance is an essential part of this position.

• Maintenance
  - Monitor system health, track performance metrics, and configure alerts for critical events. Respond promptly to database-related incidents, investigate root causes, and implement preventive measures.
• Optimization
  - Conduct performance tuning and optimization. Analyze complex queries and execution plans to maintain indices for optimal performance.
• Recovery
  - Implement established backup and disaster recovery strategies. Execute migration plans with minimal downtime and validate data integrity afterward.
• Automation
  - Develop and maintain T-SQL and Power Shell scripts to automate routine tasks such as backups, index maintenance, and database monitoring.
• Integration & Analytics
  - Use tools like SQL Server Integration Services, Azure Data Factories, Kingsway Soft, and Biztalk to migrate and transform data through complex ETL. Provide analytics on system health and growth capacity, and use tools like SSRS, Power BI, and Google Looker Studio for internal and customer reporting.
• Development
  - Develop and ensure the proper functioning of databases, data-driven applications, and reports. This includes building database schemas, tables, procedures, and permission sets. The role also involves aiding in development of complex business applications using ASP.NET, Adobe Cold Fusion, or Power Platform on a project team.
• Performs other duties as assigned.

As a condition of employment, an inquiry into job-related information will be completed which may include, but not limited to, criminal records, abuse registry records, driving records, employment history, and education and training. Failing to cooperate with this process, providing false or incomplete information, and/or discovery of disqualifying information may result in denial of or dismissal from employment or denial of transfer irrespective of when discovered.

Training: Successful completion of an Associate Degree in computer science or related field from an accredited college, university or business school.

Substitution: Two years of experience as a Database Administrator for Universal DB2, ORACLE, INFORMIX, SQL Server, SYBASE or any other multi-user database management system on mainframe, mini, or client/server platforms may substitute for the required training.

Experience: Two years of full-time or equivalent part-time paid experience in database administration and management work, with Universal DB2, ORACLE, INFORMIX, SQL Server, SYBASE or any other multi-user database management on mainframe, mini, or client/server platforms OR four years of full-time or equivalent part-time paid experience in programming and analysis work using any of a variety of programming languages, including two years of SQL experience and a variety of data storage techniques.

Substitution: Bachelor's degree from an accredited college or university in computer science or related field may be substituted for the required training and the two years of experience.