Sql Server Azure

SANJAY RAMPALLY

PH: 945-***-****

LINKEDIN: https://www.linkedin.com/in/sanjayveer

BLOG: https://medium.com/@sanjayvrr.azure

CAREER SUMMARY

DATABASE ARCHITECT • DEVOPS • CLOUD OPERATIONS • MENTOR.

Over 12 years of expertise in designing, implementing, supporting, and administering distributed applications and database systems.

Managed a large-scale MS SQL Server farm (2000+ servers), ensuring high availability, performance tuning, security, and capacity planning.

Hands-on experience with SQL Server internals, high availability configurations (Always On, Failover Clustering, Log Shipping, Replication), and performance tuning.

Extensive Azure expertise in Azure SQL Database, Azure Managed Instance, Cosmos DB, and PostgreSQL, ensuring high availability, performance optimization, and cost efficiency.

Migrated and optimized SQL Server workloads to Azure SQL Managed Instance and Azure Virtual Machines, leveraging tools like Azure Migrate, DMS, and Log Replay Service.

Designed and implemented Azure governance strategies, including RBAC, Policy Compliance, Cost Management, and Security Center monitoring.

Configured and optimized Azure Data Factory (ADF) for data ingestion and transformation, integrating with Synapse Analytics, Azure Storage, and Cosmos DB.

Automated infrastructure provisioning using Terraform, Ansible, ARM templates, and Bicep for Azure cloud deployments.

Developed CI/CD pipelines using Azure DevOps, Jenkins, and Terraform, streamlining database code deployment, version control, and security policies.

Expertise in Kubernetes (AKS, EKS) and Docker for containerized deployments, improving scalability and operational efficiency.

Configured Azure Monitor, Log Analytics, and Application Insights to track database health, security incidents, and performance trends.

Ensured data security and compliance (GDPR, HIPAA, CCPA) through Azure Key Vault, Transparent Data Encryption (TDE), Always Encrypted, and Azure AD authentication.

Implemented Azure Backup and Site Recovery for disaster recovery and business continuity planning.

Automated database maintenance tasks using Azure Automation, Runbooks, PowerShell, and Ansible, reducing manual intervention.

Architected hybrid cloud solutions, integrating on-premises databases with Azure services using ExpressRoute and VPN Gateway.

Led on-prem to Azure SQL migration projects, ensuring minimal downtime and data consistency using Azure DMS and transactional replication.

AWS experience includes RDS, Aurora, EC2, and S3, ensuring high availability and optimized cloud storage.

Managed SQL to AWS EC2 migrations, leveraging Rubrik, AWS Backup Service, and Terraform for infrastructure automation.

Worked with AWS Glue, DynamoDB, and Redshift to design data pipelines and optimize analytics workloads.

Strong expertise in Infrastructure as Code (IaC) principles, implementing configuration management and automation using Ansible, Terraform, Kubernetes, and Jenkins.

EDUCATION & CERTIFICATIONS

Microsoft Azure Certified Professional DP-300

AWS cloud practitioner

Azure AZ-104

Azure AZ-900 Fundamentals

Azure AZ-203 Data Engineer

Bachelor of Engineering in Information Technology (2011)

AREAS OF EXPERTISE

Database Platforms: MS SQL Server, Azure Synapse, Azure SQL, PostgreSQL

Cloud Platforms: Azure (Azure Data Factory, Microsoft Fabric, Analysis Services), AWS (Lambda, CloudFormation)

Data Warehousing: MPP architecture, data warehouse design, OLTP systems

Performance Optimization: Query tuning, indexing strategies, resource utilization

Infrastructure as Code (IaC): Terraform, Azure Resource Manager, Docker, Ansible, AWS CloudFormation

Scripting Languages: PowerShell, Python

Database Administration: Backup, recovery, monitoring, troubleshooting, and capacity planning

Automation: Provisioning, process improvement, and intuitive design

Disaster Recovery: High availability (HA) and disaster recovery (DR) implementation

Data Security & Compliance

CI/CD & DevOps: GitHub Actions (GHA), Jenkins, Git

Monitoring & Performance Tools: SQL Server Profiler, Azure Monitor, SolarWinds, Datadog

Data Management & BI Tools: SSIS, SSRS, SSAS, IBM VDP

Operating Systems: Windows, Linux, Unix shell commands.

Transact-SQL (T-SQL): Writing complex queries, stored procedures, triggers, indexing strategies

PROFESSIONAL EXPERIENCE:

Client: Orange County, New York (UTC ASSOCIATES) NOV ’22—Present

Role: LEAD Database /Engineer

Responsibilities:

Managed and optimized MSSQL 2008 R2, 2012, 2014, 2016, 2017, 2019, and 2022 instances within Azure IaaS, ensuring high availability, performance, and security.

Implement and manage backup and recovery solutions using Commvault, ensuring data protection and compliance.

Conducted regular performance monitoring, utilizing Red Hat Linux tools for tuning databases and application queries.

Administer and optimize Azure SQL Databases, ensuring high availability and minimal downtime

Developed T-SQL scripts for automation, data transformation, and performance enhancements

Implemented CI/CD pipelines in GitHub & Azure DevOps (ADO) for database versioning and automation

Designed and maintained Azure Redis caching to improve query performance in high-traffic applications

Managed database migrations, backup strategies using Azure Blob Storage, and disaster recovery plans

Integrated SQL databases with RESTful APIs for seamless data exchange across microservices

Collaborated with Agile teams to improve database performance and optimize stored procedures

Implemented AI/ML workflows using AWS SageMaker for predictive analytics and anomaly detection, improving operational decision-making.

Leveraged CloudFormation templates for infrastructure as code (IaC), automating the provisioning of AWS resources across multiple environments.

Optimized cloud costs using AWS Cost Explorer and Savings Plans while maintaining high performance for critical workloads.

Set up and maintained cross-region replication and disaster recovery strategies using Amazon S3 and CloudWatch alarms for business continuity.

Installed, configured, and managed RDBMS databases on Red Hat Linux, ensuring stability and high availability.

Analyzed and interpreted complex datasets using Power BI to provide business insights for decision-making.

SQL Server and Oracle databases to Azure SQL, enhancing system performance and cost efficiency.

Created and configured new servers, maintaining standardized setups across the environment.

Researched and executed Transparent Data Encryption (TDE) and Always Encrypted standards for Azure SQL databases to meet rigorous security and compliance requirements.

Client: ASSA ABOLY Nov’20 – Oct ‘22

Role: Cloud Engineer

Responsibilities:

Orchestrated SQL Server installations, migrations, service pack upgrades, and hotfix installations across various environments, including azure cloud infrastructure.

Assisted in the integration of SSO for database and application access, enhancing secure login processes.

Administered Active Directory, Azure AD Connect, and Azure AD Domain Services, ensuring robust identity management and seamless SSO integrations.

Migrated legacy SQL databases to Azure SQL PaaS and Azure Virtual Machines

Configured and fine-tuned indexing strategies, partitioning, and query optimizations

Developed stored procedures and triggers in T-SQL, ensuring efficient data processing

Implemented Azure Blob-based backup strategies for disaster recovery and compliance

Led GitHub version control and database release processes in Agile sprint cycles

Analyzed and interpreted complex datasets using Power BI to provide business insights for decision-making.

Created Custom Power BI reports and dashboards by transforming data from SharePoint and SQL databases.

Leveraged extensive knowledge of infrastructure, server principles, and virtualization technologies to maintain and optimize SQL server performance.

Client: MICROSOFT (Clients: PNC BANK /CITI BANK) May’17 – Oct’20

Role: Lead database Administrator

Responsibilities:

Spearheaded a cloud enablement project, migrating legacy application servers to the Azure cloud, ensuring modernization and cloud compliance.

Assisted in the integration of SSO for database and application access, enhancing secure login processes.

Set up and manage development, QA, and production environments in Azure, utilizing IaaS and PaaS service models for optimal resource allocation.

Created, configured, and maintained Azure SQL databases, ensuring efficient performance and seamless operation within the cloud infrastructure.

Configured Always on Availability Groups on Cloud VMs to guarantee high availability and business continuity for critical database systems.

Client: AT&T Jan’16 – April’17

Role: Senior SQL Administrator

Responsibilities:

Orchestrated migration of on-premises databases to Azure, utilizing various strategies to ensure effective cloud integration.

Employed the Database Migration Assistant for the seamless transition of large-scale databases to Azure PaaS and VM servers.

Optimized database storage by managing disk space, compressing data, and minimizing transaction log sizes.

Established and managed linked servers, enhancing database connectivity and integration across the production environment.

Addressed and resolved critical database corruption, safeguarding data integrity within production systems.

Implemented table-level data compression, significantly improving database performance and resource efficiency.

Configured RBAC for Azure resources, reinforcing security protocols and managing identity access with precision.

Client: T-MOBILE Jan’13 – Dec’15

Role: Software Engineer

Responsibilities:

Orchestrated SQL Server installations, migrations, and upgrades, ensuring seamless transitions and system integrity.

Implemented database backup, restoration, and disaster recovery strategies, enhancing data protection and business continuity.

Managed high availability solutions such as database mirroring, log shipping, and availability groups, ensuring system uptime and reliability.

Highly motivated and high-performing team player dedicated to achieving collective goals and fostering a collaborative work environment.

Contact this candidate