Ferdinand - MS SQL Server Developer

Ferdinand

MS SQL Server Developer

Nigeria | Africa/Lagos (USD)

$35/hr
Full-time : 30+ hrs/week
0, Followers

ABOUT ME

Hello,

I have 5+ years of experience in the IT industry as a SQL Server OLTP database and OLAP data warehouse Developer 2000/2005/2008/2012/2014/2016/2017 and Microsoft Azure cloud database with extensive experience in designing, developing, implementing and administering database and data warehouse systems using MSSQL Server 2005/2008/2012/2014/2016/2017 and its stack: SSIS, SSRS, SSAS, TSQL and SSMS/Visual Studio.
I have strong practical and theoretical understanding of RDBMS and Multi-Dimensional Data Warehouses with experiences in advanced database programming with T-SQL Stored procedures, functions, UDTs, Triggers, referential integrity Constraints (Primary Key, Foreign Key, and Unique key), Indexes and Batch Scripts using various Data Definition Language (DDL) and Data Manipulation Language (DML) commands.
In my project at ExactBid I designed, developed and maintained replication for over one hundred and fifty databases across multiple servers.
I developed SSIS ETL project to load data to OLAP data warehouse. This includes using data flow transformation like conditional split to identify and capture changed data.
I am very exceptional in tuning databases and database objects like stored procedures and functions. I have been able to reduce the execution time of many SPs from 8minutes to under a second by for example converting row-by-row based TSQL query execution to set based query execution.
I am an Expert in creating Business Intelligence reports, defining queries for generating drill- down reports, parameterized reports and in designing report layout using SQL Server Reporting Services (SSRS) 2005/2008/2012/2014/2016. I not only design and create reports but also optimize them for performance and schedule their delivery to subscribed recipients using the report manager.
In my various projects, I created parameterized reports and sub reports using global variables, expressions, and functions. Depending on the business requirements, I have added interactive sorting, row and column alternating colors and running totals to my reports. I also created and used both shared data sources and embedded data sources using SSRS 2005/2008/2012/2014/2016.

I have extensive experience in creating, deploying, optimizing and maintaining SSIS packages and SQL Server Agent jobs for MS SQL Server databases. In my previous project at Rodan and Fields in San Francisco, I designed and created a robust ETL framework for the migration and near-real time integration of the company's SQL Server ODS database and Salesforce CRM using SSIS packages. This project involved extensive data cleansing such as email validation. I also wrote SOQL queries in Salesforce workbench for unit testing of migrated and integrated records. Also during this SQL Server-to-Salesforce migration/integration, I wrote a T-SQL script to convert current and historical date-time records to GMT while accounting for daylight saving times. This is because Salesforce stores date-time records in GMT.
I have used both SSIS 2012’s project and package deployment models to deploy my projects to different environments as requested by business users. I automated entire deployment process by using the Isdeploymentwizard.exe executable process in SSIS process task.
In addition to my Microsoft SQL Server skills, I am experienced with C# and Java. I have strong understanding of OOP (object-oriented programming) and have used C# in both SSIS script component and script task. For example in my recent project, I used C# to format excel report documents in SSIS package by adding column autofit, shifting cells, highlighting column headers and adding borders and colors as part of business requirements.
I have extensive experience working with Atlassian’s JIRA ticketing system, GIT source control system, Windows remote desktop service and Red Gate SQL Developer. I have also worked with remote teams from different countries.
During my project at CougarTech, I created and configured Azure SQL database. I also imported existing SQL Server database into Azure cloud after taking a backup and then wrote and executed queries on the Azure SQL database to test the imported database.
I am an expert in producing and consuming JSON objects using both Java with Google's Gson library and SQL Server 2017 JSON object storage and manipulation support. In addition to JSON, I have produced and consumed XML documents in Java and SQL Server using Xtream from thoughtworks.com and TSQL's XML datatype methods respectively. I have also consumed REST API services as part of an ETL project.
I am also experienced in cloud services like AWS and DigitalOcean. I currently maintain a DigitalOcean VPS server where I installed and administer SQL Server 2017 database.

SKILLS