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