SUMMARY:

• Over 11 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing.
• Experience in Healthcare, Financial, and Telecom domains along with strong analytical problem - solving, organizational, communication, learning and team skills
• Worked with a team to provide 24x7 on-call production database support.
• Experience in HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g, 11g and 12c in UNIX/LINUX and Windows environment.
• Extensive Experience in RAC, EXADATA, ASM, DATAGUARD, Patching, Upgrades & Migrations.
• Experience in installation and maintenance of Oracle 10g and 11g RAC using both ASM and OCFS2 File System.
• Extensive Experience in Oracle Database administration of DATAGUARD & ADG 9i & 10g & 11g .
• Installed and Configured Goldengate for Migrating Database from HP-UNIX to Linux.
• Installation, setup and configuration of Oracle Streams
• Management of schemas, objects & Partitioning the tables & indexes.
• Involved in the data migration from sql-server/DB2 to Oracle.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup and TSM .
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Planned and implemented Disaster Recovery & high availability solutions using Oracle 11g Standby Database using Oracle Data Guard, 9i, 10g and 11g.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, Data Migrations using export/import, benchmarking using load testing tools
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Performance Tuning of test and production database, monitoring system. Tuning and diagnosing of database performance by query Optimization and trace facility Monitoring users, free spaces, table spaces and indexes.
• Performance monitoring/tuning/troubleshooting on Oracle, UNIX, Linux, and Windows Excellent interpersonal, analytical and problem-solving skills.
• Worked on different types of storage structures (SAN/NAS).
• Good co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3,6.1 Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP.

RDBMS: Oracle 12c/11g/10g/9i/8i, SQL Server 2000.

Languages: SQL, PL/SQL, C, C++,UNIX Shell Scripting

Tools

: TOAD, SQL Plus, SQL Developer RMAN, RAC, Golden Gate, Data guard, OEM, SQL*Loader, SQL Server, EXP, IMP, expdp, impdp, ERWIN.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

Other: VERITAS, NetBackup, TSM, EMC

Web Tools: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, TX.

Sr. Oracle Database Administrator

Responsibilities:

• Installation and Configurations of Oracle 12c,11g and 10g on Linux5 and AIX.
• Installed RAC on Oracle 10g/11g and worked on ASM feature of Oracle
• Involved in performing migration from Oracle 10g to Oracle 11g RAC database
• Migrated databases from File System to ASM and from Single Instance to RAC.
• Implemented DATAGUARD on 4 nodes Rac for disaster recovery.
• Worked on Exadata databases .
• Experience on Exadata Full rack/Half rack/Quarter rack.
• Installed and Configured Goldengate for Migrating Database from HP-UNIX to Linux.
• Installation and configuration of 32 bit and 64 bit 9i/10g/11g RAC on UNIX and Windows environment
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Upgradation and migration from Oracle10.2.0.3 to 11g & 12C.
• Added new asm disks to diskgroup while the databases were online and removed the old disks.
• Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces and other database objects and also did the patch management for oracle upgrade.
• Expertise in Client server GUI software and different Operating systems.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Responsible for refreshing testing databases with production data using RMAN Duplicate and Data Pump.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Have done database backup and recovery using RMAN/Cold backup/ Hot backup/ Logical.
• Setup backup and recovery procedure using TSM, RMAN
• Developed scripts to monitor the storage usage, object status for daily job and for RMAN backups, SQL*Loader, export and import of database.

Environment: Oracle 9i/10g/11g/12c, Oracle Enterprise Manager, SQL, TOAD, RMAN, RAC, Data guard, Golden gate, ASM, TSM, Data Pump, SQL Loader,AIX,Linux5,HP-UX, Windows NT/2000.

Confidential, Boston, MA.

Oracle DBA

Responsibilities:

• Have worked on different environments like test, development and production databases.
• Installed and configured Oracle 10g Real Application Clusters (RAC) on linux.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Analysis of the existing Data Warehouse system to understand existing functionality
• Worked on OLTP and OLAP database systems.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Implemented Oracle Streams for setting up reporting server
• Have worked on backup/recovery, performance tuning.
• Installation and creation of Oracle 9i, 10g databases on Production and Test Solaris servers.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Migrated from SQL server 2005 to oracle .
• Database Restore using RMAN, Cold Backup and Export.
• Worked on VERITAS volume manager and VERITAS Cluster Service.
• Involved in Design and implementation of oracle 10g Dataguard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Used importdp/exportdp and SQL- loader to load data into tables.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.
• Provided daily basis 24/7 Support to Mission Critical Databases.

Environment: AIX 4.3.3, HP -UX 11.23, Solaris 9, Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, XML, Load Runner 8.0, TOAD 8.1, Erwin, UNIX, Linux 4.0.

Confidential, Reston, VA

Oracle Database Administrator

Responsibilities:

• The work involved overall Maintenance of Oracle Database, Performance Tuning, Backup, Recovery and other database related activities.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery Plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Creation and maintenance of database. Handling day-to-day activities.
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backup.
• Storage and space management including table spaces and data files.
• Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles, Space management
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Environment: Oracle 9i, SQL, PL/SQL, TOAD, Sun Solaris 2.5, 2.6, UNIX Shell scripting.

Confidential, Philadelphia, PA

Oracle Database Administrator

Responsibilities:

• Support & Maintenance of Production/Development Databases on various servers.
• Install and create database, managing servers of other groups on call duty.
• Logical and Physical Modeling.
• Coordinate with Unix Administrators for space management on various servers and help in Oracle Installation, Upgrading from 8i to 9i.
• Capacity Planning, Storage Allocation and Space Management.
• Creating users, tables, database links , Performing Exports/Imports.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups
• Database Tuning - Tuning Applications, Tuning Memory and Tuning Disk Usage.
• Created PL/SQL Packages, Procedures and Functions for maximum performance
• Tuning Rollback segments , Sizing the database for future growth.
• Performing Database monitoring for deadlocked process and maintaining logs/Backups using Imp/Exp Utilities & VERITAS Backup system.
• Automating the process/Scheduling Jobs using DBMS JOB .
• Writing scripts for monitoring the database, Configuring SQL* Net. Integrating multiple application databases with multiple corporate entities, receiving business data feeds.
• Fine Performance Tuning the Databases for optimization, Tuning Application, Estimating Table & Index Size in TOAD7.5.5/7.6, Diagnosing the contentions, troubles using v$views.
• Stored procedures, packages & triggers to support the Front end/e-commerce.
• Supporting the Development team, supporting production Environment, Setting up passwords for SVRMGR and Listener, Sending out e-mails/alerts from the Database using UTL SMTP.

Environment: Oracle 8i/9i, OEM, DBCA, TOAD, Data Guard, XML, Sun Solaris, Test Director, CVS, Erwin, FTP, UNIX, Windows XP.

Confidential

Jr. Oracle DBA

Responsibilities:

• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT
• Analyzed the structures using Analyze command. Involvement in all phases of the project life cycle
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
• Developed PL/SQL functions and procedures to provide APIs for the front-end developers to manipulate the database efficiently.
• Involved in application Testing, Deployment, Production Support.
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code
• Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
• Implemented automated backup strategy using the UNIX shell script Cron Utility.

Environment: Windows 98/NT / 2000, HP-UX, Oracle 9i/8i/7, TOAD, Database Tools/Utilities.