SathishKannan Ramasamy
Chennai
Summary
Seasoned Database Engineer with 15+ years of experience in designing, implementing, and managing large-scale database systems. Proficient in data modeling, performance optimization, scalability, and database internals across SQL and NoSQL databases. A strategic leader with a track record of delivering high-quality solutions in fast-paced environments, skilled in resource optimization to drive organizational growth.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Member of Technical Staff II
Paypal
Chennai
04.2023 - Current
- Authored and proposed a strategy to address the challenges of object-relational impedance mismatch through the exploration of multi-model databases.
- Built and managed teams in RDBMS and proxy layers (Oracle Call Interface), supporting 1,000+ Oracle RDBMS servers, 100+ PB of data, and 1.2 million persistent connections.
- Trained 25+ engineers during the vendor transition and implemented a self-managed L1/L2 support framework, leading key upgrades, and migrations.
- Reduced critical application latencies from 40 ms to under 5 ms at the 99th percentile, affecting over 350 billion daily calls by implementing architectural changes and system optimizations.
- Optimized CPU utilization from over 70% to below 40% across 60% of Aerospike database nodes, significantly enhancing system efficiency and resource allocation.
- Achieved a 3x scalability improvement for an Aerospike graph use case by leveraging read-page-cache, configuring auto-pin CPU, and applying key configuration tweaks, leading to significant performance enhancements and enabling the system to handle larger workloads.
- Upgrade of Aerospike stack from version 4.9 to V6.2, resulting in improved XDR performance and enhanced system stability.
- Proposed and led a POC to redesign the data movement platform by integrating native Aerospike connectors, eliminating one network layer, reducing costs, and removing operational overhead related to managing applications and deployed machines.
- Achieved $8 million in database hardware savings by optimizing performance, improving scalability, and increasing system throughput to handle linear traffic growth without additional hardware.
- Optimized application policies for improved stability, reducing network overhead through connection persistence and circuit breakers.
- Proposed and designed an analyzer stack to simplify debugging of complex system issues, integrating Prometheus and Datadog for customized monitoring and observability solutions tailored to the Aerospike platform.
Member of Technical Support Staff I
PayPal
Chennai
04.2017 - 03.2023
- Conducted root cause analysis (RCA) for site incidents, leading complex bug fixes by thoroughly reproducing issues in a test environment to identify solutions.
- Collaborated with vendor development teams on multiple critical bug fixes, significantly improving system stability and performance.
- Led high-performance L1/L2 operations teams across various regions, cultivating a culture of excellence and operational efficiency.
- Conducted comprehensive performance analysis and load testing to debug deeper issues, including vendor-specified bugs not previously exposed.
- For example, I compared PowerPath and multipathing solutions to identify bottlenecks during peak concurrency and connection spikes, ensuring optimal system performance and reliability.
- Led a persistent effort to reduce RDBMS and NoSQL alerts by 80%, decreasing them from 12,000 per week to 2,500 through strategic fixes and deep analysis.
- Led proactive performance and scalability analysis, improving latency in dictionary and application queries, and enhancing system reliability.
- Examples of adjustments include Oracle dictionary statistics, memory configurations, object structures, undo settings, optimizer and query analysis, and fixes, resulting in significant performance boosts, meeting SLAs, and ensuring 99.999% uptime.
- Proposed and implemented innovative solutions for improved resiliency and zero downtime.
- For example, successfully demonstrated a table cutover using Oracle Online Redefinition, which eliminated downtime compared to legacy methods through a proof of concept.
Software Engineer 3
PayPal
Chennai
09.2014 - 03.2017
- Served as a key member of the L1 and L2 teams, overseeing site monitoring, cross-functional incident resolution, triaging, and ticket resolution for over 100 databases.
- Collaborated closely with engineering teams on-site incidents to conduct root cause analysis (RCA) and implement proactive engineering solutions.
- Proactively managed systems with Data Guard and GoldenGate replication to ensure consistency and adherence to reporting SLAs, effectively addressing all issues.
- Spearheaded daily troubleshooting of database alerts, achieving a 30% reduction in site alerts through detailed issue analysis, thus enhancing monitoring effectiveness, and ensuring 99.999% site availability.
- Collaborated with vendors to resolve site bugs and conducted root cause analyses (RCAs) for site incidents.
- Collaborated with engineering and DevOps teams on system cutovers and migrations.
Software Engineer IC2
Oracle Corporation
Bangalore
12.2012 - 09.2014
- Delivered exceptional support to global customers, resolving complex Oracle database issues, including those related to performance, configuration, and data recovery.
- Collaborated with Oracle's Advanced Customer Support team to escalate and resolve critical incidents, ensuring minimal downtime and adherence to SLAs.
- Implemented and managed Oracle databases, including upgrades, migrations, and patch applications, improving stability and performance.
- Conducted regular training sessions for customers on best practices, optimizing their Oracle database environments for enhanced efficiency and resilience.
- Developed and maintained documentation on troubleshooting steps and resolution paths for common Oracle database issues, streamlining the support process.
Database Analyst
VERIZON DATA SERVICES INDIA(VDSI)
Chennai
08.2011 - 12.2012
- Implemented database security measures that effectively safeguarded sensitive data and complied with industry regulations and standards.
- Conducted comprehensive performance tuning and capacity planning for database systems, ensuring optimal performance and scalability.
- Successfully reduced performance latency by 15%, decreasing the need for additional systems.
- Collaborated with cross-functional teams to support database integration for new applications, facilitating smooth deployments and seamless data access.
- Stayed abreast of the latest database technologies and best practices, applying them to continuously improve the database infrastructure.
- Conducted regular disaster recovery exercises and developed robust failover and switchover mechanisms to ensure business continuity.
Database Administrator
12.2008 - 08.2011
- Conducted weekly benchmark testing of database systems for each scheduled release, assessing resilience and performance amidst evolving data patterns and increasing payload sizes
- Successfully migrated all Oracle standalone systems to Oracle RAC, enhancing high availability and scalability
- Developed disaster recovery solutions for Oracle systems using Oracle Data Guard, ensuring resiliency and data redundancy
- Configured a monitoring stack with Oracle Enterprise Manager for comprehensive monitoring, alerts, and notifications, while also setting up automation jobs for self-managing administrative tasks and critical threshold alerts
- Performed regular proactive performance checks across databases using Oracle's in-built AWR reports, complemented by troubleshooting with internal diagnostics such as system state dump, error stack, process dump, and SQL trace
Junior Database Administrator
SQLSTAR INTERNATIONAL
Hyderabad
06.2008 - 12.2008
- Managed data warehousing systems for the Mastercard project, overseeing systems with storage capacities ranging from high terabytes to petabytes.
- Conducted regular recovery exercises using RMAN for backup and point-in-time recovery, including the restoration and testing of both logical and physical corruptions.
- Conducted partition purging exercises and resolved issues with automated purge processes.
- Managed and tested the recovery processes for redo logs, archive logs, and undo scenarios in the event of corruption and disk failures, reinforcing system resiliency.
Education
B.s.c - Chemistry
Gurunanak College
Chennai01.2007
Skills
- Database Technologies: Oracle, Aerospike, MongoDB, MySQL, PostgreSQL, Cassandra
- Data Modeling & Design: ER Modeling, Normalization, Schema Design
- Database Internals:Storage Engines, Query Execution & Optimization, Concurrency Control, Indexing Mechanisms, Transaction Management
- Data Structures & Algorithms:Advanced Data Structures (B-Trees, LSM Trees), Complexity Analysis, Graph Algorithms
- Performance Optimization:Query Tuning, Indexing Strategies, Load Balancing, Caching, Sharding & Partitioning
- Cloud Platforms:Google Cloud Platform
- Big Data Technologies: BigQuery, Spark, Kafka
- DevOps Tools:Docker, Kubernetes, Ansible, Jenkins, Git
- Soft Skills:Team Leadership, Project Management, Strategic Planning, Problem-Solving, Effective Communication
Certification
- Oracle 12c Certified Professional, 03/01/13
- Oracle 9i Certified Professional, 09/01/07
Disclaimer
I hereby declare that all the information provided above is true up to the best of my knowledge.
Timeline
Member of Technical Staff II
Paypal
04.2023 - Current
Member of Technical Support Staff I
PayPal
04.2017 - 03.2023
Software Engineer 3
PayPal
09.2014 - 03.2017
Software Engineer IC2
Oracle Corporation
12.2012 - 09.2014
Database Analyst
VERIZON DATA SERVICES INDIA(VDSI)
08.2011 - 12.2012
Database Administrator
12.2008 - 08.2011
Junior Database Administrator
SQLSTAR INTERNATIONAL
06.2008 - 12.2008
B.s.c - Chemistry
Gurunanak College
Similar Profiles
Shaun GarnerShaun Garner
Risk Operations Agent at PayPalRisk Operations Agent at PayPal
MALLIKARJUN NMALLIKARJUN N
Business Analyst at PayPalBusiness Analyst at PayPal
Jagadeesh PamarthiJagadeesh Pamarthi
Senior Data Engineer at PaypalSenior Data Engineer at Paypal
James AbelJames Abel
Head of EMEA Collections (PayPal Site Lead) at PayPalHead of EMEA Collections (PayPal Site Lead) at PayPal
Hari Krishna NallapareddyHari Krishna Nallapareddy
Lead Engineer at VESTAS WIND TECHNOLOGY INDIA PRIVATE LIMITEDLead Engineer at VESTAS WIND TECHNOLOGY INDIA PRIVATE LIMITED