Sql Server Database administration

Joe Anthony Ekpo

Phone: 270-***-****, E-mail address: **************@*****.*** Houston Texas

PROFESSIONAL SUMMARY

EXPERIENCED IN SQL Server Administration and Design

Seasoned SQL Server database administrator with over 4 years of Strong Experience with SQL Server 2000 through 2016 Administration

Production support in a 24/7 environment and project support.

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

Install and Upgrade SQL Server 2008, 2012 and 2014 database standalone / cluster instances

Service packs

High Availability Solutions- Database Mirroring, Log Shipping, Always On etc

Performance tuning and optimization

Complex database environments, Production, Development and Test Environments

TECHNICAL EXPERIENCE

Translating business requirements into conceptual, logical and physical data models

Administering, Managing, Developing and configuring SQL Server database design,

Performance tuning and query Optimization

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

SQL Server Performance Dashboard Reports for Monitoring

Performance Baselining

High Availability Solution- Clustering, AlwaysOn, Database Mirroring and Log Shipping

Disaster Recovery Strategy

Query Store, Import/Export Wizard, SSMS, SQL Profiler, Extended Events, Red-Gate tools etc.

Replication Models (Snapshot/Transactional/Merge)

Clustering Setup, Troubleshooting and Management

CMS Reporting-Member enrollment

Virtualization

Good T-SQL Writing skills

Temporal Tables

Knowledge of SQL Azure

PROFESSIONAL EXPERIENCE

Accenture Houston Texas 2014 – Present

Role: SQL Server Database Administrator

Production level support for onsite and offshore Clients

System monitoring

Integrated Temporal Tables

Troubleshooting client connectivity

Lock resolution

SQL Server Performance Dashboard Reports for Monitoring

Performance Baselining

Manage indexes to improve performance

Schedule jobs using SQL Server Agent

Developed routine jobs for data integrity check

Code deployment into Production

Information Risk Management Control

Tables Design, views, Stored procedures, Function etc.

Managing Server and database security and identity

Managing Firewall Rule, Triger, Rowversion, Temporal Tables, Change Data Capture (CDC) etc

Column Store Index for performance

Contained Databases

Task Automation

Indexes Maintenance

Stabilized Performance

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

Implementation of snapshot isolation and DDL triggers

SQL Azure

Stable Replication Topology

Comprehensive Backup plan and disaster recovery strategies

Installed SQL Server 2008 on advanced servers, applied security fixes

SQL Server Upgrade

Installed and configured MS SQL Server 2008 R2, supported all Production and development servers

Maintained database response times in 24X7 Production environments

Developing SQL scripts for maintaining administration tasks

SSIS, high performance data integration solutions, ETL packages

SQL server Reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draws content from a variety of data sources

Capacity Planning and resource allocation

Monitoring standby databases to ensure high availability

EDUCATION

High School Diploma

Advanced SQL Server Training – ModajPro IT

SQL Server Training Strategic Intelligence Technology

CERTIFICATION

Pursuing Microsoft Certification (MCSE)

Brand Ambassador (Symon Priestley Training Network

Contact this candidate