Database Administrator Associate

ISAAC MADUKA

SQL Server Database Administrator

Conroe TX *****.***-***-****.********@*****.***.********/in/isaacmaduka84b Objectives

Over 7 years of hands-on experience as SQL Database Administrator providing 24/7 Production and Development Support Extensive knowledge and proficiency in Database Design, Installation, Configuration, Monitoring & Tuning, Replication, Migration, Backup & Recovery, Security Administration, High Availability Solution, Always On, Log Shipping. Expert in Power Business Intelligence in designing analytical reports based on company data, translating data into knowledge, as well as developing BI and analytical solutions. Exceptional Communication, Analytical and Organizational skills. An accomplished and highly qualified IT professional with diverse and extensive database administration experience. An energetic achiever capable of managing successfully, multiple priorities as well as perform and deliver under pressure. Area of Expertise

•Comprehensive knowledge of SQL Server and PostgreSQL installation, migration both on-premise and from on premise to Azure, patching, troubleshooting, optimization, maintenance (modeling, High-Availability (HA) and Disaster Recovery (DR)).

• Skilled in building complex environments using functions such as Always On, Windows Failover Clustering, Log Shipping. Replication

• Competent in monitoring and performance tuning.

•T-SQL. Proficient in writing complex SQL queries. Creating new, modifying, and debugging existing stored procedures, functions, and triggers

• Excellent attention to detail, customer service and people skill, and ability to learn and adapt to change.

• SQL Server Integration Services (SSIS) Expert in developing and deploy new SSIS packages, migrating and debugging existing SSIS packages.

•SQL Server Reporting Services (SSRS). Proficient in creating and deploying new SSRS reports, migrating existing SSRS reports. Also, debugging SSRS reports for run time issues and performance.

• Ability to work independently taking care of ownership of technical skills. Technical Proficiency

Platforms: Windows, Linux, Microsoft SQL Server (2008 – 2019), PostgreSQL, Microsoft Azure, MS SSIS, SSAS, SSRS, Tableau.

Tools & Functions: PowerShell, Azure CLI, Idera, Redgate, ServiceNow, Jira, Data Migration Assistant, Activity Monitor, SQL Profiler, SSMS, Configuration Manager, Transparent Data Encryption (TDE), Dynamic Data Masking (DDM), Always Encrypted, High Availability, Database Mirroring, Log Shipping, Traditional Failover Clustering, Always On, Hyper-V, VMs, T-SQL, Azure SQL Databases, Azure storage Services, Azure scalability, Azure Data tool, Replication, Geo replication, Resource groups, and Wiki PROFESSIONAL EXPERIENCE

World Financial Group Houston February 2018 - Present MS SQL Server Database Administrator

ISAAC MADUKA

SQL Server Database Administrator

Conroe TX *****.***-***-****.*************@*****.***.******** isaacmaduka84b 2

Oversee all facets of daily MS SQL database function, including design and installation, configuration and tuning, software and hardware upgrades, security, user provisioning, systems troubleshooting, and backup and recovery management. Researched, built, installed, and properly documented modern technologies and best practices to help agency achieve and maintain regulatory compliance. Key Achievements

• Increased overall agency and departmental efficiency rate by 25% by providing adequate and optimum database performance with efficient backup and restore process/ policies

• Designed and developed SSIS packages for implementing the ETL process with proper error handling and optimization

• Maintained performance tuning and monitoring through automated jobs, scripts optimization and execution plans. Also created index maintenance jobs that ensured that indexes are reorganized, rebuilt and statistics updated.

• Developed 50 + reports by utilizing knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)

• Collaborated with business users, collected requests, and updated the set of existing BI reports to accommodate business needs.

• Generated and delivered quality reports to customers by conducting quality assurance and recorded 65% increase in customer satisfaction

• Minimized downtime by optimizing and monitoring high availability for SQL Server, including Database Mirroring, Log Shipping, Traditional Failover Clustering, and Always on Availability Group.

• Mitigated security and software concerns by thoughtfully managing and pushing patches and other updates to production and non-production servers.

• Automated jobs, configured alerts and ensured 24/7 Database and project support.

• Aided in establishing and monitoring always-on availability groups and alerts. Liaised with developers and application teams to deliver reports

• Configured database migration from on-premises to Azure using data migration assistance, replication, export/Import data- tier application, deploy database to Microsoft Azure database.

• Setup backup retention policy in Azure and Setup Always on availability solution on Azure VMs.

• Determined different service tier as well as DTU`s for Azure SQL Databases, Managed Instances, and Database Elastic pools.

• Created Azure Domain controller, added Azure VM`s to active directory, installed SQL server on VMs. Texas Dept of Criminal Justice Huntsville Texas March 2016 – January 2018 SQL SERVER DATABASE ADMINISTRATOR

Directed various day-to-day operations such as SQL server daily checks, installation, configuration, upgrades, and structure modifications. Oversaw always-on, traditional failover cluster, database mirroring, and log shipping with utmost accuracy. Mitigated downtime, fixed overall database access and performance issue, and uncovered abnormalities while patching and upgrading database Servers and Windows Server. ISAAC MADUKA

SQL Server Database Administrator

Conroe TX *****.***-***-****.*************@*****.***.******** isaacmaduka84b 3

Key Achievements:

• Generated prompt response to tickets, resolved user request based-off priority, and ensured database configuration maintenance in the configuration repository.

• Worked with the Active directory creating users and managing permissions to databases following principles of least privilege.

• Directed and automated all DBA tasks via incorporating SQL and 3rd party tools. Regulated SQL and Windows Service packs and security patches.

• Performed replication and log shipping on SQL 2008 and 2012. Completed side-by-side and in-place server upgrades.

• Coordinated with customer and 3rd party vendors to manage and support the database system and operations.

• Oversaw multiple database administration operations including conducting server health check, supporting security operations, installation, and configurations in adherence to expected targets.

• Deployed SQL server level backups while building and testing backup/recovery plans.

• Leveraged expertise regarding extended events and SQL profiler while supervising SQL server performance. Education And Training

University of Benin Nigeria

Bachelors in Computer Science May 2001

Certifications:

Azure Database Administrator Associate (DP 300) - Pursuing Microsoft Certified Professional in Implementing Databases with MSSQL Server August 2008

Contact this candidate