Project Oracle

**** - ******** **,

MUNDELEIN,

IL – *****.

Cell: 1-646-***-****

email: ******@*******.***

Nagendrapandian D

Profile

** ***** ** ********** ** an Oracle Database Administrator in Oracle 8.x/9.x/10.x/11.x on Unix environment and involved in backup and recovery methodologies, monitoring database performance etc. and total IT experience of 13+ years.

Completed Oracle Certified Professional (OCP) for Oracle 9i, 10g and 11g.

Involved in Data Center migration (Server Migration) for SAP Oracle (size between 120G to 5TB) Databases for more than 140 systems in hp-ux servers and automated this entire data transfer from One DC another DC.

Handled nine applications as Primary DBA and two applications as Secondary DBA in Xerox.

Database monitoring, maintenance and 24x7 on call support for production databases pertaining to various Xerox applications, sizes varying from 5 GB to 1.2 TB.

Database parameter modification for performance

Build Standby database and written a script to monitor standby database, also will receive TEXT when number of unapplied logs crossed to count 50.

Archive log management and written a script to send an email and TEXT when threshold reached 90%.

Database upgrade from starting 9.x to 10.x and 10.x to 11.x

Applying the Oracle PSU, CPU and Bug patches.

Creation and maintenance of tables, indexes, sequences, constraints, procedures, views, functions and packages.

Database Space management.

Database Security management (user/role creation and maintenance, scrubs).

Database Audit setup and monthly reviews

Administered database backup and recovery procedures.

Defined backup procedures using Export/Import, Hot / Cold.

Deployed RMAN backup across all production and development databases and written a scripts to send backup status in email as successful or failed. Also if it is failed then the written script will send TEXT to all DBA.

Deployed DATAPUMP backup procedure across all production and development databases and written a script to send backup status in email as successful or failed. Also if is failed then the written script will send TEXT to all DBA.

Routine activities like refreshing the test database with the Traditional and RMAN backup of production databases, refreshing the schemas using Datapump/export backup.

Setup Flashback in all major databases.

Written various types of scripts to monitor database and to send a TEXT to all DBA, when any abnormal happened to fix the issue before it goes to Sev 1, also automated some manual jobs.

Tuned the daily refresh to reduce the execution time from 17hrs to 8hrs.

Involved in various administration jobs, like storage of database objects, monitoring extents and max extents, partitions, tables and indexes.

Good communication skills, interpersonal skills, self-motivated, quick learner and team player.

Automated Database migration from one datacenter to another for more than 200+ databases.

Specialized in Automation of all Database Activities using Shell/Korn Shell/C Shell Scripts.

Visa Status - Valid H1B.

Skill Set

RDBMS: Oracle 8i, Oracle 9i, Oracle 10g and Oracle 11g

Languages: Oracle SQL

O/S: Windows NT/2000 Server, SUN Solaris 5.9/5.10, SCO UnixWare 7.1.1 & Linux 9.0

Tools: Oracle Enterprise Manager, Database Configuration Assistant, Export/Import utilities & svrmgr, TIVOLI, RMAN and Datapump (expdp).

Education:

Bachelor’s in Computer Science Engineering - 2000, Madurai Kamaraj University, India,

Certificates:

Oracle Certified Professional (OCP) for Oracle 9i.

Oracle Certified Professional (OCP) for Oracle 10g.

Oracle Certified Professional (OCP) for Oracle 11g.

Achievements:

Achieved GBS “Eminence & Excellence” Award - 2012

Achieved GBS “Eminence & Excellence” Award - 2013

Achieved “One Team One Dream” Award - 2014

Achieved “Top Contribution Award” - 2015

Professional Experience

Jul 10 – Till date, Oracle Database Administrator IBM India Pvt. Ltd. India

IBM is a global technology and innovation company that stands for progress. With operations in over 170 countries, IBMers around the world invent and integrate hardware, software and services to help forward-thinking enterprises, institutions and people everywhere succeed in building a smarter planet. IBM has been present in India since 1992. The diversity and breadth of the entire IBM portfolio of research, consulting, solutions, services, systems and software, uniquely distinguishes IBM India from other companies in the industry. IBM India's solutions and services. IBM has been expanding its footprint in India - and has a presence in over 200 cities and towns across the country - either directly or through its strong business partner network.

ABBVIE MAY 14 – JUL 15

ORACLE DATABASE ADMINISTRATOR

Project Description:

At AbbVie, they have the expertise of a proven pharmaceutical leader and the focus and passion of an entrepreneur and innovator. The result is something rare in health care today – a global biopharmaceutical company that has the ability to discover and advance innovative therapies and meet the health needs of people and societies around the globe.

As an Oracle Database Administrator my responsibilities are

Responsible for production and non-production databases in delivering solution to our customer in a proactive.

Responsible for Database monitoring, maintenance and 24x7 on call support for production databases pertaining to various applications, sizes varying from 120 GB to 5 TB for SAP and NON-SAP Databases.

Implemented RMAN backup for all the SAP and NON-SAP databases and configured with DD Boost.

Responsible for Database refresh from Production to Development and Quality to Eval Systems.

Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.

Responsible for planning SAP and NON-SAP database migration from one Datacenter to another Datacenter for around 200+ databases.

Automated the entire data transfer from one Datacenter to another Datacenter. Got Top Contribution Award for this task.

Implemented Standby Databases for 3 production databases.

Implemented Flashback in all major databases.

Responsible for Oracle database upgrade from 11.2.0.3 to 11.2.0.4 for SAP and NON-SAP Databases.

Responsible for planning database related activities and will take a concern from all appropriate teams. Then share the plan with customer to get approval.

Responsible for database Audit setup and monthly reviews

Responsible for database backups and to maintain the backups as per the retention period.

Written a various types of scripts to monitor database and to send an email to all DBA, when any abnormal happened to fix the issue before it goes to Sev 1.

Co-ordinate with Offshore and Onsite DBA and Application team for any kind of activities.

Environment: hp-ux B.11.31 U ia64, Oracle 11g/12c

Team Size : 8 (6 from Offshore and 2 from Onsite)

PROJECT - XEROX CORPORATION APR 10 – MAY 14

ORACLE DATABASE ADMINISTRATOR

Project Description:

For more than a half a century, Xerox has been a leader in document technology and services. We continue to build on this heritage of innovation. Xerox is the world’s leading enterprise for business process and document management, offering global services from claims reimbursement and automated toll transaction to customer care centers and HR benefits management. The new Xerox is dedicated to innovation, service and giving our customers the freedom to focus on what matters most: your real business.

As an Oracle Database Administrator responsibilities are

Responsible for maintaining database availability to support Level of Service metrics

Responsible for production and non-production databases in delivering solution to our customer in a proactive. Handling escalations in production and non-production environments

Deliver new innovations and complex high quality solutions to clients in response to varying business requirements

Responsible for Database monitoring, maintenance and 24x7 on call support for production databases pertaining to various applications, sizes varying from 8 GB to 1.6 TB.

Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.

Responsible for planning database related activities and will take concern from all appropriate teams. Then share the plan with customer to get approval.

Assist all team members for technical issues and to follow the process.

Responsible for database Audit setup and monthly reviews

Implemented and Configured RMAN backup across all applications. Created a scripts for L0, L1 and Archive log backup.

Automated Database refresh from Production to Non-Production database on weekly basis.

Reduced database refresh execution time from 10hrs to 5hrs using Standby database when it will be in READ-ONLY mode and after implemented the RMAN, refresh database is being done in 2 to 3 hrs for 500GB database.

Involved in Server migration activities from Solaris 5.9 to 5.10

Upgraded all Oracle databases from 9i/10g to 11g.

Responsible for database backups and to maintain the backups as per the retention period.

Coordinate with team members to complete the planned activities in a right time.

Written various types of scripts to monitor database and to send a TEXT to all DBA, when any abnormal happened to fix the issue before it goes to Sev 1, also automated some manual jobs.

Environment: SUN Solaris 5.9/5.10, Oracle 9i/10g/11g, TIVOLI, RMAN

Team Size : 6

Apr 08 – Jul 10, DBA Technical Associate, Mphasis an hp Company, Chennai, India

MphasiS consistently delivers Applications services, Infrastructure services, and Business Process Outsourcing (BPO) services globally through a combination of technology know-how, domain and process expertise. Our results focus on real improvement in business performance for our clients. We bring to our clients a credible and experienced global leadership team driving service delivery through the next generation global delivery model. We service clients in Banking & Capital Markets, Insurance, Manufacturing, Communications, Media & Entertainment, Healthcare & Life Sciences, Transportation & Logistics, Retail & Consumer Packaged goods, Energy & Utilities, and to Governments around the world.

PROJECT - XEROX CORPORATION APR 08 – APR 10

ORACLE DATABASE ADMINISTRATOR

Project Description:

For more than a half a century, Xerox has been a leader in document technology and services. We continue to build on this heritage of innovation. Xerox is the world’s leading enterprise for business process and document management, offering global services from claims reimbursement and automated toll transaction to customer care centers and HR benefits management. The new Xerox is dedicated to innovation, service and giving our customers the freedom to focus on what matters most: your real business.

As an Oracle Database Administrator responsible for production and non-production databases.

My role is as follows:

Responsible for production and non-production databases in delivering solution to our customer in a proactive.

Responsible for Database monitoring, maintenance and 24x7 on call support for production databases pertaining to various applications, sizes varying from 5 GB to 1.2 TB.

Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.

Responsible for planning database related activities and will take a concern from all appropriate teams. Then share the plan with customer to get approval.

Responsible for database Audit setup and monthly reviews

Responsible for database backups and to maintain the backups as per the retention period.

Written various types of scripts to monitor database and to send an email to all DBA, when any abnormal happened to fix the issue before it goes to Sev 1.

Environment: SUN Solaris 5.9, Oracle 8i/9i/10g.

Team Size : 10 to 12

Nov 05 – Apr 08, Oracle Database Administrator Nebula Computers Pvt Ltd (Franchisee of WIPRO InfoTech), Chennai

PROJECT - RANE Nov 05 – Apr 08

ORACLE DATABASE ADMINISTRATOR

Project Description:

Rane (Madras) Ltd is a part of the Rane Group of Companies involved in the manufacture and distribution of steering and suspension systems

As an Oracle Database Administrator my responsibilities are

Database monitoring, maintenance for production databases pertaining to various sizes varying from 5 GB to 20GB.

Database parameter modification for performance.

Archive log management

Creation and maintenance tables, indexes, sequences, constraints, procedures, views, functions and packages.

Database Space management.

Database Security management (user/role creation and maintenance, scrubs).

Administered database backup and recovery procedures.

Defined backup procedures using Export/Import, Hot backup & Cold backup.

Involved in various administration jobs, like storage of database objects, monitoring extents and max extents, partitions, tables and indexes.

Handled day-to-day database activities.

Environment: Windows, AIX and Solaris, Oracle 8i/9i/10g

Team Size : 5

Dec 01 – Aug 05, Technical Support Engg California Infotech Pvt Ltd, Bangalore.

As a Technical Support Engineer, following activities were my responsibilities.

Troubleshooting and Maintaining Desktop PC’s and Laptops.

Sharing Printers in Networks, Managing User Accounts, and Assigning rights to the Users.

Installation/ reconfiguration/ reinstallation of software’s.

Diagnosing and resolving of problems - H/w and S/w.

Install service packs, upgrades & Anti-Virus Updating.

Install software patches and upgrade.

Install and troubleshoot local peripherals.

Installation/ reconfiguration/ reinstallation of OS and application software’s.

Configuring email clients using Ms Outlook and Outlook Express.

Environment: Windows 98, XP, 2000 and 2003.

Team Size : 15

Contact this candidate