Ketan Popat — Software Engineer

Ketan is an accomplished leader in the database space with a mindset of leveraging technology for business at its best. Driven by his passion for data and databases, his expertise includes architecting large-scale SQL and NoSQL databases, seamlessly migrating mission-critical platforms from on-premise to cloud and from commercial to open-source databases, partitioning, sharding, cost-efficient scaling, performance tuning, database refactoring, data security, cloud cost management, and horizontal scaling modern SaaS systems. He has made significant contributions to organizations like Intuit, Yahoo! and Manhattan Associates. To achieve impactful business outcomes, Ketan follows guiding principles that involve embracing extreme ownership and accountability, learning fast, failing fast and forward, and winning big. His leadership style is marked by a strong focus on simplicity, accelerated execution, prompt removal of obstacles, and making durable decisions. He also carries his reputation as a top-notch negotiator when dealing with technology and cloud vendors to drive product enhancements. Core competencies • Architecting SQL and NoSQL data store for large-scale systems including modern SaaS applications • Sharding and horizontal scaling of databases • Architecting migration of VLDB supporting OLTP, OLAP, and batch workload from Oracle to PostgreSQL/Aurora • Schema refactor to eliminate global indexes in preparation for database migration from Oracle to PostgreSQL/Aurora • Advanced support, operations and in-depth troubleshooting for distributed data systems • Deep understanding of database internals and data usage patterns • Database migration from on-premise to Cloud/AWS RDS • Database server-side performance tuning and application-side query tuning • Data modeling and data model refactoring • Data model and query tuning for verity of access pattern for SQL and NoSQL store • Data security in modern SaaS a.k.a. multi tenant systems • Data partitioning, parallel query implementation and tuning • Data clustering and data compression • Homogeneous and heterogeneous database replication • Capacity forecasting and augmentation for on-premise and in-cloud databases • Strong cross functional and cross geographical team coordination and collaboration • Proven track record in hiring, developing, training and retaining resources to deliver at scale • Track record of quality deliverables on the time, all the time • Cloud hosting cost optimization • Co-architecting distributed datastore for multi tenant system with Cloud vender

Stackforce AI infers this person is a Database Architect with expertise in cloud migration and performance optimization in SaaS environments.

Location: Bengaluru, Karnataka, India

Experience: 25 yrs 5 mos

Skills

Database Management
Operational Aspects Of Databases
Database Architecture
Performance Tuning
Database Support
Etl Tuning
Sql And Pl/sql Development
Database Auditing
Oracle Database Development
Erp System Design
Database Performance Tuning
Database Recovery

Career Highlights

Expert in architecting large-scale SQL and NoSQL databases.
Proven track record of successful cloud migrations.
Strong leadership in database performance tuning and optimization.

Work Experience

Intuit

Principal Database Engineer (4 yrs 7 mos)

Staff Database Engineer (7 yrs 3 mos)

Yahoo

Principal DBA (4 yrs 1 mo)

Lead DBA (2 yrs 10 mos)

Manhattan Associates

Senior Database Administrator (2 yrs 6 mos)

Bessar Diamond Mfg Co Pvt Ltd (Bluestar diamonds)

Oracle DBA (2 yrs 3 mos)

Associated Infotech

Software Engineer (1 yr 10 mos)

Education

BE at Sardar Patel University

Oracle Certified Professional 9i at Oracle University

Oracle Certified Professional 8i at Oracle University

Ketan Popat

Software Engineer

Bengaluru, Karnataka, India25 yrs 5 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in architecting large-scale SQL and NoSQL databases.
Proven track record of successful cloud migrations.
Strong leadership in database performance tuning and optimization.

Stackforce AI infers this person is a Database Architect with expertise in cloud migration and performance optimization in SaaS environments.

Contact

Skills

Core Skills

Database ManagementOperational Aspects Of DatabasesDatabase ArchitecturePerformance TuningDatabase SupportEtl TuningSql And Pl/sql DevelopmentDatabase AuditingOracle Database DevelopmentErp System DesignDatabase Performance TuningDatabase Recovery

Other Skills

Accountability and Deliverable QualityAmazon RDSAmazon Web Services (AWS)Architecting Highly Scalable Data Storage SolutionsAurora PostgresBackup strategiesBig DataCapacity Planning and AugmentationCapacity planningCloud Database MigrationCommercial to opensource database migrationConducting Customer Database AuditsDB2Data MartsData Modeling

About

Experience

Intuit

2 roles

Principal Database Engineer

Promoted

Aug 2021 – Present · 4 yrs 7 mos

Staff Database Engineer

Apr 2014 – Jul 2021 · 7 yrs 3 mos

Manage engineering and operational aspects of databases for Intuit's flagship products like Quickbooks Online, Payroll and Payments a.k.a. SBSEG (Small Business and Self Employed Group)

Database managementOperational aspects of databasesProduct development support

Yahoo

2 roles

Principal DBA

Promoted

Mar 2010 – Apr 2014 · 4 yrs 1 mo · Bangalore, India

Key Responsibilities:
Managed all the audience analytics related database needs -- starting from architecting, sizing, capacity planning, installations and upgrades, performance tuning as well as production support, additionally managed all the advertiser analytics database needs from Aug-2011 onwards.
Driven multiple initiatives to improve - team member’s knowledge and accountability, quality of deliverables, stability of databases and engagement with development and counter part team.
Provided technical leadership for the project to upgrade 50+ production and its non-production database environments from Oracle 10gR2 to 11gR2.
Worked with a team responsible for 12 x 7 on-call support as well as product development support of 150+ production databases and 300+ non-production databases running on oracle 10gR2/11gR2 including 75%+ RAC database and physical standby.

Database architecturePerformance tuningCapacity planningProduction support

Lead DBA

Apr 2007 – Feb 2010 · 2 yrs 10 mos · Bangalore, India

Responsibilities:
Worked for a team responsible for 12 x 7 on-call support as well as product development support of 50+ production databases and 50+ development databases running on oracle 9i /10g (R1 & R2) including RAC, physical standby, cascade standby databases with database size ranging from 1TB to 240 TB.
Implemented proactive monitoring to make DB stable and make on-call DBAs life easy.
Worked with application team on tuning ETL/aggregation jobs and reports to meet SLAs.
Worked with business units to define data retention, archiving/purging policy and implementation of same
to control database growth.
Worked for maintenance and administration snapshot sites using MVs refresh technology.

Database supportETL tuningData retention policies

Manhattan associates

Senior Database Administrator

Oct 2004 – Apr 2007 · 2 yrs 6 mos

Development, maintenance, enhancement and review of complex Oracle SQL and PL/SQL code
Wrote application version upgrade/migration script
Worked on release over release performance benchmarking for WMS product
Trained and assisted multiple PSO/GoLive team and Development/QA team to write efficient code, install Oracle client and server software installation, database creation, export-import, tracing, identifying and resolving connection, cursor leaks, database lock contention etc
Worked on client DB Auditing and on-demand consulting for client database mainly Oracle 9i/10g database on ASM hosted on various platforms like AIX, Sun, HPIT, HPUX and Windows and DB2 UDB version 8.2 databases hosted AIX platform
Worked on transforming and copying data between heterogeneous RDBMS like Oracle, SQL Server and DB2 UDB using DTS and SQL Loader

SQL and PL/SQL developmentDatabase auditingPerformance benchmarking

Bessar diamond mfg co pvt ltd (bluestar diamonds)

Oracle DBA

Jun 2002 – Sep 2004 · 2 yrs 3 mos · Surat, India

Worked as a Developer cum DBA for Dimond mfg ERP with Oracle DB 8i/9i as backend and Oracle developer forms/reports as frontend
Wrote PL/SQL code for payroll processing
Designed and tuned of various analytical reports for management
Parallelly worked on new ERP system design and development with Oracle9iR2 as backend and Oracle10g Application server as middle tier and Oracle 10g Forms / Reports as front end

Oracle database developmentERP system designPL/SQL coding

Associated infotech

Software Engineer

Aug 2000 – Jun 2002 · 1 yr 10 mos · Ahmedabad, India

Worked on development of a mini-ERP system for Pharmaceutical. System included functionality for GRN, Delivery Challan, Sales Order Entry, Inventory management and Daily, Monthly and Yearly Reports for Sales, Purchase and Inventory
Worked for various state government and private organizations for database performance tuning, Query/Application tuning, database recovery, implementing database administration best practice for backup, testing and documenting recovery procedure, setting up physical standby database, MTS, disk layout planning for various Oracle files and Backup/Recovery strategy.

Database performance tuningDatabase recoveryBackup strategies