Sql Server Database Administrator

ROLAND INYIAKOD

ad7oju@r.postjobfree.com 713-***-**** 8721 Town Park Dr Houston, TX 77036

Summary

With 7 years of experience in IT as a MS SQL Server Database Administrator, I have administered and provisioned SQL Server 2008 to 2022 in Production environments, Test, Development and Clustered Environment. I am a Highly motivated self-starter with strong interpersonal and excellent communication skills, outstanding problem solving and active listening skills. Working in my previous and current environments as a very strong part of the team, my experience spans; Installation and Configuration of SQL Server, Upgrade and Service Pack, Performance Tuning, High Availability and Disaster Recovery/Disaster prevention, Database Refreshes, Active directory and other Windows server features and Storage Accounts, Virtual Machines creation and configuration for HADRS including Always on, Log shipping, Replication, Database mirroring and fail over clustering.

Skills

•High Availability (HA) and Disaster Recovery (DR) solutions, Always On Availability Groups, Replication, Database Mirroring and Log Shipping.

•Monitoring tools.

•Strong skills in using excel sheet

•Optimization and Performance Tuning

•Strong in database normalization and handling Indexes.

•Understands Active Directory

•Experience with Windows Server

•Powershell

•Customer service

•Warehouse fulfillment and robotics.

•Strong interpersonal, communication skills and team work.

•Backup and Recovery.

•Microsoft SQL

•Storage and system hardware

•T-SQL Queries

•Database Analysis

•Active Listening and fast in learning new skills.

•Critical Thinking

•Team Management

•Ticketing System-Service Now(SN)

•TSQL using joins, windowing clauses and functions, common Table Expression(CTE).

Experience

MEDLINE INDUSTRIES

Houston, TX

MSSQL Server Database Administrator

10/2019 - Current

•Performing Microsoft SQL Server installation in stand alone and Clustered environments, configuring ISCSI Storage and perform Traditional fail over clustering installation.

•Experience working with Windows Server Technology and Active Directory, managing proper disk configurations.

•Ensuring High Availability and Disaster Recovery(HADR) in the SQL sever environments by the use of updated and highly recommended Microsoft Technologies such as Traditional fail over clustering, Always on availability groups, Log shipping, Database mirroring and replication..

•Optimizing database performance by conducting performance tuning, query optimization, and indexing to improve overall performance and capabilities.

•Ability to identify performance bottlenecks and resolve them, including identifying potential missing indexes, reviewing query plans and applying query plan hints, deep understanding of the SQL Server query optimizer.

•Supports data loads into databases, collaborating with stakeholders to identify, analyze, and provide technical recommendations for reporting and analytic capabilities, data retrieval logistics, and database optimization efforts.

•Experience designing stored procedures, SQL queries and to improve overall database performance. Working knowledge of DDL, DML, triggers, views, constraints.

•Six years of experience managing backups restores of databases, having a great understanding of both full. differential and transactional log backups and which database recovery model support which type of backup.

•Creating logins and user, grant permissions according to the principles of least privilege. Checking health of SQL Server and session details, checking error logs for any issues so as to get it fixed in a timely fashion.

•Creating SQL Server jobs, monitoring the jobs to make sure the run smoothly. Troubleshooting all job related issues.

• Implements database maintenance best practices including index rebuilds and reorganization carrying on database consistency checks;

•Analyze and document the current SQL Server environment, which includes the servers, instances, databases and their disk allocations and system allocations such as CPU and memory.

•Applying Security Patching in both windows and SQL Server. ability to perform administration tasks for SQL Server databases such as ensuring auditing is enabled, ensuring user accesses are monitored, and ensuring that the database security best practices are adhered to.

•Working with indexes on very large databases of more than 4 terabyte to do away with index fragmentation by reorganizing and rebuilding indexes depending on the fragmentation level. Experience Setting up or creating Azure SQL Managed Instance, migrating databases on prem to Azure SQL Managed Instance.

•Handling performance monitoring with the use of both SQL Server inbuilt tools such as activity monitor, SQL server profiler, using also third party tools such as Solar winds and IDERA. Have also used stored procedures like sp_who is active, sp_who2 and sp-who to monitor performance and trouble shoot database issues, assisting with data analysis and reporting tasks when required.

•Managing Security of data with the use of Transparent Data Encryption(TDE), Dynamic Data Masking(DDM), and Transparent Data Encryption(TDE)

•Experience in performance tuning, query optimization, and query window execution plan.

•Attaining general DBA meeting and get assigned with tickets to be resolved.

•Conduct routine quality checks to identify and correct errors in a timely fashion.

•Experience using Redgate SQL Change Automation, SQL Change manager generating script for Database changes when need arises.

•Sound knowledge using Git Bash to committing and pushing change scripts to remote repositories, running Azure Devops pipe line and creating Pull Requests(PR). Has carried on several projects recently including upgrading from SQL Server 2017 and 2019 to SQL Server 2022, using powershell and Microsoft migration assistant tools to migrate over databases, jobs, stored procedures, functions, linked servers etc to SQL Server 2022 in side by side upgrade.

AMAZON Houston TX

MSSQL Server Database Administrator

01/2017 - 09/2019

•Planning the Installation of Microsoft SQL Server 2008, 2008R2, 2012, 2014, 2016, 2019, building, designing, Configuration, Upgrade, Migration and application of Windows and SQL Patching during scheduled database downtimes after hours to ensure databases are up to date in Virtualized environments.

•Making sure Backup and Recovery strategies and Capacity planning follows the company's Recovery Point Objective (RPO) and Recovery Time Objective (RTO) and the Retention policy.

clients sensitive data.

•Leveraging the uses of i n-built software in SSMS such as SQL Server profiler, Performance monitor, Extended Events, DMVs, Database Integrity checks to ensure database integrity, stability, and system availability and other Third-party software like IDERA and SolarWinds Database Performance Analyzer to monitor system health and security.

•Configured High Availability (HA) and Disaster Recovery (DR) Solutions on productions systems using Always On, Traditional Failover Clustering (Windows Server Failover Cluster - WSFC), Database Mirroring.

•Managing and providing end to end support and problem resolution for SQL Server databases through multiple product lifecycle environments, such as development, testing to mission-critical production systems.

•Independently analyze, solve, and correct issues related to database integrity, performance, deadlocking, connectivity, and security in real time, providing problem resolution end-to-end.

•Analyze, solve, and correct issues in real time and provide end-to-end problem resolution such as hardware and software purchases, server configuration changes and assisting developers with query/index tuning.

•Creating and monitoring maintenance plans and agent jobs that take backups and defrayment indexes for query performance.

•Hands-on database tuning and troubleshooting of SQL Server service outages as they occur, including providing On call support during after-hours and weekends. Providing scheduled maintenance, supporting application deployment, and hardware/software upgrades after hours and 24 x 7 support.

•Review scripts submitted by the development team and working with other teams like systems analysts, developers, business analysts, and project teams to perform the capacity planning required to create and maintain the Databases.

Control and establish appropriate database user access control levels by provisioning users based upon company policy to control access for each segment of the Databases. Develops database security guidelines and performs audits.

•Work with developers and application teams to plan and design database structures both logical and physical.

Education and Training

BAMENDAUNIVERSITY OF SCIENCE AND TECHNOLOGY(BUST)

Bachelors of Science Degree in Marketing

07/2015

Contact this candidate