Database Administrator
Publicis Groupe
Job Summary
Epsilon is seeking a highly motivated Oracle DBA with a strong development background for a fast-paced production support and full-lifecycle implementation team. The role involves full life cycle support of client databases, including design, development, testing, performance tuning, and quarterly patch applications. The candidate will work with developers, participate in 24x7 on-call rotation, and proactively automate tasks, ensuring operational excellence across various database engines and Big Data solutions.
Must Have
- 3-5 years of related experience with implementation and administration of database systems
- Bachelor Degree or equivalent experience required
- Able to administer, manage and tune high-transaction Standalone/RAC production server environment(s) on premises and cloud environments
- Familiarity with database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/SQL programming, backup & recovery concepts, and database performance and tuning
- Strong analytical and troubleshooting skills for complex database performance issues
- Strong knowledge of database upgrade/migrations
- Strong knowledge in using Backup and recovery tools (RMAN/EXPDP/IMPDP)
- Strong knowledge of Oracle DataGuard Physical Standby configuration, build and support including DataGuard Broker and replication
- Knowledge on database programming and query troubleshooting
- Experience in writing Shell scripts
- Good written/oral communication and soft skills
Good to Have
- Oracle certification
Job Description
Overview
About Business Unit:
A consolidated team of database technology professionals, we deliver expert insights across all major database engines and Big Data solutions to support Epsilon products and platforms. The team has a one-of-a-kind alignment that combines a horizontal organizational structure with vertically aligned sub-groups dedicated to our clients. By adhering to consistent standards and methodologies, the team ensures operational excellence and has close ties with product teams at Oracle, IBM, Cloudera, Amazon and Microsoft.
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.
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.
Click here to view how Epsilon transforms marketing with 1 View, 1 Vision and 1 Voice.
Responsibilities
- Full life cycle support of client's database(s). Database system uses RAC and non-RAC for OLTP and warehouse, Active DataGuard for DR, partitioning on 12c and 19c on premises and cloud environment.
- 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.
- Proactively think toward automation of repeated tasks.
Qualifications
- 3-5 years of related experience with implementation and administration of database systems.
- Bachelor Degree or equivalent experience required.
- Able to administer, manage and tune high-transaction Standalone/RAC production server environment(s) on premises and cloud environments.
- Able to understand and meet needs of end users.
- Able to work with multiple project in a dynamic, fast paced and often changing environment.
- Strong design, development, administration skills.
- Strong knowledge on managing Automatic storage management.
- Strong analytical and troubleshooting skills for complex database performance issues using AWR/ASH/ADDM/TKPROF/SQLT/10046 tracing/OSWatcher/CHM etc.
- Strong knowledge of database upgrade/migrations.
- Strong knowledge in using Backup and recovery tools(RMAN/EXPDP/IMPDP)
- Strong knowledge of Oracle DataGuard Physical Standby configuration, build and support including DataGuard Broker and replication.
- Knowledge on database programming and query troubleshooting.
- Knowledge on Oracle Enterprise Manager.
- Experience in managing Database in AWS cloud environment.
- Experience in Oracle Exadata
- Experience in writing Shell scripts.
- Have good written/oral communication and soft skills.
- Oracle certification can be plus.
Additional Information
Epsilon is a global data, technology and services company that powers the marketing and advertising ecosystem. For decades, we’ve provided marketers from the world’s leading brands the data, technology and services they need to engage consumers with 1 View, 1 Vision and 1 Voice. 1 View of their universe of potential buyers. 1 Vision for engaging each individual. And 1 Voice to harmonize engagement across paid, owned and earned channels.
Epsilon’s comprehensive portfolio of capabilities across our suite of digital media, messaging and loyalty solutions bridge the divide between marketing and advertising technology. We process 400+ billion consumer actions each day using advanced AI and hold many patents of proprietary technology, including real-time modeling languages and consumer privacy advancements. Thanks to the work of every employee, Epsilon has been consistently recognized as industry-leading by Forrester, Adweek and the MRC. Epsilon is a global company with more than 9,000 employees around the world.
Our pillars aren't just words. They're how we show up every day.
- People centricity: We focus on employee well-being in an environment where colleagues truly care about each other.
- Collaboration: We work together, support one another, and collectively achieve goals.
- Growth: There are endless opportunities for growth through learning, development and career advancement.
- Innovation: We drive progress through cutting-edge solutions and forward-thinking approaches.
- Flexibility: We’ve created a balance between work and personal life, and we encourage adaptability to solve problems creatively.
Our values guide us to create value for our clients, our people and consumers.
- Act with integrity
- Work together to win together
- Innovate with purpose
- Respect all voices
- Empower with accountability
These pillars and values are our foundation—shaping our culture, guiding our decisions, and uniting us in common purpose.
Epsilon is an Equal Opportunity Employer.
Epsilon is committed to promoting diversity, inclusion, and equal employment opportunities by using reasonable efforts to attract, recruit, engage and retain qualified individuals of all ethnicities and backgrounds, including, but not limited to, women, people of color, LGBTQ individuals, people with disabilities and any other underrepresented groups, traits or characteristics.