Title: Oracle DBA with PL/SQL
Location: Houston, TX(3 days onsite per week)
Type: Fulltime //Contract
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.