Resume

Sign in

Data Oracle

Location:
Cupertino, California, United States
Posted:
November 29, 2017

Contact this candidate

Resume:

SELVATHIRUPPATHI SRINIVASAN

818-***-**** ac3i1m@r.postjobfree.com

SUMMARY:

Certified Oracle Golden Gate 10 Essentials

Certified Oracle Real Application Clusters(RAC) Administrator.

Certified Oracle Database 9i/10g/11g Administrator Associate (OCA)

Certified EMC Information Storage Associate (EMCISA)

Ten years of experience in software development using Oracle Technologies.

24x7 SaaS production support,

Configure multi node NOSQL Cassandra 2.1 on production and development database servers.

Experience as ORACLE 11g RAC DBA with multi node Cluster in ASM Environment

Experienced using Explain plan, KPOF, Sql trace, Sql Tuning Advisor and Sql Access Advisor and identifying the Execution plan and tune queries, using indexes, hints etc. Also used Data Dictionary Views, STATSPACK, AWR, and ADDM for performance monitoring and maintain health of database.

Extensive experience in Requirement Capturing, System Analysis, Software Design (Data Modeling) and Architecture, Development and Implementation of Software Applications.

Expertise in ETL data modeling, Data Warehouse Partition table, index, Database

development skills like PL/SQL, stored procedures, functions, packages, and triggers.

Pursue a proactive Analytical approach to troubleshooting and problem solving

On call support and Applying Patches on off time

Strong knowledge on Multi clustered environment and setting up Hadoop Eco-System.

Configuring the Zookeeper to coordinate the servers in clusters and to maintain the Data consistency.

Planning and scheduling regular backups over network storage and testing of recovery

Customization and automation of regular DBA activities and operating system specific tasks by

shell scripts and SQL scripts take preventive actions and troubleshoot the problems proactively

Experience in Performance Tuning, Capacity Planning, Space Management, Database Upgrades/Migration and Planning Backup & Recovery Strategies

Extensive experience Real application Clusters(RAC), ASM, RMAN, Data Guard and maintain Standby database

Developed PL/SQL programs as Database Triggers, Stored Procedures and Functions

Experience in Tables, Indexes Creation. Roles, Users Setup and Security.

Proven expertise in all phases of Software Development Life Cycle (SDLC) of various projects.

Exposure in doing Business Process Re-engineering (BPR)

HARDWARE/SOFTWARE SUMMARY

GUI Tools Developer 2000 6i/9i, Oracle Portal/Web, Designer 2000 V 2.1, Discoverer 6i/9i,

Visual Basic 6.0, Power Builder V10.0

ERP Oracle Financial Applications 10.7/11i

ETL/OLAP Tools Oracle Warehouse Builder (OWB), informatic V 8.5, CRON jobs

Languages C, C++, PL/SOL

Databases Oracle 10g/11g/12c RAC, Hadoop (HDFS), MS SQL Server 2012/2014

Tools Oracle Reports 2.5/3.0/6.0/6i, TOAD, SQL Loader, Pro C, Erin, PL/SQL,

CrystalReports5/8/8.5. Quest Shareplex

Internet HTML, ASP, VBScript, JavaScript, Java, J2EE, Developers, headscarf,

XML, SOAP

Operating Systems Windows 2000/NT/95, UNIX C Shell, AIX, Redhat Linux, MS DOS

Other Tools Datawarehousing, Oracle Enterprise Manager, SQLNet, Import/Export utilities

EDUCATION

Master of Science, Computer Application, Madras University, Madras, TamilNadu, India

Bachelor of Science, Computer Science, Madurai Kamaraj University, Madurai, Tamil Nadu India

Certified Oracle Database 9i/10g/11g Administrator Associate (OCA), Oracle Corporation, USA

Certified Oracle Golden Gate 10 Essentials, Oracle Corporation, USA

Certified Oracle Real Application Clusters (RAC) Administrator, Oracle Corporation, USA

Certified EMC Information Storage Associate (EMCISA), EMC, USA

PROFESSIONAL EXPERIENCE

Athenahealth Inc Aug 2014 to Till date

San Francisco, CA

Role in project: Lead Oracle Database Administrator

Working as DBA in the role of both an individual contributor and Lead handling a variety of major Oracle projects, implementation of new modules and customizations

As individual contributor, responsible for Capacity Planning, Installation, configuration, Creation, Maintenance of Oracle Multi-RAC Node and Stand-alone (11g and 12c) on Linux

24x7 Software as a Service(SaaS) production support

Design, implement and support various Multi-RAC Node and Stand-alone 11gR2 and 12c OLTP and Data Warehouse database

Involved in construction of Disaster Recovery (DR) for all the production databases using Data Guard

Implemented Data Guard on this RAC environment with another RAC Standby Database.

Accountable for the management and oversight of new database projects coordinating and working closely with the Project managers, Application owners, Domain Architect, UNIX, Windows, Storage teams and Vendors

Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC and Stand-alone for Performance Tuning.

Configured Oracle Database backups for Test/Dev Environment using RMAN combined with Veritas Net Backup.

Involved in Datacenter migrations projects includes planning, installation, cloning, upgrade, tuning and co-ordinate application users.

Upgrading database from lower version from 11gR2 to 12cR1

Installed and configured OEM Grid Control 12c to monitor all databases centrally

Applied Oracle’s PSU patches for supported databases

Interacting with customer to understand the requirements and recommending solutions

Troubleshooting operational issues and documenting detailed resolution steps.

Provided 24x7 on call support for the production and development databases

Troubleshooting on Ticket systems (Service Now, Hydra and Jira) and Change management

Environment: Oracle 11gR2/12cR1, Enterprise manage 12c, Active Data Guard, Linux 5.2 X84_64

Net App Sep 2013 to July 2014

Sunnyvale, CA

Role in project: Sr.Database Administrator / Performance Engineer

Design and implement Uni direction data replication to use Golden Gate from SAP, Oracle ERP, Sales force to Oracle’s data warehouse environment.

Designing and planning to upgrade 11gR2 to 12C.

Setup cluster environment for Highly Available systems.

Install and Configure multi node Cassandra on RHEL Linux 6.

Responsible to monitor availability and performance, add and remove node, add and decommission data center to a cluster.

Experience in building Cassandra cluster

Managing Cassandra clusters using Datastax opscenter.

Install, Configure and maintain Single-node and Multi-node cluster Hadoop cluster.

Knowledge of Cassandra systems backup and recovery Knowledge of Cassandra security.

Hadoop cluster configuration & deployment to integrate with systems hardware in the data center.

Managing hadoop Services like Name node, Data node, Job tracker, Task racker etc

Commissioning and decommissioning of Hadoop nodes.

Performed extensive Oracle RAC support for node eviction issues and managed them.

Performed the SQL tuning and recommendations for better performance on Query tools.

Monitor Database through 12c Enterprise Manager.

Performed the tuning of Application server to handle large workloads and long running jobs on batch server and Application server.

Designed Logical and physical database for business transaction functionality

Review data load processes and suggest enhancements and quality checks

Creating the database, tables, table spaces, data objects, setting privileges, indexes, user logins, passwords (security).

Deciding the naming conventions of data file, redo log files, table spaces, segments.

24x7 Level four (L4) production support

Environment: Oracle 11gR2(RAC),12c Enterprise manager, Cassandra, Hadoop(HDFS), Map Reduce, Hive, Cloudera Manager, SQL Server 2012/2014, Golden Gate, Active Data Guard, Redhat Linux 5.2 X84_64, Windows XP

Aptean (Formerly CDCSoftware/Tradebeam), March 2010 to Aug 2013

San Mateo, CA

Role in project: Sr.Database Administrator

Experience as ORACLE11g RAC DBA with multi node Cluster in ASM Environment.

Adding and deleting Cluster Node in existing RAC Cluster

Performed extensive Oracle RAC support for node eviction issues and managed them.

24x7 Software as a Service(SaaS) production support

Created all SQL Loader control cards and Data pumps scripts to load replicated data.

Migrate From Sybase database to Oracle database.

Upgraded SQL server databases from 2000/2005 to 2008R2/2012

Extensively worked with SQL Profiler, Activity monitor, Perlman, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues.

Design and implement Uni direction Data replication to use Golden Gate

Performed the SQL tuning and recommendations for better performance on Query tools.

Performed the tuning of Application server to handle large workloads and long running jobs on batch server and Application server.

Worked extensively with SQL, PL/SQL Stored Procedures performance tuning.

Performed the Capacity planning and sizing for large Production

Performed the Oracle's Backup and recoveries in various crash situation.

Implemented CRON Jobs

Performed extensive RMAN backup and restoration window tuning on large databases

Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).

Deciding the naming conventions of datafile, redo log files, tablespaces, segments.

Implementation and maintenance in production database.

Designed Logical and physical database for business transaction functionality

Review data load processes and suggest enhancements and quality checks

Used TOAD for faster application design and developments

Environment: Oracle 11gR1/R2(RAC), SQL Server 2012/2014, Redhat Linux 5.2 X84_64, Windows XP

IBM, Walnut creek, CA Jan 2009 to Feb 2010

Client: Virgin Mobile USA, LLC

Role in project: Sr.Database Administrator / Architect

Design and implementation of new product databases

Monitored and fine-tuned the physical database architecture in large Production databases.

Performed extensive Oracle RAC support for node eviction issues and managed them.

Support and maintenance Sybase database for customer support

Monitoring database activities using Oracle10g Grid Control

Created all SQL Loader control cards and Data pumps scripts to load replicated data.

Design and implement Uni direction Data replication to use Golden Gate

Created all SQL Loader control cards and Data pumps scripts to load replicated data.

Experience as ORACLE 11g RAC DBA with multi node Cluster in ASM Environment.

Adding Cluster Node in existing RAC Cluster

Configured and implemented Oracle Grid Control to do day to day activities

Performed the SQL tuning and recommendations for better performance on Query tools.

Worked extensively with SQL, PL/SQL Stored Procedures performance tuning.

Performed the Capacity planning and sizing for large Production

Performed the Oracle's Backup(RMAN and user managed) and recoveries in various crash situation.

Implemented CRON Jobs

Performed extensive RMAN backup and restoration window tuning on large databases

Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).

Deciding the naming conventions of datafile, redo log files, tablespaces, segments.

Implementation and maintenance in production database.

Designed Logical and physical database for business transaction functionality

Review data load processes and suggest enhancements and quality checks

Used TOAD, PL/SQL developer tools for faster application design and developments

Done the documentation and provided on-site production support

Environment: Oracle 11g(RAC), PL/SQL Stored Packages/Procedures, Sybase V 11.5, Redhat Linux 5.2 X84_64, Windows XP and UNIX Korn Shell Scripts

Zenith National Insurance Corp, Woodland Hills, CA Apr 2008 to Dec 2008

Role in project: Sr. Database Administrator

Design and implementation of new product databases

Used Sharple for replicating databases.

Initial build script development and maintenance

Database Backup Configured implemented and using RMAN catalog.

Expertise in Oracle Cluster Configuration and Implementation in RAC Environment.

Implemented Data Guard (Standby) for our Protection Application Support.

Creation and maintenance of development and test Database

Setup CRON jobs for reprots and data upload

Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).

Worked Data Guard, Cloning using copy from production to Test Supported development and test databases for on going development and testing

Implemented Data Guard (Standby) for our Protection Application Support.

Setup RAC environment in development and test database

Data transfer from SQL SERVER to Oracle using Informatic

Deciding the naming conventions of datafile, redo log files, tablespaces, segments.

Implementation and maintenance in production database.

Designed Logical and physical database for business transaction functionality

Review data load processes and suggest enhancements and quality checks

Used TOAD, PL/SQL developer tools for faster application design and developments

Done the documentation and provided on-site production support

Environment: Oracle 11g(RAC), Erwin 4.1, PL/SQL Visual Basic 6.0, Informatic V 8.5 Quest Shareplex, SQL Plus, Toad, Windows XP and UNIX Korn Shell Scripts

Health Management Systems (HMS), Alhambra, CA Nov 2007 - Mar 2008

Los Angeles Unified School District (LAUSD), Los Angeles, CA Aug 2005 - Oct 2007

Gateway, Irvine, CA Feb 2005 - July 2005

Role in project: Sr.Database Administrator / Architect

Load data extracts from legacy to Oracle systems

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

Creation and maintenance of development and test Database

Implementation and maintenance in production database.

Designed Logical and physical database for business transaction functionality

Database and SQL tuning to improve performance of loads.

Review data load processes and suggest enhancements and quality checks

Replicate Data between oracle to use Sharple

Created all SQL Loader control cards and scripts to load replicated data.

Designed and Developed PL/SQL for interface

Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages

Creating SQL PL/SQL database objects.

Written the Interface Stored Procedures for Data Transformation

Used TOAD, PL/SQL developer tools for faster application design and developments

Done the documentation and provided on-site production support

Done functional and technical specs

Environment: Oracle 10g, Oracle 10g Warehouse Builder, Sharplex, PL/SQL Stored Packages/Procedures, SQL Plus, Toad, Windows XP, Linux and UNIX Korn Shell Scripts

Detroit Edison (DTE), Detroit, MI Nov 2004 - Jan 2005

Michigan Department of Community Health, Lansing, MI July 2003 - Oct 2004

Warner Brothers, Los Angeles, CA Dec 2001 - June 2003

Adaptis (Formerly CHIS), Seattle, WA Dec 2000 - Nov 2001

Scientific Atlanta Inc., Atlanta, GA May 2000 - Nov 2000

Role in project: Database Administrator / Architect

Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages

Developed web based front-end screens using Forms 6i/9i, generated custom reports using Reports 6i/9i and generated custom graphics using Graphics 6i/9i

Up gradation of databases from Oracle 8i to 9i

Setup and implementation of Project Accounting system

Developed Custom APIs

Deployment and tuning of forms/Reports in web.

Involved SQLLOAD loads (Tera data )data from external files into tables in the Oracle Database

Involved in Control File Format in SQL*LOADER

Creating SQL, Object Views, and PL/SQL database objects.

Written the Interface Stored Procedures for Data Transformation

Tuned the SQL’s with the output of Oracle Tools Explain Plan, TKPROOF

Used Oracle snapshots for replication between various sub branches.

Fixing bugs according to the software change requirement

Used TOAD, PL/SQL developer tools for faster application design and developments

Performance tuning, SQL tuning.

Developing the backup and recovery strategy

Creating the Oracle schema i.e. table spaces, tables, indexes, constraints, triggers, synonyms, database links, roles etc.

Developed in Logical and Physical Design of Databases using Designer 2000 writing server side stored procedures/ triggers.

Performed Database Creation, Database Parameters Setting (init.ora).

Estimated Size, Storage parameters (Initial, Next extents, pctfree, pctused), Create Tables and Indexes Setup Roles, Users and Synonyms

Generated Forms and Reports Using Designer 2000

Developed procedures using Dynamic SQL, UTL_FILE.

Shared Pool, DB_BLOCK_BUFFERS, Rollback Segments tuning.

Developed and optimized of SQL queries using SQL Navigator and Explain Plan utilities

Involved in Testing (Both Unit and Integration Level) and Implementation.

Tested the entire application in testing environment and exported to Production.

Done the documentation and provided on-site production support.

Environment: Oracle 9i/10g AS, Developer 2000 6i/9i,PL/SQL, J2EE, Developer, Headscarf, SQL, Crystal Reports, Pro C,Java, Designer2000 9i. TOAD, SQL Loader, Windows95, C, UNIX Shell

Vision Software Private Limited, Chennai, India May1994 – Apr 2000

Role in Project: Developer/DBA

Created the database objects such as Tables, Indexes, Views, Database Triggers, PL /SQL procedures, Packages etc.

Installed and created of Database as per the requirement definition.

Created and assigned users, profiles, privileges, roles etc according to the hierarchy levels

Oracle installation, database creation and configuration

Capacity planning, space monitoring, creation of schema objects, table space Fragmentation

Performance tuning, SQL tuning.

Developing the backup and recovery strategy

Implementing basic replication using snapshots.

Security management through creating user accounts, user privileges, roles and auditing.

Developed and maintained test plans, documentation and procedures

Wrote scripts for indexes, clusters and other Database Objects according to the Oracle standards.

Developed front-end screens in Forms 6.0 and generated reports using Oracle Reports 6.0 and generated graphics using oracle graphics 6.0

Extensively used the Import/Export options and SQL Loader provided by Oracle for the data transfers.

Involved in Performance Tuning and Scheduled Maintenance of the application

Environment: Oracle 8.0, Developer 2000 6.0, SQL Plus, Designer 2000, Visual Basic 6.0,PLSQL, Import / Export, SQL Loader, SQL DBA, Crystal Reports, Windows 95/NT



Contact this candidate