Manager Oracle
Resume:
RAJ KUMAR
Mobile: +91-974**-*****
E-Mail: adapk4@r.postjobfree.com Skype ID: adapk4@r.postjobfree.com
Objective: To work on senior role.
Accomplishments:
Formal Graduation:
MASTER OF COMMERCE from Madurai Kamaraj University.
Visa:
Holding Multiple Entry Business visa till 16-Aug-2025
Certifications:
Certified on Prince2 Foundation & Prince2 registered Practitioner.
Completed ITIL V3 Foundation Certification
Oracle Database Administrator Certified Professional(OCP)
Oracle Database Administration Associate(OCA)
Completed Training on CISSP, CompTia Security+ Certified Professional
Completed MCSE, MCSA, MCP
Completed RHCE Training.
Higher Diploma in Software Engineering from Aptech Computer Education.
Awards and Achievements:
Awarded as Passionate entrepreneur in UST
Trained and handled implementation of Cloud Technology with Hadoop
Organizations Associated:
Organization
Designation
Period
Job Profile
International Flavors & Fragrances India Pvt Ltd
SAP Oracle Database Administrator
Mar 17 to Current
Building and migration of resources.
Galaxe Solutions
Senior Architect
June 15 to Sep 16
Building solutions as per the customer needs.
Ust Global
Consultant
Feb 11 to Nov 14
Worked as Senior Oracle DBA.
Sybase India Private Limited
Consultant
May 08 to Feb 11
Worked as Senior Database Administrator through vendor Softanger
HCL Comnet Systems & Services Limited
Consultant Systems
Nov 06 to Oct 07
Worked as Oracle Database Administrator for the client in IKEA, Sweden Project.
Cybernet Software India Pvt Limited and SlashSupport India Private Limited (Group of CSS) (Group of CSS)
Team Manager
Jan 06 to Nov 06
Worked on the Oracle Database Level support and handled related on-calls
Working as Oracle Database Administrator for the Remote Management team for Client Navic.
McAfee Software India Private Limited
Tier 3 - Field Support Engineer
Dec 04 to Jan 06
Managing Tier 1 and 2 team. Handled ePolicy Orchestrator and product issues.
CORE SKILL SET:
Database
Oracle 7.x/8.x/8i/9i/10g/11g/12c/18c [under Windows/IBM Aix/ Sun Solaris Unix/Redhat Linux and other Linux flavors], Working on Oracle 10g, Oracle Enterprise Manager (OEM grid), Oracle Cluster ready service (RAC). Oracle Application server, Data guard, ASM, Streams, replication, Data Mining, SQL, PL/SQL, XML, HTML, Java, Tuning techniques, backup and recovery, Oracle Golden Gate. Exadata.
AWS
AWS Aurora, AWS Postgress, AWS SQL Server, AWS Oracle
Distributed Database including Cloud solution
Hadoop CDH5, HBase, NoSQL Database, Cassandra, MongoDB, Datastax, Flume, Sqoop, Hive, Data warehouse & data mining.
Enterprise Applications
Oracle ERP 12.x (OM, MF, AR, AP) Oracle 11.5.8 and Oracle 11.0.3
Tools Used
Toad for Oracle, Toad DBA suite for Oracle, SQL Navigator, Rapid SQL, Foglight for Oracle, Spotlight for Oracle, PL/SQL Developer and DBArtisian, SQL Backtrack, TSM backups/restore, BRTools for SAP Migration
Methodologies
Database Architecture, Data Modelling, Database Design, Structured System Analysis and Design, Object Oriented Analysis and Design, Software Engineering Principles, Software Project Management
Other databases
SQL Server 2000/2008/2012/2018s, MS-Access, Sybase ASE,
ETL Tools
DataStage, SSIS
Other Tools
Microsoft Office 97/98/2000/XP/2003/2007 Backup and Storage devices, Managing McAfee ePolicy Orchestrator, Management of corporate Antivirus Solutions, Virtualization, SAN Storage solutions, XML
EXPERIENCE IN DETAIL:
A.International Flavors & Fragrances India Private Limited.
Architect the solution from SAP, Oracle, SQL Server to AWS Cloud as per each product line requirements.
Use Jenkins package to migrate from the source code
Periodically refresh and migrations from Production, QAS, DEV and vice versa
Security review for the SOX compliance.
Periodical code review and deployment using talend, ETL management
Scrum activity to ensure the application and data center move is successful.
Managed team for the migration activities.
B.Galaxe Solutions, Bangalore
Architect the solution and advice developers to adhere as per the standards
Understand client requirement, work with various stake holders and address client requirements
Liaise between various stake holders to implement acceptable solutions.
Provide solutions in the PBM sector for the US customers.
Develop standards, guidelines, best practices, validate and sign the architectural documents.
This role not limited to Techno-managerial and technology not limited to products, database & security compliance.
Groom the client needs at functional and cross functional needs
Worked on various tools not limited to BR Tools for the Instance Management, Space management, Segment Management, Database Backup, Database Check, Update Statistics.
C.UST Global
Client : Wellpoint
Backend : Oracle 8i, 9i, 10g, 11g, Oracle RAC, OEM
Relevant Technologies learned and used: BMC SQL backtrack
Platform : Solaris 10, Linux, Aix, windows
Tools Used : Toad, Putty, IBM TSRM.
Worked on On-duty Production support includes logical and physical design recommendation.
Successfully patched multiple databases include complex patching.
Provide RCA’s for maintain high availability.
Worked on Oracle RAC, Oracle Streams, DR, Standby database, ASM, Cluster ready service installation, administration, maintenance and configuration.
Cleared most of the backup issues and addressed the root cause of the providing not repetitive solutions.
Manage Users, passwords, authentication, roles/privileges and profiles including design and implementation.
Recommendation to end users for the design, upgrade recommendation, design of data logical models to application team.
Check Alert/Listener log files for possible oracle/listener errors. Periodic reporting of issues detected and remedies performed
Startup/Shutdown and recovery of databases scheduled and executed for the change management.
Perform tasks related to Space management not limited to capacity planning of tablespace and file system capacity planning.
Refreshed database using network link and using sql backtrack.
Minimized number of customer issues and incidents over a period and received highest number of appreciations.
D.SYBASE SOFTWARE INDIA PRIVATE LIMITED
Client : State Street
Backend : Oracle 8i, 9i, 10g, 11g, Oracle RAC.
Relevant Technologies learned and used: Oracle Golden Gate, VERITAS Cluster
Platform : Solaris 10, Linux
Tools Used : Remedy, Clear case, Clear Quest, Rapid SQL, DBArtisian
Team : 14 persons
Managed oracle 8i/9i/10g and 11g database and upgrade to the latest version as per the standards. And migration to RAC environment
Manage Users, passwords, authentication, roles/privileges and profiles
Check Alert/Listener log files for possible oracle/listener errors. Periodic reporting of issues detected and remedies performed
Startup/Shutdown and recovery of databases scheduled and executed
Perform tasks related to Space management includes handling issue with RBS Configuration or temporary segments, if required. Ensuring accuracy and completeness of data in master files and various support tools, such as base dictionaries.
Handle user request and Handling scheduled downtimes
Changing priority or Killing unwanted sessions (sniping) that takes the resource
Hands-on knowledge of PL/SQL programming. Database link creation
Clone database(s) for different databases for Development testing purposes
Interface with Oracle Corporation for technical Support
Performing routine tasks involving gathering statistics using Stats Pack and AWR Report. Performance monitoring and periodic Database health checks and report findings
Instance & database size management & proactive growth analysis
Planning computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection.
Establishing and maintaining security and integrity controls.
Perform routine DB audits to ensure compliance with established security and integrity controls.
Proposing and implementing enhancements that will improve the performance and reliability of the system. Should formulate and monitor policies, procedures and standards relating to database management.
Augment work with crisp documentation of DB configuration, ongoing changes.
Perform database failover in Primary and secondary database in EMC Storage with VERITAS cluster.
Formulated procedures, standards and monitoring of scripts in Oracle to ensure reliability of the Oracle Database.
Pro-actively forecast the space issue to different stakeholders.
E.HCL Comnet System & Software Limited
Client : IKEA, Sweden
Backend : Oracle 8i, 9i, 10g
Platform : Redhat Linux 3, 4, AIX
Tools Used : HP Service Desk, Microsoft Visio
Team : 35 persons
Online analysis of slow running programs.
Interface with Oracle Corporation for technical Support
Conversant with security related issues.
Performing routine tasks involving gathering statistics using Stats Pack. Performance monitoring and periodic Database health checks and report findings
Instance & database size management & proactive growth analysis
Planning computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection.
Ensuring accuracy and completeness of data in master files and various support tools, such as base dictionaries.
Establishing and maintaining security and integrity controls.
Perform routine DB audits to ensure compliance with established security and integrity controls.
Proposing and implementing enhancements that will improve the performance and reliability of the system
Should formulate and monitor policies, procedures and standards relating to database management.
Periodically testing of backup, recovery strategies. .
Migration of applications from legacy Oracle systems to latest Oracle Versions as per client requirement. Implemented RAC in Oracle 10g.
Performing both Physical and Logical backups. Carry out logical backups using export and import utilities.
F.CYBERNET SOFTWARE INDIA PRIVATE LIMITED
Client : Scope International, India
Backend : Oracle 8i, 9i, 10g, DB2
Platform : Redhat Linux 3, 4, AIX, Solaris
Tools Used : Microsoft Project
Team : 30 persons
Performing routine tasks involving gathering statistics using Stats Pack. Performance monitoring and periodic Database health checks and report findings
Instance & database size management & proactive growth analysis
Planning computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection.
Establishing and maintaining security and integrity controls.
Perform routine DB audits to ensure compliance with established security and integrity controls.
Proposing and implementing enhancements that will improve the performance and reliability of the system.
Should formulate and monitor policies, procedures and standards relating to database management.
Worked on 24x7 Rotation calls.
Manage space management.
G.SLASHSUPPORT INDIA PRIVATE LIMITED
Client : Navic Networks, United States
Backend : Oracle 9i
Platform : Redhat Linux 3.
Tools Used : Toad, Oracle Enterprise Manager, Sales force Ticket System
Working as Database Administration for the client.
Performance tuning in Queries and procedures.
Remote administration of 15-production server including Linux based clustered servers.
Participated in on call rotation.
Operating on 24x7 with client. Administration and creation of installation scripts for the customized schema.
Backup and recovery using export and import of schema using par files.
Design and development of the custom database for Navic.
Reporting to the client as per the standard process.
Completed the successful delivery of the Project and hence promoted as Project
H.MCAFEE SOFTWARE INDIA PRIVATE LIMITED
Currently providing level 3 support in the McAfee ePolicy Orchestrator product which users SQL Server as Back end.
This product is centralized management of all McAfee products.
Visit customer site to provide solution as required due to severity of the issues.
Interact with development and quality assurance team to inform the defects in the product.
Follow up with development team on the bug to get the solution and communicate to the customer.
Provide hot fix as required.
Create articles in the McAfee knowledge base for the customers and internal teams.
Provide solutions and ensure the customer satisfaction as per the Management criteria.
Conduct trainings for Tier 1 and Tier 2 in the McAfee ePolicy Orchestrator.
Managing Tier 3 software and hardware requirements, and escalate to the appropriate teams.
Direct escalations taken from Tier 2 and the Enterprise Customer support representative.
Contact this candidate