Summary
Strong in project/program, Pre-sales, transition, Team, ITIL & CMMi Management.
Highly Skilled in Oracle 9i,10g, 11g & 12c- DBA, RAC, RMAN, ASM, Hexadata, UNIX shell, and cloud technologies.
Now managing online application & ETL work flows which process transactions worth of 170 M USD/Day
Developing and growing the customer account, and customer relationship
Offering innovative services/solutions to the customer
Focus on quality of the delivery and customer satisfaction and provide leadership on new services offerings / strategy
Establish strategic alignment with technology or domain, provide support to COEs to achieve business goals
Managing P&L for the CBU and accelerating the targets through the program management team and business development team. Be responsible for preparing, complying and tracking budgets for the CBU
Compliance to Business contract, SLAs, Agreements, SOW.
Building& effective use of knowledge repository for the CBU
Compliance and improvements to domain and organization processes in collaboration with CoE
Implementation of Enterprise Automation Solutions of the organization across and evolve the standard Metric for all dimensions including Projects, Processes, Delivery.
Utilization deriving the Productivity quotient
Continuous improvement of CBU specific processes with focus on delivery process excellence
Contribution to vertical decisions and leadership initiatives
Developing, Mentoring & Retaining the talent in the BU
Ensuring integration of people in the CBU with effective & periodic communication
Planning and proactive people management for the CBU
Building managerial pipeline for the CBU
Building and enhancing competencies of the CBU team for current & future requirements.
Experience
Company
Designation
comments
From
To
MFX InfoTech (part of Quesscorp.com)
Sr. Project Manager
Moved to Client Pay roll
Aug-14
Till Date
Data Cede
Sr. Project Manager
Middle level Management
Feb-13
Jul-14
Logica (CGI Now)
IT consultant – T2
Senior Technical Architect
Apr-10
Feb-13
Covansys (CSC Now)
Team Lead Level 1
L3 support
Sep-07
Apr-10
Eforce Global
DBA
Oracle Streams Replication
Feb-07
Seb-07
Emerio, Malaysia
Technical consultant
Client : HP Global centre
Jun-06
Feb-07
Ford Motors
Associate DBA
Moved to client payroll
Mar-06
Jun-06
Focus InfoTech
Software Engineer
Client FORD FITSI
Sep-05
Feb -06
Indian Air Force
Ex-Corporal
Built Data centre/ATC
May-94
Mar-05
Education
Qualification
Specialization
Institute
Percentage
Year
MBA
Operations
IGNOU
63%
2012
MCA
Computers
IGNOU
63.50%
2005
B.sc
Maths
University of Madras
59%
2001
12th
Maths, Physics, Biology
Tamil Nadu State University
83%
1994
10th
Maths, Physics, Biology
Tamil Nadu State University
85%
1992
Certifications
PMP
Project Management
PMI-ID: 3074654
2014
OCP
10g DBA
Oracle
2010
OCP
9i DBA
Oracle
2005
Courses attended
Executive Leadership training
Leadership skills
By CEO, Hofincons
2015
ITIL V3
Process
ISEB certified trainer
2009
Bird Hazard Management
Aviation
Indian Air Force
2003
Air Field Safety Operator
Air Traffic Services
Indian Air Force
1995
Awards and Recognitions
Best operational role
Kargil Operations
Indian Air Force
By CO, 34 Wing
1999
Tsunami Relief operations
Relief operations
Indian Air Force
By CO, 43 Wing
2006
Best Performer of the year 2008
DBA
Covansys a CSC company
By Program Manager
2009
Ideator Award
Research and Development
Logica a CGI company
CEO of Logica
2012
Employer/Client : DataCede/MFX Feb 2013 to Till Date Moved to client payroll from August 2014 same profile/ Designation
Team Size : 50-60 [direct reports to me, some team have TL’s]
Role : Infrastructure/Application Services Manager
Environment :OS/Database/SAP/Informatica/Helpdesk/Network/Exchange servers and apps support
Tools : BMC, Microsoft Project Management, JIRA and share point.
Description : 24hrs/365 days of support for servers and its applications
Management Responsibilities:
1.Project Initiating/Planning and Continuous Monitoring.
2.Handshake meeting for SLA reviews, General Management.
3.Data center support planning and maintenance/Operations.
4.Part of Cloud implementing core team
5.Part of Duty Manager ROTA for handing Severity 1 issues
6.Improved the C-SAT (via improved Quality delivery).
7.Completed successfully ISO certification, CMMi Level 3
8.Handling end client escalation on delivery. End user services delivery like help desk.
9.Process enhancement / knowledge base creation
10.Strong vendor management for the client and in house services
11.BMC, Zenoss and sysaid implementation knowledge.
Technical Responsibilities which team handles and I Manage:
12.Server builds for the client with VMware (ESX 5.5) utilities
13.Storage allocation and de-allocation using EMC storage
14.Working on Network and Telecom related issues.
15.Microsoft Exchange-server/LYNC-2013/cloud/IBM-lotus-notes/Black-berry/IPhone.
16.Working security team for RSA tokens, AD account configurations.
17.Building databases in Oracle, SQL, MySQL servers
18.Implementing the RAC systems for Oracle RDBMS.
19.Application data patch releases Management.
20.ETL work flow management triggered via Autosys scheduler plus ETL repositories.
21.Handling IT helpdesk support round the clock for user support on the phone/Emails.
22.Managing the backups for the data centers via EMC Avamar Grid, Legato Networker.
23.Handling Middle tier configurations like Java Tom cat apache, IIS servers
24.Handing Microsoft share point (2013) Configuration, Maintenance and support.
25.Dedicated cloud hosting (Xenserver 6.2/Cloudstack v4.2.1/cDOS v5.1)
26.Application team of support/development in Java, PL/SQL, .NET, VB
Employer/Client : Logica (Daimler, AMB, Sweeden) Apr 2010 to Feb 2013
Team Size : 25
Role : Deep Technical Support
Environment : Oracle 8i/9i/10g/11g on linux/solaris/AIX/Windows
Tools : BMC monitoring alerts, Multicenter, Data protector
Description : 360 Degree support for Databases and its applications
Overall Responsibilities:
Handling L1 and L2 Resources (Junior DBA’s) in solving their day to day tickets from monitoring and user requests
Monitoring backups and fixing the issues if required coordination with SAN team and backup team
Disaster Recovery Testing once in three months
Sox compliance tasks like monthly tasks/ quarterly/ half – yearly and yearly tasks
Giving solution to L3 tasks such as migration/capacity planning/performance tuning etc
Talk to Oracle support/ BMC support and other vendor management
Working out critical patch updates and bug fixes
Pro-active Database monitoring initiatives and follow up with application team for fixing the bugs
Knowledge management of each client known issues
Co-coordinating and imparting training on technical skills to the fresher’s
Part of Innovation team inside Logica
Employer/Client : CSC/LOBLAW Jun 2009 to April 2010
Team Size : 15
Role : Oracle DBA (Production support)
Environment : Oracle 8i/9i/10g/11g on linux/solaris/AIX/Windows
Tools : BMC monitoring alerts, Remedy ticketing system
Description : Production support for 500 + servers around the globe.
Overall Responsibilities:
Handling Incident tickets (by BMC Remedy) like Critical availability of database / listener / part of database / space issues etc
Handling User requests like giving privileges and any issues faced by the user like running batch jobs etc and SQL tuning requests from development team
Handling Job failures reported through BMC tickets like hot backup failure / arch backup failures etc
Handling change requests like Regular maintenance tasks (table re-org / index rebuilds) / re-building DR sites (physical standby / cloning of db) / Any parameter changes after getting advise from Oracle / applying patches like CPU and version upgrades
Working with Oracle support for any critical issues like RAC / Data guard / ORA-600 alerts etc.
Handling on-call DBA duties
Application support from development to test/QA and rolling out to Production
Database Responsibilities:
Production support for Oracle databases including on-call support as per SLA
Responsible for Backups validity and Recovery testing
Creating/Maintaining Databases (10g) and configuring Logical Backups using IMP/EXP, Data pump. Working closely with application development team for production roll outs and troubleshooting at database level if any issues
Co-coordinating with various teams like Unix team, network team and other application teams for handling application/database related issues
Creating Database objects like PL/SQL procedures /packages /Triggers / views/Materialized views /creating SQL scripts as per the application requirement
Employer/Client : Covansys/Pfizer. Sep 2007 to Jun 2009
Team Size : 5
Role : DBA, Apps server DBA
Environment : Oracle 9i AS and 10g AS, Oracle 9i/10g, SUN OS version 10, VCS cluster and
CSS Load balancer.
Tools : Datastream 7i, Extended, Databridge, Webmethod, TOAD, Service centre
Ticketing system, Discoverer reporting tool
Description :
1. Migration of oracle database from 9i to 10g
2. Upgrading the ASSET management tool (Datastream) from 7.8 to 7.10 /8.3
3. Upgrading oracle 9i AS server to 10g AS
Responsibilities:
1. Production support for Databases and Application as per SLA
2. Frequent Data refreshes from production to dev/test and vise versa as per request.
3. Creating Application level environments for test and DEV environments
4. SQL tuning and application tuning
5. Taking Regular Backups such as Logical / physical
Database Responsibilities:
Production support for Oracle databases including on-call support as per SLA
Responsible for Backups validity and Recovery testing
Creating/Maintaining Databases (10g) and configuring Logical Backups using IMP/EXP, Data pump. Working closely with application development team for production roll outs and troubleshooting at database level if any issues
Co-coordinating with various teams like Unix team, network team and other application teams for handling application/database related issues
Creating Database objects like PL/SQL procedures /packages /Triggers / views/Materialized views /creating SQL scripts as per the application requirement.
Apps Server Responsibilities:
Oracle Apps Server (Oracle 10g AS/9i AS) – Installing, Basic performance tuning at APPS server level
Configuring oracle reporting server /forms server /HTTP server /OC4J instances /JBoss Instance / export to excel functionalities at Oracle APPS server (9iAS/10gAS)
Applying patches at various level of application like – Database level, Forms level, and any third party tool product level
Monitoring the jboss server logs / session logs for any errors for troubleshooting
Upgrading a Distributed Oracle Application Server Environment
Expanding a Middle-Tier Installation
UNIX Responsibilities
Creating Shell scripts (Unix shells) like identifying and creating automated scripts for routine tasks to save time
Monitoring the sun Solaris server health like CPU utilization and space utilization (using prstat / sar / opmnctl /emctl / df –h commands)
Employer/Client : EFORCE/Baker Hughes Feb 07 – Sep 07
Project : Replication/Quotation Process Enhancement / Supplier
Document Retrieval
Role : DBA, Apps DBA & System Admin
Environment : Oracle 10g, SUN OS version 10
Tools : TOAD, CVS Code base, Broad Vision, Secure CRT, Ultra Edit
Team Size : 5
Configured Replication using oracle 10g streams technology
Hosted Document Retrieval system in Houston for the suppliers.
Working on Quotation process enhancement.
Responsibilities:
Working with Data Architects and Technical Architects for creating schema objects such as tables, views, triggers etc.
Helping Developers to create OS level / Application level environments
Data Refresh from Production to development.
Taking Regular Backups such as Logical / physical
Employer/Client : EMERIO/HP –NOKIA project Jun 06 – Feb 07
Project : Production Data Management System, Nokia
Role : Oracle DBA
Team Size : 12
Tools: RMAN, OMEGA, OVO, RMT, Remedy Engine and TOAD
Responsibilities:
Handling 900 + Nokia Production Databases (Oracle, MS-Sql) on Linux, UNIX and Windows platforms. Database sizes from 450 GB to 3 Terabytes.
Installation of Oracle Software on various platforms: Lastly installed oracle 10g R2 in Linux ES-4 version.
Migration: Done Migration from 8i to 9i and further to 10g using migration utility.
Applying Patches: Analysis, Testing, and Recommendation & Implementation of updates of higher releases of the Database Management Software. (like Oracle Corporation Releases critical patch update at every 6 months)
Handling Replication problems: push and purge jobs, handling the dbms_jobs in replication environment.
Space Management: Checking the Server space like archived log files backing up to tapes using RMAN scripts and deleting from the disk (Delete input), shrinking the Datafiles etc.
Backup strategies: RMAN, Inconsistent and Logical backups and testing their backups in their Test server. (Contingency Testing).
Refresh of Data: exp/imp from production to Development Databases for further testing.
Tuning of SQL & PL/SQL: Application Tuning using Statspack/Tkprof. Tracing the user session for improving performance.
Application Launches and upgrades: Launching the application and upgrading the existing application to next level
Capacity Planning: Collecting metrics for the on-going capacity planning process.
Constantly monitor the performance: (V$ dynamic Performance views at peak load) of the databases, View Alert Logs and Trace Files.
Attend to day-to-day problems in the ORACLE database and take suitable actions for Trouble shooting including helpdesk Management and Documentation
Prompt Resolution of User Problems by ensuring compliance to Service Level Agreements
Employer/Client: FORD /FORD Motors Sep 05 – Jun 06
Project : Application Development Services (Asia Pacific)
Role : Associate DBA
Team Size : 21
Tools : OEM, CRON and OEM Schedule Email
Functions : Looking after more than 600 FORD Production databases around the world.
Responsibilities:
Looked after 600 + Databases (Oracle 8i, 9i on Windows, Linux and HP-Unix) around the planet for FORD Motors.
On-Call support: Given 24*7 support for critical errors like Database or part of the Database is not available or listener goes down or archive log destination getting filled up etc.
Disaster Recovery procedures: Formulated and implemented DRP for FORD motors and had taken part in Recovery procedures.
APPLICATION LAUNCHES/UPGRADES: Launching and upgrading the existing applications.
Maintaining users: Creating/Removing oracle users with appropriate privilege.
Management of Database space, Tablespace Growth Monitoring, Data file additions, Extent Growth Monitoring, and Management of Rollback Segments.
Maintenance of ORACLE Database on the Production Machines
Schedule Database Reorganizations (Defragmentation) in order to keep the database running smoothly.
Fine tuning of the database: Memory (S.G.A), I/O and Application tuning
INDIAN AIR FORCE May 94 - Mar 05
Role: Oracle DBA /EDP Manager
Responsibilities from Jan 04 - Mar 05
As Oracle DBA created oracle 9i database and implemented four applications successfully on Windows NT platform. After Tsunami our databases went 24*7.
Responsibilities:
Installed oracle 9i in windows 2000 server & created DB’s
Created schema and schema objects
Logical and physical backups (cold and hot)
Fine-tuned the applications
Created the repository and initiated Auditing.
Other Responsibilities (May 1994 – Dec 2003)
Role : Air Traffic Services
Duties: Making flight plans, coordinating the flight movements, aerodrome controls, and Air Navigations and Radar support. Also part of weather reports.
Contact Details
Mobile No. : 988-***-**** OR 988-***-****
Land line : 044-********
Mail ID : acqjyv@r.postjobfree.com, acqjyv@r.postjobfree.com
Skype id :Shenbagaraman_PMP
Passport no : Z2397522 (B1 visa valid till 2018)
Marital status : Married
Address : 4A Anugraha apt, Lavender St, Mugalivakkam, Chennai 600125, INDIA.