Lead Database Administrator

Job Summary

Overview 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 Epsilons 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 clients 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

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.