Sr. Oracle DBA - Princeton, United States - VTal Technology Solutions

    VTal Technology Solutions
    VTal Technology Solutions Princeton, United States

    1 month ago

    Default job background
    Description

    Looking for Sr. Oracle DBA - Postgres SQL DBA to work with a nonprofit educational assessment and research organization for a contract role.
    This is a hybrid role with 2 days onsite availability required.

    Job Duties & responsibilities:

    • Oracle Application DBA
    • 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 Redhat 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:
    • 10 + 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 Redhat 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 StatsPack 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.