Serve as the primary database administrator (DBA) and subject matter expert for all the systems based on Oracle Technology including databases, applications and enterprise data warehouse (EDW). Define standards to manage multiple relational database management system (RDBMS) on various operating systems. Provide input on and design new implementations in collaboration with vendors, infrastructure and application support teams in on premise, cloud and hybrid environments where appropriate. Work with Project Managers on work prioritization and assign tasks to the team members and make sure to complete them successfully. Assist I.T. Management in day-to-day operations including timesheet management, ticket resolution and work allocation.
Oversee all aspects of Oracle database system design, implementation, troubleshooting, and administration. Lead and mentor the team members to provide tier 2 and 3 support for all corporate Oracle database systems and services to meet or exceed service level agreements. Develop, install, maintain and monitor company databases in a high performance/high availability environment while supporting enterprise projects. Provide general database design, implementation and administration to assure highest reliability and availability of I.T. services. Maintain database backup/recovery procedures and disaster recovery database environment.
Develop and support procedures for database security. Conduct database capacity planning, record archival, and storage monitoring regularly. Implement and support database software upgrade and patch management procedures.
Document database specifications, licensing, configuration and infrastructure. Develop processes, procedures and guidelines for troubleshooting database events and performing tasks.
Evaluate and seek solutions to production issues as wells as new projects. Work closely with application developers and project managers in solving production issues.
Perform other duties as assigned.