Database Administrator -Administration-Office of Technology-Kanawha

Nature of Work

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

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

Job Posting: IS2600009 PSA

Alternate Posting: IS2600010 (Database Administrator
1)

Position Title: Database Administrator 2

Position Number: 0231P0253 and 0231P0129

Vacancies: 2

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

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

• Engineering - Design, implement, and maintain complex SQL Server-based infrastructure and database solutions. This includes setting up new environments and ensuring high availability and scalability.
• 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 - Plan and implement a comprehensive backup and disaster recovery strategy. Execute migration plans with minimal downtime and validate data integrity afterward.
• Governance - Develop procedures, documentation, and training for system management, backup/recovery, and other maintenance tasks. Document and provide knowledge transfer of all current and new SQL Server clusters, instances, and databases to WVOT employees.
• 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 Biz Talk 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.
• Completes other duties as assigned.

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: Four 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 eight years of full-time or equivalent part-time paid experience in programming and analysis work using any of a variety of programming languages, including at least four 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 training and two years of the experience.

• As a condition of employment, an inquiry into job-related information will…