VICTOR OGRA

Lanham, MD ***** E-mail: ad3ann@r.postjobfree.com Tel: +1-240-***-****

DATABASE ADMINISTRATOR

Professional Summary:

• A Database professional with over 7 years of experience in Database managing mission- critical databases on Prem and in the cloud (Azure).

• I have Experience and knowledge of Performance Tuning, Maintenance, High Availability, and Disaster Recovery (HADR) strategies.

• Hands-on experience in setting up and troubleshooting AlwaysON, Clustering, Log Shipping, Database Mirroring, and Replication Models (Snapshot, Transactional/Merge).

• Experienced in Database Backup, Restore/Recovery, Query Optimization, Security, SQL Server Installation, and Configuration of Stand-alone and Clustered Environments.

• Configuration of Transparent Database Encryption (TDE) for Database security purposes.

• Experience in Migration/Upgrade by applying the current Service parks and or cumulative Units (Depending on the SQL Server versions).

• Routing DBA operations

• Database Health check index optimization, updating statistics, client/Server connectivity, and capacity planning.

• Responsible for securing SQL Server, User Management, Creating Logins, Assigning Roles, and granting Permissions. Experience in using Query Store, Extended Events, Database Engine Tuning Advisor (DTA), SQL Profiler, Scripts, and Other Third-Party Tools to resolve bottlenecks, deadlocks, and slow-running queries. Work History:

SQL SERVER DATABASE ADMINISTRATOR

Piprox Technology Inc.

Bowie, MD December 2020 to date.

• Managed over 900 SQL Server Databases across multiple Data centers.

• Involved in Technical decisions for Business development, Interactions with Business analysis, Client team, Development team, Capacity Planning, and upgrading of SQL Servers.

• Responsible for setting up and maintaining High Availability and Disaster Recovery solutions and database Migration from SQL Server 2008R to 2014/2016.

• Perform Schedule Backup and Restore operations.

• Maintained Server Security by creating logins and granting Permissions. Assigning Server and Database Roles.

• SQL Server Agent monitoring and troubleshooting jobs, and events notifications using Database Mail.

• Used Optimization Tools such as SQL Profiler, Dynamic Management Views (DMVs), and Windows Performance Monitor to monitor and Tuning SQL Server for optimum performance.

• Migrated SQL Server from Prem to Azure SQL Server Database.

• Work hand-in-hand with Application Development Teams for Application deployment and monitoring.

SQL SERVER DATABASE ADMINISTRATOR

SALut Inc. MD. January 2019 to Nov 2020

• Managed over 800 Databases and VLDB across multiple Data Centers.

• Involved in Technical decisions for Business development, Interactions with Business analysis, Client team, Development team, Capacity Planning, and upgrading of SQL Servers.

• Responsible for setting up and maintaining High Availability and Disaster Recovery solutions and database Migration from SQL Server 20014 to 2016.

• Perform Schedule Backup and Restore operations.

• Maintained Server Security by assigning logins, Server and Database Roles, and permissions.

• SQL Server Agent monitoring and troubleshooting jobs, and events notifications using Database Mail.

• Used Optimization Tools such as SQL Profiler, Dynamic Management Views (DMVs), and Windows Performance Monitor to monitor and Tuning SQL Server for optimum performance.

• Migrated SQL Server from Prem to Azure SQL Server Database.

• Maintaining two different Databases: Read-only reporting Database and Disaster Recovery Database. Recovery.

• Work hand-in-hand with Application Development Teams for Application deployment and monitoring.

Hillis-Carnes Engineering Associates March 2018-December 2018 Washington DC

• Managed over 800 Databases and VLDB across multiple Data Centers.

• Involved in Technical decisions for Business development, Interactions with Business analysis, Client team, Development team, Capacity Planning, and upgrading of SQL Servers.

• Responsible for setting up and maintaining High Availability and Disaster Recovery solutions and database Migration from SQL Server 20014 to 2016.

• Perform Schedule Backup and Restore operations.

• Maintained Server Security by assigning logins, Server and Database Roles, and permissions.

• SQL Server Agent monitoring and troubleshooting jobs, and events notifications using Database Mail.

• Used Optimization Tools such as SQL Profiler, Dynamic Management Views (DMVs), and Windows Performance Monitor to monitor and Tuning SQL Server for optimum performance.

• Migrated SQL Server from Prem to Azure SQL Server Database.

• Maintaining two different Databases: Read-only reporting Database and Disaster Recovery Database. Recovery.

Work hand-in-hand with Application Development Teams for Application deployment and monitoring

BGL Plc January 2015 to December 2017

Lagos, Nigeria.

• Automate routine tasks that follow prescribed standards

• Maintain and monitor alerts for database monitoring

• Maintain and enhance existing database security and database user security.

• Perform database tuning and optimization

• Responsible for setting up and maintaining High Availability and Disaster Recovery solutions

• Ensure the integrity, security, and performance of database systems

• Ensure that database systems storage and archiving procedures are functioning correctly

• Troubleshoot and resolve various database-related problems per standards

• Maintain, enhance, and collaborate on appropriate documentation and standards

• Stay current with changes in the field, especially regarding data database administration

• Find, document, and inform of database anomalies and non-standard functionality or configuration.

• Install and upgrade the database servers and application tools

• Allocate system storage and plan storage requirements for the database environment

• Manage and monitor data replication.

AFRICAN INTERNATIONAL BANK LTD June 2010 to Nov. 2014 Lagos, Nigeria.

• Branch Relationship Manager

• Investment Advisory Manager

• Attending monthly Management performance reviews and strategy meetings.

• General Branch Operation and administration responsibilities. Education and Training:

• MSSQL Database Administration: Info-Tech Computer College, Benin City Nigeria- 2014

• Masters in Business Administration (MBA): Ogun State University, Nigeria- 2006

• BSC Banking and Finance: Ogun State University, Nigeria-2004

• Fellow Chartered Institute of Bankers of Nigeria-2012

• Associate Chartered Institute of Bankers of Nigeria-1992 References: Available on request

Contact this candidate