Seeking a challenging position to leverage extensive experience and technical skills in contributing to the success of an organization while staying current in the rapidly evolving field of database administration and cloud technologies.
I am a highly skilled Microsoft Certified Solutions Expert and AWS Certified Solutions Architect Professional with a Top-Secret/SCI clearance and over 25 years of experience in the field of database administration, I am an expert in leading DBA teams, system analysis, design, development, and support of various Microsoft SQL Server versions, including Azure, 2022, 2019, 2017, and more. Specialized in managing and optimizing SQL databases, ensuring security, integrity, and implementing effective backup and recovery strategies. Committed to delivering high-quality solutions and exceptional support.
Dutch Ridge– (IT Services), Database Admin (SME), 06/2022, Present, Provide DEA (Aviation) database support Database 24x7x365., Develop methodology for ongoing assessment of database performance and the identification of problem areas., Providing SQL Server DBA support for an existing database in an Azure cloud., Configure Azure database backup policy., Troubleshoot SQL Server service outages as they occur, including after-hours and weekends., Work with development staff to ensure that database deployments, access and security compliance measures are consistently met and align with government guidelines and requirements., Resolving various database issues, including problems with queries, security controls, backup/restore, disaster recovery, and import/export and data ingest efforts., Responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our critical facility system applications., Participating in server and storage capacity management and planning for the most complex and critical systems., Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security., Configure and maintain server STIGs and DoD policies in database systems and applications., Refine and automate regular processes, track issues, and document changes., Supporting installations, upgrades, and patches in accordance with IT policies and procedures., Ensuring data recoverability by supporting system backups and database archive operations, Create functions and stored procedures to provide custom functionality as per the requirements., Maintain and expand document the company’s database environments., Ensure compliance with security measures and government guidelines. Resolve Tech Solutions– (IT Services), Database Admin, 06/2021, 06/2022, Provided DLA, NAVY, and DoD missions critical database support 24x7x365., Developed methodology for ongoing assessment of database performance and the identification of problem areas., Provided SQL Server DBA support for an existing database in an AWS cloud., Troubleshooted SQL Server service outages as they occur, including after-hours and weekends., Resolved various database issues, including problems with queries, security controls, backup/restore, disaster recovery, and import/export and data ingest efforts., Responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our critical facility system applications., Responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health, and performance), executing data loads, and performing data modeling., Configured and maintained database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security., Configured and maintained server STIGs and DoD policies in database systems and applications., Refined and automated regular processes, track issues, and document changes., Supporting installations, upgrades, and patches in accordance with IT policies and procedures., Ensuring data recoverability by supporting system backups and database archive operations Michaels Stores– (Arts and Crafts Retail Chain), Sr.DBA (SQL Tower Lead), 05/2017, 06/2021, Develop methodology for ongoing assessment of database performance and the identification of problem areas., Assist in development of processing database and computing environments both on-premises infrastructure and cloud (Azure & GCP), Migrated existing SQL Server databases from on prem to Azure SQL, Designed and Implemented High availability (HA) and disaster recovery (DR) for MSSQL SERVER such as Replication and Always ON, Configured and installed Microsoft Data Protection Manager (DPM) 2019, Performed SQL server installation and configurations for SQL SERVER 2012,2014, 2016,2017 and 2019 in various Stand-alone/Cluster/VM environments., Performed SQL server installation and configurations in UBUNTU 20.04, Performed MySQL NDB cluster installation and configurations in UBUNTU 20.04, Performed MySQL Innodb installation and configurations in UBUNTU 20.04/18.04, Establish appropriate business metrics to track success for CI/CD capability and share with broader organization to driver further adoption for CI/CD, Troubleshoot SQL Server service outages as they occur, including after-hours and weekends., Provide leadership during the development and enhancement of production applications including working with applications, technical support and operations during the design, development, and implementation of applications., Work closely with middleware application administrators to identify the database resource requirements and to improve operational processes., Work with vendors in evaluating and implementing new technologies., Maintain and expand document the company’s database environments., Lead and mentor a team of offshore DBAs. Omnitracs– (Fleet Management), Consultant-Sr. Database Administrator, 03/2017, 05/2017, Develop methodology for ongoing assessment of database performance and the identification of problem areas., Assist in development of processing database and computing environments both on-premises infrastructure and hybrid cloud (private cloud and public cloud like AWS, Performed SQL server installation and configurations for SQL SERVER 2012,2014 and 2016 in various Stand-alone/Cluster/VM environments., Responsible for Database support, troubleshooting, planning, migration and Resource planning, Work with transaction processing to develop both physical and logical database administration functions. OrthoSynetics– (Healthcare), Sr. Database Administrator, 08/2014, 01/2017, Provided 24x7x365 production database support., Performed ongoing daily support for SQL Server general health, security, troubleshooting the SQL SERVER performance with the help of built-in tools OS performance monitor, Extended events and SQL profiler., Performed SQL server installation and configurations for SQL SERVER 2012,2014 and 2016 in various Stand-alone/Cluster/VM environments., Configured and maintained AZURE SQL SERVER databases., Involved in capacity planning, sizing, and database growth projections., Installed and configure SQL Server failover cluster on multiple nodes., Migrated several large databases from SQL 2008/2008R2 to SQL 2012 and from SQL 2008R2/2012 to SQL 2014 and 2016, Performed installation of SQL Server Service Packs., Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment., Extensively worked on SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS), Designed and Implemented ETL processes using SQL Server SSIS packages and to load data from the source systems into the tables within the data warehouse and operational data., Designed and Implemented High availability (HA) and disaster recovery (DR) for MSSQL SERVER such as Replication and Always ON, Created and managed database backup plans for very large databases, Configured Database mail and linked servers., Developed automated daily, weekly and monthly database maintenance tasks such as database integrity verification, reorganize indexes, re-indexing and update the index statistics., Designed and implemented monitoring and alerts on CPU and memory resource usage, disk capacity, database growth, long running queries, deadlocks, and backup jobs., Interface with database vendors & client technical support teams to isolate & resolve database related problems., Lead a team of two DBAs. Atos– (IT service), Sr. Database Administrator (IV), 05/2014, 08/2014, Provided 24x7x365 production database support., Responsible for Database support, troubleshooting, planning, migration, and Resource planning, Performed SQL server installation and configurations for SQL SERVER 2005,2008,2008R2 and 2012., Installed and configure SQL Server failover cluster on multiple nodes., Configure database Log Shipping, database Mirroring, Replication and Always ON, Create and manage database backup plans for very large databases., Configure Database mail and linked servers., Developed automated daily, weekly, and monthly database maintenance tasks such as database integrity verification and indexing updates., Support and implement all database changes for maintaining SOX compliance., Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate vendor Security Policy based on mutual agreement., Lead a team of 10 DBAs. OrthoSynetics– (Healthcare), Database Administrator, 03/2014, 05/2014, Responsible for Database support, troubleshooting, backups, planning, migration, mirroring and replication, tuning, and re-indexing and updating the index statistics., Provided 24x7x365 production support., Involved in capacity planning, sizing and database growth projections., Complied with standard security-related policies and procedures and followed best practices. Belo Corp (Gannett) – (Broadcasting & Technology), Sr. Database Administrator, 10/2006, 02/2014, Responsible for Database support, troubleshooting, backups, planning, migration, mirroring and replication, tuning, and re-indexing and updating the index statistics., Provided 24x7x365 production support, monitoring, and routine maintenance tasks., Performed from scratch and service pack installations and configurations for SQL Server 2005, 2008, 2008R2 and 2012., Migrated several large databases from SQL 2000 to SQL 2005, from SQL2005 to SQL 2008/2008R2 and from SQL 2005/2008/2008R2 to SQL 2012., Involved in capacity planning, sizing and database growth projections., Extensive work on SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS), Worked with database vendors and 3rd party support teams to isolate & resolve database related problems., Monitored server performance and tuned SQL Server configuration to maximize capacity and output., Installed and configured SQL Server failover cluster on multiple nodes., Worked alongside business application developers – assisting in database design and phasing from development to QA and to Production environment., Complied with standard security-related policies and procedures and followed best practices., Configured Database mail and linked servers., Refresh non-production environments periodically., Lead a team of two DBAs. Bravo Tech. (Contractor to Belo Corp.), Database Administrator/SQL, 11/2005, 10/2006, Provided daily support, troubleshooting, security, monitoring, optimizing and tuning of large SQL Server databases., Performed and documented data migration from production to development and backup/recovery with minimal downtime., Created and maintained database users, roles, and jobs, as well as controlled and monitored user access., Installed service packs/patches and administered SQL Server security. UBS (Contractor to Verizon), Production Support DBA, 10/2003, 08/2005, Provided front-line support for SQL databases and MS Clustering Services on a 24x7x365 basis., Involved in the design and management of SQL Server 2000 database engines, data design, and data transformation., Daily administration, deployment, patching, problem analysis, troubleshooting, monitoring, optimizing, purging, and tuning of large SQL databases., Created and Maintained database users, roles, jobs, DTS packages., Created daily, weekly and monthly maintenance tasks such as backup, verification, and indexing updates., Define database backup & recovery strategies and administer it by using Veritas NetBackup, Worked alongside IT Systems teams in code deployment, testing and verifying data accuracy., Involved in data migration from SQL Server to Teradata and Teradata to SQL Server., Restored databases from Tape (Veritas NetBackup) and BCV (Business Continuous Volume)., Maintained database system and periodic backup/recovery testing and documentation., Provided front-line support for SQL databases and MS Clustering Services on a 24x7x365 basis., Maintain and Tune SQL Server and Teradata Production Systems., Designed Database Hierarchy and Architecture for SQL Server/Teradata Production Systems., Designed, implement and administer secured access rights structures for SQL Server and Teradata Systems., Daily administration, deployment, patching, problem analysis, troubleshooting, monitoring, optimizing, purging, and tuning of large SQL databases and Teradata Systems., Defined database backup/recovery strategies and implemented it by using VERITAS NETBACKUP tool.