Oracle DBA
Verizon Business
Contract Ashburn, Virginia, United States Posted 7 months ago
About Position
Oracle DBA (Contract)
$70.00 / Hourly
Ashburn, Virginia, United States
Oracle DBA
Contract Ashburn, Virginia, United States Posted 7 months ago
Description
Senior Oracle DBA with a minimum of 6 or more years of excellent hands-on experience to support on-premise and Cloud (OCI and AWS) with strong emphasis on Database performance tuning ,which includes: using hints, execution plans, write/re-write SQL, PL/SQL, identifying SQL regression, Resource Manager, reading various Oracle provided tools like OEM, SPA, AWR, ADDM, ASH. AWR-Diff, tracing and unix utilities like top, vmstat, sar etc.
Responsibilities
- Ability to support Production (24X7) systems and non-prod systems
- Ability to work efficiently in production support environment
- Ability to attend calls during off -hours
- Ability to provide weekly on-call support
- Well versed in Oracle Performance Tuning (P&T) with hands-on tuning experience in production environment
- Ability to write and review PL/SQL codes
- Thorough understanding of RMAN Backup and Recovery process
- Well versed in HA and DR solutions – RAC (GI, ASM), Oracle Goldengate, Physical Standby Database, ActiveDataguard
- Well versed in Oracle Goldengate (OGG) – Active/passive (one-way), Active/Active Install, setup, config, troubleshooting, admin
- Expert in various Database migration scenarios
- Experience in Cloud support and migrations
- Expert in Database installs, upgrades, and patching
- Ability to efficiently carry out BAU (day to day) DBA responsibilities
- Experience in Capacity Planning
- Ability to provide technical support to application development teams, Application DB release changes, Backout process
- Experience with Physical Database design
- Ability to understand Application architecture
- Pro-active and Reactive monitoring, Oracle Enterprise Manager (OEM) (Synthetic Monitoring)
- Troubleshooting Skills (process, scripts, commands) to quickly identify and resolve issues
- Oracle Security, Audit and security compliance
- Understanding of Storage technologies and Networking
- Well versed in Scripting (Shell, PL/SQL, Python)
- Good understanding of ITIL (Release Management, Change Management, Crisis Management, etc)
- Strong Linux/Unix skills
- Good understanding of DevOps, DB release automation for DevOps
- Understanding of Oracle Support process
- Exposure to Terraform, Jenkins, Sourcetree, YAML
- Experience with cloud automation
- Good documentation skills
- AWS certification is a plus
- Cassandra DB experience is a plus
By applying to a job using PingJob you are agreeing to comply with and be subject to the PingJob Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.
