Ankur Sinha
Cloud Database Engineer
Noida,Uttar Pradesh
Summary
A highly skilled Cloud database engineer with over 14+ years of experience in Sybase ASE, Sybase IQ, Replication, HADR, Warm standby, MSSQL and Oracle database administration. Throughout my career, I have developed expertise in incident/request/change management, technical support, and problem-solving within key AWS and Azure services. My current role as an Engineering Architect with Azure Cloud Database and Cloud migration responsibilities at Microsoft has provided me with valuable insights and hands-on experience in Azure cloud and on-prem data modernization.
I have had the opportunity to work with various clients, including prestigious organizations e.g. Microsoft Corp., Zurich Insurance, Cadent Gas Ltd., Bank of America, Proximus, and Moody's. My expertise extends to installation, upgradation and service pack rollouts, covering MSSQL, Sybase, Replication, and HADR databases.
My technical skills encompass a wide range of database management systems and cloud platforms. I possess extensive knowledge of MSSQL versions 2014/2016/2017/2019/2022, Sybase ASE versions 12.x/15.x/16.x, and Oracle Database versions 11g/12C/19C. Additionally, I have hands-on experience with warm standby and replication, MSA, upgrade processes, patching, and migration. My proficiency extends to utilizing Azure VM functions, Hashicorp Terraform, Terraform Cloud, Azure DevOps, CI/CD pipelines, high availability configurations, IAAS and PAAS services, shell scripting, and HADR configuration. Furthermore, I possess efficient knowledge of AWS cloud computing, having worked extensively with key services such as EC2, VPC, S3, Load Balancers, RDS, and IAM, among others.
Throughout my career, I have consistently contributed to the improvement and maintenance of databases, successfully rolling out upgrades and implementing effective solutions. I have demonstrated expertise in production support, database recovery and backup, performance tuning, and job automation using Autosys and crontab schedulers. My commitment to efficiency and automation has led to the reduction of alerts and enhanced operational effectiveness.
With my extensive experience in cloud database engineering and a strong technical skill set, I am equipped to tackle complex challenges and drive impactful solutions. I am open to new opportunities and collaborations where I can leverage my expertise to deliver high-quality results. Feel free to connect with me to explore potential synergies or discuss any database-related endeavors.
Overview
14
14
years of professional experience
13
13
Certification
Work History
Engineering Architect
Microsoft
12.2024 - Current
- As a Cloud Database Administrator, I specialize in migrating databases from legacy systems like Sybase ASE and Sybase IQ to Microsoft SQL Server, leveraging both on-premises and cloud environments.
- My work primarily focuses on Azure Virtual Machines (VMs) and Azure Data Factory (ADF), ensuring efficient, secure, and scalable data migration.
- I use tools such as SQL Server Migration Assistant (SSMA) and SQL Server Integration Services (SSIS) to design and execute migration processes.
- This involves schema extraction, data transformation, validation, and load procedures to ensure data integrity and minimal downtime during migration.
- With Azure Data Factory, I build and manage data pipelines, integrating various data sources and orchestrating workflows for seamless migration.
- Automation, monitoring, and optimization are key aspects of the cloud-based migration strategy I implement.
- A significant part of my role is performance benchmarking, where I compare throughput, data load speed, and transaction efficiency between on-premises setups and cloud VMs.
- These assessments help in identifying bottlenecks, fine-tuning configurations, and improving overall migration performance.
- Post-migration, I conduct analysis to troubleshoot issues, optimize configurations, and ensure the databases operate at peak efficiency while adhering to security and compliance standards.
- By enabling organizations to transition from outdated systems to modern cloud environments, I help drive operational agility, scalability, and improved data management, ensuring seamless migrations with measurable improvements in performance.
Cloud Database Administrator
HCLTech
London, England
07.2022 - 11.2024
- Designed and implemented highly available and scalable cloud architectures using AWS services such as EC2, VPC, Subnet, Availability Zones, S3, EBS, FSX, Load Balancers, Glacier, ECS, RDS, Aurora, DMS, Babelfish, Babelfish Compass, SCT, AWS Backup, Lambda, IAM, IAM SSO, CloudTrail, Cloud Watch, SNS, SQS, Control Tower and Route53 using Terraform.
- Designed and implemented cloud security solutions using AWS Identity and Access Management (IAM), Security Groups, Network ACLs.
- Optimized the performance of cloud-based applications using AWS services like Elastic Load Balancing (ELB), Auto Scaling.
- Worked with DevOps teams to design and implement continuous integration and delivery (CI/CD) pipelines, Terraform, BitBucket, Terraform Cloud, Azure Devops and Packers.
- Written shell scripts to export/import database backups from RDS and keep the same in S3.
- Developing new modules like Lambda function to start/stop RDS weekly.
- Database migration from Onprem to RDS.
- Database migration from S3 bucket to RDS.
Lead Database Administrator
HCLTech
Noida, Uttar Pradesh
08.2019 - 06.2022
- Building of New Sybase ASE 16 Servers with/without ASE cockpit.
- Sybase ASE upgrades and patching from 16.0 SP03 PL06 and 16.0 SP03 PL09.
- Diagnose and troubleshoot the Production Server on the fly. Bypass recovery, Log suicide method responding to alerts received via mail.
- Monitoring memory, processor, Disk I/O, user connections, locks.
- Reorganization of table by rebuilding its clustered indexes after high volume inserts, updates, deletes.
- Working as Senior Sybase DBA and involved in 24/7 production support database services management of over 100+ Sybase ASE servers, and ASE Databases including all 5 environments.
- Configuring ASE cockpit on Production environment.
- Creating Database and Device: Initializing database devices, Creating/altering/dropping Database.
- Creating database level automation scripts for update stats and alert generation using crontab.
- DB Performance Management and Tuning Sybase ASE and HADR replication database.
- Installation of HADR replication server.
- Responsible for ensuring high availability and performance of the databases.
- Creating stored procedures.
- Proactive Database Performance Monitoring.
- Perform data refresh from production systems, wherever the infrastructure is available.
- Interacting directly with customers through any media like emails, chats or through calls to take judgment and make the majority of day to day decisions to prevent escalations.
- Using UNIX (Suse Linux) as Operating System and SNOW as ticketing tool and Service requests or CRQ for Production changes.
- Apart from day to day activities I have also completed AWS, GCP, Azure KT session as cross platform training to gain knowledge on Cloud base.
Analyst II System Administrator
Bank of America
Gurgaon, Haryana
10.2016 - 07.2019
- Working as Senior Analyst and Sybase DBA on database services management of over 1000 Sybase ASE servers, 3000 Sybase Databases including all 5 environments.
- Responsible for improvement and maintenance of the databases to include rollout and upgrades.
- Clearing the tempdb by Truncating the tables as when required.
- Gathering defragmentation report and providing recommendations.
- Daily database maintenance activities.
- DB Performance Management - Pro-active and Tuning Sybase ASE and replication database.
- Responsible for ensuring availability and performance of the databases.
- Perform data refresh from production systems, wherever the infrastructure is available.
- Provide senior database administration consulting expertise in the areas of SybaseASE and replication Servers.
- Using UNIX (Sun Solaris) as Operating System and HPSM, filezilla, DBArtisan as monitoring tool.
- Using ITSM as ticketing tool. Nexus for Work requests and CRQ for Production changes.
- Foglight for Blackouts and Monitoring.
Senior System Engineer
Infosys
Pune Area
04.2015 - 10.2016
- One of Senior Consultants on a Database Services team specializing in remote and on site database services management of over 100 Sybase ASE servers, 280 Sybase Databases including all 5 environments.
- Responsible for improvement and maintenance of the databases to include rollout and upgrades.
- DB Performance Management - Pro-active and Tuning Sybase ASE and replication database.
- Responsible for ensuring availability and performance of the databases.
- Perform data refresh from production systems, wherever the infrastructure is available.
- Database troubleshooting and problem root cause analysis.
- Problem management.
- Provide senior database administration consulting expertise in the areas of SybaseASE and replication Servers.
- Using UNIX (Sun Solaris) as Operating System and HPSM, filezilla, DBArtisan as monitoring tool.
- Working on tools like Putty, HPSM, IMD etc.
Software Engineer
Syntel
Mumbai
12.2011 - 03.2015
- A project to enhance the Rating monitoring process for improving the data in order to significantly reduce the rejects and incompletes registration.
- Take corrective action as indicated by the resolution team or by using existing incident scripts coordinate incident calls by analyzing the issue and determining the necessary participants.
- Worked on client Tools like OPAS BMC Remedy, Rapid SQL and Word forge and having a decent knowledge of these tools.
- Technically worked on Sybase and SQL database and gained good knowledge of business.
Education
Bachelor of Technology (B.Tech.) - Information Technology
IET ALWAR
07.2011
Skills
- Database Administration
- AWS RDS (MSSQL, PostgreSQL, Oracle)
- SAP SYBASE ASE 12x, 15x, 16x
- MSSQL 2014, 2016, 2017, 2019, 2022
- Warm standby
- MSA
- HADR configuration
- Oracle Database 11g, 12C, 19C
- PostgreSQL 14, 15
- MSSQL Server Tools
- SSMA
- SSMS
- SSIS
- Data Tools
- Config Manager
- Cloud Technologies
- Amazon Web Services (AWS)
- Microsoft Azure
- Google Cloud Platform (GCP)
- Alibaba Cloud
- Version Control System
- Azure Devops
- Bitbucket
- Git
- CI/CD
- Bamboo
- Terraform Cloud
- Infrastructure orchestration
- Terraform
- IDE Tools
- Visual studio code
- Monitoring Tools
- Autosys
- Shell Script
- Crontab
- Ticketing Handling Tools
- JIRA
- ITSM
- Nexus
- HPSM
- BMC OPAS
- SNOW
- IMD
- DBArtisan
- Filezilla
- Server Operating System
- Linux
- UNIX (Solaris)
- Suse Linux
- Windows Server
- Scripting
- Shell script
- Power shell
Certification
- Certified Microsoft Azure Data Fundamentals (DP-900)
- Certified Microsoft Azure Fundamentals (AZ-900)
- Certified Complete MSSQL certified DBA from Udemy
- Certified Terraform Certified Associate
- Certified AWS Solution Architect Associate
- Certified GCP Associate Cloud Engineer from Google
- Certified ITIL Foundation v3 Certificate in IT Service Management
- Certified Alibaba Cloud - Operate and Manage a Relational Database on the Cloud from Alibaba Cloud
- Certified Oracle Certified Associate (OCA) from ORACLE Corp.
- Certified Agile Overview Level 1
- Certified ‘PDLC 2.0 Executive Overview’ from ‘Moodys.com’
- Certified ‘Rational Application Development (RAD)’ from ‘IBM’
- Certified Soft Skills’ conducted by ‘INFOSYS’ Campus connect program
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Awards
- HCL Jewels Award
- HCL Achiever’s League Award
- Bank of America Silver Award
- Syntel Synergy Award
Work Preference
Work Type
Full TimeLocation Preference
HybridTimeline
Engineering Architect
Microsoft
12.2024 - Current
Cloud Database Administrator
HCLTech
07.2022 - 11.2024
Lead Database Administrator
HCLTech
08.2019 - 06.2022
Analyst II System Administrator
Bank of America
10.2016 - 07.2019
Senior System Engineer
Infosys
04.2015 - 10.2016
Software Engineer
Syntel
12.2011 - 03.2015
Bachelor of Technology (B.Tech.) - Information Technology
IET ALWAR