Yugank Srivastava
Sr Database Administrator
Allahabad,UP
Summary
Accomplished **Database Professional** with over 9 years of experience specializing in **Database management, cloud infrastructure, and solution architecture**. I bring a proven track record of delivering robust and scalable **Cloud DBA solutions** across AWS and Azure, leveraging automation, database optimization, and performance tuning in dynamic environments. My expertise includes streamlining database operations through tools like **Terraform, Jenkins, and CI/CD pipelines**, enabling efficient, secure, and resilient deployments that align with modern DevOps practices.
Currently pursuing an **MBA in Strategy and Consulting at FMS Delhi**, I am passionate about transitioning into a more **Strategic role**—where I can bridge deep technical acumen with business-driven objectives. I am well-versed in **Collaborating with cross-functional teams** to ensure high availability, disaster recovery, and operational excellence while driving innovation and business value. Inspired by your professional journey, I would be grateful for your mentorship or guidance as I navigate this next career phase.
Sources
Overview
10
10
years of professional experience
9
9
Certifications
Work History
Senior Database Administrator
Brightly Software's a Siemens Company
10.2023 - Current
- Designed and architected Relational DB’s (AWS/AZURE) solutions to meet business requirements, ensuring scalability, high availability, and fault tolerance in cloud environments.
- Architected and optimized SQL Server databases on EC2 and RDS, implementing best practices for performance, scalability, and cost-efficiency in cloud environments.
- Led the design of high availability and disaster recovery solutions for SQL Server (Always On) and other Relational DB’s (AWS/AZURE) including replication, failover, and backup strategies.
- Managed SQL Server on EC2 and RDS as well as AWS Aurora PostgreSQL instances, driving improvements in provisioning, configuration, and optimization for peak performance.
- Designed and implemented automation workflows using CI/CD tools (Jenkins, Terraform) to streamline database deployments and reduce manual intervention in cloud environments.
- Developed and enforced robust security policies for AWS Aurora PostgreSQL and SQL Server on EC2/RDS, implementing encryption, access control, and compliance best practices.
- Provided solution architecture leadership for cloud-based database design, ensuring seamless integration of SQL Server and PostgreSQL databases with applications and services.
- Implemented monitoring and performance tracking solutions using AWS CloudWatch for AWS Aurora PostgreSQL and SQL Server on EC2/RDS, proactively identifying and resolving performance issues.
- Collaborated with cross-functional teams and stakeholders to align database architecture solutions with overall business and technical requirements, ensuring optimal design and performance.
- Provided expert-level guidance and troubleshooting for SQL Server and AWS Aurora PostgreSQL, supporting 24/7 incident resolution, performance tuning, and system optimization.
Database Administrator
Gartner India Research and Advisory Services Pvt. Ltd
11.2019 - 10.2023
- Managed SQL Server and PostgreSQL databases in on-premises and cloud environments (AWS & Azure), handling installation, configuration, and performance tuning.
- Designed and implemented high availability and disaster recovery solutions, including Always On for SQL Server, to ensure 24/7 system availability and minimal downtime.
- Provisioned and optimized AWS RDS instances for SQL Server and PostgreSQL, ensuring scalability, security, and high performance.
- Collaborated with DevOps teams to integrate CI/CD pipelines for automated database deployments and management of both SQL Server and PostgreSQL.
- Troubleshoot and resolved performance issues, identifying and addressing bottlenecks to ensure efficient database operations.
- Worked cross-functionally with DBAs, application developers, and cloud teams, ensuring seamless database integration and supporting agile project delivery.
- Worked on enabling High Availability on Gartner Events Infrastructure
- Ensured 24/7 availability of critical database systems hosted on-premises and in AWS & Azure cloud environments, ensuring seamless operations.
- Implemented and maintained industry-standard database processes and policies, ensuring compliance and system reliability across cloud and on-premises environments.
- Participated in the architecture and design of database solutions to support critical business applications, ensuring high availability and scalability.
- Collaborated with DBAs, application developers, and technical teams to implement database solutions and resolve issues, supporting smooth application performance.
- Supported Gartner’s database infrastructure, working in an agile environment and collaborating with Cloud and Data Center Management teams to ensure consistency across departments.
- Provisioned and maintained stable database environments using Oracle, Microsoft, and Open Source/Other technologies, facilitating continuous improvement and troubleshooting.
MSSQL Database Administrator
IBM PVT LTD
06.2015 - 11.2019
- Monitoring and Performance Tuning: Physical Server Level, Database level, and query tuning.
- Setup High Availability as part of Disaster Recovery Strategy for Databases.
- Created Users and assigned permissions based on the level of database access needed.
- Monitored network performance and provided network performance statistical reports.
- Managed firewall, network monitoring, and server monitoring both on- and off-site.
- Assisted in the installation, configuration, and routine maintenance of SQL Server databases.
- Supported backup, recovery strategies, and ensured data integrity and minimal downtime.
- Monitored database performance and assisted in basic performance tuning and troubleshooting.
- Managed user permissions and enforced security practices for SQL Server databases.
- Collaborated with development teams to optimize queries and support database integration.
Education
Executive MBA - Strategy And Consulting
Faculty of Management Studies
Delhi04-2027
B.tech - Information technology
Uttarakhand Technical University
Dehradun 01.2011 - 1 2015
Skills
Expertise with key DevOps, monitoring, and automation tools: Jenkins, Datadog, Terraform, Dynatrace, Striim, Bitbucket, JIRA, TSM, Splunk, Microsoft PowerShell Advanced database management: Cloud and relational database administration, SQL Profiler, schema design, indexing, partitioning, query optimization, replication, clustering,powershell Business intelligence and analytics: Power BI, resource utilization analysis, performance optimization Comprehensive data management: Data migration techniques, DMS,ETL process development, data integration strategies, data modeling, database upgrades, Infrastructure and cloud solutions: Multi-cloud strategy, cloud architecture design, capacity planning, scalability, serverless and virtualization technologies, infrastructure automation and migration Disaster recovery and high availability: Disaster recovery planning, backup and recovery, high availability implementations,Multi-AZ Enterprise architecture: Enterprise architecture design, solution implementation, architecture review, strategic IT planning Sales and stakeholder communication: Sales strategy, pre-sales support, sales presentations, excellent communication, stakeholder engagement Automation and microservices: Automation scripting, microservices development, resource provisioning, load balancing Security and compliance: Security compliance, cost optimization, data storage optimization AI and innovation: Artificial intelligence implementation, analytical thinking, migration strategies, effective communication,GenAI tools And Integration
CLOUD COMMUNITY CONTRIBUTION
- Spoke at the “New Stars of Data Platform” event on the topic “Evolution of Database Security Concepts: From On-Premises to the Cloud.”
- Selected to speak at the PGConf India, 2025 event on the topic “AI-Assisted Post-Mortem Analysis and Optimizations for PostgreSQL Performance”
- Delivered guest lecture’s on AWS Cloud Computing in various Educational platforms.
Accomplishments
1. SQL Server DB Script Deployment Project through Jenkins
• Reduced manual deployment effort by 60% by fully automating SQL Server script deployments via Jenkins pipelines, saving over 120 hours per year.
• Improved deployment success rate by 30% by implementing automated error-checking and rollback procedures.
2. DC4 Datacentres Migration Project
• Successfully migrated over 100+ databases across DC4 Datacentres with zero data loss, achieving 99.99% uptime during transition.
• Shortened migration window by 40%, resulting in annual operational savings of approximately $50,000 due to reduced downtime.
3. Datadog Integration Project with SQL Server
• Enabled real-time performance monitoring on 50+ SQL Server instances, reducing incident response times by 45%.
• Decreased average resolution time for SQL Server alerts by 35% post-integration.
4. BAW Migration Project from Oracle to Synapse
• Led migration of 15+ business data workflows from Oracle to Synapse, boosting query performance by 50% and reducing monthly infrastructure costs by $30,000.
• Achieved project deliverables 3 weeks ahead of schedule through streamlined ETL pipelines.
5. SQL Server Upgrades Project from 2012 to 2019
• Upgraded over 70 SQL Server databases from 2012 to 2019 with zero critical incidents, improving security compliance and reducing legacy vulnerabilities by 80%.
• Reduced system maintenance overhead by 25% post-upgrade.
6. Migration Project from EC2 to AWS RDS Instances
• Migrated 30+ enterprise databases from EC2 to AWS RDS, reducing infrastructure costs by $45,000 annually and improving backup/recovery efficiency by 60%.
• Enhanced scalability and disaster recovery capabilities with minimal downtime (7. Migration from PostgreSQL to SQL MI through Azure ADF
• Automated migration workflows for 20 databases using Azure Data Factory, reducing migration effort by 70 hours.
• Improved data synchronization accuracy to 99.8% during transition.
8. Azure Analysis Service Model Deployments and Refresh Project
• Implemented automated deployment and refresh process for Azure Analysis Services models, reducing time-to-deploy from 3 hours to 20 minutes per cycle.
• Increased report data freshness by 85%, enabling more informed business decisions.
9. Disaster Recovery Automation Project for RDS Instances Database
• Designed and deployed disaster recovery automation for 25+ RDS instances, reducing recovery time objective (RTO) by 90% (from 2 hours to under 12 minutes).
• Secured annual risk mitigation savings estimated at $75,000 by minimizing data loss and downtime.
Certification
Exam 462: Administering Microsoft SQL Server 2012/2014: Issued Sep 2020
Timeline
Senior Database Administrator
Brightly Software's a Siemens Company
10.2023 - Current
Database Administrator
Gartner India Research and Advisory Services Pvt. Ltd
11.2019 - 10.2023
MSSQL Database Administrator
IBM PVT LTD
06.2015 - 11.2019
B.tech - Information technology
Uttarakhand Technical University
01.2011 - 1 2015
Executive MBA - Strategy And Consulting
Faculty of Management Studies
Similar Profiles
Kishore NegiKishore Negi
Global QA Head | Director Test Engineering at Brightly Software (a Siemens Company)Global QA Head | Director Test Engineering at Brightly Software (a Siemens Company)
Mike KnoxMike Knox
VP of Sales Public Markets / Energy at Brightly Software (Siemens Company)VP of Sales Public Markets / Energy at Brightly Software (Siemens Company)
Austin H JoyAustin H Joy
Sales Development Representative at Brightly- A Siemens CompanySales Development Representative at Brightly- A Siemens Company
MOHD MUZAMMIL ANSARIMOHD MUZAMMIL ANSARI
BUSINESS DEVELOPMENT EXECUTIVE at AGILEINTEL RESEARCHBUSINESS DEVELOPMENT EXECUTIVE at AGILEINTEL RESEARCH
Mohammad YaseenMohammad Yaseen
Freelance Civil Work at Freelance Civil WorkFreelance Civil Work at Freelance Civil Work