Megha Rathod
Mumbai
Summary
15.5 years of IT experience in database in Azure, SQL Server, Generative AI , Fabric and Snowflake Domain expertized in Brooking, Manufacturing, Healthcare, Industrial Services, tourism and hospitality, and Food Chain domains
Overview
16
16
years of professional experience
5
5
Certifications
Work History
Senior Database Administrator
Xoriant Solutions Pvt. Ltd.
03.2023 - Current
- Client Gaming Laboratories International - Leading Testing & Certification Services specialized in providing the gaming industry’s leading testing and certification services along with an unsurpassed range of services and tools for regulators, suppliers and operators.
- Implemented cloud database backup strategy for Microsoft SQL Server databases hosted on Azure and shared drives
- Administered Azure SQL servers, designed and maintained stored procedures, functions, sequences, constraints, and triggers to ensure data integrity. Applied indexing and partitioning strategies to enhance performance and created views for monitoring and reporting purposes
- Performed regular patching and upgrades to keep SQL Servers up to date with the latest versions
- Optimized SQL queries by analyzing Query Store and execution plans to improve performance
- Configured and managed SSIS packages and SSRS reports
- Set up and maintained SQL Server Replication for data synchronization and high availability
- Developed and automated daily customized reports for disk space utilization, job failures, and replication synchronization status
- Tools/ Technologies: Azure, SQL, Service Now, SSIS, SSRS, PowerShell, DMA
Senior Database Administrator
Xoriant Solutions Pvt. Ltd.
03.2023 - 10.2024
- Safety Chain is food & beverage manufacturing facilities globally to improve alignment and collaboration between Operations, etc.
- Performed deployment and version control of database objects, including schemas, tables, views, stored procedures, and functions during migration and release cycle
- Managed user provisioning, role-based access control, and implemented security configurations in line with organizational policies
- Contributed to tenant migration projects from on-premises Virtual Machines to Azure SQL Managed Instance, ensuring data integrity and high availability
- Oversaw weekly and monthly deployments by preparing and validating scripts for both production and non-production environments
- Conducted performance tuning and query optimization through indexing and refactoring to enhance response time and efficiency
- Utilized Datadog and Query Store to identify performance bottlenecks and applied corrective actions proactively
- Handled core DBA responsibilities, including backups, job scheduling, index maintenance, and routine health checks
- Automated custom and client-specific reports using PowerShell and optimized Azure scaling operations based on workload performance trends
- Tools/ Technologies: Azure, SQL, Datadog, Azure devops, GitHub, PowerShell
Consultant Associate
Tata Consultancy Services
03.2016 - 03.2023
- Element helps businesses manage their commercial vehicles across the entire lifecycle, from acquisition and financing to maintenance and remarketing.
- Coordinated with development team, ETL team, config management, and data migration team
- Deployment of database objects – Database, Schema, Tables, Views, Store Procedure, functions as part of migration activities and code changes. Users, roles creation and granting access based on requirement
- Evaluated requests for new data elements & systems, and incorporated the same into the existing shared environment without any disruptions
- Utilized continuous data protection features like Time travel to recover data and zero copy cloning to create another database for testing.
- Secured data sharing from one Snowflake account to another using Snowflake shares
- Optimized warehouse performance and credit saving PI implementation
- Led a team of 8-10 members, managing their roasters, shifts, etc.
- Offered production support for backup & recovery, participating in & supporting initiatives for disaster recovery planning and problem resolution utilizing root cause analysis, collaborating with end-users & department managers
- Automated multiple tasks like logon trigger, automated query result output to auditor in CSV format as per Soc audit requirement
Project Manager
Tata Consultancy Services
06.2021 - 06.2022
- Implemented Microsoft 365 E5 Enterprise security control features across entire environment, that includes office 365 Tenant Hardening, Azure information Protection (AIP), Data Loss Protection (DLP), Microsoft Defender for Identity, Threat & Vulnerability management. We achieved our milestone by splitting implementation phase into three workstream
Architecture and Migration to Latest Version
Tata Consultancy Services
05.2020 - 06.2021
- Migrated MS SQL database from lower to higher version
- Migrated 10 -15 Servers from SQL 2000 to SQL 2016 and above with minimal downtime
- Implemented cloud DB backup strategy for MS SQL database using Rubrik tool
- Designed procedures, functions, sequences, constraints & triggers to maintain data integrity; applying indexes & partitions to improve performance; creating views for monitoring and reporting provided consultancy & mentoring for database design, performance tuning, database platform selection for applications, and database structures to accommodate growth
- New business opportunities offering production support for backup & recovery, participating in & supporting initiatives for disaster recovery planning and problem resolution utilizing root cause analysis related issues Implementing design modifications to database
- Collaborated with end-users & department managers for capacity planning and development of long-term strategic goals for production databases
Database Administrator
Tata Consultancy Services
03.2016 - 04.2020
- Administered AWS serves Designing procedures, functions, sequences, constraints & triggers to maintain data integrity, applying indexes & partitions to improve performance creating views for monitoring and reporting
- Implemented cloud DB backup strategy for MS SQL database using Rubrik tool
- Administered AWS servers Designing procedures, functions, sequences, constraints & triggers to maintain data integrity; applied indexes & partitions to improve performance creating views for monitoring and reporting
- Provided consultancy & mentoring for database design, performance tuning, database platform selection for applications, and database related issues
- Implemented design modifications to database structures to accommodate growth and new business opportunities
- All SQL DBA related tasks, SQL Hardening, etc.
- Implemented CR, Work on RCA and present it to client on Monthly basis
- Worked on DR like Always on Availability, Replication, Log Shipping, and Mirroring
- Functioned as part of internal database audit and shared data and worked on automated reports for auditors as per requirements
- Tools/ Technologies: SQL 2000/ 2016, ServiceNow, SISS, SSRS, SQL Profiler, SSMS
Database Technical Administrator Lead
Tata Consultancy Services
02.2019 - 04.2019
- Assessed proposal
- Validated performance issue with application/ SQL Server
- Estimated resource, planning and delivery data (SOW)
- Validated resources for project
- Tools/ Technologies: SQL 2016/ 2019, ServiceNow, SSMS, SQL Profiler
Database Administrator
Wipro InfoTech
03.2013 - 02.2016
- The Maharashtra State Government has set up a fully functional State Data Center (SDC) for managing the government website. Dedicated servers are provided to the department to host their applications or web portals along with the required bandwidth.
- Installed Oracle 11g R2 and MS SQL 2012
- Migration from MS SQL Server 2008/ 2008 R2/ 2005 to MS SQL Server 2012
- Worked on database backups, restore, and migration
- Created Server Logins, database user and maintaining Least privileged Policy
- Performed Service Pack Patching on SQL server
- Troubleshot issues related to SQL Server
- Engaged in SSIS package creation and troubleshooting
- Tools/ Technologies: SQL, SSMS, SSIS, SQL Profiler
Database Administrator
Sphere Info Solutions
08.2011 - 03.2013
- Managed a centralized database system for travel-related data, supporting both domestic and international tour packages across global destinations.
- Administered and maintained Development, QA, Pre-Production, and Production database environments.
- Designed and implemented database backup and recovery strategies to ensure data protection and business continuity.
- Monitored database performance and executed query and index optimization to improve efficiency and reliability.
- Conducted quarterly database restore and validation drills to verify backup integrity and disaster recovery readiness.
Jr. DBA
Angel Broking LTD
05.2010 - 06.2011
- Used to managed trading related data commodity, equity, used to run batches of data on daily basis.
- Sharing the database report on every day basis.
- All DBA related task like backup, restore and disaster recovery like database monitoring.
Education
Bachelor of Engineering - Information Technology
Amravati University
Chikhli01.2009
Skills
PL/SQL
T-SQL
UNIX
Linux
Windows
SQL 2000 to SQL 2022
SSIS
SSRS
Azure
Snowflake
Fabric
Generative AI
ServiceNow (SNOW)
JIRA
Datadog
Database performance tuning
Accomplishments
- Received Galaxy Award, Wipro
- Received five On the Spot Award
- Received Star Performer Award
- Received niner Best Team Award
- Received XorChamp Award
Certification
MCTS certified for SQL Server 2008, 70-432
Areas Of Expertise
PL/SQL, T-SQL, UNIX, Linux, Windows, SQL 2000 to SQL 2022, SSIS, SSRS, Azure, Snowflake, Fabric, Generative AI, ServiceNow (SNOW), JIRA, Datadog
Training
- SQL Server 2005/2008 Performance and Tuning
- SQL Server 2012 Always On
- Power BI Classroom, Microsoft
- PostgreSQL
- Generative AI
Timeline
Senior Database Administrator
Xoriant Solutions Pvt. Ltd.
03.2023 - Current
Senior Database Administrator
Xoriant Solutions Pvt. Ltd.
03.2023 - 10.2024
Project Manager
Tata Consultancy Services
06.2021 - 06.2022
Architecture and Migration to Latest Version
Tata Consultancy Services
05.2020 - 06.2021
Database Technical Administrator Lead
Tata Consultancy Services
02.2019 - 04.2019
Consultant Associate
Tata Consultancy Services
03.2016 - 03.2023
Database Administrator
Tata Consultancy Services
03.2016 - 04.2020
Database Administrator
Wipro InfoTech
03.2013 - 02.2016
Database Administrator
Sphere Info Solutions
08.2011 - 03.2013
Jr. DBA
Angel Broking LTD
05.2010 - 06.2011
Bachelor of Engineering - Information Technology
Amravati University