SUMMARY

• Over 10+ years of Information Technology experience which includes Oracle Database Administration (12c/11g/10g/9i/8i) on different operating system environments like Sun Solaris, Linux, IBM AIX, HP UX /Windows 2000/2003/NT/2008 and SQL Server 7/2000/ 2005/2008/2008 R2/2012 Administration.
• Experience in Real Application Cluster (RAC) Setup and Administration. Involved in configuring and maintaining Oracle 3 - node/2-node RAC for high scalability and availability.
• Expertise in configuring and maintaining Oracle Data guard for Disaster Recovery.
• Expertise in Installing Oracle Enterprise Editions until 12c on UNIX and Windows Servers. Good Working Knowledge on Grid Infrastructure, Weblogic Installations and maintenance.
• Experience in Creating Physical databases using Oracle ASM wif SAN at teh back end
• Good practical exposure on Upgrading Oracle Software across multiple versions. Extensively worked on Conversions from one RDBMS to another (eg: SQLServer to oracle)
• Expertise in setting up of RMAN backup and Recovery strategies wif teh help of UNIX shell scripting.
• Clone/Refresh of Production databases for testing and Development environments using Recovery Manager (RMAN).
• Extensive knowledge in using statspack, TKProf, Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for performance tuning.
• Expertise in working wif Oracle partitioning technology.
• Expertise in working wif loading tools like sqlldr, impdp, expdp, imp, exp utilities.
• Good Knowledge on VERITAS Netbackup, EMC and Netapps storage practices. Good understanding about Netapps Snap-manager for High availability solutions.
• Knowledge in setting up Oracle Enterprise manager (OEM) 12c/11g/10g. Installed OEM agents on UNIX/Windows platforms and configured teh TARGETS in teh repository for efficient monitoring of teh mission critical Production databases.
• Extensive Knowledge in using Tools like TOAD, Putty, Confio, Attunity, FOGLight, embarcadero-DB Artisan,SQL Developer,OEM for SQL/Oracle performance tuning.
• Worked on Oracle Streams, Golden Gate replication technologies and LOG Miner.
• Experience in handling Solaris, Red hat Linux, and Windows NT/ 2000/2003/2008/2008 R2 systems.
• Knowledge in downloading and applying Oracle Patches following CPU patch updates.
• Complete range of Oracle DBA activities including Day-to-day production database monitoring of alert logs, trace files Troubleshooting production issues and Performance Tuning issues.
• Installed & configured SQLServer database software (7/ 2000/20 ) associated database tools and performance monitoring software.
• Experience in Query Optimization and performance tuning. Strong in using SQL profiler to debug any issues.
• Good in T-SQL Programming skills.
• Expertise in setting up SQL Database Mirroring as Disaster recovery solution using various protection modes.
• Expert in creating and maintaining SQL Replication - Snapshot, Transactional and Merge. Worked on SQL to SQL and SQL to Oracle Replication.
• Good working knowledge in using SQLServer 2012 - Always On feature in Database Mirroring.
• Experience in setting up Log shipping on SQL 2000 and 2005 Servers.
• Performed several migrations from SQL 2000 to SQL2005, SQL R2.Currently involved in SQL 2008/2008R2 to SQL 2012 migrations.
• Extensive Knowledge on creating SSIS and DTS packages. Has trained developers to do teh same.
• Experience in applying SQLServer Service Packs and latest Patches from Microsoft.
• Implemented MS SQL Mutli Node Cluster (Active/Active and Active/Passive)
• Setting up MSSQL Mail - DBMAIL and SMTP Configuration for sending mails from SQLServer.
• Extensive Knowledge on creating and maintaining SSRS reports and working wif SSAS Analysis services.
• Knowledge on using dbcc utilities to Reorg, Rebuild indexes and fine tune SQL queries.
• Expertise in using powershell scripting to control Backup, Restore and DBA maintenance activities.
• Good in using Database Engine tuning advisor, Dynamic Management Views (DMVs) and SQLServer dash boards while troubleshooting performance issues.

PROFESSIONAL EXPERIENCE

Confidential, Roseland, NJ

Sr. ORACLE/SQL Server DBA

Responsibilities:

• Worked as Senior Database Consultant for Oracle and SQL Server.
• Involved in Migration of Sybase databases to Oracle and SQL Server environments for Wealth Management group.
• Established SQL Database Mirroring for SQLServer2008 R2 environment in maximum Performance Mode.
• Involved in Setting up Oracle DataGuard 11g as part of our Disaster recovery Solutions.
• Upgrading Oracle database from 10g to 11gR2 and from 11gR2 to 12cR1.
• Installing SQLServer 2008, 2008R2 and 2012 on Windows Servers.
• Implementing Maintenance tasks using UNIX shells and Windows powershell 2.0/3.0.
• Setting up Oracle ASM .Worked on migrating oracle Physical files from UNIX file system to ASM.
• Maintaining Oracle 11g RAC on a 2-node cluster wif Oracle DataGuard set up.
• Setup and maintenance of SQLServer Clustering on Windows 2005 and 2008 Servers.
• Setting up Replication between SQLServer to SQLServer and SQLserver to Oracle environments.
• Extensive knowledge on Setting up and maintaining Oracle Golden gate Replication technology.
• Setting up and maintaining Log shipping in some of teh SQLServer environments as a Business continuity solution.
• Upgrading SQLServer R2 and 2008R2 to SQLServer 2012 versions.
• Installing and configuring Latest Oracle Softwares on UNIX and Windows Servers.
• Installing and setting up of Oracle Grid Infrastructure, WebLogic and OEM 12c.
• Creating and maintaining Oracle table Partitions to enhance Oracle performance.
• Actively involved in Annual Disaster Recovery Testing for Oracle and SQLServer Databases.
• Well versed wif most of teh financial jargon and actively involved in Coordinating wif Vendors for any product enhancements or Application issues.
• Tuning Oracle performance issues using Statspack, AWR, ADDM and ASH.
• Tuning SQLServer performance issues using SQLServer profiler, Dynamic Management Views (DMVs), Database tuning advisor and dashboards.
• Designing and maintaining reports using SQLServer Reporting Services (SSRS).
• Building packages for in house projects using SSIS. Helping Developers solve any SSIS related issues.
• Providing assistance to immediate manager on Cost and storage estimations for teh next IT Budgeting.
• Performing DBA daily maintenance tasks and monitoring Jobs scheduled using AutoSYS.Good working knowledge on AutoSYS
• Supported Vendor related applications such as Eagle Pace, SUMMIT, Eagle Wings, and ATOM.

Environment: Sun Solaris, IBM-AIX,Oracle Linux Server(OEL), Windows XP/2003/2008 and 2008R2, Oracle 10g/11gR1/11gR2/12c, PL/SQL, shell scripts, Powershell 2.0/3.0,Toad, SQL Server 2005/2008/2008 R2 /2012, embarcadero,SQL Developer,OEM 11gR2, Confio,WebLogic 10.2

Confidential, Springfield, MA

Sr. ORACLE / SQL Server DBA

Responsibilities:

• Worked as Senior Database Consultant for Oracle and SQL Server.
• Managing all DBA related tasks pertaining to Oracle and SQL Databases.
• Includes DBA daily tasks such as monitoring Database health, checking logs, solving Production issues.
• Capacity Planning, Trouble shooting and Pro-active maintenance.
• Setting up Oracle 10g DataGurad as a Business continuity Solution.
• Designed Backup and Recovery strategies using Oracle Recovery Manager (RMAN ).
• Managing Oracle RAC 10g 3-node cluster environment wif Load Balancing on LINUX server.
• Involved in Upgrading Oracle 9i/10g databases to 10g/11g Enterprise Database softwares.
• Tuning Oracle performance issues using Tkprof, Statspack, AWR, ADDM and ASH.
• Configuring Oracle Streams replication on Oracle 9i databases.
• Setting up SQLServer Replication - Transactional, Snapshot as a High availability solution.
• Setting up and maintaining Log shipping technology in SQLServer 2005 and 2008 Servers.
• Involved in Upgrading/Migrating SQLServer 2000 to SQLServer 2005 and SQLServer 2005 to SQLServer2008.
• Working wif Developers involving Integration Services(SSIS) and Reporting Services(SSRS )
• Working wif Data warehouse team by setting up SQLServer Analysis Service (SSAS) on 2005 Servers.
• Tuning SQLServer performance issues using SQLServer profiler and dbcc commands
• Maintained SQLServer 2005 Active-Passive cluster configuration in SQLServer 2005 environment.
• Had always been on Disaster Recovery team and involved in smooth completion of annual DR testing.
• Manage complex Production environments which include around 100 Production Database environments.
• Mentored Junior DBAs and documented all DBA duties to be performed.
• Installed and configured most of teh Oracle and SQLServer Database software tools and utilities.
• Part of a highly talented Infrastructure Team. Responsible for supporting teh entire IT infrastructure of teh Company.
• Strict adherence to Change Control Procedures. Worked wif Audit Controllers of teh clients, once every year.
• Worked on Several In-house Projects in Conjunction wif Systems teams and Business Partners. Actively participated in Project planning and execution phases.
• Supported major Vendor related applications such as Murex for accounting, Golden Source for Securites,CDO etc.
• Regular Coordination wif DBA teams at OffShore supporting Nightly activities.

Environment: Sun Solaris, LINUX, Windows XP/2003/2008, Oracle 9i/10g/11g, PL/SQL, shell scripts,Powershell,Toad, SQL Server 2000/2005/2008, embarcadero,SQL Developer,OEM 10g,Attunity,FogLight.

Confidential, Naperville, IL

Sr. Oracle DBA

Responsibilities:

• Preparing teh DBA project plan, DBA project estimation and teh execution plan
• Involved in setting up teh Disaster Recovery plan for Business continuation.
• Involved in logical migration/transferring of around 50 databases spread across teh world to teh DataCenter
• Maintained around 60 production and 70 test instances.
• Supporting both production and development activities.
• Creating databases for Testing, Development and Production.
• Installing various versions of Oracle software in UNIX and Windows Servers.
• Involved in manual as well as Oracle RMAN backup and recovery
• Helping teh Business users in creating teh new database links.
• Restoring teh data from teh backup tapes.
• Database recovery / crashes using hot /cold backups and dump/loads.
• Configured and implemented Physical Standby DB using Oracle DataGuard.
• Reorganized existing database to de fragment database objects like tables and indexes.
• Managed logical/physical backups for these databases depending on teh nature of database set up either full export, partial export or export of just teh structure of schema objects.
• Recovering teh databases using point-in-time recoveries.
• Migration of teh central databases from oracle 8i,9i to 10.2.0.2 version
• Developing UNIX shell scripts to automate teh Database maintenance processes.
• Extensively used import/export utility to handle change requests.
• Coordinating wif Application teams while trouble shooting any Database related issues.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, statspack.
• Involved in 24x7 production support

Environment: Sun Solaris, IBM-AIX, Windows NT/2003/Xp, Oracle 8.1.7/9.2.0.4/10.2.0.1, PL/SQL, shell scripts, Toad, SQL Server 7.0/2000

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 8.0.5 /8.1.x on Solaris 2.6, Windows NT
• Creation of databases for Testing, Development and Production
• Every day lights on activities (Monitoring database and Operating system)
• Space management issues involving resizing table spaces, data files and rollback segments
• Migration of oracle 7.3.4 databases to Oracle version 8.1.5
• Created Database triggers and stored procedures
• Automate backup jobs (hot, cold and export) and performed regular test recovery to validate teh backups
• Performance Tuning at Database Level.
• Provided 24x7support (on call) to all end users of teh applications related to Databases.

Environment: Windows Servers, Sun Solaris, Oracle 7.x, 8i