SUMMARY:

• With more than 7 years of IT experience as Oracle Database Administrator on a variety of UNIX (Solaris, HP - UX, IBM-AIX), Windows NT 4.0/2000/2003 with Oracle (9i, 10g, 11g) 11g/10gRAC, Data Guard, Installation, Configuration, Migration, Capacity planning, Backup and Recovery, Performance tuning and troubleshooting.
• Extensive experience of working on Oracle 9i, 10g and 11g on Sun Solaris, UNIX, IBM AIX, HP-UX, Red Hat Linux, and Windows.
• Install Configure and deployment of Oracle 11g database and Real Application Clusters (RAC) on different nodes with ASM (Automatic Storage Management) on RHEL 5 & HP-UX Itanium 11.31.
• Experience of Install, Configure and Create SQL Server Database for SQL Server 2000, SQL Server 2005, SQL Server 2008 and 2008 R2 Version.
• Setup physical stand by database using Data Guard for disaster recovery.
• Knowledge of the Oracle GoldenGate installation, configuration, troubleshooting GG issues.
• Installed and maintained GoldenGate products, including patch application and upgrade of the environments.
• Establishes standards, policies, and procedures for GoldenGate replication administration.
• Installation and Configuration of 11g and 10g Grid Control.
• Expertise in Oracle Enterprise Manager and setup of Oracle Grid Control for monitoring VLDB (Very Large Databases).
• Experience in full life cycle of database administration. Worked both as a development and Production Support DBA.
• Installed OMS for the access of the Oracle Grid Control.
• Build DICOM (Digital Imaging and Communications in Medicine) content enabled Electronic Health Records (EHRs) for secure and efficient sharing of images while sharing patient data.
• Experience in Oracle Relink using Traditional Relink and using OUI.
• Expertise in Database Replay workflow to test database configuration changes and hardware changes.
• Implemented and configured Oracle streams in between different version of database.
• Written Perl Script for scheduling varies SQL queries, processing unknown bill files and their related data in Oracle database. Assisted development team on debugging or updating existing programs
• Experience with PostgreSQL for point-in-time-recovery.
• Laying out database tables and database schema design, startup and shutdown of Databases.
• Hands on experience in Managing Tablespaces, segments, extents, and indexes.
• Good Knowledge in Setting PFile & SPFile parameters, maintaining Data Files, Control Files, and Redo Log Files.
• Managing Oracle Net Configuration, monitoring Alert Log Files, Listener Log, Redo Log status, and Trace files for the database.
• Monitored and tuned Rollback segment, temporary tablespace, redo log buffer, sort area size
• Maintained Users and Roles with Appropriate Privileges and Profile.
• Designed and implemented Backup and strategy using RMAN (Recovery Manager)
• Experience in advanced recovery methods like PITR using Flashback.
• Logical backup using and full/ partial backup export/import and Data Pump in Oracle 10g.
• Experience in Upgrade and Migration of oracle database and RAC to higher version installing patches.
• Experience in applying security patches to the databases using the Opatch Utility.
• Experience for upgrading SQL Server databases from SQL Server 2000, 2005 to SQL Server 2008 and 2008 R2 Version.
• Experience in applying Service Packs and Hotfix for various SQL Server Versions.
• Proficient use of Oracle Enterprise Manager (OEM) and Grid control for managing and monitoring Oracle database with the use of Oracle Text Manager.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Communicate with Oracle, generate RDA Report and Web conference for TAR Support.
• Efficient in SQL query optimization using explain plan, TKPROF reports, gathering statistics, pinning the objects.
• Designed logical and physical Data Models using ERWIN forward-engineered into DDL and executed on large scale to create database.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Experienced in 24x7 Environments. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.
• Excellent communication and interpersonal skills Good team player analytical, and presentation skills with strong aptitude towards learning new technologies.

TECHNICAL SKILLS:

RDBMS:

Oracle 11g, 10g, 9i, SQL Server 2000, SQL Server 2005, SQL Server 2008 and 2008 R2, Oracle Golden Gate Repository database, MySQL

OS:

Windows XP, 2000, SUN SOLARIS 8/9/10, HP-UX Itanium 11.31, Red Hat Linux 4/5, AIX 4.3, 5.2

Tools: TOAD, Putty, SQL Developer, SQL*Loader, EXP/IMP, Datapump Utilities,, SQL Navigator, Hummingbird, SQL Server Management Studio, FTP, SFTP, SSH, SCP, TELNET

DB Utilities:

RMAN, OEM Grid Control 10g/11g, Data Guard 10g/11g, Tkprof

Language:

SQL, PL/SQL for Oracle, PL/SQL for SQL Server, Shell programming (Unix - Korn, Bourne, Bash), C/C++. VC++, C#, COBOL, PHP, Python, Java, Perl Script, PostgreSQLWeb Technology:

VB, VB.Net, ASP, ASP. Net, ADO. Net, AJAX Toolkit, Silver light Application, WPF Application, MVC Application, WCF Service, Workflow Service, SharePoint, SOA ( Using SOAP and WSDL)

Scripting language:

Java Script, C# Script

Shell script:

Shell Script (Bourne shell & Korn Shell)

Enterprise Integration Technologies:

J2EE, JSP, JDBC, ODBC

PROFESSIONAL SUMMARY:

Confidential

Cumberland, RI

Oracle DBA / SQL DBA

Confidential, (NYSE: CVS) is an American drug retailing company with a U.S. pharmacy chain. CVS Caremark provides pharmacy services through its over 7,000 CVS/pharmacy and Longs Drugs stores; its pharmacy benefit management, mail order and specialty pharmacy division, Caremark Pharmacy Services; its retail-based health clinic subsidiary, Minute Clinic; and its online pharmacy.

Responsibilities:

• Worked for the Database security and compliance team, which involved certifying the newly built databases according to the minimum security baselines set at enterprise level for Oracle as well as SQL Server.
• Upgraded multiple standalone and RAC One 11.2.0.1 databases to 11.2.0.3.0 running various applications.
• Upgraded multiple SQL Server Databases from SQL Server 2000, 2005 version to SQL Server 2008 R2.
• Patched various versions of oracle databases like 10.1.0.5, 10.2.0.4, 10.2.05, 11.2.0.2, 11.2.0.3 with CPU and PSU bundles on platforms like AIX and Sun-Solaris.
• Applied various Hotfix bugs on SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
• Worked with upgrades of Grid infrastructure from 11.2.0.1 to 11.2.0.3 and applied PSU patch bundles to the grid using OPatch auto.
• Support from the DBA team on migrating databases for ongoing server consolidation effort to migrate physical servers to virtual environment.
• Actively participated in vulnerability management and uploading the evidences into Qualys “Archer” tool for Oracle and SQL Server Databases.
• Installation, configuration of Oracle 11gR2 RAC, ASM, Stand alone database and client.
• Worked for Incident & Problem Management and Change Release Management to meet business SLAs (Service Level Agreement).
• Expertise with hot backup, cold backup, TSM backup and Tivoli backup using RMAN-TDP and EMC’s Avamar.
• Expertise in implementing RMAN catalog for storing backup information.
• Worked on Backup and Restore for SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 Versions.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Refreshing development/test database from production using Export/Import. This is done so that the latest data is available in the development/test database.

Environment: Oracle 10g/11gR1/R2, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 008 R2, Solaris 5.10/5.8, AIX 5.3/6.1, Windows Server 2003, Windows Server 2008 and 2008 R2, VMware, Grid Control 10.2.0.5, OEM, RMAN-TDP, TSM and AVAMAR, SQL Server Management Studio

Confidential

Sacramento, CA

Oracle DBA

Confidential, is responsible for medical care for California’s state prison population. CCHCS reduce unnecessary morbidity and mortality and protect public health by providing patient-inmates timely access to safe, effective and efficient medical care, and integrate the delivery of medical care with mental health, dental and disability programs.

Role and Responsibilities:

• Installed, Configuration and deployment of Oracle 11g database and Real Application Clusters (RAC) on different nodes with ASM (Automatic Storage Management) on IBM AIX Power System 5.3.0.0 and AIX 6.1.0.0 .
• Upgraded RAC database from 10.2.0.5.0 to 11.2.0.1.
• Installed DICOM (Digital Imaging and Communications in Medicine) content enabled Electronic Health Records (EHRs) for secure and efficient sharing of images while sharing patient data to improve the reliability and performance of PACS systems used for local storage of diagnostic images and other DICOM content.
• Loaded DICOM content from other files and created DICOM format files from ORDDicom objects.
• Implemented active-passive clusters in a VERITAS Cluster server environment.
• Database replication and streams for distributed database system for fast availability and data protection using Golden Gate.
• Administers Golden Gate replication security
• Setting up schedule RMAN Backup using DBMS SCHEDULER and CRONTAB.
• Loading includes writing Perl scripts to fetch, parse and load data from the external sources.
• Database Cloning for Logical and Physical Standby server.
• Migrated Database from Microsoft SQL Server 2008 to Oracle Database 11.2.0.1.
• Migrated Database from MySQL to Oracle Database 11.2.0.3.
• Written PostgreSQL sub queries for point-in-time-recovery and multibyte character encoding.
• Installation and Configuration of 11g Grid Control.
• Grid control Integration with HP Open View & Sentinel.
• Using Flashback for Point-in-time Recovery.
• Memory management to increase performance of database.
• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support.
• Working for RDA Reporting for TAR Support.
• Applied CPU patches and using OPatch utility for database 10.2.0.5 Security.
• Wrote shell scripts for taking backup using Export/Import and Data pump Utilities.
• Worked on SOA Purge Scripts, Create Table As Select (CTAS) Scripts for BPEL Dehydration Store Purge Solutions.
• Performed Capacity monitoring and short and long-term Capacity Planning in collaboration with development resources, system administrators and system architects.
• Installed Oracle Universal Content Management for Image Management and Digital Asset Management.
• Worked on UNIX Shell Scripts, PL/SQL Stored Procedures, Functions and Triggers.
• Wrote Different Shell Scripts for Data Refresh for Development environment.
• Coordinating DBCR (Database Change Request) and DBUR (Database Update Request) for Non-Prod and Prod Environments.
• Followed Central Issue and Change Management Process for DEV, QA and STAGE Environment.
• Experienced with Verizon Business Total View Tool for Production environment to Create Change Tickets, Service Tickets and Problem Tickets.
• Used ERWIN for scripting physical data models from logical models. Converted Logical Data models into Physical Structure.
• Creating and Managing Users, Roles and Privileges.
• Monitoring Alert log files and other process of the Databases.
• Database Administration of Large size database (5 TB).
• Responsible for data integrity and concurrent data, locks and deadlocks.
• Providing 24 * 7 productions supports for different environment

Environment: Oracle 11g/10g, Red Hat Linux 4/5, HP-UX Itanium 11.31, RAC, Grid Control, OEM, Data Guard, RMAN, Exp/Imp, Data pump, Putty, cygwin, ERWIN, Spot Light, Perl Scripting

Confidential, Sacramento, CA

Oracle DBA

Confidential,Employees\' Retirement Systemprovides retirement, health, and related financial programs and benefits to 1.5 million public employees, retirees,and their families and more than 2,500 public employers.

Role and Responsibilities:

• Installation and configuration of Oracle 11g Database and Client.
• Installed, Configuration and deployment of Oracle 11g database and Real Application Clusters (RAC) on different nodes with ASM (Automatic Storage Management) on Linux RHEL & HP-UX Itanium.
• Implemented active-passive clusters in a Veritas Cluster server environment.
• Database replication and streams for distributed database system for fast availability and data protection using Golden Gate.
• Administers Golden Gate replication security
• Setting up schedule RMAN Backup using DBMS SCHEDULER and CRONTAB.
• Database Cloning for Logical and Physical Standby server.
• Perl scripting, shell scripting and PL/SQL programming to resolve business problems of various nature.
• Installation and Configuration of 10g Grid Control.
• Grid control Integration with HP Open View & Sentinel.
• Using Flashback for Point-in-time Recovery.
• Memory management to increase performance of database.
• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support.
• Working for RDA Reporting for TAR Support.
• Database upgrade from 10.2.0.3 & 11.1.0.6 to 11.1.0.7
• Applied CPU patches using OPatch utility for database patch maintenance.
• Wrote shell scripts for taking backup using Export/Import and Data pump Utilities.
• Worked on UNIX Shell Scripts, PL/SQL Stored Procedures, Functions and Triggers.
• Wrote Different Shell Scripts for Data Refresh for Development environment.
• Used PostgreSQL for programming interface with various language like Java, .Net, Python and Perl.
• Worked on MySQL for migration and import and export utility.
• Coordinating DBCR (Database Change Request) and DBUR (Database Update Request) for Non-Prod and Prod Environments.
• Used ERWIN for scripting physical data models from logical models. Converted Logical Data models into Physical Structure.
• Creating and Managing Users, Roles and Privileges.
• Tuning SQL statements using EXPLAIN PLAN.
• Monitoring Alert log files and other process of the Databases.
• Database Administration of Large size database (5 TB).
• Responsible for data integrity and concurrent data, locks and deadlocks.
• Providing 24 * 7 productions supports for different environment

Environment: Oracle 11g/10g, Red Hat Linux 4/5, HP-UX Itanium 11.31, RAC, Grid Control, OEM, Data Guard, RMAN, Exp/Imp, Data pump, Putty, cygwin, ERWIN, Spot Light, Perl Scripting

Confidential,NJ

Oracle DBA

Confidential, is a non-profit organization. IEEE is the world\'s leading professional association for the advancement of technology. The IEEE name was originally an acronym for the Institute of Electrical and Electronics Engineers. IEEE is a leading authority on areas ranging from aerospace systems, computers and telecommunications to biomedical engineering, electric power and consumer electronics among others.

Role and Responsibilities:

• Installation and configuration of Oracle Database Software 10g; Creation and configuration of database.
• Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle 10g Automatic Storage Management (ASM).
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Install and configure Oracle GoldenGate and Veridata.
• Experience with MySQL for migration.
• Cloned database from PROCUCTION to create TEST and DEVELOPMENT.
• Used Flashback for the Point In Time Recovery (PITR).
• Setting up of RMAN on the database to perform necessary back up.
• Administered Hot/Cold Backups on a regular basis.
• Wrote shell script to perform hot backup and schedule it with crontab.
• Written and updated some deploy or application scripts in Perl for various build, testing, and system management purposes
• Use Export/Import and Datapump utilities for full/partial backup.
• Also wrote a shell script for taking backup using Export/Import.
• Upgrading database from Oracle version 9i to 10g and migration of data.
• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support and coordinating the patches and implementing the necessary changes.
• Optimize SQL queries for better performance.
• Used PostgreSQL to run stored procedures in more than one language like java, Perl, .Net and python.
• Carried out Optimizing performance and Query tuning using Statspack, Tkprof, and OEM.
• Use Explain Plan for monitoring the query execution.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performance tuning by doing partitions.
• Responding and working with Application Development teams.
• Identifying issues/ bottlenecks that could potentially cause issues, involving the right teams (such as server admins or application developers) and take a corrective action to rectify the issues.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment: Oracle 10g/9i, SUN Solaris 10, OEM, Data Guard, RMAN, Exp/Imp, Datapump, Smart FTP, Putty, Perl

Oracle DBA

Confidential,is the world\'s leading provider of financial services to institutional investors. State Street provides specialized investment research and trading in foreign exchange, equities, fixed income, derivatives and money market products. State Street delivers an array of customized investment solutions to asset managers, pension funds, hedge funds, insurance companies, collective funds, mutual funds and nonprofit organizations.

Roles and Responsibilities:

• Organizing Oracle Database operations, installation, creation, configuration of Databases
• Laying out database tables and database schema design, startup and shutdown of Databases.
• Created Perl and UNIX shell script utilities for parsing or reformatting user data and compiling user information reports for various support purpose.
• Setting Pfile parameters, maintaining Data Files, Control Files, and Redo Log Files.
• Managing Tablespaces, segments, extents, materialize view and indexes.
• Create Users and Roles with suitable privileges.
• Monitored and tuned Rollback segment, temporary tablespace, redo log buffer, sort area size, Flash Recovery area.
• Managing Oracle Net Configuration, monitoring Alert Log Files, Listener Log, Redo Log status, rollback segments and trace files for the database.
• Monitored Alert Log Report and system Error Logs.
• Create User and Roles and grant appropriate roles, privilege and profile.
• Create User Profile and assign to appropriate user.
• Administered Hot/Cold Backups on a regular basis.
• Design and implement database backups using RMAN and perform recovery when needed.
• Carrying out Export/Import and Datapump operations on Oracle Database
• Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle 10g.
• Team member of Backup and Recovery Group (consist of 4 DBAs) responsible for Disaster recovery and implementing Physical Standby Database using Data guard.
• Installed and maintained GoldenGate products and GoldenGate Director.
• Performs backup and recovery of GoldenGate replication.
• Refreshing development/test database from production using Export/Import. This is done so that the latest data is available in the development/test database.
• Data Refresh from test Environmet to Production Environment.
• Upgradation, Migration and Installation of different patches.
• Wrote UNIX shell script for taking daily backup using crontab.
• Monitoring of the queries with high response time and high disk reads per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF, Auto trace.
• Use Oracle Enterprise Manager (OEM) for Monitor and improve performance.
• Use Partitioning features for better performance.
• Resolve performance issues by using AWR and ADDM.
• Wrote a shell script to load a data from a flat file to database using SQL * Loader.
• Supported test and development environments to ensure smooth transition of applications into production.
• Served as Oracle DBA in a 24x7 Production environment managing several Database instances.

Environment: Oracle 9i/10g, Sun Solaris 8, Import/Export, Datapump, OEM, RMAN, Dataguard, Statspack, Tkprof, Hummingbird, PERL Scripting

Confidential,Mumbai, India

Oracle DBA

Confidential,is a group of seasoned professionals who came together from backgrounds as diverse as Management consultancy, Human resources Management, Banking, Supply Chain management, Information technology, and Training. Their wide and varied experience base notwithstanding, what brought them together was one common vision.

Role and Responsibilities:

• Design and creation of client Database instances per requirements including production and test environment.
• Creating database files and Tablespaces based on the OFA model.
• Configuration of Oracle Instance with SGA, PGA and Background Processes.
• Upgraded and patched Oracle software, Setup brand new machines including Oracle software installation.
• Upgrading from 9.2.0.1 to 9.2.0.6 and 9.2.0.6 to 9.2.0.8 Database and also apply critical patches update (CPU) for latest versions.
• Managing Logical objects like Tablespaces, segments, and extents.
• Maintaining indexes, views, materialize view and performing management of Undo Data.
• Create users & roles and give appropriate privileges and roles.
• Define Database level authentication and OS level authentication using password file and User Profile.
• Laying out tables and define constrains regarding to business application.
• Installed and Configured RAC on Red Hat Linux Advanced Server with 4 nodes server side load balancing using Automatic Storage Management.
• Performance Tuning for Oracle Real Application Clusters (RAC).
• Installed and maintained GoldenGate.
• Performing regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery (Instance, media).
• Setting up of RMAN on the database to perform necessary back-up.
• Use RMAN Utilities for taking hot backup.
• Data loading from the flat file Using SQL * Loader.
• Extensive use of Export and Import for full database backup, schema level backup, Table level backup and metadata as well as full database defragmentation
• Analyzing STATSPACK Report at regular intervals to ensure good database performance.
• Tuning the Databases for optimization using STATSPACK, TKPROF and Explain Plans, Estimating Table & Index Size.
• Create Indexes by analyzing and rebuilding of Indexes for better performance.
• Wrote shell script, which generate Statspack report at regular interval.
• Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures, Functions and Triggers.
• Actively worked on SQL and Physical database tuning resolving fragmentation and disk contention.
• Actively participated in Application Tuning, which includes SQL Tuning, Database design tuning and tuning at Instance level.
• Implemented physical database design after sizing tables and indexes and locally managed Tablespaces were used which track all extent information in the tablespace itself. This results in improved performance.
• Implemented database refresh with the hot backup using DUPLICATE or full export.
• Procedures and package Concepts were used to develop the tables for designing the applications. Logical and Physical Modeling using ERWIN Data Modeler.
• Also maintain 24 X 7 uptime for the database while carrying out the activities.

Environment: SCO UNIX, Oracle 9i/10g, HP-UX 11.20, Import/Export, RMAN, ERWIN, SQL * Loader, F-secure client, SQL * Loader, Erwin, Toad