SUMMARY:

• Leverage 8+ years of experience - A multi-skilled professional with a superb track record of managing complex database projects in Finance,MutualFund,Insurance environments.
• Able to manage stakeholder expectations and willing to take full responsibility for the delivering of project objectives.
• Working in 24x7 production environment and provided on-call and day-to-day support.
• Experience with VLDB with size up to 2 TB.
• Installation & Management of Oracle 10g, 11g, 12c, ASM, RAC cluster environment on Linux platform.
• Administering the database security, creating users, granting roles, privileges to users, extending the database storage capacity, and optimizing the performance.
• Analyzing Tables and Schemas, collecting statics, reorganizing tables and rebuilding indexes.
• Implementation of Backup and Recovery strategies for Oracle database using RMAN, exp/imp, Cold and Hot backups.
• Automating most of the daily activities through cronjobs, shell scripts or schedulers.
• Monitoring CPU utilization and heavy running application queries.
• Responsible for Backup and restoration of Oracle database.
• Implementing Audit policies from DB point of view as per the business rules/Hardening policies.
• Experience with database replication tools such as Oracle Golden Gate and Shareplex.
• Setup Physical Standby / Manual standby database for the critical PROD databases.
• Troubleshooting different Standby issues during the configuration & DR Drill.
• Analyze AWR and ADDM Report for database tuning.
• Performing DR-Drill on quarterly basis for the critical databases without fail.
• Implemented Graceful Switchover and Switchback feature for Manual Standby database.
• Implemented CASACADED Standby feature for one of the critical database.
• Implemented different 11g Standby features such as Snapshot Standby, Active Dataguard etc.
• Applying PSU patches to Oracle binaries and keeping binaries updated with latest BUG fixes.
• Refresh of databases on UAT environment using datapump.
• Performance tuning of database for dedicated SQL queries or jobs.
• Installation and configuration of 11g R2 Oracle ASM and Grid Infrastructure.
• Upgrading from 10g to 11g and 11g to 12c.
• Reorganizing tables and re-building indexes within databases whenever required.
• Migrating various versions of database (8i/9i/10g/11g/12c) on different platforms i.e. HP-UX, RHEL,SOLARIS and Windows.
• Upgradation of Grid Infrastructure and ASM from 11.2.0.4 to 12.1.0.2
• PSU patching on database and grid.
• Performing database online and offline database re-organization for database enhancement.
• Adding disks in ASM and monitoring the ASM diskgroups.
• Creating users & privileges with appropriate roles and levels of security.
• Monitoring and maintaining Flash Recovery Area (FRA) to meet the requirement.
• Documentation Report/Review - Site Documents, System Study, Backup Policy, Security Policy, Performance Management Document, Patch Management Document, Activity Report, Incident Report, Monthly Service Report etc.

PROJECT MANAGEMENT SKILLS:

• Commercial awareness & business acumen Experience of working in a multi-vendor environments
• Good conflict management and prioritization skills Manage technical process and resolve technical issues
• Can understand and document project requirements and dependencies Excellent documentation & report writing skills
• Demonstrated ability to work with and support cross-functional project teams
• Ability to manage multiple projects simultaneously and under pressure
• Strong attention to detail and focus on task completion Internal and External Stakeholder Management Capacity management Escalation resolver.

PERSONAL ATTRIBUTES:

• Team leader capable of motivating staff.
• Ability to get on with all levels of people and possess strong relationship building skills.
• Superb communication skills and able to articulate technical jargon to a non-technical audience.
• Ability to gain results through others. Knowledge of project management methods.
• Able to continuously meet targets and surpass expectations. Articulate and well presented.
• Having the necessary drive and enthusiasm required for a tough competitive industry Acting on client feedback.

PROJECT LEADER EXPERTISE:

• Single point contact for all database technologies. (Oracle,MSSQL,MYSQL,DB2,Middleware,OS)
• Client management & driving the client meetings.
• Managing any Client escalations.
• Driving scheduled client service review meetings, sharing the MOM & action plan.
• Implementation of recommendations & value additions.
• Finding the scope for Process automation to overcome manual intervention.
• Building the team technically as per project requirement.
• Allocation of resources ensuring continuity of services.
• To ensure necessary Pro-active Monitoring of the Database Application and OS is done and ensure uptime of 99.90% is maintained at all times.
• Provide support and minimize the downtime in case of severity issues.
• Identify the root causes of the issues faced and take necessary actions.
• Ensure appropriate backup policy is implemented at the client place and the contingency for the same is carried out regularly.
• To ensure Performance Benchmarking, Security Management, Patch Management as per the SOW and as per Processes are implemented at the client place and are quarterly reviewed.
• Ensure smooth operations of the database for existing systems and efficient sizing for upcoming projects.
• To provide necessary handholding and assistance to the team.
• To ensure all Documentation in connection to the service provided are updated on a regular basis. & discussion on the recommendations
• To attend all scheduled trainings of the Clover Academy and upgrade your knowledge
• Supporting the Clover End-to-End business cycle including - Pre-sales, system study, resource allocation & service reviews.
• To ensure team member's execute SOW activities as per the schedule.
• Following the industry standard processes & practices for maintaining the service quality.
• Adhere to the Company Policies & values to enhance the service level.
• Ensure smooth audit for the domain.
• Capacity planning for the database to ensure sufficient DB growth.
• Consolidation of database to save the Client Licensing cost.
• VAPT Testing for critical Applications.

TECHNICAL SKILLS:

RDBMS: Oracle 8i,9i,10g,11g,12c, RAC Systems

Operating System: HP-UX, RHEL server, Windows server 2003/2008.

Replication Tools: Shareplex, Oracle GoldenGate

DWH Tools: Informatica, Cognos

Backup Tools: Veritas Netbackup, Symantec Netbackup

Ticketing Tool: Sapphire

Infra Monitoring Tools: ManageEngine, Nagions, Foglight

Other Tools: SQL*PLUS, RMAN, Data Pump(EXPDP/IMPDP), ASM, OEM, Hp-Data protector(DP-Tool), Putty,TOAD, Microsoft Office (Word, Powerpoint, Excel)

PROFESSIONAL EXPERIENCE

Confidential

Project Leader L3 Support

Confidential

Project Leader L3 Support

Confidential

Sr. Oracle Consultant

Confidential

Oracle Consultant

Confidential

Technical Associate

Responsibilities:

• Database Management
• Client Management
• Vendor Management
• Process Automation
• Process Improvement
• Team Management