Systems Engineer Sql Server

Akeem Prince

Olass

**** ************ **. *******

GA

PH: 571-***-**** · Email:

*************@*****.***

Linkedin : Akeem Olass

EXPERIENCE

General Motors, GA — Systems Engineer

Mar 2021 - PRESENT

• Developed, maintained and optimized software to move data between different database management systems including the cloud using Apache Spark, DACPACS, like Ora2Pg, SSMA, Ispire

• Improved user experience by taking user feedback and reiterating features until users were satisfied

• Developed and used PKCE OAuth 2.0 for our react application to authenticate users

• Optimized and refactored our code base to improve migration times and make our software extensible and maintainable.

• Adapted and wrote code for business continuity for Hana Databases which helped teams remain compliant and available in case of disasters.

• Wrote various PowerShell scripts to generate reports that helped the company keep track of strategic goals and reduce costs using tools like Azure Resource Graph, Influx library, Azure CLI and Azure monitoring and other tools to generate reports that helped the company keep track of strategic goals and reduce costs.

• Upgraded Sql Server and PostgreSql databases.

• Optimize SQL queries for application teams

• Backup and restores.

• Troubleshoot and resolve archive and log related issues on PostgreSQL

• Installed and created databases for app teams

• Created logins for app teams and queried databases

• Created different reports for database backups and other metrics

• Worked in an agile environment and used TFS,ADO pipelines, github SKILLS

Apache Spark, Web

development,

Database and Query

Optimization, Java,

React, Python, SQL,

SQL Server,

Postgres, C, Go,

Powershell,JavaScri

pt

Excellent Customer

Service Skills,

Detailed Oriented,

Problem Solver, Basic

Web

LANGUAGES

Fluent in English, Twi, read

French

StemExcel Tutor,VA — Tutor

Jan 2020-March 2020

•Teaching kids from Grade 1-6 programming concepts such as conditionals, loops and functions.

•One on one and hands-on coding skills teaching with Scratch2. Career and Transfer Center Work Study at Northern

Virginia Community College, VA — Office

Assistant/Receptionist

June 2017-December 2018

•Provided a friendly and welcoming atmosphere at the Center for students, faculty, staff, administrators, and visitors.

•Succinctly disseminated basic information about services to visitors and students in person and on phone calls.

•Organized incoming employers and University recruiters on-site. EDUCATION

George Mason University, VA — Bsc,3.45

Jan 2019-December 2020

Data Structures

Formal Methods and Models

Statistics and Probability

Calculus, I, II, III

Operating Systems

Intro to Artificial Intelligences

Analysis of Algorithms

Computer Networking

Computer Science Northern Virginia Community College, VA — Asc, 3.67

Jan 2017 - Dec 2018

PROJECTS

● Developed a 100-node network using Dijkstra’s algorithm and a hash table in Java.

I created an adjacency list to represent the network of nodes and edges.

I used the same structure to implement the hash table

My hash table supported the routing tables for each node

Dijkstra’s algorithm used the costs of edges between nodes to construct the routing tables so that messages can to a destination node would take the quickest path. Created a shell using fork and wait in the C programing language.

I created a command line interface the executed

commands such as ls, cat, sleep, pwd and file redirection commands.

These commands were typed in by a user and my parser passed the inputs to determine the type of command and whether it’s a foreground and background process

I used the fork command to create a child process that could these commands independently of the parent

I used the wait command to implement foreground

processes and background process

I also used signals to determine the state of my processes and printed out messages related to the states.

● Developed a UDP socket to a DNS server in python.

I parsed a domain name from user input with the help of my partner to send a DNS query.

After parsing, I formatted the input into the DNS format so that the server can understand and sent the message through the socket after encoding.

If the server sent back a message, we extracted the information from it after receiving it in our socket and printed it out into human readable format

We used wireshark for debugging.

● Developed a search algorithm for packman to find food optimally using AIpython.

To help packman search for a single food item, all food items and food items the four corners I used a variety of search algorithms.

I used a* search which used both a heuristic and the cost to a food item to solve the all food problem and corners problem. My heuristic of using the Manhattan distance aided in the search.

I used an uninformed search such as the breadth first search to find a single food item.

Contact this candidate