Sudhir Varma
Hyderabad
Summary
High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
17
17
years of professional experience
Work History
DBA/DMA Administrator
Pathfinder Management Consulting India Limited
03.2015 - Current
- Excel in Oracle database administration across diverse platforms and versions, with specialization in 19c/12c/11g/10g/9i databases, accumulated over 15 years.
- Extensive experience with Oracle Exadata X7, X8, and X9 versions, including database administration, , and Exadata Full stack patching.
- Experience in ILOM administration, Storage administration and Switch administration.
- Provide support for hardware failures(i.e.dimm/cpu/hdd) on Exadata racks
- Shutdown or reboot cell without impacting ASM
- Adding Storage to mount points whenever it required.
- Run exachk, sosreport, sundiag and ilom snapshots to diagnose Exadata health check.
- ASR configuration and addressing ILOM incidents.
- Experience in troubleshooting various installation and patching issues.
- Experience in installation of new Exadata setup using OEDA and Reimage compute nodes.
- Hands-on experience with Oracle Key Vault for secure encryption key management and protection of sensitive data across databases and applications.
- Upgraded ORACLE/GRID Home from 11g to 12c and 19c.
- Experience in database migrations and upgrades.
- Experience in handling complex database recovery scenarios.
- Scheduled RMAN & Logical backups using ZDLRA and Actifio tool.
- Implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Creation of new databases as per request from Client
- Supporting user requests as per ITIL process of Incident management, Change management and problem management.
- Restoration of DBs using RMAN backup and handling complex database recovery scenarios.
- Enhanced data security measures, conducted regular system backups to prevent data loss.
- Troubleshoot performance issues that might have come up with data growth
- Monitoring Oracle Applications Instance and Oracle Databases using Oracle Enterprise Manager(OEM).
- Follow-up with Oracle Product Support through Metalink for any issues that Functional Consultants raise which requires Database level log files etc..
- Actively participated in annual Disaster Recovery (DR) exercises, ensuring business continuity and validating backup and recovery strategies.
- Supporting user requests as per ITIL process of Incident management, Change management and problem management.
- Excellent written and verbal communication skills.
- Ability to work under pressure - quick thinking and remaining calm during stressful situations.
- Willingness to work in 24x7 rotational shifts and on weekends.
- Ability to quickly grasp complex technical issues.
- Appetite to learn new technologies and constantly improve technical skills.
- Provide SME level of support whenever scenario exists.
Oracle APPS DBA
KPIT INFOSYSTEMS LTD.
12.2007 - 03.2015
- Managing Multiple Instances like Development, Test, UAT and Production etc.
- Cloning of Oracle applications.
- Patching – family packs/mini packs/maintenance packs etc.
- Co-ordination with Technical and Functional teams for Patching related activities.
- Adadmin utilities like maintaining invalid objects,(compiling apps schema).
- Allocating system storage and planning future storage requirements for thdatabase system.
- Creating primary database storage structures (table spaces) after application developers have designed application.
- Creating primary objects (tables, views, indexes) once application developers have designed application.
- Modifying database structure mainly in customized programs, as necessary from information given by application developers.
- Enrolling users and maintaining system security.
- Schedule jobs management and monitoring. (cron jobs etc.).
- Planning for backup (Hot, Cold and Logical) and recovery of database information.
- Monitoring OS Load and suggesting system admin accordingly to tune OS.
- Identifying long running queries, high disk read queries and guides application developer to tune queries accordingly.
- Co-ordination with Oracle via Metalink for resolutions of issues.
- Extracting required information from database using sql/toad for uploading requirements to Oracle Support.
- Monitoring OS related parameters like Memory Usage, CPU Usage, inactive jobs.
- Maintaining documents of System Study, Uptime, and Patching Records.
- Implementing Best Practices like Index Rebuilding, Analyzing tables etc for better performance.
- Monitor Workflow related services.
- Monitor Notification Mailer Working.
- Monitor Concurrent Programs/Managers Status.
- Work on Sysadmin (Oracle Apps) programs for creating users/responsibilities/printer/profile options.
- Troubleshoot with Oracle Applications Tech Stack including Up-gradation/configuration of HTTP Server (Apache), Jserver, Fusion Middleware(Forms server and Reports Server), Concurrent Manager.
- Periodically refreshed Oracle databases and Applications, for business reasons.
- Troubleshooting Oracle Application Performance/Tuning Issues.
Education
MSc (IT) -
Manipal University
Karnataka01.2004
B.Sc. (M.P.E) -
Andhra University
Visakhapatnam01.2000
Skills
- Linux, UNIX Sun Solaris, Windows 95/98/2000/NT 40 Serve, DOS
- SQL *Loader, Export and Import, Toad, Putty, Data Pump
- Oracle 9i, 10G, 11G, 12c, 19c DB Management
- Oracle E-Business Suite 11i and R12 E-Business Suite
- Oracle Exadata Management
- Oracle database Patching/Upgrade/ Migration
- Database Troubleshooting
- Backup and recovery
- Capacity Planning
- Performance Tuning
- Disaster Recovery Planning
- Memory Management
- Data Guard Implementation
- Database Cloning
- Oracle 13c OEM Management
- Database Security Management
- Oracle RAC Administration
- ASM management
- Problem-solving abilities
- Shell scripting
- Time Management
- Multitasking Abilities
- Excellent Communication
- Organizational Skills
- Active Listening
Languages
English, Hindi, Telugu, Marathi
Summary Of Experience
Having 16 Years of in IT and experience in Core Database Administration and Apps DBA, Expert in Exadata Patching ,Upgradation & Migration ,Performance & Tuning, RAC,ASM, Backup and Recovery, DATAGAURD. Possess Good Communication & Problem-solving skills.
Personal Information
- Date of Birth: 01/08/1980
- Nationality: Indian
- Marital Status: Married
Timeline
DBA/DMA Administrator
Pathfinder Management Consulting India Limited
03.2015 - Current
Oracle APPS DBA
KPIT INFOSYSTEMS LTD.
12.2007 - 03.2015
MSc (IT) -
Manipal University
B.Sc. (M.P.E) -
Andhra University
Similar Profiles
Vibhas KumarVibhas Kumar
Business Development Manager at Pathfinder Consulting LLCBusiness Development Manager at Pathfinder Consulting LLC
Rajasekhar KondapuneniRajasekhar Kondapuneni
Oracle Apps DBA at Pathfinder Managemment Consulting Pvt Ltd.Oracle Apps DBA at Pathfinder Managemment Consulting Pvt Ltd.
Ramchand MekaRamchand Meka
Senior Accountant ( Team Lead) at TATA Sikorsky Aerospace Limited ( Payroll Pulivarthi Consulting India Private Limited)Senior Accountant ( Team Lead) at TATA Sikorsky Aerospace Limited ( Payroll Pulivarthi Consulting India Private Limited)