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
Oracle 11g & 12c RAC & Data Guard Administration
SQL Server 2012 Administration
AWS - EC2, RDS, DMS, MGN , Cloud watch
DevOps Tool Git , Ansible, Jenkin, Ansible Tower
ETL Tool - Pentaho
Versioning System - Git , Tortoise SVN, TFS
VMware vSphere & vRealizeAtlassian JIRA & Confluence
Web Servers - IBM WebSphere , Apache Tomcat
Certification
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