SUMMARY:

• 10+ years of professional IT experience, over 8+ years of experience in Oracle Database Administrative functions such as Installation, Configuration, Upgrading, Backup & Recovery, Data Guard Implementation / Administration, Moving Data, Partitioning, Tuning Confidential Instance level and SQL level, Space Management, Database Security, Auditing, Troubleshooting, Database Designing / Developing, Writing / Debugging PL/SQL code, Shell Scripting on various LINUX, UNIX, Sun OS and Windows platforms.
• 3+ years of Setting up GRID infrastructure & RAC Installation, Designing / creating RAC Databases, Patching, Troubleshooting & Performance Tuning, Monitoring and Maintaining RAC Databases.
• 3+ years of configuring & maintaining Golden Gate & Shareplex (uni & bi - directional) as replication tool in number of non-RAC & RAC (Real Application Cluster) environments.
• Administration of over 200 Oracle Databases 8i, 9i, 10g, 11G, 10g RAC & 11g RAC including production critical 24x7 instances running in archive log, MTS modes sizes of range up to 4TB.
• Oracle PL/SQL Development, Debugging, Coding, SQL Tuning and SQL Server on various LINUX, UNIX, Sun OS and Windows
• Working as a Team Lead Role.
• Experienced in entire system life cycle including Analysis, Design, Programming, Testing, Debugging and Implementation of client/server based Oracle applications.
• Good Technical, Analytical, Communication and Interpersonal skills.
• Oracle7.3.4, 8.1.7, 9i and 10G Database Administration, UNIX (SCO Open Server 5.x, UnixWare 7.x, Open UNIX 8.0, Red Hat Advanced Server Linux 2.1, Red Hat Advanced Server Linux 3.0 & Red Hat Advanced Server Linux 4.0 &5.0.
• Performance and Tuning: Tuned various large critical OLAP and OLTP databases of tera bytes size using various tools like STATSPACK, Oradebug, Tkprof and Explain Plan, ADDM, AWR, ASH Methods.
• Oracle PL/SQL Development, Debugging, Coding, SQL Tuning and SQL Server on various LINUX, UNIX, Sun OS and Windows
• Backup and Recovery: Implemented Hot backup in manual method using scripts and Using RMAN and recovered various development and critical Productions systems on various products.
• RAC ( 10g & 11g RAC): Setting up GRID infrastructure & RAC Installation, Designing / creating RAC Databases,, patching, Troubleshooting & Performance Tuning, Monitoring and Maintaining RAC Databases
• Database Upgrades: Handful experience in Upgrading oracle databases from Versions 8 to 8.1.7.4 8i to 9i, 9i to 10g, And 9i Upgrades like 9.2.0.6/7 to 10.2.0.2/3.10 g on RedHat Linux
• Database Design experience, Shareplex.
• Cloning databases & Oracle Installations on various UNIX & LINUX servers.
• Maintained Standby Databases and implemented 9i & 10G Data Guard Setup.
• Data Privacy: Successfully Implemented latest 10G security features like TDE (Transparent data encryption), VPD (Virtual private database), FGAC (Fine grained auditing control Confidential row and column level).
• Automated various monitoring scripts and converted various shell scripts using the feature DBMS Scheduler
• Oracle 9iAS, Portal Database Setup, Tuning and Configuration.
• Capacity Planning and Sizing the Servers for entire system life cycle.
• Oracle Tools - Oracle Enterprise manager (OEM), Stats pack, SQL Trace, TKPROF,AWR,ADDM, SQL*NET, Net8 Assistant, TOAD, SQL * Loader, DB artisan.
• Maintaining of WebLogic servers .Monitoring and resolving the issues.
• Maintaining, installing web servers/Apache server in APPS 11i Database.
• GoldenGate, Materialized views, streams, Shareplex replication experience with Oracle 8i, 9i & 10G Databases.
• Managed number of 14 TB Data Repository / Datawarehouse Databases, performed structural changes and ETL activities.
• Set up monitoring for various environments using tools like Oracle Enterprise manager (OEM).
• Shareplex replication: Installation, configuring, Monitoring, Troubleshooting and Tuning Supporting Shareplex in non-RAC environment.
• GoldenGate: Installation, configuring, Monitoring, Troubleshooting and Tuning Oracle GoldenGate in number of RAC (Real Application Cluster) environments.
• Rebuild indexes periodically. Very flexible Oracle job would accept the owner, tablespace and table name patterns and rebuild all matching indexes or only those that were too large, very fragmented. Extents resized appropriately. Target tablespace could be different for defragmenting an entire tablespace.
• Monitor long transactions. Proactively take care of potential performance issues due to uncommitted hung transactions or poor query
• Database health. Set of scripts for detailed and precise information about locks, SGA, cache, objects in cache, stats, events, and space in the database Confidential the current time. Another script for trending over a period of time. Monitored largest free chunk per tablespace as well.
• Analyze tables and indexes. Stored procedure could decide if to compute or estimate or let the caller override. It took owner, object name pattern as input
• Alert log error mailing Sending SMS to DBA team of any errors in alert log every n minutes.
• Disk space. Monitor disk space free space. Monitor archive destination. Setting up Mobile Alerts which sends SMS to DBA team in critical situations
• Archive Logs. Monitor archive logs and zip, move, purge them periodically. Redirecting the Archivelog directory in SAP databases.
• Secure SQL*Plus connections so that only privileged users can connect. Monitored logged sessions and killed unauthorized sessions.
• System table space, Oracle job to move new users off of the SYSTEM table space
• Database structure. Script to dump database table, index and column definitions into flat files. Script could then recreate optionally resized objects.
• Schema comparison: for differences in tables, indexes, columns, grants, triggers etc.
• Maintaining of WebLogic servers web logic servers(6.0,7.1 and 8.0) .Monitoring and resolving the issues.
• Maintaing, installing web logic servers(6.0,7.1 and 8.0)/Apache server in APPS 11i Database.
• Invalid Objects: Find and compile all invalid objects using SQL generating scripts.
• Standards: Script to help follow company standards when creating a new database. UNIX system administrator. General system admin duties including creating users, backups, rlogin, rsh, vi editor, ftp, mounting and unmounting, creating mount points, creating users, groups and giving access rights, Creating Disk groups and Volumes on Veritas. Cron jobs for backup, security checks and file system dumps/restores. Monitor important daemons and to restart if any fails.
• I/O balancing: split the tablespaces in 5 or more datafiles to even out on all the disks. Moved datafiles for partitions of large partitioned tables to their own tablespaces distributed on various disks. In sort-heavy situations, split the TEMP tablespace over multiple disks as well. Working with Locally Managed Tablespaces
• Rollback, Redo, Extents: Resize rollback segments to avoid dynamic allocation of space by pre-allocating the extents. Presently working with SMU (System Managed Undo).Increased numbers of redo log groups to avoid archiver hanging, increase size of redo logs to avoid too frequent archive logs. Maintained extents previously and now all working with Locally Managed.
• Optimized SQL queries: To run from a few minutes to 15 seconds or less by reordering the where clause, using subqueires in joins, realizing and creating indexes on columns in the where clause. Tuned PL/SQL codes to run in shorter time.
• Used UTLESTAT and UTLBSTAT and STATSPACK for Database wide performance issues to tune the SGA and all. Used Analyze, Explain Plan and Tkprof to tune the SQL Queries.

TECHNICAL SKILLS:

Platforms: HP-UX 10.x/11.x, Sun Solaris 8/ 9/ 10, AIX 4.3/ 5.1, RHL/ LINUX 2.0.1

High Availability:: Oracle 10g/11g RAC Advanced Replication, Clustering and Data Guard Setup, Configuration and Tuning.

RDBMS: Oracle 11g/10g/9i/8i, SQL SERVER 2000, 2005 and DB2

Languages: PL/SQL, Shell Scripting, C, Visual BASIC, C++ and ABAP (SAP)

Tools: Export/Import, DATAPUMP, RMAN, OEM Grid Control, SQL*Loader, TOAD, DBARTISAN

Replication: Shareplex & Golden gate / Oracle streaming

ETL Tool: Informatica 8.2, Cognos (Datawarehouse / Repository Database tools)

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Oracle DBA

• Installation of 11g /10g / 9i oracle binaries & Designing / Creation / upgradation of Databases for DEV & Production environments on Solaris / UNIX and LINUX servers.
• Performing routine Monitoring of Oracle Instances, Users, Undo/Rollback Segments, various other DB Objects, Memory Structures, SQL queries and Alerts.
• Working closely with the Onshore/Offshore DEV & application teams daily basis to perform Data Updates / Data Loading / Reporting.
• Resolving frequent Locking /Blocking and CPU 100% / Max sessions issues.
• Maintained the required level of available Free Space in the Tablespaces / respective Mount Points across.
• Taking care day to day basis Archiving related issues.
• Implementing CRON setup to automate constant monitoring / various maintenance/reporting and other batch jobs using written Shell scripts (cron setup) and dbms scheduler.
• Implementing & monitoring Database Security through Users managements (distributing/limiting privileges) & Auditing.
• Supporting Data Replication process through Shareplex / Golden gate / Oracle streaming.
• Refreshing Databases from production to test and development using Export/Import, RMAN as well as traditional hot backup method for smaller databases.
• Writing necessary Scripts for Startup and Shutdown, for Health Check of Databases and for Analyzing of Tables and Rebuilding of Indexes, for different type of Backups and to check Oracle errors in alert log file.
• Performance Tuning / Troubleshooting of the Databases/SQLs using TOAD/DBArtisan and Oracle utilities like OEM, AWR, ADDM, ASH, Explain Plan, StatsPack and Tkprof.
• Tuning the Initialization Parameters for better performance.
• Our Team supporting more than three hundred fifty intensive Production Databases. Number of them are 11+ Terra Bytes in sizes.
• Supporting /Maintaining instances in 10g RAC/11gR2 RAC environments with ASM on RHL servers.
• Capacity planning as per the DB growth.
• Performing monthly release Database Objects’ structural changes activities DDL changes.
• Provided database support to the developers & Application team.
• Managing 13 TB Data Repository / Datawarehouse Databases, performing necessary structural changes and ETL activities using Informatica/Cognos tools.
• Writing & recreating Procedures, Triggers, Functions and Packages and Shell Scripting to meet business needs.
• Working with Onshore/Offshore DEV & application teams daily basis to perform Data Updates / Loading / Reporting
• Worked in a 24/7 supporting environment with ON-CALL rotation.
• Working with development team and production implementation team during application reorganization and implementing changes in applications.
• Implemented monthly release structural / DDL changes activities as well as daily maintenance CA activities to the production Databases.
• Designed, tested and implemented backup strategies using RMAN.
• Shareplex replication: Installation, configuring, Monitoring, Troubleshooting and Tuning Supporting Shareplex in non-RAC environment
• GoldenGate: Installation, configuring, Monitoring, Troubleshooting and Tuning Oracle GoldenGate in number of RAC (Real Application Cluster) environments
• Providing Mid level DB2 DBA supports to number of DB2 Server production Databases as well.

Environment: s: HP-UX, SUN-Solaris, LINUX, Oracle 8i/9i/10g/11g, RAC/11gR2 RAC, ASM, DB2, MS SQL Server 2005/2008 & Shareplex / Goldengate replication tool

Confidential, Richardson, TX

Oracle DBA

• 24/7 support for databases and critical production operations teams.
• Perform daily maintenance tasks on ORACLE databases such as monitoring of Alert log files and resolve issues, daily check on the application of archive logs.
• Monitoring and tuning the database queries of the application team, using Explain Plan and SQL Trace.
• Performance Tuning by creating indexes and analyze the database objects when needed.
• Worked on Production and reporting databases, helped the application team to get data from production to reporting as per the request.
• Importing/ Exporting data from/to different databases using utilities like SQL*Loader, Import/Export.
• Worked closely with the developers & Application team for every monthly release structural / DDL changes activities to the production Databases.
• Provided Database Production support to the customers.
• Supporting Oracle Stream & Golden Gate as replication tool among the RAC Databases.
• Trouble shooting the alerts generated from the cron scripts, and try to rectifying them ASAP.
• Doing regular maintenance of databases (Supporting nearly 200 Databases) which has 6 Terabyte size.
• Generating performance reports using utilities like statspack, AWR, ASH report to gather statistics.
• Installation and creation of 9i and 10g databases for Production.
• Performed database cloning to setup test and development database.
• Backup & Recovery of Database using 10G Recovery Manager (RMAN).
• Implemented DATA GUARD (Physical Standby) for high availability/disaster recovery purpose.
• Installation, Configuration & Administration of 10G OEM.

Environment: s: SUN Solaris, HP-UX, Oracle 8i/9i/10g/11g, UDB DB2, Shareplex, RHEL 2.6.18-128. el5,Oracle Golden Gate 10.4.0.19 as replication tool