Administrator Associate Database

PROFESSIONAL SUMMARY

A Passionate Microsoft Certified SQL Server Database Administrator with 8+ years’ experience of innovation and success in day-to-day administration. maintenance, optimization and troubleshooting of database platform in a SQL Server environment, work closely with business managers to provide optimum business solutions by configuring great reports using power-BI, Expert in ETL process and report designs. Configure and deploy HA/DR solutions to ensure databases always 99.99% up time, SQL Server/Azure cloud migration with goal to ensure smooth business continuity. Very passionate contributor to team success, self-starter who is versatile with reports technologies across multiple platforms, keeps up with current technology and develop solutions for company’s future growth

AREAS OF EXPERTISE

Works closely with developers to provide optimum business solutions.

SQL Server installation in Standalone and Cluster

Administrating Azure Cloud Resources.

Project Team leadership and Management.

Performs other duties and assists as needed

Analyzes platform for compliance with best practices

Proficiency using C#

Performance Monitoring and Tuning

Proficiency using Power-BI

Proficiency using Python

SAAS

Develop SSIS automation, SSRS reports as needed

SSIS: Build, deploy and troubleshoot Packages.

Azure Cost Management solutions.

Manage Azure elastic pools/ managed instances.

Log shipping and Always-on as HA & DR solutions

Implement Backup and Recovery Strategies

Configure TDE for critical DB Encryption

Provides on call-support

T-SQL, Power Shell scripts review for developers.

Proficiency using Jira as a: Ticketing tool

SSAS

PROFESSIONAL EXPERIENCE

BAXTER

SQL Developer August 2022 Present

•Creating, updating database objects like stored procedures, user defined functions, triggers, views, tables and other database objects for application development

•Review and interpret business report requirements to address user needs

•Analyze existing SQL queries to identify opportunities for improvements and prepared memory management for database systems

•Document and analyze business reports for prompt communication, follow up and ongoing support.

PTAC Consulting Engineers

SQL Developer June 2022 -Present

Prepare reports using power-BI for business decisions making.

Configured email account for staff as SAAS service on Azure cloud platform

Used power shell in migrating databases from one server to another

Used C# in configuring both windows and web interfaces

Responsible for creating Database Objects like Stored Procedures, User defined Functions, triggers, Views, Tables etc for GE Wind Energy Web Application.

Create and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.

Design the conceptual data model, logical data model and the physical design of the database of a project

Used python to configure web application API and checked it in on Azure DevOps and hosted it on Azure web services

Identify and troubleshooting Blocking and deadlock issues.

Prepare knowledge base and deployment Documents.

Analysed and designed changes in business logic using SSAS

Responsible for Performance Tuning using Profiler and DMVs.

Provided disaster recovery procedures and policies for backup and recovery of Databases using Power BI generate the report.

Created SSIS packages to populate data from various data sources

Transformation of data from one server to other servers using tools like bulk copy program (BCP), Export/Import Utility.

COMCAST (Contractor) October 2017-December 2021

SQL Server Database Administrator

Installed and configured software for sql server on Standard and Enterprise editions.

Created new store procedures, triggers, common table expression and maintain existing objects to reflect changes in the business rules

Identify performance bottleneck analysis using T-SQL script, dynamic management views, query execution plans, extended events, and third-party tools

Worked in a cross functional team that was responsible for the installation and configuration of Always On Avaliable Group as a HA and DR solution for cluster setting.

Created and maintained databases, users, logins, tables, indexes, stored procedures, roles, database access

Strategized and implemented comprehensive Backup and disaster recovery strategies

Database migration from on premise into Azure elastic pool

Performance Monitoring/Tuning using Activity Monitor, sp_who2, Redgate, error logs, profiler

Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases

Created detailed documentation during project planning/ execution and project maintenance phases

Enforce security policy to secure databases, using passwords, dynamic data masking, always encrypted

Perform monthly drills on stored backups to be sure they could readily be restored in case of a disaster

Create and configure Virtual Network between virtual machines between geographic Azure regions

Use Transparent Data Encryption (TDE) to secure databases at rest. Implement dynamic data masking

Perform Consistency checks by running DBCC commands

Identify and troubleshooting Blocking and deadlock issues

Prepare knowledge base and deployment Documents

Responsible for Performance Tuning using Profiler and DMVs

Tune and Optimize SQL Queries using Execution Plan and SQL Profiler

Managing disaster recovery procedures and policies for backup and recovery of Databases

CACI (Contractor)

SQL Server Database Administrator

03/2014 – 09/2017

Installed and configured SQL server 2016 database in standalone/cluster environment with availability groups.

Re-organized databases and sized database objects to meet standards and improve performance

Managed indexes to improve performance, index tales for optimal data retrieval and update statistics

Interacted with clients, application team managers to design, implement and support solutions for client needs.

Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures.

Created and maintained databases, users, logins, tables, indexes, stored procedures, assign roles, assign databases access permissions.

Performed detail documentation during project planning, project execution and project maintenance phases.

Performed failed job analysis, develop, and implement preventive measures

Performed in-place and side-by-side migration in SQL Server Standalone settings.

Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of database

Participated in the design and development of ETL job using SSIS for data migration between different maintenance systems

Developed metrics and measures for resource utilization and provided capacity planning and management

Managed Database Security by creating Users, Roles and assigning proper permissions according to the business requirements

Implemented business logic using Triggers, Indexes, Views and Stored procedures

VPS MEDIA CENTER

System Administrator

01/2001 – 02/2014

Installed windows operating system on all the company computers

Used excel to design financial reports and payroll for the company

Serviced all printers, scanners, and printers

Updated and upgraded all company’s computers

Designed company logos and graphics

Edited company’s videos, pictures, promo videos and portals

Worked closely with business owner to provide optimum business solutions

Performed other duties and assist in other departments as needed

Analyzed platform for compliance with best practices

Coordinated with the company to fully understand customer expectations

Trained employees on windows operating system

TECHNICAL PROFICIENCIES

Databases

SQL Server Standard and Enterprise, Azure Cloud

Database Tools

Redgate, SQL Profiler, Activity monitor, SSMS, Database Migration Assistant, Configuration Manager, Jira, T_SQL, Power Shell, SSMS, DMA, SSAS, SSRS, SSIS, C#, VB.net, ASP.net, Net Framework, DevOps Microsoft office 365, Microsoft Visual Studio, and Team Foundation, Python, Powe-BI

Operating Systems

MS Windows servers (2008-2019)

PROFESSIONAL CERTIFICATION AND LICENCES

Administering Microsoft SQL Server 2012/2014

Querying Microsoft SQL Server 2012/2014

Implementing data warehouse with Microsoft SQL Server 2012/2014

Security+ CE.

Education

Bachelor’s degree in computer science University of Yaoundé 1 Cameroon

Professional Affiliations:

Database administrators stack exchange

Vital trainings (SQL Server Database institute)

Contact this candidate