Nidhi Panchal

Experience

• 

  Atos

  Sept 2012 - Oct 2015

  Software Engineer (DBA)

  MSSQL Server Administration:• Schedule backups of databases. Create maintenance plans, Data recovery, backup and restore of databases and Database Refreshes• Work on high availability features like clustering and replication.• Identify and resolve SQL Server Database locks, deadlocks and blocks issues, using Dynamic Management Views & Functions• Manage user and data security to allow access to appropriate resources and fixing orphaned users.Sybase Server Administration:• Establish and Maintain Backup & Recovery policies and procedures.• Authorize Sybase server users and logins and grant permissions to them • Taking regular and scheduled backups through task scheduler and cron jobs and troubleshooting the logs in case of failures.Change and Problem Management:• Raise Change Requests, seek approval and follow up for closure within the SLA.• Represent the team in Technical CAB meetings Show less

• 

  Travelex

  Oct 2015 - Feb 2019

  DBA Technical Product Analyst

  MSSQL Server Administration:• Create, schedule, maintain and monitor Database backup and refresh.• Work on high availability features like clustering, replication, log shipping and mirroring.• Perform database design, modeling and implementation of new database structures, as required.• Test for Disaster Recovery on half yearly basis.Sybase Server Administration:• Applying production build, application upgradations and releases.• Executing the queries sent by developers and testers through command line and ISQL.• Monitor server performance, database and transaction log growth and error logs checks.Change and Problem Management:• Raise a Problem Record for repeated incidents and work on RCA.• Arrange, attend and drive weekly Problem Management call. Show less

• 

  General Atlantic

  Feb 2019 - Jan 2021

  Senior Data Strategy Analyst

  • Develop and maintain MSSQL Server databases.• Create stored procedures, triggers, and functions to support business requirements.• Provide technical support for database-related issues.• Migration of database objects from MSSQL server to Snowflake.• Snowflake database development using SnowSQL.• Develop Tableau reports using SQL Server data sources.• Complete projects and development activities timely and accurately while following the Agile System Development Life Cycle (SDLC) Show less

• 

  Mindtree

  Feb 2021 - Nov 2022

  Data Engineer Module Lead

  • Develop and implement data pipelines using Databricks, SparkSQL and Azure DevOps.• Build data platforms on Azure cloud technology.• Create data models using SQL and Databricks.• Manage ETL processes using Databricks and Airflow.• Develop Airflow DAGs using Python.• Source-control the code and make it ready for deployment across Development, QA, UAT and Production using Git and Azure DevOps CI/CD.• Collaborate with cross-functional teams to ensure data accuracy and consistency.• Optimize queries and data pipelines for performance and scalability.• Develop Tableau reports for clients using SQL Server and Databricks data sources.• Migrate database objects viz. Tables, Views and Functions from MSSQL server to Snowflake under Data Platform as a Service initiative.• Design Azure Standard Logic App workflow under ASEv3 to copy a file from BOX to Azure storage container and SFTP it to a client location.• Infrastructure deployment of Resource Group, Storage account, App Service Plan and Standard Logic App via Terraform.• Lead the Sprint from Sprint planning to closure once in a month as a SCRUM master. Show less

• 

  LTIMindtree

  Dec 2022 - Feb 2024

  Specialist - Data Engineering

  • Develop and implement data pipelines using Databricks, SparkSQL and Azure DevOps.• Build data platforms on Azure cloud technology.• Create data models using SQL and Databricks.• Manage ETL processes using Databricks and Airflow.• Develop Airflow DAGs using Python.• Source-control the code and make it ready for deployment across Development, QA, UAT and Production using Git and Azure DevOps CI/CD.• Collaborate with cross-functional teams to ensure data accuracy and consistency.• Optimize queries and data pipelines for performance and scalability.• Develop Tableau reports for clients using SQL Server and Databricks data sources.• Migrate database objects viz. Tables, Views and Functions from MSSQL server to Snowflake under Data Platform as a Service initiative.• Design Azure Standard Logic App workflow under ASEv3 to copy a file from BOX to Azure storage container and SFTP it to a client location.• Master Data Management via Semarchy xDM• Infrastructure deployment of Resource Group, Storage account, App Service Plan and Standard Logic App via Terraform.• Lead the Sprint from Sprint planning to closure once in a month as a SCRUM master. Show less

• 

  Accenture in India

  Feb 2024 - now

  Data Engineering Associate Manager