SUMMARY:

Senior Oracle Database and SQL Server Administrator with around 10 years of experience in Oracle Administration in planning, installation, configuration and upgrades of Oracle 11gR2, 10G, 9i, 8i databases including applying patches under Linux, HP-Unix, Sun Solaris and Windows platforms. Experience includes managing Oracle 9i, 10g and 11gR1, 11gR2 RAC environments using the OEM Grid Control tools. Experience includes using Golden Gate to support data replication in the Oracle database environment. Experience includes Oracle Utilities Data Guard, Data Pump, Flashback and RMAN. SQL.

• Performing backups, setting up jobs, performing recovery on MS SQL Server databases.
• Installing, Upgrading and applying patches for various versions of SQL Server 2000, 2005, 2008 and 2012
• Strong programming experience in creating Packages, Stored Procedures and Functions, Database Triggers.
• Procedures using RMAN, VERITAS Net Backup. Worked with EXP/IMP,EXPDP/IMPDP to refresh the schemas and to restore the Dev, Test databases.
• Design, document, implement, and maintain all backup, recovery including disaster recovery.
• Over 3 years of experience in SQL Server Administration in installing, upgrading, applying patches on SQL Server 2000/2005/2008 and 2012, mirroring, log shipping, backup, recovery and scheduling jobs.
• Good experience of setup configuration, implementation of Oracle 11gR2 RAC two-node on Linux with ASM .
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support.
• Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
• Migrating and Upgrading the Databases between different environments and versions.
• Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases. Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
• Strong Exposure on High Availability Concepts RAC, Standby , Database Cloning, and Oracle Streams.
• Good experience in applying Critical Patch Update CPU Patches on Databases.
• Good experience in Oracle Clustering services CRS , VERITAS Cluster Services Quick I/O file systems and High Availability features. Extensive Knowledge of 10g and 11g ASM.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems. Performed complete multi-master replication with updateable Materialized views.
• Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Experience in Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions X3/X2 Quarter/Half Full Machines. Good experience in applying Critical Patch Update CPU Patches on Databases.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROF and ADDM reports. Proven ability of providing production support for 24X7 on multiple databases.
• Configuring log shipping For 2000 version , configuring mirroring in SQL Server

TECHNICAL SKILLS:

• Operating System UNIX, LINUX, Solaris, AIX, HP-UX and WINDOWS NT/2000, XP, SL Server 2005, 2008 and 2012.
• RDBMS ORACLE 11g/10.x/9.x/8.x and SQL Server 2008/2005
• Oracle Tools/Utilities RMAN, EXP/IMP, EXPDP/IMPDP, SQL Loader, DBVERIFY, TKPROF and STATSPACK,
• AWR, ADDM, OEM.
• Languages SQL, PL/SQL and UNIX Shell

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle and SQL Server DBA

• Planning, implementing and validating various versions of Oracle Databases to 10gR2 10.2.0.4, 11g R1 11.1.0.7 11gR2 upgrades on all the environments in a procedural approach Dev, Test, Stage and Production also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Installation of 11.2.0.3 RAC 3 node from the Scratch and the maintenance of the high available Databases.
• Migrated OCR and VOTING disks to newer disks by adding newer disks from SAN and dropping the old disks by using ASM's native rebalancing feature.
• Installation of ASMLIB rpm packages. Initialize the asmlib using oracleasm init command. Portioning the disks using fdisk/dd command.
• Installing and configuring Grid Infrastructure Database software. Troubleshooting using cluvfy handling common issues that arise during integration of the whole bugs, network issues, configuration files issues, OCR issue, deinstallation cleanup of Clusterware .
• Refresh/Cloning of Database and applications for development and testing purpose.
• Performing Backup/Restore of all the Oracle databases using RMAN.
• Performed migration of the oracle databases whose database sizes vary from 300 to 500GB from Oracle 10.2.0.4/11.1.0.7/11.2.0.1 to Oracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.
• Ran Scripts for Health Check on Exadata Storage Servers.
• Implemented Oracle Patches CPU PSU on the Compliance databases Device a plan to patch them.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Involved in Production Support for Critical Application Databases when needed.
• Installing agent 12c on the server. Adding High Available Database with CRS, Scheduling Backups through OEM12c.
• Scheduling jobs through oracle JOB SCHEDULAR, Crontab UNIX .
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.
• Environment: Oracle 11.2.0.3/11.2.0.1/11.1.0.7/10.2.0.4, Exadata X3/X2 Quarter/Half/Full RACK, OEM 12c, LINUX, IBM AIX , TOAD,SQL Developer.
• Performing backups, setting up jobs, performing recovery on MS SQL Server databases.
• Installing, Upgrading and applying for various versions of SQL Server 2000, 2005, 2008 and 2012
• Configuring log shipping For 2000 version , configuring mirroring in SQL Server

Confidential

Sr. Oracle DBA

• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2 10.2.0.1, 10.2.0.2 and 10.2.0.4 11g Release 1 11.1,11.2 11gR2 upgrades on all the environments in a procedural approach Dev, Test, Stage and Production also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Involved in installation, configuration and support of Oracle 11g RAC.
• Worked on using the Materialized views for large Data Replication between 2 production databases.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues.
• Implemented Oracle Patches CPU, PSU on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN.
• Recovering Databases when there is any Physical or Logical Corruption.
• Created routines for Daily, Weekly Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Implemented Transparent Data Encryption TDE for compliance related databases.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection. Also did Capacity Planning.
• Responsible for purging and archiving the production databases.
• Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
• Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time, ran SQL trace and generated TKPROF reports.
• Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.
• High level of tracing of Optimizer and SQL performance with events 10053, and 10046 etc, recommend any changes required.
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Scheduling jobs through oracle JOB SCHEDULAR, Control M, Crontab UNIX , Scheduled Tasks Windows and Maestro 7.0 Job Scheduling Tool .
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Used DBMS packages to schedule jobs, re-engineering, gathering statistics, mview refresh...so on.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used new oracle Metalink.
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
• Assisted developers with the Tuning during the development and tuned the applications.
• Environment: Oracle 9i,10.2.0.4,11.1.0.6, SQL Server 2000/2005, OEM 10g grid, SQL Loader, Windows XP, LINUX, Solaris5.9,TOAD,SQL Developer.

Confidential

Sr. Oracle DBA

• Resolved gaps between primary and standby databases Gap Resolution .
• Created physical standby database for disaster recovery from hot backup of primary database.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in installation, configuration and support of Oracle 11g RAC.
• Involved in 24x7 Oracle Production Database Administration.
• Performance tuning for optimized results using Explain Plan, SQL Trace, TKPROF and Statspack.
• Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98 of the time.
• Creating Tables, indexes, triggers to assist developers.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Was involved in developing a disaster recovery DR plan.
• Experience with Oracle Golden Gate software.
• Proficiency using Oracle Golden Gate and csscan utility.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Scripts for Health Check of Databases.
• Reading Alert Logs and User trace Files and Diagnosing the Problem.
• Writing UNIX shell Scripts and Scheduling through crontab.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• OS level activities like space monitoring of Mount points.
• Scripts for Analyzing of Tables and Rebuilding of Indexes.
• Taking periodic backup of the database and the software.
• Automation of Backups.
• Interfacing with Oracle Corporation for technical support.
• Environment: Oracle 9i,10.2.0.2,11.1.0.7,Maestro 7.0,HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL Loader, Windows XP, Solaris5.9.

Confidential

Oracle DBA

• Database Design, Backup Recovery.
• Tuning the Database and Analyzing the Database.
• Coding PL/SQL Shell Scripts, Design/Code reviews.
• The activities included the database administration of the various databases assigned to the division for the internal as well as external clients.
• Installation of the Databases, Environment Building to OFA compliancy.
• Backup Cold, Hot, Online, Exports, Performance Tuning, Remote sessions tracing.
• Recovery Manager RMAN Implementation and strategies, Various Database Recovery scenarios verification in advance.
• Altering the Database objects and files during maintenance.
• Implementation of RAC Technology.
• Database Maintenance, Data warehousing. Data Modeling using Erwin.
• Software design of medium/large business applications, Design methodologies.
• Database SQL design, E-R Modeling, Design and Development Of database design.
• Jobs Scheduling, Exports/ Imports, Space Management.
• Hot and Cold Database Backups and recovery, Shell Scripting, Restoration Tuning Memory.
• Troubleshooting and maintaining, Database Recovery, Automation of the Database Start up and Shut down. Database Migrations.
• Writing Stored Procedures, functions, packages, triggers.
• Managing the network and service changes on the network of the databases.
• STANDBY Database implementation and Automation of the process KSH, LOADER, PL-SQL scripting combination of ftp download of files to proper load and update on tables.
• Writing shell scripts, Loading data into the database from the flat files with SQL Loader.
• Environment: Solaris 2.6/2.8, Oracle 8.0.5, PL/SQL, Perl, Windows NT shell scripting, TOAD.

Confidential

Oracle DBA

• Involved in the process of tuning and refining queries of various applications.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Wrote scripts for Startup, Shutdown and automation of backups.
• Monitoring and Management of table space growth, extent growth.
• Storage and space management including table spaces and data files.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
• Performing all the Database Administration activities like installation, configuration, cloning, patching, upgrade, performance tuning, backup recovery, space management in database, user and roles administration, schema management.
• Involved in 24x7 Oracle Production Database Administration.
• Monitored Production Databases, Performed performance tuning, added data files, resized segments, and tablespaces.
• Installed and configured Oracle 10g.
• Migrated Oracle 9i database to Oracle 10g.
• Monitoring Database for fragmentation and correcting them.
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan.
• Planning and implementation of Backup and recovery procedures and Maintenance of Database.
• Performed Backup/Recovery using RMAN.
• Written scripts for Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Interfacing with Oracle Corporation for technical support.
• Environment: Oracle Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting.