Oracle Autonomous Data Warehouse (ADW) Database Administrator & ETL Engineer

Accenture Federal Services | IT Consulting

1h 6m ago

On-site

Full Time

United States of America

$91.7k - $178.7k USD/yr

Title: Oracle Autonomous Data Warehouse (ADW) Database Administrator & ETL Engineer Location: Washington, DC

At Accenture Federal Services, nothing matters more than helping the US federal government make the nation stronger and safer and life better for people. Our 13,000+ people are united in a shared purpose to pursue the limitless potential of technology and ingenuity for clients across defense, national security, public safety, civilian, and military health organizations.

Join Accenture Federal Services, a technology company within global Accenture. Recognized as a Glassdoor Top 100 Best Place to Work, we offer a collaborative and caring community where you feel like you belong and are empowered to grow, learn and thrive through hands-on experience, certifications, industry training and more.

Join us to drive positive, lasting change that moves missions and the government forward!

The Work:

We are seeking an experienced Oracle ADW Database Administrator & ETL Engineer to support the implementation and administration of Oracle Autonomous Data Warehouse (ADW) and the development of data integration pipelines using Oracle Cloud Infrastructure (OCI) Data Integration. This role will be responsible for building scalable data solutions, optimizing analytical performance, and supporting enterprise reporting and analytics initiatives.

Key Responsibilities

Provision, configure, and administer Oracle Autonomous Data Warehouse (ADW) environments within OCI.
Design, develop, and maintain ETL/ELT pipelines using OCI Data Integration Cloud Service.
Build and support data ingestion, transformation, and staging processes for analytics and reporting.
Design, implement, and maintain STAR schemas and dimensional data models.
Monitor and optimize database performance, storage utilization, and query efficiency.
Collaborate with analytics, data engineering, and infrastructure teams to support reporting and data modeling needs.
Manage security, access controls, and OCI resource configurations.
Document data models, ETL processes, mappings, and system configurations.

Here’s What You Need:

3–5 years of experience as an Oracle Database Administrator, Data Engineer, or ETL Engineer.
Hands-on experience with Oracle Autonomous Data Warehouse (ADW).
Experience developing and managing pipelines with OCI Data Integration Cloud Service.
Strong knowledge of Oracle Cloud Infrastructure (OCI) administration and configuration.
Advanced SQL skills, including performance tuning and query optimization.
Experience designing and maintaining STAR schemas and dimensional data models.

Bonus Points If You Have:

Experience integrating ADW with Oracle Analytics Cloud (OAC).
Familiarity with OCI services such as Object Storage, Data Catalog, Data Flow, and GoldenGate.
Knowledge of cloud-based data warehousing and ETL/ELT best practices.
Experience with data governance, metadata management, and cloud security practices.

Eligibility Requirements:

U.S. Citizen – Dual Citizen

As required by local law, Accenture Federal Services provides reasonable ranges of compensation for hired roles based on labor costs in the states of California, Colorado, Connecticut, Hawaii, Illinois, Maine, Maryland, Massachusetts, Minnesota, New Jersey, New York, Ohio, Vermont, Virginia, Washington, and the District of Columbia. The base pay range for this position in these locations is shown below. Compensation for roles at Accenture Federal Services varies depending on a wide array of factors, including but not limited to office location, role, skill set, and level of experience. Accenture Federal Services offers a wide variety of benefits. You can find more information on benefits here. We accept applications on an on-going basis and there is no fixed deadline to apply.

The pay range for the states of California, Colorado, Connecticut, Hawaii, Illinois, Maine, Maryland, Massachusetts, Minnesota, New Jersey, New York, Ohio, Vermont, Virginia, Washington, and the District of Columbia is:

$91,700—$178,700 USD

What We Believe

As a company wholly dedicated to serving the US federal government, we bring together the best talent to help reinvent how federal agencies operate and deliver greater value for their mission and the American people. We have an unwavering commitment to creating a culture in which all our people are respected, feel a sense of belonging, and have equal opportunity. As a business imperative, every person at Accenture Federal Services has the responsibility to create and sustain a culture where everyone feels welcomed and included. This is grounded in our core values and our experience that hiring and developing great people who reflect different perspectives, experiences, and backgrounds is key to driving innovation and delivering the results that our clients and the country count on.

Equal Employment Opportunity Statement

We believe that no one should be discriminated against because of their differences. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities. For details, view a copy of the Accenture Federal Services Equal Opportunity Policy Statement.

Accenture Federal Services is an Equal Employment Opportunity employer. Additionally, as an Affirmative Action Employer for Veterans and Individuals with Disabilities, Accenture Federal Services is committed to providing veteran employment opportunities to our service men and women.

Requesting An Accommodation

Accenture Federal Services is committed to providing equal employment opportunities for persons with disabilities or religious observances, including reasonable accommodation when needed. If you are hired by Accenture Federal Services and require accommodation to perform the essential functions of your role, you will be asked to participate in our reasonable accommodation process. Accommodations made to facilitate the recruiting process are not a guarantee of future or continued accommodations once hired.

If you are being considered for employment opportunities with Accenture Federal Services and need an accommodation for a disability or religious observance during the interview process or for the job you are interviewing for, please speak with your recruiter.

Other Employment Statements

Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States.

Candidates who are currently employed by a client of Accenture Federal Services or an affiliated Accenture business may not be eligible for consideration.

Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process.

The Company will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. Additionally, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the Company's legal duty to furnish information.

California requires additional notifications for applicants and employees. If you are a California resident, live in or plan to work from Los Angeles County upon being hired for this position, please click here for additional important information.

Required Skills

sql

Required Languages

🇬🇧 English