Summary
Overview
Work History
Education
Skills
Certifications
Projects
Affiliations
Accomplishments
Personal Information
Hobbies and Interests
Timeline
Generic
Nikhil Chandiwala

Nikhil Chandiwala

Gurugram

Summary

Seasoned Oracle DBA with proven track record of productivity and efficiency in database design, development and management. Specialize in SQL tuning, RMAN backup and recovery techniques, Golden Gate data replication and automation using Shell Scripting. Excel in problem-solving, time management, and effective communication to ensure seamless database operations and support organizational objectives.

Overview

11
11
years of professional experience

Work History

Technical Specialist

CitiusTech
Gurugram
06.2020 - Current
  • Led and managed a team of infrastructure resources to ensure timely and high-quality deliverables for the client within SLA timelines
  • Actively engaged with leadership and various stakeholders in monthly/quarterly project reviews to ensure seamless coordination and accountability.
  • Contributed to the implementation of new technologies, documented procedures thoroughly, and conducted effective knowledge transfer sessions for colleagues.
  • Implemented robust disaster recovery and business continuity plans to mitigate risk.
  • Collaborated with IT teams to develop solutions for complex technical issues.
  • Contributed to quality and infosec audits for the project

Consultant

Infosys
Pune
01.2020 - 06.2020
  • Facilitated successful KT sessions for resources on the Talent Pool
  • Reviewed existing policies and procedures to suggest necessary improvements.
  • Created plans to propose solutions to problems related to efficiency, costs or profits.

Consultant

Capgemini
Mumbai
11.2017 - 01.2020
  • Managed a small team within the DBA domain consisting of 4 members.
  • Delivered round-the-clock support to the project, fulfilling the role of an Oncall contact for P1/P2 issues.
  • Conducted client-specific proof-of-concepts (POCs)
  • Ensured crossskill development through management of team training sessions.
  • Reviewed existing policies and procedures to suggest necessary improvements.
  • Collaborated with clients to develop action plans to address specific challenges and objectives.

Senior Software Engineer

CGI Information Systems
Mumbai
06.2013 - 11.2017
  • Successfully completed required technical and domain trainings as a fresher
  • Delivered support to clients as part of a shared services team as a software engineer
  • Autonomously provided timely resolutions for software issues as a senior engineer, meeting SLA requirements.
  • Provided KT and served as a mentor to new team resources
  • Contributed to the implementation of new technologies, documented procedures thoroughly, and conducted effective knowledge transfer sessions for colleagues.

Education

B.Tech/B.E.( Computers ) - Computer Science

Uttar Pradesh Technical University (UPTU)
Lucknow, UP
06-2012

Class XII - Mathematics And Computer Science

DMA
Rampur, UP
06-2007

Class X - Mathematics

DMA
Rampur, UP
06-2005

Skills

  • Database Administration
  • Database Design & Development
  • Disaster Recovery Planning
  • Database Upgrade & Migration
  • Performance Tuning
  • Storage Management & Capacity Planning
  • Incident Management
  • Team Management
  • RAC/RMAN/OEM/Dataguard/Golden Gate/PLSQL
  • Unix/Shell Scripting/Ansible
  • Snowflake/PostgreSQL

Certifications

  • Oracle Cloud Infrastructure 2019 Certified Architect Associate Certification
  • Oracle Database 12c Administrator Certified Professional
  • Oracle Autonomous Database Cloud 2019 Certified Specialist
  • Oracle Database 12c Administrator Certified Associate

Projects

MultiPlan (NY, 47 Months)

  • Support for Mission Critical Databases ensuring availability, performance, and security of databases.
  • Implement monitoring solutions like OEM/Solar Wind to detect issues proactively.
  • Establish backup and recovery strategies using Rubrik.
  • Identify repetitive tasks and develop scripts or workflows to automate them by utilizing tools like Ansible, or custom scripts for automation.
  • Implementing Virtual Private Database for PHI data in guarded environments.
  • Research and evaluate new technologies/features relevant to the client environment. Conduct proof-of concept tests to assess feasibility and benefits.
  • Collaborate with application teams to understand their database requirements, provide guidance on database access, performance tuning, and deployments.
  • Integrate database changes into CI/CD pipelines for streamlined deployments.
  • Maintain knowledge repository for known issues and best practices in Confluence and share with team members.

Royal Mail (UK, 26 Months) 

  • Providing 24 7 support in a shared services team for mission critical databases varying from 11g to 12c without container.
  • Sync with cross-vendor and executing tasks following demarcation.
  • Proactively resolving issues from the alerts via OEM.
  • Document and standardize processes for consistency using Confluence/Sharepoint.
  • Performing database upgrade/patching with minimal downtime.
  • Collaborate with application teams to understand their database requirements, provide guidance on database access, performance tuning, and deployments.
  • Mentoring team members and managing cross-skill trainings. CGI Advantage, 24 Months, Performing database creation, management, upgrade, migration.
  • Performing database backup using RMAN and DataPump.
  • Managing database schema, roles, privileges based on need-to-have access.
  • Performing deployments along with AppDev.
  • Setting up OEM agents, alerts and SLAs.

Equity Insurance (UK, 28 Months)

  • Learning new development language RTM for the client.
  • Supporting development for new functionalities in the application.
  • Resolving issues as per priority and SLA defined.
  • Scheduling and executing deployments over weekend during maintenance window.
  • Managing MID - Motor Insurance Database for the client.
  • Performing SCM related tasks for baseline creation and deployment.

Capital Group (US, 6 Months)

  • Worked as a shadow resource for the DBA team, ensuring 24 7 support.
  • Maintaing a variety of Oracle databases ranging from 11g to 12c and Postgres.
  • Performing environment refresh using datapump.
  • Performing database creation, configuration and hardening as per templates.
  • Managing access for the AppDev based on data classification.
  • Maintaining passwords in Thycotic vault.
  • Performing online patching with minimal downtime.
  • Performing database upgrades.

Affiliations

  • Active CSR participant
  • Vice-caption of the House for Fun & Adventure Activities

Accomplishments

  • Received Pat On the Back award.
  • Received Rising Star award.

Personal Information

  • Total Experience: 11 Years 01 Month
  • Gender: Male
  • Marital Status: Married

Hobbies and Interests

  • Photograhy
  • Travelling
  • Music
  • Reading

Timeline

Technical Specialist

CitiusTech
06.2020 - Current

Consultant

Infosys
01.2020 - 06.2020

Consultant

Capgemini
11.2017 - 01.2020

Senior Software Engineer

CGI Information Systems
06.2013 - 11.2017

B.Tech/B.E.( Computers ) - Computer Science

Uttar Pradesh Technical University (UPTU)

Class XII - Mathematics And Computer Science

DMA

Class X - Mathematics

DMA
Nikhil Chandiwala