Sql Server Database Administrator

JOEL NYAGHU

MS SQL Server Database Administrator

Email: **********@*****.***

Phone: +1-346-***-****

Location: Houston, TX

LinkedIn: www.linkedin.com/in/joel-nyaghu-07a8ba256 PROFESSIONAL SUMMARY:

• Experienced SQL Database Administrator with 7+ years of experience managing Microsoft SQL Server databases for large enterprise applications.

• Strong expertise in database design, performance optimization, and implementing robust backup and recovery strategies.

• Proficiency with database security, high availability solutions, backup and recovery, and performance tuning.

• Demonstrated capacity to guarantee data integrity, improve database efficiency, and minimize downtime.

• Skilled in working with multidisciplinary teams to advance technology innovation and business goals EDUCATION:

Bachelor's Degree in Computer Science 2013

TECHNICAL SKILLS:

• Database platforms: SQL Server, MySQL, SQL Server Management Studio, Oracle SQL Developer, pgAdmin, SQLite

• Cloud databases: Amazon RDS, Azure SQL Database, Google Cloud SQL

• Scripting languages: T-SQL, Python

• Data modelling tools: ERwin, Visio, Lucid chart, Entity-Relationship Diagrams (ERD),

• Database Security: Access Control, Encryption, Auditing

• Performance Optimization: Query Optimization, Indexing, Partitioning

• Programming: SQL, PL/SQL, Python, Shell scripts, Java, C/C++

• Software & Tools: Toad, SQL*Loader, RMAN, Data Guard, SSIS, SSRS, Data Studio

• Operating Systems: Linux (Debian, CentOS, Ubuntu), Windows Server (2016, 2019, 2022)

• SQL Server Administration (2012, 2014, 2016, 2017, 2019)

• High Availability (HA) Solutions

• Database Performance Tuning

• Data Security and Compliance

• Cloud Computing (Azure, AWS)

• Data Analytics and Reporting

• Scripting (T-SQL, PowerShell)

• Data Migration

• Database Administrator MS SQL Server

• Microsoft SQL Server 2005 SQL Server SQL Server 2005 MySQL Replication SQL Backups

• Data Masking Disaster Recovery Clustering ETL Raven

• DB Application Deployment

• Real-Time Active Directory Encryption SolarWinds Virtualization User Access Microsoft SSRS

• SSRS T-SQL Product Lifecycle .NET Visual Studio Client/Server Python Scripting

• Bash PowerShell Optimization VM VMware Hyper-V PAAS Virtual Machine

• Docker Linux Best Practices Metrics Shipping Statistics Analyzer UPS Maintenance

• Problem Resolution Capacity Planning Credit Union Problem-Solving Self-Starter Multitasking

• Project Management Maintain Documentation Logging Auditing Operational Support

• Performance Tuning QA Switch Capacity Mechanical Engineering PROFESSIONAL EXPERIENCE:

Dell Technologies Feb 2022 to Present

MS SQL Database Administrator

• Maintained 99.9% uptime by managing and optimizing more than 50 SQL Server instances.

• Increased query execution speed by 25% with the use of performance tweaking techniques.

• Streamlined recovery times by forty percent by designing and implementing backup and recovery systems.

• Guaranteed database security and compliance, achieving perfect compliance in all security audits.

• Weekly manual labour savings of 10 hours thanks to automated routine maintenance operations.

• A significant system upgrade resulted in the migration of over 10 TB of data with no data loss.

• Improved database indexing technique that results in a 30% decrease in page splits.

• Awarded the Employee of the Quarter title in Q2 2022 in recognition of exceptional achievement.

• Optimized database performance by implementing index strategies and tuning SQL queries.

• Developed and put into practice a thorough database backup and recovery plan that guarantees mission-critical applications will run at 99.99% uptime.

• Worked together with development teams to create and implement a new database schema that could handle a 50% rise in transaction traffic.

• The text outlines the process of implementing data security measures, including creating users and assigning permissions based on database access, using in-built software in SSMS, and utilizing third-party software for monitoring system health and security.

• Also discusses configuration of High Availability and Disaster Recovery solutions, migration of databases, and providing end-to-end support for SQL databases.

• The text also discusses real-time problem resolution, maintenance plans, and troubleshooting of SQL Server service outages, including on-call support during after-hours and weekends. Akamai Technologies Aug 2019 to Jan 2022

MS SQL Database Administrator

• Maintained peak performance by monitoring and managing thirty SQL Server databases.

• Established and maintained SSIS packages for ETL procedures, resulting in a 20% reduction in data load time.

• Proactively detected and fixed such problems by conducting routine database audits and health checks.

• Improve SQL queries and stored procedures in conjunction with development teams.

• By putting in place a high-availability solution, database downtime was cut in half.

• Accomplished a data migration project with 5+ TB of data successfully and without any downtime.

• Achieved a 35% decrease in backup time through the streamlining of backup procedures.

• Orchestrated a vigorous SQL tuning strategy that led to a 40% increase in database performance.

• Reconstructed database systems using Oracle RAC, improving disaster recovery capability by 70%.

• Empowered associates' decision-making process with Business Intelligence tools, boosting team efficiency by 35%.

• used database mirroring, failover cluster instances, and always-on availability groups to design and execute high availability (HA) systems.

• Query optimization, indexing, and statistics management were used to maximize database performance. Oversaw backups, disaster recovery plans, and database security

• Designed and implemented database solutions for new applications in cooperation with development teams Junior database administrators were coached, and recommended practices were taught. Epsilon Jan 2017 to Jul 2019

MS SQL Database Administrator

• Focused on performance and dependability while helping to manage 20 SQL Server instances.

• Monitored and resolved database issues, achieving a 98% resolution rate within SLA.

• Produced and kept up-to-date database configuration and procedure documentation.

• Backed bolstered corporate intelligence and data warehousing initiatives, guaranteeing data availability and accuracy.

• Introduced a new indexing approach that resulted in a 15% improvement in query performance.

• Created automated scripts that eliminated tedious work, saving five hours a week.

• Achieved a 100% recovery rate while playing a major part in a catastrophe recovery exercise.

• Implemented an Oracle Database recovery solution with RMAN, resulting in a 25% speedup for backup and recovery operations. Executed performance tuning on Microsoft SQL Server which increased query response time by 30%.

• Designed a robust database using PL/SQL that streamlined end-user data access, reducing data retrieval time by 20%.

• SQL Server Management Studio and outside tools were used to implement database monitoring and alerting.

• Indexing, query optimization, and database performance tuning. Contributed to the creation of databases for new applications worked along with development teams to resolve database problems PROJECTS:

Lead major Project

Designed and implemented a HA solution using Always On Availability Groups for a mission-critical database, resulting in 99.99% uptime and improved data availability

Developed a database performance tuning framework using T-SQL and PowerShell scripts, resulting in 30% improvement in query performance

Contact this candidate