Mahak Agrawal

Results-driven SQL Developer with 3+ years of hands-on experience specializing in PostgreSQL, MySQL, and Microsoft SQL Server. Proven expertise in writing complex SQL queries, stored procedures, functions, and triggers, along with query optimization, indexing, and database design. Skilled at diagnosing and resolving performance bottlenecks to keep systems fast, reliable, and accurate.

SQL Developer at Xtracap Fintech Pvt Ltd (2025-02 – Present)

• Wrote and optimized complex SQL queries, stored procedures, and functions for a fintech production database.
• Performed database backups using pg_dump and pg_basebackup to ensure data safety and zero data loss.
• Led database migrations and upgrades using EXPLAIN ANALYZE for in-depth query optimization.
• Diagnosed and resolved query performance bottlenecks through indexing strategies and query refactoring.
• Coordinated with Support, Credit, and CBD teams for issue resolution and manual case processing.
• Managed customer onboarding (T2) by validating financial data using SQL and identifying data discrepancies, guiding customers through corrections.

SQL Developer at Sikarwar Tech Services (2022-10 – 2025-02)

• Wrote and maintained SQL queries, stored procedures, and reports for 30+ production databases.
• Set up local PostgreSQL database instances, configured users/roles, and managed permissions.
• Supported routine backup and recovery operations using mysqldump and pg_dump, ensuring data safety during deployments.
• Performed regular query optimization; benchmarked queries using EXPLAIN plans and execution statistics to reduce latency and improve throughput.
• Designed and maintained normalized database schemas, stored procedures, functions, views, triggers, DDL, DML commands and indexes; led schema refactoring initiatives to improve scalability.
• Managed databases using Microsoft SQL Server and PostgreSQL, focusing on data integrity.
• Conducted data purging and archiving using retention policies to improve system performance.
• Delivered reports and automated routine SQL-based tasks for reporting and log management.

Post Graduation – Mahendra Pratap University, Aligarh, Uttar Pradesh (2024 – 2026)

Bachelor of Science – Dayal Bagh Educational Institute, Agra, Uttar Pradesh (2019 – 2022)

Senior Secondary Education – St. Vivekanand Public School, Sadabad, Hathras (2017 – 2019)