Candidates About

 

SenthilKumar Sivakumar

Objective:

With the knowledge in the field of Database coupled with my expertise in Oracle Database 9i ,10g ,11g,12C Database Administrator seeking a long-term career in the field of Database management systems in a professional organization.

 

Experience Summary 

 

·         Having 10 years of experience in Oracle Database Administration and 18 months of experience in MSSQLSERVER, MYSQL and Postgres. Provided support to 300 plus Production, Test and Development Instance environment.

·         Sound understanding of database requirement with a global mindset, and strong quantitative and conceptual abilities with strong database management skills.

·         Administrated database of various sizes from 40GB to 110TB.

·         In-depth knowledge in Oracle 12c RAC/11g RAC /10g /9i Installation, Administration, Monitoring, Performance Tuning, Database Backup and Recovery, Patching and cloning.

·         Implemented Oracle 12c CDB/PDB.

·         Implemented 11g R2 RAC production environment Worked on 11i EBS environment DB upgrade from 10g to 11g R2 and conversion of a single node 11g Database to a 5-node RAC cluster.

·         Database migration from non-Exadata to Exadata and MS SQLSERVER to Exadata

·         Sound knowledge on Exadata X4-2/X3-8/X3-2/X2-2 Administration.

·         Solid understanding of key Exadata features like Hybrid Columnar Compression, Smart Flash Cache, Storage Index, Storage Management & Administration.

·         Implemented HCC for Historical tables gain space around 4:40 ratio.

·         Hands on experience on quarterly Patching Oracle Exadata X4-2/X3-8/X3-2 Full and Half Rack.

·         Installed and configured of Oracle Enterprise Manager Cloud Control 12c for Exadata monitoring

·         Experience in Design, Creating and Maintaining the Oracle Database.

·         Exposure on managing Tablespace, Rollback segments, Archives.

·         Experience in Installation, Configuration and Re-Configuration of Oracle Database on Solaris OS, Red-hat Linux AS/ES/4/5/6/7.

·         Hand on Experience in 11.2.0.4 GI and DB Upgrade.

·         Experience in Performance Tuning of SQL statements and Database using tools/reports like Explain plan, ASH/AWR/ADDM reports, TKPROF, SQL Analyze, UTLBSTAT, UTLESTAT, and STATSPACK.

·         Experience in Capacity Planning and Space Management.

·         Expertise in RMAN Configuration with backup servers like TSM, Veritas etc.

·         Expertise in Alert Monitoring and Ticketing.

·         Installation and configuration of MYSQL and Postgres in AWS.

·         Hands on experience on golden gate implementation configured 11g and 10g terminal version non-Exadata and Exadata environment.

·         Configured GoldernGate Downstream Mining and integrated component for Active-Passive and Active-Active.

·         Experience on Performance tuning of Oracle GoldenGate process to achieve zero lag time.

·         Installing and configuring Oracle GoldenGate agent with OEM GoldenGate Plugin.

·         Experience on creating Active stand by and setup Datagaurd for DR setup.

·         Hands on experience in Implementing Oracle Revenue Management and Billing(ORMB 2.3).

·         Hands on experience in ORMB cloning and patching.

·         Hands on Experience on ORMB Coherence upgrade for 2.3 to 2.6. 

·         Hands on Experience on 11g OBIEE installation and integrated with ORMB.

·         Experience on Python scripting.

·         Hands on experience on administration of Hadoop in Cloudera.

·         Worked on Global Data warehouse, OLTP, OLAP prod and dev environments and maintained and managed various sizes of database ranging from 500 GB to 50 TB on Linux 6.

·         Managing and directing offshore team for Project and operation.

·         Track record of providing excellent management of workload, strong troubleshooting and problem-solving skills.

·         Provided support for implementing and upgrading various new and third party application in client site.

·         As a team player with strong communication, relationship management and analytical skills and ability to meet deadlines.  

 

 

TECHNICAL SKILLS

Databases	Oracle 9i/10g/11g/12c, MSSQLSERVER, MYSQL ,Postgres,
Platforms	RHEL ES/AS/4/5/6, Sun Solaris 10/9/8, Windows 2012r2/2000/XP,
Programming Languages	SQL, PL/SQL, C, C++, Shell Scripting, python
Tools/Utilities	TOAD, PL/SQL Developer, SQLPLUS, STREAMS, GOLDEN GATE, VERITAS, TKProf, RMAN, Data Pump, tidal, MYSQL workbench, DB visualize, Mobaextra. Backup Tool IBM Tivoli storage Management, Commvault Backup Tool and RMAN
Hadoop Framework	HDFS, Map Reduce, Impala, Hive, Sqoop, zookeeper, Solr, flume, Hue.

 

 

 

 

Certifications

 

·         Oracle Certified professional  as Oracle 9i Database Administrator.

·         Oracle Certified Associate as Oracle 11g Database Administrator.

 

EDUCATION

• Masters of computer applications (MCA) from Pondicherry University - 2006
• B.Sc computer science from Bharathidasan University - 2003

 

 

 

 

 

Professional Experience

 

Esurance Insurance Services INC

 

Role : Sr Oracle DBA

Environment : Oracle core 11g in Linux 6.

Duration : July 10^th 2015 to till date

 

Esurance is committed to being the leading provider of insurance products and services for today's consumers who want to feel empowered and confident in their insurance decisions.

Esurance have innovative technology and great people to give our customers a rewarding, hassle-free experience, competitive prices, and amazing claims service 24 hours a day, 7 days a week.

Esurance is owned by Allstate Insurance Company, the oldest publically held personal lines insurer in the U.S.

Responsibilities:

·         Managing 60 TB of Datawarehouse database exist in Exadata X4-2 half rack.

·         Handling 60TB of Datawarehouse db.  in Oracle EXADATA X4-2 (DMA with knowledge on Cell Administration).

·         Installed and configured 11g Grid Control and database for PROD/QA/DEV environment.

·         Installed and configured of Oracle Enterprise Manager Cloud Control 12c for Exadata monitoring.

·         Worked on X4-2 RACK consolidation. Combined 2 quarter Rack to half RACK.

·         Hands on experience on disk and other component replacement without DB downtime.

·         Implemented IORM, DBRM to cap the resource usage on storage/database nodes on EXADATA X4-2.

·         Hands on experience on adding new serials to Platinum gateway server.

·         Proactive analysis of systems by running AWR, ADDM reports and taking necessary measures.

·         Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock and latch contention.

·         Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.

·         Quarterly CPU patching with detailed patch analysis.

·         Automate DB cloning for QA and Dev environment based on the user requirement.

·         Implemented Hybrid Columnar Compression for history tables.

·         Setup RMAN backup Jobs through OEM12c.

·         Setup Active Standby Data Guard for DR site

·         Installation and configuration of oracle transparent gate for MS SQLSERVER.

·         Hands on experience on SSIS package creation and transfer date to Oracle from Informix and MSSQLSERVER 2014

·         Worked on Oracle RAC implementation in Amazon Web Service(POC).

·         Hands on experience in DB restoration in MSSQLSERVER 2014.

·         Automated the data transformation from Informix to Oracle

·         Used Data pump for exporting and importing tables, schemas and table spaces.

·         Installed and configured MYSQL cluster.

·         Handled MYSQL and Postgres Database in ASW.

·         Spine-up EC2 instances and used S3 for External storage.

·         Installed and configures MYSQL and Postgres in AWS.

·         Managing Hadoop in cloudera.

·         Import new users through Hue.

·         Created scripts for Data ingestion and compaction.

·         Hand on experience on python scripting.

·         Schedule Data ingestion using spark-submit.

·         Configured Goldern Gate Downstream Mining and integrated component for unidirectional and Bi-Directional replication for oracle DB migration for 11g to 12c.

·         Experience on Performance tuning of Oracle GoldenGate process to achieve zero lag time.

·         Monitor and fix GoldenGate Extraction and replication conflict issues

·         Hands on experience installing Anaconda 3.5 in Hadoop cluster and created new environment for users.

·         Implemented SSIS 2008 ETL processes to load data from source files to target tables

·         Created complex SQL views and stored procedures to join multiple tables for contract data interface files.

·         Created database link between Oracle 10g and SQL Server 2005.

·         Administering SQL Server High Availability and Disaster Recovery strategies.

·         Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

·         Worked on configuring SQL Server with minimum privileged access.

·         Troubleshoot performance problems, fine-tuning of databases and index Analysis.

·         Worked on SQL Server 2012 migration from SQL Server 2008.

·         Performing Day to day DBA activities

·         Working with Different teams and gathering the requirements for the project.

·         Responsible for end to end execution of projects.

 

Wipro Technologies

 

Role : Sr Oracle DBA

Client : New York Stock Exchange(NYSE)(New York)

Environment :Oracle core 10g,11g and Oracle Apps 11i and Linux.

Duration : July 4^th 2011 to May 24^th 2015

 

The NYSE is owned by Intercontinental Exchange, a holding company it also lists (NYSE: ICE) A leading global operator of financial markets and provider of innovative trading technologies, NYSE Euronext (NYX) is the holding company and the first cross-border exchange group created by the combination of NYSE Group, Inc. and Euronext N.V., on April 4, 2007. It is by far the world's largest stock exchange by market capitalization of its listed companies at US$16.613 trillion as of May 2013. 

Responsibilities:

·         Performed DBA functions and handling/managing a team of 12 members

·         Worked with highly skilled people, experts in various streams of DBA knowledge

·         Installation, configuration, and maintenance of Oracle 10g on RHEL 4,5,6 and 11g on RHEL 5,6.

·         Responsible for setup and implementation of 8 node RAC on Oracle 11gr2 and 12c.

·         Configured ASM with high redundancy for high availability.

·         Implemented and managed Oracle Data Guard on Oracle 10g.

·         Upgraded the Oracle 10g to the latest Oracle 11g Release 2 by applied patches. Used both patch sets and interim patches.

·         Upgraded databases using DBUA.

·         Solid Exposure to Exadata Configurations including X2-8, X3-2, full rack, half rack and Qtr rack and X3-8.

·         Solid understanding of key Exadata features including Hybrid Columnar Compression, Exadata Smart Flash Cache, Exadata Storage Index and Exadata Storage Management & Administration.

·         Oracle Exadata server & database management (DMA with knowledge on Cell Administration, Linux Administration and management of other Exadata components like InfiniBand).

·         Implemented IORM, DBRM to manage resource utilization on EXADATA v2/x2 for ETL jobs and Application usage.

·         Applied quarterly Patches on Oracle Exadata X3-8/X3-2 Full and Half Rack.

·         Installed and configured MYSQL cluster.

·         Setup data load on mysqldatabase.

·         Installed and configured GolednGate 11.2.1 and 12.1.2 software.

·         Hands on Experience in configuring Golden Gate on Exadata Machines for data Replication..

·         Configured GoldernGate Downstream Mining and integrated component for Active-Passive and Active-Active.

·         Configured GoldenGate High availability using oracle DBFS and Active DataGuard.

·         Experience on Performance tuning of Oracle GoldenGate process to achieve zero lag time.

·         Installed and configured GoldenGate Agent to work with OEM GoldenGate Plugin.

·         Hands on experience in Implement OEM12.

·         Hands on experience in Implementing Oracle Revenue Management and Billing(ORMB 2.3).

·         Hands on experience in ORMB cloning and patching.

·         Hands on Experience on ORMB Coherence upgrade for 2.3 to 2.6.  

·         Hands on Experience on OBIEE integration for ORMB.

·         Hands on experience in implementing OBIEE installation and creating data source.

·         Configured standby solution for Oracle Ebusiness Database and applications.

·         Production Support experience in Hyperion.

·         Troubleshoot issues which arise during patching.

·         Daily health check and proactive monitoring of Production instance.

·         Implemented Data Guard on production database.

·         Daily Database clone using RMAN duplication and Cloning the oracle apps instances (scheduled or on-demand) from prod to test using rapid cloning process. 

·         Sysadmin activities like user creation, responsibility assignment, profile value change etc.

·         Created shell scripts to automate tasks like patch merging, health checks, post-clone steps, directory clean-up etc.

·         Support to general technical issues faced by developers.

·         Support Sev-1 Oracle service requests created for release bugs. 

 

Role : Sr DBA

Client : State Street (US New York)

Environment : Oracle core 10g,11g and Oracle Apps 11i and R12,Solaries (Sparc 64).

Duration : April 14^th 2010 to July 2nd 2011

 

Established in 1977, the State Street Foundation is the charitable grant making arm of State Street Corporation. Supporting the communities in which we live and work around the world is one of State Street’s fundamental values. Headquartered in Boston, the Foundation has 39 community support program committees in 26 countries responsible for establishing programs and managing relationships with local recipient organizations.

 

Responsibilities:

·         Quarterly CPU patching with detailed patch analysis.

·         Troubleshoot issues which arise during patching.

·         Prepared patch impact analysis and execution plan for Min baseline patches (30 products, 100 patches) for Extended Support on E-Business suit 11.5.10.  

·         Resolve the concurrent manager, concurrent programs issues and performance issues related to concurrent programs

·         Daily health check and proactive monitoring of Production instance.

·         Monitor the Application System with Oracle Applications Manager (OAM).

·         Cloning the oracle apps instances (scheduled or on-demand) from prod to test using rapid cloning process. 

·         Modify and track customizations on template files during Autoconfig customization.

·         Sysadmin activities like user creation, responsibility assignment, profile value change etc.

·         Generate diagnostic reports using tools like SQLT, TRACEANALYZER, TOAD, Oracle Diagnostics etc

·         Created shell scripts to automate tasks like patch merging, health checks, post-clone steps, directory clean-up etc.

·         Support to general technical issues faced by developers.

·         Support Sev-1 Oracle service requests created for release bugs.

·         Implement Datapump for 11.2.0.2 in UA environment and refresh database using DP backup.

·         AWR and ASH report creation for analyze performance issues.

 

 

WiFi Networks Pvt Ltd

 

WiFi Networks is a provider of ready-to-deploy mobile products and services. Wifi is partner with Broadcasters, production companies, advertisers, brand-owners and mobile operators, enabling them to generate revenue by offering interactive entertainment, Interactive TV program formats and mobile Value-added services to end-users.

 

Role : DBA

Project : RaceAfrica

Environment :Oracle 10g, sqldeveloper,linux CentOS,RMAN,Xshell

Duration : Feb-2009  to  Mar -2010

 

Responsibilities:

 

·         Installation and configuration of Oracle for production server under Linux CentOS environment.

·         Configure datagaurd physical stand by for production database.

·         Upgrade quality server using database upgradation assistant from 10.2.0.1 to 10.2.0.4

·         Restored PROD database on server crash.

·         Test Recovery of Production database twice in a week on quality server .

·         Configure Rman backup with remote server

·         Applying CPU critical patch update on production server for every 3 months

·         SQL tuning for application developer team improve performance of loads.

·         Implemented table partitioning both in Mysql and Oracle to improve performance and data management.

·         Taking cumulative backup for both the production and quality server.

·         Configure streams replication for Horse racing schema on 10g in Quality.

 

OneAPPS Enterprises Technologies

 

OneAPPS is a leading provider of professional, outsourcing and enablement services for Largecap and Midcap mid-market organizations. It is a concern that placed professional to their client place.

 

 

 

 

Exide Technologies, with operations in more than 80 countries and fiscal 2011 net sales of approximately $2.9 billion, is one of the world's largest producers and recyclers of lead-acid batteries.