Sai praneeth K

Designed and maintained scalable OLTP and OLAP database architectures using PostgreSQL, SQL Server, Azure SQL Database, Azure SQL Managed Instance, PL/pgSQL, T-SQL, stored procedures, views, indexing, partitioning, Query Store, SQL Profiler, and Azure Monitor. Delivered end-to-end database modernization solutions from requirements gathering and design through development, testing, deployment, monitoring, production support, and operational handoff. Built secure data integration patterns across relational databases, files, APIs, SaaS platforms, operational systems, data marts, and centralized analytics platforms. Improved reliability through automated testing, data validation, reconciliation, schema checks, SQL Agent alerts, Azure Monitor dashboards, failure notifications, runbooks, and proactive controls. Optimized PostgreSQL, SQL Server, and Azure SQL workloads using indexes, partitioning, statistics updates, execution plan analysis, query refactoring, resource sizing, and workload isolation. Created HLD/LLD documents, ER diagrams, logical and physical data models, source-to-target mappings, indexing standards, runbooks, release notes, and database delivery standards. Supported business reporting, KPI dashboards, operational analytics, stakeholder demos, and data analysis using SQL, Power BI, SSAS, SSRS, Tableau, and governed relational data assets.

Designed database and application architecture integrating PostgreSQL, SQL Server, Azure SQL Database, transactional systems, APIs, dimensional marts, SSAS models, Power BI datasets, and enterprise reporting layers. Developed SQL, PL/pgSQL, T-SQL, stored procedures, views, functions, SSIS packages, and Azure Data Factory pipelines for high-volume transactional, analytical, operational, and reporting data. Built scalable batch and incremental ETL pipelines using ADF, SSIS, SQL Server Agent, stored procedures, control tables, metadata-driven processing, and restart logic. Implemented database security and governance using RBAC, schema-level permissions, service accounts, encryption, audit trails, SQL Server auditing, PostgreSQL role design, and least-privilege access principles. Automated database deployments using Git, Azure DevOps, Jenkins, CI/CD, migration scripts, schema versioning, and environment-specific configuration management. Built monitoring dashboards and alerts for latency, blocking, deadlocks, index usage, failures, job health, and database performance issues. Presented technical designs, integration status, refactoring plans, performance tuning updates, data modeling decisions, and analytics delivery progress to stakeholders and leadership teams.

Built database-backed applications using SQL, PL/pgSQL, T-SQL, PostgreSQL, SQL Server, Azure SQL, Python, Java, PowerShell, SSIS, and Shell scripting. Designed ETL pipelines that transformed APIs, files, relational databases, operational events, and source feeds into normalized master data tables, curated data marts, dimensional models, and warehouse structures. Migrated and refactored legacy SQL Server workloads to modern relational platforms using PostgreSQL, Azure SQL, Azure Data Factory, Power BI datasets, and warehouse design standards. Created Python and PowerShell utilities for failure monitoring, data lineage checks, root-cause analysis, integration debugging, and production support. Optimized database and reporting workloads with partitioning, indexing, statistics maintenance, execution plan review, query rewriting, and resource monitoring. Developed BI-ready datasets and dashboards using Power BI, SSAS, Tableau, and governed dimensions and metrics.

Developed Python backend applications supporting financial and operational systems. Created RESTful APIs and reusable service components. Built ETL and automation solutions using Python, Pandas, and SQL. Developed cloud-based solutions using AWS services including EC2, S3, Lambda, and RDS. Implemented database integrations using PostgreSQL and MySQL. Automated business workflows and reporting processes. Participated in software architecture and design discussions. Developed unit tests and performed application debugging and optimization.

Developed Python applications and internal automation tools. Built backend services using Django and Flask frameworks. Created REST APIs for enterprise integrations. Developed SQL queries, stored procedures, and database solutions. Automated manual business processes using Python scripts. Implemented object-oriented programming principles and design patterns. Performed testing, debugging, and production support activities. Collaborated with developers, analysts, and QA teams in Agile environments.