DATA BASE CONSULTANT - 37010324

State of Florida • Tallahassee, FL

5d • $70,000 - $87,000 • Onsite

About The Position

DEP’s Office of Technology and 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.
Identifying and meeting the needs of customers and providing excellent customer service.
Perform other duties as assigned.

Requirements

• 5+ years of experience managing Oracle Enterprise version 12c or 19c database instances.
• 5+ years of experience troubleshooting Oracle database administration and connection problems.
• 5+ years of experience monitoring Oracle performance metrics
• 3+ years of experience 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.
• Ability to develop reports and cross references from the data dictionary.

Nice To Haves

• 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

Responsibilities

• 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.
• Identifying and meeting the needs of customers and providing excellent customer service.
• Perform other duties as assigned.

Benefits

• 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
• Tuition waivers;

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed