Nikhil Chandiwala
Gurugram, Haryana
Summary
Experienced Database Administrator with over 11 years of expertise in database design, development, and administration. Proficient in managing large-scale Oracle environments, with a strong focus on high availability, performance optimization, and security. Skilled in database backup and recovery, upgrades and migrations, Data Guard, Golden Gate replication, encryption techniques, and UNIX shell scripting. Committed to ensuring seamless database operations and business continuity.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Technical Specialist
CitiusTech Healthcare Technology
06.2020 - Current
- Managed group of resources in infrastructure, maintaining quality standards and meeting SLA deadlines.
- Facilitated seamless communication by engaging stakeholders and senior leaders in regular progress evaluations.
- Supported multi-database environments by maintaining over 100 Oracle databases with consistent 99.99% uptime.
- Reduced manual operations by integrating automated solutions, cutting human efforts by up to 70%.
- Managed database migrations and upgrades, ensuring minimal service disruption.
- Facilitated continuous data synchronization using Oracle GoldenGate for critical infrastructure.
- Enforced data protection strategies by leveraging Oracle Transparent Data Encryption.
- Optimized databases to support application scalability with development teams.
- Implemented new tools/technologies, achieving operational cost reductions of up to 30%.
Consultant
Infosys Ltd.
01.2020 - 06.2020
- Supported multi-database environments by maintaining over 100 Oracle databases with consistent 99.99% uptime.
- Optimized large-scale database reliability by conducting seamless RMAN-powered backups and recoveries.
- Enhanced application response time by 30% through optimization of SQL queries.
- Facilitated successful KT sessions for resources on the Talent Pool.
- Collaborated with development teams on database design and optimizations, ensuring high availability and scalability for applications.
- Crafted solutions aimed at improving operational efficiency, cutting costs, and boosting profit margins.
Consultant
Capgemini
11.2017 - 01.2020
- Maintained daily operations of more than 50 Oracle databases ensuring around-the-clock availability.
- Oversaw complete lifecycle of database design, implementation, and optimization.
- Executed meticulous plans to minimize downtime during Oracle Database upgrades.
- Established and verified disaster recovery plans utilizing RMAN and Data Guard, substantially reducing RTO.
- Implemented cross-platform data integration with Oracle GoldenGate.
- Created monitoring scripts with Unix Shell to enhance database health.
- Implemented continuous database health monitoring using OEM.
- Executed query optimization techniques to boost transaction processing speed by 20%.
Senior Software Engineer
CGI Information Systems
06.2013 - 11.2017
• Contributed to the implementation of new technologies, documented procedures thoroughly, and conducted effective knowledge transfer sessions for colleagues.
• Assisted senior DBAs in the installation, configuration, and maintenance of Oracle databases.
Conducted regular database backups using RMAN.
• Supported Oracle Data Guard and RAC implementations to ensure high availability and failover capabilities.
Performed upgrade verifications and patch implementations in both test and production settings.
• Created basic shell scripts to automate routine database maintenance tasks, improving efficiency.
Education
B.Tech - CSE
Gautam Buddh Technical University
Lucknow, UP06-2012
Class XII -
Dayawati Modi Academy
Rampur, UP06-2007
Class X -
Dayawati Modi Academy
Rampur, UP03-2005
Skills
- Database: Oracle 11g/12c/19c, Snowflake
- Backup & Recovery: RMAN, Data Guard, Flashback
- High Availability: Oracle RAC, Data Guard
- Replication: Oracle GoldenGate
- Performance Tuning: AWR, ASH, ADDM, SQL Advisor
- Scripting & Automation: Unix Shell Scripting, Python
- Upgrade & Migration: Oracle Database/Grid Upgrades, Patch Management
- Operating Systems: OEL 7/8, Windows Server
- Security: Transparent Data Encryption (TDE), Virtual Private Database (VPD), Privilege Analysis
- Tools & Utilities: SQL*Plus, TOAD, Oracle Enterprise Manager, RMAN, Data Pump, GoldenGate Veridata
- Project Management: JIRA, Confluence, ServiceNow, SharePoint
Certification
- Oracle Cloud Infrastructure 2019 Certified Architect Associate
- Oracle Autonomous Database Cloud 2019 Certified Specialist
- Oracle Database 12c Administrator Certified Professional
- Oracle Database 12c Administrator Certified Associate
Key Projects
Oracle Database Upgrade to 19c
• Led the upgrade of 100+ Oracle 12c database to Oracle 19c, ensuring minimal downtime and within SLA timelines.
• Used Ansible to automate 19c binaries installation.
• Used shell scripting to automate the upgrade process, thus reducing manual effort by 40%
• Created documentation for known issues over Confluence for a smooth knowledge transfer.
Oracle DGBroker Implementation
- Implemented Dataguard Broker configuration for seamless switchover/switchback during production maintenance.
- Developed automation to perform switchover/switchback using DG Broker, datapatch apply, etc., thus reducing manual intervention up to 90%
Oracle Veridata Implementation
• Performed PoC on Oracle Veridata ensuring all known issues are resolved prior to actual implementation.
• Deployed Oracle Veridata successfully in the production environment for homogenous/heterogeneous replication.
• Developed automation to implement comparison/repair for a new configuration, reducing the manual effort by 70%
• Created documentation over Confluence for smooth knowledge transfer.
• Scheduled regular compare/repair jobs to ensure source and target systems are in sync for data integrity.
Oracle GoldenGate Migration to DBFS
• Handled the migration project to move GoldenGate deployment from ACFS to DBFS using automation, thus reducing the manual effort by 50%
• Created documentation over Confluence for smooth knowledge transfer.
GoldenGate Lag Monitoring
• Introduced an automation to perform lag monitoring at OGG process level.
• Helped in quickly identify any issues during replication of a particular process proactively.
• Number of replication failure/stuck incidents reduced to 50%
• Created documentation over Confluence for smooth knowledge transfer.
Environment Refresh Automation
• Developed automation to periodically perform refresh from production to non-production environment, thus reducing manual efforts up to 80%
• Configured a lookup table to allow automation to execute as desired without a need of manual changes in the code every time.
• Created documentation over Confluence for smooth knowledge transfer.
Accomplishments
- Received Top Innovator Award for implementing various ideas around automation to reduce manual efforts and errors.
- Received Rising Star Award for demonstrating core values and serving as a mentor for new joiners in the team.
Professional Development
- Attended various Oracle workshops and trainings around Oracle Cloud and Autonomous Database.
- Attended AskTom and NYOUG sessions related to Oracle Cloud, Oracle Security, Application Development, Monitoring, etc.
Timeline
Technical Specialist
CitiusTech Healthcare Technology
06.2020 - Current
Consultant
Infosys Ltd.
01.2020 - 06.2020
Consultant
Capgemini
11.2017 - 01.2020
Senior Software Engineer
CGI Information Systems
06.2013 - 11.2017
B.Tech - CSE
Gautam Buddh Technical University
Class XII -
Dayawati Modi Academy
Class X -
Dayawati Modi Academy
Similar Profiles
Dhairya KothariDhairya Kothari
Manager - I at US Healthcare - CitiusTech Healthcare Technology Pvt. Ltd.Manager - I at US Healthcare - CitiusTech Healthcare Technology Pvt. Ltd.
Arti Mukherjee SainiArti Mukherjee Saini
Technical Lead at Citiustech Healthcare Technology Pvt LtdTechnical Lead at Citiustech Healthcare Technology Pvt Ltd
Rachana KRachana K
Senior Software Engineer at CitiusTech Healthcare Technology Private LimitedSenior Software Engineer at CitiusTech Healthcare Technology Private Limited