Jahnavi Puri

Database Management & Optimization:

• Designed, developed, and optimized SQL queries across Oracle and PostgreSQL to manage large-scale transactional and analytical data.
• Implemented advanced SQL techniques such as CTEs, subqueries, and functions to optimize reporting and performance.
• Conducted data normalization, denormalization, and indexing to improve query performance and ensure efficient data storage.
• Performed root cause analysis and troubleshooting of database-related performance issues, leading to a 25% improvement in query execution time.
• Applied advanced indexing strategies (e.g., composite, full-text, spatial indexes) to enhance data retrieval times and minimize database lock contention.
• Monitored and tuned database performance using profiling tools (e.g., EXPLAIN), and implemented automatic job scheduling for regular database maintenance tasks.

Security, Backup, & Recovery:

• Automated backup processes and maintained high-availability configurations (e.g., replication, clustering) to reduce downtime and mitigate data loss risks.
• Collaborated with the IT team on disaster recovery strategies, and successfully tested failover scenarios, ensuring minimal disruption to services.

Client Support & Troubleshooting:

• Created and automated customized reports and key performance indicators (KPIs) to provide real-time insights into system health, resulting in increased operational efficiency.
• Provided responsive technical support for database issues, ensuring zero downtime during critical business hours.
• Analyzed and optimized slow-performing queries, reduced execution times by up to 40%, and ensured the system operated at peak performance.

Collaboration & Documentation:

• Collaborated with development teams to ensure that database schemas aligned with application requirements, supporting seamless integrations.
• Created detailed documentation for database design patterns, troubleshooting guides, and backup procedures, improving knowledge sharing across the team.
• Worked with cross-functional teams to optimize data pipelines, streamline workflows, and enhance data accessibility.