Senior Database Administrator

Role & 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.

Preferred candidate profile

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