SUMMARY

• Eight plus years experience as a Oracle Database Administrator primarily worked on UNIX/LINUX (Sun Solaris, HP - UX,AIX, RedHat)/Windows environment, both in production and development environments.
• Oracle Database Administration including Analysis, Design, Performance Tuning, Backup and Recovery.
• Performance Tuning and regular maintenance/monitoring of Production Databases.
• Installed and configured of Real Application Clusters (Oracle 11g RAC, 10g RAC), Standby Databases (DataGuard) for High Availability and Disaster Recovery.
• Ugraded databases from Oracle 8i to 9i, 9i to 10g, 10g to 11g
• Capacity Planning, Physical & Logical Modeling. Disaster Recovery & Security Management.
• Experience in using Export, Import, SQL*Loader, OEM Grid Control, SharePlex, Golden gate.
• Migrated databases from Windows to LINUX, HP-UX,AIX to LINUX
• Analyzing, Coding and Implementation of Oracle based applications.
• Monitoring and management of various database components (logical & physical) like tablespaces.
• Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance of the database.
• Performance Tuning: Experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, OEM Grid Monitoring.
• Expertise in maintaining Database Roles, Users using Security Compliance Auditing, expertise in loading data from Flat Files using SQL*LOADER and External Table.
• Good experience in managing Very Large OLTP and Datawarehousing databases.
• Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
• Experience on Backup Methodologies (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Scheduling jobs through Oracle Job Scheduler, cronjobs (Unix) and Schedule Tasks (Windows).
• Experience on Recovering Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures and functions using Oracle tools.
• Excellent communication skills, strong analytical & logical abilities, problem solving skills and fast learning.

TECHNICAL SKILLS

Operating Systems: Sun Solaris, Linux, HP-UX, IBM AIX, WIN 2000

Languages: C, C++, SQL, PL/SQL, UNIX Shell Scripting,PERL scripting.

Database/Applications/Tools: ORACLE 7.x/8.x/9i/10g RAC/11g RAC, Recovery Manager (RMAN), Oracle, TSM, TDP, STATSPACK, AWR,ADDM,ASM,Developer 2000, SQL Loader, TOAD, OEM/GridControl, Erwin, Exadata, Remedy, Siebel, Maximo, Golden Gate.

Business Intelligence Tools: Informatica 6.5, Cognos 6.2

PROFESSIONAL EXPERIENCE

Confidential, Eagan, MN

Oracle DBA

Responsibilities:

• 24 X 7 Production Oracle database support and administration
• Installed, configured and maintained Oracle Databases.
• Evaluating, Supervise, plan, Installing Database servers, Database software, upgrading to new versions, co-coordinating with hardware changes and applying oracle database patches
• Involved in the implementation of High availability with Real Applications Clusters (Oracle 11g RAC, 10g RAC), Disaster Recovery solutions with Standby Databases (DataGuard).
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM
• Identify performance problems using wait event statistics.
• Monitor session-level wait events and collect historical data for root cause analysis Supported the development team at offshore in issue fixing, migrations of code & other support activities.
• Ugraded databases from Oracle 8i to 9i, 9i to 10g, 10g to 11g
• Scripted proactive & scheduled DBA related health analysis & monitoring including instance, index and log health, Maintenance ( Partition tables, Materialized views refresh, Reorg, index), PDA alerts.
• Capturing the database statistics and metrics for proactive database management
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Resolving Oracle listener and TNS names problems
• Install, configure, upgrade, migrate, patch Oracle GoldenGate and Veridata
• Debugged and resolved oracle GoldenGate on Linux and troubleshooted GG issues
• Monitored the growth of the database objects for capacity planning.
• Database Administration and Planning including database design, backup & recovery.
• Developing a backup and recovery strategy and performed backups and recoveries.
• Re-organizing the tables for better response time.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented data replication through materialized views, GoldenGate.
• Capacity planning and bench marking
• Developed PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 11g RAC,10g RAC,9i, DB2, RedHat Linux, Sun Solaris, HP-UX, IBM Aix, Grid Control, DataPump, RMAN, ASM, TOAD, SQL, PL/SQL, ERWIN, Golden Gate

Confidential, Dublin, OH

Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration.
• Applying patches for both Server side and Client side.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrading of the oracle databases from Oracle 9i to Oracle 10g.
• Standby Database (Data Guard) setup and configuration.
• Global operations and maintaining database using Oracle RAC and Data Guard/Standby databases.
• Involved in the implementation of High availability with Real Applications Clusters (oracle 11g RAC, 10g RAC), Disaster Recovery solutions with Standby Databases (DataGuard).
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF
• Working alongside programmers and contributing to the development process
• Involved in the Oracle GoldenGate installation, configuration, troubleshooting GG issues
• Creation of the Test, Development and Production Oracle 8i/9i/10g databases.
• Installed and configured of oracle 10gR2 RAC.
• Proactive Support, tuning & troubleshooting of production database.
• Managed backup recoveries, replication, data integrity validation,
• Upgraded databases, Applied patches
• Scripted proactive & DBA related health analysis & monitoring including instance, index and log health, Maintenance ( Partition tables, Materialized views refresh, Reorg, index), PDA alerts.
• Scheduled & coordinated database maintenance activities including such items as database reorganizations, restructures, migrations, tuning, SOX ( Sarbanes-Oxley Act) sensitive views, materialized views & staged data refresh.
• Capturing the database statistics and metrics for proactive database management
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Monitored the growth of the database objects for capacity planning.
• Migrated databases from windows environment to HP-UNIX servers.
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Developed and implemented a backup and recovery strategy and tested.
• Loading data from flat files into Oracle Database using SQL*Loader, External Tables and automated the process by using UNIX Shell scripting.

Environment: Oracle 10gRAC,9i, RedHat Linux, HP-UX, IBM Aix, OEM, RMAN, SQL*Loader, Oracle GoldenGate

Confidential, Denver, CO

Oracle Database Administrator

Responsibilities:

• 24x7 Oracle Production Database Administration.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Working alongside programmers and contributing to the development process
• Planning and recommendations for optimum performance
• Defining and Setting backup and recovery procedures.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF, STATSPACK, AWR, ADDM
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Optimal Space utilization in table space by avoiding fragmentation
• Usage of Partitions to improve the query performance and manageability.
• Installation of Oracle RDBMS server software and version upgrades.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Participated in Disaster Recovery Drills, documented database and application validation steps
• SQL and PL/SQL Programming
• Installation and configuration of Oracle Client software and Tools.
• Installation, Configuration, Maintenance of Oracle Applications.
• Automated the process of analyzing tables every night.
• PL/SQL Programming (Functions, Procedures,Packages and Triggers)
• Capturing the database statistics and metrics for proactive database management
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Resolving Oracle listener and TNS names problems
• Developing a backup and recovery strategy and tested several recovery scenarios.
• Perform ongoing database administration, maintenance, troubleshooting, tuning, installation, backup and recovery.
• Estimated Storage capacity for database objects.
• Monitored the growth of the database objects for capacity planning.
• Database security, job scheduling and documentation.
• Investigating suspicious database activity using auditing.
• Applied DST (Daylight Savings Time) patches

Environment: Oracle 10gRAC,9i, 8i, Sun Solaris, RedHat Linux,OEM, RMAN, SQL*Loader, PL/SQL

Confidential

Oracle Database Administrator

Responsibilities:

• Database Administration support for Production, Development and Test Databases
• Installed Oracle 10g, 9i databases
• Attend meetings with data modelers, developers and other DBAs in the organization
• Backup/Restoration, scheduling Backups, taking Backups
• Coordinate with Unix Administrators for space management on various servers
• Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Migrated database’s from windows environment to Linux servers.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Support & Maintenance of Production/Development Databases on various servers.
• Logical and Physical Modeling using ERWIN.
• Creating users, roles and managing privileges.
• Creating tables, views, synonyms, database links
• Developed several PL/SQL programs functions, procedures, packages and triggers
• Automating cloning, backup and repetitive tasks
• Writing scripts for monitoring the DB, Configuring SQL* Net,Integrating multiple applications
• Performance monitoring and tuning using SQLTRACE, EXPLAIN PLAN, STATSPACK, AWR, ADDM
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions)
• Refresh/Cloning of Database and applications for development, testing
• Backups and Recovery i.e. exports/imports, hot archive log backups, cold offline backups, etc

Environment: Oracle 10gRAC,9i, 8i, Sun Solaris, IBM Aix, RedHat Linux,OEM, RMAN, SQL*Loader