| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate 8082 Barrosa Circle Melbourne, FL Street Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLECandidate's Name
Senior SQL Server Database Administrator_____________________________________________________________________________OBJECTIVE To provide exceptional database administration. I have over fourteen years of hands-on experience in the installation, configuration, and management of large available and scalable database systems. I have administered SQL Server versions from SQL 2008 through SQL 2022, and Azure SQL Databases. I employ my expertise and experience to ensure a strong end user supported platform and the highest production performance levels._____________________________________________________________________________SIGNIFICANT ACCOMPLISHMENTS:
Migrated 60 SQL Server databases from Enterprise Edition to Standard Edition, accomplishing a reduction in cost of over $500,000.
Implemented AOAG Read Only secondary to support reporting for the Finance, Warehouse divisions, resulting in significant performance gains in production.
Implemented TDE and RLS on 12 production and test SQL 2019/2022 databases ensuring high level of data safety and security._____________________________________________________________________________SKILLSSQL Server Database Administrator - 13 yearsAzure SQL Server Administrator - 4 yearsSQL Server Performance Tuning Specialist - 10 yearsSQL Server Disaster Recover Specialist - 13 yearsSQL Server Architecture Design - 11 yearsSQL Server Migration / Upgrade Specialist - 10 yearsSQL Server Replication Specialist - 12 yearsSQL Server Log Shipping Specialist - 12 yearsSQL Server Always On Availability Group Specialist - 7 yearsSQL Server TSQL programming 7 - yearsWSFC Specialist 5 - years_____________________________________________________________________________EXPERIENCESenior SQL Server 2022 Database Administrator, Athena Health, Jan 2019 Aug 2024 RemoteFormulated the maintenance, availability, and performance of 100% of the DIQ production databases, the DIQ reporting environment, and the DIQ production data warehouse. I am solely responsible for saving hundreds of thousands of dollars in monthly licensing fees, by migrating from SQL Server Enterprise to SQL Server Standard Edition for over 60 SQL 2019 instances.Developed instance configuration checklist to ensure all new Azure managed instances were created using the correct configurations for performance. Spear headed the SQL Server weekly production performance review meeting to monitor all the Azure databases for performance issues and develop resolutions to issues found.Set up and managed the disaster recovery scenario to ensure 100% of production databases were backed up and restore tested. Implemented high availability solutions using SQL 2019/22 Availability Groups allowing for the offloading of reporting to secondaries.
Designed the SQL Database migration plan for 18 SQL Server production databases and their associated sub applications to Azure/AWS. Implemented weekly meetings to ensure that stakeholders were briefed on the status of all migrations.Established performance monitoring plan to ensure smooth transition to Azure/AWS. Developed and implemented AZURE Log Analytics to ensure high levels of performanceSenior SQL Server Database Administrator, Insight Global (DXC), Nov 2018 - Dec 2019 RemotePerformed a 100% inventory of existing database servers and initiated a performance review to identify any bottlenecks.Reviewed all instances for accounts with sa rights and provided the information to management for removal of unnecessary privileges.Reviewed the backup plans on all servers to ensure the RPO and RTO was being met.Assisted in after hours code release and upgrade testing.Senior SQL Server Database Administrator, Icanotes May 2016 - Oct 2018 RemoteProvided ongoing support to the Icanotes application and responded to client request for access to the system.Developed and deployed a comprehensive backup plan for all SQL Servers.Assisted developers with code reviews and best coding practices.Assisted with the yearly Icanotes application upgrade and testing.Senior SQL Server Database Administrator, CDI, Aug 2014 - Apr 2016 RemoteAssisted with team lead responsibilities when the lead was absent, provided mentorship and guidance to junior team members.Customized SQL Server installation configuration files for the automated installation and configuration of over 33 SQL Server 2016 Enterprise and Standard Edition instances.Produced 75% across-the-board improvement in performance by implementing SQL Server Extended Events in production environments.Developed/deployed 32 SQL Server Transactional Replication articles for internal reporting requirements to standby secondary servers.Assisted and trained team members in the use of PowerShell scripting to automate common maintenance tasks.SQL Server 2014 Database Administrator, CoCentrix, Jan 2014 - Aug 2014Provided direct maintenance, performance, and architectural support to the CoCentrix SQL Server environment which consisted of 160 databases.Established SQL 2012 Replication for nine databases on five servers which included HR, Finance and Engineering, to support reporting and data analysis.Participated in the quarterly disaster recovery meetings to ensure 100% of recovery plans were kept up to date and tested.Developed and deployed automated tasks in SQL Server by using PowerShell scripts for backups, error log searches and performance metrics gathering.Senior SQL Server 2014 Database Administrator, CDI, Remote Apr 2011 - Jan 2014 RemoteEliminated 85% of performance issues by implementing a performance gathering methodology which included SQL Traces, and DMV centered performance queries.Spearheaded the creation of AlwaysOn High availability group solutions for 65% of the production SQL Server databases.Developed best security practices for SQL Server for all 4 environments.Assisted and developed automation task for SQL Server using PowerShell scripts for backups and error log searches.
Senior SQL Server 2008 Database Administrator, Petro Algae, Jan 2011 - Apr 2011 Melbourne, FLProvided emergency assistance in support of Petro Algae' production SQL Server environment, which consisted of 34 SQL Servers.Established enterprise level backup and recovery procedures to guarantee 24X7 recovery ability for all production and critical development databases.Implemented and maintained SQL 2008 SSRS for all business departments and senior management, created ad-hoc reports for senior managers.Senior SQL Server 2008 Database Administrator, Harris Corporation, Apr 2010 - Jan 2011 Palm Bay, FLDesigned and deployed production performance data warehouse used to monitor all production instances of SQL 2000/2005/2008.Implemented a centralized maintenance server to consolidate 385 SQL jobs. This resulted in a 24% reduction in job errors and a reduction in the job error resolution period.Developed the standards for implementation and configuration of SQL 2008 installations and databases.Analyzed 44 SSIS packages for consolidation of data loads into 26 packages.Senior SQL Server 2008 Database Administrator, Access MediQuip, Oct 2009 - Mar 2010 Orlando, FLDeveloped a comprehensive plan to monitor 100% of the production servers for performance issues.Generated a migration plan that relocated 92 databases from 14 physical servers to 4 Microsoft Windows 2008 R2 virtual servers which enabled the redistribution of 6 physical servers.Completed the deployment of log shipping for 12 databases, providing the enterprise with two warm stand-by servers of 12 production databases.Upgraded 643 SQL jobs by implementing a centralized maintenance server, which reduced job errors by 51%.EDUCATION:Master of Science, Computer Information Systems, Florida Institute of TechnologyJan 2005 - Aug 2008 Melbourne, FL |
