Name: Prakash S Patel
Current Location: Bangalore
Profile Summary:
Total Years of Experience: 15+ Years
Companies worked for: Wipro, IBM, Cognizant, DXC
Why is he your right choice?
Category Skills
Database Management SQL Server, T-SQL, SSMS, PostgreSQL, pSQL, PGAdmin,
Systems MySQL, MySQL Workbench, SQLite3, Oracle Database,
SQL*Plus, Oracle SQL Developer, Oracle Enterprise
Manager, MySQL Connector, psycopg2
Database Administration SQL Server Security, Backup & Recovery, Performance
Tuning, High Availability, Replication, SSIS, RMAN, AWR,
ADDM, Data Guard, Exadata, Hadoop Admin, Audit Vault
and Database firewall, Veridata, IBM CDC
Data Replication Replication, Streaming Replication, Logical Replication,
Master-Slave Replication, Group Replication
Programming Languages Python, OOP, SQL, HTML, HTML5, PHP
Operating Systems Windows Server 2003/07/11, Unix, Linux, AIX, Sun
Solaris
Graph Databases & NoSQL Neo4j, Graph Modelling, Data Import, MongoDB
Java Integration Java Integration, Quarkus, Neo4j OGM
Tools Secure IT, E helpline, BIRT, Event Grid, Pragathi, SIP,
IPROMPT, GYAN
Recent trainings delivered on SQL:
Training Name Month & Year Client Names Audience
MSSQL & NoSQL Sep – 2024 Capgemini System Admin (3-6 years)
MySQL June – 2024 HCL Entry Level Professional
MSSQL Admin May – 2024 Accenture Database Administrators
(3-6 years)
Graph DB May – 2024 Capgemini Data Analysts (2-4 years)
MySQL April – 2024 Accenture System Admin (3-6 years)
Certifications:
• OCA & OCI Certified in the Domain of Oracle Database Management.
Work Experience:
Organization: WIPRO
Role: Oracle Database Administrator
Responsibilities:
• Managed and optimized Oracle and MySQL databases, including performance
tuning, schema design, and regular maintenance tasks.
• Implemented security protocols and access controls, ensuring compliance with
organizational policies, and leveraging Oracle architecture knowledge.
• Coordinated with cross-functional teams and third-party vendors for issue
resolution, utilizing Oracle, MySQL, and Postgres expertise.
• Automated routine database tasks using Python scripts, improving operational
efficiency, and minimizing manual efforts.
Organization: IBM
Role: Subject Matter Expert
Responsibilities:
• Provided subject matter expertise in Oracle and MS SQL Admin for projects in the
U.K. Banking Environment, focusing on performance optimization and
troubleshooting.
• Collaborated with project teams to implement database changes and
enhancements, ensuring alignment with business requirements.
• Conducted training sessions for team members on database management best
practices and new technologies, fostering knowledge sharing and skill
development.
• Utilized Python scripting for automating repetitive tasks, enhancing productivity
and reducing turnaround times.
Organization: Cognizant Technology Solutions Ltd.
Role: Senior Associate (Team Lead/L3+)
Responsibilities:
• Led a team in managing Oracle and MySQL databases for Health Care & Banking
Projects in the US, overseeing performance tuning and data integrity.
• Coordinated project timelines and deliverables, ensuring adherence to client
specifications and regulatory standards.
• Provided technical guidance and mentorship to team members, fostering a
collaborative environment and promoting continuous learning.
• Implemented database backup and recovery strategies using RMAN and other
tools, ensuring data availability and disaster recovery preparedness.
Organization: DXC Technology Solutions Ltd.
Role: Associate Manager
Responsibilities:
• Managed database operations across Oracle, MySQL, and Postgres platforms for
networking domain projects based in the US, focusing on scalability and
performance optimization.
• Led Change Management and Incident Management processes, ensuring timely
resolution of database-related issues and minimizing business impact.
• Collaborated with stakeholders to define and implement database strategies
aligned with business goals, leveraging MS SQL Admin skills for effective
decision-making.
• Implemented automation scripts for database maintenance and monitoring,
improving operational efficiency and reducing downtime.
His next immediate availability for training: From Dec 4th week onwards (subject to
change based on your confirmation).
Profile Submitted by:
Padmashree R, Solutions Expert, Non – Web Tech
Techademy: www.techademy.com
Contact Number:7795255466
Email ID:
[email protected] Understanding of the Requirement
1. Technology – SQL Fundamentals
2. Audience - Experienced professionals
3. Tentative Dates – To be discussed
4. Proposed Duration – 5 days (8 hrs/day)
5. Training Timing – To be discussed
6. Mode of Delivery – Virtual
7. No of participants – 20 pax
Proposed Solution
1. Proposed Trainer – Prakash S Patel (Profile Attached)
2. Proposed coverage – Attached (will be proposed post our discussion with the
SME/Will be shared in the subsequent email)
a. The provided coverage is standard coverage this is subject to change post
the discussion with the business team.
b. The duration may also vary based on the coverage
3. Training Outcome – Upon completing the SQL Fundamentals training,
participants will gain a solid understanding of SQL syntax, relational database
concepts, and data manipulation techniques. They will be able to write efficient
queries, perform data retrieval, apply joins, use aggregate functions, manage
databases, and design schemas, preparing them for real-world database
management tasks.
4. Pre-requisites –
• Familiarity with using operating systems (Windows, Linux, macOS) and basic
file management.
• General knowledge of what databases are, particularly relational databases
(tables, rows, columns).
• Ability to understand basic arithmetic operations, logical conditions, and
sorting/grouping concepts.
• Basic programming concepts (conditions, loops) will help in understanding
SQL queries.
• Basic experience with tools like Excel can help relate to SQL concepts like
tables and data manipulation.
5. Training aids –
a. LMS – Access to techademy platform to monitor, manage and engage the
participants with reports and analytics, discussion forums, badges and
leader board, certificates
b. Labs – labs will be provided by IIHT as a value
add with VM Insights/ labs can be provided by
IIHT as additional cost/ public cloud, third party extra cost
c. Hands on Practice – 15+ assignments
d. Assessments – Pre-assessment, module/milestone assessment-
5(composite Skill Based), final assessment (Skill based/project based)
e. Delivery Platform (Applicable for Virtual Training) – Virtutor with
auto attendance, session analytics and session recordings
f. Feedback – Primary (Day 1), mid-session and Final Feedback (Last Day)
6. Post Training Support (Optional, available on demand at additional cost)
a. Refresher sessions
b. Post training project
c. Only virtual support for 15 days on email
d. Extension of practice labs
