- Provide 24/7/365 primary systems dba support of all Oracle rac & standalone databases and related systems on Linux, Solaris x64, and AIX
- Support business and infrastructure changes on-call after business hours and weekends on a rotation basis for Oracle
- Support database hotline 7:30am – 6:30pm Monday – Friday on a rotation basis
- Comply with database security baselines and remediate vulnerabilities
- Plan and migrate EOL databases, patch databases required by Patching Committee
- Complete IV2 database migration
- Support IV2 databases with automation, patching and various requirements from APS
- Lead database development, tuning and optimization expertise to application development and support teams on an ah-hoc or continual basis.
- Contribute towards Architecture, Engineering of Db solutions. Develop, Document and Deploy Standards and Procedures to comply with Audit, Configuration, Industry and Security baselines.
- Proactively monitor all database systems utilizing vendor supplied and client standard tools.
- Maintain complete inventory, config and documentation of deployed systems.
- Engineer high availability Database Systems based on Oracle and SQL Server.
- Remediate database security baselines, policies, standard procedures and best practices.
- Work within the project management framework defined for IT Production North America.
- Cross train members of the Database team in all responsibilities and maintain a daily and weekly rotation schedule for these.
- Liaise with application and business clients to gather requirements, design and deploy standard systems which clearly differentiate between production, development, UAT, and DR.
- Identify operational and infrastructure risks within the environment and work with the application development team and business to make corrections and mitigate risks.
- Ensure that all systems are backed up and monitored according to the business requirements and notify the data owners when there are failures.
- Ensure optimal resilience of deployed systems and meet all disaster recovery and compliance requirements dictated by the business.
- Liaise with UNIX/Storage/Network Engineers in troubleshooting issues.
- Maintain top-notch technical skills and business knowledge through proactive self-learning in addition to any formal instructor-led training provided by customer.
- Interface with external vendors in troubleshooting complex, cross-platform issues.
- Provide comprehensive cross-training for engineers and support personnel on front-line database client troubleshooting and support
