Lead Database Administrator

Publicis Groupe ANZ; Bengaluru; Hybrid; INR 1,800,000 - 3,200,000; Full time

Job summary

Epsilon is seeking a Lead Oracle DBA with a strong development background to join a fast-paced production support and full-lifecycle implementation team in Bengaluru. Responsibilities include RAC/Non-RAC OLTP and warehouse deployments, data guard for DR, cloud and on-premises environments, and performance tuning with automation focus.

The role requires 8+ years of relevant experience, PL/SQL, RMAN, and Oracle Cloud Certification as a plus.

Qualifications

• 8+ years of related experience with implementation and administration of database systems.
• Strong development background and ability to work with developers to support app enhancements.
• Experience with Oracle RAC/Non-RAC, DR, and cloud environments (AWS/Azure).
• Proficient in PL/SQL programming and backup/recovery tools.

Responsibilities

• Full lifecycle support of client's database(s) including on-premises and cloud deployment.
• Design, implement, test, and tune database systems for performance and reliability.
• Collaborate with developers to design new structures and promote changes across DEV/UAT/PROD.
• Apply quarterly patching (PSU) and perform upgrades with minimal downtime.
• Participate in 24x7 on-call rotation and after-hours support.
• Proactively automate repeated tasks to improve efficiency.

Skills

Oracle DBA

PL/SQL

Cloud AWS/Azure

Shell scripting

Backup & recovery

Performance tuning

DataGuard/DR

Exadata

Automation

Oracle Enterprise Manager

Education

Bachelor degree or equivalent

Tools

RMAN/EXPDP/IMPDP

AWR/ASH/ADDM/TKPROF/SQLT

OSWatcher

DataGuard Broker

Job description

About Business Unit

At the core of all that Epsilon does is a team that sets the foundation of our IT infrastructure. The team drives innovation and efficiency through pioneering technology across Epsilon's platforms and business verticals. From being the first point of contact for infrastructure needs to final deployment, the team provides end-to-end solutions for our client-facing platforms. ETS supports all aspects of revenue-generating platforms for Epsilon and sets the architectural direction for our enterprise deployments. By adopting the newest technologies, such as Cloud, Automation, and Artificial Intelligence, the team is at the front of redefining our digital business and capturing new opportunities.

About the Role

Seeking a highly motivated and well-rounded Lead 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.

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

• 8+ 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 projects in a dynamic, fast paced and often changing environment.
• Strong design, development, administration skills.
• Should have excellent knowledge on Cloud(AWS/Azure)- Must to have.
• 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.
• Knowledge on Oracle Exadata
• 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 writing Shell scripts.
• Have good written/oral communication and soft skills.
• Oracle certification & Cloud Certification is 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.