Oracle DBA with PL/SQL

Job Description:

The 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.

• 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 the database environment.
• Oracle and AWS certifications is a plus.
• 10+ years of related experience with implementation and administration of database systems.
• Able to administer, manage and tune high-transaction and decision support 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 environment.
• Expert level database design, development and administration skills.
• Expert level knowledge of Oracle DataGuard Physical Standby configuration, build and support, including DataGuard Broker and replication.
• Expert knowledge of Oracle backup and recovery options and tools.
• Expert knowledge of managing automatic storage management.
• Proficient analytical and troubleshooting skills for complex database performance issues.
• Proficient knowledge of database upgrades/migrations.
• Proficient knowledge of database programming and query troubleshooting.
• Proficient knowledge of Oracle Enterprise Manager.
• Solid expertise in managing databases in AWS/AZURE cloud environment.
• Strong experience in writing Shell scripts.