Vacancy expired!
Position: Sr. Oracle DBA Location: Remote Duration: 12+ months (Long Term) Rate: Open Interview: Video Position is remote but candidates must be willing to travel to Philadelphia for meetings as needed on their own expense. Must provide 24/7 support as needed. Hands-on "daily" experienced Oracle DBA with 10-15 years of experience with large OLTP databases providing 7x24 hour production support for databases that host multiple IIS web applications. Must be organized and have good communication skills, proactive problem solver, and working knowledge of high availability / failover architectures. Position is remote, onsite support, after hours, and scheduled weekends as needed. Essential Functions
- Database support for OLTP and Data Warehouse applications
- Database 19c installations on Windows and Unix in a multi-tenant environment
- Applying Quarterly Security patches
- Creating and working SR requests with Oracle Support
- Proactive monitoring of database performance, maintenance and reporting using TOAD, OEM13c and/or Foglight tools
- Working knowledge of Materialized Views refresh options and Oracle Job Scheduler
- Troubleshooting and diagnosing IIS application pool connectivity issues surrounding 'inactive and dropped sessions'
- Maintain, patch, and rebuild Data Guard physical standby databases
- Disaster recovery installation and support and testing different scenarios; like a Failover or Switchover
- Backup Strategies and cloning databases using RMAN "active duplicate" and Multi-tenant "hot cloning"
- Hands-on experience configuring and maintaining Golden Gate one-way replication environments
- Prior experience of configuring Oracle databases on AWS
- Prior experience of configuring Oracle19c databases on Linux
- Working knowledge of Postgres is a plus
- Working knowledge of SQL Server 2017 and higher databases is a plus
- Working knowledge of Cognos App/Reporting server is a plus
- Working knowledge of KRONOS software installations is a plus
- Prior hands-on DBA experience with databases that host IIS web applications.
- Installation of Oracle 19c software on Windows 2019
- Installation, testing and staging Oracle Quarterly security patches on Windows using Opatch utility
- Installation and configuration of SQL Svr gateways
- Installation and configuration Oracle client and ODAC client versions
- Maintaining and monitoring database storage structures (datafiles, tablespaces, tables, indexes, Mviews)
- Monitoring and managing production users and security
- Managing database backups, developing, and performing test recoveries
- Working knowledge of RMAN, configurations, creating jobs and levels of backups and use of Catalog
- Working knowledge of configuring, rebuilding and failover for a Physical Standby DataGuard
- Working knowledge of DR strategies; Failover, Switchover to an on-prem or cloud replica
- Proactive database monitoring and performance tuning of; tables, indexes, materialized views, scheduled jobs .
- Experience with monitoring tools; TOAD, OEM13c, Foglight, AWR
- Good communication and problem-solving skills
- Clear understandable documentation skills
- Ability to interact with other teams and managers
Vacancy expired!