Resume

Sql Server Ms

Location:

Bessemer, AL

Salary:

130k

Posted:

January 08, 2024

Contact this candidate

Resume:

Stephen A Muliokela

**** ******** ********* **********, ** 35211 410-***-**** ad2kb4@r.postjobfree.com

Professional Summary:

15+ years of IT experience as a MS SQL Server Database Administrator 2019/2017/2016/2014/2012/2008/2005/2000.

I am also a regular speaker at events like SQL Saturday, SQL Community, SQL meetings at Microsoft conferences.

Strong knowledge working with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

Worked in collaborative team environment with other developers, business analysts, and a project management team.

Extensive experience in MS SQL Server 2019/2017/2016/2014/2012/2008/2005/2000, Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.

Strong experience working with BCP, Bulk Insert, OPENROWSET(BULK),SSIS packages, creating jobs and linked servers for MS SQL Server/ Sybase databases, PowerShell.

Experience in SQL Azure and AWS-using containers, setting up provisional VMs

Strong experience in

oOptimizing and troubleshooting SQL Server, Designing SQL Server Security, Event notification

oFailover Clustering, Database Mirroring, Log Shipping, Replication, AlwaysOn and Availability, capacity planning

oTSQL, DAX, MDX, Data Encryption, Data Compression, SQL Azure, Parallel Data Warehouse

oLinked Servers, Disaster Recovery Planning, Data Quality Services, Master Data Services, Change Data Capture

oService Broker; Activation, Contracts, Conversation Troubleshooting and Designing SQL Server Endpoints

oDatabase Backup and Restore Strategies

oPolicy Based Management, SQL Server Auditing, Predictive Analysis with Data Mining Models, Implementing Slowly Changing Dimension

oSQL Server Integration services, SQL Server Reporting services, SQL Server Analysis Service

oSix Sigma process improvement methodology

Experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads and various heterogeneous data sources.

Expert in using MDX, DMX queries and using SQL Server data mining algorithms e.g. Association algorithm, Clustering algorithm, Decision trees, Linear regression logistics, Naïve Bayes, Neural network, Sequence clustering, Time series and plugin algorithms.

Expert in creating and deploying SQL Server Reporting Services (SSRS) reports on the portal for user accessibility.

Highly experienced in writing advanced parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SQL Server Reporting Services (SSRS).

Expertise in web designing using HTML, CSS and ASP.Net to display reports on the server.

Stronger experience in logical and physical database design and development, normalization and data modeling and SQL server Enterprise Manager/SQL Server Management Studio.

Expert in using tools like MS SQL Profiler, Index tuning wizard, Windows performance for monitoring and tuning SQL server performance.

Extensive experience in using T-SQL for developing complex stored procedures, triggers, tables, views, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.

Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.

Hands on experience with IDEs like Visual Studio.Net

Used SQL Server command-Line Utilities to interact with SQL Server . Utilities such as:

osqlcmd; using scripting variables with sqlcmd, the dta command-line utility. In addition- the tablediff command-line utility, the bcp command-line utility, the sqldiag command-Line utility, the sqlservr command-line utility, the SqlLocalDB command-line utility.

Skills Set:

Programming

Languages

C++, Visual Basic 6.0, Visual Studio 2008/2012/2018, Cobol, T-SQL, MDX, DMX

Databases

MS SQL Server 2019/2017/2016/2014/2012/2008/2005/2000., MS Access, Oracle, Sybase, Excel.

Web Technologies

HTML, DHTML, CSS, XML, XLMA, ASP.Net

Office

Word, PowerPoint, Excel, Outlook, Project, Notepad

Operating

Systems

Windows 2012/2016/2019 server, Windows 2008 server Windows 2003 server, Windows XP Home/Professional, Windows Vista, Windows 7 /8

BI Skills

Expert SQL Server Reporting Services(SSRS), SQL Server Integration Services(ETL-SSIS), SQL Analysis Services Skills

Third-Party Tools

MS Visio 2007/2003/2008/2010/2012/2018

Certification

Microsoft Certified Solutions Expert-Data Management and Analytics

-SQL Server

Microsoft certified solution Association

-SQL Server

Microsoft Certified Database Administrator on

-SQL Server

Microsoft Certified IT Professional on

-SQL Server

Microsoft Certified Technology Specialist on

-SQL Server

Management and Strategy Institute

-Master Six Sigma Black Belt

Management and Strategy Institute

-Six Sigma Black Belt

Microsoft Devops Badge

Microsoft Certified: Azure Fundamentals

Educational Qualification:

Masters in Applied Information Technology Towson State University, Towson, Maryland

Concentration = Database Management System

GPA =3.90

Bachelors in Computer Science University of Maryland Eastern Shore, Princess Anne, Maryland.

Concentration = Business

From: 09/2019 to Present

Company Profile: HireRight

Senior Database Administrator

Duties and Responsibilities:

Perform the duties of a Senior Database Administration team and SQL Expert. I am also a part of CAB (Change Advisory board) of the company. I work very closely with Project Management team to identify resources needed and scheduling needed.

I also manage SQL code deployments and moves as well as provide 24x7 support for production databases as well as provide assistance to developers for complex queries tuning efforts as well as schema refinement.

Perform resource planning for all our DBA resources as well as time allocation for projects.

Perform data transfer using BCP, Bulk Insert, OPENROWSET(BULK),SSIS packages,

Perform migration efforts as well as setting up disaster and high availability efforts for our production systems.

Performed duties of a Senior Database in the following areas:

oOptimizing and troubleshooting SQL Server, Designing SQL Server Security, Event notification

oHigh availability

Failover Clustering: configured Failover clustering. Extending WFSC with NLB.

Replication-Snapshot, Peer-to-peer, merge and transaction replication. Created Replication models-central publisher, central publisher with, remote distributor, publishing subscriber, multiple publishers – multiple subscriber, updating subscriber

AlwaysOn,Log Shipping, and Availability, capacity planning

oTSQL, DAX, MDX, Data Encryption, Data Compression, SQL Azure, Parallel Data Warehouse

oLinked Servers, Disaster Recovery Planning, Data Quality Services, Master Data Services, Change Data Capture

oService Broker; Activation, Contracts, Conversation Troubleshooting and Designing SQL Server Endpoints

oDatabase Backup and Restore Strategies

I am responsible for optimizing and troubleshooting SQL Server, designing SQL Server Security, Event notification, Failover Clustering, Database Mirroring, Log Shipping, Replication, AlwaysOn and Availability

I am responsible for creating Data Encryption, Data Compression, Resource Governor, Parallel Data Warehouse, Linked Servers, Disaster Recovery Planning

I lead efforts to implement Data Quality Services, Change Data Capture, Service Broker, troubleshooting and designing SQL Server Endpoints, Database Backup and Restore Strategies.

I introduced Policy Based Management, SQL Server Auditing, predictive Analysis with Data Mining Models/algorithms, Implementing Slowly Changing Dimension

I also lead projects efforts for SQL Server Integration services, Server Reporting services, SQL Server Analysis Service

Perform scheduled maintenance and support release deployment after hours.

I am also responsible for introducing/ and reviewing all new technology that will affect our database landscape.

Lead efforts of planning, architecting and developing databases, based on business requirements, with key executives, architects and users.

I am also a part of a team that evaluate who gets hired at a management level in the IT department, including those that get hired on the Database, ETL and Reporting team.

I am also responsible for checking Daily SQL Server Job status, performing database integrity checks, resolving production issues related to databases. Planning the database migration process, creating indexes, implementing views, backing up and setting up backup schedules, working with SQL Server Agent Jobs, creating database Snapshots. Implementing database layered security. Resolving Service Oriented Architecture problems for SQL Server Service broker and create new strategies for auditing via Service Broker.

I am responsible for troubleshooting SQL Server issues using different tools. I monitor sections of the system e.g. disk usage-e.g. high disk queue length, monitoring memory usage e.g. page life expectance and other items.

Manage users, database roles and applications roles where applicable. Configured database permissions, managed securables, assigned permissions on objects. I am also responsible for troubleshooting all SQL Server security issues e.g. authentication, certificates, keys and endpoints etc.

Responsible for reviewing hundreds upon hundreds of lines of SQL code and tuning the code - identifying options for improving performances. Implemented table level partitioning. Used SQL profiler, Database Tuning Advisor, Dynamic management view, Query Execution plan. This increased the performance of the database by 96 percent. I used metric counters/measures and SQL Server database metrics to implement and identify best IT database strategies.

I am also responsible for approving all database level access requests and providing oversight over all production level deployments.

From: 02/2017 to 09/2019

Company Profile: American Credit Acceptance

Senior Database Administrator

Duties and Responsibilities:

Perform the duties of a Manager of the Database Administration team, Manager of the Reporting team and Manager of valueLabs Offshore team. I am also a part of PCB (Production change board) of the company. I work very closely with Project Management team to identify resources needed and scheduling needed.

I am also a part of a team that evaluate who gets hired at a management level in the IT department, including those that get hired on the Database, ETL and Reporting team.

Responsible for troubleshooting SQL Server issues using different tools. I monitor sections of the system e.g. disk usage-e.g. high disk queue length, monitoring memory usage e.g. page life expectance and other items.

Responsible for reviewing code and making improvements.

I am also responsible for approving all database level access requests and providing oversight over all production level deployments.

From: 05/2012 to 02/2017

Company Profile: Imagine Software & Technology Partners

Senior Database Administrator

Duties and Responsibilities:

Perform duties of a Senior Database Administrator/ Database Trainer; Checking Daily SQL Server Job status, performing database integrity checks, resolving production issues related to databases. Planning the database migration process, creating indexes, implementing views, backing up and setting up backup schedules, working with SQL Server Agent Jobs, creating database Snapshots. Implementing database layered security. Resolving Service Oriented Architecture problems for SQL Server Service broker and create new strategies for auditing via Service Broker.

Manage 70+ clients each of whom can have an average of 200+ databases spread across different servers.

omaintained and created indexes.

oPerformed query tuning and monitored index fragmentation.

Introduced/ Led Six sigma efforts to improve the database platform as well as train other junior DBAs on the implementations of Six Sigma.

Refine the requirements to best represent the customer’s wishes. Review and translate high level requirements into technical solutions. Help users understand their desired requirements. Increase customer confidence in the-to-be system.

Create Database based SSIS packages to help transform, extract and load data from multiple sources.

Train Senior Databases administrators, mentored Senior/Junior DBAs and train regular staff member on SQL Server. Principle consultant for all advanced SQL Server concepts. Strong Problem-solving skills for all SQL Server errors/issues or possible projects.

Utilize database mirroring techniques and replication techniques high availability techniques. Replication; implemented snapshot replication, transactional replication, peer-to-peer transaction replication. Merge replication.

Mirroring; implemented different operating modes, role switching and failover techniques

Implemented and maintained SQL Service Broker solution on the system. Created SQL Server service-oriented solution to help the company abide to the HIPPA laws. Created Service broker services, queues, activation stored procedures and audit trail databases. Implemented Service broker contracts via stored procedures.

Created a layered SQL Server Security solution. Separated the regular users from the admin user and implemented switched execution context for regular users.

Evaluated current practices to provide base for new technology for better performance

Enforced security across the network by forcing encryption and implemented transparent database encryption as well as column level encryption.

Migrated production systems from the SQL Server 2000 platform to the SQL Server 2005, 2005 to 2008 R2,2012, 2014 and 2016 platforms.

Created and maintained the nightly reporting platform that would displayed pre-calculated results to management and clients.

Designed and led efforts to implement Big data using SQL Server analysis services data mining algorithm.

Designed and led efforts to implement a maintenance plan to automate the index management process that reduced time for query retrieval process.

Recommended implementation of best practices for ad hoc Data retrieval and reporting. The recommendation helped tens of thousands of people to be able to interact with the software to build report solutions. Trained thousands of base end users and hundreds of technical resources on how to interact with report model so that they would have more power on what they wanted to see.

Implemented Database high availability solution from a software perspective. This increased the database availability by 300 percent and provided a constant presence of the system. The down time of the system was reduced to milli seconds. This increased the number of clients turn over, and return clients by 200 percent. Implemented Database mirroring and replication for high availability configuring end points to ensure database security.

Designed and implemented stored procedures and triggers for automating tasks for backup and recovery, index maintenance task. The processes were taking 1 hour to do when done by hand and improved to running from few minutes to few seconds.

Led effort of planning, architecting and developing databases, based on business requirements, with key executives, architects and users.

Designed and developed documentation for further reference.

Interfaced with various stake holders, key executives and technical resources to gather and refine requirements.

oMapped these requirements to functional technical solutions by identifying by identifying possible code solutions that would be created to resolve requirement

Created numerous stored procedures and triggers, implemented error checking and transaction control in the T-SQL code for reporting. The reports that were generated were used by management to make important business and strategy decisions.

Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, and Derived column.

Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008.

Generated sub-reports, drill down reports, drill through reports and Parameterized reports using SSRS 2005/2008.

oCreated reports to retrieve data using stored procedures that accept parameters.

oFine-tuned SQL queries for maximum efficiency and performance.

oImplemented various formatting tasks to enhance the feel of the reports

oImplemented parameters grouping

Installed and Configured MS SQL Server 2005/2008.

From: 05/2011 to 05/2012

Company Profile: Mayor’s Office City of Baltimore

Senior Database Administrator

Duties and Responsibilities:

Performed duties of a Senior Database Administrator; Checking Daily SQL Server Job status, performing database integrity checks, resolving production issues related to databases. Planning Migration process, creating indexes, implementing views, backing up and setting up backup schedules, moving and migration databases, working with SQL Server Agent Jobs, creating database Snapshots. Implementing database security.

Created Database based SSIS packages to help transform, extract and load data.

Led scaled-out deployment of enterprise databases through the migration of both applications and their respective databases.

Created multiple complex reports that would be used by executive management team. These were used for important financial reviews and projections that would be utilized to make key business decisions.

Architected and implemented Database High availability techniques.

Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.

Responsible for reviewing hundred lines of SQL code and tuning the code - identifying options for improving performances. Used SQL profiler, Database Tuning Advisor, Dynamic management view, Query Execution plan. Used metric counters and SQL Server database metrics to implement and identify best IT database strategies.

oCreated and maintained indexes.

oMonitored index fragmentation and performed query tuning.

oMonitored the Database System to record and tune any performance issues.

Designed and led effort to implement a maintenance plan to automate the index management process that reduced time for query retrieval process.

Implemented Database high availability solution from a software perspective. This increased the database availability by 300 percent and provided a constant presence of the system. The down time of the system was reduced to milli seconds. This increased the number of clients turn over, and return clients by 250 percent. Implemented Database mirroring and replication for high availability configuring end points to ensure database security.

Evaluated current practices to provide base for new technology for better performance

Evaluated and made recommendations to management regarding the best installation process based current technology domains. Communicated best database practices to executive management. The recommendation was made such as side by side installation to allow test to be done on the new system before we moved to it. The recommended practices were the best database practices. The recommendation was to have a test server that would mirror the current old system and various tests would be done on the test server.

Led effort of planning, architecting and developing databases, based on business requirements, with key executives, architects and users.

Designed and developed documentation for further reference.

Created numerous stored procedures and triggers, implemented error checking and transaction control in the T-SQL code for reporting.

Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, and Derived column.

Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008.

Generated sub-reports, drill down reports, drill through reports and Parameterized reports using SSRS 2005/2008.

oCreated reports to retrieve data using stored procedures that accept parameters.

oFine-tuned SQL queries for maximum efficiency and performance.

oImplemented various formatting tasks to enhance the feel of the reports

oImplemented parameters grouping

Installed and Configured MS SQL Server 2005/2008.

From: 12/2010 to 3/2011

Company Profile: BGE Home / Technisource

SENIOR DATABASE ADMINISTRATOR / REPORT DEVEOPER /ANALYST & DATABASE DEVELOPER

Led effort of planning, architecting and developing databases, based on business requirements, with key executives, architects and users.

Designed and developed technical SSRS Report solutions that would determine how millions of dollars would be spent every month based on marketing solicitations campaigns.

Interfaced with various stake holders, key executives and technical resources to gather and refine requirements.

Cleansed the data using T-SQL code and SSIS techniques.

Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, and Derived column.

Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008/2012/2014.

Generated sub-reports, drill down reports, drill through reports and Parameterized reports using SSRS 20005/2008.

Created reports to retrieve data using stored procedures that accept parameters.

Fine-tuned SQL queries for maximum efficiency and performance.

oImplemented various formatting tasks to enhance the feel of the reports

oImplemented parameters grouping

Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.

Evaluated and made recommendations to management regarding the best installation process based current technology domains.

Created and maintained indexes. Monitored index fragmentation and performed query tuning.

Designed and led effort to implement a maintenance plan to automate the index management process that reduced time for query retrieval process

Architected and implemented Database High availability techniques.

Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.

Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008/2012/2014.

Interfaced with various stake holders, key executives and technical resources to gather and refine requirements.

oMapped these requirements to functional technical solutions by identifying by identifying possible code solutions that would be created to resolve requirement

Created reports to retrieve data using stored procedures that accept parameters.

Fine-tuned SQL queries for maximum efficiency and performance.

Designed and implemented stored procedures and triggers for automating tasks.

Implemented various formatting tasks to enhance the feel of the reports

Implemented parameters grouping

From: 9/2008 to 11/2010

Company Profile: SOGETI LLC

DATABASE ADMINISTRATOR

Responsibilities:

Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.

Involved in installation and configuration of MS SQL Server 2005/2008/2012/2014.

Created numerous stored procedures and triggers, implemented error checking and transaction control in the T-SQL code for reporting purposes.

Created and maintained numerous claims Databases. Configured Reporting Server. Utilized Database Modeling techniques.

Created and maintained indexes. Monitored index fragmentation and performed query tuning

Implemented Database High availability techniques. Enforced security across the network by forcing encryption.

Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.

Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008/2012/2014.

Generated sub-reports, drill down reports, drill through reports and Parameterized reports using SSRS 2005/2008//2012/2014and Crystal Reports.

Created numerous reports emphasizing on the look and feel of reports. Utilized advanced stored procedures, and plain text queries to create datasets. Created reports using Crystal Reports and SSRS. Implemented database High availability techniques, backup and recovery.

Fine tuned SQL queries for maximum efficiency and performance.

Designed and implemented stored procedures and triggers for automating tasks.

Implemented various formatting tasks to enhance the feel of the reports

Implemented parameters, grouping

From: 1/2006-8/2008

Company Profile: Towson University

DATABASE ADMINISTRATOR /MS SQL DEVELOPER/ ETL DEVELOPER

Responsibilities:

Transformed data from MS SQL server 2000/2005/2008 to MS SQL server 2005/2008/2012/2014 using OLE DB connection by creating various SSIS packages.

Used the execute DTS package task to execute DTS packages to prepare university data.

Utilized the System Development Life Cycle. Created and maintained the backend database. Implemented stored procedures, triggers, replication. Used data mining techniques.

Created data transformation tasks like BCP, BULK INSERT to import/export data from clients.

Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data mart databases.

Designed a new schema for the data mart databases.

Generated dynamic reports from cubes (SSAS) using SSRS.

Designed, developed and deployed reports in MS SQL server environment using SSRS.

Generated various reports like cascade type reports, tabular reports, and drill down reports.

Created store procedures, functions and triggers for retrieval and update of data in the database.

Performed Full, Differential, Transactional log and File grouped backup of databases and restore them as needed.

Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Used Index tuning wizard, SQL profiler and SQL query analyzer for performance tuning.

From: 01/2005 to 12/2005

Company Profile: University of Maryland Eastern Shore, Princess Anne, Maryland

STUDENDT DATABASE RESEARCHER

Extensively interfaced with a large Database and used Data Mining techniques to analyze and give future prediction in the luminosity of stars.

Received an award for this research at a research conference

Utilized MySQL, Oracle and later SQL Server.

Create numerous Stored Procedures, Performed Database Tuning

Created Triggers for data integrity

Created reports using Microsoft products

Contact this candidate