Kumar Ashish
Senior Database Administrator
NEW DELHI
Summary
Adroit and proficient Database Administrator with 7 years and 4 months of experience in the software industry, particularly in working as an PostgreSQL DBA, Oracle DBA and PL/SQL Developer. Valuable experience in installing, upgrading, and maintaining the Oracle and PostgreSQL databases.
5 Years of experience in migration to PostgreSQL technology from Oracle. Currently working on PostgreSQL migration project for a recovery audit workbench company, serving as a Senior Lead Engineer, involved in rewriting the procedures using PostgreSQL syntax.
Overview
8
8
years of professional experience
12
12
years of post-secondary education
2
2
Certifications
Work History
Senior Staff Engineer
Nagarro Engineering Pvt LTD
Gurugram
09.2021 - Current
- Name
- PRGX Recovery audit Workbench
- Client
- PRGX USA, Inc
- Provides business analytics and management consulting services
- Company offers services which includes vendor maintenance, contract compliance, working capital improvement, recovery audit, product cost harmonization, and workflow automation
- PRGX serves customers worldwide
- Description
- Project involved installation on Postgres database on centos and Ubuntu servers and movement of data from OCP to Virtual Machines
- It also involves schedule upgrades , maintenance and debugging day to day issues which involves query optimization and health monitoring of the database
- Creating and installing pgbouncer for connection pool mechanism through ansible playbooks
- PostgreSQL 13.5 , 14.6 , Pgbouncer 1.16 , pgdump, pgBackRest 1.36 , Redgate
- Responsibilities
- Created and upgraded 300 databases for dev and prod environments
- Scheduled backups using pgBackRest and maintaining backups on CIFS shares
- Set up the configuration of the server
- Maintaining health check-ups and monitoring of the server
- Set up master-slave configuration using patroni and distributed the load accordingly.
- Conducted research to test and analyze feasibility, design, operation and performance of equipment, components, and systems
- Wrote, reviewed and edited technical document in accordance with template requirements
- Provided input to team lead regarding areas for process and procedural improvement
Senior Team Leader
Indiamart Intermesh Public LTD
Greater Noida, UP
10.2019 - 09.2021
- Oracle to PostgreSQL Migration
- Client
- An Indian e-commerce company that provides B2B and customer to customer sales services via its web portal
- Description
- Project involved moving enquiry and leads modules from Oracle to PostgreSQL
- This involved the movement of all applications compatibility along with database migration
- Technology Stack
- Oracle PL/SQL development, PostgreSQL 9.6
- Responsibilities
- Created foreign tables and creating materialized views
- Scheduled procedures and functions using schedulers
- Set up the configuration of the server
- Rewrote the procs using PostgreSQL Syntax
- Set up master-slave configuration and distributed the load accordingly
- Discovered training needs and provided coaching.
- Developed strategies to promote team member adherence to company regulations and performance goals.
- Conducted training and mentored team members to promote productivity and commitment to friendly service.
- Demonstrated knowledge of company mission and goals and mentored employees in reaching objectives aligned with company core values.
Senior DBA
Indiamart Intermesh Public LTD
Greater Noida, UP
03.2019 - 03.2021
- Name
- Fraud Detection, Client
- An Indian e-commerce company that provides B2B and customer to customer sales services via its web portal
- Description
- Project involved creating a function to detect fraud users based on their unique IDs
- Technology Stack
- Oracle 11g/12c
- Responsibilities
- Served as a Senior Team Lead, Oracle DBA, Oracle Developer, Process Manager, Root Cause Analysis, and 24
- 7 Support
- Prepared technical documents, PostgreSQL procedures, and functions creation
- Created a module where the employee of the company can check the fraud status of a registered user based on its PAN (Primary Account Number), TAN, CIN, mobile, e-mail, and other personal information
- Set up and controlled user access levels across databases to protect important data
Database Administrator
Tata Consultancy Services
08.2015 - 02.2018
- Project Name
- User Management
- Client
- A Swedish multinational networking and telecommunications company
- Description
- Project involved working with a networking company in having multiple internal portals for user management
- All the databases were handled by external team
- Technology Stack
- Oracle 11g/12c, Exadata
- Responsibilities
- Upgraded 300 production and development environments to 12c
- Worked at the client location explaining about the advantages and process of going for upgrades
- Took care of the process management using ITSM tool
- Consolidated multiple DB homes on a unique location and helped in space and resource utilization.
Education
Bachelor of Technology - Electronics and Telecommunications
Bharati Vidyapeeth College of Engineering
Pune, MH 06.2011 - 06.2023
Skills
Experience inundefined
Accomplishments
Employee of the Year 2022-2023
Employee of the Month Jan 2022
Employee of the Month Aug 2022
Pillar of the Year 2021-22
Certification
Postgresql-v12-database-administration-on-windows-and-linux
Timeline
Postgresql-v12-database-administration-on-windows-and-linux
03-2023
PostgreSQL Essential Training on LinkedIn
01-2023
Senior Staff Engineer
Nagarro Engineering Pvt LTD
09.2021 - Current
Senior Team Leader
Indiamart Intermesh Public LTD
10.2019 - 09.2021
Senior DBA
Indiamart Intermesh Public LTD
03.2019 - 03.2021
Database Administrator
Tata Consultancy Services
08.2015 - 02.2018
Bachelor of Technology - Electronics and Telecommunications
Bharati Vidyapeeth College of Engineering
06.2011 - 06.2023
Similar Profiles
Praveen KumarPraveen Kumar
Associate Director Product Management at Nagarro Enterprises Services Pvt. Ltd.Associate Director Product Management at Nagarro Enterprises Services Pvt. Ltd.
Rakshit GuptaRakshit Gupta
Trainee at Nagarro Software Pvt. Ltd.Trainee at Nagarro Software Pvt. Ltd.
ATUL SOMALATUL SOMAL
Engineer at Nagarro Software Pvt LtdEngineer at Nagarro Software Pvt Ltd
Manvendra KumarManvendra Kumar
Manager- Finance & Costing at Genpact India Private LimitedManager- Finance & Costing at Genpact India Private Limited
Rohit PajhalRohit Pajhal
Director Network Operations at Indian Air ForceDirector Network Operations at Indian Air Force