Lead Consultant - SQL Server DBA & HADR - Optimum Info Systems - Hyderabad
(2024-06 - 2026-06)
Client: PayPal – Business Loans. Technologies: SQL Server 2012/2016/2019, Azure SQL, DBAmp
- Managed and optimized MSSQL databases (installation, configuration, and ongoing maintenance) for PayPal's business-critical financial systems.
- Configured and maintained AOAG across SQL Server 2016/2019, monitoring synchronisation health, replica states, and failover readiness; executed both controlled and automatic failovers.
- Configured and managed Replication for data distribution and reporting offload; diagnosed and resolved replication latency, conflicts, and agent failures in production.
- Developed and enhanced T-SQL stored procedures, functions, and triggers to meet evolving business requirements; designed and optimized complex SQL queries, views, and database objects.
- Identified and resolved performance bottlenecks via query optimization, index tuning, execution plan analysis, and database object refinement.
- Performed database capacity planning and resource forecasting for on-premises SQL Server instances, ensuring infrastructure readiness for anticipated data growth.
- Performed database backup, restore, and DR activities ensuring data integrity and high availability SLA compliance.
- Managed DBAmp tool for seamless data integration between SQL Server and Salesforce, including version upgrades and performance tuning.
- Executed SQL Server database migration from SQL Server 2016 to SQL Server 2019.
- Migrated SQL Server databases from on-premises environments to Azure SQL.
- Participated in Windows Server patching cycles, co-ordinating with infrastructure teams to apply OS-level patches to database servers with minimal service disruption.
- Supported compliance audits and maintained documentation in line with regulatory and internal standards.
- Collaborated with Salesforce developers, system administrators, and cross-functional teams to improve database functionality.
Associate Tech Specialist - SQL Server DBA | Azure SQL Migration - TechMahindra - Hyderabad
(2022-10 - 2024-06)
Client: Ernst & Young – GDS Managed Services. Technologies: SQL Server 2016/2019, Azure SQL Database, Azure DMA, Azure Data Studio, Azure Monitor
- Designed and executed a comprehensive Azure SQL migration strategy — from on-premises assessment through to post-migration performance tuning.
- Always On Availability Groups (AOAG): Implemented and managed AOAG for HA/DR; configured, monitored, and troubleshot AOAG replica synchronisation to minimise downtime and maximise data availability.
- Performed end-to-end Azure resource provisioning: Azure SQL Database, Virtual Networks, firewalls, and RBAC security configurations.
- Executed on-premises to Azure migrations using BACPAC export/import, and Azure DMA — ensuring data consistency throughout.
- Performed capacity assessment and right-sizing of Azure SQL tiers (DTU/vCore) based on workload profiling, optimising cost and performance for migrated databases.
- Implemented Azure SQL security best practices: RBAC, auditing, encryption, and monitoring via Azure Monitor and Azure Log Analytics.
- Configured automated Azure SQL backups and point-in-time recovery as part of a robust disaster recovery plan.
- Developed T-SQL stored procedures, functions, views, and database objects to support application development and reporting requirements in development and production environments.
- Co-ordinated with infrastructure teams on Windows Server patch scheduling for database servers, validating post-patch DB service health.
- Worked on SMART tool dashboards (VOC, IDR/EDR reports) and DWH maintenance tasks.
SQL Server DBA |On-Prem & Azure - Evelyn Partners (TS&W) - Liverpool, UK
(2022-04 - 2022-09)
Technologies: SQL Server 2008–2019, Azure SQL
- Administered SQL Server in a hybrid virtual/Azure environment; provided platform support to internal and external developers.
- Managed Backup & Recovery strategies, system health checks, performance tuning, patching, upgrading, and release deployment support.
- Performed capacity management reviews for on-premises SQL Server environments, monitoring disk growth trends, memory utilisation, and CPU patterns to pre-empt resource constraints.
- Automated routine SQL tasks using DBATools (PowerShell).
- Assisted in Windows Server patching for database server estate, ensuring patch compliance and service continuity post-maintenance.
- Supported 3rd party vendors (Wipro, Accenture, Credera) with SQL Server expertise.
SQL Server DBA | Cloud & HADR - Davies Group - Stoke-on-Trent, UK
(2021-06 - 2022-03)
Technologies: SQL Server 2008R2/2012/2014/2016/2017/2019, Azure SQL
- Maintained Azure-based services and existing SQL environments across Dev, Test, Stage, UAT, and Production.
- Log Shipping: Maintained Log Shipping for DR across SQL Server 2008R2–2019; monitored log shipping latency, secondary restore jobs, and managed failover procedures for insurance production databases.
- Designed and implemented cloud strategy; applied patches, service packs, and performance optimisation measures.
- Monitored Azure resource utilisation and performed capacity management for cloud-hosted SQL workloads, adjusting compute and storage tiers to align with business SLAs.
- Administered SolarWinds monitoring tool; managed Problem/Incident/Major Incident workflows.
- Participated in Windows Server patching programmes across the database estate; validated service health post-patching and raised incidents for any regressions.
- Ensured data compliance with GDPR, ISO 27001, and PCI standards across large-scale databases.
- Managed Indexes, Statistics, Execution Plans, and Plan guides and SQL Agent Job maintenance.
SQL Server DBA - Belong Limited - Nantwich, UK
(2021-03 - 2021-06)
Technologies: SQL Server 2008–2017
- Designed, created, and maintained databases in virtual and hosted environments.
- Managed stored procedures, performance tuning, indexing, data extraction, reporting, and migration support.
- Supported Windows Server patching activities for the database server estate in coordination with the infrastructure team.
- Enforced database security policies and production compliance standards in accordance with healthcare regulations.
SQL Server DBA - ADVAM/TNSi - Manchester, UK
(2019-05 - 2021-02)
Technologies: SQL Server 2014–2017
- Managed implementation, configuration, maintenance, and performance of mission-critical SQL Server environments supporting global parking/reservation solutions.
- Collaborated with developers on SQL Server design and schema changes; provided expert T-SQL knowledge.
- Led SQL installation, configuration, and PowerShell-based backup automation to/from AWS S3.
- Monitored production DB instances using automated tools; managed escalations and delivered prompt resolutions.
- Assisted in Windows Server patching for database servers, co-ordinating maintenance windows with minimal client impact.
- Managed and administered Redgate monitoring tool for database performance and health monitoring.
- Clients: NCP, UK/EU/AU/US Airports.
SQL Server Developer|DBA - ProcessWeaver - Crewe, UK
(2015-09 - 2019-04)
Technologies: SQL Server 2012/2014/2016
- Developed and maintained SQL Server database objects — tables, views, stored procedures, functions, and triggers — for a carrier shipment management platform.
- Designed and built complex T-SQL queries, parameterised stored procedures, and user-defined functions to support core application logic and business reporting.
- Implemented SSRS reports and contributed to ETL automation using SSIS packages.
- Conducted query tuning using execution plans and index analysis to optimise high-volume transactional workloads.
- Deployed code to UAT and Production environments; participated in Change Management and requirement analysis.
- Worked across TDD, Agile, and Scrum methodologies; contributed to sprint planning and technical documentation.
Developer - Assurant Solutions - Crewe, UK
(2014-01 - 2015-06)
Technologies: SQL Server 2008/2012, MySQL
- Supported CRM systems; developed T-SQL stored procedures, tables, and views for mobile insurance platforms serving major UK banking clients.
- Wrote complex T-SQL scripts for data manipulation, complex financial data extraction, and ETL processing across multi-source datasets.
- Designed and optimised SQL queries and database schemas to support CRM application requirements and reporting pipelines.
- Developed data cleansing routines and automated data validation scripts to maintain data quality standards.
- Performed data manipulation, cleansing, and reporting across MySQL and SQL Server environments.
- Clients included Barclays, Nationwide, Lloyds, Halifax, TSB Banks, and others.
