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 create strong community partnerships, safeguard Florida’s natural resources and enhance its ecosystem.
The Work You Will Do:
DEP’s Office of Technology and Information Services (OTIS) is currently seeking a Data Base Consultant, which will serve as a Senior Oracle Database Administrator. This is a technical position that provides Oracle database support and solutions for the agency. The incumbent of this position will represent OTIS and must be helpful, cooperative, polite, respectful, and courteous at all times in the interactions with customers.
The Difference You Will Make:
DEP relies heavily on science and technology in order to meet its mission and continually advances modern methods, platforms and innovations for this purpose. Examples at DEP include an application architecture leveraging Azure Kubernetes, a cloud-based server infrastructure, an industry leading data analytics platform, and an advanced security management solution.
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.
- CompTIA A+, Security+, Network+
- Certified Information Systems Security Professional (CISSP)
- PMP®; ScrumMaster
- Florida Certified Public Manager (CPM)
- GISP® (Certified GIS Professional)
- Microsoft Certified DevOps Engineer, Azure Solutions Architect
- Oracle Certified Professional
- Florida Certified Contract Manager (FCCM)
- Florida Certified Contract Negotiator (FCCN)
Where You Will Work:
This position is in Florida’s capital city, Tallahassee, which is lined with rolling hills, oak trees, and canopied roads. Tallahassee is a mid-sized city in the heart of Florida’s Big Bend that combines old world charm with a modern pace of life. Home to two major universities as well as a community college and state government, 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;
- Flexible Spending Accounts;
- Tuition waivers;
- And more!
For a more complete list of benefits, visit www.mybenefits.myflorida.com.
Your Specific Responsibilities:
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. The primary duties are:
- Establishing and maintaining databases used for development, test, production, data warehousing, and public access.
- Recording, tracking, and investigating problems reported by users and keeping management informed of potential trouble areas.
- 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.
- Identifying and meeting the needs of customers and providing excellent customer service.
- Perform other duties as assigned.
Required Knowledge, Skills, and Abilities:
- 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 establish and maintain effective working relationships with others.
Minimum Qualifications:
- 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.
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.
- Current Oracle Cloud Infrastructure Foundations Associate and Architect Associate certifications preferred but required during the first year of employment.
Other Job-Related Requirements for this Position:
BACKGROUND SCREENING REQUIREMENT: This position is designated as a Position of Special Trust. Any applicant being considered for employment must successfully complete a Level 2 State and National criminal history check as a condition of employment before beginning employment.
DEP is committed to successfully recruiting and onboarding talented and skilled individuals into its workforce. We recognize the extensive training, experience, and transferrable skills that veterans and individuals with disabilities bring to the workforce.
HR_VeteransPreference@dep.state.fl.us
HR_ER@dep.state.fl.us
The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer, and does not tolerate discrimination or violence in the workplace.
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.
