IT Statewide Associate Engineer 1-4 (Dco/Ots)

State of Louisiana•Baton Rouge, LA

12h

About The Position

The Division of Administration, Office of Technology Services (OTS), has a vacancy in its Data Center Operations Section. The role provides technical leadership and support for complex database systems serving multiple state agencies and critical business applications. It requires specialized database-platform skills and an in-depth understanding of database planning, design, analysis, and the people, processes, and technology of a large enterprise and government environment. The position may coordinate with vendors on in-house and outsourced database initiatives. The incumbent administers database platforms across on-premises, virtualized, and cloud environments, and supports database availability, performance, security, backup and recovery, high availability, and disaster recovery. The role provides Tier 2 and Tier 3 technical support, contributes to database projects and implementations, develops operational documentation, and works with application, infrastructure, network, security, cloud, vendor, and technical teams. The position may be filled at Associate Engineer level 1, 2, 3, or 4, depending on the selected applicant’s experience. The appointment is limited to promotion of a current permanent-status OTS employee.

Requirements

Two years of experience in information technology; or six years of full-time work experience in any field; or an associate's degree in information technology; or a bachelor’s degree.
Every 30 semester hours from an accredited college or university may substitute for one year of the six-year general work-experience requirement, up to 120 semester hours (four years).
An approved-area certification may substitute for education and/or experience requirements at hire or promotion if the appointment is made from a Certificate of Eligibles.
Any college credits or degree used to meet qualifications must be from an accredited college or university.
The vacancy is being filled by promotion of a current permanent-status Office of Technology Services employee.
A permanent-status employee may be required to serve a new probationary period in lieu of promotion.

Responsibilities

Administer, maintain, and support database systems serving multiple state agencies and critical business applications.
Install, configure, upgrade, patch, monitor, and maintain database platforms in on-premises, virtualized, and cloud environments.
Perform database backup and recovery, performance monitoring and tuning, capacity management, security configuration, and high-availability and disaster-recovery support.
Coordinate database maintenance activities, including after-hours work when required to meet business availability requirements.
Troubleshoot database software and configuration issues with vendors and internal technical teams, and implement appropriate solutions.
Provide technical support and guidance to application developers, system administrators, technical support personnel, and end users on database configuration, performance, connectivity, availability, and functionality.
Develop and maintain technical documentation, procedures, configuration standards, and operational runbooks.
Determine and resolve database-related incidents and service requests; provide Tier 2 and Tier 3 support according to issue complexity and established procedures.
Investigate availability, performance, connectivity, backup and recovery, security, and application-related issues using database monitoring, diagnostic, logging, and performance-analysis tools.
Coordinate with application, infrastructure, network, security, cloud, and vendor teams to troubleshoot issues and identify root causes; document resolutions and follow up as needed.
Provide database administration and technical support for assigned projects and initiatives.
Participate in the design, implementation, testing, deployment, and maintenance of database solutions, including installations, upgrades, migrations, high-availability configurations, disaster-recovery solutions, and cloud database implementations.
Assist with evaluating and implementing database tools and technologies.
Use scripting and automation to improve routine database administration tasks and operational efficiency.
Work with senior database administrators and other technical teams on complex projects and technical issues.
Participate in knowledge-sharing and training, and develop familiarity with database technologies, cloud services, automation, security practices, and enterprise database standards.
Provide technical advice and assistance on database administration, capacity planning, performance, availability, security, backup and recovery, and emerging technologies.
Assist with technology evaluations, product research, and technical planning.
Keep current with database technology, cloud services, automation tools, security practices, vendor recommendations, technical documentation, and relevant industry trends.
Perform other duties as assigned to provide reliable, secure, and effective database services.