SUMMARY

• OVER 10 Years of experience in the field of IT. Predominantly associated with Oracle Core Database Administration and Microsoft SQL Server Database Administration.
• Good Experience in 24/7 Production Environment Support.
• Strong capabilities with DB installation, setup and architecture (Oracle 11g R2, 10g).
• Migrating 9i,10g databases to higher version across platforms.
• Vast experience in designing, planning & implementation of Backup & Recovery strategies (RMAN, DATAPUMP).
• Maintain, monitor and administer both production and development servers.
• Sysadmin Activities, DB Administration & User management.
• Proven capabilities in handling complex performance issues. Good knowledge & experience using/interpreting tools like - STATSPACK, OEM, and AWR.
• Disaster recovery - data guard and other replication techniques.
• Worked 2+yrs on implementation, administration and troubleshooting Oracle Golden gate.
• Liaison with Oracle-Support for bug fixes and TARs/SR and OWC.
• De-fragmentation of database using export import.
• Setting up new environments (Development, Production etc).
• Database Patch Application using OPATCH.
• Database Refresh using hot backup and RMAN Duplicating.
• Oracle 11g and 12c OEM implementation, maintenance and troubleshooting the issues.
• MS SQL Server 2005/2008 (L2/L3 + tasks) - Proficient in installations, Architecture, Administration tasks, upgradations, Maintenance, Backups/restorations, SSIS deployments and administrations
• Excellent communication/presentation skills.
• Proven capabilities in managing and motivating team.
• Contributions during initiation of new & prospective businesses in the organization.
• Able to work efficiently with global clients, understand their requirements, give them value added services.

TECHNICAL SKILLS

Operating Systems: Linux, AIX, HP-UX, Solaris and Windows

RDBMS: Oracle 10g/11g, MS SQL Server 2005/2008 R2

Utilities & Packages: RMAN, Sql*Loader, Data Pump Import-ExportPL/SQL, AWR, ADDM, Statspack, OEM

GUI: Developer2000, OEM.TOAD

Skills: Software Installation | Upgrading & Troubleshooting | Administration | Patch & Change Management | Cloning | Performance Tuning | Unix Shell Scripting | Backup & Recovery.

PROFESSIONAL EXPERIENCE

Confidential, New York

Senior DBA

Responsibilities:

• Senior DBA responsible for supporting critical Subscription, Forecasting, and Reporting BI applications.
• Architecture & Administration of Oracle 11g hosted on Red Hat Linux.
• Installing 11gR2 database on RHEL 5 64bit operating system.
• Design, Develop & optimize complex processes in coordination with Business needs and ETL, to load huge data (ranging from 200GB - 1 TB) for reporting & forecasting.
• Install, patching, configure and upgrade software.
• Maintain Backup, restore & refresh technologies using Oracle RMAN & Data Pump utilities
• DB Performance tuning - resolve complex performance issues. Enhance performance. Extensive usage of Oracl12c OEM, AWR reports and plan optimization techniques.
• Plan, test & migrate the current infrastructure/servers onto latest & optimal technologies - Oracle 10g to 11g migrations, AIX to Linux migrations.
• Implement industry standard Security measures (User Security, CPU patching, DB Link optimization).
• MS SQL Server 2005/2008 R2 Administration.
• MS SQL Server installation, upgradatation ( R2/2008 R2 to 2012) & Patching.
• Great knowledge and hands on various aspects of MS SQL Server (user setup, security).
• Fine tuned and fixed many issues including patching slowness, and other driver failure issues.

Environment: Oracle 10g, 11g R2 Database technology, LINUX, Sun Solaris UNIX, SQL, OEM 12c

Confidential

Senior DBA

Responsibilities:

• Primary responsible contact for the Database from offshore. Promoted as Lead DBA in January 2010.
• Provide production support for critical databases, which consists the OLTP reservation platform and
• Market intelligence solutions. Oracle 11g, 10g, 9i databases hosted on RedHat Linux servers.
• Support process is modeled on ITIL framework. Incident, Service, Problem, Capacity & Change management responsibilities.
• Support mission critical application databases in a 24/7 mode.
• Install, patching, configure and upgrade software.
• Design, Implement and Manage DR environment.
• Design optimal backup/restore & refresh techniques by utilizing RMAN & Data Pump tools.
• Expertise in DB Performance tuning - Proficient use of AWR, Stats Pack & OEM reports to resolve complex performance issues.
• Responsible for testing and implementing automation techniques & other methods to simplify everyday operations. Example - important backup strategies (RMAN merge & incremental backups), write shell scripts to do DB refreshes/restores.
• Assist in design and support Data warehousing DB. The environment uses Oracle Business Intelligence (OBIEE); three load balanced databases, with version11g (11.1.0.7).
• Support replication done using Golden Gate software.

Environment: Oracle 10g, 11g R2 Database technology, Golden Gate 10, LINUX, Sun Solaris UNIX, SQL, OEM 11g, Golden Gate 10

Confidential

Database Administrator

Responsibilities:

• Supported Oracle 10g (mainly 10.2.0.3) and Oracle 9i Production and standby databases, as a System DBA. Hosted on AIX, Solaris and Linux servers.
• Provide the independent and primary on call support.
• Handle day to day issues related to Oracle instances and ensure high availability.
• Provide support as a system DBA to the various apps groups(eg - ensure availability/connectivity to the database, recover/restore in case of outages, monitor file system size - for the binaries, archive location - to be adequate, provide support incase of critical issues).
• Install, patching, configure and upgrade software.
• Manage Standby database, Data guard creation, switchover, DR tests Management.
• Responsible for High availability, 24/7, Maintaining 9i RAC environment and RMAN. Backups/restores.
• Support developers in tuning DB and apps for optimal performance.
• Monitor DB growth and provide DB capacity planning for apps expansion.
• Design and implement backup methods and disaster recovery strategies.

Environment: Oracle 10g,9i DB and Linux, Solaris, IBM AIX. 9i RAC

Confidential

Systems Analyst/DBA

Responsibilities:

• Problem Diagnostic and Fix(Resolving issues raised by developers, users or from Monitoring Tools).
• Daily Monitoring and Checks( OEM monitoring, checking alert logs Trace files etc).
• Maintenance/ House Keeping.
• Implementation of Change Requests (Implement approved changes raised by users or other processes).
• Backups and Recovery(database refreshes).
• Database administration (space management, resolving any Issues with jobs, user administration like grants, privileges etc).
• Maintaining standby databases troubleshoot issues pertaining.
• Administration of Oracle application servers, Oracle 10g (deploying applications, resolve any issues pertaining to Configuration etc) .
• Basic administration of a SQL server databases as well.

Environment: Oracle 9i DB and Linux, Solaris, IBM AIX.