Oracle Manager

Kanagaraj Palanisamy

Phone: 312-***-**** Sr. Database Administrator

********@*****.**.**

Summary:

Over 12+ years of experience as an Oracle Database Administrator having hands on experience in Database Design, Administration, Production Support, Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup and Recovery, Cloning, Capacity Management, Database Security, Disaster Recovery, Migration, Automation, Cloud, POC (Proof of Concept) and Documentations.

Excellent experience with Oracle 12c Multitenant Architecture Database CDB Vs PDB’s

Worked on Exadata Database Machine and Exadata Storage Machine X4/X5/X6/X7

Worked on Oracle Database Appliance(ODA) X5-2

Experience in Designing, Implementing, Supporting High Availability and Disaster Recovery Solution for Oracle 12c Multitenant Databases on Exadata Machine

Experience in Building Cloud based Database environment on Exadata using Oracle 12c Multitenant

Worked on Database as a Service (DBaaS) with Oracle 12c Multitenant on Exadata Machine

Experience in Designing and Implementing Backup and Recovery Strategy for Oracle 12c Multitenant Database

Worked on Oracle 12c Instance Caging, CDB/PDB’s Resource Manager Plan

Worked on Exadata Storage I/O Resource Manager Plan

Automate Oracle 12c CDB/PDB Database Creation using UNIX Shell Script

Apply Quarterly Bundle Patches by Rolling or Non-Rolling method on Exadata Machine

Worked on Oracle Replications like Streams, Golden Gate and also with CDC (IBM)

Installed and Configured Oracle 12c OEM using Load Balancer F5 Network. End-to-End Implementation

Deep understanding about Exadata Specified Features such as Smart Scan, Hybrid Columnar Compression(HCC), Flash Cache, Storage Index, etc

Deep understanding of Software and Firmware maintenance of Exadata Database and Storage Servers including Upgrades and Patching

Coordinate with Oracle Platinum Support Team for Applying Patches on Exadata Machine

Performed POC (Proof of Concept) on Oracle 12c Snap Clone Vs Delphix Appliance

Performed POC on Oracle Enterprise User Security (EUS) for Database Environments - LDAP

Setup Centralized Oracle12c AWR-Warehouse Database to store AWR Data for long term retention(1 year)

Experience in implementing EMC DataDomain Storage Appliance for Database Backup Solution

Performed Database Tuning by using various Tools such as ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), OEM (Oracle Enterprise Manager) STATSPACK, etc

Performed SQL Tuning using Explain Plan, TKPROF with SQL trace,SPA (SQL Performance Analyzer) STA (SQL Tuning Advisor), OEM, etc

Worked on Oracle11g Grid Infrastructure, Clusterware, ASM, RAC Internal, Active Data Guard in RAC environment

Planning, Designing, Developing, Deploying and Supporting Oracle 11gR2 RAC/ASM environment

Solid skills in Upgrading 10g R2 RAC to 11g R2 RAC and 11g R2 RAC to 12c R1 RAC

Proficient in SQL, PL/SQL such as Triggers, Functions and Stored Procedures

Experience in Database Security and Auditing

Worked on Different Types of Storage Structures (SAN/NAS/NFS, etc)

Unix Script Programming using SED, AWK and Korn Shell

Full Life-Cycle Software Development of OLTP and Data Warehouse Databases

Experience with Managing and Supervising DBAs and Developers

Excellent Communication and Coordination skills with System Administrators and various Internal Teams

Worked as a Delivery Lead for the Database Support Team which has around 20 Members in a Team

Experience with On-Call 24x7 Support of Production Systems and Applications with Strong Troubleshooting Skills

Technical Skills:

Hardware Oracle Exadata Machine Half Rack X4/X5/X6/X7, IBM PowerPC, X64 box, ODA Machine Operating System Oracle / Redhat Linux, IBM AIX, HP-UX, Solaris, Windows 2005/2003/XP/2000/NT Languages PL/SQL, SQL, Shell Scripting, Java, C, C++,VC++, HTML, XML, Visual Basic 6.0, ASP .NET (C#) RDBMS Oracle 9i/10g/11g/12c/RAC, ASM, MS SQL Server 2005/2008/2012, Mysql, Sybase 9.0 TOOLS SQL Developer, TOAD, DBArtisan, Erwin, Crystal Report, Putty, OEM, Cygwin –X, Win Runner, Insta1lshield, Surround SCM, Microsoft VSS, TIBCO, Microsoft Virtual Machine, DataDomain Storage, Delphix, Oracle EUS, OUD, Patrol, Pandora Education:

Master of Science in Software System, Year 2005, Bharathiyar University, Coimbatore, India

Diploma in Computer Hardware and Networking

Oracle Certified Professional OCP 9i/10g/11g/11gRAC

Completed Oracle11g RAC Training Program from Oracle University

Completed Oracle12c New Features for Administrators Training Program from Oracle University

Completed ITIL V3 Foundation Certification

Awards:

Won the Best Performance Award for Employee of the Year 2006 from the Client (Dendrite Software)

Received lot of Appreciation Mails from the Client (Northern Trust Bank) Experience:

Title: Sr. Database Administrator Apr’10 –Current

Company: TATA America International Corporation

Client: Northern Trust Bank, Chicago

Work Location: Chicago, USA

Responsibilities:

Worked on Oracle 12c Multitenant Architecture Database CDB Vs PDB

Performed Database Migration from Oracle 9i/10g/11g to Oracle 12c CDB/PDB’s

Designing, Implementing, Supporting High Availability and Disaster Recovery Solution for Oracle 12c Multitenant Databases on Exadata Machine

Built Private Cloud based Database environment on Exadata Machine using Oracle 12c Multitenant Architecture

Implemented Database as a Service (DBaaS) using Oracle 12c Multitenant on Exadata Machine

Design and Implement Backup and Recovery Strategy for Oracle 12c Multitenant Databases

Performed Database Restore and Recovery at CDB level and also PDB level with Different Scenarios

Refresh/Cloning CDB/PDB Databases using Datapump and RMAN using DataDomain, TSM, Commvault, etc

Implemented Compression and Deduplication on Oracle 12c CDB/PDB to save the Storage Cost for the Company

Apply Oracle 12c One-Off Database Patches (Bug Fix) as per Application/Vendor Requirement

Automate Oracle 12c CDB/PDB Database Creation using UNIX Shell Script

Installed and Configured the Replication using Oracle Streams and Golden Gate and also using CDC (IBM)

Worked on Oracle 12c Instance Caging and CDB/PDB’s Resource Manager Plan

Worked on Legacy Servers Consolidation and Databases Consolidation for Exadata environment

Worked on Exadata Specified Features such as Smart Scan, Hybrid Columnar Compression(HCC), Flash Cache, Storage Index, etc

Worked on Exadata Storage I/O Resource Manager Plan

Successfully Installed, Configured and Maintained Enterprise Manager Cloud Control 12c to Monitor and Manage Exadata Machine and other regular Databases

Installed ASR and Activated Exadata ASR assets for Hardware Fault Monitoring

Apply Quarterly Bundle Patch by Rolling or Non-Rolling Method on Exadata Machine

Download Latest Exacheck and Execute on the Exadata Machine Before/After Patch Applied

Coordinate with Oracle Platinum Support Team for Applying Patches on Exadata Machine

Coordinate with Application Team, Perform RAC Node Fail-Over testing and DR testing

Good understanding of Oracle 12c Adaptive Query Optimization, Adaptive Plans and Adaptive Statistics

Tune SQL Queries as per Exadata environment to use features like Smart Scans, Flash Cache, Storage Index, etc

Identify and Address Performance issues at Oracle 12c CDB/PDB level using various Oracle Utilities or Tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control, Manual Scripts, etc

Successfully implemented and utilized Oracle Real Applications Testing (RAT) for Workload Management, analyzing and optimizing SQL Performance

Involved in SQL Query Tuning and provided recommendations to ERP Jobs, Time/CPU Consuming Queries

Performed Table Partition for larger Database to Improve the Performance of the Query

Developed and Deployed SQL, PL/SQL Stored Procedures, Functions and Triggers for Several in-house Projects

Developed Monitoring Scripts to Monitor Databases and Report issues Proactively

Upgrade Oracle Enterprise Manager (OEM) 11g to 12c including Oracle Management Server (OMS) and Agent

Apply Quarterly Oracle Patches and Plug-ins on 12c OEM which includes OMS and Agent

Deploy Oracle 12c Agent or Plug-ins on all the Database Server Host from OEM Console and Make sure it’s uploading the data to the OEM Repository Database

Automate Oracle 12c Agent Installation using Unix Shell Script

Performed Mass Database Migration from RHEL 5 to RHEL 7 by copying the ASM Disk at OS level

Setup Centralized Oracle12c AWR-Warehouse Database to store AWR Data for all the Databases for long term retention

Installed EMC DataDomain Storage Appliance to store all the Oracle Database Backup files. This Appliance has High Compression and Deduplication ration which help to Save the Storage Cost for the Company

Installed EMC DataDomain Boost Agent (Client) on all the Database Server and Configured to Backup the Oracle Database Backup files to DataDomain Storage Appliance

Analyze Technical fit of Oracle's Products/Features and Professional Services against Prospects requirements

Performed POC (Proof of Concept) on Oracle 12c Snap Clone Vs Delphix Appliance

Performed POC on Oracle Enterprise User Security (EUS) for Oracle Database Environments by installing Oracle Unified Directory (OUD) Proxying Communications to the existing Oracle Directory Services Enterprise Edition

(ODSEE) using OUD to Store relevant Supporting Configuration Information

Performed Oracle SME(Subject Matter Expert) Role for the Database Support Team

Recovered Database from Media Failure, Accidentally Dropped Tables, Missing Data Files and Block Corruption using Flashback Recovery, TSPITR and from Previous RMAN backups

Unix Script Programming using SED, AWK and Korn Shell

Communicated and Coordinated with Oracle Support regarding major Database Issues and applied required Patches on Unit/System test; Rolled-out and Implemented Patches into Production

Respond to Trouble Tickets and Customer Request

Provided 24x7 On-Call Supports for Mission Critical OLTP and OLAP RAC and Single Instance Production Databases on Multiple OS Platforms

Documented lessons learned and Improving Efficiency in Debugging related Issues for the Team

Address Database Escalations Issues on Time without SLA (Service Level Agreement) Miss

Managed Multiple Technical Projects for Database Upgrades, Resource Capacity Planning, Platform Migrations, Application Consolidation and Data Center Rationalization

Worked on Change Management, Problem Management and Incident Management Service-now Ticketing Tool Environment: Oracle 9i/10g/11g/12c/RAC, DataGuard, Streams, Golden Gate, PL/SQL, Toad, RMAN, Windows, Solaris, HP-UX, AIX, Oracle Exadata, Shell Scripting, Service now, DBArtisan, Oracle 10g OEM, SQL Server 2005, DataDomain Storage Appliance, Delphix Appliance, Oracle Enterprise User Security(EUS), Oracle Unified Directory (OUD), Patrol, Pandora

Title: Sr. Database Administrator Aug’08 –Apr’10

Company: TATA Consultancy Services (TCS)

Client: Northern Trust Bank, Chicago

Work Location: Chennai, India

Responsibilities:

24*7 Primary Production Database Administration, Support Oracle 9i/10g/11g/RAC

Provided Secondary Support to Microsoft SQL Server, MySQL and Sybase Databases

Managed 15 Members Database Support Team in different location(Chennai/Mexico/Chicago)

Provided L2/L3 Support for Critical Databases to the Bank. This Support Model has resulted in 99.9% Uptime for Company Critical Databases

Worked on Change Management, Problem Management and Incident Management Service-now Ticketing Tool

Move Database Changes using Change Management System from Development to Production with Appropriate approval to avoid any Database Outage

Worked on Logical and Physical Database Design for OLTP and OLAP Applications

Designing, Implementing, Supporting High Availability and Disaster Recovery Solution for Oracle 11g/10g

Migrate Oracle 9i/10g Databases from Solaris/AIX to RHEL

Upgrade Databases from Oracle 9i/10g to Oracle 11g

Actively Worked with Infrastructure Team for Server & Database Consolidation during Datacenter Migration

Installed and Configured 10g OEM Grid Control including OMS(Oracle Management Server) and Agent

Upgrade 10g OEM to 11g OEM which includes OMS (Oracle Management Server) and Agent. End to End Upgrade

Implement High Availability Solution for 10g OEM using F5 Network - Load Balancer

Implemented Oracle Streams at Schema/Table level for Replicating the Data

Configured and used Oracle Flashback for Recovery of Objects in the Database

Written Unix Shell Scripts to Monitor Database Activities and Send an Alert to the Support Team

Applying Oracle Quarterly Patches CPU, PSU, One-Off Patches on Stand-alone and RAC Databases

Implemented Oracle Database Backup & Recovery Solutions using RMAN

Performed Database Recovery (both complete and incomplete) from Different Types of Failure

Worked on Database Refresh/Cloning using RMAN

Maintain all Database Objects including Schemas, Tables, Indexes, Triggers, Sequences, Primary and Foreign keys, Views, all Constraints, etc

Created Users, Roles and Granted necessary Privileges according to the Business Requirements

Worked on Database Tuning, Memory Tuning and SQL Tuning using various Oracle utilities like STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, ADDM, SQL Tuning Analyzer(STA), SQL Performance Analyzer

(SPA)e, OEM, etc.

Conducted Regular Performance Review of Oracle Database for Business Critical Applications

Used Explain Plan, Oracle Hints and Creation of new Indexes to Improve the Performance of SQL Statements

Conducted Load Testing and Collated the Test Results. Provided Recommendations based on the Test Results

Perform Root Cause Analysis on Failures. Resolve Performance Tuning related Issues and Queries

Partitioning of Large Tables for Better Performance and Manageability

Implemented Oracle Database Replay for Workload Test to address Performance issues

Perform SQL Tuning and assist Developers with coding PL/SQL

Share Oracle SQL/PL-SQL Best Practices and Recommendations with the Application Team

Written PL/SQL Stored Procedures, Packages, Functions and Triggers

Developed various Business and ad-hoc Reports for Management

Study and Analysis of Business Requirements

Consistently Delivered Work Assignments within given Timeframe, with High Quality and Zero Defect

Interacted with the Technical Design Team and Contributed in Impact Analysis

Involved in End-User Training and Creating User Manual Document

Research and Evaluate Innovative Technology Solutions, Collaborating with Teams to Determine Feasibility of Deployment

Provide Technical Presentation to DBA Team about upcoming Oracle Database Technology, New Features, etc Environment: Oracle 9i/10g/11g/RAC, DataGuard, Streams, PL/SQL, Toad, RMAN, Windows, Solaris, HP-UX, AIX, Shell Scripting, Service now, DBArtisan, Oracle 10g OEM, SQL Server 2005, Patrol Title: Database Administrator Aug’05 - Aug’08

Company: Aztec Software and Technology

Client: Dendrite/Cegedim Software India Private Limited Wok Location: Bangalore, India

Responsibilities:

Responsible for Manage and 24*7 Support all Production, Development and Staging Databases of Oracle 9i/10g/11g/RAC and also Sybase Databases

Thorough Knowledge in Setting up Infrastructure for Oracle Databases in Huge Data Centers

Responsible for Building Oracle 11g Stand-alone and RAC Databases with ASM

Configured Oracle Physical Standby Database for High Availability and for Disaster Recovery using Data Guard

Oracle Database Upgraded from 9i/10g to 11g

Oracle Database Migrated 9i/10g from AIX to RHEL

Applying Quarterly Patches (PSU, CPU, one-off) for Security and Bug Fixes

Involved in Designing the Databases for OLTP and DSS type of Applications

Automate Database Build/Creation using Unix Shell Script to be Consistent across the board

Built Development, Testing, Production Database for OLTP and DSS applications using Database Build Scripts

Install and Configured 10g Oracle Enterprise Manager (OEM) which includes OMS Server and Agent

Worked on Oracle Streams to Enable Real-Time Data Integration and Continuous Data Availability

Configure Oracle Flash Back for Recovery of the Objects

Devised, Developed and Implemented RMAN Backup and Recovery Strategy using IBM Tivoli Tape

Performed various Complete and Incomplete Database Recovery using RMAN

Refresh Dev and Test Instances with Data from Production on a Regular basis

Worked with QA Team in Unit Testing

Perform Daily Health Checkup of the Critical Databases Proactively

Resolving Database and SQL Performance issues using Oracle utilities like EXPLAIN PLAN, TKPROF, SQL Trace, SQL Analyzer, Gather Statistics, AWR/STATSPACK, OEM, etc

Gathering Full and Stale Statistics of Data Objects using Analyze and DBMS_STATS

Providing Oracle SQL/PL-SQL Best Practices and Recommendations to the Development Team

Analyzed the User Requirements and Designed Partitioned Tables for Improving Performance of the Database

Good Understanding of Normalization Techniques

Security User Management, Privileges, Roles, Auditing, Profiling, Authentication, etc

Developed numerous PL/SQL Procedures, Packages, Functions and Triggers for various requirements

Audit Database for Statements, Privileges and Schema Objects

Importing Data from Flat files into Database using SQL Loader and External Tables

Monitoring Growth of Tables and Perform Re-Organization of Tables and Indexes as and when required

Performing Monthly and Annual Performance Reports for Trend Analysis and Capacity Planning

Written Shell Scripts to Monitor Availability of Database & Listeners, Space Utilization, Gathering Statistic for the Tables, Index Rebuilding, etc

Monitoring the Operating System Response in terms of CPU Usage, Disk Space, and Swap Space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT, TOP, etc

Good exposure to Oracle Technologies like Transportation Tablespaces, Data Pump Import/Export, Flashback

Worked with Oracle Support to fix the Production issues

Respond to REMEDY Ticketing System and Customer Requests

Provided Technical/User Documentation and Training to the Team Members

Coordinate Internal Resources and Third Parties/Vendors for the Flawless Execution of Projects

Responsible for Building and Maintain TIBCO Server as per Application requirement

Administrator for Source Code Control Tools like Surround SCM and Microsoft VSS

Create an Application Package(setup.exe) using Installshield Tool

Prepare Process and Knowledge Transfer Documents for the new Team Members about the Projects Environment: Oracle 9i/10g/11g/RAC, Red Hat Enterprise Linux, Solaris, IBM AIX, Windows 2000, TOAD, SQL *Plus, Export, Import, 10gOEM, RMAN, UNIX Shell Scripts, PL/SQL, Remedy Ticketing Tool, Erwin, SQL Developer, Surround SCM, Microsoft VSS, Microsoft Virtual Machines, Installshield 10.5

Contact this candidate