Oracle Database Administrator

About Business Unit:

A consolidated team of database technology professionals, we provide expertise across all major database engines and Big Data solutions to support Epsilon products and platforms. The team has a unique alignment that combines a horizontal organizational structure with vertically aligned sub-groups dedicated to our clients. By adhering to consistent standards and best practices, the team ensures operational excellence and has close ties with product teams at Oracle, IBM, Cloudera, Amazon and Microsoft.

Why we are looking for you:

At Epsilon, we deliver excellence and create connections that last a lifetime. Our digital marketing arm, Conversant, is now growing and we are on the lookout for dedicated individuals who believe that every interaction counts - and want to make an impact on the future of our clients’ businesses.

So, are you someone who wants to work on the cutting edge of new-generation UI technology? Does the thought of working with Data Warehouse, Machine Learning, and Artificial Intelligence excite you? Then you could be exactly who we’re looking for.

Apply today and be part of a dynamic, enthusiastic and passionate team who want nothing more but to make a lasting impact on the lives of consumers. You will also get the opportunity to see your ideas come to life on almost every consumer device across the US.

What you will enjoy in this role:

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

What you will do?

• Full life cycle support of client's database(s). Database system applies RAC and non-RAC for OLTP and warehouse, Active DataGuard for DR, partitioning on 12c and 19c on premises and cloud environment.
• Oracle Exadata patching and maintenance experience is a must.
• 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

• 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 projects in a dynamic, fast paced and often changing environment.
• Strong design, development, administration skills.
• Strong knowledge on managing Automatic storage management.
• Strong analytical abilities to solve complex database performance issues using AWR/ASH/ADDM/TKPROF/SQLT/10046 tracing/OSWatcher/CHM etc.
• Strong 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 can be plus.