Akash Pujari
Pune
Summary
Database Administrator with extensive experience in PostgreSQL optimization and performance tuning at Neosoft Technologies. Achieved significant improvements in data integrity and security through effective collaboration with development teams. Expertise in database backup and recovery, maintaining 99.9% uptime and ensuring seamless operations. Proficient in Apache Superset for advanced data visualization.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Database Administrator
Neosoft Technologies Pvt. Ltd
Pune
05.2025 - Current
- Company Overview: Client: FirstCry.com
- Implemented Logical and Streaming Replication Migration for PostgreSQL databases, enabling smooth transitions with minimal downtime and high data integrity.
- Monitored and optimized vacuum/auto-vacuum processes, reducing table bloat and improving query response times.
- Configured and managed WAL (Write Ahead Log) server monitoring, strengthening disaster recovery capabilities and ensuring log efficiency.
- Performed database performance tuning, query optimization, and troubleshooting, improving system stability and ensuring 99.9% uptime.
- Partnered with development teams to design scalable database structures, aligning with business growth and future requirements.
- Client: FirstCry.com
Database Administrator
Manlitics B2B ITES Pvt.Ltd
Pune
01.2023 - 05.2025
- Administered and maintained PostgreSQL databases, ensuring data integrity, security, and optimal performance.
- Managed and maintained PostgreSQL databases to keep data secure, accurate, and running smoothly.
- Conducted data mining and management to gather insights that help with business decisions.
- Improved database performance by optimizing queries and structures, making data retrieval faster.
- Worked with development teams to design and implement database structures and code.
- Monitored the database and solved problems to keep everything running without interruptions.
- Hands-on experience with Apache Superset: - Utilized Apache Superset for data exploration, analysis, and creating interactive visualizations.
Data Research Analyst
Manlitics B2B Ites
Pune
06.2022 - 01.2023
- Improved data accuracy by conducting in-depth research and analysis on industry and market behavior.
- Conduct weekly ad-hoc data requests for external team members using Excel and SQL Queries.
- Used advance Microsoft excel to create pivot tables and pivot reporting, as well as VLOOKUP, HLOOKUP and XLOOKUP Function.
Data Research Analyst
Flexisales Marketing Pvt. Ltd
Pune
08.2021 - 05.2022
- Use tools like Apify, Skrapp.io, and Phantom buster to gather LinkedIn data and build databases for business needs.
- Clean and process data with automation tools for accuracy.
- Continuously improve extraction and organization methods.
Education
Bachelor of Business Administration - BCA
Savitribai Phule Pune University
Pune, Maharashtra01.2021
Skills
- Advance Excel
- Campaign execution
- PostgreSQL and MySQL
- SSMS and Power BI
- Database optimization and tuning
- Data mining and integrity
- Backup and recovery strategies
- Schema design and security
Certification
- SQL for Data Analysis (Advance SQL Certification), Simplilearn, 03/01/25
- Diploma in MySQL and Statistics for Data Analysis, 03/01/25
- Certification in SQL (ADVANCE), Hacker-rank, 03/01/25
- Certification in SQL (Intermediate), Hacker-rank, 01/01/25
- Introduction to SQL, Simplilearn, 06/01/24
- Power BI Projects, Great Learning Academy, 2024
Projects
E-Commerce Sales Dashboard (Power BI), Developed a comprehensive sales dashboard to track customer behavior and predict market trends. Delivered actionable KPIs to stakeholders, improving decision-making processes by 25%. Netflix Data Analysis Using SQL (PostgreSQL), Conducted an advanced SQL project analyzing Netflix’s content library. Extracted insights into content trends, viewership patterns, and production decisions.
Timeline
Database Administrator
Neosoft Technologies Pvt. Ltd
05.2025 - Current
Database Administrator
Manlitics B2B ITES Pvt.Ltd
01.2023 - 05.2025
Data Research Analyst
Manlitics B2B Ites
06.2022 - 01.2023
Data Research Analyst
Flexisales Marketing Pvt. Ltd
08.2021 - 05.2022
Bachelor of Business Administration - BCA
Savitribai Phule Pune University