SUDHIR PHADTARE
Database Administrator
Mumbai,MH
Summary
Talented Database Administrator with 7 years of diverse experience in database design and administration. Extensive technical skills and advanced understanding of Postgres , Oracle, SQL Server administration. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving.
Overview
7
7
years of professional experience
7
7
years of post-secondary education
1
1
Certificate
1
1
Language
Work History
Senior Engineering Lead
Persistent System
Pune, Maharashtra
01.2021 - Current
- Currently working on infrastructure migration project from On-Premise to AWS Cloud
- Working on AWS RDS (Relational Database Service), AWS DMS (Database Migration Service), AWS MGN (Application Migration Service) and AWS Cloud Watch closely.
- Worked on Ansible to automate Postgres , Oracle , SQL Server & SAP Hana installation on different OS like Windows and Linux
- Working on AWX Ansible Tower to run Ansible playbooks through tower.
- Learning HashiCorp Packer for creating template or AMI in AWS for EC2 instance creation and Terraform for provisoning EC2 instance as IAC
- Automation of Postgres / SQL Server, Oracle , SAP Hana database backup and restore functionality using Ansible and Jenkin
- Working on VMware to spin up new VMs using Vsphere VRA and change configuration(CPU, Memory, Storage) of existing Windows and Linux VM
- Administered, supported and monitored databases like Postgres , SQL Server and Oracle by proactively resolving database issues and maintaining servers.
- Works database performance tuning and query tuning for long running queries.
- Provided reporting and technical expertise for maintenance of organizational processes.
- Created technical documentation for database technologies, providing updates.
Deputy Manager
AGS Transact Technology Limited
Mumbai, Maharashtra
09.2018 - 01.2021
- Managed DBA Team of 5 members.
- New server hardware projection and new database server setup on Production and Non-Production environments on Postgres, Oracle, SQL Server.
- Worked on Database migration from SQL Server to Postgres.
- Worked on SQL Server SSRS for reporting.
- Involved in database Auditing.
- Supports multiple database farms including Development, SIT, UAT, Production sizes up to 8 TB for 24/7.
- Perform Database Tuning Performance, Storage Management, Plan growth and changes capacity planning, Database Monitoring, Security Management and Tuning SQL queries.
Business Technology Analyst
Deloitte Consulting US
Mumbai, Maharashtra
02.2015 - 09.2018
- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- Set up and controlled user access levels across databases to protect important data.
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
- Worked on database and application deployment.
- Developed custom database objects, stored procedures and delivered application support.
- Followed standard practices for migrating changes to test and production environments.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
Education
BE - Computer Engineering
YTCEM College of Engineering
Karjat 11.2011 - 05.2014
Diploma - Information Technology
Vidyalankar Polytechnique
Wadala Mumbai 11.2008 - 04.2011
HSC - Computer Science
MD College
Parel Mumbai 03.2007 - 03.2008
SSC -
Social Service League High School
Parel Mumbai 03.2006 - 03.2007
Skills
Postgres 9-14 Administration
undefinedCertification
Certified AWS, Solution Architect Associate
Timeline
Certified AWS, Solution Architect Associate
03-2021
Senior Engineering Lead
Persistent System
01.2021 - Current
Deputy Manager
AGS Transact Technology Limited
09.2018 - 01.2021
Business Technology Analyst
Deloitte Consulting US
02.2015 - 09.2018
BE - Computer Engineering
YTCEM College of Engineering
11.2011 - 05.2014
Diploma - Information Technology
Vidyalankar Polytechnique
11.2008 - 04.2011
HSC - Computer Science
MD College
03.2007 - 03.2008
SSC -
Social Service League High School
03.2006 - 03.2007
Rewards and Recognition
- Individual High Five Award || Persistent || Dec- 2021
- Team Bravo Award || Persistent || Oct- 2021
- Shining Star Award || Deloitte || Nov 2017
- Performer of the month || Deloitte || April 2017
- Spot Awards || Deloitte || 2016 - 2018
Rewards and Recognition
- Individual High Five Award || Persistent || Dec- 2021
- Team Bravo Award || Persistent || Oct- 2021
- Shining Star Award || Deloitte || Nov 2017
- Performer of the month || Deloitte || April 2017
- Spot Awards || Deloitte || 2016 - 2018
Similar Profiles
Abha AgarwalAbha Agarwal
Lead Software Engineer at Persistent SystemLead Software Engineer at Persistent System
Mohini SinhaMohini Sinha
Senior Scrum Master at Persistent SystemSenior Scrum Master at Persistent System
SACHIN BHABADSACHIN BHABAD
Lead Network Engineer L2 at Persistent systemLead Network Engineer L2 at Persistent system