Oracle DBA

Isaivani Arumugam

Mobile : +919********* E-Mail : ********@*****.***

Professional Summary:

With an extensive 15+ years background in IT as Oracle DBA which includes 1.7 years of overseas experience in Netherlands.

Ability to perform DBA activities that span multiple phases of database application life cycle including Planning and Setting up Database infrastructure, Database Design & Security, Performance Tuning, Backup/Recovery, Database Upgradation/Migration, High Availability, Disaster Recovery & other Database related Development.

Leadership skills include ability to lead and motivate co-workers from all backgrounds, decisive and confident decision-making,strong analytical capabilities, client interacting skills and project management exposure.

Education :

(B.E) - Bachelor of Engineering in Electrical and Electronics Engineering BHARATHIAR UNIVERSITY, Coimbatore, Tamilnadu, India

Career Details :

Organization : Accenture Services Limited, Bangalore

Duration : Feb, 2011 – Jan, 2020

Designation : Senior Oracle Database Administrator

Organization : International Business Machines, Bangalore

Duration : Apr, 2007 – Feb, 2011

Designation : System Engineer

Organization : Wipro Limited, Mumbai

Duration : Jan, 2007 – Apr, 2007

Designation : Engineer – Database Administration

Organization : Accenture Services Limited, Mumbai

Duration : Jun, 2006 – Dec, 2006

Designation : Oracle Database Administrator

Organization : Hindustan Aeronautics Limited, Bangalore

Duration : Nov, 2003 – May, 2006

Designation : Oracle Database Administrator

Certification Details :

Oracle Certified Professional (OCP) in Oracle 11g.

Oracle Certified Professional (OCP) in Oracle 10g.

Project Details :

Client : Bank Of Ireland - Ireland

Location : Bangalore

Employer : Accenture, Bangalore

Duration : Jul, 2017 – Jan, 2020

Description :The Bank of Ireland is a commercial bank operation in Ireland and one of the ‘Big Four’ Irish banks.Historically the premier banking organisation in Ireland, the Bank occupies a unique position in Irish banking history. At the core of the modern-day group is the old Bank of Ireland, the ancient institution established by Royal Charter in 1783.Iit performed many central bank functions, much like the earlier-established Bank of Scotland and Bank of England.

Role : Lead Oracle DBA for pre production and Production support.

Environment :Oracle11g,12c,ASM,Redhat Linux, RAC, Exadata, RMAN,Data Guard,Golden Gate,Service Now,OEM.

Contribution:

oProviding pre-production and production support for Exadata database systems.

oPerforming Daily, Weekly and Monthly Health Checks for all pre-production and Production Exadata database systems.

oHandling tickets,incident management and planned change management via Service Now tool.

oMaintaining,testing,scheduling and adhoc backups and restore via RMAN.

oMonitoring dataguard replication status and performing switch over activities.

oTuning database performance by regularly monitoring AWR,ADDM and SQL trace reports via OEM.

oHandling database security by password rotation, User access management as per policy.

oExperience in Oracle Golden Gate Installation,configurstion and troubleshooting issues.

oCo-ordinating with Green CAB team and WAR team to perform required changes in production systems.

oFollowing the BOI standards as per TOM (Technical Operations Manual).

oResponsible for problem escalation to Oracle product support team and third parties as appropriate.

oCo-ordinating with management, IT peers, internal teams and business unit to provide technical solutions.

oTraining, Mentoring and upskilling DBAs and contributing in technical initiatives.

Client : Verizon Communications Inc., - USA

Location : Bangalore

Employer : Accenture, Bangalore

Duration : Jun, 2016 – Jul, 2017

Description :Verizon Communications otherwise known as Verizon, is an American multinational telecommunications conglomerate and a corporate component of the Dow Jones Industrial Average The company is based at 1095 Avenue of the Americas in Midtown Manhattan, New York City, but is incorporated in Delaware. In 2015, Verizon expanded into media ownership by acquiring AOL. Two years later, the company acquired Yahoo! Inc.; both AOL and Yahoo were amalgamated into a new division known as Oath.

.Role : Lead Oracle DBA leading implementation team to provide implementation,development Production support.

Environment :Oracle10g,11g,12c,ASM,RedhatLinux,11gR2 RAC,SQL databases, SQL clusters,team

management and application support.

Contribution:

oProviding Implementation and solutioning support for Databases systems.

oInstallation,Maintenance and backup of Oracle & SQL Server databases.

oDevelops database solutions by defining database physical structure and functional capabilities, security,back-up,and recovery specifications.

oUninstall,edition upgrade of SQL server databases and adding nodes to the existing SQL clusters.

oDesigning, administering, and supporting Oracle RAC databases on Linux Platform.

oImplementation designing and solutioning by reviewing customers contract form.

oHandling work orders,changes modification in existing customer system.

oAttending internal sales calls and customer calls to meet the requirement.

oCo-ordinating with CER team to provide solution on non-standard requirements of client.

oCreation of SOP,Build Manifest and customer Questionaire and upload to customer sharepoint Reviewing SOW to Implement database change requests and Manage databases, perform routine maintenance tasks.

oDiagnose the problems, to propose and set up the solutions adapted to the customer requirements.

oCreating monitoring users and roles to monitor databases via Netiq apps Manager.

oCo-ordinating with other internal teams storage,network,windows and Linux to track issues.

oTraining, Mentoring and upskilling DBAs and contributing in technical initiatives.

Client : Cox Communications - USA

Location : Bangalore

Employer : Accenture, Bangalore

Duration : Mar, 2013 – Jun, 2016

Description : Cox Communications (also known as Cox Cable and formerly Cox Broadcasting Corporation,

Dimension Cable Services and Times-Mirror Cable) is a privately owned subsidiary of Cox

Enterprises providing digital cable television, telecommunications and wireless services in the

United States. It is the third-largest cable television provider in the United States, serving more

than 6.2 million customers, including 2.9 million digital cable subscribers, 3.5 million Internet

subscribers,and almost 3.2 million digital telephone subscribers, making it the seventh-largest

telephone carrier in the country.Cox is headquartered at 1400 Lake Hearn Drive in Sandy

Springs, Georgia, U.S., in the Atlanta metropolitan area

.Role : Lead Oracle DBA leading technical architecture team to provide production &

development support.

Environment :Oracle10g,11g,11g,RAC,ASM,RedhatLinux,12cCloudcontrol,OEM,Dataguard,

and application support.

Contribution:

oProviding production support.

oImplementing new technical architecture as required to meet the needs of the business.

oDesigning, administering, and supporting Oracle RAC databases on Linux Platform.

oDatabase upgradation/migration from standalone to RAC.

oConfiguring and implementing backup and restore strategies by using RMAN.

oCloning development/test databases from standalone to RAC using RMAN.

oConfiguring and Administering Oracle 11g Automatic Storage Management(ASM).

oUser management and Space management.

oApplying Oracle PSU using OPatch utility for RAC.

oInstalling 12c OEM and agents.

oEnsure successful delivery of development tasks assigned within time.

oDiagnose the problems, to propose and set up the solutions adapted to the customer requirements.

oSingle point of contact for Techinical Architecture team by collecting metrices for the team,Risks & issues log maintenance and other process improvement related tasks for the team to prepare technical documentation.

oResponsible for Resource allocation/resource management/skillgap analysis.

oLeading the team to track issues with other internal teams.

oEscalate Issues affecting Client Satisfaction and imapcting project implementation and profitability to appropriate technical resources (internal systems administrators, suppliers).

oProviding weekly and Monthly status reports to higher management.

oRCA preparation, Mentoring and upskilling DBAs, Contributing in technical initiatives.

oResponsible for Project Planning, monitoring, maintaining & delivery within the set timeline.

Client : Sanofi-Aventis - France

Location : Bangalore

Employer : Accenture, Bangalore

Duration : Feb, 2011 – Mar, 2013

Description : Sanofi S.A. is a French multinational pharmaceutical company

headquartered in Paris, France, the world's fourth-largest by prescription

sales. Sanofi engages in the research and development, manufacturing and

marketing of pharmaceutical products for sale principally in the

prescription market, but the firm also develops over-the-counter

medication. The company was formed as Sanofi-Aventis in 2004 by the

merger of Aventis and Sanofi-Synthélabo

Role : Oracle DBA providing production support for 5 major entities of PO-US,

PO-Germany, NGDC, RnD and OSH.

Environment : Oracle 8i,9i,10g &11g, RAC, AIX, HP-UX, Red Hat Linux, OEM, HP

Open view Service Desk and Promise monitoring tool,Remedy,BBDA

Contribution:

oProviding production support.

oOracle binary installation, creation and maintenance of database in multiple versions.

oPlanning for production database Storage and capacity management.

oInstalling and Managing Oracle 10g and 11g RAC databases.

oDatabase upgradation/migration in different versions.

oRefreshing database from production to staging and development environment

oExport & import at full, schema level and object level.

oConfiguring and Scheduling RMAN Backups.

oPreparing backup, restore and recovery of Oracle database.

oCloning development databases from PROD using RMAN.

oConfiguring and Administering Oracle 10g/11g Automatic Storage Management(ASM).

oUser management and Space management.

oImplementation and Administration of Oracle physical standby database.

oApplying Oracle Critical Patch Updates (CPU Patches) and PSU using OPatch utility.

oHaving experience on in OEM GRID control.

oInstalling client as per request.

oMonitoring database performance and scheduling backup via OEM.

oManaging Database Performance using (Statspack, TKPROF, AWR, ADDM).

oTrouble shooting and resolving database issues.

oRaising service request and escalation for oracle support.

oHandling tickets by monitoring HPSD and BMC Remedy tool.

oCo-ordinating with different teams in the project and providing 24x7 support.

oPerforming other tasks as required by the team, such as user support, documentation, backup, etc

oHaving Business Operation knowledge for Pharmacutical RND Business

Client : Abn Amro Bank (AAB) - Netherlands

Location : Netherlands

Employer : IBM, Bangalore

Duration : Nov, 2008 – Feb, 2011

Description : ABN AMRO Bank N.V. is a Dutch bank, currently owned by RFS Holdings

B.V.,a consortium of Royal Bank of Scotland Group, the government of

Netherlands and Banco Santander. The bank was created as the result of

the 1990-91 merger between Amsterdam-Rotterdam (AMRO) Bank and ABN,

Between 1991 and 2007, ABN AMRO was one of the largest banks in Europe and

had operations in about 63 countries around the world.

Role : Oracle DBA providing Production Support for more than 130 production

and around 440 development databases.

Environment : Oracle 8i,9i,10g&11g, AIX, HP UX, HACMP, Oracle OMS, OEM, Tivoli,OPatch

Smile, RMAN

Contribution:

oProvided database support

oOracle binary installation, creation and maintenance of database

oInstalling and managing Oracle enterprise manager grid control

oDatabase upgradation/migration and patching using opatch.

oApplying latest security patch with Opatch utility

oMonitoring Database using OEM.

oReorganization of tablespaces

oRefreshing databases from production to development.

oSetting up and maintenance of Datagaurd/Standby Database.

oExport & import at full, schema level and object level.

oResolving performance and connectivity issues.

oTroubleshoot Oracle error and issues reported by developers/users

oRaising service request and escalation to Oracle support.

oAnalyzing statspack/AWR report and sqltrace

oUser management and space administration

oCreating database objects/Code deployment as per user requirements.

oDatabase backup and recovery using RMAN.

oManaging/Creating automated jobs for daily backup,analyze,reindex.etc using OEM.

oDeveloped application for health check, QEV and other daily DBA checks.

oLeading the oracle team and co-ordinating with Customers

Client : American Telephone & Telegraph (AT&T) - USA

Location : Bangalore

Employer : IBM, Bangalore

Duration : Apr, 2007 – Oct, 2008

Description : AT&T Inc. is the largest provider of fixed telephony in the United States, and

also provides broadband and subscription television services. AT&T is the

second largest provider of mobile telephony service in the United States, with

over 85.1 million wireless customers, and more than 150 million total customers.

Role : Worked as a Oracle Database Administrator for AT &T account applications.

Managed databases of Development/Test(ST,JST,UAT)/Production environments of applications on different oracle versions.

Environment : Oracle 8i,9i,10g on AIX, HP UX, Solaris &Linux,Opatch,Shareplex

Contribution:

oEstimating,Planning,Designing and Installation of Databases of various environments (Development,Testing and Production)

oDatabase Migartion from 8i to 9i/10g and space management

oSecurity user Management,Privileges,Roles,Auditing,Profiling and Authentication for local databases and remote or destination databases.

oEstablish & maintain Backup & Recovery methods of On-line hot archive log backups, Off-line cold backups,procedures,exp/imp,restore and recovery process.

oUsing Quest Shareplex for replicating databases & applying Patches both Server side and Client side.

oRefreshing and Cloning/Copying database with production cold /hot backup dump and using export/import utility.

oRemoving row chanining, Reorganisation / Rebuilding of fragmented tables and indexes for better performance

oWriting Unix shell scripts to monitor the database activities proactively,scripts for backup & recovery,Export/Import procedure,and automating shell scripts as cron jobs.

oPerformance tuning like,creating indexes,parameter changes, SQL tuning and Memory tuning like SGA,large_pool,java_pool etc.,

oBetter understanding of existing/implemented application system and business requirements.

oSupporting in production installation/deployments & providing 7x24 support at the time of production deployment.

Client : Dena Bank - India

Location : Mumbai

Employer : Wipro Limited, Mumbai

Duration : Jan, 2007 – Apr, 2007

Description : Dena Bank was founded by the family of Devkaran Nanjee under the name

Devkaran Nanjee Banking Company Ltd.It found its new name, Dena Bank Ltd. when it was incorporated as a Public Company in Dec 1939 which is one of the most prestigious banks of India having a good market share. Dena Bank was nationalised (and therefore dropped the 'Ltd.' from its name) in 1969 along with 13 other banks in India.

Role : Oracle DBA creating, maintaining&supporting production development database

Environment : Oracle 8i,9i,10g AIX, HP UX, Solaris,OEM, Tivoli,Opatch,Finacle

Contribution:

oInvolved in implementation of FINACLE (core banking software of version 7.0.11)

oInvolving in implementation of Servers & SAN box.

oInstallation & Configuration of Oracle database.

oTaking cold backup of test databases.

oImplementing RMAN setup

oCloning of database for test and development environment

oImplementing Physical standby database / Disaster recovery setup at remote location.

Client : Boston Scientific Corporation (BSC) - USA

Location : Mumbai

Employer : Accenture Services Limited, Mumbai

Duration : Jun, 2006 – Dec, 2006

Description : Boston Scientific Corporation, is a worldwide developer,history began in the late

1960s, when co-founder John Abele acquired an equity interest in Medi-tech and

it is a research and development company focused on developing alternatives to

traditional surgery,manufacturer and marketer of medical devices.

Role : Oracle DBA providing Production Support (24x7) for more than 60

production and around 210 development databases

Environment : Oracle 8i,9i,10g AIX, HP UX, HACMP, SAP,Opatch, RMAN,Symantech i3 tool

Contribution:

oInstallation of Oracle 9i on Solaris, Unix and Windows.

oCreating,proactively monitoring and maintaining databases with multiple instances.

oSQL Query tuning using tkprof utility,explain plan, hint for better plan.

oCreating Unix Shell scripts to monitor the database activities and running the scripts in cron jobs.

oCreating database objects and maintaining through OEM.

oChecking alert logfiles, trace files and solve the issues and preparing documentation.

oMonitoring and maintaining production database activities through Symantec i3 performance monitoring tool

oUpgrdation of Symantec i3 performance monitoring tool from version v7.5 to version 7.5.1

oInvolved in taking backup at regular intervals through RMAN and recovery of database information if required

oScheduled Oracle performance monitoring and tuning to ensure system reliability.

oRebuilding of indexes,tables of database

oRefresh of development and test databases using Export/Import Utility

oProviding 24/7 support for production databases.

Client : Defence & Civil Aviation Sector (Indian Army,Navy & Airforce) - India

Location : Bangalore

Employer : HAL, Bangalore

Duration : Nov, 2003 – May, 2006

Description : Hindustan Aeronautics Limited based in Bangalore, India, is one of Asia's

largest aerospace companies. Under the management of the Indian Ministry of

defence, this public sector company is mainly involved in aerospace industry,

which includes manufacturing and assembling aircraft, navigation and related

communication equipment, as well as operating airports.

Role : Oracle DBA for monitoring, maintaining and administrating for defence and civil

aviation sector databases.

Environment : Oracle 7i,8i,9i HP_UX,RMAN,Opatch

Contribution:

oCreating databases, Managing Database Users, Managing Tablespaces

oProvided the sole administration and management of Oracle database

oEstablish & Maintain Backup & Recovery of Database.

oConversant in Archive Log Backups

oInvolved in taking backup at regular intervals and recovery of database information if required.

oSelecting data with SQL and complex queries.

oSQL*Loader for migration and importing.

oResponsible for monitoring, maintaining,and administrating of Oracle databases

oSecurity & Privilege management

oTransporting Data between Databases using Export/Import Utility

Contact this candidate