Lead Oracle Database Administrator (8-15 yrs)

Roles and Responsibility

1. Provide support and maintenance of applications and database to meet daily operational needs. May act as escalation point if needed

2. Troubleshoot performance, stability, and availability issues in a high volume and highly transactional database environment

3. Perform routine and regular application and database maintenance operations.

4. Install, upgrade, and configure applications and database software and replication and implement and maintenance complex database security

5. Manages databases through multiple product lifecycle environments, from development to mission critical production systems.

6. ERP, CRM, Database tuning, performance monitoring, capacity management and automation tasks

7. Apply application and database updates and stand-alone hotfixes to environments, as well as evaluate and make recommendations for improvement to processes for database management.

8. Conduct application and database maintenance, maintains database backups, while also triaging and troubleshooting database alerts and issues, identifying root cause, and launching corrective actions.

9. Independently analyzes, solves, and corrects issues in real time, providing problem resolution end-to-end.

10. Refines and automates regular processes, tracks issues, and documents changes.

11. Assists developers with complex query tuning and schema refinement.

12. Provides 24x7 support for critical production systems. Participates in an On-Call rotation as needed

13. Performs scheduled maintenance and support release deployment activities after hours.

Requirements:

1. Technical knowledge in application and database development methodologies, design and implementation and basic application and database administration skills/experience (procedures for change control, test and production release).

2. 7+ years Application and Database Server Administration experience

3. Experience with Performance Tuning and Optimization using native monitoring and troubleshooting tools.

4. Experience with backups, restores and recovery models.

5. Knowledge of High Availability and Disaster Recovery options for application and database technologies.

6. Experience migrating on-prem environments to public cloud (Azure-preferred)

7. Knowledge of best practices in the areas of application design, performance, security, scalability and maintainability

8. Excellent analytical and design skills.

9. Good skills in research and analysis, project planning and implementation. Excellent understanding of entire development process, including specification, documentation and quality assurance. An awareness of business issues as they impact overall project plans is necessary