Designed and developed efficient ETL processes for data ingestion, integration, and analytics. Designed and implemented data models and databases for data storage and analysis. Created and maintained streaming and batch-oriented solutions. Analyzed data quality requirements and designed data quality processes. Monitored data performance issues and troubleshooted them. Developed custom and complex scripts to automate data engineering processes. Configured, deployed, and maintained databases and software technologies for data engineering processes.

Successfully created and maintained automated CI/CD pipelines. Developed, maintained, and optimized database reliability processes and procedures for improved reliability. Wrote complex T-SQL scripts to carry out database management automation tasks. Performed periodic code reviews and provided feedback to ensure high-quality, efficient, well-tested, and documented code. Optimized database backup and recovery processes, reducing recovery time by 30% through automation. Achieved 90% availability for a mission-critical database cluster by implementing automated AG processes. Improved database uptime by 15% through proactive monitoring and maintenance.

Created new and improved existing Stored Procedures with complex business logic. Reviewed the existing SQL code from other team members. Carried out Unit Tests using the tSQLt framework for existing Stored Procedures. Managed source code for database projects using Git. Carried out and troubleshooted database deployment from Visual Studio via Dacpac. Created and maintained database snapshots. Used custom and Redgate third-party tools to test new features and validate existing logic.

Examined legacy databases to comprehend and document their design and object dependency. Wrote custom SQL scripts for each impacted object to be migrated and ensure data integrity. Developed admin-related Stored Procedures to aid with the auto-generation/pull of new objects. Used SQL Server third-party tools from Redgate for day-to-day productivity. Managed repository using Git and Azure DevOps. Designed and executed Unit Tests against cloned databases to identify performance bottlenecks.

Installed and configured MS SQL Server on Windows 2008/2012 servers. Provided technical documentation for DBA standards and procedures. Contributed to information management by applying expertise in backup restore processes and user access. Orchestrated database patching and upgrades to ensure operational stability. Troubleshot and fixed database server-related issues. Automated manual processes with PowerShell and SQL. Supported database functionalities by designing and coding utilities with the aid of cursors, dynamic SQL, and temporary tables.