Job description:

• 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