Microsoft SQL Server Database Administrator

PROFESSIONAL SUMMARY

I am a Proactive, and self-motivated IT professional with over 5years + experience in Database Administrationand MS SQL Server Installations, Configuration, Upgrades, Troubleshooting, performance tuning, monitoring,and security. Azure SQL Databases, Migration, Azure backups, Storage Accounts, Azure VMs and Powershell.Manage end-to-end security operations involving setting up logins, user IDs, and permission grant to databaseobjects in line with company’s security policy. Leverage expertise and industry best practices while running SQLserver health check on Microsoft SQL server databases and servers. Ensure timely configuration of highavailability solution, always-on cluster, Replication, database mirroring,and log shipping to overcome irregularities. Identify areas of improvement and troubleshoot SQLDB 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 alwaysopen and ready to learn new technologies, Team focused and goal oriented. Have worked successfully bothremotely and onsite, with little or no supervision.

SKILLS

- SQL Server 2008-2019, Standalone and Cluster environments

- MS Azure Cloud computing

- MS SQL Database Administration/Installation, Configuration/Security/HR, DR

- Database upgrade and deployments

- Strong experience with Performance Tuning and Troubleshooting

- Query Optimization using in-built tools (SQL Profiler, Extended Events, Query store) and external tools(IDERA, SolarWinds)

- High Availability and disaster recovery solutions-Log Shipping, Always on Availability Groups, Replication and Database mirroring

- Expert in backups and recovery processes using both SQL level backups and PowerShell.

- Expert knowledge on DB Security

- SQL Server Task Automation

- Problem Solving Skills, Performance analysis

- Documentation of processes and user stories, Presentation

- Effective Listening, Time Management, Verbal communication, and written communication skills

- Database Software, Computer Science, Database Management systems, Relational Database,Information systems.

- T-SQL Scripting, Query tuning and Production Support, capacity planning

- A great team member with a flexible positive attitude

- Hyper-V, Virtualization/ Virtual machines/Active Directory

- Subject matter expert with a great knowledge on Key performance indicators

- Production, Dev, and Test Environments

- Organizational change management

- Azure SQL databases

- Azure Storage accounts

- Azure VMs

- Azure PowerShell

- Azure High Availability

- Expert in Visual studio installation

- Expert with using B.I tools( SSIS, SSAS, SSRS)

- Expert in Data Warehousing

- Expert in using ETL tool

-Expert in Data migration and maintenance using SSIS

- Expert in Data Analysis using SSAS

PROFESSIONAL EXPERIENCES

February 2019 – Present

Senior Support Engineer and Senior database administrator

Responsibilities

- Senior Engineer with SQL Engine.

- Resolve performance Issues arising from SQL Engine.

- Communicate with customers to gather information in a fast-paced environment.

- Explain customer responsibilities in resolving issues, communicate next steps and status, inspire confidence.

- Resolve difficult customer issues.

- Provide customer support through phone calls, email, and chat services as applicable.

- Offer 24/7 customer support.

- Handle both technically challenging and politically sensitive customer situations.

- Review and 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 following Microsoft best practices and company policies.

- Build and configured Windowserver fail-over clusters for HA solutions.

- Set up and managed monitor Always-On availability groups.

- Install windows and SQL server patches.

- Follow process to Perform Server decommissioning.

- Ensure database safety and Maintain database security (users, logins, and granting assess).

- Task Automation using SQL server agent/ PowerShell.

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

- Perform database refreshes/Data management, Upgrade from SQL Server 2008 to SQL 2016.

- Performance Tuning, troubleshoot and query optimization using inbuilt monitoring tools and 3rd party tools.

- Documenting of database processes.

- Prioritize, monitor, and remove impediments to improve team performance.

- Migration of databases, Database design and designing, data migration into data warehouse- Resolving of tickets/Special assignments using ssis.

- Provide full engagement in teams to identify risks and impediments to sprint goals and proposed solutions to address them quickly and efficiently.

- Manage and maintain large and numerous SQL databases.

- Configuration of database, database administration- Team Focus, Technical skills, have a vision forsuccess and progress.

- Develop strategy to monitor Document Processes

- Aid developers, application analyst, project manager

- Keep up to date with new software releases of Microsoft SQL Server and emerging technologies

- Microsoft Management Studio/SQL Server Reporting Service Visual Studio/Power BI

- Work with the DBA team for the development of the organization and carrying on projects

- Work in close collaboration with other IT departments to provide customer support

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

- Support applications / OS with databases hosted on SQL Server.

- Implemented data security by creating users both at active directory and server level, assigning

- Set up always encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure client sensitive data

- Recover databases following companies SLA

- 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.

EDUCATION AND CERTIFICATION

- Bachelor’s Degree, university of yaounde 1, Cameroon

- Microsoft Technology Associate -Database Fundamentals

- DP-300 Administering relational Databases in Microsoft AZURE SQL Cloud – Pursuing

Contact this candidate