- Melbourne VIC
- +61 (0) 481 235 655
- [email protected]
I am oracle certified and result oriented professional with an extensive 8 years of knowledge and demonstrated competencies in infrastructure analysis, production support, design and development of superior database architecture. I am experienced in supporting "Business Critical" production database support. I have worked under ITIL methodology ,worked on incident, change, problem management, and solved database issues with in strict SLAs . I have excelled in complex systems migration, specialise on RAC & Standalone database (8i, 9i, 10G, 11G), experienced in replication and standby database with data guard setup.
Apart from Oracle database administration, I have worked on Oracle E-Business suite, and also exposed to MSSQL 2008.
Selected for Target technology services department, reported to service delivery manager, role encompassed handling various databases and leading projects as single point of contact whilst liaising with multiple stakeholders. Scoped business requirements, whilst creating functional specifications for complex database environments.
♦ Managed Conflicting Stakeholders’ Expectations; analysed and anticipated production database issues. Proposed system changes, persuading advisory board and deploying changes, subsequently preventing costly outages.
♦Improved Compliance Processes; initiated quality assurance inspection by creating comprehensive pre-delivery checklist, resulting in reliable backup configurations and increased client satisfaction.
♦Enhanced Application Outcomes; designed and rolled out questionnaire, capturing end user needs, ensuring complete alignment with project deliverables, resulting in reduced errors, and improved communication flow.
♦Stabilised Database Structure Up to 95%; implemented UNIX shell scripting, automatically monitoring OEM agent performance, resulting in efficiency and costs saving by at least 900 hours of manpower per quarter.
♦Developed Customised Data Extracts; eliminated troubleshooting cases by 100%, by developing programs using PL/SQL, whilst inserting data in remote systems, subsequently enhancing business outcomes.
♦Undertook Capacity Management Planning; minimised storage requirement costs, managing optimum database space. Analysed data growth, forecasting volumes whilst generating trend reports and deploying solutions.
♦Upgraded System with Zero Downtime; Upgraded 8 Oracle clusterwares to 18.104.22.168 version, without disrupting regular business. Ensured continuous improvement and subsequently resulting in increased stability.
Contributed to IT Operations Pyramid and provided valuable and attentive database administration. Notably applied skills and dedication through 24*7 shifts supported varied clients as per ITIL Process. Main tasks included; tracked Openview Service Desk/Centre, incident handling, trouble shooting, service calls and Change tickets created. Prepared UNIX Shell scripts to monitor and maintain environment, automated database jobs reducing people costs.
♦ Delivered Under Pressure; demonstrated multitasking expertise by undertaking restorative measures, liaising with vendors, and providing periodic updates to management whilst taking swift, system reinstatement actions.
♦Implemented Automatic Data Monitoring Procedure; mitigated database supervision risks by preparing and utilising shell script program, averting human error possibilities and subsequently enhancing database robustness.
Managed Operations department of India and Netherlands as a Database administrator and supported European based clients. Provided database support as per ITIL methodologies, collaborated with internal and external stakeholders, including vendors and Oracle support team, delivered positive outcomes through trouble shooting and critical database issue resolution. Led and mentored junior staff to ensure team productivity and goal realisation.
♦ Awarded Customer Hero for exceeding customer expectation.
♦ Resolved all incidents with in SLA.
♦ Carried out all Change Management activities like installation, up-gradation, database refreshes, user management, database creation etc
Was deputed to Atos , Netherlands site to provide onsite support to client, and complete knowledge transfer on Client's EBS application to offshore location.
MySQL for Database Administrator Ed 2 PRV; Oracle University, 2012
Oracle 11g Performance Tuning; Oracle University, 2011
Oracle 10g RAC for Administrators; Oracle University, 2010
Install, Patch and maintain Oracle application; Oracle University, 2007
Oracle 9i SQL, Fundamentals I, Fundamentals II, Performance Tuning; SQLSTAR, 2006