DilipKumar Patel
Core Platform Lead at Cintra Software and Services- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Hindi -
Topline Score
Bio
Vivek Shukla
I have worked with Dilip at Xchanging and have known him for nearly 5 years now. During my experience of working with Dilip I have found him very knwoledgable, hard working and easy to get on with. He has an excellent knowledge of Oracle databases in high availability envionment. He is knowledgeable and is always studying for the next technology. He is an absolute pleasure to wrok with.
Anjum Shehzad
I had the pleasure to work with Dilip Kumar when he was in Xchanging. All my implementations were sent to him to scrutinize them to make sure they comply with Xchanging Database Management Standards. I always found him very knowledgeable and precise. With diverse database versions and sizes (both Core and EBS) amounting to more than 150 across Xchanging, Dilip had been winner of XTS Senior Management Team awards for effective management of the databases. He is very good in handling Core DB functionalities, Performance Tuning, Partitioning, EBS Cloning/Patching, RMAN & ASM alike. I wish him success in his future endeavours.
Vivek Shukla
I have worked with Dilip at Xchanging and have known him for nearly 5 years now. During my experience of working with Dilip I have found him very knwoledgable, hard working and easy to get on with. He has an excellent knowledge of Oracle databases in high availability envionment. He is knowledgeable and is always studying for the next technology. He is an absolute pleasure to wrok with.
Anjum Shehzad
I had the pleasure to work with Dilip Kumar when he was in Xchanging. All my implementations were sent to him to scrutinize them to make sure they comply with Xchanging Database Management Standards. I always found him very knowledgeable and precise. With diverse database versions and sizes (both Core and EBS) amounting to more than 150 across Xchanging, Dilip had been winner of XTS Senior Management Team awards for effective management of the databases. He is very good in handling Core DB functionalities, Performance Tuning, Partitioning, EBS Cloning/Patching, RMAN & ASM alike. I wish him success in his future endeavours.
Vivek Shukla
I have worked with Dilip at Xchanging and have known him for nearly 5 years now. During my experience of working with Dilip I have found him very knwoledgable, hard working and easy to get on with. He has an excellent knowledge of Oracle databases in high availability envionment. He is knowledgeable and is always studying for the next technology. He is an absolute pleasure to wrok with.
Anjum Shehzad
I had the pleasure to work with Dilip Kumar when he was in Xchanging. All my implementations were sent to him to scrutinize them to make sure they comply with Xchanging Database Management Standards. I always found him very knowledgeable and precise. With diverse database versions and sizes (both Core and EBS) amounting to more than 150 across Xchanging, Dilip had been winner of XTS Senior Management Team awards for effective management of the databases. He is very good in handling Core DB functionalities, Performance Tuning, Partitioning, EBS Cloning/Patching, RMAN & ASM alike. I wish him success in his future endeavours.
Vivek Shukla
I have worked with Dilip at Xchanging and have known him for nearly 5 years now. During my experience of working with Dilip I have found him very knwoledgable, hard working and easy to get on with. He has an excellent knowledge of Oracle databases in high availability envionment. He is knowledgeable and is always studying for the next technology. He is an absolute pleasure to wrok with.
Anjum Shehzad
I had the pleasure to work with Dilip Kumar when he was in Xchanging. All my implementations were sent to him to scrutinize them to make sure they comply with Xchanging Database Management Standards. I always found him very knowledgeable and precise. With diverse database versions and sizes (both Core and EBS) amounting to more than 150 across Xchanging, Dilip had been winner of XTS Senior Management Team awards for effective management of the databases. He is very good in handling Core DB functionalities, Performance Tuning, Partitioning, EBS Cloning/Patching, RMAN & ASM alike. I wish him success in his future endeavours.
Credentials
-
Oracle Cloud Infrastructure 2018 Architect Associate
OracleJan, 2019- Nov, 2024 -
Oracle Cloud Infrastructure 2019 Certified Architect Professional
OracleAug, 2020- Nov, 2024 -
Oracle Autonomous Database Cloud 2019 Certified Specialist
OracleJul, 2020- Nov, 2024 -
ITIL V3 Foundation Certificate in IT Service Management
ISEB -
OCP - Oracle 8i Certified Database Administrator
Oracle Corporation
Experience
-
Cintra: The Multi-Cloud Database Architects
-
United States
-
IT Services and IT Consulting
-
100 - 200 Employee
-
Core Platform Lead
-
Feb 2022 - Present
Managing Database and Middleware platform team,Oracle EBS & Middleware Architect.Production support for very large Oracle E-Business system with more than 250K users.Oracle EBS on Oracle Cloud Infrastructure, Migration from On-Premises to Oracle Cloud.Managing Oracle Exadata Cloud service, DBaaS and IaaS.Oracle Cloud Infrastructure planning for EBS, Middleware and SSO. Oracle Cloud Data Security using TDE and Database Vault.Planning VCN, Subnets, security lists for database and application secure communications.Manage customer relationship and global team. Oracle Cloud Infrastructure, database cloud migration. Lift and Shift Oracle EBS Projects.Oracle Cloud Exadata Cloud service,
-
-
Sr. Oracle DBA
-
Nov 2016 - Jan 2022
Managed services and Projects. Manage customer relationship and global team. 24*7 Oracle production support.Oracle Cloud Infrastructure, database cloud migration.Oracle EBS Lift and Shift projects.Review and documentation of existing Database and Middleware infrastructure and improvement based on best practices. IT Service management, monitoring incidents and SLA,Oracle Fusion Middleware, Weblogic (11g, 12c)Oracle RAC (12c, 11g) install, troubleshooting and upgrade.Build and maintain Oracle Data Guard.Oracle APPS DBA (12.2, 12.1.3) support and upgrade.Oracle Engineered Systems support: Exadata, ODAShell script development for monitoring entire Oracle EBS application tier.
-
-
-
Affinity Water
-
United Kingdom
-
Utilities
-
700 & Above Employee
-
Database Analyst
-
Oct 2015 - Nov 2016
Database Analyst at Affinity WaterOracle DBA, Oracle APPS DBA, Oracle Fusion Middleware support.Manage Oracle E-Business, Clone, Patches, Concurrent manager, ensure performance level of Oracle E-Business, maintain security, backup and recovery.Managing Oracle Fusion Middleware, responsible for critical integration between various systems. Maintain SLA to ensure customer self-serve portal website for managing billing, payment and meter reading.Troubleshooting SOA, OSB, JMS , XML.JVM tuning for Weblogic 12c managed servers, Middleware performance tuning, Weblogic patches and maintenance.
-
-
-
-
Consultant DBA
-
Dec 2012 - Oct 2015
Sr. Oracle DBA Managed services.Production support DBA, Single point of contact for some of the biggest Red Stack Tech customers.Manage Level 3 customer incidents, root cause analysis, suggesting long term solutions for complex problems. Oracle DBA support for customer systems version 12c (With Pluggable database), 11g and 10g. Oracle RAC (12c and 11g), Oracle Data Guard, RMAN backup and recovery, Performance tuning, Database security, Auditing and Database vault. Database replication using Oracle Streams and Oracle GoldenGate. Oracle backup and recovery using RMAN, build DR systems, Clone databases, automated RMAN refresh solutions, constant review of backup and DR solutions for customer systems. Export/Import datapump, Performance tuning for large production database systems, using AWR, Statspack, Query tuning, regular review of the production database performance. Upgrade and migrations from 10g to 11g/12c for database and Oracle RAC. Oracle EBS installation, APPS Tier Configuration, SSL, Load Balancing, Multi Node, EBS Patches and General APPS DBA support. Oracle Internet application server, Oracle Weblogic (12c, 11g), Oracle Discoverer, OID and Oracle Fusion Middleware products. Understanding customer database infrastructure, technologies, problems, technical documentation of customer databases, establishing remote support for customer databases, incident management and change management of customer. Communication with Red Stack Tech customer managers, technical leads and ensure the contract Service levels are being maintained by team members.Provide technical solutions for customer Oracle database systems, production support, 24*7 support and on-call support. Reporting customer management about performance of their database infrastructures, summary of incidents. Improvement suggestions, space growth estimates, proactive support and manage customer expectations.
-
-
-
Sopra Steria
-
France
-
IT Services and IT Consulting
-
700 & Above Employee
-
Senior Technical Specialist
-
Jun 2012 - Nov 2012
• Oracle DBA for various banking customers, managing mortgage application and databases.• 24*7 Support for critical databases, working in shifts and supporting on-call.• Oracle Database performance tuning, Statspack, AWR and Query tuning using SQL Trace, Explain plan and Trace.• High availability setup using Oracle Data Guard, Setup DR testes and document business continuity procedures.• Oracle Development using PL/SQL (Packages, Procedures, Functions and Triggers).• Solaris/UNIX administration, user management and UNIX Shell scripts.• Manage Security for database (SOX Compliance).• Set up Backup using Recovery Manager (RMAN) configuration, backup scripts, clones and recovery testing.
-
-
-
iTrain
-
United Kingdom
-
Information Technology & Services
-
1 - 100 Employee
-
Technical Consultant
-
Nov 2011 - Jun 2012
Databases and Applications: Oracle 11g, Oracle 10g, Oracle E-Business Suite R12 on Linux.Tools: SQL*PLUS, AD utilities, EXPDP/IMPDP, AWR, ADDM, Oracle Data Guard, RAC, RMAN, Weblogic, Discoverer, OCCG (Configuration Controls Governor) and Oracle Grid Control.Responsibilities:• Oracle APPS DBA for Northern Powergrid and AHI Carrier projects.• Oracle database installation, EBS installation, Patching and APPS DBA support.• Data migration from R11 to R12. (EXPDP/IMPDP)• Oracle EBS Upgrade from R11 (11.5.10) to R12 (12.1.3).• Installation of OCCG, Discoverer and Weblogic 11.• High availability setup using Oracle RAC and Data Guard.• Managing Oracle development and test environments, Installation and cloning.• Oracle 11g database administration.
-
-
-
Hewlett Packard Enterprise
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Oracle DBA / Oracle Retail DBA Consultant
-
Sep 2011 - Sep 2011
Databases and Applications: Oracle 11g, Oracle Retail R13 on UNIX/Linux.Tools: SQL*Plus.Duration: 01-Sep-2011 to 30-Sep-2011Description: Oracle retail R13 implementation support for AHOLD, Netherlands.Responsibilities:• Oracle 11g DBA, Oracle Retail DBA.• Installation and troubleshooting of Retail applications like RMS, RPM, SIM, RSL, RDW, ALLOC and RIB.• Managing Oracle development and test environments, Installation and cloning.• Oracle 11g database administration.
-
-
-
CSC UKI
-
United Kingdom
-
Outsourcing and Offshoring Consulting
-
700 & Above Employee
-
Oracle DBA
-
Oct 2008 - Aug 2011
Databases: Oracle 11g, 10g, 9iProduction DBA support for Insurance Market Repository (IMR): IMR is a document management system to enable the electronic distribution. Managing total more than 100 Oracle databases spanning across four data centers.Production DBA support for LME (London Metal Exchange) for huge transactions trading systems. Managing production and development databases.Development DBA support, understand business processes, data modeling, relational database modeling, communication with business analysts and stakeholders, managing large data warehouse databases, supporting ETL activities, ETL strategy, PL/SQL scripts, Deployment and testing, benchmarking database performance, Partition strategy for data warehouses and OLTP systems, manage large volume tables on Oracle 11g database, managed larger than 1 TB database. Oracle Database replication using Oracle Streams and CDC (Change data capture), Oracle Advanced Queuing (AQ).Installation of Oracle 11g R2 RAC, 10g R2 RAC and high availability setup using Oracle Data Guard. Storage management for Oracle 11g, 10g, 9i, 8i databases, Oracle ASM, maintain Tablespace below warning levels. Storage estimation and planning for future growth of databaseManaging Oracle E-Business suite (11 and 12) for Oracle Financials and HRMS, Cloning, Patching and troubleshooting. Implementation of R12 and Upgrade R11 to R12, Oracle Discoverer 10g, Oracle portal and SSO using OID (Oracle Internet Directory). Installation of web servers like Apache and Oracle application servers.Performance tuning for OLTP and Data warehousing systems using Explain Plan, AWR, SQL Trace and self written SQL scripts and utilities.Backup/Recovery using RMAN. Backup scripts and database recovery and clones.OEM Grid control, monitoring and alerts setup for Oracle estate.Databases patches and upgrades. Upgrades from Oracle 8i, 9i, 10g to 11g. MySQL installation, administration, security, backup/recovery, replication.
-
-
-
Tesco
-
United Kingdom
-
Retail
-
700 & Above Employee
-
Oracle DBA Consultant (Mahindra Satyam employee)
-
2007 - 2008
Databases: Oracle 10g RAC, 10g, 9i, 8i on IBM AIX, Solaris, Linux.Tools: SQL*Plus, Oracle 10g Grid Control, AWR, ADDM, RMAN, Data guard, Partitioning, Flashback database, UNIX Shell scripts.Application: Oracle RETEK 12.0.2, 12.0.5.Employer: Satyam Computer Services Limited.Description: Production support for TESCO’s business critical database for procurement, stock, product maintenance, Development support for Oracle RETEK application.Responsibilities:Oracle DBA Team leader for Satyam DBA Team, Oracle Retail and Development DBA.Manage Oracle databases, availability monitoring, space management, network configuration, application connectivity, security setup and general troubleshooting.Data warehousing and ETL support, development of batch scripts, largest database supported with 5 Terabytes.Partitioning strategy and large data migration for Oracle Retail.Managing Oracle RETEK production and development environments, Installation and cloning.Installation of Oracle 10g R2 RAC with ASM.Oracle RETEK batch process tuning and partitioning policy, customization and integration with legacy.Installation of Oracle Retek and general administration (RMS, RPM, RIB, RETL, Retail Batch).Database performance tuning using AWR, SQL Trace and Explain plan.UNIX Shell scripting and basic UNIX administration.Oracle Data guard setup, Backup/Recovery strategy using RMAN.
-
-
-
Tech Mahindra
-
IT Services and IT Consulting
-
700 & Above Employee
-
Oracle DBA team lead for GE Consumer Finance Americas / GE Money Global
-
Apr 2004 - Sep 2007
: GECF-Americas, a division of General Electric Consumer Finance, based in Stamford, Connecticut, is a leader in providing credit services to retailers, consumers, and manufacturers across the United States and Canada. GECF-Americas utilizes two separate hosting facilities to support its data warehouses, which contain demographic, account, billing, historical transaction, HR, operations, collections, and financial ledger data. Data is fed into these data warehouses periodically from multiple data sources, including GECF-Americas legacy transaction systems, First Data Resources transaction systems, GECF-Americas call center monitoring systems, GECF-Americas HR system, GECF-Americas Collections dialers, and GECF-Americas General Ledger system.Major functions of these data warehouses are: (1) to provide users with easy access to the required data, (2) to support modeling and analysis by the analysts and (3) to support the creation of performance management reporting. Leading team of Development DBA, the team is responsible for all DBA activities. • Architecture of data warehouse. • Managing Oracle 10g software and database instances. • Understanding logical data model of the emerging data warehouse. • Develop Physical data model, design partitioning strategy for the target tables. • Participation in forming ETL architecture for better database performance.• Design of I/O subsystem and capacity planning.• Security requirements: Planning of the roles and access methods for ETL, End users and Reporting tools for DWH Target tables. • Masking of confidential columns/tables from the general users and providing access to only selected users. • Backup and recovery, planning backup/recovery strategy for the DWH. • Designing strategy for loading history data to data warehouse.
-
-
-
Atul Ltd
-
India
-
Chemical Manufacturing
-
700 & Above Employee
-
Asst. Manager
-
Nov 2000 - Mar 2004
Oracle Database AdministratorOracle DevelopmentUNIX Administration Oracle Database AdministratorOracle DevelopmentUNIX Administration
-
-
-
Bhrigus
-
Software Development
-
1 - 100 Employee
-
Database Administrator
-
2004 - 2004
Oracle Database Administration.Performance tuning. Oracle Database Administration.Performance tuning.
-
-
-
-
Programmer
-
Feb 1999 - Nov 2000
Oracle Database AdministrationOracle Development using PL/SQL, Oracle Forms and Reports.UNIX Administration Oracle Database AdministrationOracle Development using PL/SQL, Oracle Forms and Reports.UNIX Administration
-
-
-
-
System Analyst
-
1995 - 1999
Oracle Development using PL/SQL, Forms, SQL and UNIX Shell scripts.UNIX Administration. Oracle Development using PL/SQL, Forms, SQL and UNIX Shell scripts.UNIX Administration.
-
-
Education
-
1992 - 1995
South Gujarat University
MCA, Computer Applications -
1987 - 1991
South Gujarat University
B.Sc., Maths, Physics
Community
