Dinesh Parmar
Ahmedabad
Summary
Results-driven Database Administrator with 9.5 years of experience in managing and optimizing Oracle, MySQL, Goldengate, Exadata, and PostgreSQL databases. Focused on ensuring high availability and performance through effective troubleshooting and implementation of disaster recovery solutions.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Team Lead
Beyondata Solutions Pvt. Limited
08.2023 - Current
- Managed day-to-day operations and technical issues for Oracle, MySQL, Exadata and PostgreSQL databases, ensuring their availability and performance.
- Configured and maintained Oracle Exadata systems to enhance storage efficiency and compute resource allocation.
- Implemented Oracle Goldengate for data replication and ensured data consistency across systems.
- Delivered 24/7 support for critical production databases, achieving high availability and swift issue resolution.
- Conducted regular performance tuning, SQL query optimization, and database maintenance activities.
- Automated backup and recovery processes using RMAN and mysqldump, improving reliability.
- Managed user accounts, roles, and permissions to ensure data security and compliance.
- Collaborated with development teams to optimize database designs and SQL queries for better performance.
- Monitored and resolved database issues using Oracle Enterprise Manager and other monitoring tools.
- Performed database upgrades, patching, and migrations with minimal downtime.
- Executed Exadata patching and migration from EXACC to EXACS RAC server, optimizing system performance.
- Patching and upgradation from 12c to 19c server.
- Implement tde(Transparent Data Encryption) in oracle rac 19c.
Team Lead
Sterlite Technologies Pvt. Limited
10.2018 - 08.2023
- 24x7 support to project as ORACLEDBA.
- Daily DBA activities such as user management, space management, database performance.
- Modified housekeeping shell scripts for Oracle Database tablespace alerts, file system usage, and weekly cleanups, ensuring optimal database performance.
- Supported client site users in resolving database-related issues, enhancing user satisfaction and operational efficiency.
- Performed weekly cold backup of databases to ensure data safety. and daily hot backup.
- Create and configure partitions in database.
- Perform database switchover, roll forward activities.
- Create and configure dataguard RAC in production server.
- Database patching using patch.
- Executed database clone activities.
- Working on oracle 12c database.
- Create, Configure and Managed Standby Database.
- Create and configure oracle 12c RAC database.
- Create and manage partition in PostgreSQL database.
- Performed backup and point-in-time recovery for PostgreSQL database, safeguarding critical data and ensuring business continuity.
- Perform fail over in Postgres using pg_rewind utility.
- Perform Postgres upgradation manually and automatic.
- Maintain database performance in PostgreSQL server.
- Performing dc-dr switchover activities on production server.
- Upgrade MySQL database.
- Create and configure PostgreSQL server.
Team Member
infosense global pvt Limited
10.2016 - 10.2018
- Provided 24x7 DBA support for Central Bank of India project, ensuring database availability and performance.
- Managed 2 production instances and 3 test instances totaling 2 TB of database size.
- Ensured RAC database stability and performance.
- Implementation of Oracle 12cRAC(2node).
- Perform Database migration from 12c to 19c with zero downtime.
- Perform database switchover, Roll forward activities.
- Database Refresh Activities weekly.
- Modified shell scripts for Oracle database housekeeping, improving alerts for tablespace, file system usage, and weekly cleanups.
- Regularly rebuilding indexes, analyze the tables and gathering statistics.
- Coordinating with Oracle Technical Support (Meta link) for Several bugfixes.
- Managed space allocation for database resources. and managing of Raw devices inventory.
- Installation of Oracle 11g single instance.
- Bottomline Technologies (NASDAQ: EPAY), an innovator in business payment automation technology for 30 years, eliminates that struggle by helping companies make complex business payments simple, smart and secure.
Team Member
Infrastructure Leasing & Financial Services Limited (IL&FS)
03.2016 - 10.2016
- Managing Production Instances and Test Instances with database total size of 1.5 TB.
- Executed daily DBA activities, including user management, space management, and monitoring database performance.
- Provided 24/7 assistance to clients on the MpBhulekh project as ORACLEDBA.
- Provided support to client site users for database-related issues, ensuring timely resolution.
- Weekly cold backup and daily hot backup.
- Upgrade standalone database 10.1.0.2 to11.2.0.4.
- Modified housekeeping shell scripts to automate alerts for Oracle Database tablespaces, track file system usage, and facilitate weekly database cleanups.
- Perform database switchover, roll forward activities.
- Database patching using Opatch.
- Infrastructure Leasing & Financial Services Limited (IL&FS) is one of India's leading infrastructure developments and finance companies. IL&FS has developed the requisite capabilities to take infrastructure projects from concept to commissioning in each sector.
Education
Bachelor of Computer Science -
Gujarat University
IndiaSkills
- MySQL & PostgreSQL Administration
- Oracle Exadata Configuration & Maintenance
- Oracle Goldengate Replication
- Backup & Recovery (RMAN, mysqldump)
- Performance Tuning & Optimization
- Database Security & Compliance
- High Availability & Disaster Recovery (RAC, Data Guard)
- SQL & cell Scripting
- Unix/Linux System Administration
- Cloud Database Management (AWS, Oracle Cloud)
- Exadata Administrator
- TDE implement
- AVDF implement with GoldenGate
Certification
- Oracle DBA 11g OCP Certification
- Oracle DBA 19c OCP Certification
- Oracle CLOUD Associate
Languages
English
Upper Intermediate
B2
Hindi
Proficient
C2
Timeline
Team Lead
Beyondata Solutions Pvt. Limited
08.2023 - Current
Team Lead
Sterlite Technologies Pvt. Limited
10.2018 - 08.2023
Team Member
infosense global pvt Limited
10.2016 - 10.2018
Team Member
Infrastructure Leasing & Financial Services Limited (IL&FS)
03.2016 - 10.2016
Bachelor of Computer Science -
Gujarat University