Sundar Shrestha
Houston,TX
Summary
Accomplished Database Developer with extensive experience in architecting and optimizing high-performance database solutions. Successfully unified disparate systems into a single AWS cloud architecture with zero data loss, automating data loading for operational analytics. Proven track record of enhancing query performance and reducing report generation time significantly.
Overview
10
10
years of professional experience
1
1
Certification
Work History
SQL Developer
T-Mobile
Frisco, TX
07.2021 - Current
- Spearheaded corporate merger data migration, unifying database systems into AWS cloud architecture with zero data loss.
- Automated enterprise data loading into PostgreSQL and Snowflake, facilitating business intelligence and operational analytics.
- Designed scalable ETL pipelines using Apache Kafka for real-time streaming and AWS Lambda for event-driven processing.
- Developed PL/pgSQL functions and procedures for banking transaction processing and automated regulatory reporting.
- Engineered migration of NoSQL data from AWS DynamoDB to MongoDB, optimizing document schemas for improved querying.
- Optimized PostgreSQL performance through execution plan analysis and composite indexing, reducing slow queries by 60%.
- Conducted regular data quality audits to ensure accuracy, consistency, and compliance with security protocols.
- Collaborated with cross-functional teams to gather requirements, translating business needs into technical specifications.
Database Developer
Change Healthcare
01.2016 - 07.2021
- Architected and executed phased migration from legacy Oracle systems to AWS PostgreSQL, reducing licensing costs while optimizing performance.
- Led modernization of legacy infrastructure, transitioning on-premises databases to Amazon RDS, enhancing scalability and minimizing maintenance overhead.
- Optimized high-volume transactional queries for reporting dashboards, decreasing report generation time from 12 minutes to under 4 minutes.
- Developed advanced database functions and stored procedures to automate data transformation, reducing data preparation time by 40%.
- Created PL/pgSQL validation scripts and reconciliation processes to ensure data consistency during QA testing and UAT releases.
- Collaborated with backend application teams, QA engineers, and stakeholders in an agile environment for stable database releases.
- Maintained data integrity through regular audits, optimized queries, and implemented security measures for sensitive healthcare information.
- Documented database processes and provided training to junior developers on best practices in database management.
Education
Bachelor of Science - Computer Science
University of Houston
Houston, TX01-2016
Skills
- SQL
- PostgreSQL
- PL/pgSQL
- T-SQL
- DDL/DML
- Stored Procedures
- Triggers
- Materialized Views
- Query Optimization
- Execution Plan Analysis
- EXPLAIN ANALYZE
- Indexing Strategies
- Partitioning
- ETL Pipelines
- ETL design
- Data Transformation
- Validation
- AWS services expertise
- AWS RDS management
- Cloud migration
- PostgreSQL tuning
- MS SQL Server
- MongoDB
- NoSQL management
- Performance monitoring
- Linux (Ubuntu, RHEL)
- Unix Shell Scripting
- Python
- PySpark
- Git
- Version control systems
- CI/CD Pipelines
- Agile/Scrum
- Problem solving
- Backup and recovery
- Data analytics
- Backup and recovery
- Version control systems
- Performance monitoring
Certification
- AWS Certified Database - Specialty
- AWS Certified Solutions Architect - Associate
- PostgreSQL 15 Certified Professional
Timeline
SQL Developer
T-Mobile
07.2021 - Current
Database Developer
Change Healthcare
01.2016 - 07.2021
Bachelor of Science - Computer Science
University of Houston