RAPHAEL AWA OGAR

MS SQL Server Database Administrator

Cell: 412-***-**** Home: ad0lh4@r.postjobfree.com

Job Objective:

A professional database administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end users.

Accomplished and highly qualified IT professional with diverse and extensive database administration experience.

Seeking a DBA position in your organization where I can apply my experience and efficiently contribute to the company’s growth.

My career goal is to be a part of a growing organization and aid in accomplishment of organizational objectives by utilizing my knowledge with what I have learned, and I am still learning. I am equipped with an excellent work ethic, and I have a strong sense of responsibility and teamwork with a track record of dependability.

Education and Training

•National Certificate in Business Administration, with concentration in Database Administration.

•Associate degree in Homeland/Cybersecurity: Community Colleges of Allegheny County

Certifications:

Microsoft Technology Associate

AWS Certified Cloud Practitioner

Residence Status: US CITIZEN

Professional Summary

•Proven Working Experience as a Database Administrator

•Responsible for daily maintenance of large environments comprising of over 200 servers, 400+ Instances and 650+ databases.

•Planned and executed database migration.

•Enhanced database performance and implemented recovery procedures and achieved 99.9% uptime on all SQL Servers.

•Increased efficiency by providing optimum database performance with efficient backup and restore processes.

•Strong Experience with SQL Server 2012 through 2019 administration in standalone and cluster environments.

•Configured and supported replication (Snapshot/Transactional/Merge/Peers to Peers) and log shipping in both SQL 2012 through 2014 Servers.

•Production level support for onsite and offshore - On Call 24/7 environment

•High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping

•Advanced skills in Monitoring Tools

•Query Store, Import/Export Wizard, SSMS, SQL Server Profiler, Extended Events and Tuning Advisor tools

•Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs.

•Configured and Managed High Availability (HA) and Disaster Recovery (DR) Solutions (Log Shipping, Mirroring, Always On, Clustering, and Replication), TDE (Transparent Data Encryption)

•Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

•Experience with Load balancing and T-SQL.

•Experience with VM, Hyper-V, VMWARE

•Experience with partitioned schemas and tables, creating Filegroups using SQL Server.

•Experience in SQL Server Performance Tuning, Query Optimization, Client Connectivity and Database Consistency Checks Using DBCC.

•Experience in Administering SQL Server security by Creating User Logins with appropriate roles, monitoring user accounts, granting privileges to users and groups

•In charge of Server Lease Replacement, Server Decommissioning for the entire

Professional Experience

KiawitectIT LLC

Database Administrator

MS SQL Database Administrator 4/2019 – Present

Responsibilities:

Currents projects:

•Upgrading SQL 2012 to 2016 in our environment

•Setting up Always on, replication and database mirroring

•Database migration

•Windows and SQL patching

•Reviewing and optimizing VMWare environment

•Reviewing and optimizing storage

•Responding to ticket queue (refreshing databases, creating logins and users)

•Performed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, installation, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution.

•Configured High Availability Solution- Always on Cluster, Traditional Failover Clustering, Database Mirroring and Log Shipping.

•Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical databases. Creating and Modifying Tables, Views, Indexes, and Triggers etc. as on SQL Server Environments.

•Responded to and resolved all database access and performance issues.

•Oriented other database administrators on SQL Server management including upgrades and migration.

•Ensured databases adhere to corporate standards and policies, including database auditing.

•Installed SQL Server 2012, 2014, 2016, 2017 and 2019 on advanced servers, applied security fixes.

•SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.

•In charge of Server Lease Replacement, Server Decommissioning for the entire Datacenter.

Friesland De Campino (WAMCO) Industries Lagos, Nigeria April 2017-2019

Database Administrator/IT Helpdesk Support Specialist

Responsibilities:

•Troubleshoot and resolve application issues.

•Manage users in active directory (reset passwords, unlock accounts, disabled/enable accounts)

•Create, close, and escalate tickets, if necessary, to appropriate teams

•Remote desktop assistance

•Troubleshoot computer hardware and peripheral devices.

•Troubleshoot connection issues for remote employees’ login in through the VPN.

•Updating mailboxes in Exchange, adding, and removing users

•Respond to Customers via email or over the phone to resolve application / hardware issues.

• Document all issues appointed to in Jira’s ticket system.

• Escalate tickets to appropriate hierarchy.

• Upgrade/remove computer hardware components and computer software.

• Configure, update, and maintain Company’s Tablet systems as well as inventory check.

• Follow up on end-user’s tickets to assure issue was resolved.

• On-board new employees with laptop, keyboards, mouse, monitors, and other accessories.

Created Databases, Tables, Indexes, Views and Coded Stored Procedures, functions, triggers and Used SQL Profiler and performance monitors to enhance the performance of database servers.

•DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.

•Calculate disk space and table space requirements and Involve in capacity planning, estimating and sizing of tables.

•Migrate data to other databases and import data from Excel spreadsheets and Implementing user training and providing technical support.

•Designed the logical and physical databases and development of SQL Server Database and Database testing, maintaining the data and writing the procedure.

Contact this candidate