Installation of application schemas which include all the application database objects (eg. Store procedures; tables and index)
· Import/Export of application database request;
· Planning, sizing of application data growth and on-going needs;
· Support hourly DB refreshing processes
· Performance monitoring and reporting issues to various support teams;
· Provide DBA support and consultation to CGI AMS team.
· Troubleshoot production database related incidents
· Perform database reorganization as required to improve database performance
· Co-ordinate application of Oracle alerts with IBM DBC;
· Maintain application specific cleanups scripts and scheduling them for routine runs.
· Support regular database maintenance activities
· Participate in servicing database audit request
• Oracle Application and Database Cloning which includes all categories
• Upgrade /Migration
• Monitoring Database and Application Instances
• Proactive Monitoring of the Database, Application and Knowledge about monitoring tools
• Use of Code Moving Tools like Kintana
• Performance Monitoring and Collection – Staspack , AWR
• Knowledge and usage of OEM, OAM
• Documenting the Solution and work with Project Lead on the Deliverables
• Effectively communicate and define technology considerations within the context of business requirements.
• Maintain effective working relationships with Colleques and customers and third party service providers.
• Mentor junior staff on technology and best practices
• Ability to anticipate and proactively manage issues before they become major problems
• Advance Configuration setup
• Advance Configuration like DMZ
