Post Job Free

Resume

Sign in

Server Administrator Database

Location:
Los Alamos, NM, 87544
Salary:
130000
Posted:
January 27, 2023

Contact this candidate

Resume:

CHRISTIAN ODUNZE

aduyqb@r.postjobfree.com

***** ******** *****, ****** ** 75254 Cell Phone: 469-***-****

Professional Summary

I am a highly successful and motivated IT Professional with 9years’ experience in the IT Industry. I have 6years of experience in MSSQL Server Database Administration, managing mission critical databases on Prem and in the Cloud (Azure) and 3 years’ experience as a Systems Administrator.

I am a very proactive DBA and I have administered and provisioned SQL Servers 2008, 2012, 2014, 2016, 2017 and 2019 in production, Test and Stage Environments. I am a highly motivated self-starter with strong interpersonal and persuasive communication, outstanding problem solving, and active listening skills. An agile team player with excellent communication skills and problem solver who can successfully manage multiple priorities while performing well under pressure. I am a proven leader with motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solution.

Core Qualifications

A Database Professional with over 5 years’ experience managing mission critical databases on Prem and in the Cloud (Azure)

Data Conversion

Migration

Performance Tuning

SQL Automation

Database Security

SQL Server HALODR

SQL Server Reporting Services

Backup and Restore Procedures

Active Directory

SQL Server Upgrade and Patching

Database Refresh

Installation and Configuration of SQL Server

AWS • Azure. ETL Tools: SSIS (SQL Server Integration Services), DTS (Data transformation Services), Import and Export Data, Bulk Copy Program (BCP).

Oracle 11g/12c Installation • OEM • RMAN • Data Pump

OLAP

OLTP

POWERSHELL

AWS

AZURE

LOGSHIPING

ALWAYS ON

MIRROWING.

GCP

Profile

Experience in Managing Database Security by creating Users, Roles and assigning proper permissions according to the business requirements.

Experienced in database security through configuring transparent database encryption (TDE) and dynamic data masking.

Hands on in setting up and troubleshooting Always On, Clustering, Database Mirroring, Log Shipping, including Replication models (Snapshot, Transactional/Merge).

Proactive in establishing backup and recovery processes and protocols to protect and retain valuable company data.

Proficient in T-SQL, Linux and Power Shell languages.

Proficient in Relational Database Management Systems (RDBMS).

Successful Database Administrator in database development and production environments.

Areas of expertise include Maintenance and security.

Experienced working with ServiceNow, SolarWinds, SQL Sentry etc.

Experienced in Active Directory (AD) objects and user permissions.

Experienced with Azure, AWS and Google cloud.

Extensive experience in Administering SQL Server in a Clustered and Non-Clustered Environment.

Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.

Basic Knowledge of Linux/Unix Commands.

24/7 on Call Support for Production Database.

Proactive in establishing backup and recovery processes and protocols to protect and retain valuable company data.

Expertise in Performance Tuning, Maintenance, High Availability and Disaster Recovery (HADR) Solutions.

Experienced with creating and support ETL processes, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Experienced with POWER BI and Tableau.

Responsible for securing SQL Server, User Management, assigning permissions and roles.

Experienced 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 Experience

OBello Technology Inc. Dallas TX. Aug 2019 to present

SQL Server Database Administrator

Global Management Consulting and Professional Services

Using SSIS, building high performance data integration solutions, including extraction, transformation and load (ETL) packages for data warehousing.

Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs.

Responsible for providing 24x7 DBA & Production support for over 180 SQL Server databases in Production on Clustered Servers.

Involved in assisting SQL Server prime customers with Configuration, Administration, Implementation and Troubleshooting for Business workflow with Log Shipping mechanism.

Configured DR solution with Transaction Replication from Distribution Server with multiple Update table subscriptions.

Involved in Installation, Configuration and Deployment of SSRS Reports using different topologies.

Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008-19.

Performed Database Refresh tasks from production to Development and Staging Servers.

Performed Scheduled backups and restore operations with LiteSpeed 4.5

Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.

Managed over 600 servers and 1500 databases across multiple data centers. • Involved in Technical decisions for Business requirement.

Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers.

Migrated SQL Data from on premises to Azure SQL Database.

Responsible for setting up and maintaining High Availability and Disaster Recovery Solutions and largescale.

Database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014/2016.

Smooth Multi Service Platform, Allen Tx Nov 2016 - Aug 2019

SQL Server Administrator

Professional Information Technology services

.Plan and Implement database backup/restore and disaster recovery.

Implement Log Shipping, from Primary to Standby servers.

Used Optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and Windows Performance Monitor for monitoring and tuning SQL Server performance.

Administered support for Oracle and PostgreSQL database.

Perform SQL Server service pack and Windows Service pack patches and upgrades.

Monitor and implement Comprehensive Backup plan and disaster recovery strategies.

Perform Regular Backup and Maintenance Jobs across enterprise banking databases Managed.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. (Index creations, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases).

Responsible for providing 24x7 DBA & Production support for over 180 SQL Server databases in Production on Clustered Servers.

Perform Physical and Logical Data Modeling for databases of varied sizes including VLDBs.

Perform Database Refresh tasks from production to Development and Staging Servers.

Perform Scheduled backups, restore operations and automation.

Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.

Resolve SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, backup/restore, security and continuous improvement.

Supreme Security Services, Antigua and Barbuda Dec 2014-Sep 2016

Security and Arm Guide

System Administrator

Performing network hardware/software troubleshooting, performance tuning, and security auditing.

Providing on-call technical support for network and communication problems.

Maintaining technological proficiency and certification through training and education sessions, seminars, workshops, and courses, and by reviewing online and published literature or training.

Completing special projects and presentations as assigned by the IT director, technology services manager, and senior network administrator.

Researching and choosing hardware and software products to be deployed and supported by client services.

Assigning field calls and balancing the workload for the deployment of new equipment and replacement of PCs.

Standardizing, creating and maintaining client images using Microsoft deployment toolkit and Norton Ghost.

Structure Cabling (Cat 5, Cat 5e, Cat 6 and Fiber Optic) Network processing, centralized and distributive network connection.

Installing, configuring and administering network technologies including firewall, routers and switches.

Installing and configuring Windows Vista, Windows 7, Server 2003 & 2008, Linux Server.

Designing, implementing, and testing wireless, Local Area Network (LAN), Wide Area Network (WAN), internet, and other data communications systems and segments.

Coordinating network maintenance activities with city network users, external network managers, and other technical service personnel.

Achieved customer’s satisfaction rating of 95% with Six months, exceeding corporate target.

EDUCATION

Federal University of Technology Akure. Feb 2001-Sep 2007

(Bachelor’ Science( Food Science and Technology)

Federal University of Technology Akure.

Information and Communication Technology (ICT) Diploma Jan 2008- Oct 2009

Certification

ORACLE Database 11g/12C Certified.

Professional Dossier

Gender: Male

Languages known: English

References

References Available on Request.



Contact this candidate