Ajay Laxman Shinde
Pune,
Summary
Accomplished Oracle DBA with extensive experience at Infosys LTD, excelling in database performance optimization and incident resolution. Proficient in Oracle RAC and Data Guard management, I effectively ensured database integrity and security while collaborating with cross-functional teams. My strong analytical skills and proactive approach consistently enhanced operational efficiency.
Overview
5
5
years of professional experience
Work History
Oracle DBA
Infosys LTD
Pune
08.2021 - Current
- Extensive hands-on experience in managing Oracle 11g/12c databases, including Prod, Dev, and QA.
- Provided regular DBA support for standalone, as well as RAC databases.
- Provided dedicated DBA support for the merging of two reputed banks in the USA.
- Responsible for handling critical issues, incidents, service requests, and resolution as per SLA.
- Database performance: Constantly striving for better performance, making suggestions to eradicate any bottlenecks, monitoring logs, blocking sessions using OEM, and killing unwanted user processes and sessions.
- Knowledge of patching in standalone and RAC databases.
- Extensive knowledge of logical standby database monitoring and management.
- Space management: Monitoring tablespaces, filesystems, and FRA.
- DR testing: Worked on converting standby databases to snapshot mode to make the database available for DR environment testing, and bringing them back in sync with PROD.
- User management that includes creating, dropping, locking, and unlocking database user accounts and PIDs.
- Extensive hands-on experience in database refresh using the expdp/impdp data pump utility under different conditions.
- Extensive experience in database maintenance activities, including DB restore and restart.
- Ensured that databases adhere to corporate standards and policies.
- Creating and scheduling jobs in Crontab, OEM.
- Worked with application, development, and QA teams to ensure a smooth database life cycle process from development through testing and production deployment.
- Installed, configured and administered Oracle 10g, 11g databases on Linux, Unix platforms.
- Used OEM for monitoring, diagnosing and resolving problems quickly.
- Monitored database performance and tuned SQL statements for optimal performance.
Database Engineer
TCS LTD
Powai
11.2019 - 04.2021
- Working knowledge of ETL tools, like IBM InfoSphere DataStage and Datawatch PrepStudio Monarch.
- Handled client data as per request, establishing different Unix shell scripts and logics successfully.
- Extracting and replicating company data, and loading it into a data warehouse environment.
- Supported another within the project in which the StoneBranch tool was used to schedule the different jobs in the production environment.
Education
Bachelor of Technology - Electrical Engineering
Shri Guru Gobind Singh Ji IE&T
Nanded, Maharashtra05-2019
Skills
- Oracle database management
- Standby/failover administration
- Database and agent patching
- Managing Oracle Data Guard
- Oracle RAC and ASM Administration
- Logical standby database administration
- Capacity monitoring
- Daily health checks of the database
- Shell scripting
- Data backup and recovery
- Database security practices
- Incident resolution
Software/Tools
- Putty
- TOAD
- OEM 13c
- ServiceNow ticketing tool
- WinSCP
- SQL Developer
- IBM InfoSphere DataStage for ETL activities
- Monarch for ETL activities
- StoneBranch for scheduling jobs
Accomplishments
- Received an award in recognition of the successful development and implementation of a proactive monitoring script in production that detects long-running database sessions consuming excessive CPU and system resources, significantly enhancing system performance and operational efficiency
- Received an award for consistently demonstrating outstanding team spirit and dependability by voluntarily stepping in to cover shifts for colleagues, ensuring uninterrupted support, and maintaining seamless operational continuity
Timeline
Oracle DBA
Infosys LTD
08.2021 - Current
Database Engineer
TCS LTD
11.2019 - 04.2021
Bachelor of Technology - Electrical Engineering
Shri Guru Gobind Singh Ji IE&T
Similar Profiles
Manas PatwardhanManas Patwardhan
Consultant at Infosys LtdConsultant at Infosys Ltd
Gyanender SinghGyanender Singh
Technology Lead at Infosys LtdTechnology Lead at Infosys Ltd
RAHUL GUPTARAHUL GUPTA
Principal Consultant - Digital & AI Transformation at INFOSYS LTDPrincipal Consultant - Digital & AI Transformation at INFOSYS LTD