Alex Atobrah

DACULA, GA 404-***-****

adv0n0@r.postjobfree.com LinkedIn

AREAS OF EXPERTISE

8+ years SQL Database Administrator (DBA) with extensive experience in designing, coding, testing, and supporting next-generation database solutions in MS SQL SERVER environments. Proficient in an assortment of applications, including MS SQL 2012,2014,2016, 2019, and MS POWER BI.

KNOWLEDGE AND SKILLS

• SQL Server 2012,2014,2016,2019.

• Install And Upgrade.

• High Availability and Disaster Recovery Solutions.

• Performance Tuning & Monitoring.

• Database Security & Integrity.

• Job Scheduling and Automation.

• Store Procedures & Indexing.

• Backup And Restore Solutions.

• Importing And Exporting Using ETL and SSIS

• Monitoring And Troubleshooting.

• Expert in SSRA and SSAS

• Expert in migrating from On-perm to cloud.

• Programming Skills: R, Stats, Excel, SQL, SPSS, Python(Pandas)

• Visualization Tools: Power BI, Tableau, Excel

• Databases: MySQL, Relational Databases

• Tools/Libraries: Ggplot2, dplyr

• Core Competence &Other Skills: Report writing, Effective presentation, Data cleaning, MS Office, PowerPoint, Pages, Data-driven decision making. EDUCATION AND CERTIFICATIONS

GEORGIA STATE UNIVERSITY

BACHELOR OF ACTUARIAL SCIENCE

CERTIFICATIONS

• Google Data Analytics (Coursera)

• Prepare, Clean, Transform, and Load Data using Power BI (Coursera)

• The Complete Tableau Bootcamp for Data Visualization (Udemy)

• Data Analysis with R Programming (Coursera)

• Microsoft Access (Udemy)

• Introduction to Data Analysis using Microsoft Excel (Coursera)

• Microsoft Power BI Desktop for Business Intelligence (Udemy)

• SQL(Coursera)

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator (MSSQL DBA)

WIPRO LIMITED MARCH 2018– DEC 2022

• Performing Technical analysis and troubleshooting on complex database problems.

• Working with developers, support, and QA team to maintain all database environment.

• Database administration activities including installation, configuration, capacity planning and space management.

• Using Data Migration Assistant to migrate data to Azure cloud.

• Azure (creating resources group, SQL Database, Geo-Replication, creating server names, setting server firewall, monitor your applications and infrastructure, Enable Security Center standard tier on subscriptions, Azure cosmos DB, Function app, etc).

• Experienced in designing, configuring and deploying solutions on Windows Azure for applications (Including Compute, Web, Storage, IaaS, Service Bus, Logic Apps and ARM templates).

• Upgrading database (in place and side by side).

• Setting up and monitoring Replication (transactional, snapshot, and merge).

• Scheduling Maintenance jobs and backups.

• Troubleshooting production issues.

• Configuring database mirroring (synchronous and asynchronous).

• Importing data from various data sources to SQL server.

• Monitoring server and database activities using SQL native tools.

• ETL (Use to transform flat files like excel, notepad to SQL server platform).

• TSQL (Store procedures, Triggers, joints, select statement).

• Analyzing and tuning slow running queries.

• Developing backup strategies and recovery solutions.

• Understanding of different database models and styles (OLTP, OLAP).

• Test and configure database backups to meet the business’s Recovery Point Objectives

(RPO) and Recovery Time Objectives (RTO).

• Knowledge of High Availability and Disaster Recovery (DR) options for SQL Server.

• Always on (configuration of Asynchronous-commit mode and Synchronous-commit mode failover to other nodes).

• Experienced in Azure IaaS - Virtual machines, VM Scale Sets, Load Balancer, Traffic Manager, Virtual Networks, SQL, Resource Groups and Cloud Services.

• Experienced in Azure Backup, Azure Policies, Azure Key Vault, Salt Stack and Tagging.

• Experienced in ARM templates while building Servers (Windows, SQL, VM Scale Sets) backend and frontend needed for application migration on Azure Cloud.

• Experienced in Creation of Definitions to enforce Azure Policies across subscription.

• Experience in designing architecture solutions involving DNS, AAD, firewalls, load balancers, Traffic Manager, gateway devices, VM's and Storage.

• Good knowledge in implementing IAAS and PAAS solutions.

• Experience is setting up hybrid cloud environments, backup and disaster recovery solutions and migrating On-prem servers into cloud.

• Experienced in PowerShell scripting and azure CLI.

• Migrating SSIS packages from SQL Server 2008 R2 to SSIS 2012.

• Developing reports using SQL server reporting services (SSRS).

• SSRS/SSIS (For reporting and migrating flat files to SQL server platform). JUNIOR SQL DBA JAN 2016- FEB 2018

Enterprise Life Insurance

• Install and configure SQL server 2012.

• Help with other database projects and set goals to increase efficiency.

• Implement database maintenance plans.

• Query store, Import/Export ETL, SQL, SSMS.

• Achieve maximum performance gain for overall database performance.

• Proactively monitor and tune slow running queries.

• Upgrade SQL server databases from SQL Server 2012 to SQL Server 2016.

• Document processes and procedures for future reverences.

• Interact with developers, application team and project managers. Data Analyst

Ghana Commercial Bank FEB 2014- SEP 2015

• Conducted qualitative and quantitative data analysis, finding key themes, trends, and opportunities from complex data sources.

• Experience in designing interactive dashboards, reports, performing analysis, and visualizations using Tableau, and PowerBI.

• Utilize R for data visualization and SPSS statistical software to track and analyze data.

• Optimized data collection procedures and generated weekly, monthly, and quarterly reports to stakeholders on streaming and trends.

• Developed and Analyzed reports for review by management, which helped to secure new partnerships with banks.

• Used analysis and visualization tools such as Excel and Tableau to analyze data and draw accurate and reliable conclusions to provide insights to financial team and upper management.

• Create Tableau dashboards for the company to help decide areas of improvement.

Contact this candidate