Senior Oracle Database Administrator

Company Description

Job Description

Seeking a highly motivated and well-rounded Oracle DBA with a strong development background to be part of a fast-paced production support and full-lifecycle implementation team supporting our largest clients. Environments consist of highly available real-time and Data Warehouse utilizing Exadata, TDE,Active Dataguard,HVR, and MAA

The ideal candidate is expected to be familiar with database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/SQL programming, backup & recovery concepts, and database performance and tuning. Candidate must have good analytical, verbal, and written skills.

Key Duties, Tasks and Responsibilities

• Full life cycle support of client's database(s). Database system utilizes RAC and non-RAC for OLTP and warehouse, Active Dataguard for DR, partitioning on 19c and Oracle Golden Gate for Active/Active data replication.
• Responsible for database backups, design, development, testing, and performance tuning.
• Will work with developers to design and build new structures to support application enhancements and promote database changes throughout the Dev, UAT and Prod databases.
• Responsible for quarterly patch applications (PSU) and periodic database upgrades with minimal downtime in database environment.
• Required to participate in 24x7 on-call rotation and be available to perform periodic after-hours support.

Qualifications

• 5 years of related experience with implementation and administration of database systems.
• Advanced degree in computer science or equivalent experience required.
• Able to administer, manage and tune high-transaction production server environment(s).
• Able to understand and meet needs of end users.
• Able to work in a dynamic, fast paced and often changing environment.
• Excellent analytical and troubleshooting skills.
• Excellent database programming and query knowledge.
• Excellent design, development, administration skills.
• Excellent knowledge of database development.
• Excellent knowledge of logical and physical database design.
• Excellent problem-solving skills and written and oral communication skills.
• Experience in Oracle Exadata and Oracle Golden Gate can be a plus.
• Experience in hosting/managing database servers which hosted on Cloud, can be a plus.
• Optimized SQL queries from various Industry applications to meet stringent KPI’s.
• Extensive use of AWR, TKProf, SQLHC, and various other tools in analyzing slow SQLs.
• Providing the best practices for optimal performance of the database.
• Experience in Performance Tuning using EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK, AWR and ADDM.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors, and Triggers.

Qualifications

Additional Information

We know that we have some of the brightest and most talented associates in the world, and we believe in rewarding them accordingly. If you work here, expect competitive pay, comprehensive health coverage, and endless opportunities to advance your career.

Epsilon is an Equal Opportunity Employer. Epsilon’s policy is not to discriminate against any applicant or employee based on actual or perceived race, age, sex or gender (including pregnancy), marital status, national origin, ancestry, citizenship status, mental or physical disability, religion, creed, color, sexual orientation, gender identity or expression (including transgender status), veteran status, genetic information, or any other characteristic protected by applicable federal, state or local law. Epsilon also prohibits harassment of applicants and employees based on any of these protected categories.

Epsilon will provide accommodations to applicants needing accommodations to complete the application process.

REF157637C

#LI-AM1