Post Job Free
Sign in

Sql Server Data Engineer

Location:
La Canada Flintridge, CA
Posted:
July 21, 2025

Contact this candidate

Resume:

Aspet Golestanian

La Cañada Flintridge, CA *****

818-***-**** ****************@*****.***

linkedin.com/in/aspet-golestanian-namagerdi-3224784 Professional Summary

Lead Database Engineer with 15+ years of experience designing, building, and optimizing scalable, high-performance data infrastructures. Expert in AWS cloud services (DynamoDB, Aurora MySQL, OpenSearch, Redshift, S3), SQL Server, and enterprise-grade ETL solutions. Proven track record leading complex database migrations, architecting ETL pipelines, developing CI/CD frameworks, and mentoring senior engineering teams. Skilled in delivering highly available, fully automated systems to power mission-critical applications. Education

● CSULA, CA – M.S. in Computer Science, 2011

● SBU, Tehran– B.S. in Computer Engineering (Software), 2000 Licenses & Certifications

● AWS Certified Data Engineer – Associate (06/2025)

● AWS Certified Database – Specialty (09/2022)

● Unsupervised Learning, Recommenders, Reinforcement Learning – Stanford Online (09/2024)

● DeepLearning.AI Data Engineering (03/2025)

Technical Expertise

● Databases & Cloud Technologies: AWS DynamoDB, OpenSearch, Aurora MySQL, SQL Server 2019, Redshift, AWS MSK, S3

● Programming & Scripting: Python, T-SQL, PowerShell, Terraform, VB.NET

● ETL & Reporting: AWS Glue, Glue DataBrew, DMS, Step Function, Airflow, Tableau, Quicksight, SSIS, SSRS

● High Availability & Performance: Always On, Transactional & Peer-to-Peer Replication

● Monitoring & Logging: Sumo Logic, New Relic, SQL Sentry

● Automation, DevOps & Workflow Management: Octopus Deploy, AWS Lambda, Jira

Professional Experience

Lead Database Engineer

Stamps.com (El Segundo, CA) / Auctane.com (Austin, TX, Remote) May 2012 – Present

(Following an acquisition in Oct 2021, Stamps.com became a brand under Auctane.com; continued in the same role with unchanged responsibilities.) Tech Stack: SQL Server 2019, AWS (DynamoDB, OpenSearch, Aurora MySQL), Python, PowerShell

● Designed and implemented scalable DynamoDB tables to support high-throughput e-commerce transactions.

● Optimized indexing strategy in AWS OpenSearch, improving search query performance by 30%.

● Designed and implemented ETL processes for data synchronization across DynamoDB, S3, SQL Server, and Aurora MySQL, reducing sync time by over 50%.

● Led large-scale database migrations (e.g., SQL Server to Aurora MySQL) reducing infrastructure cost by 40% and improving scalability.

● Developed ETL pipelines using AWS Glue, Airflow, AWS DMS, and SSIS to streamline data flow across cloud platforms, reducing data sync latency by 30%.

● Developed and maintained stored procedures, tables, and UDFs in MS SQL Server 2019.

● Built and maintained Aurora MySQL database objects to enable high-availability transactional processing.

● Optimized stored procedures and UDFs in Aurora MySQL and SQL Server, reducing query execution time by 40%.

● Automated SQL and operational alerts using AWS Lambda and Python, enabling real-time monitoring of data anomalies.

● Built CI/CD pipelines using PowerShell and Octopus Deploy, cutting deployment time by 30%.

● Created custom reports to streamline financial analysis for the finance department

● Architected HA solutions by configuring Always On groups and transactional replication, ensuring 99.999% database uptime.

● Configured AWS CloudWatch monitoring and alerting for database services and infrastructure.

● Led a team of five senior database engineers, overseeing project delivery, code quality, and system architecture improvements.

● Configured AWS IAM roles and policies to securely manage access control for services such as Lambda, S3, Glue, and DMS

Database Developer / DBA

UNX - Burbank, CA (On-Site)

August 2008 – May 2012

Tech Stack: SQL Server 2008/2008 R2

● Designed and implemented stored procedures, indexes, and views in SQL Server 2008 R2, improving query response time by 35%.

● Administered SQL Server 2008 R2 environments across production and staging, ensuring 99.9999% system uptime.

● Built automated ETL workflows using SSIS to support nightly data warehousing and reporting operations.

● Maintained transactional replication and log shipping for real-time data synchronization and disaster recovery readiness.

● Led legacy database migrations from SQL Server 2000/2005 to 2008 R2, enabling improved performance and supportability.

● Migrated legacy reports from C# to SSRS 2008, reducing development time for reporting changes by 50%.

● Coordinated and managed database release cycles across Dev, QA, and Prod, ensuring compliance with SDLC and minimizing downtime. Database Engineer

RISARC – Burbank, CA (On-Site)

May 2007 – August 2008

Tech Stack: SQL Server 2005, VB.NET, ASP.NET, Crystal Reports 9

● Designed and developed a custom accounting application using VB.NET and SQL Server 2005, streamlining financial reporting for internal stakeholders.

● Built ETL pipelines using SQL Server DTS to automate data transfers from disparate sources, reducing manual effort by 60%.

● Configured transactional replication and log shipping to ensure data consistency and enable high-availability for client-facing applications.

● Engineered backend components—stored procedures, views, SSIS packages—to support business-critical reporting and application logic. References:

available upon request.



Contact this candidate