Home

Shashi Shekat - Senior postgres DBA | Data Architect | Database Architect | Database Engineer | DBRE | Data Modeler Resume

[email protected]

Location: Dallas, Texas, USA

Relocation: yes

Visa:

SHASHISHEKAR www.linkedin.com/in/Shashishekar-H-A-Profile Email: [email protected]| Direct : +1 (734) 821-5129 SUMMARY: Senior DBA | Data Architect | Database Architect | Database Engineer | DBRE | Data Modeler I bring total of 17 years of IT experience includes 10+ experience specialized focus on Database Administration, Database Engineering, Database Reliability and Data Engineering/Architecting/Modelling with expertise in architecting, optimizing, and managing complex database systems (PostgreSQL, MySQL, MariaDB, MongoDB, SQL Server) across on-premises and multi-cloud (AWS, GCP, Oracle Cloud) environments. Led end-to-end cloud migration initiatives for critical production databases, reducing operational costs by 40% and improving scalability by 60%. Expert in performance tuning, high availability strategies, disaster recovery planning, and implementing robust ETL pipelines to ensure data integrity and drive business insights. Installed, Configured EDB PostgreSQL Servers, implemented High Availability Failover Setup with failover manager. Deployed EDB PostgreSQL on AWS and defined backup strategies. Designed and Created Snowflake Container Objects. Designed and implemented Conceptual, Physical data models leveraging GCP CloudSQL and BigQuery and aligning transactional data models with data analytics star schema and Fact tables for the analytical systems. Optimized Snowflake Queries for data transformation and analysis. Configured RBAC in Snowflake. Architected Datawarehouse solutions using Cloud Storage, Dataflow and BigQuery. Integrated Snowflake with BI tools. Proficient in distributed database computing, advanced security protocols, and leveraging platforms like Snowflake for analytical workloads. Committed to continuous learning and adapting to emerging technologies. EDUCATION Master of Technology (M Tech) in Computer Science and Engineering from Dr. Ambedkar Institute of Technology Bangalore affiliated to Visveswaraya Technological University (VTU) Belgaum, Karnataka, India. CERTIFICATIONS - SnowPro Core Certified Issue in Jul 2025 - Databricks Azure platform Architect Issued in Jun 2025 - Databricks Generative AI Fundamentals - Google Cloud Certified Professional Database Engineer issued in Mar 2024 - Oracle Cloud Database Services 2022 Certified Professional - AWS Certified Database Specialty issued in Mar 2023 - Microsoft Certified Azure Data Fundamentals TECHNICAL SKILLS Cloud Platforms: AWS, GCP, Oracle Cloud Infrastructure Database Technologies: PostgreSQL, MySQL, MongoDB, SQL Server, MariaDB, Percona XtraDB Cloud Database Services: AWS RDS/Aurora, GCP CloudSQL, OCI MySQL, Snowflake, Databricks, BigQuery, AlloyDB, DynamoDB, EDB PostgreSQL DevOps/IaC/Automation: Kubernetes, Docker, Terraform, Ansible, Git, Liquibase Monitoring/Observability: Prometheus, Grafana, CloudWatch, DataDog Scripting/Programming: Python, Bash Operating Systems: RHEL, Ubuntu, Windows Server Data Modelling: Erwin PROFESSIONAL EXPERIENCE Compunnel Software Group May 2023 to July 2025. Database Engineer/Administrator Client: Verizon, US Project: SurveyHub Cloud Database Administrator/Engineer Architected, Designed Disaster recovery Infrastructure architecture for Aurora PostgreSQL and implemented the Global Database architecture for the mission critical databases ensuring continuous data availability and achieving near zero RPO and less than 15 minuets RTO for the databases over multi terabytes of OLTP and Analytical databases. Defined and implemented Cloud DB monitoring alerting on DB availability, performance, and health check aspects for continuous observability. Performance Optimization and Tuning of all my info functions, my analysis and resolutions resulted in 42% reduction in the query execution time and boosted the performance up to the same percentage, this has resulted in the improvement in CPU and other resource utilization and average Active sessions reduced from 600 sessions to 100 sessions and seen lots of improvement in handling DB workloads. Led and coordinated with the team on post deployment data validation testing and ensured deployment is successful with no issues. Project: RTPA SQL Server DBA Deployed SSIS packages onto the server using SSIS deployment framework and automated the SSIS package execution by scheduling jobs achieving 50% reduction in development and execution time. Configured Windows and SQL Authentication and Implemented RBAC to Users/Logins. Engineered and Automated the Comprehensive Backup and Recovery strategies for mission critical databases using native backup and recovery methods reducing RPO and improved data recoverability to 99.9% Analyzed slow Queries statistics and implemented few indexes to improve DB performance which resulted in performance improvement of 40%.. Configured and Implemented Transactional Replication and managed high availability architectures across over many SQL Server instances. Rackspace Technology US, Inc. MySQL Database Administrator III/Senior DBA Aug 2014 to Apr 2023 Responsibilities: Optimized complex SQL queries and database indexing across MySQL 8.x, MariaDB and PostgreSQL production instances, reducing average query execution time by 35% to 40% and improving application performance for 10K+ daily users. Architected scalable MySQL, MariaDB database solutions for applications supporting many daily transactions and ensuring sub-second response times under peak load. Implemented and managed multi region/data centers MySQL and MariaDB instances/Clusters with replication for the High Availability achieving near zero RPO and sub minuet RTO. Deployed OCI MySQL Services and configured some of the critical server parameters for the optimal performance. Integrated OCI MySQL related monitoring and created some alerts for the proactive performance tracking. Implemented automated backup and point-in-time recovery (PITR) for MySQL databases using OCI Backup policies. Successfully led the On-Premises to Cloud Migration of MySQL databases in AWS/Google Cloud reducing infrastructure overhead of 30%. Developed and Deployed Ansible Playbooks and Terraform Modules to fully automate the provisioning and configuration of MySQL instances/clusters reducing setup time to 80%. Enhanced database observability by integrating Prometheus and Grafana for real-time monitoring, enabling proactive identification and resolution of performance related issues 25% faster. Deployed and Managed MongoDB Replica set/Shards in Production environment. Performance Optimized MongoDB queries by deploying relevant indexes achieving improved performance in query execution. Hands on experience in MongoDB Atlas. Experienced in Cloud Migration to Atlas. Troubleshooting database issues. Working knowledge of CRUD operations. PostgreSQL Database Administration/Engineering: Jun 2017 to Apr 2023 Spearheaded the multi environments (prod, dev and uat) Object rocket PostgreSQL data migration to Google CloudSQL PostgreSQL achieving 90% reduce in infrastructure overhead time. Migrated data from On-premises Oracle database to AWS EC2 PostgreSQL leveraging AWS DMS and AWS Schema Conversion tools. Architected scalable PostgreSQL database solutions for applications supporting many daily transactions and ensuring sub-second response times under peak load. Deployed PostgreSQL DB Clusters, Installation, and customized DB Configuration for the optimal performance of PostgreSQL 10/11/12/13/15 servers / DB clusters. Leveraged Terraform scripts/modules to deploy AWS EC2 instances and installed PostgreSQL clusters. Effectively tuned Slow queries leveraging Indexing strategies and Partitioning, tuned server configurations, analyzed DB/tables statistics for read and hit ratios, index/sequential scan metrics. Deployed High Availability architectures leveraging Logical/Streaming replication methodologies with defining optimal replication parameter settings. Backup and Recovery Automated the Backup process for full/differential backup, defined the backup window to run the backup process in an automated way. Defined RTO and RPO for the Point In time recovery. Knowledge in Capacity Planning Migrated On premise PostgreSQL DB clusters to AWS RDS/Aurora PostgreSQL Leveraged AWS CloudWatch and GCP Database monitoring tools to design Database Monitoring/alerting in AWS EC2,RDS/Aurora/CloudSQL PostgreSQL instances. MongoDB Database Administration: Managed scalable MongoDB Clusters/Replicasets and Sharded clusters. Assessed existing MarkLogic schemas, collections, and indexes, and designed a target MongoDB schema model aligned with business use cases. Designed MongoDB collections, indexes, and shading keys to support high-volume transactions and queries. Migrated terabytes of data using parallelized bulk loading with MongoDB s mongoimport, and Compass. Implemented checksums, sampling, and reconciliation queries to validate data integrity post-migration. Optimized queries to leverage MongoDB indexes, projections, and pipelines for better performance. Migrated workloads to MongoDB Atlas with auto-scaling, backups, and monitoring for high availability. Applied data archival strategies to manage hot/warm/cold data cost-effectively. Migrated user roles, permissions, and access controls from Mark Logic to MongoDB RBAC. Configured Atlas monitoring to track cluster health and workloads post-migration. Automated backups and disaster recovery strategies to ensure business continuity. Deployed MongoDB Clusters/Replica sets and Sharded Clusters Configured and implemented SSLs on the Clusters. Additional Experience: Motus IT- Software Engineer May 2013 to Aug 2014, MySQL Data validation Query development for Workday Migration and Performance Optimization of slow queries. Wipro Technologies Senior Specialist Jan 2006 to May 2013, Led Data warehousing QA projects at both Offshore and Onsite, Data Validation, Data Integrity and Test lead for DW QA projects. Ciber India Database Lead, Jun 2005 to Jan 2006, Database Development Lead, PL/SQL stored procedures development and deployment Rewards and Recognitions Winner of Accomplished CIBER Employee award at Ciber India for the excellent contribution towards the Successful execution of the Project. Keywords: quality analyst artificial intelligence business intelligence database information technology procedural language