Summary

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.

Skills

Skills

System Administration (Unix, Windows, Virtual Machines)

✔ Support file systems on Unix. ✔ Storage management ✔ Build and support Oracle database on VM.

Oracle Database Administration

✔ Supported production, development, test, UAT databases. Solved issues as per ITIL methodologies. ✔ Solved Incident, Change, problem tickets with in strict SLA. ✔ 24*7 Database support (prod & non-prod) ✔Refreshing databases (data pump & RMAN) ✔ Database design and build ✔ Disaster recovery exercise ✔ Install oracle binaries ✔ Migrate oracle databases to different server ✔ Application of PSU & Bug fix patches ✔ Table partitioning ✔ Maintain database security ✔ Clone EBS application and apply on-off patch ✔ Reorganization of database , if database is fragmented

High availability solution(Data-Guard)

✔ Created and supported physical standby databases for RAC and standalone setup. ✔ Refreshed standby database from primary when standby database is lagging for few days. ✔ As per disaster recover practice, switched the database role so that standby database can serve as primary.

Performance Optimisation

✔ Performance and query tuning

RAC & Grid Infrastructure

✔Support RAC & grid related issues ✔Upgrade database & grid infrastructure ✔ Migrate 2 node RAC database to another server

Unix Shell & PL/SQL scripting

✔ Automated database and backup jobs through scripting. ✔ Created crontab jobs to monitor database behavior proactively and report in case of abnormalities. ✔ Programmed UNIX shell script to monitor database usage which helped for capacity planning.

Automatic Storage Management

✔ Support automatic storage management (ASM) ✔ Create or drop diskgroup. ✔ Migrate database from Non-ASM storage to ASM storage

Work History

Work History
Jan 2013 - Mar 2014

Database Administrator

Target Corporation

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.

Key Achievements:

♦ 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 11.2.0.4 version, without disrupting regular business. Ensured continuous improvement and subsequently resulting in increased stability.

Aug 2010 - Jan 2013

Service delivery consultant (Oracle DBA)

Hewlett Packard

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.

Select achievement: 

♦ 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. 

Jun 2006 - Jul 2010

Senior Database Administrator

Atos (formerly known as Atos Origin)

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.

selected achievement:

♦ 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

Certifications

Certifications
May 2014 - Present

Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator

Oracle Corporation
2007 - Present

Oracle 10G Database Administrator Professional

Oracle Corporation
2006 - Present

Oracle 9i Database Administrator Professional

Oracle Corporation
2007 - Present

ITIL Foundation Certificate in IT Service Management

Exin

Trainings

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

Education

Education
May 2002 - Apr 2006

Bachelor of Technology

National Institute of Technology