2,065 Oracle Dba jobs in the United States

Oracle DBA

Category: Database Administration

Main location: United States, Virginia, Arlington

Position ID: J0325-1708

Employment Type: Full Time

Position Description:

CGI Federal is seeking a talented Database Developer to join our team. As a key member of our US Courts client project, you will be responsible for designing, implementing, and managing database solutions to ensure data integrity, consistency, and performance.

You will work closely with data analysts, IT staff, and other stakeholders to understand data requirements and provide database solutions.

This position is located in Arlington, VA.

Your future duties and responsibilities:

Database Installation and Configuration:

Install, configure, and maintain Oracle database systems to ensure optimal performance, availability, and security.

Performance Monitoring and Tuning:

Monitor database performance and implement performance tuning.

Optimize SQL queries to improve database efficiency.

Backup and Recovery:

Perform regular database backups and recovery operations.

Develop and implement disaster recovery plans to ensure data integrity and availability.

Security Management:

Manage database security by implementing and maintaining user roles, permissions, and encryption.

Ensure compliance with security policies and regulations.

Database Maintenance:

Plan and execute database upgrades, patches, and migrations.

Maintain database documentation, including data models, schemas, and procedures.

Collaboration with Development Teams:

Work closely with development teams to design and implement database solutions that meet business requirements.

Provide technical support and guidance on database-related issues.

Troubleshooting and Issue Resolution:

Troubleshoot and resolve database-related issues.

Provide technical support to internal teams and end-users.

Data Integrity and Consistency:

Ensure data integrity and consistency across multiple environments.

Implement and maintain data validation and integrity checks.

Automation and Scripting:

Develop and maintain scripts for database automation tasks.

Automate routine database maintenance and monitoring activities.

Documentation and Reporting:

Create and maintain comprehensive database documentation.

Generate reports on database performance, usage, and security.

Staying Current with Industry Trends:

Stay up-to-date with Oracle database technologies, best practices, and industry trends.

Continuously improve skills and knowledge through training and professional development.

Capacity Planning:

Monitor database storage and plan for future capacity requirements.

Ensure that database resources are efficiently allocate

Required qualifications to be successful in this role:

Bachelor's degree in Computer Science, Information Technology, or related field. Or years of experience in Oracle administration.

Proven experience as an Oracle DBA with a strong understanding of Oracle database architecture and administration.

Proficiency in Oracle database management tools and utilities.

Experience with performance tuning, backup and recovery, and database security.

Strong knowledge of SQL and PL/SQL programming.

Excellent problem-solving skills and attention to detail.

Strong communication and collaboration abilities.

Desired qualifications/non-essential skills required:

Oracle DBA certifications (e.g., Oracle Certified Professional).

Experience with Oracle RAC, Data Guard, and ASM.

Familiarity with cloud-based database solutions (e.g., Oracle Cloud, AWS RDS).

Knowledge of other database technologies (e.g., MySQL, SQL Server).

CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. To support the ability to reward for merit-based performance, CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $69,700.00 - $169,700.00.

CGI Federal's benefits are offered to eligible professionals on their first day of employment to include:

• Competitive compensation

• Comprehensive insurance options

• Matching contributions through the 401(k) plan and the share purchase plan

• Paid time off for vacation, holidays, and sick time

• Paid parental leave

• Learning opportunities and tuition assistance

• Wellness and Well-being programs

#CGIFederalJob

#ClearanceJobs

Skills:

• Oracle

• Oracle SQL Server

• Oracle Cert Database SQL Exper

• Oracle Content Management

• Oracle DBMS

• Oracle SQL Developer

What you can expect from us:

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our team—one of the largest IT and business consulting services firms in the world.

Qualified applicants will receive consideration for employment without regard to their race, ethnicity, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, pregnancy, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity, and gender expression, familial status or responsibilities, reproductive health decisions, political affiliation, genetic information, height, weight, or any other legally protected status or characteristics to the extent required by applicable federal, state, and/or local laws where we do business.

CGI provides reasonable accommodations to qualified individuals with disabilities. If you need an accommodation to apply for a job in the U.S., please email the CGI U.S. Employment Compliance mailbox at . You will need to reference the Position ID of the position in which you are interested. Your message will be routed to the appropriate recruiter who will assist you. Please note, this email address is only to be used for those individuals who need an accommodation to apply for a job. Emails for any other reason or those that do not include a Position ID will not be returned.

We make it easy to translate military experience and skills! Clickhere ( to be directed to our site that is dedicated to veterans and transitioning service members.

All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary dependent upon specific assignment and/or level of US government security clearance held. Dependent upon role and/or federal government security clearance requirements, and in accordance with applicable laws, some background investigations may include a credit check. CGI will consider for employment qualified applicants with arrests and conviction records in accordance with all local regulations and ordinances.

CGI 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. However, 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 CGI’s legal duty to furnish information.

• Oracle DBA with Golden Gate and AWS Experience working in Production and Dev systems Oracle Systems.
• Specialized in Golden Gate Bidirectional setup including deep dived troubleshooting.( 19c and 12c )
• Oracle 11g/12/19c Rel1, Rel 2 administration
• Experience in OS Patching with Linux and AIX
• Experience in oracle Database Patching for 12c and 19c
• SSL experience and working with certificate renewals.
• Experience in MySQL and Mongo ( nice to have )
• Handling RMAN backup and Recovery issues.
• Oracle database upgrade and patching
• Oracle SQL Performance tuning
• Shell script writing (nice to have)
• Oracle Container, Pluggable database knowledge
• Provide 24/7 support of production database services to ensure the highest standards of availability resilience, integrity, security and performance.
• Install and maintain database server, replication and client environments
• Develops and implements plans to oversee the database administration function and ensures smooth transition to new technology ---Familiarity with standard database monitoring tools (OEM) - Able to use documentation tools to follow and maintain technical plans and procedures

Support server, storage and database migration activities ? Assist team with root cause analysis for major incidents. ? Knowledge on continuous security OS patching and validation? Ensure all solutions and recommended solutions are consistent IT standards and best practices

Title: ORACLE DBA
Location: Irvine, CA (Onsite)
Duration: 6+ months
Implementation Partner: Infosys
End Client: Capital Group

JD:

• Minimum 8 years of experience is required.
• We are seeking a highly skilled and experienced Oracle Database Administrator (DBA) with expertise in AWS.
• The candidate will be responsible for the day-to-day management of Oracle databases and will lead our e orts to migrate our database infrastructure to AWS.
• This role requires in-depth knowledge of Oracle database administration and AWS services, particularly related to database migration and management on EC2 instances and RDS using AWS Database Migration Service (DMS).
• Additionally, this role will involve designing, architecting, and implementing database solutions, including backup, security, and disaster recovery strategies.

• Configure and maintain Dynatrace monitoring solutions.
• Must have strong experience in migrating Oracle databases to the AWS Cloud Environment.
• Install and manage Oracle versions 11g, 12c, 18c, and 19c.
• Configure databases according to application requirements, ensuring optimal performance and availability.
• Experience in setting up and managing Oracle Data Guard for disaster recovery.
• Hands-on experience with Oracle RAC (Real Application Clusters) and ASM (Automatic Storage Management).
• Proficient in Oracle RMAN for backup and recovery.
• Expert in RMAN Should be able to restore Oracle Database using RMAN from backups.
• Strong understanding of Oracle database architecture, performance tuning, and troubleshooting.
• Implement and manage Oracle database security policies, Roles, privileges for Users.
• Involved in testing and troubleshooting backups, monitoring backup performance, and setting up alerts
• Develop, manage, and test backup and recovery plans, including both on-premises and cloud environments.
• Hands-on experience with AWS EC2, RDS, S3, IAM, CloudWatch, and other relevant AWS services.
• Configure and manage Oracle Multi-AZ deployments for high availability and fault tolerance in AWS.
• Implement and maintain Oracle Data Guard for Multi-AZ replication and failover configurations.
• Design and implement disaster recovery strategies, including DR in AWS.
• Excellent communication skills and the ability to work in a team-oriented environment.

• Oracle Certified Professional (OCP) - Oracle Database Administration.
• AWS Certified Solutions Architect - Associate/Professional (Optional But Beneficial).

Upgrading Oracle database from 12c to 19c version for Oracle EBS application 12.2.8
2. Troubleshooting and resolution of database and application issues encountered as part of the upgrade
3. Working with Oracle support to resolve issues and seek recommendation on best practises for upgrade
4. Extensive knowledge and experience in Oracle RAC, PCP and DMZ environments.
5. Collaborate with Application Functional testing and boundary application teams and work on issue resolution reported by teams
6. Develop upgrade runbook for database upgrade
7. Work towards reducing the upgrade downtime by streamlining and optimizing the upgrade process
8. Work with Infrastructure teams (Linux, storage teams) to plan and upgrade for infrastructure components e.g. OS, Grid upgrade
9. Environment planning for multiple upgrade test cycles
10. Working with Project Manager and others stakeholders to adhere to project timelines set for upgrade
11. Work on performance issues reported by testing teams, work on SQL tuning advisor, SQL profiling
12. Develop documents for system maintenance (Patching, cloning, service account password change)
13. Setup a Disaster recovery environment using Oracle dataguard and perform DR test

Experience
• 10+ Years of experience as Oracle Apps DBA and Oracle DBA
• Extensive experience working on 12c and 19c database versions
• Extensive experience working on Oracle EBS 12.2 version
• Flexibility to work in 24*7 model.
• bility to learn new technologies and tools
• Good communication skills

• Experience with Oracle 19c , RMAN and ASM. (change)
• Proficiency with Linux, EC2 and VMware vSphere. (change)
• Experience designing and supporting the database components of software applications, and understanding of entire application development life cycle.
• Experience in database schema design including logical and physical database schemas design using data modeling tools such as Erwin, ERStudio.
• Extensive knowledge with complex SQL and PL/SQL programming and optimization.
• Experience with Oracle E-Business Suite (EBS)

• Administration of firm’s Oracle database environment including, but not limited to:

li>Support Oracle environment HA/DR solutions (RAC, DataGuard)
• Participate in 24x7 on-call rotation to support production database environment.
• Support software development projects, including production releases.
• Effectively coordinate and communicate with all stakeholders.
• Learn relevant business processes and understand data flow, criticality and dependencies.
• Innovative approach to work, constantly looking for opportunities to uplift the system to more   efficient and effective new technologies.

< i>7+ year experience as an Oracle Database Administrator, supporting various Oracle RDBMS versions (11g -19c+)
• Good working knowledge of Oracle Real Application Clusters and Operating Systems (AIX, Linux, Windows)
• Extensive Full Project life Cycle experience
• Extensive experience in developing database scripts (SQL, PL/SQL and Unix Shell)
• Working knowledge of Oracle database design, coding, and documentation.
• Excellent communication and problem-solving skills.
• Preferred candidates will have some experience with other DBMS’s: PostgreSQL, Sybase, etc.