Sql Server Database Administrator
Resume:
Chris Onuwa
SQL Database Administrator
Email: *****.************@*****.***
Richmond, TX 77407
SUMMARY
8+ years hands on experience in MS SQL Server, SQL Server 2019, 2017, 2016, 2014, 2012, 2008.
a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012 Always On availability groups maximizes the availability of a set of user databases for an enterprise.
Experience on Installation, Administration, Monitoring, Query Optimization, Always-On, Replications and Security of database Servers, TDE Encryption etc.
Expert in Microsoft’s Structured Query Language. We utilize software designed to track and store large amounts of personal and financial data and organize and analyze that using the SQL platform.
Experience on Migration, moving data to or from a database. Switch from one instance of SQL to another. Migration from On-premises to Azure cloud to save costs and money for the company. Experience on always on, High Availability and Disaster Recovery solution. Basically, extends a failover environment for availability Databases that fail together.
Experience on Database Security, objective of trying to secure sensitive data and maintain the confidentiality, availability, and integrity of the database.
Experience on managing multiple databases and installation of databases, configuration, migration, stored procedure, troubleshooting, and maintaining efficient and effective functioning of the database and SQL database services.
Excellent work ethic; possesses a keen sense of responsibility and teamwork with a record of accomplishment and dependability. Strong knowledge in writing TSQL, stored procedures, functions and triggers. An effective team member, including work as a Senior Microsoft SQL Server DBA, database design, and system administration.
Key strengths include problem-solving skills, attention to detail, multitasking, and the ability to build effective business relationships, even during times of high.
SKILLS
SQL Server,2019, 2017, 2016, 2014, 2012, 2008
Database Administration
SQL/TSQL Programming
Database Monitoring
Installation/Configuration
Indexing/Optimizing
Database Security
Transparent Data Encryption
Always On Availability Group
Database Replication
Database Mirroring
Database Auditing
Disaster Recovery
Backup/Restore
Data Manipulation
Spreadsheet updating
Experience on SSIS: - (ETL Tool)
XML, SSAS, and SSRS
Account reconciliation
Researching and rectifying variances
Data analysis, research and management
Equipped IGT Advantage CMS and other Casino systems
Documentation and recordkeeping
MS Excel, Word, Outlook, Power Point
Excel Data Validation
Customer- and service-oriented
Excellent communication skills
Team player mentality
Quick Learner
POS system operation
Excel VLOOKUP
PivotTable
·
WORK EXPERIENCE
SQL Database Administrator
(April 2021 – Present) Aldi, Houston TX
Programmed ETL/Data Pipelines and the Creation of Data Marts.
Install and Configure SQL Server and experience in Cloud environment like Azure and AWS.
Migrated about 20+ On-Prem SQL Server databases to Azure using tools like Azure Data Studio.
Support and administer SQL Server 2008R2 2012, 2014, 2016, 2017, 2019
Support and administer SQL Server Database mirroring, Always-On, Replication, SSRS, and SSIS.
Work on SQL Server Performance Tuning to improve query and application performance.
Used SQL Server Profiler and Extended Events to help trace and troubleshoot long running queries and other issues.
Planned and modified SQL server Permissions in quarterly basis.
Designed, assessed, and deployed, database changes, stored procedures, SSIS packages, and other data migration processes.
Monitored system's health and performance and ensured elevated levels of performance, availability, sustainability, and security.
Refined and automated regular processes, tracked issues, and documented changes.
Provide database support, responded to user questions, and resolved problems.
Organized data and implemented analytic data marts and business intelligence views for performance monitoring, measurement, evaluation vs. forecasts, and financial measures.
Recommended and designed ongoing improvements to process to improve program performance measurement.
Installed new software or upgrade existing software for various tools or systems utilized by marketing.
Setup Alerts, Notifications, Jobs, Job steps with automated response solution schedules.
Worked extensively in clustered environment (Active / Passive) to further increase scalability and availability
(August 2017 – March 2021) Walgreens, Houston TX
TSQL Programming: Maintain and fine tune SQL/ Stored Proc/UDF/Views/Triggers.
HA/DR Implementation: Configure and Maintain Always on Availability Group, SQL Server Replication and Log Shipping.
Performance Monitoring/Tuning: Index fine tuning, Analysis Disk, CPU & Memory bottle neck using Query Store, SCOM, SQL Profiler, Extended Events, DMV/DMF, SolarWinds DPA and Spotlight.
Implementation of Permission, Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Patching and Code Release.
Handled 20 TB+ Databases
Participation in DevOps and adherence to Change/Problem/Incident/Event Management processes and procedures.
Work closely with offshore development team.
(August 2015 – February 2017) Home Depot, Houston TX
TSQL Programming: Maintain and fine tune SQL/ Stored Proc/UDF/Views/Triggers.
HA/DR Implementation: Configure and Maintain Always on Availability Group, SQL Server Replication and Log Shipping.
Performance Monitoring/Tuning: Index fine tuning, Analysis Disk, CPU & Memory bottle neck using Query Store, SCOM, SQL Profiler, Extended Events, DMV/DMF, SolarWinds DPA and Spotlight.
Implementation of Permission, Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Patching and Code Release.
Handled 20 TB+ Databases.
Participation in DevOps and adherence to Change/Problem/Incident/Event Management processes and procedures.
Work closely with offshore development team.
EDUCATION/LICENSES/CERTIFICATIONS
Bachelor’s Degree University of Phoenix 2012 – 2016
HealthCare Administration
Contact this candidate