Sr. Consultant, Technology Infrastructure And Support, Sql Server Technology
Demonstrate service delivery excellence expertise across several technology paradigms to establish a proven track record SQL incident management, database optimization, and performance tuning (starting with SQL 2012 to 2019). Contribute to driving revenue and client confidence making trust possible through technology through problem management and service disruption mitigation management. I Drive innovation though automation and collaboration as a thought leader collaborating with regional and… Show more Demonstrate service delivery excellence expertise across several technology paradigms to establish a proven track record SQL incident management, database optimization, and performance tuning (starting with SQL 2012 to 2019). Contribute to driving revenue and client confidence making trust possible through technology through problem management and service disruption mitigation management. I Drive innovation though automation and collaboration as a thought leader collaborating with regional and global colleagues focusing on SQL server solutions, AWS cloud EC2/RDS/Lambda services and CI/CD Pipeline with Ansible, Terraform and Jenkins. Provide technical leadership in root cause analysis and resolution procedures taking problem prevention initiative and leveraging automation example: HADR intervention to address SQL AlwaysOn HADR Sync Commit Waits.• SQL Server Administration, Migration, and Optimization:o Proposed and implemented strategic database optimizations, including index strategy modifications and SQL performance tuning, to prevent transaction failures and improve database transaction processing efficiency.o Led transition from SQL 2012 to 2016/2019 for business-critical applications, enhancing system performance and mitigating repeated I/O latency in VM abstraction layers.o Leveraged Quest Foglight and SQL Optimizer for SQL performance problem analysis, resolution, and query tuning, improving application performance and up time for business-critical applications within the US as well as India, LATAM, South Africa, Hong Kong, Philippines, Canada, and UK.o Globally introduced Quest SQL Optimizer tool to optimize database performance, reducing CPU utilization and enhancing system efficiency. This solution allowed development teams to quickly identified less than idea performing code and quickly identify options for optimization with zero impact to production activity. Show less