Post Job Free

Resume

Sign in

Sql Server Database Administrator

Location:
Olathe, KS
Salary:
$100,000
Posted:
August 08, 2023

Contact this candidate

Resume:

Emmanuel Mbella Endeley

Tel: 913-***-****

Email: adysyb@r.postjobfree.com

SUMMARY OF TECHNICAL EXPERIENCE

•SQL Database Administrator with over five years’ experience working with MS SQL.

•Responsible for daily maintenance of an environment comprising of over 150 servers, 300+ Instances and 500+ databases.

•Enhanced database performance, implemented recovery procedures, and achieved 99.9% up time on all SQL Servers.

•Increased efficiency by providing optimum database performance with efficient backup and restore processes.

•Create automation for repeating database tasks.

•Experience with database migration using Azure.

•Strong experience with SQL Server 2008 through 2019 with both standalone and cluster environments.

•Configured and supported replication and log shipping in different versions of SQL Server.

•Experience with High Availability Solution- Clustering, Always On, Database Mirroring, and Log Shipping.

•Advanced skills in Redgate and Solar Winds Monitoring tools.

•Experience with Extended Events, SQL Server Profiler, Query Store, Import/Export Wizard, SSMS, and Tuning Advisor tools.

•Experience with trouble shooting, performance tuning using both inbuild and third-party tools.

Professional Experience

Black Knight of Overland Park: Kansas, USA MS SQL Database Administrator 03/2021-Present

•Provide 24/7 production database administration support and monitoring to ensure a proactive problem recognition and resolution of database issues.

•Installation of SQL server in both standalone and clustered environment.

•Provide DBA support and technical expertise for multiple applications in Development, Test, and Production of SQL server 2012, 2016,2017, 2019 environments.

•Configured High Availability Solution and Disaster Recovery such as, Traditional Failover Clustering, Log Shipping, Always on availability group and Replication.

•Upgrading databases from lower versions of SQL to a higher version.

•Vertical and horizontal migration in SQL server standalone and cluster.

•Planning and implementation of database backup/restore and disaster recovery.

•Managed database security by creating, assigning appropriate roles and privileges to users based on user activity, auditing and performing important security tasks as transparent data encryption and creation of contained database.

•Solving ticket using Jira and service desk ticketing system based on high to low priority.

•Carryout database migration using Azure.

Dupont New Century Pkwy Gardener: Kansas, USA

Database Administrator 05/2018 –02/2021.

•Configured High Availability Solution- Always on Cluster, Traditional Failover Clustering, Database Mirroring and Log Shipping

•Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to successful backups, resolving system issues, opening cases with vendors to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, and database recovery.

•Respond to and resolve all database access and performance issues.

•Upgrade SQL Server by reviewing, planning, testing, and installing database security patches and service packs.

•Design, documentation, and promote security best practices, policies, standards. Setup and maintenance of appropriate database and application monitoring using Idea monitoring tool.

•Working with development and systems teams to perform application and database upgrades and tuning.

•Migrating and upgrading SQL Server 2012 to SQL Server 2019.

•Setup and maintenance of appropriate database and application monitoring using monitoring tool.

•Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.

•Setting up TDE, DDM, and always encrypted.

Educational Experience

•Bachelor of Science (Information science) University of Buea- Cameroon-10/2007-12/2010

•Training in Microsoft SQL Server Database Administrator

•Trainings in Microsoft Business Intelligence (SQL, SSRS, SSIS and SSAS)

•Training in Microsoft sql server (solution associate)

CURRENT PROJECTS

•Upgrading from SQL Server 2012 to SQL Server 2022.

•Database Migration using Azure.

•Setting HD and DR Solutions (Always On, Replication, and Database Log Shipping)

•Windows and SQL patching

•Responding to ticket queue (refreshing databases on demand, creating logins and users)



Contact this candidate