Database Administrator 2-Administration-Office of Technology-Kanawha Co.

Full Job Description

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

Requirements for this position include but are not limited to:

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

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, 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 ColdFusion, or Power Platform on a project team.

• Completes other duties as assigned.

Desired Qualifications: Training: Successful completion of an Associate Degree in computer science or related field from an accredited college, university or business school.
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.
* 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.

* Internal applications should be emailed to madeline.l.fitzwater@wv.gov or mailed to Madeline Fitzwater at 1900 Kanawha Blvd. East Building 5 10th Floor, Charleston, WV 25305. Please include the posting number on your application.

Click The APPLY Link To Apply Online.

INSTRUCTIONS TO APPLICANT:

You must submit an application for each position of interest.

Your complete work history is used to qualify you for positions. Please be as detailed as possible and list all of your past employment in the Work Experience section of your application or you may attach it to your application with a resume.

If you have not previously submitted a copy of your official transcript or diploma, or licensure or training earned, you may attach it to your application or email it to applicantservices@wv.gov

If you have already submitted copies of these documents with other applications, please do not resubmit. You may contact Staffing & Recruitment at 304-414-1852 if you have any questions.

If you would like to be notified of jobs of this nature or in other categories, please complete our Job Interest Card

Additional Information

* Internal applications should be emailed to madeline.l.fitzwater@wv.gov or mailed to Madeline Fitzwater at 1900 Kanawha Blvd. East Building 5 10th Floor, Charleston, WV 25305. Please include the posting number on your application.