Garimella Santosh

• Designed Lift-Shift , Re-platform, Rehost, Rehome strategies specifically on Database & Data-Engineering workloads
• Worked extensively on migration, hyper-care, DR, SRE, steady state strategies & AWS Factory tools CloudEndure, DMS & SQL native migration & SRE accelerators for MSSQL, MySQL, PostgreSQL, MariaDB & Oracle
• DevOps & SRE- SLO strategies for Infra & App-DB APM/Monitoring +Hypercare with Percona, Pg-profile, pg-badger, Promethous & Grafana
• Integrated the OpenSource DB APMs for 4+ DB Engines along with regular AWS Cloudwatch brought in deep insights & Site Reliability Engineering on Databases
• Established AWS Data-Ecosystem Practice with DW & S3 DataLake solutions using Lambda, AWS Glue, HIVE , Athena, Redshift
• Implemented S3 DataLakes solutions , HIVE style partitioning & ETL solutions in Glue, Datamarts in Athena
• Implemented S3 DataLakes in Parquet/CSV formats, Hive style data partition pruning, partition elimination for downstream applications viz AWS Athena, AWS EMR
• Implemented Redshift + Redshift Spectrum federation use cases with S3 & RDS, Redshift + S3 + Spectrum+ RDS PostgreSQL/MySQL + Aurora federation use cases for ELT, ETL & flexible data pipelines
• Implemented tens of CloudOps/DevOps/DBOps & Data Engineering Operation processes in Managed Services Capacity.
• Supported identical Database & Data-Engineering solutions in Azure Cloud
• Conducted two POCs on AWS Finspace + AWS SageMaker for BFSI business cases, Amazon HealthLake PoC for HealthCare BigData.
• Conducted multiple POCs on Redshift + ML on petabyte scale datamarts
• Analytical thinker always focusing on innovation & solutions at scale
• Contributed as OLTP/OLAP SME, Technical Manager & Program Manager in lean/flat/tall Business Units
• Minfy Technologies is a CSP & premium partner of AWS ,offering DataCenter commissions/Migrations in Professional Services capacity, SYSOPS/CLOUDOPS/CLOUDDBOPS etc in Managed Services capacity
• Job Profile & Summary:
• Projects :
• Contributed to ~15 AWS Datacenter Greenfield commission & Migration projects driving AWS CLOUDOPS/SYSOPS/DBOPS teams technically in Delivery Management capacity since 7 years
• Designed & brought innovation, velocity, migration accelerators in the Cloud Migration Factory and contributed heavily to the organization achieve the AWS 'Large Migration Partner’ competency
• Incepted and scaled holistic AWS Managed Services capacity for CLOUDOPS & CLOUDDBOPS with 100+ sustained customers including 7 large enterprises in 2 years
• Built AWS & Azure Database Freedom Practice with 4+ DB Engines spanning CloudDBOPS, Database Modernization (Performance & Cost) serving AWS ProServ., AWS MS, SAP & Application Modernization Practices
• Achieved ¬2x performance differentiators & 40-60% TCO rationalization for 5 Large Enterprises in a span of one year
• Designed the holistic ITSM Program Management models automating the ServiceDesk, ProServ., Managed Services running Incident/Change/Problem & Prevention Management with lineage
• Part of results <>rewards oriented Teams , mentored & trained many resources specifically DBA/DBE/Migration/Data-Engineering skills
• Facilitated 1000+ Database Migrations, commercial to opensource engine migrations, DevOps Automation with SNS/SQS, Lambda on pushing data across RDS, DataMarts.

• Hitachi Solutions Managed & Live Services engagement offers end to end Support post Delivery & Pre-Sales of ERP Applications, Microsoft AX/CRM Dynamics Applications, and integrated Azure BI
• Job Profile & Summary:
• Service Delivery Management of Dynamics AX/CRM ERP applications & lead a team of Managed Services Support driving post Implementation of AX/CRM suite integrated with MS BI Reporting & PowerBI
• Worked as the SQL/BI focal point driving high availability, SQL query optimization, performance tuning & Microsoft best practices for Database/BI layers of Microsoft AX & CRM Dynamics applications
• Driven MSBI & PowerBI dashboard integrations with AX/CRM systems, and to analyze query behaviors, performance metrics of DW Reports, OLTP/OLAP Data processing with wide experience on
• Create data blends, area charts , Axis charts and dashboards using Tableau Desktop to capture the ERP Customers contracts/ revenues data, Customer Subscriptions data, consumption of subscription on monthly, quarterly wise to perform end to end Business Analytics for each Financial Year
• Create implementation roadmaps in SDLC cycle for Managed Services ERP & .NET applications with resources working on AX/CRM Engineering efforts, Functional & Technical efforts
• Create, analyze, measure & present the reports related to AX/CRM Consulting efforts/billing/ Customer contract & subscription metrics using BI dashboards of CMDB & Ticketing tools for Managed Services Support
• Service Delivery, SLA Management & Reporting & ERP Support engagement reviews for Live AX/Management using PowerBI & Tableau data visualization dashboards and charts
• Contributed implementation of processes such as ITIL Incident/Change/Release Management, BCDR, Capacity Availability Management in alignment with CMMI Industry standards.

• Host Analytics offers their flagship Financial Planning & Forecasting solutions for various customers across the globe and it’s famous Enterprise Performance Management (EPM Suite) products offer strategic financial solutions to CFO & CMO offices of the organizations
• The Service Engineering & Technical Operations business unit owns the end to end landscape of the Self-Managed On-Premise/Cloud managed Datacenter services, Service Engineering solutions for Web & Database Applications on premise/in Private/Public cloud capacities to the Host Analytics EPM customers
• The scope of this project constitutes of building/managing IT Infrastructure, Deployment of EPM suite web & database applications, and offer the premium Application & Service Operations support
• Job Profile & Summary:
• Commissioned & designed the entire database layer for HA EPM product in AWS, collated & self-managed datacenters
• Has spearheaded the Service Operations & Database Management, OLTP/OLAP Re-Engineering for ¬800 EPM SaaS Tenants
• Brought in key contributions to the Hardware/Network/Capacity/ designs for various new Data-center & existing Datacenter migration projects to Cloud with expertise on IT Infra, Compute & Capacity requirements for Database & Middleware Applications
• Driven the opportunity to migrate hundreds of EPM Tenants across On-Prem & Cloud Datacenters & brought in expertise to accelerate Middleware & Database Applications migration
• Played critical roles accomplishing Production & Pre-Production Data Center migrations: Spearheaded the migrations ranging from the migrations of Web Apps, migration of Huge/Large/Medium Databases, OLAP/OLTP databases for 700 odd Production customers & tenants
• Heavy contributions to performance tuning SQL OLTP/OLAP workloads spanning core EPM Apps, BIRST/Qlik Visualization Apps
• Deep dives with OLTP & OLAP Data Loads & BI Reports performance and conducted POCs to review the design of DW/BI Data marts, Schemas, Dimensions, Keys, Hierarchies etc
• Accomplished various out of box projects to enhance the user concurrency of EPM applications from 250 to 5000
• Contributed to BI Reporting & Data Engineering efforts on Business Analytics Apps integration with Host EPM application
• Data Engineering & Reports Analysis with Business Analytics tools using Tableau/BIRST integrated with EPM suite application
• Implemented best practices for Database logical design with schema, constraints, normalized vs de-normalized object designs, SQL Query Optimization, Index Optimization & management, DB Tuning advisor, Snapshot Isolation techniques etc
• Implemented best practices for physical Database design and brought in performance tuning with data FileGroup structuring, Huge DB horizontal partitioning etc
• Implemented SQL native 128/256 bit TDE RDBMS encryption
• Implemented SQL Replication/Always ON Read intent techniques to split/offload OLTP/OLAP traffic
• Contributed to SaaS Farming techniques such as OLAP cube partitioning/ OLAP cube synchronization to bring performance improvements in BI Reporting & OLAP world
• Spearheaded Agile Sprint collaboration with NOC, Engineering Teams & Product Teams
• Contributed heavily to 6 Major Releases on the database layer of HA EPM product, multiple Datacenter commissions & in span of 18 months
• Contributed to configuration of monitoring tools such as Logic Monitor, Alert Site, New Relic, SQL Sentry and consequently streamlining the monitoring tools for EPM Infrastructure, Services & Applications
• Collaborated with other stake holder teams such as Product Management & Application Development teams to innovate/manifest/build to test & deploy the OLTP/OLAP features of EPM Product.

• The project ‘Service Transition’ offers the full cycle Build/Incident/Change/Problem Management on the IT Infrastructure & Middleware layers for the Microsoft Global CFIT/FIT/HRIT Application
• The Service Transition stands as the Service Delivery Organization managing the Infra/DCOPS, DBOPS (MSIT) deployed in Microsoft self-managed/Cloud Managed global datacenters
• Contribution
• Has accomplished many time & mission critical Microsoft customer projects in highly scaled Corporate Function IT portfolios of Microsoft IT
• In SDM capacity, Contributed heavily to the Planning Engine by creating road maps, architecting solutions & execution engine with Project Plans
• Contributed to build & manage many solid IT Infrastructure & Database Support with consistent delivery excellence to Microsoft customers & internal/external stake holders
• Job profile & summary:
• Architecting & planning customized IT Infra, Middleware & Database solutions based on the portfolio & client requirements
• Creating road maps starting from the procurement of servers, OS/SQL builds, Technology deployments/upgrades, SQL Database Administration & Management in Microsoft collated & Azure datacenters
• Accomplish technically complex time and business critical projects/deliverables constituting technologies such as MSSQL, IIS, SSRS/SSAS/SSIS , Microsoft AD DS, VM Management with Hyper-V etc
• Plan & build high performance InfraOps/CloudOps/SysOps/DBOPS/AppDBA teams supporting the Infra & Database layers
• Responsible for building Dev/Test/UAT & Production SQL Servers, Web Servers in MSIT from scratch following SDLC cycle and accountable for customized software & hardware configuration tasks as per the client requirements
• Accountable for the full cycle of change management adhering to ITIL & CAB processes to implement changes involving the deployment of various supported Microsoft Technologies
• Build Roadmaps /plan/configure/maintain various SQL configurations such as SQL Maintenance Plans, SQL Performance Tuning, BCDR methods, High Availability solutions such as SQL Always ON/clustering/Mirroring/Log-Shipping/Replication
• Build various SQL servers with SSAS, SSRS, SSIS & other Developer Tools and contributed to OLTP/OLAP workload performance & cost optimizations
• Part of overseas trips to spearhead data driven solutions/innovation across the Customers For Life, Product Management, Service Operation teams supporting the HA Products.

Contribution & Technical Summary:

• Subject Matter Expert for Microsoft SQL Server & Middleware technologies leading Change Management and App Support for The Hartford Insurance applications
• Plan, lead & Manage all middleware & database layer changes with Microsoft Technologies and architected/customized solutions for client specific requirements to address business needs of The Hartford Insurance company IT infrastructure
• Responsible for providing the highest level of support for SQL DBA & IIS Admin roles and responsibilities
• Leading Incident and Problem Management areas as a SME for Microsoft SQL Servers, IIS, Microsoft Web Servers and business critical web portals
• Leading SLA, CAB & ITIL Process Management for Changes/Incidents related to Microsoft Technology based Applications and driving efficient Support Teams
• Worked as SME on PostgreSQL/MSSQL & other Middleware technologies managing the IM/CM/PB support teams

• Fragrances
• Web & Database Technologies -, International Flavors & Fragrances (IFF) manufactures wide range of Flavors & Fragrances for FMCG industries across the globe
• Contribution & Job Profile and Technical Summary: The job roles constitute but not limited to engineering and management of premier IT Infra projects managing Microsoft Technologies such as Microsoft SQL Server, Active Directory, IIS, and hands on experience monitoring with SCOM, VMWare, SolarWinds
• The role offers L3 support on MS SQL RDBMS, OLAP, OLTP & Middleware Applications
• SQL DBA support for all the production Servers in IFF global data centers and the responsibilities include deployment of new projects, Applications managing & enhancing features/functionality of exiting IIF internal applications
• SQL DBA support for all production database servers with SQL 2000, 2005 and 2008 and deploying various features such as SQL maintenance plans, log shipping, DR plans, mirroring, Index maintenance
• Leading the Incident/Problem/Change/Prevention Management areas of SQL Server and database management
• Working closely with other Oracle DBAs for the data migration support activities
• Building numerous SQL servers and managing/fine tuning critical large/huge databases containing IFF confidential OLTP/OLAP data
• And maintaining all internal and business websites of IFF and IIS administration of various websites and web servers deployed on IIS5, IIS6 and IIS7
• Leading the deployment, support and maintenance activities of projects and business critical applications which are cohesively implemented with SQL-IIS technologies
• Played pivotal role to migrate OLTP/OLAP workloads to Azure Cloud & part of overseas trips to USA for heavy-lift /rehome strategy from On-Prem to Azure/AWS Cloud.

• Providing Technology Solutions for the top notch clients of Butler and specifically dealing with the roles-Windows Administration of Windows Servers (2000/2003/2008) deployed with various end user applications, L4 SQL DBA support for the production database servers, IIS Administration of websites, Active Directory Admin activities for the users and objects of client application called EMC AppEXtender
• Building numerous SQL servers in PROD & DEV environments and support IFF PROD applications
• IIS Administration of various client web portals, administration of the web servers, creation and configuration of various websites, configuration and redirections of Virtual Directories and URLs, Debugging all categories of IIS application errors and providing the fixes
• Providing Level III support for various Microsoft technologies implemented for the client business units and systems
• Served as a go to resource for the Database & Middleware layers
• Windows & AD Administration of Windows 2000, Windows 2003 and Windows 2008 servers deployed with SQL database and IIS Admin applications
• Working closely with other SQL DBAs and Oracle DBAs to provide customized servers for the data migrations and debugging of the end user issues (ODBC Environment).

• Project Description
• Microsoft GFS & MSN projects constitute support roles such as Remote Monitoring, Windows Administration and Level II Support of approximately 80 lakh Windows Servers and 6 thousand core Network devices
• Summary & Job Profile:
• Proved & acknowledged as one among the top performing resources in OCIM Incident Management support projects of MSN/GFS
• Played key roles to address business impact issues, outages, mission & time critical incidents occurred in GFS/MSN accounts
• Mentored & trained many new resources during his tenure with MOC/OCIM support projects in MSN account
• Roles: WINTEL & SQL L2 support for Microsoft Global Foundation Services and datacenters
• Remote Monitoring, Windows Administration and Level II Support of approximately eighty thousand Windows Servers and 6 thousand core Network devices which are part of various network domains and constitute all the Microsoft data centers around the globe
• Worked extensively on Incident and Problem Management areas in MSN production environments with: Windows Servers Administration (win2003/2005/2008) and support of the integrated technologies and applications such as SQL Server, SQL Management Studio (2000/2005/2008), Web Servers, IIS (6.0 and 7.0)
• The challenges include finding the root causes, debugging the issues, finding the fixes, prevention of the issues, deployment of the changes, and creating the troubleshooting documents in knowledge base
• Conducting monitoring and bug investigations which comprise of change/disable of existing monitoring rules/thresholds create volume drivers and eliminating the non-actionable or false alerts with the help of the tools and part of various enhancements of the efficient Incident and Problem Management environments
• Part of overseas trips and knowledge transformations to understand expectations and the system of working of the client at Microsoft, Redmond, USA and bridged the enhanced and vital functions of working to the teams at overseas and offshore for the manifested customer experiences.

• Academics:
• Graduation.