Senior Oracle DBA

Company Description

Epsilon is the leader in outcome-based marketing. We enable marketing that’s built on proof, not promises. Through Epsilon PeopleCloud, the marketing platform for personalizing consumer journeys with performance transparency, Epsilon helps marketers anticipate, activate and prove measurable business outcomes. Powered by CORE ID®, the most accurate and stable identity management platform representing 200+ million people, Epsilon’s award-winning data and technology is rooted in privacy by design and underpinned by powerful AI. With more than 50 years of experience in personalization and performance working with the world’s top brands, agencies and publishers, Epsilon is a trusted partner leading CRM, digital media, loyalty and email programs. Positioned at the core of Publicis Groupe, Epsilon is a global company with over 9,000 employees in over 40 offices around the world.

Job Description

Love cutting-edge tech? We do too.

A subsidiary of Publicis Groupe, Epsilon is a leading provider of multi-channel marketing services, technologies, and database solutions. We do more than collect and store data, and we might be the most important Internet company you’ve never heard of. Join our team for your chance to work in the digital marketing space and solve meaningful problems on a massive scale—and have fun doing it.

For this role, we are seeking a highly motivated and well-rounded Senior Database Administrator 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 should 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.

What you’ll do:

• Providing the best practices for optimal performance of the database
• 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.
• Oversee large scale Elasticsearch and Kafka Clusters
• 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
• Provide 24 x 7 x 365 support through on-call rotation

About you:

• Able to do your best work in a team setting and autonomously
• Well-developed interpersonal and problem-solving skills
• Strong written and oral communication skills.
• Owns a problem to the end
• Proud to share in team’s success
• Wants to grow a career with a great company.

What you’ll bring:

• BS in Computer Science or related technical discipline or equivalent practical experience.
• At least 5 years of related experience with implementation and administration of database systems.
• 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.
• Experience in Performance Tuning using EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK, AWR and ADDM.
• Optimized SQL queries from various Industry applications to meet stringent KPI’s.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors, and Triggers.
• Strong analytical and troubleshooting skills.
• Excellent database programming and query knowledge.
• Deep knowledge of knowledge of database development, including design, development, administration skills.
• Excellent knowledge of logical and physical database design.  
• Extensive use of AWR, TKProf, SQLHC, and various other tools in analyzing slow SQLs.
• Experience in hosting/managing database servers which hosted on Cloud, can be a plus.
• Familiarity with Elasticsearch and Kafka technologies
• Enthusiastic to learn new technologies and apply knowledge to improve our products.
• Extremely detail-oriented with strong analytical problem-solving skills
• Experience in Oracle Exadata and Oracle Golden Gate can be a plus

Qualifications

About you:

• Able to do your best work