JOB
***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 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 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 ID and 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.
Job Duties:
-
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 PowerShell 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, KingswaySoft, 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 ColdFusion, 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.
Click The APPLY Link To Apply Online.
