Krutarth Pandya

Experience

• 

  Tata Consultancy Services

  Jul 2011 - Oct 2012

  Oracle Developer

   Database Creation using DBCA utility. Taking database backup using Export utility and regularly shifting those backups to Tape. Creating Stored Procedures , Functions and Packages for generating Revenue reports, Tax reports, Defaulters list, User details etc based on clients requirement. Export / Import of database objects. Tuning complex and poorly performing queries. Day to day working with functional team, understanding there requirements and developing packages, procedures and functions. Maintaining production, development and staging environment code in sync. After successful testing on staging and during GoLive activity, moving code to production. Preparing SQL scripts which includes any Table structure change, new or edited procedures/functions/packages, create/insert/update/delete/drop statements and executing them at one go without any errors. Similarly testing those over Staging environment first and then on production during GO live activity.  Monitoring session level flow and understating tracefile generated using TKPROF utility. Worked on production, development and standing databases. Database used Oracle 10G and Oracle 11G XE Operating System used Windows. Show less

• 

  Paul Mason Consulting India Ltd

  Oct 2012 - Sept 2014

  Database Administrator

   Database Creation Rebuild of indexes and Analysis Configuring and Scheduling of RMAN backups Export / Import of Tables, Schemas and Procedures. Database movement from one server to another using RMAN backup. Monitoring alerts and resolving them within given SLA. As a part of Data separation activity, moving data from one database to another using SQL scripts. Making sure statistics at db level are not stale, rebuilding statistics at table or index level where DML operations are huge and frequent. Generating AWR, ADDM, ASH reports to obtain details of performance issue during given timeframe. Database upgradation. Handling 20+ Production databases and 20+ Development databases. Databases used Oracle 10G and Oracle 11G. Operating System used Linux X86_64. Show less

• 

  Tata Consultancy Services

  Oct 2014 - Sept 2022

   Managing Oracle and MSSQL Environment. Leading team of Oracle and SQL DBA’s. Managing Oracle Exadata x7-2 along with ZFS 5 Backup appliance. Replacing Faulty parts of Exadata and ZFS appliances with the help of Vendor Support. Performing regular Exadata Patching with 0 Down time and co-ordinating with Application teams to perform end to end testing post activity completion. Performing Regular Oracle Database Patching and Bug fixing. Working closely with team to perform regular SQL Patching either Manually or using SCCM. Configuring and Managing OEM 12C/13C, OEM Agents and OEM alerts. Building and maintaining Oracle Data guard. Performing regular DR Drills to provide HA and Stability in environment. Managing ASM Disk Group and adding disk space as and when required. Managing RMAN Backups and restorations. Configuring backups using external backup solutions like Commvault and Veeam. Database upgradation from Oracle 11G to 12C, 18C and 19C. Performing regular refresh of databases using RMAN or FLASH restore. Working closely with client for continuous service improvement in the environment. Ticket handling and managing SLA using ServiceNow. Integrating ServiceNow with OEM for auto ticket generation on critical alerts. Working closely with Client and following ITIL best practices. Show less

  • Assistant Consultant

    Jan 2021 - Sept 2022

  • Information Technology Analyst

    Jun 2016 - Dec 2020

  • System Engineer

    Oct 2014 - May 2016
• 

  Oracle

  Sept 2022 - now

  Principal Software Engineer