DATA BASE CONSULTANT - 37010324

Florida; Tallahassee (FL); On-site; USD 70,000 - 87,000; Full time

Job summary

The Florida Department of Environmental Protection seeks a Data Base Consultant to provide Oracle database consultation and oversight in Tallahassee, FL. This is an onsite position in Tallahassee, Florida.

Responsibilities include establishing and maintaining Oracle 12c/19c databases, monitoring performance, planning migrations, and ensuring security and reliability within OCI and on‑prem environments. Strong Oracle, Unix, and data‑analysis skills are required.

Qualifications

• 5+ years managing Oracle Enterprise 12c/19c databases.
• 5+ years troubleshooting Oracle DB administration and connection problems.
• 3+ years reviewing physical schema models.
• 3+ years of experience with Oracle EM.
• Knowledge of Oracle RDBMS administration tools and processes.
• Knowledge of Unix commands and concepts.
• Ability to plan and coordinate work assignments.
• Ability to communicate technical information effectively.
• Ability to develop reports from the data dictionary.

Responsibilities

• Establishing and maintaining databases used for development, testing, production, data warehousing, and public access.
• Monitoring database performance and ensuring uptime, security, and integrity.
• Planning and executing database migration/upgrade events.
• Meeting customer needs with excellent service and support.

Skills

Oracle 12c/19c

Oracle troubleshooting

Oracle performance monitoring

Schema modeling

Oracle EM

Unix commands

RDBMS tools

Data analysis

Communication skills

Planning/coordination

Tools

OCI

Oracle Linux

Job description

Select how often (in days) to receive an alert:

The State Personnel System is an E-Verify employer. For more information click on our E-Verify Website.

Requisition No:878881

Working Title: DATA BASE CONSULTANT - 37010324

This is an onsite position in Tallahassee, Florida.

Position Overview and Responsibilities:

D EP’s Office of Technology an d Information Services (OTIS) is currently seeking a Data Base Consultant. This is a technical position that provides Oracle database consultation support and solutions for the Agency. This position is responsible for professional and high-level technical oversight and management for planning, designing, modeling, monitoring, testing, operating, and maintaining database management systems. These database systems are managed in the ORACLE EE Oracle Linux RDBMS environment on-premises and in the DEP Oracle Cloud Infrastructure (OCI) tenancy. Specific duties and responsibilities include:

• Establishing and maintaining databases used for development, testing, production, data warehousing, and public access. Monitoring and reviewing the department’s database systems to ensure efficiency, integrity, and security of operation and to eliminate problems related to hardware, software, and procedural error.
• Recording, tracking, and investigating problems reported by users and keeping management informed of potential trouble areas, taking corrective actions to resolve and mitigate issues.
• Planning and executing database migration/upgrade events to keep databases at the current long-term release level.
• Monitoring database performance across the development, beta, and production services; acting to resolve issues that affect these services to ensure that the maximum possible uptime availability is achieved; performing OS and database patching for the OCI Oracle Base database systems.
• Identifyingand meetingthe needs of customers and providing excellent customer service.
• Perform other duties as assigned.

Attendance is an essential function of this position.

Required Knowledge, Skills, and Abilities:

• 5+ years ofexperience managing Oracle Enterprise version 12c or 19c database instances.
• 5+ years ofexperience troubleshooting Oracle database administration and connection problems.
• 5+ years of experience monitoring Oracle performance metrics
• 3+ years ofexperience reviewing physical schema models.
• 3+ years of experience with Oracle EM
• Knowledge of the principles, practices and techniques of computer programming and system design
• Knowledge of computer operations, systems, and procedures
• Knowledge of Unix commands and concepts
• Knowledge of Oracle RDBMS administration tools and processes
• Knowledge of database structures and theories
• Knowledge of current database technologies
• Knowledge of data analysis techniques
• Ability to process information logically.
• Ability to develop short-range and long-range database storage/growth estimations.
• Ability to plan, organize and coordinate work assignments.
• Ability to communicate technical information effectively.
• Ability to plan and document team processes clearly and correctly.
• Ability to establish and maintain effective working relationships with others.
• Ability to assess future information needs so that the databases can evolve in an appropriate manner.
• Abilityto develop reports and cross references from the data dictionary.

Minimum Qualifications:

• 5+ years ofexperience managing Oracle Enterprise version 12c or 19c database instances.
• 5+ years ofexperience troubleshooting Oracle database administration and connection problems.

Preferred Qualifications:

• 3+ years of experience working with Red Hat/Oracle Linux command line syntax and crontab files
• Knowledge of Oracle Cloud Infrastructure architecture and DB Systems

Position of Special Trust Requirement:

This position is designated as a Position of Special Trust in accordance with DEP Directive 422, Positions of Special Trust or Responsibility. Successful completion of background screening will be required for this position.

Pay:

$70,000-$87,000 annually

Our Organization and Mission:

The Florida Department of Environmental Protection (DEP) is the state’s lead agency for environmental management and stewardship - protecting our air, water and land. The vision of DEP is to advance Florida’s position as a world leader in protecting natural resources while growing the state’s economy. DEP encourages its leaders to constantly innovate and seek efficiencies. We believe in supporting and encouraging you as you take on important and often complex projects while offering you the opportunity to gain valuable experience quickly.

How You Will Grow:

DEP encourages its employees to constantly innovate and seek efficiencies. We believe in supporting and encouraging you as you take on important and often complex projects while offering you the opportunity to gain valuable experience quickly. OTIS has an extensive training program, including courses and certifications, that provide staff with the ability to build upon existing skills and remain current on job‑related information technologies. Examples of certifications recently earned by staff include, but are not limited to:

• CompTIA A+, Security+, Network+
• Certified Information Systems Security Professional (CISSP)
• Florida Certified Public Manager (CPM)
• Microsoft Certified DevOps Engineer, Azure Solutions Architect
• Oracle Certified Professional
• Florida Certified Contract Manager (FCCM)

Where You Will Work:

Tallahassee, Florida’s Capital City, lined with rolling hills, oak trees, and canopied roads combine old world charm with a modern pace of life. Home to two major universities as well as state government, Tallahassee is a mid-sized city in the heart of Florida’s Big Bend. Tallahassee is a highly desirable location for both those seeking their first job or those ready to enter the next exciting chapter in their career.

This is an on-site position.

The Benefits of Working for the State of Florida:

Working for the State of Florida is more than a paycheck. The State’s total compensation package for employees features a highly competitive set of employee benefits including:

• Annual and Sick Leave benefits;
• Nine paid holidays and one Personal Holiday each year;
• State Group Insurance coverage options, including health, life, dental, vision, and other supplemental insurance options;
• Retirement plan options, including employer contributions (For more information, please click www.myfrs.com );

DEP is committed to successfully recruiting and onboarding talented and skilled individuals into its workforce. We recognize the extensive training, experience, and transferable skills that veterans and individuals with disabilities bring to the workforce. Veterans and individuals with disabilities are encouraged to contact our recruiter for guidance and answers to questions through the following email addresses:

An individual with a disability is qualified if he or she satisfies the skills, experience, and other job‑related requirements for a position and can perform the essential functions of the position with or without reasonable accommodation.Candidatesrequiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must contact the DEP Human Resources (HR) Office at [phone]. DEP requests applicants notify HR in advance to allow sufficient time to provide the accommodation.

Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must notify the agency hiring authority and/or People First Service Center (1-866-663-4735). Notification to the hiring authority must be made in advance to allow sufficient time to provide the accommodation.

The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., Drug-Free Workplace Act.

VETERANS’ PREFERENCE. Pursuant to Chapter 295, Florida Statutes,candidates eligible for Veterans’ Preference will receive preference in employment for Career Service vacancies and are encouraged to apply. Certain service members may be eligible to receive waivers for postsecondary educational requirements. Candidates claiming Veterans’ Preference must attach supporting documentation with each submission that includes character of service (for example, DD Form 214 Member Copy #4) along with any other documentation as required by Rule 55A-7, Florida Administrative Code. Veterans’ Preference documentation requirements are available by clicking here . All documentation is due by the close of the vacancy announcement.

Location

TALLAHASSEE, FL, US, 32399 TALLAHASSEE, FL, US, 32309 TALLAHASSEE, FL, US, 32305 TALLAHASSEE, FL, US, 32316 TALLAHASSEE, FL, US, 32311 TALLAHASSEE, FL, US, 32304 TALLAHASSEE, FL, US, 32317 TALLAHASSEE, FL, US, 32303 TALLAHASSEE, FL, US, 32310 TALLAHASSEE, FL, US, 32308 TALLAHASSEE, FL, US, 32312 TALLAHASSEE, FL, US, 32307 TALLAHASSEE, FL, US, 32302 TALLAHASSEE, FL, US, 32301

For assistance, call the People First Service Center at [phone] Monday - Friday, 8:00 a.m. to 6:00 p.m., Eastern time. Pursuant to Florida Law, 110.211 F. S., the State of Florida is an EEO employer.