Oracle Data
Resume:
Senguttuvan Venketakrishnan
214-***-****(Home)
*********@*****.***
Summary:
Dedicated and committed Oracle DBA with more than 18 years of experience in Oracle 7, 8,8i, 9i & 10g & 11g,11gr2 RAC &12C databases with large user bases (5000+) and 500TB sizes.
Extensively Involved in Oracle Goldengate Extract/Replication (Both Integrated & Classic ) & Troubleshooting Goldengate issues
Support of OLTP Customer Service Application & Batch Billing Operations of Centurylink operations
Expertise in working Exadata environment with Datawarehouse applications
Extensively Involved in System Analysis/Programming/Data warehouse Development over 10 years
Worked on various flavors of Operating Systems like Sun 8/9, HP-UX 11, Red Hat Linux, Enterprise Advanced Server 5 and Windows Advanced 200x servers & AIX.
Well versed in Oracle software installation, database creation, configuration and maintenance.
Experienced in Oracle 10g & 12C RAC implementation & administration using Oracle Clusterware including Oracle Clusterware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery
Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
Designed logical and physical database design using Erwin tool.
Ample experience in setup and maintenance of RMAN and Oracle Streams.
Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
Experience in Capacity Planning, Space Management, Database Upgrades / Migration.
Designed data marts based on star and snowflake data warehouse designs.
Extensive experience in writing stored procedures, Packages, Triggers & Functions.
Extensive experience in providing 24x7 support for Mission Critical and high availability databases and ensured database functionality.
Expert in performance tuning, troubleshooting, code optimization, partitioning, capacity Planning and recommendation.
Good experience in Datapump, Flashback database and DBMS Scheduler.
Used various tools like Oracle Enterprise Manager, Statspack, TKPROF, Explain Plan, ADDM, and AWR to tune SQL, memory, I/O and databases for better performance.
Performed normalization and de-normalization in data warehouse projects.
Oracle Replication using Standby Db’s and using shareplex & Goldengate
Ingres DB Maintenance & Development
VAX-RDB Database Maintenance
Replication using Oracle Data Guard
Replication using Physical Standby Databases
Implemented SOX compliance in ORACLE DB side for All Production DB’s @ Centurylink
SQL-Server 2008 DBA expertise
Architecture Experience Summary
Successful background working with stakeholders to develop architecture framework that aligns strategy, processes, and IT assets with business goals.
Work closely with project managers, developers, and focus groups to avoid redundancy, minimize expenditures, and improve overall synergy within organization.
In-depth experience establishing best practices and guidelines for selecting, developing, and implementing information systems within enterprise.
Acute knowledge of hardware, software, networking, applications, and systems engineering.
Excellent communication, presentation, and organizational skills.
Education, Certification & Training:
M.S ( Physics)
P.G.D.C.A ( Post Graduate Diploma in Computer Science and applications)
Oracle Certified Professional 8i
Oracle Certified Professional 10g
Oracle Database 10g: Real Applications Clusters (RAC) Administrator Certified Expert
Linkedin Recommendation from previous DBA Team members (https://www.linkedin.com/in/senguttuvan-venketakrishnan-5b8538/)
Technical Skills:
Databases: Oracle 11g, Oracle 10g, Oracale9i, ORACLE8i, ORACLE-8, ORACLE-7, INGRES6.4, IDMS, VAX-RDB, Sql-Server-2008,AIX Unix
Operating Systems: HP9000/HP-UX 11i, NT, VAX/VMS, ICIM, PRIME-9955, Windows-2000, Windows-95,SUN-OS E6500,SunOs 5.6, Sun 8/9
Languages: ORACLE PL/SQL, PRO*C, ORACLE-FORMS,ESQL-C, INGRES-Report Writer, VAX-RDB, ACMS, ABF,DEC-FORMS, 4GL, PRO-IV,COBOL, FORTRAN, BASIC, Crystal Reports, VAX-DCL, Unix Shell Scripting, ORACLE SQL*LOADER
ETL- Tools Used: Data Junction (Data Mapping and Data Extraction),Data Mirroring, Data Mining and Data Loading,
Case Tools Used: ERWIN (Data Modeling)
Miscellaneous: Quest SQL-LAB, VERITAS Precise-i3, Query Tool Q+E, Starjet Report Design, UPS/RPS Bar Coded Label Design, Backup and Restore using RMAN, Grid-Control OEM
Replication Tool: SharePlex Version = 3.2.12, Oracle-GoldenGate 11, 12c
Professional Experience:
Progressive IT @ CENTURYLINK Site, MONROE, LA Jan 2017 – June 2017
Senior Oracle DBA Architect with Goldengate expertise
Successfully implemented Oracle Goldengate integrated extract/replicate using Mining Db method for Data warehouse from the Customer Ensemble DB.
Redo shipping will happen from our Telecommunication Customer DB to a Mining DB.. and from that Mining DB Goldengate integrated extract will extract data for those requested tables.( 46 tables involved in that replication).
To get good performance created three different groups of extracts/replicate depends on the data volume
Created monitoring shell scripts to send out lag information & if any abends in GG extract/replication. Good Knowledge in troubleshooting perl scripts
Included DDL capture also in this method.. Any DDL changes happening in source will take care in the target also
Since our Customer DB is 4 node oracle RAC 11gr2. we have created multiple services based on the requirement.
Online Transaction Processing ( OLTP application services) will be going to only 2 instances. Batch activities will go to 2 other db instances..
Distributed the services according to the application
Environment:
Hardware: Linux lxmdtsdx04.test.intranet 2.6.32-642.15.1.el6.x86_64 #1 SMP Mon Feb 20 02:26:38 EST 2017 x86_64 x86_64 x86_64 GNU/Linux
DB Software: 11gr2 RAC with 4 nodes Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
GG Version:Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Progressive IT @ CENTURYLINK Site, MONROE, LA Jan 2016 – Dec 2016
Senior Oracle DBA Architect with Goldengate expertise
Extensively Involved with the Cross Platform Migration ( From Hp-Ux Oracle 11g to Linux 11gr2 RAC)
Initial 20 TB Database has been migrated to Linux using RMAN Transportable Tablespace method.
Once converted and opened with particular SCN, then production data has been replicated to the converted environment using oracle Goldengate extracts/replicate.. I have extensively worked with this sync up the converted DB using Goldengate.
Used the ALO method for the extract.. Once everything is current We went with production.
Created multiple groups of extract/replicate to achieve good performance
Extensively involved in the Troubleshooting oracle Goldengate issues
Also Involved in the setting up of oracle 11gr2 RAC development databases.
Monitoring & troubleshooting RAC related issues. Automating Environment refresh using Shell scripts.
OLTP application Support & Batch Operations of Billing system
Environment:
Hardware: HP-UX lamare05 B.11.31 U ia64 151******* unlimited-user license,Linux
DB software: oracle 11g (11.2.0.4 non-rac) & oracle 11gr2 RAC in linux
GG Version:12C
Amdocs @ at & t Site, Richardson,TX
OCT 2015 – Jan 2016
Senior Oracle DBA with Goldengate expertise
Setting up & troubleshooting all development & test environments extract/replicat.
Worked with monitoring scripts & Automating Amdocs application upgrade scripts
Involved in application upgrade of Amdocs onlines (OLTP and batch operations of Telecommunication Billing system)
Progressive IT @ CENTURYLINK Site, MONROE, LA July 2012 – June 2015
Senior Oracle DBA Architect with Goldengate Expertise
As a Lead ORACLE DBA Architect Involved in Physical DBA Activities and Amdocs Ensemble Application DBA activities & Working with EDS CIRAS application Database Migration.
Physical DBA activity includes Creation of New DB instances in Oracle 10g/11g /12c and setting up Backup/Recovery procedures using RMAN. Alert Monitoring using OEM. Setting up DB Stats collection at Regular Intervals. Upgrading DB’s from 9i to 10g and 10g to 11g. Migration of DB’s from SunOS Platform to Linux. Involved in Failover activities.
Extensively Involved in setting up TDE encryption using AES128 protocol for the sensitive data in Ensemble Databases ( Such SSN, Credit Card no. etc)
Involved in the Performance Tuning activities of oracle 11g/12c databases
Implementation of GSD standards in all the oracle Databases
Extensively involved in all Amdocs Ensemble application patches
Extensively involved in the Oracle DB patching from 10g to 11g
Provided KT about Centurylink DB architecture and application setup to Centurylink Offshore folks
Setting up of Dataguard replication with oracle 11g and 12c
Setting up of Oracle RAC 12c two node DB with virtual machine ( Linux OS)
Involved in the Archive/Purge process of Ensemble Customer Application DB. Archiving to RAINSTOR DB
Provide full fledged training regarding Ensemble application process to offshore and onshore DBA’s
Worked with Remedy Ticketing System. Involved in Dimension process to check-in /check-out the Oracle processes involved in Ensemble Application. Also worked with Change Control Management process to implement the DB activities during application release
Setup Oracle Goldengate Classic extract/replicat from customer/usage Ensemble Databases to
Datawarehouse DB . Used GG version 11.2.1.0.2 . Implemented Monitoring tools to sent email/page if the GG extract/replicate is abending/stopping.
Environment: Oracle 10g/11g/12c/12c RAC/Sql-Server-2008, HP-UX B.11.31 U ia64,Linux, Sunos 5.10 Generic_138888-07 sun4u sparc, OEM ( Grid-Control), Precise-i3,AIX Unix
IISC @ AIG – ATOS DataCenter Fort Worth,TX
Mar-2012 – June-2012
Senior Oracle DBA
As a Senior ORACLE DBA Involved in Datacenter Crossplatform Migration Activities for AIG Databases
Migrated Oracle Databases 10g, 11g from Solaris to AIX-Unix
Migrated Oracle Databases from Windows Platform to AIX, Windows to Linux
Extensively Involved in the Installation and setting up of new DB instances using Oracle 11g
Involved in the Installation activities of SQL-Server 2008
RMAN db backup/recovery procedure using netbackup
Environment: Oracle 10g/11g/RAC/Sql-Server-2008,,Linux, Sunos 5.10 Generic_138888-07 sun4u sparc, OEM ( Grid-Control), Precise-i3,AIX Unix
Progressive IT @ CENTURYLINK Site, MONROE, LA Apr 2009 – Dec-2011
Oracle DBA
As a Lead ORACLE DBA Involved in Physical DBA Activities and Amdocs Ensemble Application DBA activites.
Physical DBA activity includes Creation of New DB instances in Oracle 10g/11g and setting up Backup/Recovery procedures using RMAN. Alert Monitoring using OEM. Setting up DB Stats collection at Regular Intervals. Upgrading DB’s from 9i to 10g and 10g to 11g. Migration of DB’s from Windows Platform to Linux. Involved in Failover activities. Provided DBA support for BCV process.
Actively participated in on call DBA rotation ( 24/7).
Performance maintenance such as Rebuild Indexes, tables etc
End to End support & setting up of the Telecommunication Billing Application.
Setting UP RAC environment for the Conversion activities ( Embarq to CenturyLink).
Involved with SOX compliance activities in DBA side.
Involved in application upgrade of Amdocs onlines (OLTP and batch operations of
Telecommunication Billing system)
Environment: Oracle 10g/11g/RAC/Sql-Server-2008, HP-UX B.11.31 U ia64,Linux, Sunos 5.10 Generic_138888-07 sun4u sparc, OEM ( Grid-Control), Precise-i3,AIX Unix
Genesis Network Amdocs @ Cingular Site, Richardson,TX Mar 2008 – Apr 2009
Oracle DBA
Application DBA support for at & t Telecom Billing System.
Setting up of new Amdocs Ensemble Environments and Production APP DBA support for at & t Prod DB’s.
Involved in SQL tuning activites..
Also involved in the DB-maintenance activities such as Reorg tables & Indexes and partition table maintenance. Extensively Involved in Data Migration from Convergys Billing System to Amdocs Ensemble Billing System .
Involved in application upgrade of Amdocs onlines (OLTP and batch operations of
Telecommunication Billing system)
Environment: Oracle 10g, Goldengate replication, HP-UX 11, OEM ( Grid-Control), Precise-i3
Progressive IT @ CENTURYTEL Site, MONROE,LA Sep 2007 – Mar 2008
Oracle DBA
Physical & Application DB activities for Centurytel Telecom Systems.
Involved in Setting up OEM for monitoring ORACLE Databases in Centurytel. Configuring OMS server.
Environment: Oracle 9i, HP-UX 11, OEM ( Grid-Control), Precise-i3
Amdocs @ Cingular Site, Richardson,TX Feb 2005 – Aug 2007
Oracle DBA
Application DBA support for at & t Telecom Billing System. Setting up of new Amdocs Ensemble Environments and Production APP DBA support for at & t Prod DB’s.
Involved in SQL tuning activites..
Also involved in the DB-maintenance activities such as Reorg tables & Indexes and partition table maintenance Extensively Involved in Merging activities of AT & T to Cingular
Environment: Oracle 9i/10g, HP-UX 11, OEM ( Grid-Control), Precise-i3
Progressive IT CENTURYTEL Site, Monroe,LA Jul 2002 – Jan 2005
Oracle DBA
As an Oracle DBA Team Lead Supporting Production & Non-Production ( Development) VLDB ( 1-Terrabyte) Databases. Indepth knowledge on Amdocs-Ensemble system on the backend. Involved in Application setup ( Ensemble), Upgrade of Ensemble application patches, Upgrade of oracle versions ( 8.0.6 to 8i, 8i to 9i), Performance tuning of Databases & Backup and recovery of databases using RMAN ( RAW File System) and shell scripts.
Creation of new Databases and capacity planning and Performance monitoring .
Environment: Oracle 9i/8i/8.0.6, HP9000/HP-UX 11i, SUN-OS E6500, Precise-i3
PSCS AMDOCS @ NEXTEL Site, Atlanta,GA Aug 2001 – Jun 2002
Oracle DBA
As an ORACLE DBA Involved in the Creation and maintanace of 700GB (VLDB) Standby Databases (NOR ‘s – Nextel Owned Replication ) for the Reporting Purpose of NDW ( Nextel Data Warehousing). Partial Replication using Shareplex ( For One of the Major application of NEXTEL-EDM). Also involved in the Partition Replication ( Only 7 days Data to be replicated to the Reporting Server).
Also Involved in Performance Tuning of the Datawarehousing applications . Created Automatic Recovery Procedures for the Replicated Database.AMDOCS is the world’s leading provider of superior, advanced telecommunication Billing software products. Knowledge of Telecommunication Billing Process
Environment: Oracle 8i/8.0.6 SharePlex Version = 3.2.12-i3, HP-UX B.11.00 U 9000/800, SUN-OS E6500
Global Software Tech @ LOREAL USA Site, North Brunswick, NJ Jan 1999 – Jul 2001
Oracle DBA/Development
SAMI is a powerful and flexible Datawarehousing Decision Support tool for the management to improve their Product Sales in the Local and GlobalMarket.
Functioned as a Oracle DBA, Creation and maintenance of 160GB size Database.
Involved in Database sizing, creation, day to day maintenance, Performance tuning, Development of PL/SQL procedures and Created Database Monitoring scripts. Created Interfaces from the Order Processing, Distribution & Human Resources Systems.
Automated the process of loading of the Retail Sales Information from EDI. Developed and implemented Sales Force Automation. Converted Data from Ingres to Oracle using Data Junction. Also involved in ongoing support for the existing ingres database.
Environment: Oracle 8i, PL/SQL,INGRES, PRO*C, ESQL-C, Crystal Reports using Oracle ODBC, Ingres Report Writer, Unix Shell Scripts, Data Junction,Data Mirror, Windows-NT4, HP900/UX
Global Software Tech @ Maybelline USA Site, Little Rock,AR Aug 1997 – Dec 1998
Oracle DBA/Development
Functioned as DBA/ORACLE supporting and maintaining the production system.
Converted Data from Ingres to Oracle Database. Validated the Data Accuracy.
Involved in Performance Tuning of the SAMI Database .Developed new reports according to the User Requirement.
Automated the Dayend and Monthend process Using Unix Shell Scripts. Involved in the development of Oracle PL/SQL Procedures. Created Cold and Hot backup scripts.
Environment: Oracle 8, Ingres, ESQL*C, PRO*C,PL/SQL, Crystal Reports, Windows-NT4, HP900/UX
Global Software Tech @ Maybelline USA Site, Little Rock, AR Jan 1997 – Jul 1997
Ingres DBA/Development
The Warehouse Inventory Management System maintains the inventory of the finished goods, materials and controls over the location of the goods, and as customer order their needs from the warehouse, having good selection and shipping procedures.
Functioned as DBA ingres, Converted the Mainframe Data to ingres.
Developed some additional reports, Maintenance screen using ABF according to the User Requirement.
Team of 3 people Involved in this Project.
Environment: INGRES6.4, ESQL*C, ABF, Ingres Report Writer, STARJET, PALLET TICKET LABEL GENERATION USING RJS printer, Windows-NT4, HP900/UX
Global Software Tech @ LOREAL USA Site, North Brunswick,NJ Nov 1995 – Dec 1996
Ingres DBA/Development
Lead role in a team effort to develop a flexible Distribution System that provides automatic cubing, grouping and routing of the orders. The Distribution involved picking the material from warehouse and packing and generating pick-pack labels, packing slip etc.,
Involved in System Development, Database Creation and Integrated System testing.Generated UPS/RPS Labels using RJS printer. Team of 4 involved in this project.
Environment: INGRES6.4, ESQL*C, ABF, Ingres Report Writer, STARJET, PALLET TICKET LABEL GENERATION USING RJS printer, Windows-NT4, HP900/UX
Global Software Tech @ SKYALLAND Marketin Research Site, Rockville,MD Feb 1995 – Nov1995
ORACLE DBA/Development
Functioned As a Systems Analyst involved in the Survey Report Module Development and integrated System testing for the following Clients of Skyalland Marketing Research.
The Clients are AUDI, MITSUBISHI, BMW, CADILLAC, VOLKSWAGEN, BOA & CHEMICAL BANK. Team of 5 people involved in this project.
Also involved in the Database sizing, Performance Tuning of CRMS database.
Environment: ORACLE-7, PL/SQL, PRO*C, ORACLE-FORMS4.5, Data Mining, HP900/UX
Contact this candidate