Subham Divyajyoti

Business and Data Analyst

Zolostays•  July 2022 - April 2024•  Bangalore

PostgreSQL Database Administrator | ZoloStays 2022-2024 Managed and maintained PostgreSQL databases, ensuring high performance, availability, and security. Implemented database backup and recovery strategies to protect critical data and ensure data integrity. Monitored database performance, tuned queries, and optimized data storage through the design and implementation of schemas, indexes, and partitioning. Administered and supported PostgreSQL databases, including installation, configuration, and upgrades. Conducted regular database health checks and maintenance tasks to ensure system stability and minimize downtime. Developed automation scripts using Python for routine database tasks. Collaborated with development teams to provide database support for application development and deployment. Provided database support for data analytics and business intelligence projects using Tableau and Power BI. Ensured data integrity and security through user access controls and encryption, and developed and maintained database documentation. Troubleshot and resolved database issues, collaborating with cross-functional teams to understand database requirements and deliver solutions. Migrated databases from other database management systems to PostgreSQL, ensuring compatibility and performance optimization. Monitored database performance using tools like pgAdmin, pg_stat_statements, and other PostgreSQL monitoring tools. Identified and resolved database issues such as deadlocks, slow queries, and connection problems. Implemented security measures including user authentication, role-based access control, and data encryption. Ensured database compliance with industry standards and regulations, such as GDPR and HIPAA, by implementing appropriate data protection measures.

Junior Database Administrator

Vedantu•  June 2019 - June 2022•  Bangalore

Assisted in the management and maintenance of PostgreSQL and SQL databases. Performed routine database backups and restores, ensuring data availability and recoverability. Monitored database performance and executed performance-tuning tasks. Supported database development and deployment activities. Documented database procedures and maintenance activities. Data Analyst Generated over 50 daily and monthly reports on B2B calls, leads, sales, and performance metrics, while developing more than 30 dashboards for insights into demo performance and sales metrics by using Excel, Google Sheets and PowerBI. Conducted quality assurance testing on reporting solutions, ensuring accuracy and reliability. Documented all programming activities, coding standards, and best practices for future reference. Collaborated with stakeholders, product teams, and customers throughout the system development life cycle to meet business needs. Assisted in tracking sales metrics, identifying growth opportunities, and optimizing strategies to enhance performance. Managed a team of 100 outsourced employees, optimizing operations and sales performance, and produced over 10 reports evaluating the Sales Development Manager (SDM) team's performance for targeted coaching.