IT STATEWIDE ASSOCIATE ENGINEER 1-4 (DCO/OTS)

Nunez Community College; Baton Rouge (LA); On-site; USD 80,000 - 110,000; Full time

Job summary

The Louisiana Division of Administration, Office of Technology Services, seeks a high-level Database Administrator to provide technical leadership in implementing and managing complex database systems across on-premises, virtualized, and cloud environments. You will coordinate with vendors and internal teams, develop runbooks, and guide Tier 2/3 support to ensure availability and security.

Responsibilities include performance tuning, disaster recovery, capacity planning, and documenting

Qualifications

• Two years of experience in information technology.
• An associate's degree in information technology.
• A bachelor’s degree.
• Experience substitution: Every 30 semester hours earned from an accredited college or university will be credited as one year of experience toward the six years of full-time work experience in any area.
• A certification in an approved area may be substituted for the education and/or experience requirements at the time of hire or promotion, provided the appointment is made from a Certificate of Eligibles.
• Any college hours or degree must be from an accredited college or university.

Responsibilities

• Performs day-to-day administration, maintenance, and support of database systems serving multiple state agencies and critical business applications.
• Installs, configures, upgrades, patches, monitors, and maintains database platforms in on-premises, virtualized, and cloud environments.
• Performs database backup and recovery, performance monitoring and tuning, capacity management, security configuration, and high availability and disaster recovery support.
• Coordinates database maintenance activities, including after-hours work when required to meet business availability requirements.
• Works with vendors and internal technical teams to troubleshoot database software and configuration issues and implement appropriate solutions.
• Provides technical support and guidance to application developers, system administrators, technical support personnel, and end users regarding database configuration, performance, connectivity, availability, and functionality.
• Develops and maintains technical documentation, procedures, configuration standards, and operational runbooks.
• Performs problem determination and resolution for database-related incidents and service requests reported by application users and technical staff.
• Provides Tier 2 and Tier 3 technical support based on the complexity of the issue and established support procedures.
• Investigates database availability, performance, connectivity, backup and recovery, security, and application-related issues using database monitoring, diagnostic, logging, and performance analysis tools.
• Coordinates with application, infrastructure, network, security, cloud, and vendor teams to troubleshoot issues and identify root causes. Documents resolutions and follows up with users and technical teams as necessary.
• Provides database administration and technical support for assigned projects and initiatives.
• Participates in the design, implementation, testing, deployment, and maintenance of database solutions, including new database installations, upgrades, migrations, high availability configurations, disaster recovery solutions, and cloud database implementations.
• Assists with evaluating and implementing database tools and technologies.
• Uses scripting and automation to improve routine database administration tasks and operational efficiency.
• Works with senior database administrators and other technical teams on complex projects and technical issues.
• Participates in knowledge-sharing and training activities and develops familiarity with database technologies, cloud services, automation, security practices, and enterprise database standards.
• Provides technical advice and assistance to management, application teams, system administrators, and other technical personnel regarding database administration, capacity planning, performance, availability, security, backup and recovery, and emerging database technologies.
• Assists with technology evaluations, product research, and technical planning activities.
• Keeps current with database technology, cloud services, automation tools, security practices, vendor recommendations, technical documentation, and industry trends relevant to the State's database environment.
• Performs other duties as assigned to provide reliable, secure, and effective database services.

Skills

Database administration

Database design

SQL scripting

Technical leadership

Vendor coordination

Education

Associate's degree in information technology

Bachelor's degree

Job description

The Division of Administration/Office of Technology Services has a vacancy. This position is located in the Data Center Operations Section. Req.227096

The Office of Technology Services aims to be a responsible partner in delivering innovative, effective, and reliable solutions that support and enhance the IT functions within Executive Branch Departments. The Office of Technology Services will work to increase the return on the State's investment in technology by promoting smart decision-making, solving problems intelligently, increasing the rate of project success, and fostering a skilled and professional staff.

This is a high level technical support position requiring the ability to provide technical leadership in the implementation and management of complex database systems. The incumbent will possess advanced, specialized skills in database platforms and software. The nature of the work is highly complex and requires a deep understanding of people, processes and technology within the context of a large enterprise and government environment. The incumbent is required to have in-depth database planning, design, and analysis skills. The incumbent may be required to coordinate and serve as liaison with multiple vendors for in-house and outsourced database related initiatives.

The Division of Administration is the state government’s management arm and the hub of its financial operations. Division offices perform a wide variety of activities including the following:

• Overseeing the state’s capital construction program
• Working to provide state and federal grants for community development
• Development of the state budget
• Providing technology services
• Giving agencies guidance in the state purchasing and contracting process as they seek goods and services
• Administering a program that provides federal funds to help Louisiana residents recover from a series of devastating hurricanes

• Two years of experience in information technology
• Six years of full-time work experience in any field
• An associate's degree in information technology
• A bachelor’s degree
• EXPERIENCE SUBSTITUTION: Every 30 semester hours earned from an accredited college or university will be credited as one year of experience towards the six years of full-time work experience in any area. The maximum substitution allowed is 120 semester hours which substitutes for a maximum of four years of experience in any area.
• NOTE: A certification in an approved area may be substituted for the education and/or experience requirements at the time of hire or promotion, provided the appointment is made from a Certificate of Eligibles.
• NOTE: Any college hours or degree must be from an accredited college or university.

The official job specifications for this role, as defined by the State Civil Service, can be found here.

Job Duties

• Performs day-to-day administration, maintenance, and support of database systems serving multiple state agencies and critical business applications. I
• Installs, configures, upgrades, patches, monitors, and maintains database platforms in on-premises, virtualized, and cloud environments.
• Performs database backup and recovery, performance monitoring and tuning, capacity management, security configuration, and high availability and disaster recovery support.
• Coordinates database maintenance activities, including after-hours work when required to meet business availability requirements.
• Works with vendors and internal technical teams to troubleshoot database software and configuration issues and implement appropriate solutions.
• Provides technical support and guidance to application developers, system administrators, technical support personnel, and end users regarding database configuration, performance, connectivity, availability, and functionality.
• Develops and maintains technical documentation, procedures, configuration standards, and operational runbooks.
• Performs problem determination and resolution for database-related incidents and service requests reported by application users and technical staff.
• Provides Tier 2 and Tier 3 technical support based on the complexity of the issue and established support procedures.
• Investigates database availability, performance, connectivity, backup and recovery, security, and application-related issues using database monitoring, diagnostic, logging, and performance analysis tools.
• Coordinates with application, infrastructure, network, security, cloud, and vendor teams to troubleshoot issues and identify root causes. Documents resolutions and follows up with users and technical teams as necessary.
• Provides database administration and technical support for assigned projects and initiatives.
• Participates in the design, implementation, testing, deployment, and maintenance of database solutions, including new database installations, upgrades, migrations, high availability configurations, disaster recovery solutions, and cloud database implementations.
• Assists with evaluating and implementing database tools and technologies.
• Uses scripting and automation to improve routine database administration tasks and operational efficiency.
• Works with senior database administrators and other technical teams on complex projects and technical issues.
• Participates in knowledge-sharing and training activities and develops familiarity with database technologies, cloud services, automation, security practices, and enterprise database standards.
• Provides technical advice and assistance to management, application teams, system administrators, and other technical personnel regarding database administration, capacity planning, performance, availability, security, backup and recovery, and emerging database technologies.
• Assists with technology evaluations, product research, and technical planning activities.
• Keeps current with database technology, cloud services, automation tools, security practices, vendor recommendations, technical documentation, and industry trends relevant to the State's database environment.
• Performs other duties as assigned to provide reliable, secure, and effective database services.

Position-Specific Details

Appointment Type: This vacancy will be 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.

Career Progression: This position may be filled as an IT Statewide Associate Engineer 1, 2,3 or 4, depending on the level of experience of the selected applicant.

Compensation

Compensation: The Salary range listed on the job posting reflects the pay grade minimum and maximum for the IT Statewide Associate Engineer 1 job title. The salary range pay grade minimum and maximum for the other levels of the career progression group can be viewed using the links below:

• IT Statewide Associate Engineer 2
• IT Statewide Associate Engineer 3
• IT Statewide Associate Engineer 4

Louisiana is a "State as a Model Employer" for People with Disabilities.

No Civil Service test score is required in order to be considered for this vacancy.