Database Administrator 2

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.

Do you have a valid Driver’s License license?, Do you have experience in User training (technical support)?, Do you have a Associate’s degree?, 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.

Pulled from the full job description

• Paid holidays