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.