Sql Server Database

Dede EKUE

Microsoft SQL Server Database Administrator

678-***-**** ***********@*****.***

ATLANTA,GA

PROFESSIONAL SUMMARY

I am a Proactive, and self-motivated IT professional with over 5years + experience in Database Administration and MS SQL Server Installations, I have administered and provisioned SQL 2008 to 2019 in Production, Test, Development and Clustered Environments. Configuration, Upgrades, Troubleshooting, performance tuning, monitoring, and security. Manage end-to-end security operations involving setting up logins, user IDs, and permission grant to database objects in line with company’s security policy. Leverage expertise and industry best practices while running SQL server health check on Microsoft SQL server databases and servers. Disaster Recovery/Disaster prevention, Database Refreshes, SQL Server Upgrades and Patches and the preparation and deployment of SSIS packages, Active directory and other Windows server features .Ensure timely configuration of high availability solution, always-on cluster, Replication, database mirroring,

and log shipping to overcome irregularities. Identify areas of improvement and troubleshoot SQL

DB slowness and Disk/Memory/CPU utilization process. Control data recovery, maintenance, data integrity, and space requirements for physical databases in an efficient manner. I am also a fast learner who is always open and ready to learn new technologies, Team focused and goal oriented. Have worked successfully both remotely and onsite, with little or no supervision.

PROFESSIONAL EXPERIENCES

Elad Signs Atlanta-Ga April 2019 -Present

Microsoft SQL Server Database Administrator

Responsibilities:

Perform health check on all SQL server databases and implement Microsoft best practice.

Ensure appropriate maintenance including database consistence check, index optimized, statistics and backups

Installations and configuration of new instances of SQL server instances

Build and configured Windows fail-over clusters for HA solutions

Set up and managed monitor Always-On availability groups

Install windows and SQL server patches Migrate SQL Server instances and Migrate databases

Perform Server decommissioning, programming

Ensure database safety and Maintain database security (users, logins and encryption)

Task Automation using SQL server agent

Administer database backups using both SQL server and third-party tools

Perform database refreshes

Upgrade from SQL Server 2008 to SQL 2016 and 2017

Performance Tuning and query optimization using inbuilt tools and 3rd party tools like Idera and solarwinds

Document database processes

Interact with developers, application developers and project manager

Prioritize, monitor and remove impediments to improve team performance

Works with PO to prioritize and reprioritize backlog into sprints/releases to align with business needs.

Tracks team’s progress, including daily burn down chart, velocity and release forecasting.

Help teams to identify risks and impediments to sprint goals and proposed solutions to address them quickly and efficiently

Contribute to product roadmap planning, project scheduling and release management Implemented data security by creating users and assigning permissions following the principle of lease privilege. • Set up always encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure client sensitive data

• Set up and manage Always on availability groups, Log shipping Replication, for high availability and disaster recover

• Recover databases following companies SLA

• Create and update database documentation about company standard procedures, technology features and production issue troubleshooting. • Leveraging the uses of in-built software in SSMS such as SQL Server profiler, Performance monitor, Extended Events, DMVs, Database Integrity checks to ensure database integrity, stability.

A Touch of Care and Love Llc,–Decatur –GA May 2017- March 2019

Microsoft SQL Server Database Administrator

• Responsibilities:

• Run SQL Server health check on all SQL Server databases and implement Microsoft best practice

• Planning the Installation of Microsoft SQL Server, 2008R2, 2012, 2014, 2016, and 2019 building.

• Plan, install, and test software upgrades and patches.

• Upgrade from SQL Server 2012 to SQL Server 2016

• Monitor and evaluate database performance using inbuilt SQL Server tools and 3rd party tools trends to identify anomalies or errors.

• Create and maintain all SQL Server databases required for development, testing, education and production usage.

• Perform database refreshes

• Administer database security and control access (create, users, logins, implement database encryption)

• Implement HA for business-critical databases (Transaction log shipping, Always-On availability groups)

• Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.

• Perform database transactions and security audits using SQL Queries, • Document Processes

• Provide support to developers, application analyst, project manager

• Ensure appropriate maintenance is in place including backups, index maintenance, consistency checks and statistics.

• Administer database backups and restores (database refresh)

• Keep up to date with new releases of Microsoft SQL Server and advise on aspects that pertain to

• Creating and monitoring maintenance plans and agent jobs that take backups and defragment indexes for query performance

• Work with developers to deploy scripts in PROD

Implemented data security by creating users and assigning permissions following the principle of lease privilege.

EDUCATION AND CERTIFICATIONS

• University of Lome -Togo

• DP-300 Administering relational Databases in AZURE – Pursuing

SKILLS

●Virtualization using VMWare and Hyper-V.

●SQL Server Integration Services - SSIS

●SQL Server Analysis Services – SSAS

●SQL Server Reporting Services - SSRS

●High Availability (HA) and Disaster Recovery (DR) solutions; Traditional Failover Clusters, Always On Availability Groups, Replication, Database Mirroring and Log Shipping

●SQL Server Monitoring - Inbuilt monitoring tools like SQL Server Profiler, Database Tuning Advisor, Extended Events and External tools like IDERA

●Using PowerShell to automate processes on my servers.

●Proficient with SQL Server 2008 to 2019, Optimization and Performance Tuning

●Support big databases - 3 terabytes and more.

Contact this candidate