Sangeetha Mandapaka

Alpharetta,GA

Summary

Overall 8 years of IT experience in IT Infrastructure support projects with ITIL and Agile knowledge with SQL Server DBA and Azure Cloud implementing and managing release processes for code through development, test, and production environments. Implementation experience with medium to complex on-prem to Azure migrations. Experience in Distributed Availability Groups(SQL AG). Conduct Release Readiness reviews, Milestone Reviews, and Business Go/No-Go reviews. Lead a team and define project principles and guidelines for the team to adopt. Experience in implementing disaster recovery plans and participated in Disaster Recovery testing. Experience in designing enterprise-wide database backup and recovery plans. Comprehensive experience in Change Management and ticketing system software such as Team track, Service Now ticketing tool, service center and Remedy. Self-motivated team player with excellent verbal and writing communication skills.

Domains: Financial Services, Retail, Energy, Manufacturing, Tech

Overview

years of professional experience

Work History

SQL Production DBA

Freddie Mac

03.2020 - Current

Monitor and Troubleshoot SQL Server Performance using Query Blocking and Deadlocking Issues
Worked on production Break issues which include performance, blocking and space-related issues
Implemented Always on High availability and Disaster recovery on all migrated instances
Develop and maintained Ci/CD methodologies to speed development process through automation.
Update procedure documentation to improve training procedures.
Worked on Extract Transform and Load source data into respective target tables
Developed different maintenance plans for database monitoring
Maintained server and Database security Including database encryption (TDE)
Troubleshoot and identify performance, connectivity and other issues for applications hosted in Azure platform
Administer and monitor snowflake computing platform
Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision
Documented and analyzed business reports for prompt communication, follow-up and ongoing support
Incorporated extensive familiarity for data management and backup and recovery accountability
Solid understanding and Experience in cloud computing based services architecture, technical design and implementations including IaaS, PaaS, and SaaS
Demonstrated respect, friendliness and willingness to help wherever needed.
Excellent communication skills, both verbal and written.

SQL DBA

Kohl’s Corporation

10.2018 - 03.2020

Responsible for implementing and managing release processes for code through development, test, and production Database environments
Responsible to collect release scope from project managers and release windows and cycles across portfolio
Application Support, Build and Release Management activities
Orchestrate environment activities including provisioning of environments, configuration status, stability, and maintenance
Involved in Migration of SQL server 2008 R2 to SQL 2016
Work with release engineers to understand impacts of branches and code merges
Performed all aspects of database administration, including backup, recovery, and replication for SQL server
Solid experience on plutora to track releases and environment details
Worked on install and configuration of Always ON
Implementation of Distributed Availability Groups on Azure Cloud
Leading responsibility to drive innovation based on data which is first time efforts in organization to move towards completely data driven business
Maintain cloud data processing platform and environment utilizing services provided by azure platform
Coach, mentor technical team member as required
Responsible for managing development and performance of SQL databases, BI reports and ETL interfaces for web and business applications
Responsible for configuring servers, processes and automating tasks to improve reliability and cut down on development time
Implement highly available and disaster recovery solutions in Azure to meet customer SLA requirements
Analyze organization’s data management, input and security needs and help develop tools that support data access and information security
Solid experience in Tableau and Power BI, creating reports for business.
Identified issues, analyzed information and provided solutions to problems.
Participated in team projects, demonstrating ability to work collaboratively and effectively.

Sr. SQL SERVER DBA

CAPITAL ONE BANK

11.2017 - 10.2018

Worked on migrating SQL server 2005/2008/2008R2 to SQL server 2012
Responsible for deploying scripts, only when CO (change order) is accepted and approved by DBA manager
Recovering database from backup in disasters
Implementing point-in-time recovery solutions
Responsible for Remediating Nezumi (security) violations and maintaining as per standards
Creating monthly metrics reports for resource utilization in Projects and forecasting future requirements from clients
Migrated data from SQL to Oracle using SSIS as per application team request
Monitoring server and database to detect any problems in performance or connections, especially if an error was notified by application team in all environments
Replication – Configured and maintained Transactional replication
Involved in various DBA activities like taking backups and restore as per application need, creation of logins with necessary permissions, creating disk space reports, memory and connection issues, blocking and file growth issues etc.
Self-motivated, with strong sense of personal responsibility.

SQL SERVER DBA

MICROSOFT

08.2016 - 11.2017

Involved in installation of SQL Server on Consolidated and Standalone environments and maintains development and production databases (e.g., SQL Server databases)
Involved in creating maintenance plans for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application based on standard processes
Worked on Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally
Worked on DTS Packages, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server
Defined and provided recommendations database standards, procedures and architecture
Worked with Database tools IDERA, SQL Diagnostic manager, Sites cope for Multi Queries, Space analyzer, SQL alerts(Disk space alerts, SQL Service alerts, CPU utilization alerts).
Passionate about learning and committed to continual improvement.
Delivered services to customer locations within specific timeframes.

Education

Skills

T-SQL, XML, HTML Script
MS SQL Server 2019,2017,2016,2012, 2008, 2005, 2000, MS-Access, Oracle,My SQL

SQL Spotlight by Quest, Lite speed, Octopus deployment Tool, Idera Diagnostic Manager, MS system center operations Manager (SCOM), Red Gate,Jenkins,TFS,SolarWinds

Timeline