Oracle Database Administrator

Job Requirements

•  
  • Advanced Oracle database administration skills and experience required.
  • AWS cloud experience required
  • Oracle 19c experience highly desired
  • Good communication skills required
  • Working knowledge of Oracle Data Guard and standby databases
  • Working knowledge of Oracle Golden Gate and database replication
  • Working knowledge of some other database technology like MS SQL Server, Postgres, or MongoDB are desired
  • Advanced problem solving and troubleshooting skills
  • Oracle database and query performance tuning skills needed
  • Troubleshoot and resolve RAC and Red hat clustering issues in database environments
  • Schedule and coordinate database maintenance activities
  • Strong ability to resolve technical and complex database issues before they impact production systems
  • Ability to perform physical database design changes according to requirements established during logical data modeling activity
  • Ability to perform database backup, recovery, and disaster recovery
  • Performs database migrations, upgrades, and structure migrations
  • Ability to influence development organizations to comply with database best practices and client’s standards and practices
  • Ability to run transaction access path analysis with application developers to ensure database design and application code is efficient.
  • Make recommendations for improvements
  • Ensures high quality database design across projects enabling company-wide data reusability
  • Coordinate and participate in database stress testing and make recommendations for improvements
  • Develops and maintains database standards that fit with client’s standard development processes
  • Monitors database performance and tunes where needed
  • Identifies and supports quality improvements
  • Complies with all client’s security and audit standards
  • Participates in 7x24 rotating on-call nights and weekends as needed
  • Works well in teams and in matrix to multiple projects

 Knowledge, Skills, and Abilities:

•  
  • 5-8 years of experience, with at least the last 3-5 years as Lead Oracle DBA on all aspects of Oracle Database Administration in a large/challenging database environment on AWS/Unix / Linux platform.
  • Experience on Amazon Web Services or Azure with database support in IaaS or PaaS preferred.
  • Experience with automation tools (Ansible, Jenkins) & container technologies (Docker, CoreOS) is a plus
  • Strong verbal and written communication skills
  • Good Linux, AWS Linux and Red hat clustering experience and scripting is a plus
  • Experience supporting internet/web-based database applications with heavy concurrent user volume.      
  • Experience working on Oracle 12c; 19c and RAC database applications, Oracle TDE, OEM Grid Control and RMAN
  • Skilled in SQL statement tuning with detailed understating of AWR and Stats Pack reports, database performance tuning
  • Basic understanding of Connection pooling and middleware software like JBoss, JRun, Tom Cat, IBM Web sphere is desired
  • Experience doing database upgrade and maintenance work (19c desired)
  • Willingness to work on-call DBA rotations in a 7x24 environment
  • Must be able to work effectively in a team environment Proficient at time and priority management
  • Ability to create and maintain positive and professional business relationships with both internal associates and external customers

Education:

• The candidate should have a Bachelor’s degree or Masters in Computer Science or 5 to 8 years of related experience in IT or a related field.