Swarn Singh
Summary
Database Specialist with 20 years of experience in designing and implementing enterprise data solutions across various platforms including SQL Server, DB2, and cloud databases on Azure and AWS. Expertise in database design, high availability, disaster recovery, and performance tuning, with a strong focus on security and migration. Proven track record of integrating databases into DevOps pipelines using tools such as Ansible and PowerShell, enhancing automation and efficiency. Skilled in leading cross-functional teams to optimize systems and align technical initiatives with business objectives.
Overview
20
20
years of professional experience
8
8
Certification
Work History
Database Specialist
Datacom
09.2013 - Current
- Specialized in SQL Server (2000–2022) with a strong focus on performance optimization, query tuning, and workload analysis.
- Led database migrations to Azure and AWS using tools such as Azure DMS, SSIS, AWS DMS/SCT, and AWS Data Pipeline/Glue.
- Successfully managed cross-platform migrations, including SQL Server to DB2 and Sybase.
- Designed and implemented high availability (HA/DR) solutions using Always On, Replication, Mirroring, and Log Shipping across Linux distributions (RedHat, CentOS, Ubuntu).
- Performed data analysis to support capacity planning, indexing strategies, and storage optimization.
- Developed analytical SQL scripts and stored procedures for ad hoc reporting and business insight generation.
- Automated database operations using Ansible, PowerShell, PowerShell DSC, Bash, and native DB tools.
- Deployed databases in containerized environments using Docker and Podman.
- Built DevOps pipelines for database deployments with Flyway, GitHub, GitLab CI, and Azure DevOps.
- Improved collaboration and delivery using GitHub, Jira, Confluence, and Miro.
- Created dashboards and audit reports using SSRS, Power BI, and SQL-based reporting frameworks.
- Conducted regular database health checks, data profiling, and security assessments to ensure integrity and compliance.
- Leveraged Azure Automation and Runbooks for managing Azure SQL, and AWS RDS automation via CloudWatch, Lambda, and CloudFormation.
- Deep experience in SQL Server on Linux with HA/DR configuration and troubleshooting.
Database Consultant
Tech Mahindra
New Delhi, Delhi, India
12.2011 - 08.2013
- Company Overview: vCustomer International has been taken over by Mahindra Satyam company which is Top 5 IT company in India and have presence in 100 countries worldwide.
- Project progress monitoring and feasibility reports
- Deploying functional solutions
- Team mentoring
- System Analysis from SDLC to design for new systems
- Database Design and Modelling
- Database Management, Administration and cleaning
- Database Memory Management
- Database Change Management
- Business Analytical reports
- Work force Management reports and data Analysis
- Call data application management
- Remote Agent monitoring application
- Database Maintenance
- High Availability Solutions
- Clustering
- Licensing
- Database Consolidation and Visualization
- DW / ETL design and Development
- Disaster Recovery
- Optimization and Performance management.
- Data Migration - SQL Server to MySQL and MySQL to SQL Server
Database Engineer
VCustomer India Service Pvt Ltd
New Delhi, INDIA
04.2008 - 11.2011
- Project management - Monitoring and Reports
- Deploy functional solutions
- Develop client proposals and manage client interfaces
- Team Management
- Database Design and Modelling
- Database management
- Database change management
- Produce business analytical reports
- Generate workforce management reports and conduct data analysis
- Manage call data applications
- Develop and maintain Customer Relationship Management (CRM) systems
- Remote agent monitoring applications
- Database maintenance
- High availability solutions and strategies (replication, mirroring, log shipping)
- Manage licensing
- Execute consolidation and virtualisation strategies
- Develop business intelligence solutions
- Disaster recovery strategies and Implementation
- Database Optimization and performance
- Facilitate data migration between SQL Server and MySQL (SQL Server to MySQL and MySQL to SQL Server)
- Work with MS SQL Server (2000, 2005, 2008, 2008 R2), Oracle 9i, and MySQL
- Implement ITIL processes
- Utilize open-source technologies such as MySQl, Asterisk, Talend, JavaScript, JScript, PL\SQL, Pascal, Perl, JasperReports, Pentaho, PHP and phpMyAdmin
Education
BSc (Hons) - Computer Science And Information Systems
University of Derby
01.1999
Bachelor of Arts - History (Hons)
Delhi University
New DelhiSkills
- Cloud and Emerging Database Technologies - Database Management Serverless Databases Migration Strategies - Azure and AWS
- Integration and Agile Development - AI Database Integration Agile Database Development
- SQL Failover Clustering and Database High Availability
- Backup, Recovery, and Disaster Planning
- Database Security and Compliance
- Performance Tuning and Monitoring and Reporting
- Data Migration and ETL Processes
- Data Analytics & Database Modelling
- Indexes and Statistics Strategy
- Capacity and Storage Planning
- DevOps & Automation - Ansible AWX Bash GitHub CI/CD Jira Confluence Flyway PowerShell DBATools
- Multiple DBMS - MS SQL Server, DB2, Sybase, MySQL, PostgreSQL, Mongo, NoSQL
- Business Intelligence & ETL - SSIS SSRS SSAS Azure AWS
- Container - Docker Podman Microsoft Cloud
- Scripting and Automation
- Data Warehouse
- Database Best Practices, Policies and Standards
- Teamwork
- Communication
- Continuous Learning
- Documentation
Languages
English Professional
Full Professional
Hindi Professional
Full Professional
Spanish
Elementary
Urdu
Limited Working
INDUSTRY EXPERIENCE
- Government - Defence | Social Development | Parliament | MBIE | DIA | Natural Hazards Commission |
- Banking
- Manufacturing
- Insurance
- Hospitality
- Education
- Retail
- Transport
- Treasury
- Finance
Certification
- BIGFIX Foundation BESFND101 - Issued Feb 16 2025
- Microsoft Certified: Azure Administrator Associate Microsoft https://www.credly.com/badges/43b38810-1051-415d-8ff8-cd5da51e96eb/public_url - Issued Mar 2022 · Expires Mar 2026
- Microsoft Certified: Azure Administrator Associate https://www.credly.com/badges/43b38810-1051-415d-8ff8-cd5da51e96eb?source=linked_in_profile - Issued Mar 2022 · Expires Mar 2026
Accomplishments
- Database - Specialty (DBS-C01) ▪ Linux Academy https://linuxacademy.com/profile/u/cert/id/440853
- Learn AWS by Doing ▪ Linux Academy https://linuxacademy.com/profile/u/cert/id/439465
- Agile Project Planning ▪ Skillsoft https://www.credential.net/06d08e30-11d2-4013-a6ad-a5c6a6a27e1a#gs.dg4uek
- The Essential Role of the Agile Product Owner - Skillsoft - https://www.credential.net/5f36f705-4e72-4ef6-9f9e-f783df1c2895#gs.dg4wrj
- Agile Principles and Methodologies - Skillsoft - https://www.credential.net/d1dcd4fc-de5a-4025-8368-ae76faea866a#gs.dg4y4c
- Agile Stakeholder Engagement and Team Development - Skillsoft - https://www.credential.net/166a743c-cc58-46c6-bb1a-dafc8ecb7205#gs.dg4vpk
- ICAgile Certified Professional - Foundations of DevOps (ICP-FDO)
- ITIL Foundation Level ▪ AXELOS Global Best Practice
Timeline
Database Specialist
Datacom
09.2013 - Current
Database Consultant
Tech Mahindra
12.2011 - 08.2013
Database Engineer
VCustomer India Service Pvt Ltd
04.2008 - 11.2011
BSc (Hons) - Computer Science And Information Systems
University of Derby
Bachelor of Arts - History (Hons)
Delhi University