GAURAV SHRIVASTAVA
Summary
Bachelor of Engineering (Computer Technology) with 19+ years of experience in designing, architecting and administration of large, enterprise scale PostgreSQL, IBM DB2 UDB and MySQL databases on LUW in banking, retail, ERP domains across private and public sectors on cloud and on-premise.
Overview
20
20
years of professional experience
4
4
Certifications
Work History
Solutions Architect
Crunchydata (acquired by Snowflake)
09.2022 - Current
- Serve as a trusted advisor for multiple enterprise clients, delivering architecture design, performance tuning, and technical guidance for mission-critical PostgreSQL deployments.
- Led the design and implementation of cloud-native solutions, enhancing scalability and reliability for enterprise clients.
- Design and implement scalable PostgreSQL solutions on Kubernetes (CPK) and VMs (CPA), ensuring high availability, security, and compliance.
- Collaborated with cross-functional teams to develop architecture strategies that reduced operational costs and improved system performance.
- Worked with customers and prospective clients to develop integrated solutions and conducted detailed architectural dialogues to facilitate delivery of comprehensive solutions.
- Lead technical escalations for high-priority customer tickets, coordinating with engineering, support, and product teams to ensure rapid resolution and root-cause analysis.
- Optimize client environments through proactive monitoring, database tuning, and infrastructure automation.
- Collaborate with product and engineering teams to improve Crunchy Data's products and contribute to best practices documentation.
- Conduct client workshops, architectural reviews, and training sessions to enhance customer adoption and knowledge of PostgreSQL technologies.
- Partner with customer success teams to drive retention, satisfaction, and adoption of Crunchy Data solutions.
- Utilized Agile methodologies to drive project delivery, ensuring timely completion and alignment with client requirements.
Data Privacy/Security Engineer
BNZ Bank
03.2022 - Current
- Implement Data tokenization, encryption and tokenization tool across the bank.
- Performing PoC for data tokenization/ encryption/obfuscation for vendor (Protegrity & Comforte) provided tools on Snowflake, Informatica DEI, Kafka, AWS RDS, AWS EKS and flat files.
- Design and build PoC environment (AWS RDS, Snowflake, Kafka, EC2) using Terraform (IaaC) and Github, Bitbucket (version control).
- Build data test plan and test cases according to data governance/privacy and security policies set.
Datawarehouse Operations Engineer
Ministry of Health
09.2021 - 02.2022
- Snowflake Operations/Administration: - User management, access control, Column Level security, User resource management, time travel management. user management, role hierarchy setup, Snowflake DB DR setup, Managing Snowflake outbound shares, Column level masking.
- Snowflake outbound shares and access management.
- Cost optimization by purging unused objects, compute/warehouse/SF credit management.
- Dbt Documentation and creating knowledge base for the team using Confluence/Jira wherever required.
- Assisting developers with issues on Snowflake and dbt and BAU.
Database Reliability Engineer
Xero Limited
08.2020 - 09.2021
- Collated problems faced by developers across the organization with PostgreSQL and AWS RDS.
- Defined the future path of PostgreSQL in the organization and worked towards standardizing Builds and deployments.
- Setting up standards for AWS RDS and PostgreSQL based on ISO 9002 and Xero's standards.
- Planning, managing, monitoring, scaling of AWS RDS datastores.
- Setup of monitoring of all AWS RDS instances in Xero.
- Lower ongoing costs by actively monitoring DB usage and appropriate use of AWS RDS instance class.
- Tightening security/access to the databases.
- Helping developers with their database performance and issues.
Database Engineer
Datacom Systems Ltd.
02.2013 - Current
- Led projects and transitions as Technical Lead / SME for IBM DB2 UDB, PostgreSQL, MySQL, and Redis, guiding team tasks and validating technical solutions.
- Designed and implemented database and infrastructure architectures for multiple clients like NZ Customs, ACC, DIA, LINZ ,including automated HA, DR, multi-site failover, and Enterprise Failover Manager setups.
- Developed scripts for data purge, DB maintenance, automated HA setup, across environments.
- Performed complex data migrations and upgrades, redesigning logical/physical DB structures; Database, Schema and table-level data movement for production projects. Reduced database cutover time from 12 hours to 1 hour.
- Managed data replication, ingestion, transformation, and CDC using Qlik Replicate and AWS DMS from MS SQL Server, Sybase, Oracle into Data Lake (MAP-R, AWS EMR, S3).
- Automated installation, configuration, patching, upgrades, and monitoring (Check_MK plugin scripts) for PostgreSQL, IBM DB2, and MySQL.
- Provided 24x7 support, root cause analysis, SDLC assistance, and documented processes using JIRA, Confluence, SharePoint; awarded Service of Excellence three times.
IT Infrastructure Analyst
Barclays Technology Centre
04.2009 - 02.2013
- Designed (physical and logical) and implemented UN Sanctions' database with HA and DR capabilities, based on data models, and reverse/forward engineering data and database model.
- Involved in projects to design physical & logical design for new databases based on customer requirements.
- Installation, configuration, DB management/administration, HADR setup, upgrade/patching DB, Error resolution and liaising with IBM Support.
- Enabled auditing, setting compliance standards as part of external and internal IT Audit and Compliance requirement.
- Troubleshooting production/live issues, resolving customer requests, assisting and advising them for their application. Providing 24X7 on-call support, incident/change and request management.
- Configured and installed Quest Foglight 5 across the Barclays DB2 estate and provided training to team members.
- Scripted & automated the daily health check, awarded and recognised for the efforts i.e. Barclays STAR award.
- Successfully assisted in GOLF datacentre Migration from Portugal to UK and was awarded Barclays STAR award.
- Successful takeover of support and knowledge transfer to team for Barclays Capitals, USA, ABSA Bank, South Africa, and started production support from India Centre.
Senior Software Engineer
EDS, An HP Company
02.2007 - 04.2009
- Database Owner for the USDE databases, which were back-end databases for SAP Payrolls.
- Complete responsibility of the databases, their upgrades, maintenance, performance management, data migrations.
- Implement new releases, interacting with customers and action their requests.
- Creating Business process Agreements, setting SLAs with the customers.
- Ensuring success of recurring jobs, troubleshooting and fixing failures.
- Daily handover of tasks done, database recommendations, future storage requirements analysis, bi-yearly data purging and archiving based on data retention requirements.
- Creating database physical model based on customer requirements.
- Clients: Commonwealth Bank of Australia, Krafts Food Products, Australia, United States Data Engineering.
Database Administrator
Prodapt Software Pvt. Ltd.
03.2006 - 01.2007
- Project to migrate VLDB of Bahrain Government's Passport database from CA-DATACOM database into IBM DB2 UDB V8.2.
- Designed physical design of the target database in IBM DB2 UDB.
- Data analysis, conversion and move to IBM DB2 UDB from CA-Datacom.
- Data modelling and designing data flow using IBM Rational Rose.
- Creating ETL jobs using IBM Rational Rose
- Using LOAD/EXPORT/IMPORT to import data into DB2 UDB databases.
- Providing training to fellow CA-DATACOM DBAs for IBM DB2 UDB.
- Ensuring success of daily database maintenance jobs.
- Daily reporting to the Director of the CIO with the progress.
- Clients: Central Informatics Organization, Bahrain Government.
Database Administrator
Davlin Softwares Pvt. Ltd.
09.2005 - 02.2006
- Converted KIOCL's COBOL database into IBM DB2 UDB database.
- Developed shell scripts to convert COBOL data into IBM DB2 format.
- Designed and implemented DB2 UDB databases for different clients for their ERP solutions.
- Providing support to hundreds of local clients with each client having their own databases.
- DB2 UDB installation and configuration at client's site.
- Continuous monitoring and responsibility of the upkeep, user maintenance and security of the database.
- Product: OFSY ERP Solution with, Accounting, HR, Inventory, e-Mail Clients, etc. modules.
Education
Bachelor of Engineering - Computer Technology
M.I.E.T.
Nagpur University, India01.2003
Skills
- Data & Database (PostgreSQL, IBM DB2, MySQL)
- Worked on tools and technologies like Openshift, opensource Kubernetes, VMs (Vsphere, Oracle VB), cloud technologies like AWS, GCP
- Deep ability to tackle enterprise-wide deployment, scalability, availability, and performance issues
- Creating database infrastructure designs as per customer requirement Coordinating in smooth implementation of the projects; extending post-implementation and database maintenance support to the client
- Proven ability to deliver high profile activities to tight timescales, maintain and ensure availability and quality of platforms
- Planning and implementation of backup strategies, retention policies, tape management, database configuration, performance management etc
- Complex, heterogeneous and homogenous data migration from different data sources into RDBMS (PostgreSQL and IBM DB2 UDB)
- Monitoring and optimizing the performance of databases, DB configurations, troubleshooting issues in live/production environment like performance tuning, setting up DR/high availability, backup/recovery, and data related issues, data and DB access, etc
- Setting up data and database compliance and security standards, collecting audit data for the Internal IT audits
- Patch/upgrade DB, license management, installation and configuration of DB server and client software Setup of DB audit, database compliance and keeping up with security standards
- Setup/manage & administer replication and ingestion from MS SQL Server, Sybase, Oracle , IBM DB2 into Data lake using Qlik Replicate
Certification
AWS Cloud Practitioner
Personal Dossier
- Birth Month and Year: March 1981
- Location: Melbourne, State: Victoria, Australia.
- Citizenship Status: New Zealand citizen, Australian resident.
Accomplishments
- ITIL V3 Foundation Certified
- AWS Cloud Practitioner
- IBM DB2 V10.1 Certified Associate
- Oracle 9i Certified Associate
Timeline
Solutions Architect
Crunchydata (acquired by Snowflake)
09.2022 - Current
Data Privacy/Security Engineer
BNZ Bank
03.2022 - Current
Datawarehouse Operations Engineer
Ministry of Health
09.2021 - 02.2022
Database Reliability Engineer
Xero Limited
08.2020 - 09.2021
Database Engineer
Datacom Systems Ltd.
02.2013 - Current
IT Infrastructure Analyst
Barclays Technology Centre
04.2009 - 02.2013
Senior Software Engineer
EDS, An HP Company
02.2007 - 04.2009
Database Administrator
Prodapt Software Pvt. Ltd.
03.2006 - 01.2007
Database Administrator
Davlin Softwares Pvt. Ltd.
09.2005 - 02.2006
Bachelor of Engineering - Computer Technology
M.I.E.T.
Similar Profiles
Brijesh AminBrijesh Amin
Manager at MRI India (acquired Castleton Technology India Private Limited, acquired CarbonNV)Manager at MRI India (acquired Castleton Technology India Private Limited, acquired CarbonNV)
Majeed Abu DbayMajeed Abu Dbay
Full Stack Developer at Bidalgo (acquired By IronSource, Acquired By Unity)Full Stack Developer at Bidalgo (acquired By IronSource, Acquired By Unity)
JACKELINE GERSCHJACKELINE GERSCH
Costume Service LATAM at SnowflakeCostume Service LATAM at Snowflake
Dikshit CelurDikshit Celur
Sr. Regional Solutions Architect / Sr. Solutions Architect at Trace3 (Formerly Groupware Technology Inc.)Sr. Regional Solutions Architect / Sr. Solutions Architect at Trace3 (Formerly Groupware Technology Inc.)
William BrownWilliam Brown
Solutions Architect at Spectrum BrandsSolutions Architect at Spectrum Brands