Sachin Kumar
Database Team Lead
Singapore
Summary
I am working as a Database Team Lead for SQL Server/Oracle/Postgresql DBAs at NEC Asia Pacific Pte Ltd Singapore. I am working on Database Cloud Migration; Database redesigning, Database audits, Database Patching, DB standby drills, DB Backup and Restore. My core expertise into SQL/Oracle/Postgresql Performance issues, handle all escalated issues, DB capacity defects and Database problems. I handled multiple projects end to end and have experience in handling Database team, handled 6 SQL/Oracle DBA's team. I am responsible for developing and documenting business requirements, functional requirements, Azure user stories, and full as-Is and To-Be process models for our growing Infrastructure solutions group. I have created 20+ automated tasks like SQL server/Oracle/Postgresql installations, backups, decommission scripts which reduced team's manual efforts. I am working on the Cloud migration project and migrated many SQL Server/Oracle/Mysql/Postgresql databases to AWS RDS and EC2. Apart from SQL Server/Oracle Database, I have excellent experience in AWS Cloud and other flavor databases like Postgresql, Mysql, Exadata.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
Work History
Database Team Lead
NEC Asia Pacific Pte Ltd (Singapore)
Singapore
12.2022 - Current
- As a Database Performance Specialist, my work is to handle and give recommendations to Client about Database Optimization
- Managing and handling end-to-end Government Project Databases and resolved multiple P1/Priority incidents
- Handle multiple client’s database and giving recommendations to improve DB performance and find RCA
- Advise DBA and developers to optimize database queries
- Optimize Database performance with Wait events, slow performance query
- Identify database performance bottlenecks and advise to client
- Database related recommendation and activity planning
- Always on High Availablity database configuration and implementation
- End-to-End recommendations and trouble shoot all DB related queries
- Excellent hands on experience on Log Shipping, Mirroring, Always-On high Availability, Clustering and Replication
- Troubleshoot/Resolve Performance related issues of SQL Servers independently and handle all P1 calls and resolve many performance issues
- Configured HA/DR solutions(Always-On, Log-shipping, Replication) for many clients
- Resolve multiple DB performance related issues and gives recommendation to improve DB performance
- Worked on Log-shipping, Mirroring, Replication, Always-ON HA, Performance tuning
- Working not only DB part but working into Application/query design.
- Worked flexible hours, covering nights, weekends and bank holidays.
Database SME
Kyndryl (IBM) IT Services India Pvt. Ltd
India
07.2022 - 12.2022
- Worked on Oracle Exadata machines (X9-2), RAC, Dataguard
- Migrated multiple databases to new exadata machines
- Managing and handling 200+ SQL servers which are on 2012/14/16/17/19 versions and 20 Oracle Production databases
- Excellent hands on experience on Log Shipping, Mirroring, Always-On high Availability, Clustering and Replication
- Troubleshoot/Resolve Performance related issues of SQL Servers independently and handle all P1 calls and resolve many performance issues
- Worked on many Outages like Exadata DIMM/DISK/Battery/HBA/Flash Disk/Infiniband/ZFS replacement activates and replaced with help of Oracle
- Experience in resolving DC-DR Lag issues and ensuring DR sync with DC
- Worked in all aspects of architecting a database, designing and Implementing High Availability systems for 24/7 (RAC & Data Guard)
- Hands on experience on restoring table from RMAN backup in the event of export backup failure
- Handle Postgresql databases issues on Production.
Database Team Lead
Genpact IT Services India Pvt. Ltd
India
02.2021 - 07.2022
- Resolved Performance related issues of Oracle/SQL Servers independently and handled all P1 calls
- Assign Quarterly goals to team and share feedbacks in monthly calls
- Capacity planning and handle Oracle/SQL Database team and align them to do daily tasks
- Migrated many SQL/Oracle Servers to AWS RDS,EC2
- Create many Production/ UAT SQL Server/Oracle RDS and attend all AWS cloud migration meetings
- Worked with cloud team to migrate applications to cloud and resolve many issues during migration
- Mainly working on Project to Migrate/Upgrade SQL Server old version to latest versions SQL Server 2016/17
- Capable of managing crisis and working under pressure when required; remaining motivated and focused on team goals.
Senior Database Administrator
Dunnhumby IT Services India Pvt. Ltd
Gurgaon
04.2012 - 02.2021
- Working on Project to migrate SQL Server old version to latest versions
- There are 10 Exadata Full Racks ranging from X3 to X5, X7-8
- Database base estate includes - 10 Oracle Exadata Racks split into 4 clusters and 4 other RAC installations running over 50 databases (over 50 TB in size) & OEM
- Hands on experience on Oracle Exadata versions (X7-8,X5)
- Worked on many Outages like Exadata DIMM/DISK/Battery/HBA/Flash Disk/Infiniband/ZFS replacement activates and replaced with the help of Oracle
- Experience in resolving DC-DR Lag issues and ensuring DR sync with DC
- Worked in all aspects of architecting a database, designing and Implementing High Availability systems for 24/7 (RAC & Data Guard)
- Hands on experience on restoring table from RMAN backup in the event of export backup failure
- Handle Postgresql databases issues on Production
- Excellent experience to manage SQL Server new versions2016/17/19.
Application Support Engineer
QuadlabsTechnologies Private Limited
Noida
09.2011 - 04.2012
- Worked on the root cause analysis of L2 level of application production issues and providing solutions to them within the defined SLA
- Handling overnight production issues for two/three applications simultaneously in off business hours support
- The services being provided include Incident Management, Service Request Fulfillment, Batch Monitoring, and Service Level Management
- Coordination with Product Development Team,Unix team,storage and Data centre operation Team
- My work is troubleshooting complex production issues, data fixing, and resolve issues raised as alerts and follow the correct resolution procedures
- Daily Audit server logs,IIS logs, monitor SQL/Oracle DB's and daily check server backups
- Database Management, Patches upload on Production server
- Monitoring the EOD Batches and performing any event monitoring related tasks
- Deployment of Staging/Production environments and send effective communication to Stakeholders about application status.
Education
Bachelor of Science - Computer Science Engineering
Punjab Technical University
India 05.2007 - 03.2011
Skills
- Microsoft SQL Server DBA
- Oracle DBA
- Postgresql DBA
- EXADATA DBA
- MySQL DBA
- AWS Cloud
- Scrum/Service & Process Management
Accomplishments
- MCSA
- OCA 12C
- AWS Sys OPS
- Scrum Master certified
- Received values in action awards
- Received excellent feedback from Service Management teams
Hobbies
- Play Badminton in free time.
- Technical Books Reading.
- Motor Bike Riding.
Timeline
Database Team Lead
NEC Asia Pacific Pte Ltd (Singapore)
12.2022 - Current
Database SME
Kyndryl (IBM) IT Services India Pvt. Ltd
07.2022 - 12.2022
Database Team Lead
Genpact IT Services India Pvt. Ltd
02.2021 - 07.2022
Senior Database Administrator
Dunnhumby IT Services India Pvt. Ltd
04.2012 - 02.2021
Application Support Engineer
QuadlabsTechnologies Private Limited
09.2011 - 04.2012
Bachelor of Science - Computer Science Engineering
Punjab Technical University
05.2007 - 03.2011
Similar Profiles
Suresh Kumar M GanesanSuresh Kumar M Ganesan
IPC at NEC Asia Pacific Pte LtdIPC at NEC Asia Pacific Pte Ltd
Sherwin SashiSherwin Sashi
Intern at NEC Asia Pacific Pte LtdIntern at NEC Asia Pacific Pte Ltd
AUBREY JEANNE BUGTONGAUBREY JEANNE BUGTONG
Integration Manager at NEC Asia Pacific Pte. Ltd.Integration Manager at NEC Asia Pacific Pte. Ltd.