Database Administrator II or III

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, Web Logic, BI, Web Center) to other solutions like PostgreSQL; and off-loading current on-premises workloads to leverage cloud computing resources.

• 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.

• 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.

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

• 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…