SUMMARY:

• Over Eight 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, the configuration of Oracle 11g/10g.
• 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 for the interface.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Experienced in Troubleshooting and resolving critical production issues in complex application environments: SQL*net connectivity issues, locking, OS/network issues.
• Excellent knowledge of 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:

Project Description:

• 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 instances 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 the 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 data pump 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.
• Experience in working VMWare Server which is virtualization of server with RDB.
• Experience in large scale production databases;

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

Role: Senior Oracle DBA.

Project Description:

• Installed Oracle Database 11gR2 with Real Application Cluster (RAC) with CRS and ASM in the SOLARIS environment.
• 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 checkpointing, 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, tablespaces, memory structures, rollback segments, logs, and alerts.
• 24 X 7 on-call support of all production environments in a group supported by our team.
• Utilized Various Raid levels such as mirroring and striping 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.
• Written Shell scripting monitors the server’s performance and logs output on a periodic basis to the database using Perl Scripting.
• Experience in using the flashback feature of oracle throughout 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.

Role: 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 set up 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 downtimes.
• 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 a test environment.
• Performed Golden Gate setup, extract, pumping,and replication processes
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistics for the cost-based 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 Tablespaces with different block sizes to prevent row chaining.
• Installed, Configured, Upgraded & Applied patches for Prod & Dev Servers.
• Creating tablespaces, 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 the 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.

Role: Oracle DBA /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 applies 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 the 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, designing custom database objects as required and recommending 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 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 tablespaces 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.