Database Administrator Server

.

.

Sylvester Obidike.

Location: Mansfield, TX Phone: 214-***-**** Email: *********@*****.***

Summary

A highly motivated SQL Server Database Administrator with strong experience in SQL Server Security, Database Maintenance, Performance Tuning, High Availability and Disaster Recovery Solutions. Worked with different versions of SQL Server from 2008 to 2019. Handled production and project support in a 24/7 environment. Currently work in a complex environment with databases hosted on premise and on Azure cloud. Very good in documentation, teamwork, and attention to details. Core Technical Competencies

• Project documentation

• SQL Server Reporting Services/Power BI

• SQL Server Integration Services/ETL Operations

• Microsoft SQL Server Database Management

• Performance Tuning/Query Optimization

• Query store, Import/export

• Extended Events/SQL Profiler

• Upgrade and Migration

• SQL Server installation

• PowerShell Scripting

• Azure Database Management

• Backup and Restore

• Table/view/ Schema design and management

• T-SQL (Stored Procedures, Triggers, Functions)

• High Availability Solutions (Clustering, AlwaysOn, Log Shipping)

• DR planning and implementation

• Security/Access Management

• Replication

• Patching

Experience

SQL SERVER DBA 08/2018 - Present

Modaj Pro Solutions, Sugar Land, TX

• Production, development and project support of client databases

• Coordinate with project management staff on database development timelines and project scope

• On call/duty rotation

• Migration of on premise databases to the Azure cloud

• Implement Azure backup and backup of on premise databases according to client Service Level Agreement

• Installation and configuration of SQL Server Reporting Services (SSRS)

• Perform ETL operations to move data from various sources to data warehouse

• T-SQL scripting, writing and analyzing complex SQL queries

• Control access, permissions and privileges on production and development databases

• Configure different levels of encryption, especially Transparent Data Encryption on mission critical databases and Dynamic Data Masking on sensitive columns

• SQL Server upgrade from older versions to newer versions, using in-place or side-by-side upgrade method

• Troubleshoot and resolve slow-running queries to optimize query performance

• SQL Server Installation, configuration and troubleshooting

• Capacity Planning and resource allocation

• Index maintenance (rebuild/reorganize) to improve performance and reliability

• Configure Transactional and Merge Replication with up to 5 Subscribers to a publisher for client database

• Actively monitor and resolve Database Performance issues

• Table design, views, stored procedures, etc

• Planning and implementation of AlwaysOn Availability Groups project

• Creating contained databases when needed

• Tables Design, views, Stored procedures, Function etc.

.

.

SQL SERVER DBA 03/2017 - 08/2018 Freeborn Corporation, Houston, TX

• Documented database system configurations and operational procedures

• Conducted database backups and occasional planned backup restore

• Deployed projects from other sources using Microsoft visual studio into SQL Server instances

• Resolved database query issues and made sure that Data is consistent

• Performed Database Integrity Checks, reorganized, and rebuilt indexes when necessary

• Created new databases and designed database objects - tables, views, stored procedures

• Participated in planning and installation of SQL Server Instances

• Responsible for security administration - setting up users and logins in SQL Server, while ensuring users had only the minimum access required to get their jobs done

• Migrated databases from source server to destination server

• Data Encryption including dynamic data masking for sensitive columns

• Configured Resource Governor in mission critical SQL Server Instances with multi-tenancy

• Cleaned up over 10 poorly designed tables and configured table compression to save space

• Actively monitored performance and maintenance jobs to ensure databases’ integrity Education and Training

MBA

Coventry University, London, UK

Nov 2012

LL.B.

University of Calabar, Calabar, Nigeria

Feb 2007

Advanced MS SQL Server Training

MPIT Academy, Houston, TX

Jan 2017

Contact this candidate