WV Departments of Health, Health Facilities, and Human Services · 6 hours ago
Database Administrator 2-Administration-Office of Technology-Kanawha Co.
Kanawha County, WV
Full-time
Onsite
Mid Level
4+ years expThe WV Departments of Human Services is seeking a Database Administrator 2 to join their Office of Technology team. This role involves designing, implementing, and maintaining SQL Server-based infrastructure and database solutions, as well as monitoring system health and optimizing performance.
GovernmentHealth CareInformation ServicesMedical
Responsibilities
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
Qualification
Required
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
Successful completion of an Associate Degree in computer science or related field from an accredited college, university or business school
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
Preferred
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
Benefits
12 paid holidays
Insurance and flexible benefits
Ample annual and sick leave accrual
Various training opportunities
Company
WV Departments of Health, Health Facilities, and Human Services
The mission of the West Virginia Departments of Health, Health Facilities, and Human Services is to collaborate with stakeholders to promote, protect, manage, and provide appropriate health and human services for our residents to improve their health, well-being and quality of life.
5001-10000 employees
H1B Sponsorship
WV Departments of Health, Health Facilities, and Human Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (1)
Funding
Current Stage
Late StageLeadership Team
Jessica Hudson
Chief Operating Officer
Angie Jacobs-Ferris, SHRM-SCP
Chief Human Resources Officer
Company data provided by crunchbase