Essential Duties and Responsibilities:
• Resolve complex issues involving database performance, database capacity, resiliency, stability, replication, and other key aspects of distributed database technology.
• Perform testing, analysis, and modification of existing database SQL stored procedures.
• Evaluate, refine, and tune existing Oracle objects in support of application. Install, upgrade, patch, secure, diagnose system problems, user accessibility, and troubleshoot Oracle Database versions 12.2 through 19.26.
• Digest onsite concepts, design, implementation, limitations, and configuration of complex database environments.
• Ability to define, troubleshoot, document, and escalate issues as needed.
• Work closely with application development team to implement and support data-oriented development efforts.
• Work closely with support center to expeditiously resolve issues or problems as they arise.
• Assist with analysis and documentation of user requirements. Implement system security patches & Security Technical Implementation Guides (STIGs).
• Maintain electronic repository of all database baseline, changes, and documentation.
• Perform directed tasks in a timely and efficient manner.
• Research and recommend solutions that best meet program needs and operational requirements.
• Work alongside senior application development managers to gather business rules and requirements.
• Evaluate existing database structures and propose solutions to enhance efficiency while maintaining date integrity.
• Create database schemas and objects such as tables, columns, triggers, stored procedures, scheduled jobs etc.
• Create database models based on current and future requirements outlined from customer.
• Evaluate, review, revise, and integrate database change requests.
• Utilize tools such as Visual Studio, Toad Data Modeler, SQLPLUS, Team Foundation Server, Azure Devops, Jira, and Solarwinds Helpdesk.
Required Knowledge, Skills, and Abilities:
• Robust experience administering Oracle Database Enterprise Editions.
• Advanced degree of analytical ability.
• Advanced skills in problem solving.
• Committed to a positive work ethic and active desire to learn.
• Skillful time management and organizational skills to set and meet deadlines.
• Excellent written and oral communication skills.
• Ability to work both independently and within a team.
• Strong understanding of Oracle Data Guard Replication and Recovery Manager. Experience with Linux and Windows based operating systems administration and troubleshooting.
• Extensive knowledge of relational database concepts; Database Modeling, Design and Database Creation.
• Demonstrated proficiency in creating database schemas and objects pursuant to current oracle database industry standards and best practices.
• Ability to create, clone, plug and unplug pluggable databases in a multitenant environment.
• Experience working with programming languages such as SQL, PL/SQL, Shell Scripts, and Batch Scripts.
• Proven troubleshooting and problem-solving skills for critical database, application, network, and system administration issues.
• Ability to work efficiently under pressure and with a high degree of independence.
• Critical thinking skills, ability to accurately analyze information and make sound decisions.
• Strong knowledge of Oracle Database best practices, concepts, and technologies.
• Must be versatile, flexible, and proactive when resolving technical issues. Ability to handle diverse situations and rapidly changing priorities with deadlines.
• Graduate comprehension and understanding of the Open Systems Interconnection (OSI) model.
• Ability to demonstrate relational database constructs leveraging primary and foreign keys, check constraints, and creation of objects via command line.
Preferred Knowledge, Skills, and Abilities:
• Positive experience in database administration with at least 7 years in a junior to mid-level position.
• Experience installing, configuring, and troubleshooting Oracle 19c software. Exposure to other RDBMS systems such as MSSQL and PostgreSQL is a plus. Bachelor's degree in a related field, such as Computer Science, Data Processing, Information Systems, or equivalent experience.
• Experience with features such as Automatic Storage Management and Data Guard.
• Sound efficiency in developing PL/SQL code and genuine relational database management.
• Ability to work effectively in a team environment.
Minimum Education and Experience:
• 5+ years of direct DBA experience working with Oracle Enterprise Editions.
• 7+ years of increasing responsibilities in Oracle Application Development and Database Administration.
• 5+ years of direct IT experience supporting database environments on RHEL and Windows system platforms.
• B.S. Degree required or direct work experience may substitute for education (1 year experience = 1 year education).
• DoD final Secret security clearance is required, with ability to gain and hold Top Secret.
• Oracle 19c Certified Associate (OCA), Oracle 19c Certified Professional (OCP) prior to hire.
• Comptia "Security +" certification in accordance with DoD Directive 8140.01 Cyberspace Workforce Management requirements upon hire.
Date Posted: 17 April 2025
Apply for this Job