Senior Database Administrator w/ETL Experience (Telework Available)
Job Category: Information Technology
Time Type: Full time
Minimum Clearance Required to Start: Secret
Employee Type: Regular
Percentage of Travel Required: Up to 10%
Type of Travel: Local
What You’ll Get to Do
CACI is seeking an experienced Oracle database administrator with ETL experience to join our program as a member of our team supporting our DOD clients. In this role, you will support application and database activities in maintaining multiple Oracle 19c RDBMS environment instances. You will also support a new data transformation/migration across systems in support of a DoD customer.
You will provide Oracle DBA support to a large implementation project in a complex environment which includes Oracle 19 and Postgres databases and multiple functional applications and technologies. You will play a key role in support a new data transformation and migration project moving data from a legacy source to a new target system. You will be part of a team where complex problem solving, and communication skills are critical to success.
Your contributions will directly impact the success of the customers' mission, our team, and ultimately CACI! In return, CACI will provide you with a company that fosters a culture based on integrity, strong ethics, quality work, and professionalism, while supporting your career growth aspirations.
More About the Role
Assist in managing and maintain multiple Oracle 19c RDBMS and PostgreSql instances.
Work closely with cross-functional teams to help create and maintain source to target data mappings and transformation business rules.
Develop migration scripts using PL SQL and SQL related technologies to perform data extract, transformation and load.
Perform the migration of data from legacy systems to new system.
Perform data profiling and validation of source to target migrated data
Identify data anomalies, address data issues by applying data validation rules and remediation routines
Support DBA activities as well as support special projects including application rehosting migrations
Perform installation and upgrade of applications, databases, and tools including patching of technology stack and databases
Perform patching tasks for keeping all environments current with vendor patches
Recommend improvements to processes and procedures to increase productivity, reduce maintenance cycles, and improve quality delivery.
Provide on-call support to production environments including some weekend support
Work cooperatively with functional and technical staff, to meet timelines and deliverables
You’ll Bring These Qualifications
Bachelor’s or above degree in relevant field, or equivalent work experience
10+ years software development experience
5+ years DBA experience
7+ years PL/SQL experience
5+ years experience supporting Oracle Forms/APEX applications development
Experience extract, transform, load (ETL) of data from diverse databases and file structures to leverage in a different target system
Experience in data validation and cleaning to ensure the quality and integrity of data
Must have strong analytical skills and can demonstrate strong problem-solving skills
Minimum current DoD Secret clearance
Must be US citizen
These Qualifications Would Be Nice to Have
Experience DoD Oracle based technical implementations
Experience with ETL tools
Experience with Azure DevOps
Experience with Toad, SQL Developer or DBeaver
What We Can Offer You:
We’ve been named a Best Place to Work by the Washington Post.
Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives.
We offer competitive benefits and learning and development opportunities.
We are mission-oriented and ever vigilant in aligning our solutions with the nation’s highest priorities.
For over 60 years, the principles of CACI’s unique, character-based culture have been the driving force behind our success.
Company Overview: At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other protected characteristic.