SUMMARY:

• Over Seven years of experience as Oracle DBA, providing 24/7 support for both development and production databases on Various Platforms like Red Hat Linux, IBM - AIX, Sun Solaris and Windows.
• Proficiency includes Production DBA, Tuning, Clustering, Backup and Recovery, Optimal Flexible Architecture.
• Experience in installation, configuration of Oracle 11g/10g.
• Experience implementing and using SHAREPLEX with advanced queuing.
• Experience in implementing real application cluster Oracle 11g/10 RAC.
• Experience in Disaster recovery support using Data Guard.
• Proficient in Delivering Oracle Database performance-tuning services for customers with Explain Plan, TKPROF, STATSPACK, SQL TRACE, custom scripts and wait interface.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Experienced in Troubleshooting and resolving critical production issues in complex application environment: SQL*net connectivity issues, locking, OS/network issues.
• Excellent knowledge on Oracle 11g/10g features like AWR, ASM, 10g Grid monitoring.
• Worked with development teams and data administration staff to enhance Database and application performance.
• Experience in backup and cloning using RMAN procedures.
• Experience in Data Migrations using oracle export/import, Data Pump, SQL*Loader.
• Proficient in using OEM and Oracle Grid Control.
• Experience in Proactive monitoring, identifying areas that need to be improved in the application and database.
• Expertise includes management of schemas, objects & partitioning the tables & indexes.
• Providing Solutions to the Problem Faced by end Users or Programmers.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.

TECHNICAL SKILLS:

Operating Systems: IBM AIX,HP-UX, Sun Solaris, RedHat Linux, Windows 95/98/ME/2000/XP/Vista - Windows 7/VMWare Server.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005, Access.

Languages: SQL, PL/SQL, UNIX Shell scripting,Perl scripting.

Tools: /App. Software: RMAN, OEM, SQL*Loader, EXP, IMP, TOAD,SQL*Navigator.

DBA Tools: SHAREPLEX,Dataguard,TKPROF, EXPLAIN PLAN, STATSPACK.

Network: TCP/IP .

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Senior DBA

Responsibilities:

• Worked in the group as a technical team lead providing support to development teams to create database objects, schemas, tables, indexes etc.
• Provided support to development teams to create database objects, schemas, tables, indexes etc.
• Administered Oracle Real Application (RAC) system.
• Implementing backup and recovery procedures including logical backup (RMAN), physical backup (online/offline) and integrating the backup procedures.
• Performed recovery from instance and media failures.
• Performed capacity planning and space management.
• Performed Installation, configuration, troubleshooting Oracle RAC Database in 11gR2.
• Assisted in disaster recovery procedures and recovery using Data Guard in both 11gR2 and 10g.
• Responsible for Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Scalability/HA solutions included Oracle RAC, implemented and supported Shareplex for Data replication, supported Oracle Golden Gate Replication and Active Standby(11gR2).
• Maintained users, roles and privileges in Oracle database for the development team.
• Carried out disk space maintenance on various UNIX servers. Provided suitable mount points for each database and additional disk space for testing purposes.
• Provided Oracle installation support, database maintenance, version control for source code and backup using RMAN with new features of 11gR2.
• Provided 24x7 on call production support to troubleshoot complex and sometimes cross-platform issues.
• Extensively used datapump which is a feature of Oracle 11gR1 throughout the project.
• Developing and reviewing PL/SQL stored procedures.
• Created physical and standby databases in a Data Guard environment to use as reporting and an alternate failover database.
• Have assisted several project managers in reporting and activity management on a daily basis.
• Used Oracle Exadata for DBA activities and advanced queuing while replication.
• Performed cronjobs mostly backup jobs using crontab utility in Linux Operating System.
• Experience in using TOAD for SQL Development and DBA tasks.
• Experiance in working VMWare Server which is virtualization of server with RDB.
• Experiance in large scale production database;

Environment: Oracle 11gR2/10g, Red Hat Linux, Golden Gate,SQL Loader, Toad, OEM, Shell Scripting

Confidential, Milwaukee, WI

Senior Oracle DBA

Responsibilities:

• Installed Oracle Database 11gR2 with Real Application Cluster (RAC) with CRS and ASM in SOLARIS environment.
• Configured RAC Physical standby database for RAC primary using ASM filesystem in 11gR2.
• Worked on creation and deletion of RAC resources like listener/instance and database.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing oracle processes and increasing SGA overall .
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Capacity Planning: Allocate system storage and plan future storage requirements.
• Monitoring and maintenance of multiple databases for production, development, testing.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• 24 X 7 on call support of all production environments in group supported by our team.
• Utilized Various Raid levels such as mirroring and stripping with parity.
• Data migration between environments using Export/Import, expdp/impdp, Transportable Tablespace and Oracle Streams.
• Implemented Golden Gate Technology on Oracle 11g/10g.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Worked on development of PL/SQL stored procedures, Triggers.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Have automated/monitored backup strategies for different databases.
• Administered Oracle Real Application cluster (RAC) system both 11gR2/10g.
• Written Shell scripting which monitors the server’s performance and logs output on periodic basis to database using Perl Scripting.
• Experience in using flashback feature of oracle through out the project.
• Oracle Exadata Management was efficiently used in the project.

Environment: Oracle 11gR2/10g, RAC, RMAN, PL/SQL, Stored procedures, SQL*Loader, Toad for Oracle, GoldenGate, OEM, SQL Loader, UNIX, Solaris, Linux, AIX 5.x, Windows

Confidential, Hightstown,NJ

Senior Oracle DBA

Responsibilities:

• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace, TOAD.
• Assisted in configuring disaster recovery procedures using Standby Data Guard setup.
• Refresh/Cloning of Database and applications for development,testing.
• Involved in taking periodic Backup of the Database and the software using RMAN.
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• Performed Performance tuning for optimized results using tools like Explain Plan, TKPROF and STATSPACK.
• Performed ASM Configuration, maintenance and monitoring.
• Resolving any databases issue like database down, file system space issue, Agent issue etc.
• Worked in the matters of performance issues, major reorganizations and auditing the required down times.
• Migrated flat files from different sources into Oracle Database using SQL*Loader.
• Performed Cross Platform transformation of the databases.
• Worked with Real Application Cluster (RAC) database in test environment.
• Performed Golden Gate setup,extract,pumping and replication processes
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Managing archived redo files, DB-links, Partitions and monitoring Alert Logs.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity
• Wrote database PL/SQL stored procedures, triggers and procedures to provide backend security and data consistency.
• Extensively used Oracle Exadata throughout the project.
• Creating and Managing Table spaces with different block-sizes to prevent row chaining.
• Installed, Configured, Upgraded & Applied patches for Prod & Dev Servers.
• Creating table spaces, tables, and users for custom applications. Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required Capacity Planning & Benchmarking using analysis from STATSPACK reports.

Environment: Oracle 10g, RAC, RMAN, GoldenGate, TOAD, Sun Solaris, UNIX Scripting, LINUX, AIX,PL/SQL.

Confidential, Newyork City, NY

Oracle DBA Developer

Responsibilities:

• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have worked on different environments like test, development and production databases.
• Have worked on backup/recovery, performance tuning.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Database Restore using RMAN, Cold Backup and Export.
• Setup, configured and managed oracle 9i RAC database for high availability.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.
• Monitoring the table growth, database growth, current users, and system resource usage and so on. Experience in SQL*Loader, loading data from text files.
• Knowledge in writing shell scripts for automating backups and restoration

Environment: AIX 4.3.3, HP -UX 11.23, Solaris 9, Windows XP, Oracle 9i, RAC, OEM, RMAN, DBCA, Data Guard, Putty, Java, XML, Load Runner, TOAD, Erwin, UNIX, RHEL Linux 4.0.

Confidential, NY

Oracle DBA cum Developer

Responsibilities:

• 24x7 production support for several missions critical systems which utilize multiple Oracle 9i, 10g, 11g databases.
• Installation, maintenance and tuning of Oracle 10g RAC/11g RAC database for high availability.
• Performed upgrades from Oracle 9i to 10g, 10g to 11g
• Involved in Design and Implementation of physical/logical standby databases for disaster and reporting
• Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Closely monitoring and administering log transport services and log apply services in physical/logical databases.
• Used shell scripting for RMAN backups and hot backup and recovery.
• Devised and implemented backup strategies for hot, cold, export and RMAN using shell scripting.
• Implemented Backup using RMAN (Recovery Manager) as a media management layer.
• Have worked on building complex logical data models, reverse engineering and forward engineering using sophisticated modeling techniques and tools like Erwin and Visio.
• Improved the performance of database by creating and managing database objects such as tables, Indexes, Partition tables, Index Organized tables, material views and views.
• Performance tuning i.e. tuning RAC, applications, shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/ Logical I/O and Memory usage.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Consulting and advising with developers on the design of applications having complex database considerations, design custom database objects as required and recommended data access solutions that best fit the needs of the application.
• Used export/import for schema, table and database refresh.
• Supported bi-directional replication using oracle streams and designed the conflict resolution.
• Installation and administration of GoldenGate.
• Implemented Range, List Partitions, Hash Partitions
• Creating and refreshing materialized views.
• SQL, PL/SQL programming. Written functions, procedures, packages and triggers.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects and also did the patch management for oracle upgrade.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and tuning.
• Have done database backup and recovery using(cold backup/Hot backup/ logical)

Environment: Oracle 10g RAC/11g RAC/9i, Red Hat Linux 4.x, Solaris 10, Sun v480, HP-UX11, AIX 5L, Windows NT/2000, TOAD 8.6, ASM, EMC, Oracle Enterprise Manager, Erwin 4.x, Visio, Warehouse builder, Data Guard, RAC, RMAN,TKPROF,SQL-Trace.

Confidential, COLLIERVILLE, TN

Database Administrator

Responsibilities:

• Manage data architects, data administrators and client enhancement requests.
• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams & failover.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Created tablespaces, tables, users for custom applications.
• Created and managed database objects such as tables, indexes, partition tables and views.
• Creation of Materialized views and partitioned the oracle tables to improve reporting performance
• Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Handling large database environments (Data warehouse) using ETL tool Informatica and Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Worked on recovering of database in case of Media Failure, Block Corruption, missing data files and accidental tables dropped.
• Setup backup and recovery procedures using RMAN.
• Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
• Wrote Shell Scripting for managing day-to-day activities and automation of backup.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF
• Wrote PL/SQL procedure, functions, packages for various requirements in the database. .