Database Administrator II or III

St. Johns River Water Management District•Palatka, FL

38d•$68,848 - $102,461•Onsite

About The Position

The St. Johns River Water Management District’s Office of Information Technology seeks a Database Administrator II or III to participate in the design, development, implementation, and maintenance of District-wide database environments. The role supports technology initiatives including modernization of legacy in-house applications; improvements to data query, analytics, and reporting; migration from Oracle products such as Database, WebLogic, BI, and WebCenter to other solutions such as PostgreSQL; and moving on-premises workloads to cloud computing resources. The position installs, configures, and maintains database engines, application servers, and related core technology software; configures operating systems and software for performance; and develops data-loading and extraction programs. It monitors and tunes database performance, resolves database issues, manages user access, supports database projects and applications, and collaborates with developers, customers, and stakeholders. It also reviews application proposals for standards compliance, develops and tests backup and recovery procedures, assesses new technologies, and implements solutions under established operational and documentation standards. The position is based in Palatka, Florida, in a general office environment, with some travel and occasional evening or weekend work. Hours worked over 40 in a single week earn compensatory time. Starting salary ranges are $68,848.00–$89,502.40 for Database Administrator II and $78,832.00–$102,460.80 for Database Administrator III; starting salary is based on qualifications and experience. A valid Florida driver’s license is required.

Requirements

Database Administrator II: Bachelor’s degree from an accredited college or university in computer science or management information systems, three years of database-administration experience with PostgreSQL, Oracle Database, Microsoft SQL Server, or MySQL, and two years of experience with a Linux or UNIX operating-system variant; experience may overlap.
Database Administrator II alternative: Completion of a two-year vocational/technical school or community-college program in computer science or management information systems, five years of database-administration experience with PostgreSQL, Oracle Database, Microsoft SQL Server, or MySQL, and two years of experience with a Linux or UNIX operating-system variant; experience may overlap.
Database Administrator III: Bachelor’s degree from an accredited college or university in computer science or management information systems, four years of database-administration experience with PostgreSQL, Oracle Database, Microsoft SQL Server, or MySQL, including one year performing physical design and implementation of a large multi-user relational database, and three years of experience with a Linux or UNIX operating-system variant; experience may overlap.
Database Administrator III alternative: Completion of a two-year vocational/technical school or community-college program in computer science or management information systems, six years of database-administration experience with PostgreSQL, Oracle Database, Microsoft SQL Server, or MySQL, including one year performing physical design and implementation of a large multi-user relational database, and three years of experience with a Linux or UNIX operating-system variant; experience may overlap.
An advanced degree in computer science or management information systems may substitute for a portion of the required experience.
Professional database-administration experience may substitute year-for-year for required college education.
Knowledge of relational database concepts, computer programming, application and systems design and implementation, performance tuning for relational database client/server applications, application-development methodologies, structured analysis techniques, data modeling, data-repository tools, and project-management tools and methodologies.
Skill in SQL, PostgreSQL administration, Oracle Database administration and related tools and technologies including WebLogic, Microsoft SQL Server administration, Linux, and Microsoft Windows.
Ability to document and communicate clearly in writing and verbally; maintain professional interpersonal skills with all levels of District staff; lead technology projects from conception to completion; and provide technical guidance and support to peers.
Valid State of Florida driver’s license.

Nice To Haves

Experience with RedHat or Rocky Linux.
PostgreSQL administration experience.
Experience with virtualization platforms such as Linux KVM, VMware, or Nutanix.
Docker container technology experience.
Python programming experience.
Experience with Oracle technology products.
Qlik Cloud experience.

Responsibilities

Install, configure, and maintain database engines, application servers, and related core technology software.
Configure operating systems and software for optimal performance.
Develop software programs for data-loading and extraction processes.
Implement new database application structures and modify existing structures.
Monitor database and related-system performance; recommend and implement improvements.
Analyze database query performance and optimize SQL statements.
Diagnose and resolve database-related errors and support end users and developers facing data issues.
Define, develop, and implement database user-access control standards, and provision accounts and permissions according to established guidelines.
Participate in selecting data-structure modifications to address changes in data distribution and maintain optimal performance.
Serve as a lead technical resource on database projects, assisting across design, programming, operation, and maintenance.
Collaborate with developers to design new database applications and modify existing ones.
Collaborate with customers and stakeholders to understand data needs and translate them into technical solutions.
Review proposed database applications for compliance with database and software standards.
Develop and test database backup and recovery procedures and ensure compliance with business continuity standards.
Assess and implement new technologies in support of agency program goals and objectives.
Implement technology solutions in accordance with standards for business continuity, change management, software development, and documentation.