Database Administrator

Publicis Groupe ANZ; Bengaluru; Hybrid; INR 1,100,000 - 1,500,000; Full time

Job summary

Epsilon is seeking a highly motivated Oracle DBA with a strong development background to join a fast-paced production support and full-lifecycle implementation team in Bengaluru. You will work on RAC and non-RAC environments, Active DataGuard for DR, and cloud/on-premises deployments, with emphasis on performance tuning and automation.

The role requires shell scripting, PL/SQL programming, backup strategies, and the ability to produce clear technical documentation while collaborating with

Qualifications

• 3+ years of experience with implementation and administration of database systems.
• Bachelor Degree or equivalent experience.
• Able to administer Standalone/RAC production server environments on-premises and cloud.
• Strong design, development, and admin skills.
• Experience with RMAN and data pump utilities.
• Knowledge of AWS Oracle on EC2/RDS.

Responsibilities

• Full lifecycle support of client databases (RAC and non-RAC) including OLTP and warehouse.
• Backups, design, development, testing, and performance tuning.
• Collaborate with developers to design and promote changes across DEV/UAT/PROD databases.
• Apply quarterly PSU patches and upgrades with minimal downtime.
• Participate in 24x7 on-call rotation and after-hours support.

Skills

Oracle DBA

Shell scripting

PL/SQL

Backup & Recovery

Performance tuning

Automation

Documentation

Communication skills

Education

Bachelor's degree

Tools

RMAN/EXPDP/IMPDP

Oracle Enterprise Manager

AWS Oracle on EC2/RDS

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.

About the Role:

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.

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.

Qualifications

• 3+ years of related experience with implementation and administration of database systems.
• Bachelor Degree or equivalent experience required.
• Able to administer and manage Standalone/RAC production server environment(s) on-premises and cloud environments.
• Able to understand and meet the needs of end-users.
• Able to work with multiple projects in a dynamic, fast-paced and often changing environments.
• Strong design, development, administration skills.
• Strong knowledge of database upgrade/migrations.
• Expertise in using Backup and recovery tools(RMAN/EXPDP/IMPDP)
• Knowledge of managing Automatic storage management.
• AWS Oracle database administration on EC2s and RDS preferred. Areas of knowledge would include, but not limited to, EBS storage, S3 storage, parameter groups, security groups, and option groups.
• Knowledge of troubleshooting database performance issues.
• Knowledge of Oracle DataGuard
• Knowledge of Oracle Enterprise Manager.
• Experience in writing Shell scripts.
• Ability to write clear, concise technical documentation
• Have excellent 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

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.