GNANAVEL KULLU (GV)

adgx3o@r.postjobfree.com

Mobile: +1-303-***-****

He has over 16 years of database experience in IT industry and performed various facets as technical, transition to offshore, project management and service delivery roles.

Extensive knowledge in planning, architecting, acquiring and administering the database infrastructure for a global database team comprising of multiple database flavors as well as managing a staff of database professionals.

Ability to manage all facets of project lifecycle, including transition, service delivery support, risk analysis, managing offshore and onsite model, incident, problem, change and release managements of IT Infrastructure support for database tower.

Possess strong organizational and communication skills, ability to successfully build strong working relationships with co-workers and clientele, while managing a healthy team.

Worked on Oracle advanced products like Exadata, Golden Gate, RAC, RMAN, Dataguard, ASM and Grid Control.

WORK EXPERIENCE SUMMARY

Currently working as Infra Ops Specialist – Database in Cognizant Technology Solutions from May 2014 till date

Worked as a Senior Specialist / Project Manager in Wipro Technologies from Mar 2005 to May 2014

Worked as Consultant – Database Administration in HCL Comnet Ltd, Chennai, India from Mar 2004 to Feb 2005

Worked as Sr. Systems Executive in Telesis Technologies (India) P. Ltd, Chennai, India from Jun 2003 to Mar 2004

Worked as Associate IT Specialist in Net Vision Cybertech Pvt Ltd, Chennai, India from Oct 2002 to Jun 2003

Worked as DBA Consultant in SRM Radiant Infotech, Chennai, India from Jun 2000 to Oct 2002

Worked as Software Engineer in AKS Systems & Solutions, Chennai, India from Apr 1999 to May 2000

Worked as Programmer in Design Centre, Chennai, India from Aug 1997 to Mar 1999 SKILLS / CORE COMPETENCIES

Technical skills

Exadata database machine administration (DMA).

Oracle database administration (Oracle 12c/11g/10g/9i), Migrate to Exadata, Golden Gate, RAC, RMAN, Data Guard and Grid Control, MS SQL Server. Business critical application's database support, implementation and migration activities.

Process management (Methodologies/Tools/Processes), Analysis and feasibility Execution, Deployment review, Technical and process documentation. Review technology integration and IT security policies. Managerial skills

Strategic/operational planning & organizing (Implementation). Operations & delivery (Controlling / Monitoring).

People management (staffing, directing, motivation), incident / problem management. stakeholder, reporting and management information system (MIS). CERTIFICATION

Oracle Cloud Infrastructure Foundations 2020 Certified Associate

Oracle Autonomous Database Cloud 2019 Certified Specialist

Oracle certified professional for database administrator 12c, 10g, 8i (OCP).

Information technology infrastructure library (ITIL) foundation. TRAINING

Oracle database 12c new features for administrators.

Hadoop cluster administration and installation of HortonWorks and Cloudera. EDUCATION

Master of Science in Information Technology, University of Madras, Chennai, India

Bachelor of Science in Computer Science, Bharathiar University, Coimbatore, India

Diploma in Computer Technology, Directorate of Technical Education, Chennai, India VISA

H1B (USA) valid till July-2021

PROFESSIONAL EXPERIENCE

TRIZETTO HEALTHCARE HOSTING OPERATION CENTER: COGNIZANT TECHNOLOGY SOLUTIONS – CO, USA (SEP’2017 – TILL DATE) – DBA CONSULTANT (TEAM SIZE 14) PROJECT DESCRIPTION:

Cognizant hosted their healthcare proprietary products like FACETS, QNXT, QICLINK, Claims Exchange, HIPAA Gateway, Network Pricer and Network PBA for multiple customers on the Hosting Operation Center (HOC). The products and systems are managed by the infrastructure support team.

The database team provides the database support for the products hosted on the Exadata server - x4 and x6, install the Oracle database software binaries, upgrade and migrate the database, convert the pluggable database to standalone and vice versa, apply the patches, upgrade the product using framework, refresh the database across environments, implement the database security standards, deploy the database code on multiple environments, setup the connection manager (cman) and virtual LAN for individual customer, analysis and troubleshoot performance of batch job and perform the monthly maintenance activities on prod and non-prod databases.

• Managed the Oracle databases hosted on the Exadata database machine for various healthcare hosting customers.

• Supported the real application cluster (RAC) databases on the Exadata.

• Applied the quarterly full stack download (QFSD) patch on Exadata server.

• Worked on the Exadata hardware related issue in co-ordination with Oracle support and reboot the Exadata storage cell.

• Setup a table level data replication from Oracle database to Hadoop environment using Golden Gate.

• Install the Golden Gate software (12.x)

• Configure and build Golden Gate Extracts/replicate for multiple databases and performed the initial load.

• Troubleshoot and fix the golden gate replication whenever it get broken.

• Built the physical dataguard database for disaster recovery (DR) environments.

• Created the physical standby database for the disaster recovery testing purpose.

• Performed the disaster recovery test to meet the recovery time objective (RTO) and recovery point objective (RPO) as per the service level agreements.

• Implemented the database security standards for HIPAA and SOX audit compliance.

• Setup the Oracle database connection manager for the customer.

• Convert the pluggable container database to standalone.

• Built and backed up the database for dehosting of customer.

• Performed the RMAN database refresh from prod to the UAT and data masking environments and data masking to non-prod environments.

• Analysis the performance of the database, SQL queries and application batch jobs using grid control/OEM and provided the recommendation.

• Upgraded the healthcare applications and migrated the application frontend and backend users.

• Deployed the database code on multiple environments and fixed the post migration issue.

• Performed the database monthly maintenance for production and non-production environments.

• Apply the database PSU, datapatch and one-off patch.

• Provided the 24x7 oncall database support.

INFO1TECH REFRESH: COGNIZANT TECHNOLOGY SOLUTIONS – CLIENT: JPM CHASE, NJ, USA (MAY’2017 – AUG’2017) – DBA CONSULTANT (TEAM SIZE 4) PROJECT DESCRIPTION:

Info1Tech refresh project is a Time and Material project to break up the application and database layers into a new hardware/datacenter and upgrade the OS to latest AIX version. There are 123 applications are identified as a initial phase on the INFO, BUS, GOLD, PLATINUM and APEX platforms. It also provides the database and application environment support for the projects after the warrant period.

• Data collected for the identified 83 database instance at database and OS level.

• Identified the application modules and owners like application owner, schema owner, information owner.

• Followed up with server build team and validated the installed database component on the server.

• Prepared the resiliency document for the new application and define the RTO.

• Scheduled a maintenance jobs on the Control-M

• Database code deployment for OADS application on Exadata

• Provided the database support for Oracle Application Express (APEX).

• Archive and retire the legacy application’s database components through DMO request.

• Worked with application owner for the isolated backup removal on the backup storage cost optimization.

• Provided the on-call support for VLS to MSP conversion application migration activity. MANAGED DATABASE SERVICES: COGNIZANT TECHNOLOGY SOLUTIONS – CLIENT: HARTFORD INSURANCE, CT, USA (MAY’2014 – APR’2017) – DBA LEAD (TEAM SIZE 30)

PROJECT DESCRIPTION:

The Hartford Insurance project is to provide the Managed Business Model (MBM) support to the customer who takes care of the customer’s business not just the support services. The Managed Database Service (MDS) project is a subset of MBM, provides database support to 14 Lines of Businesses (LOB) which has multiple technologies like Oracle, SQL Server and Mainframe DB2. MDS provides the database administration support as application database and system database administrations.

• Managed 4 LOBs - Billing and Audit (B&A), Commercial Business (BI), Personal Insurance (PI) and Corporate

• Support from project knowledge transition till steady state support including the secondary and primary database supports

• Support application database administration of release and code deployment activities, new project implementation related to infrastructure build and upgrade

• Quarterly database capacity forecast review and request for additional storage

• High Availability Testing for Gold Support applications using DataGuard SwitchOver activities are supported

• Weekly and Bi-Monthly major release implementation across all LOBs

• Supported the application database on Exadata machine

• Database upgrade from 11.2.0.2 to 11.2.0.4

• Migrated the database to 11.2.0.4 to 12.1.0.2

• Performed the database re-organization and purge data as per standards gained 500 GB of storage

• Converted the LOB segment from Basicfile to Securefile and claimed the storage of 100 GB of space

• Database backup and refresh from Prod to non-prod environment using database, schema and table level

• Applied the Quarterly PSU patch on database servers

• Transition new application database support to steady state

• Supported the month-end and year-end activities

• Co-ordinated with application, server and storage teams for major outages

• Automated the activities of partition maintenance and user creation management

• Implemented wallet for long running and batch job execution

• Worked on the Lean Six Sigma project for incidents, alert and work request reduction, achieved 15% reduction in volume

• Worked on DB security remediation like public db links, public grants, non-standard profiles and ANY privileges

• Represent the DCCB and LCAB meeting for the changes planned on the week GLOBAL DATABASE SUPPORT: WIPRO TECHNOLOGIES – CLIENT: MASTERCARD WORLDWIDE, MO, USA (MARCH’2011 – MAY’2014) – ONSITE PROJECT CO- ORDINATOR (TEAM SIZE 53)

• MasterCard Worldwide Data Architecture project provides primary database administration support for critical applications at customer site and round the clock support at offshore.

• Managed end to end ownership for high-value and internal business applications.

• First point of contact for all application's team queries on the database support.

• Perform the spring and fall database contingencies for all critical applications.

• Generate and remediate the database audit compliance issue.

• Plan and schedule the database patchset update (PSU) patches for PCI and non-PCI compliance environments twice in a year.

• Single point of contact for Technical Resolution Team (TRT) call for major business impact applications.

• Maintain the Service Level Agreement (SLA) for Incident response and resolution, change creation and closure.

• Support around 700+ database servers of Single, RAC One and RAC on AIX, Solaris and Linux environments.

• Performed the delivery and onsite project management role and point of contact for database team.

• Prepared the weekly, monthly incident, monthly SLA and monthly reports.

• Review weekend change implementation plan and steps with database team.

• Provided the technical support for Corporate Products (SmartData, GDR, SDOL), SecureCode, BillPay and MasterCard Connect (MCC) critical applications.

• Migrated the databases to Exadata Database Machine

• Applied the Quarterly Full Stack Download (QFSD) On Exadata database machine.

• Managed the Full, Half Quarter Rack databases on Exadata.

• Worked on Exadata CellCLI, DCLI commands

• Installed Oracle RDBMS binaries, ASM and clusterware of Oracle 11g.

• Performed patchset upgraded to 11.2.0.3 on ASM, Oracle RDBMS and Clusterware.

• Created diskgroup, added disks to diskgroups and performed manual rebalance.

• Migrate ASM disks to new SAN array.

• Add a node to the existing RAC and migrated the single instance into RAC database instances.

• Built the physical standby database to setup the contingency environment.

• Setup the DataGuard broker configuration for disaster recovery purpose.

• Performed the switch and failover of database using DG broker during contingency exercise.

• Enabled the contingency databases for reporting purpose using Active DataGuard

• Setup database flashback with read write mode on the contingency site for application DR testing.

• Setup new application environment by duplicate the database.

• Migrate the database from filesystem into ASM instance to same and new server.

• Installed the Golden Gate software, configured and managed the data level replication.

• Implemented the TDE on PCI compliance data and rotated the masterkey on periodic basis.

• Applied the PatchSet Update (PSU) patch on stand-alone, RAC database and ASM instances.

• Performed hardware tech refresh on both Solaris and AIX environments.

• Implemented the application release deployment.

Hadoop Administration:-

• Worked on Hadoop and its ecosystem (Hive, Pig, Sqoop, HBase,)

• Installing, administering and monitoring Hadoop multi-cluster.

• Setup a POC environment for banking project on Hadoop platform. LLOYDS TSB & HBOS INTEGRATION SUPPORT: WIPRO TECHNOLOGIES – CLIENT: LLOYDS TSB, LONDON, UK (APRIL’2009 – FEBRUARY’2011) – ONSITE CO- ORDINATOR (TEAM SIZE 40)

• Handled Lloyds TSB & HBOS integration projects.

• Provided end to end database provisioning to the business critical applications.

• Migrated SQL server application database into Oracle.

• Single point of contact and support for payment databases & application team.

• Refresh the UAT database environments for Non-Functional Testing purpose.

• Replicated and fix the PL/SQL code and DB infrastructure issues.

• Performed the DR test, live cutover and warranty support for application databases.

• Setup and configure Golden Gate to migrate/upgrade the databases.

• Managed the Central function application projects and team.

• Attended the project workshop, gathered requirements, effort estimation and managed it with resources.

• Installed Oracle 10g, 11g software binaries.

• Created databases with ASM and FRA in Oracle clusterware, HACMP and standalone environments (RAC, Non-RAC).

• Copy the database from production into other environments.

• Configure the log maintenance, database backup & recover it on application team request.

• Install the Oracle Agent and register the databases with Grid control.

• Managed the Oracle clusterware and database services.

• Upgraded the database from 9i to 10g.

• Deployed the application database code in the pre-prod & production environments. GMACI SUSTAIN DB SUPPORT: WIPRO TECHNOLOGIES – CLIENT: GMAC INSURANCE, MO, USA (JANUARY’2008 – MARCH’2009) – TECHNICAL LEAD (TEAM SIZE 8)

• Provide 24x7 infrastructure support for GMACI insurance applications like CTS, EPIC, PMS and eAgency for Oracle and SQL server environments.

• Handled 200 Oracle databases contains production, UAT, SIT and development database instances.

• Provided remote support for US client in 24x7 environments.

• Deployed application's major and minor releases in all database environments.

• Migrated OEM 10g Grid control to 10.2.0.4 from 10.2.0.2

• Implemented SIEBEL 7.4 repository migration to production server.

• Configured 10g Dataguard, Logical standby for dataware house reporting environments.

• Upgraded the database server to 10.2.0.2 from 9.2.0.7

• Extracted database objects from data model diagram using ER-WIN tools.

• Refresh database, schemas across environments.

• Backup and recovery done through RMAN using TSM.

• Re-Organized the database objects.

• Applied the quarterly critical security patches on all Oracle database servers.

• Peregrine used for ITIL processes of Incident and Change Management.

• TOAD used for development, extract database object structure purpose.

• Provided a secondary support for SQL Server environments having 130 instances.

• Upgraded the service Pack 4 to SQL server 2000.

TUI INFOTEC DATABASE SUPPORT: WIPRO TECHNOLOGIES – CLIENT: TUI INFOTEC GMBH, HANNOVER, GERMANY (JULY’2005 – NOVEMBER’2007) – TECHNICAL LEAD

(TEAM SIZE 22)

• Managing the offshore team of 22 members

• Managing around 180 databases running in production, development and test server on UNIX servers

• Successfully completed the knowledge acquisition phase (KAP) from onsite team and supporting from offshore

• Providing remote support for Europe (Germany & UK) client in 24x7 environment

• Installing oracle enterprise software on UNIX servers

• Migrate the database from 8.1.7.4 to 9.2.0.7, 9.2.0.8, 10.2.0.3

• Offline copy of 8i to 10g databases

• Apply patchset 9.2.0.8 under the 9.2.x version and back port through OPatch

• Creation of databases, Schemas and tables on request

• Clone or Duplicate of databases using RMAN Clone the 11i apps applications

• Backup and recovery database with Oracle RMAN

• Cooperation and assistance with software vendor (Oracle support) in case of 3rd level issue

• Recovery of databases, tablespaces, schemas and tables on request

• Ensure the performance and availability of databases

• Analyze the performance of database using STATSPACK report

• Create, modify and delete backup jobs

• Creation, modify and delete expired user accounts on request

• Detection and analysis of failures and solving database issues

• Implementation of database deployment in production and development databases

• ILTIS ticketing system are used to track the incidents, problems and changes in the database servers

WAMU DATABASE TRANSITION SUPPORT: WIPRO TECHNOLOGIES – CLIENT: WASHINGTON MUTUAL, WA, USA (MARCH’2005 – JULY’2005) – TRANSITION DBA

(TEAM SIZE 6)

• Understand and Review the Statement of Work (SOW), roles and responsibilities of project deliverables

• Prepared the System Maintenance Technical Document (SMTD), Execution Process Document (EPD) documents

• Captured the environment details for around 250 databases of all environments

• Review and signed off the SMTD and EPD documents with customer

• Successfully completed the knowledge acquisition phase (KAP) from onsite team

• Provided the secondary shadow support and capture the implementation tasks and ticket activities

• Successfully completed the primary shadow supports

• Prepared the technical document for all major application and critical activities

• Regular interaction with onsite team for technical and process knowledge sharing

• Created the standard operating procedures (SOP) documentation for the Oracle database server

• Transition the database support to database delivery team AIG DB SUPPORT: HCL COMNET LTD – CLIENT: AMERICAN INTERNATIONAL GROUP

(AIG), USA (MARCH’2004 – FEBRUARY’2005) – SUPPORT DBA (TEAM SIZE 10)

• Providing remote support for US client in 24x7 environment

• Supporting production, development and test server running on Sun Solaris and Windows operating systems

• Maintained Oracle database servers running on different version 8.1.6 to 9.2.0.5

• Installation and configuration of oracle enterprises software in Sun Solaris and Windows machine

• Clone the database from production to development

• Monitoring and administering oracle database

• Activities are handled using Peregrine and Remedy ticketing systems

• Applying patches for fixing the security vulnerabilities in Oracle server GE DATACENTER SUPPORT: TELESIS TECHNOLOGIES LTD – CLIENT: GE COUNTRYWIDE, CHENNAI, INDIA (JUNE’2003 – FEBRUARY’2004) – DBA (TEAM SIZE 6)

• Installation and configuration of oracle enterprises software in AIX machine

• Administering oracle database running on AIX machine to support oracle server

• Creation and maintenance of database

• Perform logical and physical design of the database in consultation with the application teams

• Supported the OPS environments on HACMP in AIX

• Applying patches to upgrade oracle 8.1.7 to 8.1.7.2, 8.1.7.4 in AIX machine Contacting Oracle support team for technical support

• Establish and maintain sound backup and recovery policies and procedures Perform the physical (online and offline) and logical backups

• Maintaining backup and archived data on tapes

• Use STATSPACK reports for performance tuning

• Perform database, query tuning and performance monitoring

• Propose, Plan and carryout performance improvement actions such as reorganizing database/ defragmentation / optimize in efficient SQL statements for the database on need basis

• Implement and maintain database security (create and maintain users, roles and privs.)

• Handling day to day activities

• Writing UNIX shell scripting, SQL, PLSQL stored procedure for database administration and applications requirements

DATACENTER MANAGEMENT: NET VISION CYBERTECH PVT LTD (OCTOBER’2002 – JUNE’2003) – DBA (TEAM SIZE 12)

• Administering oracle database running on sun Solaris machine to support oracle database server

• Creation of database, table space, schema objects

• Configuration and maintenance of STANDBY database

• Cloning of database from production to test

• Backup and recovery

• Write export/import scripts to export/import full database, schema and tables

• Handling day-to-day database activities

• Define backup procedures for daily hot backups and weekly cold backups

• Monitoring growth of tables and undertaking necessary reorganization of database when required

• Analyzed SQL using explain plan and TKPROF

Contact this candidate