- 5 years of experience as an Oracle DBA in production support environments
- Expert level understanding and hands on experience with Oracle Golden Gate on heterogeneous databases specifically Postgresql
- 2 years of experience administering PostgreSQL including performance tuning backup and recovery version upgrades and on call support
- Hands on AWS environment setup
- Knowledge on Cockroach DB would be plus
- Strong experience providing 24x7 operations and on call support
- Ability to work in a rapid paced high availability environment
- Strong analytical troubleshooting and defect resolution skills
- Strong communication skills and ability to collaborate with infrastructure application and vendor teams
- Oracle Database Administration On Premises and Cloud includes
- Performing physical Oracle DBA activities for databases used supported or maintained as part of Services including
- a Oracle database builds installations configuration and decommissioning
- b Configuring and supporting Oracle RAC environments
- c Creating and maintaining Primary and Standby databases
- d Performing schema changes through approved user requests
- e Executing Oracle database upgrades using defined tools and procedures
Key Responsibilities:
- High Availability and Disaster Recovery Management includes
- Configuring supporting and troubleshooting Oracle Data Guard environments including
- a Physical and Logical Standby configurations
- b Fast Start Failover FSFO setup and maintenance
- c Observer configuration and monitoring
- d Resolving Data Guard synchronization and failover issues
- e Supporting disaster recovery testing and activities
- Database Maintenance and Operations Support includes
- Maintaining databases to meet availability reliability and performance SLAs
- a Performing database health checks defect analysis and resolution
- b Taking and managing logical and physical backups
- c Proactive and reactive server and database maintenance
- d Ensuring database environments remain patched secure and compliant
- e Performing routine and emergency maintenance activities as required
- Monitoring Automation and Vendor Support includes