Reading
Pankaj Gite
Oracle Database Administrator
Pune,91- 8422969884
Summary
Database Administrator with 11+ years of experience in maintaining and implementing enterprise-supported databases and software. Highly skilled at Database designing, upgrading, tunning, and automating database infrastructures. Seeking a position at your organization to implement data transformation processes guaranteed to improve your company’s position in the industry.
Overview
11
11
years of professional experience
2
2
Certifications
1
1
Language
Work History
Snr. Oracle DBA
Williams-Sonoma India Private Limited
Pune
02.2023 - Current
- Established working relationships across various departments to understand existing and emerging IT requirements.
- Provided resources and skill sets to support DBA functions for applications.
- Proposed database changes to ease monitoring and administrative effort.
- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
- Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
- Troubleshot database issues to create and resolve trouble tickets.
- Worked with customers and other third parties to support DBA functions.
- Participated in situation management of incidents to support database operations.
- Conducted tests to identify issues and make necessary modifications.
- Created and updated database designs and data models.
- Implemented security measures to protect vital business data.
- Installed and configured middleware in Linux and Windows environments.
- Modified databases to meet needs and goals determined during planning process.
Database Administrator
Nisum Consulting
Pune
07.2022 - 01.2023
- Collaborate with 30+ IT project managers, database programmers, and multimedia programmers to maintain the company database’s integrity and security
- Quickly respond to 20+ front-end users and efficiently troubleshoot their issues in adherence with relevant data protection laws and regulations
- Spearheaded installation and customization of new Databases creation as per Application needs
- Complete 5+ high-quality projects monthly and conduct debugging exercises to ensure functional requirements are met
- Yearly partitions and space procurement for future years
- Fixing PT Issue.
IT Infrastructure Analyst
Barclays Technology Centre India Pvt Ltd.
11.2016 - 05.2022
- Designed, managed, and maintained 4 multi-vendor database infrastructures, and ensured they consistently met business needs
- Performed recovery and backup of database servers and distributed server backup during emergencies
- Spearheaded data integration project and provided database deliverables such as logical databases, security policies, capacity planning, and data maintenance plans
- Served as a liaison and coordinated the support of external vendors in scheduling and performing software patching
- Managed to do 150+ database patching
- Have done database upgrades form 12c to 19c database
- Have worked on Oracle Golden gate technology
- Have a very good hands-on practice for cloning, Patching, migration
- Worked with multiple application like IAM, TIBCO, TIAA
- Worked as SPOC for IB estate database to stabilize and performance related Issues
- Managing and handling Major Incident Management call to give quick solution and stabilize application Issue for Tiie1->3 services
- Fixing database long running sessions Issues by monitoring DB HC on periodic basis
- Awarded as best DBA for outstanding performance for year 2019-20.
IT Application Specialist
Symantec Software’s India Pvt Ltd
04.2015 - 11.2016
- Designed, managed, and maintained 2 multi-vendor database infrastructures, and ensured they consistently met business needs
- Worked as Primary DBA to ensure Project and Support DBA role for Informatica, EAIP and TIBCO Application
- This Includes DB configuration, creation, maintenance of Db servers
- Quarterly and Yearly DB refreshes
- Quarterly Sys/System password change activity quarterly to maintain SOX audit
- DEV -> UAT -> PROD DB patching
- Stats gathering weekly
- Setting up backup from DR database to minimize Impact to Prod
- L1 DBA support for SQL server databases.
Oracle Database Administrator
Future Focus India Pvt Ltd
03.2013 - 03.2015
- UBI Is semi government bank running on Finacle as their core banking application
- Have worked for 2 years on L1 DBA
- Supporting banking BOD,EOD activities
- Service now Is ticketing tool for tracking tickets
- DR drill Is the main activity which, I am performing every quarter
- Stats gather, Import / export are the BAU activities
- Scheduling jobs, Monitoring RMAN backup and fix If failed
- Creating scripts for dump and trace file cleanup
- Daily DB refresh from prod SNAP backup (IBM to0l) post EOD to help application team to perform reporting
- Raising SR to resolve Issues
- Working with PT team get more knowledge on Finacle Logic.
Education
Master’s in computer application -
Dept of Computer Science, Amravati University
Amravati, MHSkills
Oracle DBA OCP (2019)Problem-solvingCommunicationTools: Putty, WINSCP, Service Now, IBM Tivoli, SQL Developer, netca, OPATCH, DBCAIBM SNAP backup, RMAN Backup, Storage Backup, Cold backupSkillsets: Patching, Upgrades, Migration, Golden Gate, Performance Tuning, Scripting, DB Build, DataGuard, Backup and Recovery, DataPump
DB Version: 9i, 10g, 11g, 12c, 19c,21c
Operating systems: Linux, AIX, Windows
Certification
OCA 11G
Interests
Cricket , Singing
I Played cricket at University Level and playing for keeping myself fit ad like to sing occasionally , have participated in singing competition at corporate level
Timeline
Snr. Oracle DBA
Williams-Sonoma India Private Limited
02.2023 - Current
Database Administrator
Nisum Consulting
07.2022 - 01.2023
OCP 19C
06-2018
IT Infrastructure Analyst
Barclays Technology Centre India Pvt Ltd.
11.2016 - 05.2022
IT Application Specialist
Symantec Software’s India Pvt Ltd
04.2015 - 11.2016
Oracle Database Administrator
Future Focus India Pvt Ltd
03.2013 - 03.2015
OCA 11G
01-2013
Master’s in computer application -
Dept of Computer Science, Amravati University