Oracle Sql Server DBA

Arulprakash Kubendran

Email id: ********@*****.**.**

Mobile no: +1-407-***-****

Professional Summary

11+ years of IT experience in oracle database administration (Installation, Configuration, implementation, designing, recovery and troubleshooting).

Oracle RAC 10g,11g,12c Installation and Configuration on REDHAT Linux 4,5,6

Oracle OEM 11g/12c installation and configuration on REDHAT Linux 4,6

Real time exposure on implemented and maintained Dataguard 9i/10g/11g.

Good experience on Goldengate 11g infrastructure

Oracle ASM diskgroup recovery

Oracle database migration/upgrade/maintenance and recovery

Implemented Database hardening to success SOX/PCI Audit.

Oracle database backup strategy implementation

Good experience Datacenter media management

Performed database refresh/clone using the utlities RMAN/Expdp & Impdp

SQL Server 2012 installation and configuration

Performed SQL Server refresh and backup configuration

Setup a SQL Server replication

Application server 9i,10g installation and configuration

Created Application server mirroring

Education Details

Master of Computer Application (2003-2006),Ponnaiyah Ramajayam College, Bharathidasan University,Trichy,India.

Bachelor of computer science (2000-2003), Ponnaiyah Ramajayam College, Bharathidasan University,Trichy,India.

Oracle 10g Certified in Associate/Professional and Expert in Real Application Cluster

Achievements:

Five count on me Awards recevied with client appreciation .

One Shining Star Award -2015 by cognizant.

Technical Skills

RDBMS: Oracle 12c RAC, Oracle 11g RAC, Oracle 10g RAC, oracle 9i, oracle 8i, SQL Server.

Operating Systems: Solaris 9/10, Linux RHAT 4/5,6, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows NT,2000/2003/2005.

High Availability, Tuning& Monitoring Products: Oracle 10g Grid infrastructure, Oracle 11g Grid infrastructure, Oracle 12c Grid infrastructure

Tools & Utilities: ASM, Data Guard, Grid Control (OEM), Tkprof, Stats pack, AWR, ADDM, ASSM, Oracle SQL Developer, TOAD, RMAN, Export/Import, Data Pump (expdp/impdp), SQL Loader, Lab128,Spotlight.

ETL & Reporting Tools: Informatica, Power Center 8.5/8.0,Data Stage6.0,1.0, Business Objects Xi R26.1, Oracle Data Integrator, SAS

Backup Tools: VERITAS Netback up, NetApp,, TSM,EMC

Programming Languages: SQL, Unix/AWK,C,C++,Asp.Net, XML, HTML, DHTML, Java.

HARDWARE: Sun Fire X 4100,Sun Fire V104,HP Itanium,IBM .

Application server: Oracle 9i / 10G AS, Forms6i/5i

Professional Experience

Cognizant Technology Soultion Private Ltd

Senior Oracle Database Administrator,Orlando, USA,(Oct–2014 to Till date ).

Senior Oracle Database Administrator,Chennai, India, (Sep-2012 to Oct-2014) .

Role & Responsibilities:

Oracle RAC 10g/11g/12c installation and configuration on Linux

Upgraded databases from Oracle 9i, 10g to 11g/12c.

Involved on new project design and implementation with development/ETL Team.

Involved to support a fusion environment setup

Experienced in performing Point-in-Time Recovery.

24x7 Production database and applications support.

Involved on annual database SOX/PCI auditing to get completed successfully.

Installed, configured, and maintained Oracle 10g and 11gR2.

Restoration and Recovery of databases at the times of occurrence of critical failures.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Implemented Oracle database backup & recovery solutions using RMAN and manual methods.

Performed block recovery using RMAN.

Refresh data from Production to Test databases using RMAN & Data Pump.

Performed large batch jobs, and tuning of SQL queries and database systems.

Partitioned large tables for better performance and manageability.

Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Environment: Oracle 12c RAC/ 11g RAC/10g RAC, REDHAT LINUX,, ASM,OEM (Grid/Cloud Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader

IBM India Private Ltd, Chennai, India.

Oracle Database Administrator, From May - 2009 to Sep - 2012.

Role & Responsibilities:

Oracle RAC 9i/10g/11g installation and configuration on Linux/Aix platforms.

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

Experienced in performing Point-in-Time Recovery.

24x7 Production database and applications support.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Managed the oracle CPU/PSU patch apply

Implemented Oracle database backup & recovery solutions using RMAN and manual methods.

Performed block recovery using RMAN.

Moving data between databases using Data Pump.

Performed large batch jobs, and tuning of SQL queries and database systems.

Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Partitioned large tables for better performance and manageability.

Great experience to coordinated with oracle corporation and IBM team due to performance issues

Environment: Oracle 11g RAC/10g RAC, DATAGUARD,REDHAT LINUX/AIX, ASM,OEM (Grid), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader.

Sundaram Infotech Solutions (ISO 9001:2000), Chennai, India.

Database Administrator, March -2007 to May-2009.

Roles and Responsibilities

Migrate database from production to beta, test environment using RMAN

Real Application Clusters monitoring, tuning using OEM (Oracle Enterprise Manager), Statspack, and V$ dynamic views

Designed and developed scripts to monitor instances locks, long running queries, listener password, tablespace space, extents growth, etc

Design and implement of database backup strategy and performed full, incremental backups using RMAN. Troubleshooting with RMAN backup problem.

Monitor and Tuning of Database Performance by using various optimization techniques

Provide database administration on production, testing and development database servers. Creation of database objects like tables, indexes, synonyms and views etc

Clone/Refresh of Production databases to dev and training environments

Perform tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc

Interacted with Oracle Support for resolving various critical database issues.

Installation support for IBM AIX version 5.3 and oracle related OS patches.

Performed memory level application tuning

Designed partition and migrated database using exp/imp

Report sever implementation and tested using RMAN

Setup and configured Physical standby database

Database creation and database migration.

Configured OMS console.

Installed Sql server 2005 and configured a Snapshot replication mirroring.

Installed and configured Oracle 9iAS and 10gAS on Linux environment.

Environment: Oracle 10g RAC, REDHAT LINUX/AIX, DATAGUARD, OEM (Grid), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader.

Orchid Infotech,Chennai

Programmer,Jul-2006 to March-2007.

Roles and Responsibilities

Developed stored procedures, functions and complex packages extensively using PL/SQL and fine-tuned SQL to optimize performance

Personal profile

Father’s Name : G. Kubendran

Martial Status : Married

Date of Birth : 18-07-1983

Address : #606,13112 Heather Moss Drive, Orlando, Florida – 32837.

Contact this candidate