Description

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.

Education

Bachelor's degree