Tech Lead - Tech Mahindra - Mumbai
(2023-02)
Client: Indian Navy, Domain: Government and Defence
- Technical Lead: Led technical Team on the Client side.
- Client Handling: Working with the client on the client side to understand the requirements.
- Database Installation and Configuration on Windows and Linux.
- Automate database backup and apply Naval security policies on backup files.
- Automate DB and Server monitoring using shell scripts.
- Query Optimisation.
- Work on AD authentication Method.
- User Management: Manage user accounts, privileges, and permissions to ensure appropriate access to data.
- Documentation: Keep documentation up-to-date and maintain records of database changes and configurations.
Technical Specialist - HCL Technologies Ltd - Pune
(2021-06 - 2023-02)
Client: UBS, Domain: Investment Banking
- Performance Tuning: Analyze and optimize database performance by adjusting parameters, indexes, and queries. I have used extensions such as pg_stat_statements and pg badger report to find issues.
- Backup and Recovery: Implement and maintain backup and disaster recovery strategies to ensure that data can be recovered in the event of a failure. Here I am using the Simpana tool for backup and restore.
- Security Management: Implement and maintain security measures to ensure data confidentiality, integrity, and availability. I have used various authentication for security purposes, such as certificate-based authentication and LDAP.
- Space Management: Manage disk space usage and allocate additional storage as needed.
- Database Maintenance: Perform routine database maintenance tasks such as index rebuilds and table vacuuming to ensure the smooth functioning of the database.
- User Management: Manage user accounts, privileges, and permissions to ensure appropriate access to data.
- Documentation: Keep documentation up-to-date and maintain records of database changes and configurations.
Sr. Consultant - Entercom Solutions Pvt Ltd - Pune
(2019-04 - 2021-06)
Client: DELL, IBM, Domain: Supply Chain Management
- Developed ETLs as per business logic.
- I have worked with the engineering team to determine the data needs of applications and optimize performance.
- Participated in 24x7 on-call rotation to support critical business applications running on SQL and NoSQL database systems.
- Engaged in short and long-term capacity planning.
- Set up High Availability, partitioning, and Security Solutions.
Sr. DBA (Postgresql/MYSQL/Mongodb) - Verse Innovations Pvt Ltd - Banglore
(2014-07 - 2019-04)
Domain: Content and News.
- Join here as a Database Developer, After six months join the DB team as DBA.
- User Role Management.
- Database Replication.
- Design DB monitoring tool using shell script, Postgresql, and PHP.
- Provide L1(Mongodb), L2(Mysql), and L3(Postgresql) Support in 24X7 environment.
Associate Analyst - Technoplanet Software Pvt Ltd - Ahmednagar
(2013-02 - 2014-06)
Joined Technoplanet as a Project Intern. Work on ASP.NET and MS-SQL Server
- Work in ERP development team.
- Work in freelancing website development team.
