Database Administrator and Analyst
Resume:
Alex Atobrah
DACULA, GA 404-***-****
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