SUMMARY

• 8+ years of experience as an Oracle core/Apps Database Administrator implemented business systems under various UNIX flavors and windows environment including build, administration and troubleshooting.
• Worked in 24/7 production Support as a Level 2/Level 3 database administrator on Key financial and multi - Terabyte databases
• Experience in implementing Oracle Advanced Security, replication and administering RDBMS Oracle 9i/10g/11g/12c within enterprise-wide database environment and critical large OLTP systems.
• Database administration activities including database design, installation, configuration, upgrades/migration of oracle database including applying patches as per oracle recommendations.
• Hands on experience in Migrating of Oracle and SQL Server databases from various versions across heterogeneous platforms
• Apply patches on requirement basis, applying bundled patches, CPU Patches on clustered, non-clustered and disaster Recovery environments.
• Knowledge in usage of Oracle internal tools for debugging like Oradebug, OSWatcher, System State dumps, process state dumps.
• Root Cause Analysis for Issues of Oracle RDBMS, following up with Oracle TARs and getting technical solutions for BUGs and applying them.
• Handled Oracle several Internal Errors ORA-600 and ORA-7445
• Migrated/upgrade single node Instance to multi-node Real Application Cluster (RAC) on different operating systems.
• Implement oracle databases in clusterware/grid (RAC) multi-node environment with ASM/non-ASM.
• For critical standalone production databases implement disaster recovery solutions with dataguard/Standby for high availability, Oracle Fail Safe and replication using SRDF.
• Experience in recovery principles using RMAN and working Knowledge on Oracle Grid Control/Enterprise Manager tools.
• Clone/refresh UAT and development environments from production database using RMAN backup based or Active duplication methods.
• Experience in system design and implementation of databases on storage solution using SAN, Veritas net-backup and IBM Tivoli Storage Manager (TSM).
• Worked effectively on database Server Tuning, Application Tuning, and Database Security.
• Knowledge on Oracle Fusion Middleware and Goldengate installation, configuration and maintenance.
• Experience in shell scripting and data loading using SQL*LOADER.
• Cloning oracle EBS applications and applying application patches by adpatch.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g/12c, Oracle EBS 11i, R12

Languages: SQL, PL/SQL, Unix shell scripting

Tools: /Packages RMAN, OEM, datapump, Grid control, TOAD, Semantic-pc Anywhere, PL/SQL Developer

Operating System: RHEL, OEL, IBM AIX,HP Unix, Solaris10, Windows 2003, SQL Server 2008/2012

Others: Goldengate, VMware workstation/server, Oracle Virtual Box

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr Database Administrator

Responsibilities:

• Developed PL/SQL code to capture encryption and scrambling table/data activities by scheduling an automated jobs.
• Partitioned large tables to enhance faster querying.
• Encrypting database exports and RMAN backups, Oracle SQL*Net network traffic
• Setup SSL based authentication for network data
• Identify and encrypt critical application tables or individual columns using Data Masking and TDE.
• Tuning of SQL statements & handling performance tuning issues.
• Clone/refresh UAT and development databases from production using RMAN backup based or active duplication method and schemas using mviews, datapump.
• Applying quarterly CPU patches and PSU on RAC and non-RAC databases.
• Support the development team during release/implementation activities.
• Work with change management engineers to support any changes during maintenance windows.
• Implement disaster recovery solutions and high availability of production environments with Active Data guard, Oracle Fail Safe and prepare documents for reference.
• Configured ASM (Automatic Storage Management) which includes creating disks, disk groups for standalone and RAC databases.
• Migrated single instance databases to multi-node 10g/11g RAC for high availability with ASM/non-ASM.
• Work with multi terabyte production databases using Oracle 10g/11g RAC 8+ Nodes.
• Implemented RAC standby database for RAC primary databases.
• Work with the development team in troubleshooting pl/sql issues and during deployments.
• Tuning queries effecting database, diagnose the performance bottlenecks using AWR, ADDM and diagnostic packs.
• Experience in Oracle OEM 12c implementation and operations in an enterprise scale.
• Installed, configure, patch and support Fusion APPS databases.
• Performed basic database administration and ensure availability of applications environments.
• Wrote Unix Shell Scripts to process the files on daily basis.

Environment: Oracle 11g RAC/10g, UNIX OS flavors, OEM, SQL*Loader, Data pump.

Confidential, Charlotte, NC

Sr. Database Administrator

Responsibilities:

• Analyzing database performance.
• Resolution and tracking of the most complex Oracle issues and communicate critical support issues identified to Oracle Support Services.
• Managing escalations for Severity 1 service requests.
• Creating problem workarounds for open service requests and monitor service requests and communicating status to others on the team.
• Investigating recent SR reports, filing, tracking, reporting SRs and recommending best practices designed to minimize future SRs.
• Creating and implementing backup and recovery procedures.
• Providing available product-specific white papers and bulletins.
• Provide on-call coverage for first response problem tickets for DBMS from Oracle, and patching on UNIX systems.
• Handle various large-scale complex data/database management activities including designing physical databases.
• Cloned production Databases to the test environment using Recovery Manager (RMAN).
• Refreshing schema's in non-production environment with production backup or using mviews.

Environment: Oracle 11g/10g, UNIX OS flavors, OEM, Data pump.

Confidential, Columbus, OH

Database Administrator

Responsibilities:

• Created databases from scratch and general database administration activities.
• Troubleshoot RMAN remote database connectivity issues and database net connectivity issues.
• Installed oracle server binaries and configure RAC primary database with RAC Standby databases for high availability.
• Upgraded databases from 9i-10g/10g-11g and converted to RAC database.
• Monitoring the ASM disk groups, add and resize the disk groups. monitor the replication between primary and standby and manually apply the missing logs to standby from primary.
• Resolve Change Ticket and Trouble Ticket Management raised by the customers for all instances
• Cloned production databases to the test environment using Recovery Manager (RMAN).
• Database management, backup & recovery activities, performance tuning.
• Optimize and tune database memory/application for effective enhancement.
• Developed and implemented disaster recovery (DR) Plan.
• Experience in identifying performance bottlenecks on high volume transaction systems.
• SQL tuning and refreshing statistics of database objects, including performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.
• Configured and maintained huge OLTP and data warehouse databases.
• Configure Physical Standby database (Data guard) on Oracle 10g, 11g environment
• Managing and monitoring the use of disk space, memory, and connections on SQL server.
• Participating in Software Peer Review Process and database design.
• Manage and monitor the use of disk space, memory, and connections on SQL server.
• Clone and upgrade on 11i, 11i to R12 OEBS(Oracle Enterprise business suite)
• Installed and configured Oracle EBS R12.1.2.
• Oracle apps R12 cloning/refresh.
• Migrating a Microsoft SQL Server Database to Oracle Database 11g using developer tool.

Environment: Oracle 9i/10g/11g, RHEL, IBM AIX, HP-UX, Oracle 11i/R12 on IBM AIX

Confidential, Auburn Hills, MI

Database Administrator

Responsibilities:

• Installed and configured Oracle 9i & 10g sever binaries on Oracle Enterprise Linux.
• Assisted development team in resolving pl/sql issues during deployments.
• Upgraded databases from 9i-10/11g including version upgrades.
• Applied patches and cloned databases for development needs.
• Migrated sql server database to oracle database.
• Refresh schemas using datapump.
• Monitoring performance using AWR, ADDM reports and resolve locks on database.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Installed Cluster software, oracle server on two node boxes, implemented RAC and ASM.
• Upgraded database from Oracle 9i to Oracle 10g RAC on windows.
• Upgraded multiple production RAC environments from 10gR1 to 10gR2.
• Setup Golden Gate to execute unidirectional replication and setup user with privileges.
• Troubleshoot complex problems with root cause analysis during product deployment/release.
• Developed database objects like stored procedures, functions, packages and triggers.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Implement a disaster recovery (DR) plan for critical production database.
• Worked with latest TOAD 9.6 having new features PLSQL & SQL script debugger, database health checkup, audit objects, diagnose extents, Log Miner, Segment Advisor, database monitor, server stat's, session browser, SGA trace, top session filter, HTML schema generator, query builder.
• Implemented timely maintenance scripts like Transact-SQL, re-org, table fragmentation, analyzing statistics and troubleshooting errors reported.
• Managed security by defining roles and rights. Scanned the data pages, Indexes and checked the storage space used by each table.
• Monitored the growth of data volume and log space usage.
• 3rd party vendor follow ups for resolving technical issues.
• Patched the R12 instance for product enhancements using adpatch.
• Supported SAP application databases using oracle.

Environment: Oracle 9i/10g & 11g RAC, Unix flavors, SAP on AIX, Oracle 11i/R12 on IBM AIX, OEM, PL/SQL developer, TOAD, SQL Server 2008

Confidential

Jr. Database Administrator

Responsibilities:

• Installed oracle server binaries on Linux/Solaris/AIX systems.
• Created 9i Database using DBCA and created tables, indexes, constraints.
• Managed network address information and configuring naming methods.
• Performed daily health check for databases.
• Resolved database and application connectivity issues by modifying TNSNAMES.ORA file.
• Maintain and Monitoring of physical standby databases, manually apply the missing logs to standby from primary.
• Troubleshoot RMAN remote database connectivity issues and database net connectivity issues.
• Upgraded Oracle Database 9.2.0.8 to 10g on Solaris.
• Apply interior patches every whenever possible.
• Creation of database indexes on certain tables to improve query performance after thoroughly tested the same in the development environment.
• Performed user and table level export/import whenever required.
• Continuous monitoring and tuning of the databases and application using OEM Tuning Pack, diagnostics pack and STATSPACK.
• Tuning SQL, PL/SQL queries using hints, explain plan and SQL trace, TKPROF.
• Participate in training and professional development sessions.
• Setting up of backup and recovery for databases and testing Backups periodically
• Automat day-to-day routine database admin work with PL/SQL, Shell scripts and scheduling jobs
• Installation/upgrade of Operating System, Hardware/Software RAID Configuration

Environment: Oracle 9i, Unix machines, RMAN, SQL Developer, Export/Import.

Confidential

Trainee Software Engineer

Responsibilities:

• Installed RHEL 3/4 oracle 9i server binaries on i386 machine.
• Applied interim (using opatch utility) patches on all the databases.
• Migrated oracle 9.2.0.1 to 9.2.0.4 and to 9.2.0.8
• Refresh development and test instances with data from Production on a regular basis.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Monitored Production Databases, Performed performance tuning, added data files, resized segments, and tablespaces.
• Scheduled shell scripts for activities like gathering schema statistics, exports, table space usage report using crontab.
• Upgraded Oracle server Database Version 8.1.7.4 to 9i (9.2.0.4) on Solaris.
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan.
• Storage and space management including table spaces and data files.
• Linux system installation, configuration, monitoring and troubleshooting.
• Manage setup, maintain groups and user accounts, created partitions, including DNS, DHCP, Samba Server, Mail Server and Client configuration.
• Experience in creating LVM, creating Quotas and backups
• Implementing, administering active directories services (ADS) and group policies.

Environment: Oracle 9i, RHEL 3/4, Solaris, TOAD, Windows 2003 Server