Veena Senthilkumar
Chennai
Summary
As a Senior Consultant, I bring over 17+years of experience in SQL database administration and cloud migration. Over the course of my career, I have gained extensive knowledge of various database technologies and cloud platforms.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Senior Consultant
Capgemini
Mumbai, IN
09.2020 - Current
- As a Senior Consultant, I performed Performance management, capacity planning, enforced database constraints, configured high availability features, provided technical support, troubleshoot SQL infrastructure problems.
- Client: METLIFE (internal position) | Tech Stack: SQL SERVER 2019, SQL SERVER 2016
- Technology Refresh and Capacity Management
- Manage/drive technology refresh, Handling Performance issues
- Handle SQL server installation and SQL patching on all environments | Assist in capacity planning of SQL database servers
- Database Integrity and Availability
- Enforce and maintain database constraints for data integrity
- Monitor, rebuild, and troubleshoot standby databases | Troubleshoot SQL infrastructure problems
- High Availability Features Configuration and Maintenance
- Configure SQL Log shipping and SQL Always On for high availability
- Configure Rubrik Tool and migrate log shipping jobs to Rubrik
- Technical Troubleshooting and Support
- Handling all the migration and patching activity
- Handling P1,P2 calls and if needed working along with Microsoft on getting an issues resolved ad creates RCA doc for the issue.
- Reporting Team Management
- Lead a reporting team of 5 members | Manage Client metrics reports, Breach analysis reports, and Project status reports
- Creating SOP for the team to handle all the infrastructure task
- Configure and manage high availability (SQL log shipping, sql always on) | Infrastructure and performance troubleshooting
- Server capacity planning to avoid outages | Always recommends access and compatibility concerns
- Working with leadership on SLA reports and ensuring 100% sla in all occurrences and changes.
Cloud Specialist
Accenture
Mumbai, IN
08.2009 - 01.2020
- As a Cloud Specialist declared as IDC (India Database Lead) and my responsibilities included managing, maintaining, and troubleshooting SQL databases, ensuring service adherence to SLAs, and leading and managing teams for Accenture internal and client projects.
- Company: Accenture (CIO, Telstra) Tech Stack: SQL server 2012, 2014, Hadoop, Kafka Connect, Hive, Spark
- For Accenture Internal (CIO):
- Own/Manage/drive technology refresh
- Manage capacity and availability of SQL databases
- Enforce and maintain database constraints to ensure the integrity
- Perform general technical troubleshooting and help application teams
- Perform database performance monitoring
- Configure and maintain High availability features (SQL Cluster, Replication, SQL Log shipping, SQL Always On)
- Assist in capacity planning of SQL servers | Monitor, rebuild, and troubleshoot standby databases
- Troubleshoot SQL infrastructure problems | Refresh development/test databases from copies of production
- For Telstra:
- Worked with the IBM team to move data of 3TB before the given time without affecting performance
- For Accenture (Big Data stack):
- Set up data ingestion pipelines for multiple CIO applications
- Develop Spark code to handle data transformations
- Handle more than 30 million records every 15 days and transform them into a Data lake
- Work on Migration activities involving AWS and POC tasks using GCP
- Other responsibilities:
- Ensure service availability and adherence to response/resolution SLAs for consulting business unit
- Work with the Engineering team to get the PAAS tools certified
- Work with the Engineering and Environment delivery to get Azure and AMZ VM provisioning
- Bring in ideas for continuous support during migration without stopping the tool by working with the IDC security team
- Manage and groom Oracle DBAs to get certified in SQL 2016
- Manage direct/virtual teams including hiring, induction, training, performance, and career growth of team members
- Budgeting and resource management | Time and efforts approval
Software Engineer
Secova eServices
Chennai, IN
11.2008 - 03.2009
- As a Release Management T-SQL Developer, my responsibilities included troubleshooting technical issues and providing support to client teams.
Programmer
Ramco Systems
Chennai, IN
12.2006 - 07.2008
- As a Release Management T-SQL Developer, my responsibilities included planning, implementing, and troubleshooting SQL software and backup installations, providing technical support to client teams, and monitoring and optimizing SQL databases for peak performance.
Education
Bachelor of Technology - Information Technology
Anna University
Chennai11.2005
Skills
Proficient in Linux, SQL Server, Hive, Kafka, Scala, Spark, and Hue
Strong project skills in various versions of SQL Server, DTS, SQL Always-ON, Replication, Backup and Recovery, Log Shipping, Cluster Administration, HP Polyserve, VMware, MongoDB, and SQL Azure
Experience in BMC Remedy Tool, Qlik report, Rubrik Tool, and DMS tool for migration to Azure
Trained in SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2016, and 2019, as well as MongoDB and Hadoop rewrite tools
Expertise in SQL Server administration and development
Proficiency in capacity planning, Performance engineering, database backup and recovery, high availability setup and monitoring
Experience in working with big data concepts and related technologies such as Hadoop, Kafka, and Hive
Strong knowledge of the windows operating system Ability to troubleshoot technical issues and provide support to application teams
Familiarity with cloud technologies such as Azure and AWS Experience in project management and team management
Proficiency in BMC Remedy Tool, Qlik report, and Rubrik Tool Skilled in SQL Server migrations (onprem and cloud), Capacity planning, Performance management
Strong analytical and problem-solving skills
SQL Server Administration
SQL Management
Team Mgmt
Migration and Performance management
Certification
Microsoft Certified Azure Administrator Associate
LANGUAGES
English
Tamil
Hindi
Accomplishments
- Successfully completed both Azure AZ-900 and AZ-104 certifications.
- Represented my company at a global SQL conference in Las Vegas, expanding my knowledge and network within the industry.
Timeline
Senior Consultant
Capgemini
09.2020 - Current
Cloud Specialist
Accenture
08.2009 - 01.2020
Software Engineer
Secova eServices
11.2008 - 03.2009
Programmer
Ramco Systems
12.2006 - 07.2008
Bachelor of Technology - Information Technology
Anna University