Location: Maryland, MD *****

Contact: 682-***-****

Nuriyyah Oladosu Email: advsjq@r.postjobfree.com

F

Highly trained, skillful, and accomplished database administrator with 8+ years of depth experience in MS SQL Server database development and administration in enterprise production environment. Experience in installation, Upgrades (In place Upgrade and side -by-side) and configuration of MS SQL Server 2008 R2, 2008 versions on both Standalone and Cluster Environments. Exceptional abilities in Software installation, Maintenance, Data Extraction, Transformation, and Loading. Specialized in Data Handling, Database Backup and Recovery . Dynamic, highly driven, and diligent professional with a proven history of success in database security through configuring transparent database encryption (TDE) and dynamic data masking . Database administrator with capabilities of monitoring performance, conducting diagnostic tests, troubleshooting database issues, configuring devices, and planning for capacity expansion and other upgrades . Proven adaptability of learning new skills, embracing challenges effectively under pressure, and dedication to generate great customer and shareholder value propositions through innovation. Looking for a high-level opportunity in a dynamic organiz ation in which my enthusiasm, expertise, and talents are utilized to the greatest degree possible.

AREAS OF EXPERTISE

RDBMS database design

Migration of MS SQL Server

ETL Tools: SSIS, DTS,

T-SQL, and Power Shell script

Cloud migration

R2/2016 Windows Server

Optimization, backup, and recovery

Microsoft Office

Database Engine, Tuning Advisor

Disaster Recovery Planning

Process Improvement

Query Advisor, SQL Profiler

SQL login implementation

System Administration 2008/2012

Project Management

Data Mapping/Warehouse

Data Transformation services

Upgrade Wizard, Replication

SUMMARY OF CORE QUALIFICATIONS

Ensures databases are security, availability, and recovery

Solid knowledge of index management, integrity checks, configuration, patching, statistics

Strong analytical, planning, and organizational skills with ability to manage competing demands

Strong knowledge of Windows platform

Professional experience of creating and supporting ETL processes, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). Experienced with POWER BI and Tableau

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

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

Creative approach to problem-solving with the ability to focus on details while maintaining the “big picture” view

Strong knowledge normalized and dimensional database experience

Strong knowledge in entity-relationship models and DWH design techniques

MS SQL SERVER 2000/2005/2008, 2012, 2016, 2017, 2019, Analysis Server 2000/2005, MS Access 2000/2005/2007.

Experienced with Azure cloud services, Oracle DB, and AWS.

Solid experience on High availability (Always-On) SQL Server solutions, including Replication Models (Snapshot/Transactional), Mirroring, Log Shipping, Mirroring and HADR Setup Configuration.

Expert in RDBMS database design, performance tuning, optimization, backup, and recovery.

Excellent analytical, communication, detailed oriented and people skills.

Provided Databases and configured appropriate HA/DR strategy based on the RTO/RPO objective of the organization. Managed over five hundred databases and VLDB across multiple data centers. Enhanced database performance, performed restores, implemented recovery procedures, and conducted regular health checks and system backups. Conducted performance tuning tasks regularly on issues ranging from query tuning to index optimization, TempDB issues, to IO, High CPU usage, severe blocking, long-running query, AlwaysOn uncoordinated, mirroring out of sync, log shipping out of sync. Responsible for setting up and maintaining High Availability and Disaster Recovery Solutions and large-scale database migrations from SQL Server 2005 to SQL Server 2012R2, 2014, and 2016.

Key Contributions:

Migrated SQL Server from on-premises to Azure SQL Database and AWS

Monitored daily, weekly, monthly, and quarterly Maintenance Tasks, ensuring that they were successful and resolved any issues when they failed. (Automating repetitive tasks using power shell)

Performed Database consistency checks with DBCC, Defrag, Index tuning, and monitored error logs

Participated in change management processes including deployment of database changes in all environments as requested, followed client change management standards and procedures

Maintained client documentation including database topology, connection procedures, and special instructions

Provided database administration, performance tuning support for Markets Business

Performed database hygiene and maintenance to ensure optimum performance

Maintained server security by assigning logins, server and database roles and server permissions.

Installed, configured, and maintained MS SQL Server Replication for production servers to provide high availability Weekly Patching of Standalone and Cluster instances

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

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

Performed Database Refresh tasks from production to Development and Staging Servers

Managed permissions and security, performs security tasks like Grant, Revoke permissions for security tasks

Provided On-Call support to Mission-critical Environments

SQL Server Database Administrator Oct 2017 – Jan 2019

TradeGo Integrated Services, NY/NJ

Responsible for reviewing and tuning technology-specify database coding technologies (PL/SQL, isql, etc.). Responsible for performance tuning and ensuring high availability of infrastructure, including operating system and storage subsystem. Followed company’s guidelines to ensure company data is held in a secure manner, including electronic access or in written format. Planned and executed disaster recovery (DR) exercises on the DR servers. Managed permissions and security. Conducted regular health checks across thousands of servers using PowerShell script. Maintained database space issue, resolving excessive log growth issue, and Normalization of DBs. Assisted application development with logical & physical database design considerations, database refreshes, cloning, and backups. Performed database changes and code promotions according to Enterprise Change management processes and standards.

Key Contributions:

Performed discovery and documentation on numerous (newly inherited) existing SQL Server database servers and created a standardized support model to manage these servers.

Established relationships with the Business Owners and worked to create a team approach for the management of their database servers.

Installed SQL 2012/2014 with the Always On (2&3 replicas). Performed upgrades and security patches to databases as required.

Built Clusters 2 node and 3node with Active – Active and Active-Passive.

Stabilized a volatile SharePoint application database server with multiple issues and implemented database mirroring for high availability. Worked with application analysts and server engineers to design and assess a disaster recovery plan for this mission critical system.

Managed a difficult atypical recovery of a mission critical system.

Created and supported ETL process from Oracle to SQL server, Sybase to SQL server, Access to SQL server, Excel to SQL Server.

Increased the MS SQL Server Availability time with optimum level of Database Recoverability by incorporating the SQL server Differential backup and LOG Backup.

Gathered data requirements, designed, and fine-tuned database as per the requirement of clients.

Provided primary SQL Server support and monitored performance for all databases instances and the Business Objects/Crystal Reports server.

Rewrote queries, stored procedures, and created missing indexes used in the company's ASP-based reporting portal application and developed a new set of Crystal Reports used by external clients.

Monitored and fixed nightly maintenance; optimized and improved DTS and SSIS packages.

Performed ad-hoc complex queries for the sales, accounting, and customer service departments

Database Administrator May 2015 – Sept 2017

Greenland Inc. Services

Key Contributions:

Provided Installed and configured SQL Server 2008 and 2012 on Windows server 2008

Exported and imported data from text files and Excel to SQL Server using Bulk Insert and BCP utility. Worked with development team to optimize schema and performance.

Initiated project to migrate Windows 2000 Active Directory to Windows 2003 Forest/Domain.

Evaluated, assessed, built, and maintained HP/Compaq ProLiant servers including Windows, Citrix, Exchange, SQL Server and VMWare ESX hosts.

Installed, configured, and maintained 8 SQL Servers and 10 Citrix Servers in farm.

Worked on SSIS packages for transferring data from various data sources like MS Access and Excel.

Created and managed schema objects such as tables, views, indexes, and referential integrity depending on user requirements and converting them into technical specifications.

Designed SSIS packages to extract data from various OLTP sources, Text Files, XML Files, Excel and MS Access to OLAP system like SQL Server.

Failover cluster on same and multiple subnets. Wrote complex T-SQL queries using stored procedures, functions and views.

Developed an insurance verification application for billing and collections using Microsoft Visual Basic.

Supported and maintained Microsoft NT 4.0 server and network platforms as well as Network troubleshooting

Architected and created new data warehouse which included implementation of new data loads, new data marts for reporting.

Supported Created reports in SQL Server Environment using SSRS in Business Intelligence Development Studio (BIDS). Collaborated with the front-end developers to deploy the reports.

Knowledge of proper use of Indexes to enhance performance of individual queries for fast and efficient reporting. Managed, set up and configured DB mail and created operators to send out an email whenever any SQL jobs fails.

Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.

Environment: SQL Server 2008/2012 Enterprise Edition, Windows 2008/XP, SSIS, SSRS

EDUCATION & TRAINING

Bachelor of Arts

Ahmadu Bello University Zaria, Nigeria 2014 GPA: 4.48

Diploma in Computer Science

Rufus Giwa Polytechnic Lagos, Nigeria 2006

CERTIFICATIONS & AFFILIATIONS

SQL Server Database Administration Certificate Kastelnet Centre, Lagos 2016

Contact this candidate