SUMMARY

• 9+ years of extensive experience as Oracle 11g/10g/9i Database Administrator.
• Experience in Oracle Database Administration (DBA), Oracle Parallel Server, Performance Tuning, Security Administration, Replication, Distributed Databases, Oracle Enterprise Manager Grid Control.
• Database Design, XML, System Design, Object - Based Design, Data Modeling, PL/SQL, C, C++, UNIX, Windows NT, JAVA, Shell Scripting.
• Extensive experience with Auditing and Security in Oracle and SQLSERVER.
• Expert level experience in installing and Configuring RAC (Real Application Clusters), Data guard, OEM, Oracle Grid Control on various Platforms including Red Hat Linux, Oracle Linux, HP-UX AIX, Solaris and Windows Servers.
• Extensive experience in Performance Tuning (Instance Tuning, Application Tuning, Database tuning), understanding proven techniques for Oracle health checks, optimizing SQL and optimize the SGA.
• Experience in installing and configuring ASM for Multiple Node RAC and Standalone Databases.
• Experience with implementation/upgrade/support of Oracle EBS R12 and Oracle Database 11g environments
• Experience in Migrating Sql Server 2000/2005/2008 to Oracle Using OMWB, Sql Developer.
• Experience as a Production/Development/Engineering/Data Warehouse DBA with Multi-Terabyte 24x7/large databases.
• Expert level knowledge in PL/SQL Programming (Writing stored procedures for Packages, Implementing functions, triggers, collections).
• Excellent knowledge in working with Physical & Relational models of the database in a development environment/multiple environments.
• Experience with implementing Oracle security features such as encryption and VPD- virtual private database
• Expert level experience in Database backups, user-managed backup/RMAN-managed backup with or without catalog, Cold and Hot backup.
• Experience in cloning the databases from production to DEV and UAT environments
• Experience working with Oracle Performance tuning tools like Statspack, AWR, ADDM, ASH, Explain Plan, SQL*Trace, Tkprof, indexing correctly.
• Experience in applying CPU, interim patches on standalone & RAC Environments.
• Experience with Oracle query tuning for a data warehouse and STAR schema design and use of bit-map indexes.
• Experience with STREAMS AND GOLDENGATE Configuration and replication.
• Performed database tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning.
• Experience in Data Loading using SQL * Loader, External Tables and Exp & IMP.
• Experience in latest features like Data Pump, Flash-Back Recovery, Recycle Bin and Transportable Table spaces.
• Experience with setting up Oracle on Virtual machines with both Oracle Linux as well as Red Hat Linux.
• Experience in ORACLE Database administration including Partitioning large tables, capacity planning, space management, Rollback segments and Undo segments, User Management, Password Management
• Experience with Java in all Health care and Insurance applications.
• Experience in shell scripting and scheduling jobs using cron, DBMS JOBS, DBMS SCHEDULER.
• Impressive Experience in Health care, Insurance, Banking and Workforce management sectors.
• Good communication skills with the great demonstration skills, team player and highly professional, with a commitment towards excellence.

TECHNICAL SKILLS

Hardware Systems: NETAPPS, IBM RS/6000, pSeries, x86, x86 64, I64, SAN (IBM DS8300), EMC, HP 9000/E39, DELL Edge 2550/4500.

RDBMS: ORACLE 9i/10g/11g, SQL Server 2005/2008/2008 R2/2012, DB2, MS Access, MYSQL.

Operating Systems: UNIX, LINUX, HP-UX, AIX, Sun Solaris, WINDOWS NT, Windows Server 2008

Languages: UNIX Shell Scripting, SQL, PL/SQL, Perl, PHP, C, HTML, XML

TOOLS: /UTILITIES: SQL*LOADER, Data-pump, Erwin, TOAD, Spotlight, Import Export Putty, Win Runner, WinSCP3, FTP, SFTP, SCP, SQL*Plus, Test Director, ETL, RAC, Oracle Migration Workbench, ASM, Oracle Grid control, Oracle Enterprise Manager(OEM), RMAN, EXPORT/IMPORT, OLTP, Net Backup, Informatica, SQL Developer.

Applications: Oracle 11i E-Business Suite Versions 11.5.9, 11.5.10, 12.1.X

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR,ASH

PROFESSIONAL EXPERIENCE

Confidential, Southlake, TX

Sr. Database Administrator

Responsibilities:

• Handled change requests from various development teams and managed several mission critical databases.
• Database upgrade from Oracle 10.2.0.4 to 11.2.0.3 on Oracle RAC systems in OLTP environment.
• Extensive experience in the Development, Testing and Production environments.
• Manage various airline databases and support application development and testing.
• Managed sequences, tables, constraints, PL/SQL procedures, packages and tuning queries.
• Export and Import, Datapump and user management in complex OLTP systems
• RMAN backup and recovery; Point in time recovery.
• Implemented Oracle Shared Server on DEV, TEST and PROD environments
• Created reports and provide analysis on the database growth and performance
• Wrote several scripts and jobs to maintain and manage the databases.
• Connection/Session management and monitoring.
• Configured memory settings and database instance parameters to enhance performance
• Created indexes, partitions, changing datatype and range of values for performance enhancement.
• Configured ASM on SAN storages. Managed ASM storages for RAC and single instance systems.
• Created service requests and escalating issues when needed.
• Configured Database Auditing and created database audit reports for the management
• Supported Application upgrades, patches and testing
• Implemented Oracle advanced compression strategies on huge tables.
• Capacity planning and implemented plans to minimize the database footprint of the application database.
• Involved in database architecture design and developments.
• Debugging and resolving issues from various DEV teams and provide support and knowledge share on best practices.
• Providing support and closely working with on-shore and of shore teams to provide efficient support on production databases.
• Design testing strategies to troubleshoot various application issues.
• Managing multiple Oracle Homes and supporting migrations
• Executed AWR, ASH and ADDM reports, analyzing the reports to fine tune the databases
• Trained the staff on best practices and knowledge share.
• On call support 24X7

Environment: Oracle 10/11g, Oracle RAC, Solaris, HP-UX,AIX, Red Hat Enterprise Linux, Data Guard, OEM, ASM, ASH, RMAN, ASSM, AWR, Toad, Spotlight, PL/SQL, Shell scripting, JAVA .

Confidential, Murray, UT

Sr. Database Administrator

Responsibilities:

• Planning the hardware and software requirements for installing Oracle Real application cluster (RAC) 11gR2
• Install and Configure Oracle 11gR2 RAC on four nodes on Red Hat Enterprise Linux 5.7 and Oracle Enterprise Linux 6.
• Installation and Database Administration of multiple Oracle 11gR2 Databases, in a development and in multiple beta-test Production environments on Red Hat 6 Linux servers and VM’s.
• Install and configure the Oracle 11gR2 RAC One Node.
• Lead and participate in projects with cross functional teams.
• Migrated the data from Oracle RAC databases to SQL Server databases.
• Install and Configure the SQL Server 2012 RC0 Database on Windows Server 2008.
• Upgraded the SQL Server Databases from 20 RC0.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Implemented Oracle security features like Oracle Database Vault, Auditing in Oracle 10g/11g and SQL Server 2005/2008/2010/2012 RC0 Databases.
• Converted Single instance to Multi-node RAC on Red Hat Enterprise Linux 5.5.
• Performed compressed backups and Point-in-time recovery using RMAN.
• Migrated Non ASM file system to ASM File system Using RMAN.
• Configured the Oracle GoldenGate on Red Hat Enterprise Linux 6 and performed data replication.
• Installed Sybase servers version 10 11.0 11.5 11.9 ASE 12.0 ASE 12.5 and 12.5 .x on SUN, SCO UNIX System and applied required patches by monitoring new patch releases.
• Expert-level performance monitoring and tuning using OEM, TOAD DBA SUITE, Spotlight.
• Move the data from SQL Server to Sybase using bcp
• Successfully, planned and implemented Oracle database upgrade from Oracle 10g/11g databases to Oracle 11.2.0.3 databases on ASM and Non-ASM development and production environments on Linux Servers and also on VM’s.
• RAC DataGuard installations and configuration. Perform Switchover and Failover when required.
• Good Knowledge and hands on experience with Oracle Enterprise Manager 12c
• Performed Data Architecture, design Tablespace restructure and database redesign, normalization, partitioning, and compression.
• Capacity Planning and implementing plans to minimize the database footprint of the application database.
• Configured and implemented best practices, as well as trained staff for Oracle setup, monitoring, performance tuning, backups, security and auditing, patch and software releases on Oracle11g databases.
• Wrote complex stored procedures, triggers, and PL/SQL coding. Fined tuned all existing PL/SQL coding for performance optimization.
• Created, modified, and maintained all database build scripts, shell scripts, RPM’s, POM, XML and Oracle seed files associated with the QUALIBRIA medical system software.
• Authored documentation and trained staff on configurations, startup/shutdown, monitoring, backups and data replication.
• Used EXPLAIN PLAN, TKPROF, SQLTRACE, ANALYZE, HINTS, AWR, ADDM, ASH, Statspack etc. for Database performance tuning.
• Understand the common causes of performance problems, See how data caching improves access speed, and See how Oracle data repository allows for proactive database tuning.
• Setting up Data Guard both Physical Standby Database and Active standby database for Disaster recovery in DEV and Production environments.
• Experience with Oracle Very Large Databases (VLDB) of 10 TB to 30 TB.
• Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Start Transformation.
• Working with VERITAS, Net App and SAN Storage Technology to take the hot and cold backups.
• Involved Oracle query tuning for a data warehouse and STAR schema design and use of bit-map indexes.
• Configured database using latest features of Oracle 11g like SCAN, Grid Infrastructure, Compression, Automatic Shared Memory Management (ASMM) and Locally Managed Tablespace.
• Performance monitoring, Alert Log monitoring and backup monitoring.
• Worked with Oracle Service Requests, escalations and high severity requests.
• Lead onshore/offshore DBA teams for DBA support for 24/7 system availability.

Environment: Oracle 11g R2 RAC, Solaris, HP-UX,AIX, Red Hat Enterprise Linux 5.7, Data Guard, Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, OWB, Toad, Spotlight, PL/SQL, Shell scripting, JAVA .

Confidential, Pittsburgh, PA

Sr. Oracle Database Administrator

Responsibilities:

• Install and Configure Oracle 11g RAC with Grid Infrastructure (GI) on two nodes on Red Hat Enterprise Linux 5.5.
• Upgraded the databases from 10.2.0 to 11.2.0 in UNIX, Windows Environment.
• Migrated Non ASM file system to ASM File system for better space management.
• Extracted all the Auditing data from all Oracle & SQL Server databases (40 databases) and Loaded in the Data Ware House using Informatica.
• Analyzed EXPLAIN PLAN, TKPROF, SQLTRACE and used ANALYZE, HINTS for performance enhancement. Ran AWR, ADDM, ASH reports to analyze the database behavior and implemented new strategies for Database performance tuning.
• Understand the common causes of performance problems, See how data caching improves access speed, and See how Oracle data repository allows for proactive database tuning.
• Created Database Schema, development, administration and testing using Sybase System 10 .x or 11 .x Servers, MS-SQL 6.5 7.0 Server.
• Setting up Physical Standby Database Data Guard for Disaster recovery and implemented failover and switchover mechanisms.
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM).
• Converted Single instance databases to RAC databases on Oracle 10g and 11g.
• Data Refresh from Test to Production and Development environments using RMAN Duplicate Database.
• Experience with Oracle Very Large Databases (VLDB) of 1TB to 8TB.
• Implemented security features like Auditing and user management in Oracle 11gR2 and SQL Server 2000/2005/2008 Databases.
• Involved in Oracle Warehouse Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Star Transformation.
• Working with VERITAS, SAN and EMC Net backup Technology to take the hot and cold backups.
• Involved Oracle query tuning for a data warehouse and STAR schema design and use of bit-map indexes.
• Managed the Very Large tablespaces and tables in 12 TB size of Database.
• Configured the Oracle Streams both up streams and down streams for data replication.
• Implemented Advanced features like Oracle security features such as encryption and VPD- virtual private database.
• Developed the database application with java like Installing Java DB, Connecting to the Java DB Database and Deploying the application.
• Identified bugs and applied required patches like CPU, DST & Bundle Patches as per the oracle recommendations.
• Developed shell-Scripts for RMAN, Hot and Cold backups.
• Configured database using latest features of Oracle 11g like Automatic Shared Memory Management (ASMM), Automatic Memory Management (AMM), Locally Managed Tablespace, Parameters.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring, Alert Log monitoring and backup monitoring.
• Provided on-call support for production-related database problems.

Environment: Oracle 11g R2 RAC, SQL Server, Solaris, HP-UX,AIX, Red Hat Enterprise Linux 5.5, Data Guard, Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, OWB, Toad, Spotlight, PL/SQL, Shell scripting, JAVA .

Confidential, Chelmsford, MA

Sr. Oracle Database Administrator

Responsibilities:

• Installations and Configurations of Oracle 10gRAC with Oracle Cluster ware (CRS) on four nodes on Red Hat Enterprise Linux 5.
• Performed backups, restore and Recovery procedures using Oracle Hot and Cold backup procedures.
• Performance Tuning using AWR, ADDM and Stats Pack and tuning usage of CPU, Memory, Disk I/O and Network Contention.
• Tuned SQL queries by using Trace, Explain Plan, Tkprof, Hints and Maintaining appropriate indexes.
• Upgraded existing production Oracle RAC 10gR2 databases to Oracle 11g RAC databases
• Analyzed the database so as to allow Oracle optimizer to choose best plan in executing the queries.
• Maintain, enhance, and monitor the database through Oracle Enterprise Manager Grid Control (OEM GC) for monitoring production Oracle databases
• Configured Workload Management, JDBC, ASM, and RMAN for maximum performance.
• Deployed Oracle technologies like ASM, OEM/Grid Control, RMAN, Partitioning, Active Data Guard, Oracle Streams/Golden Gate, Data Compression in production environments.
• Performed tuning in Oracle 9i/10g//11g for high transaction, multi-TB sized Databases.
• Strong ability with UNIX shell scripting to automate tasks and also in Crontab, OEM and dbms scheduler for scheduling jobs.
• Troubleshooting and performance tuning for Long Running Quires.
• Managing the Virtual Machines like creating and configuring the Virtual Machines and installing, configuring and monitoring Oracle database.
• Troubleshooting, backup and recovery, proactive database and system maintenance, proactive monitoring, security, research and development, all levels of performance tuning, architecture and design, mentoring and support
• Tuned the Oracle Real Application Clusters for 4 nodes for performance enhancement.
• Implemented Parallelism like System level Parallelism, Session level Parallelism, Object level Parallelism and SQL-level parallel query and also Extensively Worked with Oracle column level compression.
• Creating large tablespaces, big tablespaces and managing the tablespaces in Oracle.
• Performed data migration using RMAN, data pump export and data pump import and utilities
• Provided on-call support regarding production-related database problems.

Environment: Oracle 11g R2 RAC, Solaris, HP-UX,AIX, Red Hat Enterprise Linux 5.5, Data Guard, Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, OWB, Toad, PL/SQL, Shell scripting .

Confidential, Pittsburgh, PA

Oracle Database Administrator

Responsibilities:

• Supported 50+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• Day to day performance monitoring and tuning of database. Monitoring of database objects like rollback segments, temp segments and tablespaces. Diagnose and troubleshoot Database problems and failures.
• Monitor on a regular basis, as part of database preventive maintenance, the database Growth, alert logs and archive log destination space through Toad and OEM.
• Configured Dynamic SGA in Oracle Database 10g - Automatic Shared Memory Management (ASMM).
• Configured the Streams and Data guard in Oracle 10g
• Migrated from Single Instance databases to RAC databases
• Refreshed databases using Exp, import, hot, cold and rman backups from Production to non-prod Environments.
• Monitor database performance with Statspack, v$-views, OEM and TOAD.
• Intended solutions and performing global enterprise database backup and recovery
• Handling large database environments (Data warehouse) using ETL tools and Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active monitoring performance and space management issues and accordingly providing on-the-fly solutions to make database healthy and running.
• Storage and Space management including table spaces and data files. Management of table space growth, monitoring data files additions and extent growth.
• Taking care of all alerts for space issues and user requests.
• Tuned SQL queries by using Trace, Explain Plan, Tkprof and maintaining appropriate indexes.
• Working with Clients, Business analyst and Reporting team.
• Designed tools to proactively report system and database availability in highly available environments. Created SQL and PL/SQL scripts to provide periodic reporting and database monitoring for internal and remote customers.
• Developed or maintained Oracle backup and recovery scripts. Used Oracle backup utility RMAN/EBU to implement Oracle backup and performed a number of times of disaster recovery.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Extensive experience in supporting multiple production databases running 24 x 7 mission-critical or OLTP applications demanding high availability and increased performance.
• Provide support for Oracle Enterprise Manager Grid Control and Agents.
• Checking the invalid objects & recompiling the invalid objects by using utlrp.sql.

Environment: Oracle 11g/10g/ 9i, DB2, HP-UX, Solaris, OEM, Statspack, Tkprof, AWR, ADDM, TOAD, ERWIN, RMAN, ASH.

Confidential, Sunnyvale, CA

Oracle DBA

Responsibilities:

• Installation, configurations of multiple Oracle 10gR2 RAC environments with Oracle Clusterware(CRS) on 3 node clusters starting from scratch..
• Configuring Oracle 10g Data Guard for RAC production systems
• Managed multiple instances, including strategy, planning and technical implementation.
• Configured Automatic Storage Management (ASM).
• Implemented advance features Flashback Query and Data guard to provide advanced reporting and high availability (Hot Standby) solutions.
• Design backup strategies for minimum downtime & providing maximum data security. Used RMAN for full, incremental and cumulative backups and tested various RMAN recovery scenarios for production databases.
• Proactively monitoring, identifying areas that need to be improved in the application and database using 10g OEM Monitoring.
• Taking care of all alerts for space issues and user requests.
• Locally managed tablespaces were used which track all extent information in the tablespace itself. This results in improved performance as it eliminates recursive operations and reliance on data dictionary.
• Performed SQL tuning by using Explain Plan and Tkprof.
• Migrated Non ASM file system to ASM File system Using OEM.
• Must have experience with Oracle query tuning for a data warehouse and STAR schema design and use of bit-map indexes.
• Wrote Perl scripts for checking of Alert log and Trace files to monitor database on a daily basis.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Periodically uploading data from flat files using SQL*Loader.
• Used Oracle scheduler and Unix Cron utility for automating jobs
• 24/7 Production support on a rotational basis.

Environment: Oracle 11g/10g R2 RAC, HPUX, Red Hat Enterprise Linux 4, Toad, Erwin, OEM, sqlldr, ASM, ERWIN, GRID, AWR, ADDM, Data Guard, shell-script.

Confidential, Las Vegas, Nevada

Oracle DBA

Responsibilities:

• Installed Oracle 10g RAC with 2 Nodes on New Data mart Database Servers (RHEL- 4.0) with New SAN Storage.
• Performed Migration of the databases from normal file system to Automatic Storage Management (ASM) for managing huge data in SAN.
• Experience ensuring the high availability, Performance and integrity of databases.
• Configured logical/physical Data guard and managed data guard using data guard broker.
• Installed Oracle 10g, Gridcontrol on Linux, Sun Solaris and Windows servers.
• Have worked Data modeling, building complex logical data models using sophisticated modeling techniques and tools like TOAD, Erwin and Visio.
• Defining strategies for database implementation, high performance, streams, failover and Disaster Recovery.
• Setup backup and recovery procedures using RMAN.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).
• Worked on import/export, Datapump and SQL- loader.
• Created and managed database objects such as tables, indexes, partition tables and views.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Manage data architects, data administrators and client enhancement requests.
• Expertise in Client server GUI software and different Operating systems.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• SQL tuning and Database tuning based on reports generated by SQL Trace, TKPROF Reports, AWR, Statspack, Explain Plans and monitor the database performance on daily basis.
• Extensively worked on Database administration activities like Installation, Configuration, Backup & Recovery and Database Security.
• Expert in upgrade and configuration of MS SQL Server and databases in clustered and non-clustered environments.
• Database and log backups & restoration, backup strategies, scheduling backups.
• Created Database Security by giving proper permissions to users and roles.
• On Call 24/7

Environment: Oracle 10g R2 RAC, Solaris, Red Hat Enterprise Linux 4, Data Guard, Grid, OEM, ASM, RMAN, ASSM, AWR, OWB, sql developer, Toad, PL/SQL, Shell scripting .

Confidential

Oracle DBA

Responsibilities:

• Administered all database installation, creation and tuning issues of Oracle.
• Configured database using latest features of Oracle 9i like Undo-Tablespace, Locally Managed Tablespace, Sorting Parameters
• Analyzed the database so as to allow Oracle optimizer to choose best plan in executing the queries
• Run oracle stats pack to tune the databases.
• Wrote SQL scripts for DB monitoring, and online backups on production environments.
• Implemented Oracle Replication and enable database fail over in cases of system or database crash.
• Performed database recovery in various scenarios ensuring least downtime.
• Creating users granting the permissions and coping with the day-to-day demands and troubleshooting their connectivity, permissions and performance problems.
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files.
• Performing scheduled Restoration drills by bringing down a test database in different scenarios.
• Maintaining and configuring the archived data on appropriate storage devices like Legato Media manager.
• Backing and restoring the database using RMAN utilities, Datapump and Veritas netback up.
• Creation, maintenance, and administration of databases under UNIX and Windows environments.
• Cloning of production database to test environment using Recovery Manager (RMAN).
• Running SQL Tuning scripts for gathering information on database performance like sorts, gets, misses, cache hits, disk I/O activity, disk reads etc.
• Database performance and tuning issues.
• Tuning of I/O, which includes separating of data files and redo log files on different locations, striping.
• Experience in using utilities like Export/Import and SQL Loader.
• Developed and maintained PL/SQL packages, procedures, functions and triggers to support application.
• Provided 24*7 System support.

Environment: Oracle 9i, HP-UX, Red Hat Linux, RAC, Tkprof, Statspack, SQL Loader