SWATHI PILLARISETTY
Senior Database Administrator
Atlanta,GA
Summary
Highly driven and result-oriented database professional with over 12 years of proven experience. Expertise in full lifecycle development ensuring smooth functioning of databases. Thrives in collaborative environments, excels as a goal-oriented team player, and maintains effective communication with colleagues and clients. Motivated individual with strong analytical skills, problem-solving abilities, and task management capabilities that consistently deliver high-quality results.
Overview
14
14
years of professional experience
1
1
year of post-secondary education
1
1
Certification
Work History
Senior Database Administrator
ABM Industries
06.2016 - Current
- Spearheaded the installation, configuration, and hardening of SQL Server environments (2012-2022), overseeing both clustered and standalone production/non-production setups while ensuring high availability and disaster recovery with Always-On Availability Groups (AOAG)
- Led the management and optimization of Azure SQL environments, including Azure Elastic Pools and Managed Instances, orchestrating seamless database migrations from on-premises systems to the cloud for enhanced scalability and operational efficiency
- Directed end-to-end database administration, encompassing installation, configuration, upgrades, capacity planning, performance tuning, clustering, security, and continuity, ensuring robust, high-performing, and reliable database infrastructures
- Utilized advanced monitoring tools, such as SolarWinds Performance Analyzer and IDERA SQL Diagnostic Manager (SQLDM), to proactively identify and resolve critical SQL Server issues related to data integrity, performance, blocking/deadlocking, connectivity, and storage
- Executed comprehensive database maintenance, including high-priority backups, transaction log management, and restore operations, while leading SQL Server upgrades from legacy versions (2008 R2) to modern platforms (2019/2022) and deploying corresponding service packs
- Drove system performance optimization through advanced query tuning and indexing strategies, facilitating seamless server migrations and decommissioning with minimal downtime through strategic failover planning and high-level troubleshooting
SQL Database Administrator
Incomm
08.2015 - 11.2015
- Administered SQL Server environments (2005-2012), managing user security policies through login creation, role assignments, and authentication mode configurations
- Enhanced maintenance plans to optimize index maintenance and backup operations, while implementing Always On availability in SQL Server 2012 for high availability
- Developed, maintained, and optimized SSIS packages, SSRS reporting, and database migration documentation, ensuring smooth data transfer and accurate reporting
- Conducted daily DBA tasks, including user permission management, space monitoring, and maintenance job handling, while providing 24/7 oncall support on a weekly rotation
- Designed and implemented comprehensive disaster recovery strategies, automated alerts for task completions, server failures, and monitored resource allocation for secure and efficient database access
- Executed migrations between SQL Server versions, managed database object creation (tables, views, indexes), and maintained version control using SVN for SQL scripts
- Utilized tools like Attunity, Litespeed, and SQL Sentry to streamline backup processes, monitor database health, and ensure operational continuity across production environments
SQL Database Administrator
GSS InfoTech (Client: Wellstar Health Systems)
04.2013 - 08.2015
- Managed SQL Server environments (2000-2012) in both production and test settings, resolving login failures, user permissions, and Active Directory security issues
- Conducted side-by-side database migrations from SQL Server 2000 to 2005/2008/2008R2, ensuring smooth transition and minimal downtime
- Developed and scheduled SSIS packages for regular DBA maintenance tasks and nightly jobs to efficiently import large data volumes, including transformation processes from various sources
- Utilized native tools (Database Tuning Advisor, Profiler, Activity Monitor) and DBCC commands to monitor, analyze, and troubleshoot database health and performance, optimized queries with execution plans and index tuning
- Implemented disaster recovery protocols with detailed documentation, configured log shipping for synchronization, and operated in an active-passive cluster environment to ensure high availability
- Created comprehensive backup strategies, fine-tuned database performance through query analysis, and manually managed index rebuilds with specified fill factors and updated statistics
- Provided routine DBA support, including permissions management, disk space optimization, maintenance jobs, and extensive use of Net backup and TSM for backups; also offered 24/7 on-call support on a weekly rotation
SQL Database Administrator
Meridian InfoTech (Client: Fidelity Investments Financial)
04.2011 - 03.2013
- Installed, configured, and secured SQL Server environments (2012/2008R2/2008/2005) across production and non-production, managing clustered and mirrored setups for high availability
- Upgraded databases from SQL Server 2000/2005 to SQL Server 2008/2008R2 and implemented transactional replication and database mirroring with a third-site strategy using a witness server
- Created complex stored procedures, functions, views, cursors, and triggers as per design specifications, leveraging SQL features such as CROSS JOIN, MERGE, and CASE statements to enhance functionality
- Conducted regular database health checks using DBCC commands and dynamic management views (DMVs), optimizing performance through index tuning, execution plans, and SQL Profiler
- Managed security by resolving login issues, configuring Active Directory permissions, and implementing user-level security across environments
- Utilized SSIS for data migration, employing tasks like flat file imports, bulk inserts, and file system management, and set up log shipping for high availability between server instances
- Designed and deployed SSRS reports with advanced features (group by, drill-downs, drill-through) to support data-driven decision-making within the organization
- Applied patches and service packs across clustered and standalone servers, ensuring system integrity, and maintained Resource Governor for workload management in SQL Server 2008
- Collaborated closely with the development team to optimize SQL queries and stored procedures, improving database performance and efficiency for production and test configurations
SQL Database Administrator
Meridian InfoTech (Client: Network Health)
11.2011 - 03.2012
- Company Overview: Health Care
- Installed, configured, and secured SQL Server environments (2008R2/2008/2005/2000) in both production and non-production settings, including active-passive cluster environments
- Developed, debugged, and optimized stored procedures, functions, triggers (DDL/DML), and queries based on client specifications, improving database performance and meeting client needs
- Migrated legacy DTS packages to SSIS and designed and developed SSIS packages using control flow tasks, transformations, and data flow tasks to support data movement
- Designed and developed SQL Server reports using SSRS (2008), implementing features like group by, drilldowns, and drill-through for comprehensive reporting solutions
- Applied DBCC commands and DMVs to check database health, and actively worked on query optimization using execution plans, index tuning, and performance analysis
- Managed weekly change management processes, executing code developed by the team on production servers, and handled routine DBA tasks, including user permissions and space management
- Implemented high availability solutions, including log shipping between instances, database mirroring for HA and DR, and maintenance of the production server databases
- Used IDERA for monitoring database performance, applied patches and service packs to update SQL Server versions, and configured SQL Server settings in production and test environments
- Assisted development teams by optimizing SQL queries and stored procedures, implemented Transactional Replication, and contributed to data migration tasks using utilities like EXPORT, IMPORT, and ATTACH/DETACH
- Health Care
SQL Database Administrator
Meridian InfoTech (Client: SONY)
03.2011 - 10.2011
- Managed the side-by-side migration of MS SQL Server from version 2000 to 2005/2008, ensuring smooth transitions and documenting the entire process
- Migrated databases from SQL Server 2000 to SQL Server 2005/2008/2008R2, documenting the migration process to ensure accuracy and traceability
- Developed and optimized SSIS packages using Flat File, Bulk Insert, and File System control flow tasks for efficient data loading and transformation
- Generated SSRS reports, including drill-down and static matrix reports, to meet business reporting requirements
- Installed and configured SQL Server 2005/2008/2008R2 Failover Clusters and managed cluster configurations in SAN environments for high availability
- Applied patches and service packs to various versions of SQL Server in clustered and standalone environments, ensuring system stability and security
- Resolved issues with failed logins, user permissions, and security in Active Directory and at the SQL Server level, ensuring proper access control
- Implemented native log shipping for SQL Server 2005 to ensure database high availability and disaster recovery
- Scheduled and monitored regular backup jobs using CommVault, Veritas, Cohesity backup and set up email alerts for database health and backup status
- Utilized tools such as Database Tuning Advisor, Profiler, Activity Monitor, and Solarwinds DPA, Idera Diagnostics Manager, Foglight for performance analysis, identifying and addressing deadlocks and bottlenecks
Education
Master of Science -
Louisiana Tech University
Ruston,LA 12.2008 - 01.2010
Skills
Azure SQL Data Integration Cloud Solutions SQL Queries Database Management Azure Data Factory ETL Processes Data Migration Cosmos DB Cloud Storage Data Warehousing Git Versioning Source Control API Integration Data Analysis Performance Tuning Scalable Architecture Data Pipeline control
undefinedAccomplishments
- Cloud Migration: Successfully led the migration of a SQL Server database to Azure, resulting in decrease in operational costs and enhanced scalability for future growth.
- Security Compliance: Established and enforced database security protocols.
- High Availability Solutions: Designed and implemented SQL Server Always On Availability Groups, achieving continuous availability for mission-critical applications.
- Automation of Maintenance Tasks: Automated database maintenance processes using PowerShell scripts and SQL Server Agent, reducing manual intervention and improving overall system reliability.
- Team Leadership and Mentorship: Mentored a team of junior DBAs, fostering a collaborative environment that improved team efficiency.
- Cost Savings Initiatives: Identified and eliminated redundant database instances and unused resources, achieving reduction in licensing costs without compromising performance.
- Monitoring and Troubleshooting: Implemented proactive monitoring solutions that increased system availability and reduced response times leading to enhanced user experience.
- Performance Improvement: Enhanced database performance through the implementation of advanced indexing strategies and query optimization, significantly boosting application efficiency and user satisfaction.
Certification
DP 300
Timeline
DP 300
12-2024
Senior Database Administrator
ABM Industries
06.2016 - Current
SQL Database Administrator
Incomm
08.2015 - 11.2015
SQL Database Administrator
GSS InfoTech (Client: Wellstar Health Systems)
04.2013 - 08.2015
SQL Database Administrator
Meridian InfoTech (Client: Network Health)
11.2011 - 03.2012
SQL Database Administrator
Meridian InfoTech (Client: Fidelity Investments Financial)
04.2011 - 03.2013
SQL Database Administrator
Meridian InfoTech (Client: SONY)
03.2011 - 10.2011
Master of Science -
Louisiana Tech University
12.2008 - 01.2010
Similar Profiles
Frank PetersonFrank Peterson
Supervisor at Abm Industries Inc or abm building valueSupervisor at Abm Industries Inc or abm building value
Berencia HobbBerencia Hobb
General Labor Warehouse/FloorTech/CorrigateTech/AccessControl at Abm Industries Inc or ABM Building ValueGeneral Labor Warehouse/FloorTech/CorrigateTech/AccessControl at Abm Industries Inc or ABM Building Value
Joshua QuirogaJoshua Quiroga
NETA II Journeyman Electrician at ABM IndustriesNETA II Journeyman Electrician at ABM Industries