Summary

• Over 9 years of hands on experience in Oracle 11gR2/10g/9i/8i, SQL, PL/SQL in production support, development and maintenance.
• Strong exposure as Production Support Role as sysdba in Multi user environment.
• Highly experienced in managing survival critical production databases and resolved the critical technical Issues affecting the production environment in timely manner.
• Experienced in understanding and analyzing business requirements and working closely with various application teams and business teams to develop ETL procedures consistent across all applications and systems.
• Exposure to Pharmaceutical, Healthcare, Retail, Insurance, Hospitality and Life Science domains.
• Actively involved designing and executing Disaster Recovery / Business Continuity Plan using Oracle Data guard with failover / switchover scenarios and other technologies like snap mirror, BCV sync and split.
• Sound experience on Oracle ASM Technology ASMLib setup, creating disks using oracleasm, migration and from file systems, moving database from one ASM disk groups to another, disk group management, adding/removing disks from disk groups, manual rebalance etc with variety of storages like IBM ESS series Storage DS8100/8300 and Shark with SVC SAN Volume Controller , HDS and EMC.
• Worked in environments of small 2 GBs size databases up to 7 TB Size Databases/DW.
• Extensive experience of setting up Oracle Enterprise Manager Grid Control and database control for monitoring, tuning and managing Oracle RAC and non-RAC Environments.
• Wide experience of Tuning and Optimizations for good Throughput and Performance including RAC/Cluster related performance issues.
• Experience with SQL Tuning and Optimizing database performance and finding hotspots with the help of AWR and statspack.
• Exposure with OLTP and Data warehousing environments.
• Experience designing and implementing Database security policy and Auditing on database with minimum impact on database performance.

Technical Skills

• RDBMS : Oracle 11g R1 and R2 , Exadata /10g/9i/8i/8,RAC, Dataguard,
• Oracle Tools : PL-SQL Developer 6.0, TOAD 8.5.1.6, Export Import Utilities, SQL Loader, SQL Navigator, TKPROF, Statspack, AWR, ADDM, Autosys Job Scheduler.
• Clustering : Veritas Cluster, IBM HACMP Cluster, Oracle RAC
• Monitoring /Tools : Sitescope, Grid Control, BMC Bladelogic Database Automation Suite BBDA
• ETL/BI Tools : Datastage 7.5, Microstrategy 8,
• Languages : SQL, PL/SQL, Java
• Operating Systems : Windows XP/Vista/07, NT/2000/03/08, All Flavors of Sun Solaris and RHEL, HP-UNIX
• Que Management : BMC Remedy, Service Desk
• Others : ITIL V3 Certified, Automation through shell scripting, Cron and Autosys, BMC Bladelogic
• Database Automation implementation Experience.
• Domains : Healthcare, Life Science, Insurance

Professional Experience

Confidential

Database Contractor

Responsibilities:

• Moving the single instance databases to clustered environment through upgrades and export, responsible and accountable for the full life cycle from Development through Production, project required constant communication with data center and multiple groups.
• Also involved in a project for migrating a datacenter for whole Prod environment without affecting ongoing production.
• Fulfilling request from different database user groups
• Planning and scheduling the database upgrade with precise execution plan responsible for managing SLA according to the severity of the incident.
• Responsible for managing IBM's HACMP clustered environment using AIX platform.
• Managing and Rebalancing of ASM disk for RDC and MDC sites as well as auditing, monitoring and reporting space on the disk.
• Responding to the database performance related issues reported by the users.
• Managing the project for implementing database security policy and enable auditing with reasonable performance drawback.
• Involved in day to day project meetings with multiple project involvement and managing the delivery deadline.

Confidential

Responsibilities:

• Monitoring and Handling the Scheduled Production support Jobs, Handled the production Abort jobs and respond as per SLA with doing investigation and Creating Tickets deciding the priority.
• Involved in Analysis of Production Issues and Providing root cause analysis and summary reports for Supply Management with Data Fix and Job Fix.
• Widely used Autosys for automation and as job scheduler where thousands of jobs running pretty much everything is scripted.
• Involved in Migration of Jobs from Dev/Stage to Production Environment.
• Involved in creating, upgrading, patching, decommissioning of the databases.
• Responsible for planning and conducting DR testing activities for the DR servers.
• Responsible for creating and documenting all the database related issues for the team.
• Interact with the clients in order to understand the requirement and suggest solutions.
• Close communication with other supporting groups like UNIX SA, Storage, Autosys Group, Netbackup team, all the task performed through constant communication with groups and clients involved.
• Support includes lots of communication and documentation. Communicating to the Supporting groups and customers across the globe.
• Responsible and accountable for managing more then 1500 databases across 500 servers.
• Scheduling jobs through Autosys, Cron and Oracle Enterprise Manager responding to job failures and alerts for the jobs through Autosys, Managing Prod and Dev consoles for Autosys. More then 50,000 jobs running through Autosys console.
• Write JIL command for Autosys jobs, schedule jobs for the new database, also disable the jobs for the decommissioned databases.

Environment: 3node Rac, 6node Exadata, Oracle 8i to 11gR2, BMC Remedy, Autosys, RMAN, BCV Sync and Split, BCV cutover, Dataguard, Veritas cluster, OEM, ASM,

Confidential

Database Admin

Responsibilities:

• Handling Installation and creation of new oracle databases, 2Nodes/3Nodes/4Nodes Oracle 9i /10g/ 11g RAC, Oracle Data guard. Adding Nodes in Present RACs
• Preparing OS Environment for Database, especially RAC environment doing through testing of all RAC nodes using FEMA guidelines at Server Level, Interconnect, Failover/load balance and Database level.
• Installing OCFS, Formatting Storage, converting to OCFS. Mounting OCFS Devices.
• Setting up ASM for 10g RAC
• Setting up 9i OEM environment and 10g Grid and 10g Database Control
• Up gradation, migration, cloning and patching of Databases, RAC and Data guards.
• Database Fail over / Switch over activities for maintenance and time-to-time DR drills with Oracle9i/10g Data guard.
• Maintaining up-to date security of the Oracle Database applying Critical Security Patch releases by oracle. Testing applying patches bug fixes for new releases.
• Sql Tuning also resolve the issues related to poor database performance
• Backup, Restoration, Cloning and Recovery in different scenario.
• Hot and Cold backups
• Backup and Recovery with and without RMAN
• Complete / Incomplete Recovery.
• Automated backup scripts running through Autosys.
• RMAN with different MML Clients like Veritas, TSM, Commonvault
• Continuous monitoring of Database Performances and identifying any bottlenecks hindering the performance of the database

Environment: Oracle 10g,11g, sun Solaris 9/10, Linux4-5, HP-UX

Confidential

Database Admin

Employed by the IT Division of pharmaceutical manufacturing high quality pharmacy products and selling it domestic as well as worldwide. Job includes daily database related activities and ERP Development maintenance Support. Application implementation over various branches and In-house development using D2k and Windows NT as OS.

Responsibilities:

• Involved in Requirements Analysis, Coding, Testing and Code Review.
• Was responsible for PL/SQL coding, writing procedures, functions and packages in development phase and involved in maintenance during warranty period.
• Design the Users security Role matrix Wrote the FGAC package Policy for the different Users as per the business requirements.
• Performance tuning of SQL using TKPROF and rewriting sql.
• Used advanced features like BULK collections, DYNAMIC SQL.
• Responsible for creating Databases, Users, Indexes, SQLs.
• Developed scripts for the deploying the database objects like tables, view, packages, procedures and functions on development and production environment.
• Leading and managing development team and Task allocation monitoring.
• Provided technical guidance to the team.
• Planning and Leading for all testing activities in the project.
• Attended progress calls review meetings.

Environment : Oracle 8i, 9i Windows Linux based Server