Senior Oracle Database Administrator Contingent

Active Secret Clearance Required

This is a contingent position meaning employment is dependent upon the successful award of the associated contract toAretumand completion of any required background investigation or security clearance verification.

AboutAretum

Aretumis a mission-driven organization committed to delivering innovative technology-enabled solutions to our customers across defense civilian and homeland security sectors. Our teams work at the intersection of strategy technology and transformation helping agencies solve their most critical challenges. We believe in investing in our people and creating a culture where collaboration inclusion and professional growth are at the forefront.

Job Summary

The Senior Oracle Database Administrator willbe responsible forthe design maintenance governance and optimization of the database environment supporting a mission-critical information system and its associated sub-applications. This role ensures that database structures data standards and backend processes are implemented andmaintainedin accordance withapproved technical requirements configuration management standards and federal security policies.

Due to the nature of our work as a federal consulting organization employees may be expected to handle Controlled Unclassified Information (CUI) and must adhere to applicable safeguarding and compliance requirements.

Responsibilities

• Supporting the unification of application and database development frameworks and participating in database migration activities across development test and production environments.
• Designing building and maintaining database structures and schemas to support transactional reporting and invoicing/payment system components.
• Managing data structures and data administration procedures to control redundancy and ensure consistency across database environments.
• Assisting with the design development and maintenance of a comprehensive repository for data standards data models and data element definitions.
• Creating and maintaining a data directory that includes an inventory of stored procedures scheduled tasks and database scripts.
• Developing documenting and maintaining backend database scripts and processes and storing documentation in a centralized repository.
• Administering repository rules and coordinating the process for adding changing and deleting database objects and information.
• Ensuring synchronization and consistency between physical databases and repository information.
• Recommending and implementing database standards guidelines and best practices related to data ownership retrieval and modification rights.
• Coordinating with system administrators to ensure database compatibility with development test and production environments.
• Supporting performance tuning troubleshooting and resolution of database-related issues.
• Investigating and resolving developer-reported database problems or performance complaints.
• Supporting data migration backup and recovery activities to ensure data availability and integrity.
• Assisting with the development of test cases and supporting regression testing activities related to database changes.
• Participating in user acceptance testing (UAT) activities related to database functionality.
• Supporting application enhancements by implementing approved schema changes and backend updates.
• Assisting with data administration workshops and participating in enterprise data administration programs.
• Providing input into technical recommendations and white papers related to database modernization and optimization.

• Active Secret clearance (or higher).
• Minimum of 8 years of experience in Oracle database administration supporting enterprise or mission-critical information systems.
• Bachelors degree in Computer Science Information Technology Engineering or a related field.
• Proficiency in writing debugging and tuning SQL queries and PL/SQL procedures.
• Expertise in designing and executing database backup and recovery strategies using Recovery Manager (RMAN).
• Ability to diagnose and fix performance bottlenecks using AWR ASH and SQL Tuning Advisor.
• Demonstrated experience managing Oracle databases across development test and production environments.
• Experience supporting database migration efforts and schema modernization activities.
• Experience designing and maintaining database schemas stored procedures and backend scripts.
• Experience with database performance tuning troubleshooting and optimization.
• Working knowledge of configuration management version control and change control processes.
• Experience supporting data administration standards repositories and data governance activities.
• Experience supporting regression testing test case development and user acceptance testing.
• Familiarity with federal information system documentation requirements and SDLC artifacts.

Preferred Qualifications

• Masters degree

Travel Requirements

Travel to client locations isrequiredfor this position and may vary based on project needs.

EEO Statement

Aretumis committed to fostering a workplace rooted in excellence integrity and equal opportunity for all. We adhere to merit-based hiring practices ensuring that all employment decisions are made based on qualifications skills and ability to perform the job without preference or consideration of factors unrelated to job performance.

As an Equal Opportunity EmployerAretumcomplies withall applicable federal state and local employment laws.

We are proud to support our nations veterans and military familiesprovidingcareer opportunities that honor their service and experience.

If you require reasonable accommodation during the hiring process due to a disability please contactforassistance.

Equal Opportunity Employer/Veterans/Disabled

U.S. Work Authorization

Applicants must be U.S. citizens and currently authorized to work in the United States on a full-time basis. This position supports a federal government contract and therefore requires an active Secret clearance.

• Health Care Plan (Medical Dental & Vision)
• Retirement Plan (401k)
• Life Insurance (Basic Voluntary & AD&D)
• Paid Time Off
• Family Leave (Maternity Paternity)
• Short Term & Long-Term Disability
• Training & Development

Required Experience:

Senior IC