Senguttuvan Venketakrishnan

214-***-****(Home)

972-***-****

acrswe@r.postjobfree.com

Summary:

Dedicated and committed Oracle DBA with more than 14 years of experience in Oracle 7, 8,8i, 9i & 10g & 11g,12C databases with large user bases (5000+) and 500TB sizes.

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

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

Professional Experience:

Progressive IT @ CENTURYLINK Site, MONROE, LA July 2012 – June 2015

Senior Oracle DBA Architect

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

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.

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 .

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