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

Experience

Confidential

Role : Senior Oracle 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 2005 to 2008 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

Role : 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

Role : 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

Role : 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.