Summary
Overview
Work History
Skills
Certification
Work Authorization
Timeline
Generic

Manasa Reddy

Chicago,IL

Summary

Accomplished Sr. SQL Server Database Administrator with extensive experience at Bank of America, adept at optimizing SQL Server environments and implementing high availability solutions. Proven expertise in Azure SQL Database management and performance tuning, coupled with strong problem-solving skills to enhance operational efficiency and ensure data integrity.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Sr. SQL Server Database Administrator

Bank Of America
Chicago, Illinois
03.2022 - Current
  • Company Overview: Randstad Technologies.
  • Managed 24/7 operational oversight of all SQL Server databases across platforms.
  • Managed over 500 SQL Servers, ranging from 10 GB to 6 TB.
  • Installed and configured SQL Server on Windows servers.
  • Led database and infrastructure physical design, executed database upgrades, and applied software patches to meet specific application and client requirements.
  • Proficient in working with Azure SQL Databases, managing, and optimizing cloud-based database environments.
  • Supported the migration of on-premises SQL Server databases to Azure SQL Database as part of the company’s cloud adoption strategy.
  • Lead the administration of SQL Server instances in a high-availability environment, utilizing Always On Availability Groups, Log Shipping, and Replication for disaster recovery and continuous uptime across multiple regions.
  • Administered and managed the Informatica PowerCenter platform to streamline data integration processes.
  • Scheduled and monitored Informatica workflows using JAMS and Control M, ensuring timely execution of ETL jobs, and providing proactive troubleshooting support to resolve issues as needed.
  • Implemented Rubrik for SQL Server databases backup and recovery, achieving rapid restoration during data loss.
  • Encrypted multiple SQL Server databases using Azure Managed HSM, Azure Key Vault, and Gemalto keys.
  • Handled Batch processes, SSIS, DTS, BCP operations efficiently.
  • Created and managed JAMS jobs, setups, workflows, and triggers to automate various application-related processes, including Informatica workflows, file movements, SSIS jobs, and executing SSRS subscriptions after a set of ETL processes.
  • Deployed SSIS packages, SSRS reports, and applied enhancements to databases as per application requirements.
  • Configured and monitored snapshot and transaction replication to offload the data for reporting purposes.
  • Administer the databases using PowerShell/T-SQL scripts, and automate several frequently running processes.
  • Implemented table partitioning on large tables to enhance query performance.
  • Monitored database status includes CPU, memory, management, blocking, and deadlock issues, using the Spotlight tool to ensure optimal performance.
  • Experienced in tuning stored procedures, index tuning.
  • Experienced in creating user-defined roles and granting privileges to the database and database objects (role-based access control).
  • Provided technical support to both internal developers and external clients, resolving issues, and offering guidance.
  • Monitored the availability and performance of production databases and servers to maintain system uptime and efficiency.
  • Developed and scheduled various jobs using Control M to automate Informatica workflows, guaranteeing timely task completion.
  • Played a key role in migrating JAMS jobs to Control-M.
  • Installed Control M agents, configured connection profiles, and set up run-as users to ensure seamless job execution and integration with target systems.
  • Monitored and diagnosed SQL Server performance in real time using Spotlight, ensuring optimal server health and database activity.
  • Configured custom alerts for key performance metrics, like CPU, memory, I/O, and wait statistics, to proactively identify and address performance issues.
  • Administered the Snowflake platform by creating databases and schemas, and managing user access by assigning appropriate access roles and functional roles based on requirements.
  • Implemented data sharing and integration processes within Snowflake, facilitating seamless data collaboration across different departments, while maintaining secure access control and governance.
  • Developed and implemented backup policies using the Azure Backup Portal, ensuring database backups aligned with business continuity objectives.
  • Integrated SQL Server databases into Azure Backup policies, automating backup schedules for full, differential, and transaction log backups to maintain robust data protection.
  • Experienced in implementing Windows security policies and managing User Access Control to ensure data protection and compliance.
  • Utilized ServiceNow and JIRA ticketing systems for tracking, managing, and resolving incidents, service requests, and change management processes.
  • Environment: MS SQL Server 2022, 2019, 2017, 2016, 2014, 2012; SSIS; SSRS; Snowflake; MS Excel; Oracle 11g; Oracle 12c; Windows Server 2022, 2016, 2012, 2008 R2; Spotlight; Rubrik; JAMS; Control-M; ServiceNow; and JIRA.

Sr. SQL Server Database Administrator

Alabama Dept. of Corrections
08.2020 - 02.2022
  • Set up and configured SQL Server environments on Windows servers, ensuring smooth operations for both development and production environments
  • Directed the design and architecture of database infrastructure, overseeing database upgrades and the application of software updates to align with client and project needs
  • Performed regular performance tuning and optimization using tools like SQL Profiler, Database Tuning Advisor, and Query Store to improve query execution times and overall system performance
  • Implemented and managed high availability solutions such as Always On Availability Groups, Database Mirroring, and Log Shipping to ensure continuous uptime and data protection
  • Enforced database security measures, managed user access and permissions, and implemented Transparent Data Encryption (TDE) and auditing features to ensure compliance and data integrity
  • Managed and optimized ETL processes using SSIS for data integration and transformation, ensuring data accuracy and integrity across systems
  • Deployed, managed, and optimized SSRS reports and subscriptions, ensuring accurate and timely delivery of business intelligence to end-users
  • Identified and resolved database performance issues, blocking processes, deadlocks, and query optimization problems, ensuring minimal downtime and continuous operations
  • Automated routine database maintenance tasks such as indexing, backups, and log management using SQL Agent jobs, PowerShell, and T-SQL scripts to improve efficiency and reduce manual intervention
  • Created Linked Servers from SQL to SQL and Oracle
  • Implemented proactive monitoring systems and configured alerts to detect and resolve issues before they impact the database environment
  • Worked closely with developers to optimize database schema, troubleshoot application-related issues, and ensure seamless integration between databases and applications
  • Performed capacity planning, monitored system resources (CPU, memory, disk space), and provided recommendations for scaling SQL Server infrastructure to meet growing business demands
  • Implemented table partitioning strategies for large datasets to improve query performance and manageability, ensuring faster data retrieval, efficient indexing, and optimized maintenance operations
  • Environment: MS SQL Server 2017/2016/2014/2012/2008R2, SSIS, SSRS, MS Excel, Oracle 11g, Windows Server 2012/2008R2, Jira, PowerShell, spotlight and Change gear

Sr. SQL Server Database Administrator

Bank of America
Plano, TX
01.2020 - 03.2020
  • Company Overview: Skill Storm
  • Extensive experience in managing, upgrading, and optimizing SQL Server environments across versions and platforms, including setting up high availability and disaster recovery solutions like clustering, replication, and Always-On Availability Groups
  • The expertise extends to performance tuning, T-SQL scripting, SSIS and SSRS package deployment, Azure cloud migration, and mentoring team members while providing 24/7 production support
  • Skill Storm

SQL Server DBA

Bank of America
Frisco, TX
10.2016 - 10.2019
  • Company Overview: Randstad Technologies
  • Installation and Maintenance of SQL Server 2008R2/2012/2014/2016/2017 on Production and Non-Prod environments
  • Upgrading SQL server 2012/2014/2016/2017 and applying Service packs wherever needed
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan
  • Configured Active- Active, Active- Passive clustering (two node and multi node) on physical and virtual environments
  • Configured Always-On Availability Group with synchronous and asynchronous secondary replicas
  • Configured Transactional replication from multiple publishers to one subscriber
  • Creating and Maintaining Database Maintenance Plans
  • Performed database refreshes from prod to non-prod environments
  • Configured Database Mail for failure Job notifications
  • Modify Stored Procedures and complex T-SQL Queries to improve query execution process
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs
  • Used Extended events and SQL Server Profiler to tune queries and troubleshoot issues on server level
  • Worked with database tuning advisor, SQL server profiler, Performance counters and activity monitor for Performance tuning
  • Used DBCC and DMV commands for day-to-day troubleshooting tasks
  • Import data across multiple instances using BULK INSERT and BCP Utility
  • Involved in Capacity Planning, Database Normalization and De-normalization process
  • Optimized the database server using DMV's and DMF's and performed a code review and tuning for the best performance of the application
  • Involved in Logical and Physical Data Modelling process using MS Visio
  • Involved in Change Data Capture process
  • Involved in creating SSIS package configurations and also involved in the deployment of the SSIS packages to the production environment
  • Created SQL SERVER Jobs to execute SSIS packages using SQL SERVER Management Studio for the daily load
  • Involved in troubleshooting the stored procedures and the SSIS packages (whenever SQL Server Jobs fails)
  • Involved in creating and deploying different types of SSRS reports such as Tabular reports, Matrix reports, Drill Down reports etc
  • Disaster Recovery Planning, Testing and analyzing, preparing continuous updates of documentation
  • Experience in dealing with the issues related to High Availability Techniques such as Log shipping, Mirroring, Replication (Transactional and Snapshot), clustering and Always on
  • Migrated on premise SQL databases to cloud services of Azure
  • Configured Transactional Replication between on premise publisher and Azure SQL database (Push subscription)
  • Setup and configured Distributed Availability groups for Disaster Recovery
  • Designed Network Security Groups (NSGs) to control inbound and outbound access to network interfaces (NICs), VMs and subnets
  • Setup Azure Virtual Appliances (VMs) to meet security requirements as software-based appliance function
  • Mentoring junior team members and creating documents on daily basis
  • 24
  • 7 on-call Production support
  • Randstad Technologies
  • Environment: MS SQL Server 2017/2016/2014/2012/2008R2, SSIS, SSRS, MS Excel, Oracle 11g, oracle 12c, MS Access, MS Visio, Windows Server 2016/2012/2008R2, Foglight, LiteSpeed, Avamar and ITSM

Skills

  • Windows Server 2022/2016/2012 R2
  • SQL Server Management Studio
  • SQL Server Business Intelligence
  • MS-SQL Server 2022, 2019, 2017, 2016, 2014, 2012
  • MS Visual Studio 2019, 2017, 2015, 2012
  • Azure SQL Database
  • Azure Managed Instances
  • Snowflake
  • Transact SQL (T-SQL), PowerShell
  • SSRS, SSAS
  • ETL: Informatica, SQL Server Integration Services (SSIS)
  • Scheduling tools: JAMS, Control M
  • Data modelling Tools: ER Studio, Erwin
  • Monitoring Tools: Spotlight, Foglight, Guardium, Dynatrace, SQL Profiler
  • Backup Tools : Azure Backup services, Rubrik, Avamar, Netbackup
  • Data security : Transparent Data Encryption (TDE), Gemalto third party keys, Azure Key vault, Managed HSM
  • Ticketing systems : Service Now, Jira, Change gear, Nexus, ITSM

Certification

Microsoft certified Azure Database Administrator Associate

Work Authorization

Green Card Holder

Timeline

Sr. SQL Server Database Administrator

Bank Of America
03.2022 - Current

Sr. SQL Server Database Administrator

Alabama Dept. of Corrections
08.2020 - 02.2022

Sr. SQL Server Database Administrator

Bank of America
01.2020 - 03.2020

SQL Server DBA

Bank of America
10.2016 - 10.2019

Similar Profiles

CREATE PROFILE
Manasa Reddy