Olusegun Oshinkoya

Phoenix, AZ

Summary

Mobile: 313-***-****

adub52@r.postjobfree.com

9+ years of IT experience in Database System Analysis, Design, Implementation and Administration of MS SQL Server 2017/2016/2014/2012 in Production, Test, Development and Replication & Cluster Server Environments.

As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.

Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2017/2016/2012 on Clustered and Standby Environments.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Views, Cursors and Triggers.

Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

Master in performing administrative tasks: database files management, backup/restore, Security Management, Database Mirroring, Data Integration and Synchronization.

Hands on experience with T-SQL (DDL, DML, DCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.

Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive).

Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.

Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages. Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

Experience in designing/generating/using/deploying Visual Studio Business Intelligence Reports, SQL Server Reporting Services (SSRS), and Crystal Reports.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Report using SSRS to develop Drill-down, Drill-through and Cascading reports.

Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.

Good working knowledge Tableau Desktop (9.3x). Experience with creating workbooks and dashboards by using custom queries and multiple tables from multiple sources. Experienced with creating Labels, Annotations, data blending, data extraction, publishing and reusing data sources, applying use as filter actions, quick filtering, hierarchies, conditional formatting, groups the rows and Title and Caption.

Filled in as a Team Lead for 3 months on my project in Ohio when the team Lead quitted

Technical Skills

Databases and Tools: SQL SERVER 2017/2016/2014/2012.

Database Tools: Team Foundation Server (TFS), Clustering, HADR, Replication, Clustering, Always On

Languages: TSQL

Methodologies: Agile, Test driven environment, AZURE DevOps

Reporting Tools: SSRS, Tableau, Power BI

ETL Tools: SSIS

MS Tools: POWER Query, PowerPivot, MS Office, MS Outlook

Certifications

Azure Fundamentals

Azure Data Fundamentals

Professional Experience

Qdoba, San Diego, CA

TekSystems, Tempe, AZ

June 2022 Till Date

Snr. MS Sql Developer/DBA/Power BI/Azure DevOps

Responsibilities:

I Perform day to day database system administration, including daily checklists, backup verification, log review, security maintenance, performance tuning (analysis, indexing, updating statistics, etc.).

I Create, update, and maintain database objects in coordination with development team.

I Create, review, and maintain code in our database systems to optimize, standardize and/or prepare for upgrades.

I Upgrade, configure and maintain server and database monitoring software to baseline system performance and proactively identify (and remedy) potential issues. Resource monitoring and capacity planning.

I Review, test, update, and document detailed disaster recovery/business continuity plans for key production SQL Servers (database mirroring, log shipping, replication, clustering) in a VM/SAN environment.

Experience with JSON functions and parsing within SQL Server.

I Perform database backup and recovery as required, including periodic testing.

Reviews, tests, and recommends and installs upgrades of database software, including patches and major releases.

Experienced with SQL CLR functions

I do Data analysis and other reporting tasks which involves data investigation and cleansing.

Accenture, Redmond WA

Jan 2022 – June 2022

Snr. MS Sql Developer/DBA/Power BI/Azure DevOps

Responsibilities:

Build new dashboards and modify existing dashboards

Writing DAX to create measures for reports and dashboards

Using Power queries for creating reports and dashboards

Using the Vertipaq analyzer and DAX Studio for data schema and extraction from existing reports and dashboards

Creating security groups and deploying features to the workspace

Building new objects, modifying existing ones based on requirements from stakeholders

Making use of the Azure DevOps to track the features that is been worked on

Reviewing and Analyzing the BRD to understand the requirements

Documenting the development process for creating the reports or dashboards

Having client facing demos or the report and dashboards that was built

Deploying the reports to the workspace on different environment (DEV, PPE, PRD)

CVS Pharmacy Scottsdale, AZ

Genzeon Phoenix AZ, 85050.

August 2020 – May 2022

Snr. MS Sql Developer/DBA

Responsibilities:

Wrote stored procedures, temporary tables, views, indexes, and triggers when required.

Made use of DDL and DML statements, RDBMSs, data dictionaries and normal forms.

Estimated, scheduled and track ETL projects throughout SDLC.

Used RDBMS concepts, data models, Star/Snow Flake Schemas.

Did Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from multiple sources e.g. SQL Server and Flat File sources and load into various Business Entities.

Made use of data warehousing concepts (OLTP and OLAP).

Created reports using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Did some work on resolving complex issues and Error Handling in SSIS

I scheduled and deployed reports on report manger.

Managed and developed User reports and management reports using MS SQL Server Reporting Services (SSRS).

I developed Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services(SSRS) in Business intelligence development studio (BIDS).

Enhanced and deployed the SSIS Packages from development server to production server

Daicel Safety Systems America Inc. Mesa, AZ

Oct 2016 – June 2020

MS Sql Developer/DBA

Responsibilities:

Creating user accounts to access the different Servers/databases

Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2012 from different environments for Quality Reports.

Created various reports using both Power BI and SSRS

Created reports using Tableau technology

Managing version control of Sql scripts using the Team Foundation Server(TFS)

Creating database objects utilizing T-Sql language e.g. Tables, Views, Stored procedures, functions.

Built redundancies for our server’s purposes of High Availability and disaster Recovery(HADR).

Create logical and physical database design to support existing and new applications

Prepare and update current database structure and configuration for high performance through analysis and optimization

Develop Web application using .Net programming language

Troubleshoot and resolve database issues

Proficient with Always On Availability Groups (AAG) using the Active/Passive process to guarantee that our servers are always available

Create maintenance jobs for performance optimization of the databases

Develop and maintain standard operating policies and procedures

Address development escalation that requires data manipulation on high volume production servers and project management and cost analysis

Avnet Chandler, AZ

May 2016 – October 2016

Sql Developer/Data Analyst/DBA

Responsibilities:

Involved in gathering requirements, worked closely with business users and implemented logical and physical modeling

Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2012 from different environments for Quality Reports

Created T-SQL Queries, Dynamic Queries, Sub-Queries and Power Query

Created the SSIS /DTS packages and scheduled them using Sql Server agent.

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Utilized event handling effectively to generate audits and logs for the generated SSIS packages.

Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.

Used C# in Script task of SSIS 2010 Packages.

Created Reports Using Tableau 8.0

Deployed SSIS Packages from Dev/Staging/Production using Package Configurations

Scheduling & Maintaining ETL packages in terms of data validation and consistency.

Deployed many packages on different servers using SSIS package Configurations.

Involved in Backup and Restoring the Databases.

Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, lookup, Derived Column task and Script Task in SSIS Designer

JDA Software, Scottsdale, AZ

January 2016 – May 2016

Sql Developer

Responsibilities:

Created T-SQL Queries, Dynamic Queries, Sub-Queries and Power Query

Created Complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques.

Created report models using Pivot tables, Power Pivots tables and Power Queries.

Worked on migrating DTS packages and Metadata Management

SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor

Created SSRS reports to develop Drill-down, Drill-through and cascading reports.

Did Performance tuning on SQL Server 2008R2 and 2012

Go Daddy, Scottsdale, AZ

July 2015 to Dec 2015

Sql Developer

Responsibilities:

Created XML scripts that pulled data from CSV file into SQL server, Created Stored procedures to meet business rules on the data pulled into the database, Also Created PowerShell Scripts that call both the Application (VDI) and the SQL scripts to populate the Destination table. All was ran on a Task Scheduler

Wrote T-SQL Queries, Dynamic Queries, Sub-Queries and complex joins for generating complex Stored Procedures, User-Defined Functions, Views and Cursors.

Modified Stored Procedures, Triggers, Tables, and Views. Re wrote processes to get data from one server and database to another database.

Experience in using SSIS Tools like Import and Export wizard, Package Installation, and SSIS Package designer

Transformed data from one server to another server using Bulk Copy Program(BCP), and SQL Server Integration Service (SSIS)2008/2012

Highly efficient with writing parameterized queries, drill through reports and SQL Server Reports in SSRS 2008/2008R2

Created Change Order to Deploy Scripts from one environment to the other, usually from Development to Test and to Production

Highly Proficient and efficient with the Visual Studio 2015 Team Foundation Sever Tool (TFS)

Highly efficient with the Report Manager Tool to generate reports for the Accounting team and across all environments

Created Spreadsheet reports using Power query tool, pulling data from different data sources for the senior level management.

Created SQL Agent Jobs to run at a specific time to carryout different purposes e.g. populating a table for report purposes, generate reports for the management etc.

Environment: MS SQL Server 2008 R2/2012, Visual Studio 2013/2015, Power Query Tool, Team Foundation Server (TFS), SQL Agent, Power Shell, SQL Profiler.

Persistent Systems, Dublin, OH

December 2014 – June 2015

Sql Developer

Responsibilities:

Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.

Creating Database objects – Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.

Created New Databases, backed up and Restored previously created databases within and outside a server.

Highly Proficient and efficient with the Team Foundation Sever Tool (TFS), Element Tool(ET) and code delivery process to client

Modified Stored Procedures, Triggers, Tables, Views and also making use of Merge Statements.

Deploying new Database objects in production environment.

Bug fixing, script optimization and process enhancements that where database related

Coordinating post-implementation events such as Deployments, testing and validation of Scripts

Worked closely with the Application team to understand business requirement and develop Database objects or Procedures to meet the new requirements

American Express (GBT), Phoenix, AZ

July 2014 – December 2014

SQL Developer

Responsibilities:

Worked as a lead database and SQL developer, did extensive work on creating partitions on tables, creating relational databases.

Migrated DTS packages from 2000 to 2005 and to 2008 SQL Server and also modified Stored Procedures to comply with the current versions of SQL Server.

Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.

Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.

Worked closely with both the offshore Application and Database teams to regularly monitor system for bottlenecks and implement appropriate solutions.

Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.

Worked extensively with the Business Analyst using the Rally to create user stories based on the business requirements.

Created and Modified Stored Procedures, Triggers, Tables, Views and also making use of Merge Statements instead of Cursors in T-SQL

Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Integration / Reporting Services 2012 OLTP

FI$CAL–State of California, Sacramento, CA

January 2014 – July 2014

MS SQL Server T-SQL/SSIS Developer

Responsibilities:

Worked as a lead developer and also worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into Sql server.

Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs

Creating Database objects – Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement

Developed datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports

Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications

Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility

Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Created Complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques

Generated parameterized reports, sub reports, tabular reports using SSRS 2008.

Created SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements.

Designed and created Report templates, bar graphs and pie charts based on the financial data.

Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.

Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.

Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.

Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Integration / Reporting Services 2012 OLTP.

Countrywide Home Loans, NY

January 2013 – December 2013

Jnr SQL Developer

Responsibilities:

Involved with Installation, Upgrade and Troubleshooting of MS SQL Server 2005.

Created Complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques.

Designed, Developed and maintained Relational databases.

Worked in creating Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Running Index tuning wizard and rebuilding indexes for faster query response.

Responsible for SSIS activities to move data from text files to SQL Server.

Scheduled SSIS Packages daily and weekly Basis.

Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.

Ensured developers coordinated their efforts in managing and maintaining different application databases.

Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.

Extensively involved with the development team in carrying out the Unit testing of the applications and tuning of complex procedures.

Environment: Windows 2000 Advanced Server, SQL Server 2000, 2005, 2008, MS Outlook, FTP, TSQL.

Education

Bachelors of Science University of Lagos, Nigeria 2008, Mathematics and Statistics

Contact this candidate