SUMMARY

• Dynamic NINE years plus global IT career reflecting exemplary performance in Oracle Database Administration. Handling team in all capacities in ‘onsite - offshore’ model and have always been appreciated for being a people’s person.
• FOUR years of successful track record in maintaining relationships with the onsite clients; a keen understanding & insight into customer’s requirements and thereby, building a proposed solution. Presented on various project related and technical subjects within the organization.
• Working on RFP/RFI & technical documents for databases. Instrumental in successful implementation of knowledge transfer by closing the “know-do” gap for the offshore team regarding databases. Good knowledge of Oracle databases/options, DR Site, and data integration tools.
• Hands on experience with DR Drills and testing. A keen implementer & problem solver. Excellent people management; have driven & motivated teams towards target achievement and connected to them through ease of understanding & empathy. Effective communication skills.
• Good Adversity Quotient. Knowledge of Oracle Licensing. Member of DBA COE Transition team for Health Care ISU’s. Successfully implementation of database transitions for two US Healthcare clients in TCS. Traveled US on twice for transition process of database support to Offshore Team.
• Participated in various RFPs & technical documentation related to ‘Database Track’. Participated in Consolidations for all Oracle Databases to virtualize environment (Solaris Containers). Proposed migration of Solaris Containers to T4 Sparc Servers in RAC environment.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA & Tower Lead

Responsibilities:

• Delivering Monthly presentation to client related to team progresses & SLAs. Manage onsite customer relationships by ensuring high satisfaction & meeting customer requirements.
• Successfully carried out Data guard Switchover/Failover Testing Scenarios during Annual DR Drills & testing. Involved in project calls & activities with system managers and assisting them on queries related to databases.
• Helping business development team with the proposals and licensing information. Understanding Customer business Challenges and analyzing them. Performing database validation during SOX and FDA audits.
• Handling multiple calls on a weekly basis with client and stakeholders to capture database requirements. Setting a baseline for future project activities scheduled in Gilead. Inputs towards Level 3’s security policy and ensuring effective operations.
• Exposure in Databases Oracle 9i, 10g, 11G & 12c with Linux, Sun Solaris & Windows environment. Oracle databases Installations, Configuration & Administration of Oracle 12c/11G & 10G databases, Data Guard & Streams.
• Worked on database capacity planning, complex SQL queries, procedures & object types in the Oracle databases. Migration and up-gradation of Oracle databases from (9i to 10g, 10g to 11g & 11g to 12c) databases using DBUA, RMAN & Manual methods.
• Implementing, Managing and configuring database backups using traditional Export/Import, Data pump & RMAN. Experience in database documentation like Installation qualification, system analysis, design & development.
• Using database utilities Export/Import, OPATCH, DATA PUMP, SQL Loader, RMAN & OEM GRID. Monitored system performance using vmstat, iostat, sar & top. Experience with Golden Gate. Configuration of Physical standby databases with data guard broker.
• Hands on experience in Oracle Enterprise Manager (OEM) 10g, 11g & 12c, TOAD and SQL developer. Creating & managing new/existing users, granting privileges & refreshing data from prod to lower environments.
• Providing support to Sox applications databases like Prod, Val, DEV, UAT, POC and Test. Performance tuning with the help of AWR reports and diagnosing the issue using the ADDM reports. Performance tuning, explain plan, managing grants, privileges, policies, cloning & troubleshooting.

Environment:Oracle 10g/11g, OEM, RMAN, Data guard, Streams & SNAP Manager by Net App.

Confidential

Lead Oracle DBA

Responsibilities:

• Managing and leading DBA offshore team of 7 at offshore. Switchover/ Failover Data Guard Activity. Regular and timely report service levels to the client and reporting monthly business review and feedback.
• Hosting multiple calls with client and DBA manager to meet client expectations and future project deadlines. Manage customer relationship ensuring high satisfaction and act as single point of contact for DBA team.
• Understanding business requirements and presenting SIPs to management and client for database track. Analyzing risk analysis related to database track & highlighting on a timely basis. Exposure in Databases Oracle 10g, 11G with Windows, Linux, and Sun Solaris environment.
• Oracle Databases Installations, Configuration and Administration. Space/device Management, SLA Monitoring, Recovery Management, Release Management, Change Management, Historical trend Analysis, Cloning Oracle Databases using Cold, Hot & RMAN backup.
• Migration and up-gradation of Oracle databases. The configuration of physical standby databases with data guard configuration. Looking for performance tuning with the help of AWR Reports, and diagnosing the issue using the ADDM reports.
• Managing OEM GRID for all the databases components. Managing backups using RMAN, Export/Import. Managing table spaces, data files, redo logs, tables and its segments.

Environment:Oracle 9i/10g/11g, OEM, RMAN, Export/Import Data Guard and Putty.

Confidential

Oracle DBA KOP, PA

Responsibilities:

• Exposure in Databases Oracle 9i/10g with UNIX, Linux, and Sun Solaris environment. Provided 24x7 Database support remotely to different databases like Prod, Dev, UAT and Test databases. Creating and managing new and existing users and granting privileges.
• Managing table spaces, data files, redo logs, tables and its segments. Performance Tuning, Explain Plan, Create user managing Grant, privileges, and Securities, Cloning & Troubleshooting.
• Monitor and troubleshoot backup and restore procedures, disaster recovery procedures to provide a high availability environment using RMAN, NAGIOS. Configure the database in Archive log mode & Refreshing the databases as per the request.
• Coordinating with product vendor and their technical support. Monitoring database process through DAM (GSI Monitoring tool), Enabled Audit Trail for Oracle & UNIX users.
• Coordinating with OS Team for the OS related issues and Entertaining ETL, PS teams for their jobs performance and tuning related issues on Database. Dealing with different ORA - XXXX errors including ORA - 00600, 07445 & coordinating with Oracle Support for RCA’s.
• Database Availability Monitoring and health check, Resolving database connectivity issues, Report generation, User-id creation/deletion, Recovery monitoring, Monitor Server availability, Database Availability Monitoring and health check, DB User Administration, Patch Management.
• Performance Tuning on Database/System, Troubleshooting, Security management, Space/device Management.

Environment:Oracle 9i/10G, OEM & TOAD 9.5.

Confidential

Database Analyst

Responsibilities:

• Exposure in Databases Oracle 9i, 10g with Windows/UNIX environment. Developing the PL/SQL procedures at Level 1 and execute SQL statement against the database and its objects.
• Developing backup and recovery policies and DBA Activities to monitor the performance of databases on 24x7 basis. Responsible of working on the Escalation Tickets and Maintaining Critical Reports.
• Checking alert log file / trace file for any error and resolving the problem and DBA support in distributed production/ development environment. Monitoring and optimizing OS Space and Table space using stored script.
• Responsible for day-to-day availability and integrity of Oracle applications for an enterprise level organization. Configuration of Listener & TNS Names and generating AWR reports and OSW logs.
• Controlling and monitoring of user access to the database including Granting and revoking of privileges and roles and table space quotas. Creating the Oracle Instance/Database using customized scripts. Managing table spaces, data files, redo logs, tables and its segments.

Environment:Remedy, Oracle 9i/10g.

Confidential

Technical Support Engineer

Responsibilities:

• Cisco VPN and Citrix Metaframe Installations, Configure & Troubleshooting of various types of SOHO Routers such as Confidential, Cisco, 2Wire & supporting Hub, Switches & Print Servers. Remote desktop troubleshooting through Dame ware and Net Meeting.
• Imparting training to new joiners. Provide support for wired as well as wireless networking products on IEEE 802.11a/b/g standards.