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

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

• 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

• 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.