Subhatra Parthiban
Chennai
Summary
Proficient SQL DBA Team Lead with extensive expertise in database administration and performance tuning, driving significant enhancements in system reliability through task automation. Demonstrated success in disaster recovery planning and performance troubleshooting, ensuring optimal database functionality. Articulate communicator recognized for effectively collaborating across teams to achieve project goals.
Overview
12
12
years of professional experience
Work History
SQL DBA Team - GWIM LOB
BA Continuum India Private Ltd. (BACI) - a non-banking subsidiary of Bank of America
Chennai
02.2017 - Current
- Global Wealth and Investment Management (GWIM) provides comprehensive wealth management solutions to affluent, high-net-worth clients.
- Served as Primary DBA for nearly 18 different applications.
- Worked on and deployed the HashiVault password management system.
- Optimized control of the application release process using Datical deployment tools.
- Designing database backup, retention policy, and restoration strategy.
- Performed troubleshooting on performance issues (deadlocks, indexes, space issues, monitoring CPU/memory).
- Developed tailored solutions for DR and HA, as per client requirements.
- Cataloged inventory specifics, SOP updates, and remediated reported violations.
- Automated routine database tasks to improve system reliability and reduce manual errors.
- Automated dashboard view for daily DBA work, which displays INC, CRQ, non-prod requests, access requests, and violations tagged under each DBA.
Level 2 & 3 DBA - SQL DBA Team Lead (Capital One)
Cognizant Technology Solutions
Chennai
03.2016 - 02.2017
- Client, one of the largest American banks, specializes in financial services, offering a wide variety of products and services to its customers.
- Developed custom scripts to improve DBA monitoring and alerts through Database Mail.
- Automated the publication of weekly incident analysis reports on the dashboard.
Level 2 & 3 DBA - SQL DBA Team Lead (True Value)
Cognizant Technology Solutions
Chennai
02.2015 - 03.2016
- Client, an American retailer-owned hardware cooperative with over 5,000 retail locations worldwide, where members manage their respective stores autonomously.
- Achievements: assisted data migration from DB2 to SQL, fixed a critical order processing job delay, fixed a persisting application slowness issue, and recommended multiple ways to save space on disk.
Level 1 DBA (Bloomin' Brands, Inc.)
Cognizant Technology Solutions
Chennai
04.2013 - 01.2015
- Client, a hospitality industry entity, owned multiple American casual dining restaurants.
- One of the world's top casual dining companies managing around 100,000 Team Members.
- Established an alert system for excessive log space usage. Also, automated compilation of the Server Windows Update list via Excel macros.
Education
B.E - ECE
Anna University
Chennai, Tamil Nadu, India01.2012
Skills
- SQL Server management
- Database administration
- Capacity planning
- Backup and recovery
- Disaster recovery planning
- Data synchronization
- Query optimization
- Performance tuning
- Clear Documentation Standards
- Effective Communication Skills
Certification
- ITIL v3.0
- Level 0: IT IS Yellow Belt
- Level 1: ITIS Process Space
- IT IS Critical Situation Management for Learners
Languages
Tamil
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Accomplishments
- Cognizant - 2014 - awarded in 'Above & Beyond' category.
- Cognizant - 2015 - 'Star Performer' award.
- Cognizant - 2015 - 'Innovative Champion' award.
- Cognizant - 2016 - $100 cash award for exceptional contribution.
- Bank Of America - BACI - 2017 to present - 1-Gold, 1-Silver, 18-Bronze and 3-High Five awards.
Timeline
SQL DBA Team - GWIM LOB
BA Continuum India Private Ltd. (BACI) - a non-banking subsidiary of Bank of America
02.2017 - Current
Level 2 & 3 DBA - SQL DBA Team Lead (Capital One)
Cognizant Technology Solutions
03.2016 - 02.2017
Level 2 & 3 DBA - SQL DBA Team Lead (True Value)
Cognizant Technology Solutions
02.2015 - 03.2016
Level 1 DBA (Bloomin' Brands, Inc.)
Cognizant Technology Solutions
04.2013 - 01.2015
B.E - ECE
Anna University
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Preferred Location
Chennai, Tamil Nadu
Passport Holder
True
Personal Information
- Marital Status : Married
- Preferred Location : Coimbatore
- Passport Holder : Yes
Similar Profiles
Manisha Manisha null
Team Leader at BA Continuum India Pvt. Ltd (Non-Banking Subsidiary of Bank of America)Team Leader at BA Continuum India Pvt. Ltd (Non-Banking Subsidiary of Bank of America)
Pankaj KumarPankaj Kumar
Assistant Vice President - Senior Manager at BA Continuum Solutions Pvt. LTD (A non banking subsidiary of Bank of America)Assistant Vice President - Senior Manager at BA Continuum Solutions Pvt. LTD (A non banking subsidiary of Bank of America)
Anisha KashyapAnisha Kashyap
Assistant Manager at BA Continuum India Pvt Ltd (a subsidiary of Bank of America)Assistant Manager at BA Continuum India Pvt Ltd (a subsidiary of Bank of America)