Professional Summary

• Dedicated and result-oriented IT professional around 6 plus years of progressive information systems experience in Oracle database administration and implementing applications in heterogeneous system environment including Solaris, RHEL, UNIX and Windows, supporting a variety of mission critical applications in telecom, healthcare and financial environment. Immediate skill set includes Oracle 11g/10g, Golden Gate, Performance Tuning, Backup Recovery through RMAN, and Oracle Cluster Service. Experience working with various domains like Telecom, healthcare andFinancial to deliver new products, upgrades. Resolve application problems to maintain high level of customer satisfaction.
• Experience in setting up Database Server, Server Configuration, Installing and ConfiguringOracle on Sun Solaris, Red Hat Linux, and Windows platforms.

• Experience in Implementing Backup/Recovery strategies using RMAN, hot incremental backups and cold backups with RMAN, full/ partial backup with export/import and Data Pump.
• Experience in supportingProduction support databases running 24x7mission-critical / OLTP applications demanding high availability and increased performance.
• Experience on large Production database 200G to 20TB , Large Dataware housing databases and VLDB.

• Hands on experience in Installing, Configuring and Maintaining 10g/11g Real Application Clusters RAC 2 node clusters .

• Expertise in UNIX Shell Scripting and automated many common tasks using CRONTAB including: Backups, exports and imports, archiving old records and verification of such processes.
• Experience in Database Patching, predicting growth trends and Capacity Planning.
• Experience in Data migration and up-gradation from Oracle 8i/9i to Oracle 10g and 11g andfrom 11g R1 to 11gr2 database.
• GoldenGate replication solutions design.
• Install, configure and support uni-directional and bi-directional Oracle-to Oraclereplicated environments utilizing Golden Gate.
• Experience in System Development Life Cycle SDLC , which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in Database.
• Experience in Cloning and Replication production database refreshes onto various Database instances to investigate issues and to perform destructive testing.
• Experience in modifying and maintaining Oracle PL/SQL Stored Procedures, Table Partitions, Triggers, Packages,Tablespaces, Segments, Extents, Indexes, maintaining Data Files, Control Files, and Redo Log Files and setting PFile SPFile parameters.
• Worked extensively on GoldenGate 10.4.0.73, 11.1.1.0, 11.1.1.1 Versions with RAC and Standalone Databases.
• Troubleshooting database performance issues, generating STATSPACK, ADDM, Explain plan, TKPROF traces and AWR report for resolving performance bottlenecks and involved in SQL tuning.
• Analyzing Tables, Indexes periodically to optimize the SQL queries and assigning proper indexes such as BITMAP, B-Tree or Invisible Index according to requirements.
• Performing daily maintenance tasks like memory management, Tablespace management, Lock conflicts, and managing partitioned tables and indexes for better database performance.
• Experience in Extracting, Transforming and Loading ETL data using SQL loader utility.
• Experience in working with different FTP software's like WinSCP, Smart FTP, Cute FTP, SFTP and SCP.
• Supported Application Development in fulfilling Database requests and troubleshooting various Database issues.
• Application Support - Oracle 10g/11g experience. Common tasks include analysis of the particular system, which further included interaction with the end-users and the management to develop requirements and specification for the project.
• Worked as a Team member in performing tasks such as Strategic Planning, Logical and Physical Data Modeling Application Performance Tuning.
• Superior communication, presentation, Documentation, analytical and problem solving skill.
• Work well with all levels of business.

Technical Skills

Professional Experience

Confidential

ROLE: ORACLE DBA Developer

Responsibilities:

• Installed and configured Oracle Enterprise Manager 10G/11G Grid Control for Enterprise.
• Implemented High availability using Golden Gate Replication.
• Implanted Bi-directional replication using Golden Gate.
• Golden Gate performance tuning/troubleshooting.
• Done Initial Loads using Golden Gate processes, Expdp/Impdp, DB Cloning.
• Performed the migration and up-gradation of Oracle databases by using import/export, Oracle Data Pump, and Transportable tablespaces.
• Configured and Installed OEM 12c on production servers.
• Monitored production servers and databases through OEM12c.
• Configuring and Managing two nodes UNIX RAC environment for high availability, highly busy databases.
• Worked in Oracle 11g RAC environment and troubleshooting for RAC issues.
• Worked with Developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.
• Backup and recovery via RMAN scripts and troubleshooting.
• RMAN cloning of databases from source.
• Provided 24/7 production support for infrastructure and performance areas.
• Day to day troubleshooting like adding space in data files, rebuilding indexes, check alert log file and monitoring of system.
• Cloned databases on same node and also on different server nodes using custom shell script with hot and cold backups of source database.
• Upgraded and patched Oracle binaries in the development environment and production environment.
• Upgraded Oracle from 11.2.0.1 to 11.2.0.3.
• Responsible for setting up production, development, performance and staging database environments.
• Reorganized existing database to standardize the placement of various databases related files.

• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Monitored and audited database access for unauthorized access.

• Work as part of team and provide 24x7 supports when required.
• Golden Gate replication production support.
• Do general technical trouble shooting and give consultation to development teams.
• Have Applied Patches to existing versions.
• Created table spaces and managed table spaces adding/deleting/ resizing data files.
• Utilized SQL Loader ETL to perform bulk data loads into database tables from external data files.
• Use of Crontab, DBMS JOBS to automate the monitoring jobs.
• Performance tuning of application by identifying the SQL, which are not written well providing inputs to the application programmer correcting and implementing the right components.
• Administered all database installation, creation, modification, and tuning issues of Oracle.
• Performed SQL tuning by using Explain Plan and AWR/ADDM.
• Generated working documentation for the DBA team use.
• Analysis of alert log for error tracing.
• Resolved different locking issues.
• Worked on daily DBA activities.

Environment: Oracle 11g, Golden Gate, Sun Solaris/Linux, SQL Developer, ADDM/AWR, SQL, RMAN, OEM12c, SQL Loader.

Confidential

ROLE: ORACLE DBA

Responsibilities:

• Expert in replication using Golden Gate for one-sided replication as well as active-active configuration.
• Replication and Extracting data and applying on production using Golden Gate.
• Implemented Stream, Golden Gate for Active-Active Replication between the Datacenters for high Availability.
• Experience in data migration using tools like SQL Loader, Import/Export, migration scripts.
• Maintenance and Support for10g/11gRACInfrastructure components and Database.
• Configured Automatic Storage Management ASM .
• Oracle Installation on Solaris and Windows 2008 servers development .
• Provided 24/7 production support for infrastructure and performance areas.
• Proactive tuning and health monitoring for all production databases.
• Database monitoring with OEM and custom made scripts.
• Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time.
• Actively involved in Change Management team activities.
• Planned and Implemented disaster recovery system and backups using RMAN and custom written shell scripts.
• Upgraded Oracle from 10.2.0.3 to 11.1.0.6and 11.1.0.6 to 11.2.0.3.
• Manage Oracle RAC database configurations utilizing Golden Gate to ensure maximum availability and data protection.
• Performed the migration and up-gradation of Oracle databases by using import/export, Oracle Data Pump, and ETL processes.
• Performed various database migrations, refreshes as per requirements.
• Applied CPU patches each quarter to keep the databases up to date.
• Involved in implementing and configured Oracle 10g Grid to monitor all database instances and generating alerts.
• Done performance tuning with Golden Gate on 2-3 node RAC and Standalone Databases.
• Pro-actively monitoring and performance tuning databases including partitioning and Loaded bulk data with SQL Loader.
• Works on multiple ERP related business systems for support, enhancement and up-gradation.
• Setting up of regular backup Hot, Cold , recovery and regular testing of recovery in test environment, customization and automation of regular DBA activities and operating system specific tasks by way of shell scripts, SQL scripts.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection.
• Performed database performance tuning, STATSPACK reports automation, stress test on production copy for scalability, resolving production performance issues.
• Implemented Capacity planning for Databases.
• Tuning OS, storage and resolving I/O and contention issues.
• Worked with Oracle support to resolve various issues with the database by opening SR's.
• Database recovering using RMAN backup and Applied Oracle Security and DST Patches.
• Communication with Oracle support for identification of bugs and resolution for Service Requests.
• Assist to choice of software solution, aid for system completion and process, interfacing with presented systems, configuration of the tools for analysis.

Environment: Oracle 10g/11g,RAC,ASM, Golden Gate, Quest Toad Version 9.7.2, SQL Developer, SQL Loader,Solaris5.9, 5.10, Windows 2008 enterprise edition HP-UX, Oracle Enterprise Manager, OEM Oracle Enterprise Manager , VMware ESX/GSX server.

Confidential

ROLE: ORACLE DBA

Responsibilities:

• Installationof Oracle Database Software 10g/11g.
• Oracle RAC 10g/11g implementation on Linux platform.
• Cluster management and verifying cluster process to ensure smooth operations.
• Oracle 10g Physical and logical Data guard installation and maintenance for Reporting purpose.
• Performed Data Guard switchover/failover as per the requirements.
• SQL Queries/Application and Database performance monitoring and tuning using various tools like ADDM, AWR, Explain Plan, TKPROF and Statspack reports.
• Database Growth and Space management, capacity planning, table partitioning distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.
• Configuring parameter file to fix sizes of SGA components in conformity to available resources.
• Involved in logical backup using and full/ partial export/import and Data Pump.
• Used SQL Loader extensively to extract data from flat files and loading into the new application.
• Performed database analysis, design, coding, testing and implementation of database structures.
• Maintaining UNIX scripts for monitoring and backup.
• Database managing and monitoring using Oracle Enterprise Manager OEM .
• Oracle 10g Database upgraded to Oracle 11g Database.
• Involved in Database migration across the different OS versions.
• Planning, Scheduling and implementing database changes while ensuring no impact to users.
• Applied Oracle patches for DST, upgradation and migration of databases.
• Performed user administration, space administration on development and test database.
• Creating the database, tables, table spaces, and data objects, setting privileges, indexes, user password management, Security administration.
• Extensive use of Crontabin UNIX environment for scheduling routine tasks.
• Upgraded Oracle binaries in the development environment and production environment.
• Also maintain 24 X 7 uptime for the database while carrying out the activities.
• Create Users and Roles with appropriate privileges and roles.
• Performing regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery Instance, media .
• Performing hot/cold backup.
• Patch the database and Cluster ware as required.
• Data Modeling, ETL from spread sheets, paper files, fax documents, and MS access to Oracle, SQL, PL/SQL, Database Links, Data Warehousing, Audit Trails.

Environment:Oracle 10g/11g, IBM-AIX 5.3, Sun Solaris 5.10, Linux, Windows 2003, Oracle Enterprise Manager, SQL Developer, RMAN, Putty, SQL Loader.

Confidential

ROLE: ORACLE DBA

.Responsibilities:

• Installed and ConfiguredOracle 9i database instance running across two OracleRAC nodes on Red Hat Linux Server.
• Organizing Oracle Database operations, installation, creation, configuration of Databases, laying out database tables and database schema design
• Involved in the project of implementing and configuring Real Application Clusters RAC on Oracle 10g Automatic Storage Management ASM .
• Performance Tuning of Oracle Real Application Clusters.
• Set up the primary and standby databases for 24x7 availability using Oracle Data Guard.
• Designing strategy and upgrade path including pre-upgrade procedures, test upgrades and post upgrade steps.
• Upgraded Oracle 9.2.0.1 to 9.2.0.8 and 9.2.0.4 to 9.2.0.8 Database on Linux and Sun Solaris and also apply critical patches update CPU for latest versions.
• Used Oracle's Enterprise Manager OEM , Statspack Reports, Explain Plan, SQL Trace and TKPROF for tuning and monitoring oracle database.
• Used Export/Import and Data Pump utilities for full/partial backup.
• Database Cloning to create Test and Development environments from Production.
• Database Backup Strategy Design and Implementation.
• Setting up schedule RMAN Backup using DBMS SCHEDULER and CRONTAB.
• Used Oracle backup utility RMAN to implement Oracle backup.

• Used Flashback feature to recover a dropped tables and also to recover a database.

• Identifying issues/ bottlenecks that could potentially cause issues, involving the right teams such as server admins or application developers and take a corrective action to rectify the issues.
• Procedures and package Concepts were used to develop the tables for designing the applications.
• Logical and Physical Modeling using ERWIN Data Modeler.
• Creating Indexes,rebuilding indexes, analyzing indexes to improve the performance of query.
• Creating tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture.
• Day to day troubleshooting like adding space in data file, rebuilding indexes, check alert log file, trace file and monitoring of system availability, database availability, listener availability.
• Imported and exported files, databases, schemas and tables using SQL loader.
• Involved in applying Oracle DST patches in Oracle 9i.

Environment: Solaris 5.6/5.9, Red Hat Linux, TOAD, RAC, RMAN, Oracle9i, 10g, Windows 2003.