SATHISHKANNAN
Database Engineer
Chennai
Summary
Passionate, results-driven transformational database engineer and a technology enthusiast leading large scale data platforms over 15 years of experience in Scale, Availability, Security, Resiliency and Efficiency.
Highlights
Leading a team of 25+ engineers at PayPal across NA and APAC regions
in delivering one of the world’s largest OLTP platforms at over 100PB+ of
data with Annual operating budget of over 50M.
Built a strong track record of being trusted partner and a GO-TO guy for
complex initiatives spanning Org boundaries.
Built high performance teams with top talent across regions
Skilled troubleshooter with robust analytical abilities, adept at resolving complex issues across RDBMS and NoSQL stacks.
Enhanced database availability to 99.999% through operational efficiencies and innovative engineering solutions, significantly bolstering database stability.
Spearheaded and executed a performance overhaul for RDBMS and NoSQL databases, achieving a 50% reduction in latency for the 99th percentile of critical applications within the Aerospike database stack.
Achieved million in savings on new hardware procurement by optimizing performance, enhancing system scalability, and throughput, directly facilitating a 5x increase in traffic for critical projects.
Crafted a strategy poised to decrease RDBMS storage and Aerospike compute/storage costs by 30%, and reduce application layer connections by 20% through innovative data archival, defragmentation, and optimization techniques in compute/memory and connection management.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Member of Technical Staff II
PAYPAL
04.2023 - Current
- Successfully reduced critical application latencies from 7 ms to under 4 ms at the 99th percentile, and from 40 ms to 20 ms at the 99.9th percentile, by implementing architectural changes, impacting 350 billion daily calls.
- Enhanced the NoSQL stack upgrade efficiency by 300%, significantly reducing rebalance time for major upgrades. This optimization enabled the rapid upgrade of 1,000 servers within a quarter.
- Achieved $2.5 million in savings on new hardware procurement by optimizing performance, enhancing system scalability, and throughput, directly facilitating a 5x increase in traffic for a critical project.
- Managed and developed new teams in RDBMS, OCC, and deployments, training over 30 engineers and boosting efficiency through a self-managed L1/L2 support framework. This initiative promoted L2 to L3 transitions, focusing on engineering, automation, and key projects such as upgrades and migrations.
- Crafted a strategy poised to decrease RDBMS storage and Aerospike compute/storage costs by 30%, and reduce application layer connections by 20% through innovative data archival, defragmentation, and optimization techniques in compute/memory and connection management.
- Established effective troubleshooting techniques for faster issue resolution and minimized downtime during critical system failures.
Member of Technical Support Staff I
PayPal
09.2014 - 03.2023
- Comprehensive performance analysis comparing PowerPath and native multipathing solutions, leading to a strategic migration that enhanced critical Oracle database systems. This initiative effectively resolved bottlenecks during peak concurrency and connection spikes, ensuring optimal system performance and reliability.
- Comprehensive site-wide analysis and fixes across Oracle systems to boost stability. Adjustments to Oracle dictionary statistics, parameter configurations, shared and process memory, and undo settings significantly enhanced system reliability and availability, achieving 99.999% uptime.
- Led a persistent effort to reduce RDBMS and NoSQL alerts by 80%, decreasing from 12,000 per week to 2,500, through strategic fixes across multiple layers of the stack.
- Built and led high-performance L1/L2 operations teams across various regions, cultivating a culture of excellence and operational efficiency.
- Conducted root cause analysis (RCA) for all site incidents, spearheading complex bug fixes with thorough testing and replication to find solutions. Led efforts on multiple critical bug fixes significantly enhancing system stability and performance
- Proactively resolved performance and latency issues in both internal and application queries, leading to significant enhancements and fulfilling critical SLAs for downstream applications, as well as boosting overall site application performance.
VERIZON DATA SERVICES INDIA(VDSI)
08.2011 - 12.2012
- Verizon Data Services India, VDS India for short, is a complement of Verizon, the network company and a global leader in delivering innovation in communications, information and entertainment
- The wide spectrum of IT and non-IT work being performed by VDS India collaboratively with its parent, helps Verizon stay a leader in offering superior voice, data and video services to residential customers, businesses and the US federal government over intelligent wireless, broadband and global IP networks.
HOTCOURSES
12.2008 - 08.2011
- Hotcourses is an company which owns 60 + educational websites were students in countries like Uk, China, Australia, India, Singapore etc can search for their preferred courses and collect university and other contact details for studies
- I have a very good challenge in delivering the data for their searches at good speed and maintaining a stable apps and db servers
- Had a good exposure with performance management and facing new challenges by handling 200+ developers and data entry users in India.
SQLSTAR INTERNATIONAL
06.2008 - 12.2008
- Sqlstar is a software company which also provides training in Oracle Dba with outsourcing talents to various clients
- I have been a part of this organization and gained a good exposure with client Wipro where I have handled master card Data warehousing projects as an only offshore resource from Chennai supporting clients, developers and onsite dba’s in Europe and US.
Skills
Leadership, Coaching, Recruiting, Team building,Decision-Making,Problem-solving abilities
Oracle (RAC, NON-RAC), Exadata,Aerospike, MySQL, MongoDB,PostgreSQL,Cassandra PostgreSQL, Golden Gate Replication,Kafka, Hadoop & GCP Cloud technologies
Availability, Scalability, Resiliency, Security & Efficiency at Scale
Python,Ansible,Shell
Prometheus,Datadog,Grafana
Change management, auditing compliance, Agile, scrum, DevOps, SRE,CI/CD, SDLC
Academic Profile - Qualifications
- B.s.c (Chemistry), Gurunanak College, Chennai, 2007, 60%
- H.S.C, Southern Pearl M.H.S.S., 2004, 83%
- S.S.L.C, S.V.M.H.S.S., 2002, 73%
Disclaimer
I hereby declare that all the information provided above is true up to the best of my knowledge.
Certification
Oracle 12c Certified Professional
Timeline
Member of Technical Staff II
PAYPAL
04.2023 - Current
Member of Technical Support Staff I
PayPal
09.2014 - 03.2023
Oracle 12c Certified Professional
03-2013
VERIZON DATA SERVICES INDIA(VDSI)
08.2011 - 12.2012
HOTCOURSES
12.2008 - 08.2011
SQLSTAR INTERNATIONAL
06.2008 - 12.2008