Sql Server Database

Louis Achungo

Senior SQL Database Administrator

*********@*****.*** • 678-***-****

• Atlanta, GA

Summary

Highly analytical and innovative individual with extensive experience in MS SQL Server Database Infrastructure Design, Administration, SQL Development and Support of SQL Server, including Database Disaster Recovery, Database Performance Tuning, Database Security and Development. Technically sophisticated professional with in-depth knowledge of technologies, systems and practices, including On-Premise to Azure SQL Cloud & AWS RDS Migrations, DDL, DML, Schema Comparisons, Data Compliance, Indexing, Stored Procedures, Backups, Disaster Recovery, Scaling, Always On, Optimization, Encryption, SQL Job Management, ETL, Reporting, Data Generation and Database Source Control. Possess a deep understanding and knowledge of SQL Database Administration, Configuration, Infrastructure Configuration and Query Tuning. Demonstrated expertise in supporting large scale databases in on-premise and AWS & Azure Cloud environments along with knowledge of SQL Server 2000-2022, Windows Server OS, and security protocols for server and SQL environment hardening.

Technical Proficiencies

Database & Operating Systems:

MS SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019, 2022 ORACLE 10g, 11g, & Sybase 10, 11; Windows Server 2000, 2003, 2008 R, 2012, 2016, 2019, 2022

Applications:

MS SharePoint 2007, 2010, 2014, TFS, Informatica Power Center, V-Sphere, Veeam, Avamar & CommVault, AWS, Azure Cloud.

Languages & Tools:

SSIS, SSAS, VMWare, T-SQL, VB Script, JAVA Script, Microsoft Azure SQL, Idera SQL Monitor, AvePoint, Spotlight, Red Gate, SQL Safe, SQL Compare; SQL Data Compare; SQL Quest Diagnostic Manager, SentryOne ; Logic Monitor; Monitoring System; Jira and Service Now.

Career Experience

Lucid Corporation, Columbus, OHIO 2022 – 2025

Sr. SQL DBA (Azure & AWS Cloud Services & Operations)

Designed and implemented the company’s SQL Architecture & Framework transforming the company from outdated SQL database management methodologies to the latest On-Prem, AWS and Azure SQL Cloud designs and management practices.

Conducted the following for Azure SQL/Azure SQL Managed Instances/SQL on Azure VM, On Prem SQL Server, SSRS and SSIS.

Migrate On-Premise SQL Instances to AWS EC2, AWS Redshift and Azure SQL & SQL Managed instances.

Establish Vulnerability Azure Cloud & AWS Cloud Watch Monitoring

Install/Configure/Setup/Administer and Maintain production and non-production environments On Prem & on Azure Cloud

Plan, Setup and Test Always-On High-Availability and Windows Failover Cluster Disaster Recovery.

Create Users and assign/manage permissions by establishing roles entitlements based on the level of access the user and applications would need; ensure robust and full proof security of assets

Resolve database integrity, performance, blocking, connectivity, and replication issues using dynamic management views and Logic Monitor.

Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues.

Perform and manage Database backup/recovery/restore and capacity monitoring utilizing Red-Gate & Veeam applications.

Setup SQL agent jobs, elastic jobs and runbook automation for SQL installations using ansible.

Identify and setup critical alerts and logging both On-Prem and in Azure Cloud.

Maintain databases – Statistics, Indexes, fragmentation and Query Optimization.

Upgrade and maintain SQL Server and related software (apply patches and updates when necessary, utilizing Shavlik Windows Patching automation)

Coordinate removal and/or archiving of data that is no longer required to be available in the production databases.

Deploy and configure SSIS packages and SSRS Reports. Troubleshoot issues with SSRS and SSIS.

Support release/code deployment activities

Implement operational automation using scripts on PowerShell and Ansible runbooks.

Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database) - In-depth SQL database advanced performance tuning experience – Stored Procedures, Views, Functions; skilled and analyzing and assessing query execution plans and DMVs; expertise in assessing and implementing indexes and partitioning; Tuning ETL Jobs – SSIS.

Design and create databases to support development initiatives and Provide 24x7 support as necessary

Intel Corp, Portland, Oregon 2022 – 2022 (6 months)

Sr. SQL Database Administrator & Azure Cloud

Migrated 529 SQL Instances from SQL 2012 to 2017 & 2019 both on Premise and On Azure Cloud utilizing Azure Data Studio.

Provide assistance in On-Premise – Azure Cloud & AWS EC2 Databases Migrations. Performing SQL Server Clustering & High Availability.

Configured custom automated databases objects synchronization processes between multisite On-Premise & Azure Cloud Databases to enhance High Availability and Disaster Recovery.

Huntington Bank, Columbus, Ohio 2021 – 2022 (6 months)

Sr. SQL Database Administrator & Infrastructure Specialist

Provide accountability for multisite Always-On Availability Groups (AAG) and HA/DR setup and configuration, including performing database migrations. Oversee the deployment, implementation and troubleshooting of data integrity processes and database performance issues, including blocking, deadlocks, connectivity, resource utilization and memory utilization and space management.

Install and configure SQL Server, SSIS and SSRS on Windows as well as manage the roll out of ETL solutions.

Migrate over 205 databases onto cloud based SQL Database servers and resolved RBAC related issues during an acquisition.

CO-OP Bank, Atlanta, GA 2021 – 2022 (6 months)

Sr. SQL Database Administrator & Infrastructure Specialist

Designed and implemented the company’s SQL Architecture & Framework transforming the company from outdated SQL database management methodologies to the latest On-Prem, AWS and Azure SQL Cloud designs and management practices.

Conducted the following for Azure SQL/Azure SQL Managed Instances/SQL on Azure VM, On Prem SQL Server, SSRS and SSIS.

Hiscox LLC, Atlanta, GA 2019 – 2021 (2.5 Years )

Sr. SQL Database Administrator

Provide technical support in monitoring, investigating, analyzing, and resolving database issues in real-time, including implementing SentryOne monitoring and alerting of database servers across the SQL instances estate. Utilize Solarwinds, DynaTrace and SentryOne to create monitoring alarms and notifications for SQL Server Database Applications. Oversee the deployment, implementation and troubleshooting of data integrity processes and database performance issues, including blocking, deadlocks, connectivity, resource utilization and memory utilization and space management. Provide directional leadership in data center move and DR data center implementation. Ensure high levels of reliability, performance, availability, and security by continually configuring and maintaining database servers and processes.

Successfully installed and configured SQL Server, SSIS and SSRS on Windows as well as managed the roll out of an ETL solution between Oracle Oneshield and SQL Server.

Migrated CRM applications from on-premise to Azure Cloud and developed and implemented a robust high availability process to restore the environment on-premise in the case of a disaster in the cloud.

Debugged and tested SSIS Packages and migrated SSRS reports from Share Point to Power BI along with implementing automated BI objects (SSIS Packages, SSRS Reports, SSAS Cubes and SQL Scripts) deployments.

Implemented all lower environments and production environments to establish an ETL solution across SQL Server, Oracle and AS400 data sources for business reporting and trend analysis.

Optimized application and system performance and established a network wide SQL Health monitoring utility by analyzing long running slow queries and hung SQL Jobs.

ExamWorks, Atlanta, GA 2018 – 2019 (6 Months)

Sr. SQL Database Administrator

Determined performance slowness, system process blocking, deadlocks and TCP port Exhaustion by monitoring SQL server performance using SQL Profiler. Made substantial contributions to installation and configuration of SQL Server databases and SSRS reporting services on Windows, including administering monitoring and alerting of database servers using SentryOne and native SQL Server Tools. Orchestrated technical support in the development of monitoring alarms and notifications for SQL Server Database Applications.

Proactively resolved the issues by using DMVs and performance dash boards in the tracking of system and application performance, memory utilization, CPU, I/O, Disk Usage and Logs Usage.

Oversaw design improvements and data normalization by reviewing SQL Server database schema and structure.

Planning and execution of SQL Server Backup and Recovery strategy and execution.

SQL Server production, development and test database administration including index management, DBCC consistency checks, Performance Monitor (perfmon), SentryOne, Logic Monitor, SQL Profiler, Wait Analysis and Index Tuning.

Align Technologies, Silicon Valley, CA 2017 – 2018 (1 Year)

Sr. SQL Database Administrator & Infrastructure

Held bottom line accountability for Always-On Availability Groups (AAG) and HA/DR setup and configuration, including configuring PostgreSQL environments in both public and private domains and managing database migration from On-Premise PostgreSQL Servers to AWS. Oversaw launch of EC2 Cloud Instances using Amazon Web Services on Linux and Configuring Redshift instances concerning specific applications and regions. Participated in performance tuning and query optimization in both on-premise and AWS.

Demonstrated IT skills in installing and configuring SQL Server and PostgreSQL databases on Windows and Linux Centos7 servers.

Utilized AWS Cloud Watch service, Logic Monitor, Log Entries, Idera and New Relic to manage to monitor and alerting of database servers.

Designed and developed monitoring alarms and notifications for EC2 hosts using AWS Cloud Watch service.

Additional Experience

Sr. SQL Database Administrator, Opus Global, LLC, Pittsburgh, PA, 2016 – 2017 (1 Year)

Enterprise Content Solutions Specialist, IBM East Africa, Nairobi, KE, 2015 – 2016 (1 Year)

Senior Enterprise Architect & Lead DBA, Jackson Healthcare Technology Group, Alpharetta, GA, 2014 – 2015 (1 Year)

Lead Database Administrator & Sr. SharePoint Administrator, The Catlin Group, Atlanta, GA, 2007 – 2014 (7 Years)

Lead Database Administrator, Saint Joseph’s Hospital, Atlanta, GA, 2005– 2007 (2 Years)

Senior SQL DBA, Alogent Corporation, Alpharetta, GA, 2003 – 2005 (3 Years)

Oracle DBA, Atlanta Bonded Warehouse Corporation, Kennesaw, GA, 2000– 2003 (3 Years)

Education

Post Graduate Degree in Information Security Science & Enterprise Data Forensics, Boston University, Boston, MA

Masters of Science in Applied Computer Systems, Kennesaw State University, Atlanta, GA

Bachelors of Science in Computer Science, Southern Polytechnic & State University, Atlanta, GA

Associates of Science in Computer Science, Atlanta Metropolitan College, Atlanta, GA

Diploma in Information Management and Information Systems (IMIS), University Group of Colleges, Nairobi, KE

Professional Training

Microsoft Certified Solutions Expert

Microsoft Certified Solutions Associate

Microsoft SQL Server Database Administration (MCITP)

Microsoft Certified Database Administrator (MCDBA)

Sybase 8, 9 & 10 Database Administration

ORACLE DBA & Oracle (OCA/OCP)

Enterprise Databases Information Security (MS SQL Server & ORACLE)

MS SQL Server / ORACLE Database Security & Auditing

IT Security Policies & Procedures

Computer Data Forensics & Investigations

Microsoft Certified Azure Fundamentals (AZ-900)

Microsoft Certified Azure Database Administer (DP-300)

AWS Certified Cloud Practitioner (CLF-C02)

Mastering SQL Server on AWS Redshift Associate

Licenses &Certifications

Microsoft Certified Azure Fundamentals (AZ-900)

Microsoft Certified Azure Database Administer (DP-300)

AWS Certified Cloud Practitioner (CLF-C02)

Mastering SQL Server on AWS Redshift Associate

ORACLE DBA & ORACLE OCA / OCP

MCITP: SQL Server Database Administrator

MCITP: SharePoint Administrator

MCSE / MCSA

LinkedIn Profile URL - https://www.linkedin.com/in/louis-achungo-3865754/

Contact this candidate