SUMMARY

• Over 14 years of IT experience and Oracle Database Administration experience in Installations including Oracle 11gR2 RAC which includes Grid Infrastructure and RDBMS on LINUX and Solaris UNIX and Oracle 10gR2 installation on Sun Solaris.
• Experienced in upgrade procedures, Server Migrations, Data Center Migrations, Setting up Data Guard, setting up active - active replication using golden gate, Performance & Tuning, Backup & Recovery procedures, and Database integrity and Security
• Experienced in coding PLSQL, shell scripting and well exposed to Oracle Architecture, SQL, SQL Plus, PL/SQL, EXPDP,IMPDP,EXP, IMP, RMAN, AWR, ASH, and ADDM reports, DB control, OEM, SQL *Loader, SED, AWK, SSH (SecureSHell), SFTP and writing Unix Shell scripts
• Experienced in Oracle DBA, Oracle 11.2.0.4, 10.2.x, 9.2.x, Oracle 8.1.7x, Oracle Installations, Upgrades, CPU, PSU & oneoff Patching, Performance and tuning, Capacity planning, creating Oracle Databases, and Oracle database Objects
• Experienced in Leading DBAs working with them and helping to create projects planning providing guidance both technically and also functionally to complete projects
• Working with Application SMEs to provide recommendations on database design, architectural design and capacity planning
• Experienced in working on cost cutting projects without heavily impacting application performance and design
• Extensively involved in developing scripts, logical/physical designing of databases in OLTP and OLAP environments
• Experienced in handling multiple tasks, multiple project and mentoring multiple servers
• Served as Primary SYS/APP DBA for all client I served and carries cell phone 24/7 database support. Worked in a highly visible environment as Lead Oracle DBA.
• Strong work ethics, Oracle DBA skills, team player with excellent communication and interpersonal skills

TECHNICAL SKILLS

• Oracle 7.x
• Oracle 8.0
• Oracle 8i
• Oracle 9i
• Oracle 10g
• Oracle 11g
• MS SQL Server 2000
• MS Access 2000
• SQL
• SQL PLUS
• PL/SQL
• T-SQL
• C
• C++
• Java 2
• Visual Interdev 6.0
• VB 6.0
• JavaScript
• ASP 3.0
• Export/Import
• Datapump active data guard golden gate
• SQL *Loader
• O.E.M 2.0
• RMAN
• Toad
• DB-Artisan
• Unix Shell Scripts
• Awk Scripts
• Sed Scripts
• SSH
• SFTP
• Office 2000
• ERWin 3.x
• SUN Solaris 2.x 2.6
• Solaris 8 10
• HP-Unix 11
• Red Hat 6.3 5.7 5.X
• Win-NT 4.0
• Win 2000 Server
• Win 2000 Professional
• Sun Sparc/Ultra/Enterprise
• PC/Pentium

PROFESSIONAL EXPERIENCE

Confidential, Highlands Ranch, CO

Lead Oracle Database Administrator

Responsibilities:

• Installed several Oracle 11.2.0.3 RAC environments on Red Hat 6
• Setting RMAN backups and Setting up OEM agents for monitoring
• Wrote procedures to compare schemas and for trace files maintenance
• Tuned SQLs using Oracle SQL tuning advisor
• Setting up Stand-by database for production databases in different regions
• Worked with partitioning, splitting, creating local indexes and moving LOBs
• Applied Oracle and Grid PSU in rolling fashion
• Tuned SQL statements using SQL - profiles
• Installed, configured and Troubleshot Golden gate on Linux and Solaris
• Setting up Golden Gate Replication between Oracle database servers for HOT/Warm setup
• Setting up bidirectional replication between Sybase and Oracle databases
• Planned and executed Zero Down time database migration between data center
• Experienced in Leading DBAs working with them and helping to create projects planning providing guidance both technically and also functionally to complete projects
• Working with Application SMEs to provide recommendations on database design, architectural design and capacity planning

ENVIRONMENT: Oracle 11.2.0.3, 11.2.0.4, 10.2.0.4, Red hat 6.3,5.7, SRVCTL, CRSCTL, SQL, PL/SQL, SQL LOADER, Data pump Utilities, RMAN, Avamar media lib Tape back software, Golden Gate 11.1.1.1

Confidential, Fort Eustis, VA

Lead Oracle Database Administrator

Responsibilities:

• Responsible for upgrading Oracle 10g to Oracle 11.2.0.2 in both Development and production environments
• Worked on data center migration project, moved all RAC databases from one data center to another using data guard
• Installed 3 Node RAC on 3 sun physical machines used Jumbo frames for inter-connect
• Installed Oracle 11.2.0.2 Grid infrastructure cluster on two node Solaris Containers in development and in Production environments
• Installed Oracle 11.2.0.2 Oracle RDBMS on Solaris 10 containers
• Used RAW Disk for building 11.2.0.2 RAC databases
• Supported Application with performance issues by recommending re-writes for some SQL statements after analyzing sql execution plan
• Supported Application team by writing pl-sql scripts for their application and recommending proper indexes sequence caching
• Supported Application team with performance issues by running sql tuning advisor and by implementing to improve performance in 11.2.0.2
• Moved OCR and VOTE from One RAW Disk to Another RAW with Multi-path
• Upgraded and Created databases manually and using dbca
• Responsible for running/deploying SQL script for Application release and patches
• Responsible for Clone Prod environments to Test/UAT and development environments
• Tested Client Fail-Over and implemented procedures to take Cluster down for maintenance
• Responsible for Maintenance Release, service requests and application patches
• Responsible for SQL tuning for Oracle databases, Tuned database parameter to improve database performance, tuned Oracle SQL statements
• Setting up Oracle 11gR2 Data Guard a Physical StandBy database for OLPT databases
• Implemented Oracle Real Time Replication using Downstream methodology for Production database
• Attended Oracle Golden Gate Training with Oracle
• Implemented and replaced streams with golden gate
• Set up one directional golden gate setup frm production to DW
• Responsible for On-call Support on weekly basis and also available by phone 24/7 for any critical issues

ENVIRONMENT: Oracle 10.2.0.4, 11.2.0.2, Oracle Sun Solaris 10, SRVCTL, CRSCTL, SQL, PL/SQL, SQL LOADER, Export/Import Utilities, Golden Gate 11.1, Oracle Streams, RMAN, VERITAS NetBackup™ 6.0

Confidential, Carmel, IN

Oracle Database Administrator

Responsibilities:

• Responsible for installing Oracle quarterly critical patches, installed patches and Upgrades
• Responsible for writing RMAN backup and Restore scripts and scheduled in crontab
• Installed Oracle 11gR2 Grid infra structure cluster on two node Linux Red Hat 5.6
• Created RAC databases using ASM
• Responsible for Clone Prod environments to Test/UAT and development environments
• Responsible for Cloning Oracle Applications R12 Environment
• Tested Client Fail-Over and implemented procedures to take Cluster down for maintenance
• Responsible for Maintenance Release, service requests and application patches
• Responsible for setting up replication for selected tables using materialized views
• Responsible for SQL tuning for Oracle databases, Tuned database parameter to improve database performance, tuned Oracle SQL statements
• Responsible for Monitoring databases using OEM, Quest Fog-light and manual SQL scripts
• Carried Black Berry 24/7 and responsible for On-call Support once a week 24/7

ENVIRONMENT: Oracle 9.2.0.8, 10.2.0.3, 10.2.0.4, 11.2.0.1, Oracle Applications R12, Linux Red Hat 5.5, SUN Solaris 10, Veritas 5.0 Cluster, Oracle 10g Cluster on Windows, Oracle 11gR2 Cluster on Red Hat 5.6, SQL, PL/SQL, SQL LOADER, Export/Import Utilities, RMAN, Toad, VERITAS NetBackup™ 6.0

Confidential, Plainfield, IN

Lead Oracle Database Administrator

Responsibilities:

• Responsible for Tuning Oracle Databases to improve Order processing in ware house
• Responsible for performance and Tuning for Oracle databases, Tuned init.ora parameter to improve database performance, tuned Oracle SQL statements
• Upgraded the Oracle 9.2.07 database to Oracle 10.2.0.4 manually on Solaris OS.
• Responsible for installing Oracle quarterly critical patches, installed patches and Upgrades
• Configured Oracle to use VERITAS NetBackup™ 6.0 tape library
• Responsible for writing RMAN backup and Restore scripts and scheduled in crontab
• Installed Oracle 11gR2 RAC on two node Linux SUSE 11 Servers
• Created RAC databases using ASM
• Tested Client Fail-Over and implemented procedures to take Cluster down for maintenance
• Experienced in Leading DBAs working with them and helping to create projects planning providing guidance both technically and also functionally to complete projects
• Working with Application SMEs to provide recommendations on database design, architectural design and capacity planning
• Experienced in working on cost cutting projects without heavily impacting application performance and design

ENVIRONMENT: Oracle 9.2.0.8, 10.2.0.3, 10.2.0.4, 11.2.0.1, Linux SUSE 11, SUN Solaris 10, SQL, PL/SQL, SQL LOADER, Export/Import Utilities, RMAN, Toad, VERITAS NetBackup™ 6.0

Confidential, Indianapolis, IN

Lead Oracle Database Administrator

Responsibilities:

• Involved in gathering requirements and project planning of multiple database projects
• Responsible for Installation of Oracle Software on HP and Sun systems
• Installed Oracle RAC on Sun Solaris using Oracle cluster-ware software, on NFS mounted disks in VM-ware environment
• Responsible for creating databases, creating schema owners and database security for applications
• Analyzed recommended space and memory requirements for the data in database
• Responsible for installing Oracle quarterly critical patches, installed patches and Upgrades
• Upgraded the Oracle 9.2.07 database to Oracle 10.2.0.3 manually
• Upgraded the Oracle 8.1.7.4 database to Oracle 9.2.0.5.0 manually
• Cloning the prod database to development for testing purposes
• Used RMAN for Backup and Recovery of databases, Restored Databases on production servers in the event of an incident under pressure
• Responsible for quarterly health check testing of all databases also performed quarterly disaster recovery testing for all critical databases on production server
• Worked in ITIL environment and followed ITIL standards and procedures to perform tasks
• Responsible for documenting Disaster Recover procedure for databases and Involved in Application Disaster recovery drills
• Worked with different application end users including Java,, EJB, Siebel, UGS, Microstrategy, Cognos
• Served as a Primary DBA for all database servers on HP UX and Solaris
• Worked with EMC software like Replication Manager, EDM (Emc Data Manager) for RMAN tape backups and recovery
• Configured Oracle to use VERITAS NetBackup™ 6.0 tape library
• Configured EDM for RMAN Tape Backups
• Responsible for Oracle support on Multiple HP-HP-UX PA-RISC 11.11 servers and Multiple Sun Solaris 10 Servers
• Analyzed data in the incoming flat files to write SQL Loader control file scripts
• Wrote PL/SQL packages to update dimensions, facts, and code tables
• Estimate space requirements for tables and indexes
• Wrote PL/SQL packages tables purge tables based on the business requirements
• Tuned the queries using hints and materialized views
• Wrote end user Interfaces using Korn shell scripting for the end users to load the data mart
• Wrote scripts to backup data using exp/imp utilities
• Wrote scripts to populate the aggregate tables and indexes for agg tables
• Wrote script to update the statistics of the database and schemas
• Installed Oracle Database 10g Release 2 (10.2.0.1) on HP-UX PA-RISC 11 and Upgrade to 10.2.0.3 and applied CPU patch
• Manually Updated Oracle 9.2.0.7 database to Oracle 10.2.0.3
• Worked in both DBA team environment and also as sole DBA.
• Carried cell phone 24/7 for database and application support

ENVIRONMENT: Oracle 8.1.7.4, Oracle 9.2.0.6, 9.2.0.7, 9.2.0.8, 10.2.0.3, 10.2.0.4, HP-Unix 11, SUN Solaris 10, SQL, PL/SQL, SQL LOADER, Export/Import Utilities, RMAN, Toad, I.S.O Standards, EMC EDM, VERITAS NetBackup™ 6.0, EMC Replication Manager, SRDF replication

Confidential, Louisville, KY

Sr Database Analyst

Responsibilities:

• Involved in data modeling and project planning in data warehouse environment
• Analyzed space and memory requirements for the target data database
• Responsible for creating Referential Integrity for the tables
• Analyzed data in the incoming flat files to create SQL Loader control file scripts
• Wrote stored functions to format and substitute ssn with gemsid during loading
• Wrote shell scripts using SED, AWK tools to scrub junk characters and filter data in flat file before loading into tables
• Wrote shell scripts to automate data loading process for tables
• Created a package using UTL FILE package to update the table with source data coming in flat files
• Created Indexes, function based indexes and materialized views to improve query performance
• Wrote very complex queries by joining tables to create snapshots
• Worked extensively with Materialized to improve performance and to create snapshots
• Extensively used Explain Plan utility to tune all application queries
• Wrote a schema maintenance scripts that update statistics of all schema objects every night
• Supported whole application 24/7 and trained employees
• Involved in application project plans
• Interacted with end users to gather information about their Access applications
• Analyzed Access applications for a possible Oracle conversion as part of project planning
• Monitor 3 employees and helped them understand the project plan, scripts, and oracle database concepts
• Wrote user creation scripts for all Access applications
• Wrote a package to encrypt data using dbms obfuscation toolkit

ENVIRONMENT: Oracle 8.1.7.2, Oracle 9i, HP-Unix 11, SQL, PL/SQL, SQL LOADER, Export/Import Utilities, Windows 2000 professional

Confidential, Hyattsville, MD

Oracle Developer/DBA

Responsibilities:

• Involved in project plans for assigned database projects
• Created tables, queries, in Access 2000 database
• Created Tablespaces for different schemas and allocated different quotas for different schemas
• Coding complex stored procedures, triggers and other database objects
• Used Export/Import utilities for database backup and recovery
• Managed Backup and Recovery Scripts and shell scripts
• Loaded data in to oracle tables using SQL *Loader
• Extensively coded SQL *Loader control file for complex table structures
• Creating granting permissions, recompiling stored procedures and changing triggers
• Tuned SQL statements to improve the application performance
• Planning and troubleshooting of Rollback Segments
• Tuned the Application, Memory, I/O by using Utlbstat and Utlestat
• Used utilities like Explain Plan, DBVERIFY and Auto Trace
• Creating indexes, users on development databases to support performance tuning
• Involved in Oracle installations and configuration management
• Responsible for Oracle database server performance, tuning shared pool by tuning library cache, dictionary cache, and buffer cache
• Support the backup, recovery, consistency and security of the databases
• Responsible for solving application developer’s problems

ENVIRONMENT: Oracle 8.1.7, MS SQL Server 2000, Access 2000, SQL, PL/SQL, SQL PLUS, ERWin 3x, Visual Interdev 6.0, VB 6.0, Windows 2000 Server, Solaris 2.7