Ashish Srivastava

Migrating complex IBM DB2 stored procedures into Dataform SQLX models, enabling scalable and cloud-native data transformations in BigQuery. Designing and orchestrating real-time and batch data pipelines using Pub/Sub, Dataflow, Airflow Composer, and Cloud Functions. Automating ETL workflows and CI/CD tasks with Python, PowerShell, and MS SQL, improving efficiency and reducing manual work. Implementing automated reporting solutions using PyAutoGUI and MSS to capture and email dashboards with zero manual effort. Using Cloud Monitoring and Logging for proactive pipeline health checks, job failure alerts, and performance tuning across GCP services. Performing distributed data processing with PySpark in Dataproc, optimizing large-scale data transformation and analytics workloads.

Managed MS SQL Server services including Database Engine across production and development environments. Handled database mirroring, log shipping, replication, and configured disaster recovery (DR) and high availability solutions. Performed regular backups, restores, and implemented automated maintenance plans for index fragmentation and stats updates. Tuned performance by analyzing query plans, resolving blocking/deadlocks, and optimizing indexes and stored procedures. Automated tasks using SQL Agent jobs and PowerShell, managed security, access controls, and ensured compliance and audit readiness.