Database Administrator II or III

St Johns River Water Management District; Palatka (FL); On-site; USD 67,000 - 88,000; Full time

Benefits offered by this job

Health insurance

Retirement benefits

Paid time off

Job summary

St Johns River Water Management District is seeking a Database Administrator II or III to design, develop, implement and maintain district-wide database environments. You will support modernization efforts including migrating from Oracle to PostgreSQL and off-loading workloads to cloud resources.

The role serves as a lead technical resource, collaborating with developers and stakeholders to translate data needs into scalable solutions.

Qualifications

• Bachelor's degree in computer science or MIS and 3 years of DBA experience with PostgreSQL, Oracle, SQL Server, or MySQL; 2 years experience with Linux/UNIX.
• Two-year degree + 5 years DBA experience with PostgreSQL, Oracle, SQL Server, or MySQL; 2 years with Linux/UNIX.
• Advanced degree may substitute for some experience; professional DBA experience may substitute for education.

Responsibilities

• Install, configure, and maintain database engines, servers, and related software; optimize performance.
• Monitor database performance and SQL query efficiency; diagnose and resolve data issues.
• Manage user access controls and security per standards.
• Collaborate with developers and stakeholders to translate data needs into technical solutions.
• Develop backup and recovery procedures and support business continuity.

Skills

SQL

Oracle DBA

WebLogic

Education

Bachelor's degree in Computer Science or MIS

2-year technical degree + 5 years in DBA

Tools

PostgreSQL

Linux/UNIX

Oracle Database

Job description

Database Administrator II or III,Office of Information Technology

The St. Johns River Water Management District is an environmental agency whose work is focused on ensuring a long-term supply of drinking water, and to protect and restore the health of water bodies in the District’s 18 counties in northeast and east-central Florida. The Office of Information Technology is responsible for developing and managing technology solutions which support the District ’s missions of water quality, water supply, flood protection, and natural systems .

Enjoy work-life balance in a professional culture with competitive pay and benefits.

Job Summary: This is professional work participating in the design, development, implementation, and maintenance of District-wide database environments. This position will be directly involved in supporting a number of technology initiatives including the modernization of legacy in-house developed applications; refreshing data query, analytics, and reporting; migrating from Oracle products (Database, WebLogic, BI, WebCenter) to other solutions like PostgreSQL; and off-loading current on-premises workloads to leverage cloud computing resources.

Job duties include:

• Installs, configures, and maintains database engines, application servers, and related core technology software. Configures operating systems and software for optimal performance. Develops software programs for data loading and extraction processes . Implements new database application structures and make modifications to existing structures.
• Monitors performance of databases and related systems. Develops and implements recommendations for improvement. Analyzes database query performance and optimize SQL statements. Diagnoses and resolves database-related errors and provides support for end users and developers facing data issues.
• Defines, develops, and implements user access control standards for databases. Provision of user accounts and permissions according to established access control standards and guidelines.
• Participates in the selection of data structure modifications to address data distribution changes to ensure optimal database performance. Serves as a lead technical resource for database projects, assisting as needed in all phases of project s from design and programming to operation and maintenance. Collaborate s with developers to design new and modify existing database applications. Collaborate s with customers and stakeholders to understand data needs and translate them into technical solutions.
• Reviews proposed database applications to ensure compliance with established database or software standards. Develops and tests database backup and recovery procedures and ensures compliance with business continuity standards. Assesses and implements new technologies in support of the Agency's program goals and objectives. Implements technology solutions following established standards for business continuity, change management, software development, and documentation.

Knowledge Of:

• Relational database concepts; computer programming; practical business experience in designing and implementing applications and systems; performance tuning for relational database client/server applications; application development methodologies; structured analysis techniques; data modeling; data repository tools ; project management tools and methodologies.

Skilled In:

• Structured Query Language (SQL)
• Oracle Database administration; related tools and technologies including WebLogic

Ability To:

• Document and clearly communicate through written and verbal skills; exhibit and maintain professional interpersonal skills with all levels of District staff ; lead technology projects from conception to completion; serve as a technical resource for peers by providing guidance and support.

Preferred Experience:

• RedHat or Rocky Linux
• Virtualization platforms such as Linux KVM, VMware, or Nutanix
• Docker container technology
• Python programming
• Qlik Cloud

Minimum Qualifications:

Database Administrator II requires a bachelor's degree from an accredited college or university in computer science or management information systems and three (3) years of experience in database administration of at least one of the following: PostgreSQL, Oracle Database, Microsoft SQL Server, or MySQL and two (2) years experience with any variant of Linux or UNIX operating system (experience may overlap).

Or completion of a two-year program of study from a vocational/technical school or community college in computer science or management information systems and five (5) years of experience in database administration of at least one of the following: PostgreSQL, Oracle Database, Microsoft SQL Server, or MySQL and two (2) years experience with any variant of Linux or UNIX operating system (experience may overlap).

An advanced degree in computer science or management of information systems may substitute for a portion of the required experience.

Professional experience in database administration may substitute on a year-for-year basis for the required college education.

Database Administrator III requires a bachelor's degree from an accredited college or university in computer science or management information systems and four (4) years of experience in database administration of at least one of the following: PostgreSQL, Oracle Database, Microsoft SQL Server, or MySQL; including one year experience performing the physical design and implementation of a large multi-user relational database and three (3) years of experience with any variant of Linux or UNIX operating system (experience may overlap).

Or completion of a two-year program of study from a vocational/technical school or community college in computer science or management information systems and six (6) years of experience in database administration of at least one of the following: PostgreSQL, Oracle Database, Microsoft SQL Server, or MySQL; including one year experience performing the physical design and implementation of a large multi-user relational database and three (3) years of experience with any variant of Linux or UNIX operating system (experience may overlap).

An advanced degree in computer science or management of information systems may substitute for a portion of the required experience.

Professional experience in database administration may substitute on a year-for-year basis for the required college education.

Physical Requirements/Working Environment:

General office environment; some travel (occasional weekend and evening work), hours worked over 40 in a single week earn comp time.

Licenses:

Valid State of Florida Driver’s License.

Starting Salary Range:

Database Administrator II: $67,496.00 - $87,734.40

Database Administrator III: $77,272.00 - $100,443.20

Starting salary is based on qualifications and experience.

Benefits include Florida Retirement System, paid parental leave, health insurance, dental insurance, life insurance, long-term disability, paid leave and holidays, professional development, wellness program, and eligible for public service student loan forgiveness program.

Your application will receive careful consideration and, if selected for an interview, you will be contacted to schedule an appointment.

Certain service members and veterans, and the spouses and family members of such service members and veterans will receive preference in employment and are encouraged to apply.

St. Johns River Water Management District participates in E-Verify. E-Verify is an internet-based system that allows businesses to determine the eligibility of their employees to work in the United States.

Equal Employment Opportunity/Veterans’ Preference/Drug-Free and Tobacco-Free Workplace