Dipil Pillai

Experience

• 

  Capgemini Pvt Ltd

  Nov 2012 - Nov 2017

  Senior Systems Engineer

  • Expertise in the installation and configuration of SQL Server 2005/2008.• Regularly performed backup and recovery operations for databases, ensuring data integrity and availability.• Skilled in configuring and troubleshooting log shipping, maintaining high availability, and disaster recovery readiness.• Managed and scheduled various database jobs, efficiently resolving any related issues.• Involved in the creation and maintenance of logins, users, and roles, handling day-to-day user administration tasks.• Successfully established Linked Servers for SQL Server integration with heterogeneous environments.• Monitored database growth and adeptly managed transaction logs and space issues to optimize performance.• Scheduled and managed backup jobs for both tape and disk-based systems, enhancing data security.• Conducted restoration and disaster recovery (DR) drill activities, ensuring robustness in disaster management scenarios.• Performed switchover and switchback activities in disaster management.• Configured and troubleshot Data Transformation Services (DTS), enhancing data integration and transformation processes.• Utilized SQL Server Profiler for performance tuning, effectively identifying and rectifying bottlenecks and errors.• Configured replication according to client requirements, ensuring data consistency and reliability.• Skilled in configuring SQL Server Integration Services (SSIS) and adept at troubleshooting related errors, and enhancing ETL processes. Show less

• 

  Morningstar

  Jan 2018 - Sept 2020

  SQL Server DBA

  • Successfully upgraded database systems from SQL 2012/SQL 2014 to SQL 2016, ensuring seamless transition and system compatibility.• Conducted performance tuning for numerous queries, optimizing system efficiency and response times.• Skilled in troubleshooting and building SSIS packages, enhancing data integration and workflow processes.• Implemented robust backup and maintenance strategies on servers to ensure data integrity and availability.• Gained hands-on experience working with RDS and EC2 instances within the AWS environment, demonstrating adaptability and technical proficiency in cloud-based services.• Performed installation and configuration of SQL Server 2017 on Linux platforms, showcasing versatility in cross-platform database management. Show less

• 

  GEP Worldwide

  Oct 2020 - Jul 2023

  • Lead Daily Scrum meetings for SQL, Neo4j, and MongoDB teams, facilitating agile practices and team coordination.• Responsible for reviewing team members' work, conducting weekly project update meetings, preparing rosters and on-call schedules, and delivering weekly reports.• Actively handle issues escalated by L1/L2/L3 support teams, ensuring prompt resolution and continuous system availability.• Currently engaged with Azure SQL 2019, MongoDB versions 4.4 & 5.0, and Neo4j 4.3.15, demonstrating expertise in a diverse set of database technologies.• Proficient in PowerShell scripting for centralized server management, SQL inventory, and automation tasks, enhancing operational efficiency.• Conduct MongoDb and Neo4j version upgrades (both In Place and Rolling), ensuring systems are up-to-date and secure.• Utilize Jira for tracking incidents, cataloging tasks, and managing change tasks within the incident management framework.• Regularly perform system and user database backups on local drives, along with database recovery operations, ensuring data security and integrity.• Create and manage maintenance plans for various tasks including log backups, re-indexing, and database integrity checks.• Specialize in performance tuning using Windows performance tools, SQL Profiler, DMVs, and SQL queries to optimize database efficiency.• Skilled in database and query tuning, enhancing system performance and user experience.• Manage database user accounts by creating logins, users, and roles, and perform day-to-day user maintenance and script deployments on production servers.• Monitor database growth activities and troubleshoot transaction logs and space issues to maintain optimal database health. Show less

  • Software Lead

    Jan 2023 - Jul 2023

  • Senior Software Engineer

    Oct 2020 - Jul 2023
• 

  Infinite Computer Solutions

  Jul 2023 - now

  Senior Lead Database Administrator

  • Implemented best practices on Azure Cloud SQL Servers, ensuring optimal performance and security standards.• Maintained a large-scale database environment with a capacity of 21 TB, demonstrating capability in handling extensive data volumes.• Involved in implementing PCI Compliance projects across multiple systems at Goeasy, focusing on the protection of customer data.• Possesses master-level expertise in the Enterprise Recon tool from GroundLabs, a specialized PCI Data Scanning tool, showcasing advanced skills in data security and compliance. Show less