SUMMARY

• Over 20 years of IT work experience, which includes database administration under Windows, UNIX and Linux platforms and software development with Oracle 11g/10g/9i/8i and as a data analyst
• Experience in database architecture, design, development and deployment.
• Experience in installation, upgrading and migration of Oracle 11g, 10g, 9i/8i.
• Experience in complete range of Oracle DBA activities including day-to-day production database monitoring, backup and recovery using RMAN, troubleshooting production issues, Performance tuning, physical database design, table space administration, cloning and managing data dictionary objects. Extensive SQL and PL/SQL skills.
• Creation and modification of database objects such as tables, indexes, views, sequences, functions, procedures, triggers, stored procedures, packages.
• Setting up the complete database security implementation and troubleshooting Oracle Technologies as an Oracle DBA on OLTP and OLAP environments.
• Backend programming in PL/SQL for stored procedures, packages, triggers and functions.
• Experience in creating standby database using Data Guard.
• Hands-on experience in taking hot/cold backup and recoveries.
• Experience in loading external files to the Oracle database.
• Export and import of database objects, schema and database itself using export/import utilities and Data Pump expdb and impdb utilities.
• Efficiently handled space management, size and capacity planning in different versions of Oracle databases.
• Specialization in Oracle performance tuning using OEM, TOAD, AWR, ADDM, and Statspack.
• Experience in audit trails, Oracle alert and patch management.
• Cloning of databases using RMAN.
• Build transactions replication between two Oracle databases on different platforms using Oracle Golden Gate.
• Experience with Oracle Real Application Clusters, Parallel Queries, Materialized Views, Partitioning and Grid Control.
• Tune databases performance using OEM Grid Control
• Schedule backup, jobs using OEM Grid Control
• Recovery database using OEM Grid Control
• Check availability of the database using OEM Grid Control
• Check storage size using OEM Grid Control
• Experience in implementing the Oracle RAC with multi node cluster in ASM environment, monitoring, tuning and load balancing RAC environment.
• Experience in developing UNIX/Perl Shell Scripts, UNIX system administration.
• Management of multiple projects and personnel along with analysis and development within all phases of SDLC.
• Good communication, interpersonal and problem solving skills.

Technical Skills:

• DBMS: Oracle 9i, 10g RAC and 11gR2, Sybase ASE,DB2
• DBMS Tools: Recovery Manager RMAN , Data Pump, OEM, Grid Control, Toad, Dataguard, DBArtisan 5.4, SQL Plus, SQL Developer, SharePlex For Oracle and ERwin Modeling
• GoldenGate Tools: GGSCI, DEFGEN, Logdump, OBEY file, Reverse
• Operating System: UNIX SunOS, Solaris, HP-UX, Linux, IBM AIX
• Windows 2000/2003/2008/2008R2
• Software: GoldenGate11g, HPService Manager, Control-M, Autosys, MQSeries,
• Languages: OBEY file, SQL Plus, SQL Loader, PL/SQL, C, Perl, UNIX Shell, sed/awk,

Professional Experience:

Confidential

Sr. Oracle Database Administrator

Technical Environment:

• Conducted Database and SQL Performance Tuning in oracle RAC environment using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
• Responsible oracle databases running on Windows / UNIX HP-US, Sun Solaris, - IBM AIX 5L /Linux RedHat
• Lead Implementation project on High Availability solutions with Oracle 10g/11g RAC, Physical and Logical Standby Databases Data Guard and Replication using Oracle GoldenGate 11g.
• Built QA DEV environments via cloning using Oracle RMAN duplicate utility features. Perform several logical database refresh using Oracle Data Pump and Transportable Tablespaces tools for development and testing database.

Responsibilities:

• Responsible for providing design/developing and consulting services to a very large, high profile, global trade repository application.
• Responsible for identifying regressed SQL statement and suggesting appropriate solutions using SQL Tuning Advisor.
• Responsible for advising developers how to code optimal SQL.
• Responsible for performance tuning of PL/SQL with the help of Oracle tools set.
• Responsible for monitoring the performance of the database servers and applications.
• Responsible for recommending changes to improve performance at both the database server and application level.
• Reviewing Review existing database designs and recommend appropriate enhancement to support SQL access to the data.
• Review regressed SQL statement access paths to predict performance using SQL Performance Analyzer SPA .
• Responsible for Best coding practices and developing PL/SQL and analytical functions
• Application design and review for performance and scalability
• Responsible in Capacity planning and bench marking, excellent experience in performance tuning Application/development DBA working with development team supporting deployments database components including package, maintain user role/profile, material view, triggers, indexes, etc. to support project development effort.
• Work with development teams on all aspects of database design including tables, partition tables, views, Materialize view, stored procedures, packages and manage role based grants. Document and provide development best practices.
• Developing and maintaining standards SOE and comply with company's Audit requirements
• Conducting weekly meeting customer to meet expectations while handling complex projects with requirements that change and evolve in a quick pace

Confidential

Sr. Oracle Database Administrator

Technical Environment: Oracle 8i/9i/10g/11g, HP-UX, IBM AIX, SQL, PL/SQL, ERwin, TOAD, OEM, SQL Developer, SQL Loader, RMAN, Statspack, Data Guard, Shell Scripts, Grid Control, AWR, ADDM,SPA

Responsibilities:

• Involved in the design, review, implementation, testing, and release of databases, design specifications, and application software.
• Installed, up-graded Oracle 9i, 10g, 11g software in different environments, creating and maintaining Oracle development and test databases.
• Clone the databases using RMAN
• Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.
• Work with the application team and the business team in determining the requirements and solving all kinds of database and data issues
• Work closely with the vendor to get the required fixes and patches to the application
• Monitor the databases using Sitescope and BAC
• Manage the databases using OEM
• Developed the shell scripts to load the data coming from the vendor into the databases
• Involved in online and offline backups, and recoveries of various oracle databases using export and import utility
• Provide guidance to the Production DBA on how to work on the databases
• Used Automatic Workload Repository AWR and Automatic Database Diagnostic Monitor ADDM for performance tuning.
• Worked with data modelers in modeling the database using CA-ERwin.
• Ensured security of the database by creating profiles for each user and monitored the user sessions.
• Automated the running of jobs through Control M
• Interacted with development team in fine tuning the SQL and PL/SQL code.
• Wrote PL/SQL Scripts for running application specific monitors through Sitescope
• Worked on Oracle External Tables
• Extensively worked with performance tuning and memory SGA and PGA tuning, optimizing and troubleshooting of databases.
• Work on and manage the DR tests both from application and database standpoint
• Analyzed tables and indexes of Oracle database periodically for better performance.
• Migrated the code as well as the data from one environment to another depending on the Application team's request
• Wrote Unix shell scripts and Windows batch scripts required for functioning of the applications

Confidential

Sr. Oracle Database Administrator

Technical Environment:

Responsibilities:

• Involved in the design, review, implementation, testing, and release of databases, design specifications, and application software.
• Installed, up-graded Oracle 9i, 10g software in different environments, creating and maintaining Oracle development and test databases.
• Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.
• Installed Oracle 10.2.0.4 with multi nodes RAC in ASM storage with normal redundancy.
• Managed CRS Clusterware, ASM, Installed DB Control and OEM control Grid control. Involved in Oracle Partitioning.
• Involved in online and offline backups, and recoveries of various oracle databases using export and import utility.
• Extensively involved in Oracle database exports and imports.
• Worked with the Recovery Manager, RMAN and OEM in recovering the Oracle database.
• Involved in loading external files into the Oracle database using SQL Loader.
• Created standby databases for disaster recovery using Data Guard.
• Used Automatic Workload Repository AWR and Automatic Database Diagnostic Monitor ADDM in RAC for performance tuning.
• Upgrade of RAC database from Oracle 9.2.0.8 to Oracle 10.2.0.4.
• Experience with CA-ERwin in modeling the database.
• Ensured security of the database by creating profiles for each user and monitored the user sessions.
• Resolved the database issues of the users whenever in need of.
• Developed stored procedures, triggers and packages in PL/SQL
• Created PL/SQL Scripts for static data, views, and synonyms.
• Involved in troubleshooting everyday problems in the 24X7 environment.
• Extensively worked with performance tuning and memory SGA tuning, optimizing and troubleshooting of databases.
• Analyzed tables and indexes of Oracle database periodically for better performance.
• Used Oracle backup utility RMAN to implement Oracle backup and performed a number of disaster recoveries

Confidential

Oracle Database Administrator

Technical Environment:

Responsibilities:

• Installed and configured Oracle 10g for Production, QA, Development and testing purposes.
• Setup and configured Data Guard Physical Standby database .

Confidential

Oracle Database Administrator

NMHC offers expertise in pharmacy benefits management, health information management, home delivery pharmacy and specialty pharmacy, along with a deep understanding of client and member needs. NMHC provides service to nearly 8 million lives.

Technical Environment:

Responsibilities:

• Installed and configured Oracle 10g for production, QA, and development and testing purpose.
• Designed and configured Data Guard Physical Standby database .
• Troubleshot database and raised Service Requests with Oracle support and applied patches.
• DSS Decision Support System , PHIP OLTP System
• Clinic On-Line Transaction Processing System
• National Medical Health Card NMHC

Confidential

Technical Environment:

• CitiDirect is global 24X6 online banking systems that users access from approximately 300 countries globally, with a contingency site COB .
• Maintained database baselines of various application versions for change management, administration, and implementation of security controls Database Code Promotion into Quality Assurance, UAT and production on CitiDirect major releases.
• Provided database high availability planning and deployment.
• Supported and maintained Oracle 9i Real Application Cluster RAC .
• Developed and modified Oracle backup and recovery scripts.
• Used Oracle backup utility RMAN to implement Oracle backup and performed a number of disaster recoveries.
• Performed large terabyte database backup including physical backup via Hotbackup/ColdBackup of Oracle Database on Raw Devices using dd, and compress and logical backup using multiple streams Export / Import.
• Supported EMC TimeFinder that established/split Standby database to create production images for Quality Assurance testing Post and Pre Image using BCV, and implemented several scripts to build post-image, pre-image and copy of production environments.
• Designed and developed UNIX shell scripts using awk, sed, and tr to automate wide range of tasks including administration, backup, monitoring, troubleshooting database issues, and executing background, and batch process round the clock.
• Optimized and fine-tuned database server by planning storage requirements, partitioned large tables by range and by list, created materialize views, and indexes where make sane.
• Provided 24x6 production support onsite, offsite and rotational on-call support.
• Configured TAF to fail-over to surviving node, when one of the nodes fails.
• Configured and monitored standby database for disaster recovery.
• Designed, developed, implemented, and maintained schema migration generator and equalizer. OracleChange, Quest and Patrol were too slow for 'Schema of 700 objects' to create DDL for all objects including tables, constraints, view/pros, static data migration from 5-DEV to 3-QC to 2-UAT to Production Environments.

Confidential

Technical Environment:

• Consolidated small tier UNIX servers ultra-2, 420, 480 into higher-end UNIX machine 25K is expected to manage, support, and house numerous servers, replacing need for numerous smaller machines, resulting in approximately 41 savings in machine chargeback costs and higher system availability due to capacity on-demand features.
• Represented and coordinated group of DBA to migrate 23 instances and approximately 100 schemas.

Confidential

Technical Environment:

• Supported GEN05 and GEN06 production servers under General Service's umbrella with various set of applications on each: On-Line Print and Label System, Logic Chargeback, Client Server Citigroup look up Interface Program, Print Request System, and Invoice Processing System.
• Supported First line of contact for production support and development support for GEN05 and GEN06.
• Installed and upgraded Oracle 9i to oracle10g on UNIX, created databases, allocated database devices.
• Migrated database maintenance cronjobs to Autosys, troubleshot database backups, dumped/loaded database and log, maintained user/group, assigned privileges, and handled Oracle error logs .

Confidential

Technical Environment:

• Provided first line of contact for production support and development support for Compliance/Legal, Distributed Margin System and Distributed System group.
• Supported full project life cycle as Database Administrator, including data modeling using ERwin for logical and physical database design and implementation database backup and recovery application and system performance monitoring and tuning.

Acted as MQseries SystemAdministrator.

Installed MQSeries on UNIX, created MQmanager, and set queues and channels.

Confidential

Technical Environment:

• Installed and upgraded SYBASE SQL Server System 10.2 11.3.2 on UNIX, allocating database devices, create databases, maintaining and troubleshooting SYBASE server database backups, dumping/loading database and log.
• Maintained user/group, assigned privileges and handling dbcc output