Integrated Technology PartnersWorkday / PeopleSoft / Database Administrator
Nov. 2014St. Louis City County, Missouri, United StatesProvided IT Architect / DBA Support for various clients
• Manage SQL Server databases in both Azure and AWS environments.
• Database Management
o Proficient in installing, configuring, and maintaining MS SQL Server versions (SQL Server 2005, 2008R2 2012, 2014, 2016, 2017, 2019, 2022)
o Expertise in managing and optimizing database performance, including indexing, query optimization, and resource monitoring
• Database Administration
o Skilled in backup and recovery procedures, ensuring data integrity and availability.
o Experience in implementing security measures, including role-based access control and encryption.
o Proficient in database migrations and upgrades.
• Performance Tuning
o Proven ability to diagnose and resolve database performance issues
o Implemented best practices for resource utilization, reducing server downtime
• High Availability and Disaster Recovery
o Setup and maintained high availability solutions like AlwaysOn Availability Groups and Failover Clustering.
o Implemented and tested disaster recovery plans to ensure business continuity.
• SQL Scripting and Automation
• Vendor Relations
• Monitor system's health and performance and alerting
o Investigate blocking processes
o Implement specific tunes for long running queries
o Tuned specific index rebuilds for weekly, monthly and quarterly maintenance runs
• Ensure high levels of performance, availability, sustainability and security aligned with compliance guidelines
o Consolidation of SQL users to AD architecture
• Refine and automate regular processes, track issues, and document changes
o Tuned maintenance plans for optimal recovery and minimal system impact
• Assist developers with query tuning and schema refinement
• Upgraded EOL instances to supported version of MS SQL migrating all database instances, users and system objects
• Responsible for designing and implementing the technical upgrades of FIN/HCM systems
• Provide ETL support for platform changes ensuring data integrity.