Oracle DBA with PL/SQL - Houston, United States - VySystems

Description

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.