Database Administrator Server

GREGORY O. ONYISHI

email: ********@*****.*** Tel: 615-***-**** Lavergne, TN-USA

SQL SERVER DATABSE ADMINISTRATOR

DATABASE ADMINISTRATION• PROACTIVE MAINTENANCE • DATABASE SECURITY • HA/DR

HEALTHCARE TECHNOLOGY • APPLICATION CUSTOMIZATION & IMPLEMENTATION

Goal-driven Information Technology professional with a 6+ year history immersed in computing skills, database administration and offers a proven ability to help shape organizational performance and responsiveness to business needs, by ensuring databases are highly available and accessible by authorized users.

CORE SKILLS

Database Backup & Recovering High Availability Solutions-Disaster Recovery Database Migration- Clustering, Always On, Log shipping Microsoft Database Security Performance Maintenance Managing RDBMS SQL Statement Tuning

SUMMARY OF SKILLS

Experience in SQL 2014/2016/2017/2019 database management and related products from Microsoft including PowerShell, Windows 2008R2/2012R2/2016/2019 Servers and desktop operating systems.

Experience in Installation, Configuration, Upgrades, Maintenance and Administration of SQL Server 2012/2014/2016/2017/2019

Experience in implementing backup and restore, ensuring proper recovery and recovery models.

Setting up and administering SQL Server Database Security environments using Profiles, database Privileges and Roles.

Experience in Performance monitoring using Activity Monitor, SQL Profiler, SQL Trace, Extended Event, and System stored procedures, DETA (Database Engine Tuning Advisor).

Experience in High Availability Solutions: Log Shipping, Database Mirroring, Failover Cluster Instance, Always On Availability Group and Replication.

Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.

Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.

Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.

Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.

Deployed PaaS, IaaS Services- Azure SQL database, SQL Instance in Azure VM, Azure SQL Managed Instance

Hands on experience in virtual machines, virtual network, Azure storage, Azure active directories, Azure Subscriptions, Azure polices, Azure DNS, Azure Load Balancer and Autoscaling

Experience on Azure virtual network, network security groups (Vnet, Vnet Peering, Route table, Vnet to Vnet connection)

RECENT PROJECTS

Setting HA and DR solutions (Always On Availability Group, transactional replication and database log shipping)

SQL 2012 upgrades, applications migration

Applying windows and SQL server patches on production/nonproduction servers

Configured database backups and restoration, monitored and tuned database

Deployed SQL Server in Azure VM, Azure SQL Managed Instance, Azure SQL Database for scale and performance

Windows and SQL patching, database migration

Refreshing databases, creating logins and users

EDUCATION

WEST AFRICAN SENIOR SCHOOL CERTIFICATE (High School Diploma) ….1998

CAREER HISTORY

Middle Tennessee Mental Health Institute, Nashville, TN (April 2021 till Date) SQL Server Database Administrator

Create and manage SQL Server databases and database objects

Install, upgrade, update, configure, and maintain SQL database servers-from SQL Server 2012 to SQL Server 2019

Monitor the health and performance of databases on SQL Server

Ensure high performance, availability, recoverability, and security of the databases

Analyze, troubleshoot, and correct performance issues on SQL Server

Automate regular processes, track issues, and document changes

Assist development team with query tuning and schema refinement

Perform routine maintenance

Support release deployment activities, server, and application updates, during change management windows.

Configured High Availability Solutions – Always On availability group with 3 replicas, and transactional replication.

Maintenance of the database systems including but not limited to ensuring successful backups, resolving systems issues, monitoring success and failure of automated jobs, monitoring system availability, updating system documentation, system, and database recovery

Responds to and resolves database access and performance issues

Unipres Corporation,Smyrna, TN. (October 2020 to April 2021)

SQL Server Database Administrator

Supported existing enterprise level applications and MS SQL Server 2012/2014/2016/2019 to the business needs.

Installed, configured and Administered Databases in Test, Development and Production environments using MS SQL 2012/2014/2016/2019.

Performed troubleshooting investigations via backend methods by capturing SQL log files, updating database fields, and updating/cycling servers. Tuning database performance using Profiler, DMVs, index analysis and Tuning Advisors.

Reviewed the overall physical database structures for data integrity, quality, recoverability, maintenance, and space requirements

Applied service packs and security patches for on SQL servers on demand.

Diagnosed and troubleshot performance and slow query running issues using performance monitoring and optimization tools, Client Connectivity and Database Consistency Checks Using DBCC.

Ensured business continuity with appropriate backup and recovery processes, failover procedures, and tested to guarantee point-in-time recovery for avoiding all types of data loss, including major catastrophic disaster.

Analyzed database growths for capacity planning, normalized the data for efficient performance and partitioned data into multiple files and file groups.

Assisted and provided 24/7 production support in finding ways to improve performance without missing deadlines.

Express Employment Professionals, Murfreesboro, TN (March to October 2020)

SQL Server Database Administrator

Developed storing procedures, tables, views, indexes, and scripts for processing data.

Diagnosed & troubleshot performance and query issues using performance monitoring and optimization tools.

Recovered databases from full, differential, and transaction log backups on Production and Preproduction environments.

Performance tuning, including database/query tuning and re-writing SQLs to enhance performance.

Monitored server event logs, performance logs, growth of data on the network, and checked the nightly server's status.

Implement automation of database operations like upgrades and patching.

Mitsubishi Heavy Industries (MHI), Doha City, State of Qatar. (July 2017 to October 2019)

Jr SQL Server Database Administrator

Responded to and resolved database logon and access related issues.

Diagnosed and troubleshot performance and slow running queries using performance monitoring and

optimization tools

Monitored the growth of tempDB and user databases for capacity planning

Created logins, users, and assigned minimum required permissions to users

Implemented automation of database operations – backups, index rebuild and re-organize

Tested backups periodically by restoring in non-production environment

TECHNICAL KNOWLEDGE

Databases: Microsoft SQL Server 2012/2014/2016/2019, Azure SQL Database, PostgreSQL in Azure

SQL Server Tools: SSMS, SQL Profiler, SQL Query Analyzer, Database Engine Tuning Advisor (Eta)

Operating Systems: Windows, Windows server 2019/2016/2012R2/2008, Linux, Virtual Machines

Hardware: Pc Upgrades/Repairs, Connectivity Troubleshooting, Component Replacements

Languages: SQL, PowerShell, Azure CLI

Cloud Platform: Microsoft Azure, Azure storage, Vnets, Load Balancers, Express Route, DNS, VPN Gateway, Active Directory

Protocols: HTTPS, DNS, DHCP, RDP, FTP, TCP/IP, SSL, TLS

References

Available Upon Request

Contact this candidate