Senior Database Administrator

Senior Database Administrator

• 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

• 6+ 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.