Sql Server Database Engineer

ROBERT CONCEPCION Norcross ga *****

SQL Server Database Engineer (DBA, T-SQL, SSIS, ETL, EDW)

Accomplished database professional with over 20 years of expertise in SQL Server architecture, administration, performance tuning, and data management, seeking a full-time role with a fast-growing organization to drive strategic growth and spark innovation.

Certification:

DP-900: Azure Data Fundamentals

Experience & Roles 20+ Years

Database Engineer SQL Server, Database, and Infrastructure Management

A seasoned database engineer with over 20 years of experience specializing in SQL Server architecture and optimization. I design scalable database infrastructures, recommending cloud computing solutions (Amazon EC2) and storage configurations (Amazon EBS) for AWS and Azure environments.

I assess Recovery Point Objective (RPO) and Recovery Time Objective (RTO) to advise on High Availability (HA) architectures, ensuring alignment with business continuity goals.

Query plan analysis & performance tuning for efficient SQL execution.

Index design & optimization to enhance database responsiveness.

Diagnosing & troubleshooting performance bottlenecks through in-depth system analysis.

Modeling wait states, transaction locking, and file I/O behavior for deep system insights.

Utilizing Perfmon to track resource consumption and drive data-driven optimization.

Implementing Change Data Capture (CDC) for real-time data tracking, enabling historical reporting, auditing, and ETL integration.

SQL Server DBA 20+ Years

As a dedicated 24x7 on-call DBA, I ensure SQL Server environments remain stable, secure, and optimized. My core responsibilities include:

Backup & restore management, ensuring data integrity.

Index fragmentation analysis & statistics maintenance for performance efficiency.

Profilers & Extended Events utilization to pinpoint SQL statement inefficiencies.

Security & patch management, safeguarding database environments.

QA, UAT, and production deployment, supporting seamless code releases.

Data Engineer 15+ Years

Specialized in data pipeline development, SSIS ETL workflows, and enterprise data integration. I merge data from multiple sources, implementing table-driven batch processing solutions and various data modeling techniques, including:

Staging, Star Schema, 3NF, and Big Table models with partitioning.

SCD Type 1 & Type 2 implementations for Enterprise Data Warehouses (EDW).

SSIS Automation data load and automation and Source-to-target mapping with meticulous documentation.

Logical & physical database modeling, applying Inmon and Kimball methodologies.

Cloud & Data Lake IO optimization, ensuring scalable storage strategies.

T-SQL Developer 20+ Years

An expert in T-SQL development and query optimization, crafting high-performance database solutions tailored to business needs. My skill set includes:

Query plan analysis & tuning to refine execution efficiency.

Index optimization strategies, including single & composite clustered indexes.

Stored procedures, views, triggers, CTE, window functions, and in-memory tables development.

CDC implementation & DMV reporting, ensuring comprehensive data insights.

Team Lead 10+ Years

A results-driven leader providing strategic direction, mentorship, and technical guidance to database teams. I take full ownership of data projects, with key responsibilities in:

Requirement & test plan development to streamline software cycles.

Progress reporting & blocker resolution for efficient project execution.

Mentoring QA Analysts & SQL Developers, fostering team growth.

Enhancing inter-departmental communication, driving collaboration.

Technical resource organization, ensuring optimal execution of database initiatives.

PROFESSIONAL EXPERIENCE:

Self Employed Free Lance SQL Server Consultant Jan 2024 - Present

Over the past eight months, I have deepened my expertise in Azure, Azure AI, python, Databricks, and the migration of Enterprise Data Warehouses (EDW) to an Apache Spark platform. Additionally, I have focused on mastering the fundamentals of machine learning and enhancing my proficiency with SQL Server.

Pyramid Inc, Alogent Part time Contract

Titles of Responsibility: SQL Server Consultant Oct 2024 Jan 2025

Industry: financial services software company.

Client: Financial services company specializing in check processing for credit unions and banks, enabling mobile devices and tellers to deposit checks via photo scans. Developed an OLTP application utilizing a .NET service bus architecture for eventual consistency and SQL Server RDBMS to process both application transactional and batch file data.

Challenges: The application faced performance issues related to low concurrency and high contention and poor disk latency.

Goal: Increase throughput by decreasing contention and increasing concurrency of cash item processing.

Actions:

Conducted an architecture and T-SQL code review, along with a hardware and Hyper-V configuration assessment.

Analyzed query plans and recommended T-SQL code and index optimization improvements, including compressing XML fields that led to 80% storage compression and modifying oversized fields.

Created a set of collectors to capture wait states, file I/O stats, and transaction locking counts to identify bottlenecks.

Outcome: Identified disk contention issues during an 8-hour benchmark, with TempDB reaching 20 ms and data drives reaching 150 ms latency. Increased memory from 38GB to 90GB to enhance Page Life Expectancy and prevent flush cache. Additionally, proposed decoupling business rules from the database and creating a .NET layer to enforce data validation and business rule enforcement.

CAI Cambium Assessment, Inc– Dallas, Texas Fed 22 – Nov 23

Titles of Responsibility: Lead Database Engineer I

Industry: Educational technology Assessment

Client: The company was aggerating K12 testing data for analytics and reporting, the backend was Enterprise Data Warehouse on AWS (IaaS) cloud base MMP design of 48 Shards and 20 Cache servers using SQL Servers 2017. A major problem was the system had issues handling 6,000 logins an hour,. Contention was high and Concurrency was low. There were fundamental design issues since each SQL Server instance shard only stored on average of 3,500,000 K12 test with 16 processor and 128 GB of ram with an operational yearly cost of $1,400,000.

Challenges: The application faced performance issues related to low concurrency and high contention and data volume.

Goal: To drop operational cost from $1,300,000 to $350,000 and consolidate shard and cache server Counts from 68 server to 16.

Actions:

1st was to identify the problem, since the institution had a benchmark tool to emulate a workload, I used profiler trace to capture all store procedure call,. then automated loading the data with SSIS into a database and categorize the input parameters type and duration of execution time, then used Excel to create models of the sp calls to identify contention issues.

2nd was to analyze causation of Contention and Concurrence by creating performance models using data from both the application, OS, and databases. Used DMV such as dm_db_index_operational_stats and dm_db_index_physical_stats to trace table level locking counts. Analyzed all query plans to locate code section with long durations, high CPU, disk IO, spill to TempDB and memory grant issues. Also, gathering perfmon counters data about Disk IO, Network IO, and CPU. then created SSIS package to ETL the data into a reporting table that would export to an excel workbook that had predefined pivot table to analysis performance tables. Also used DMV fn_virtualfilestats to collect data and create models on sql server IO waits. And, using wait stats DVM dm_os_wait_stats to analysis if performance was improving. The issues were tracked down to using row base table that cache predefined datasets in a pessimistic locking model with high select, delete and insert.

3rd Solution was to use SQL Server In-Memory OLTP optimized tables for cache datasets and logging outcomes. Refactored stored procedure how the temporary table pipeline interacted In-Memory tables and removes bad code constructs.

4th Implementation and Project plan, designed a project plan with testing phases, resource allocation, and automated Benchmarking to validate new design of 70 store procedure and 20 tables, 22 new indexes, and 8 SQL Server Agent Jobs.

DBA role: 24 / 7 on call, to support operation DBA and system engineers, and did general DBA task by working on deadlocking and index usage and create a DB tools database and create diagnostic store procedure Worked with implementation team to write scripts to make object modification at the process, code, and table level.

Replaced replication high availability (HA).. solution with cross-shard Availability Group (AG) to achieve high availability.

Outcome: AWS EC2 VM where updated to the latest Intel processor, increase EBS GP3 Volume from 5 to 25 with increase IOPs and throughput, and partitioning by Client and Academic Date, which lead to an increase record count per shard and decrease contention.

Amazon EBS (Elastic Block Store) Amazon EC2 (Elastic Compute Cloud).

Free Lance SQL Server Consultant Jun 17 - Aug 21

M3, Inc.: – Lawrenceville, GA Contract 2021

Titles of Responsibility: Database Engineer III, Contract Data Engineer Consultant

Industry: Financial Hotel Accounting

Client: M3 provides hotel accounting solutions, need to evaluate feasibility of migrating 3000 single tenant databases running SQL Server 2016 to a 3 Node Nutanix Hyperconverged infrastructure (HCI) vSAN and ESXI Hypervisor (IaaS), Each Node had 36 cores and 750 MB of ram. In addition, upgrade to SQL Server 2019 and use availability groups.

Challenges: To create a model to determine the risk if the consolidation of all the SQL Server was feasible

Actions:

By Analyzing the current SQL Server infrastructure, I create a model of memory and disk storage requirements and created a cost model to compare SQL Server 2019 Standard and Enterprise licensing.

Outcome: The hardware configuration would not be able to handle the IO requirement and if the server failed over the system did not have enough memory to manage 2000 single tenant DB without a large performance issue. That consultation project was cancelled.

Apptad, Inc.: – Alpharetta, GA Contract 2020

Titles of Responsibility: Database Engineer, ETL SSIS Developer Contract Data Engineer Consultant

Industry: Construction Materials

Client: CRH A massive data load precipitated creating a data service layer to prevent users from using the OLTP system to create reports.

Created an SSIS template package that required no modification to call a CDC monitored table. Renaming the template allowed for subsequent packages to dynamically query CDC function and tables and support either a full or CDC load.

Monitored an Azure (PaaS) SQL Server hub spoke replication process and enabled CDC on subscribing tables, using SSIS packages to enable ETL delta record detection between source and target tables.

Staffing Technologies: –Atlanta, GA Contract 2019

Titles of Responsibility: Database Engineer, ETL SSIS & T-SQL Developer and Data Test Lead

Industry: Food service industry

Client: Inspire Brands (Arby’s) Migrated their OLTP system, reloading into a QA EDW data warehouse, as part of a requirement to ensure equality between all production fact tables, with an emphasis on measures.

Create SQL scripts, executing against QA and production data, that compared results and were instrumental in resolving data quality issues.

Wrote high level test plans and data flow documents used by the QA team for testing.

Datapath Inc: –Atlanta, GA Contract 2019

Titles of Responsibility: Database Engineer DBA, ETL SSIS & T-SQL Developer

Industry: Self Hospital Insurance

Client: MCIC was migrating an insurance application which included upgrading the EDW and ETL process. They project was behind schedule and the SSIS ETL was not tested. The team analyzed and created a plan to deliver project on time.

collaborate

Documented SSIS ETL workflow in Visio and Created source to target mapping and defined business rules in Excel.

Migrated existing ETL Process to automate the loading of the new Fact and Dimensions tables in EDW.

Collaborate with Finance and Account and Report writes to identify discrepancy in reports and find correct in calculation or raw data.

Softtek Inc: –Atlanta, GA Contract 2018 - 2019

Titles of Responsibility: Database Engineer DBA, SSIS ETL & T-SQL Developer

Industry: Tire Reseller

Client: TireHub was in the supply chain business in charge of retail tire distribution for Goodyear and Bridgestone, The Client was in a startup phase and the first version of the EDW and ETL which did not meet expectations.

Analyzed current Azure (IaaS) SQL Server 2016 EDW environment and made appropriate recommendations and system adjustment to address performance and recover point objective (RPO). Also providing Day to Day SQL DBA services.

Refactored the current inventory fact, supporting dimension, and reports by interviewing users and understanding the measures that would be needed then using Excel pivot function prototyping possible reports.

Created additional summary fact table to model measurement of inventory flow on how the company measures inventory turnover and on-time, in-full (OTIF)

Atayo Group Inc.: –Atlanta, GA Contract 2018

Titles of Responsibility: Database Engineer DBA, SSIS ETL & T-SQL Developer, Data Modeler

Industry: Perfume

Created a Logical and Physical model for a 2 tier Web based application to manage a system of records for Work Request and Test event tracking in SQL Server 2016 and IIS 10.

Used User Requirement documents to create Software Requirements Specification (SRS) to described system functionality.

Create Schema, Tables and Column naming conventions and assigned appropriate datatype, null ability and default values and constraints.

TRC Staffing: –Atlanta, GA Contract 2017 - 2018

Titles of Responsibility: Database Engineer DBA, SSIS ETL & T-SQL Developer

Industry: Staffing

Designed a Data Migration and Integration plan (ETL) to use SQL server 2016 and SSIS to manage the ETL process to pull data from Bond Adapt applicant tracking systems to confirm to Microsoft CRM input file formats.

Worked with 3rd party vendor’s developers to create project plan and tasks and deliverables.

Reverse engineered the source of data from the Bond Adapt ATS forms by using SQL profiler traces and using excel to document the data path to CRM input file formats.

BrightStar: –Alpharetta, GA FullTime Aug 16 – Jun 17

Titles of Responsibility:

Database Engineer DBA, SSIS ETL & T-SQL Developer, EDW Data Modeler

Industry: Cell Phone Insurance and claims

Modified existing Data Migration and Integration process to support multiple time zones and locals to support EDW.

Fostered meeting with senior managers to define fact and dimension models and measures for the EDW.

Create a performance model to measure the performance of a cell phone insurance claim being filed to the time the claim is fulfilled by the warehouse and the device are sent to customer.

Create a performance model to measure the performance of a cell phone insurance claim when a same unit repair involves repair vendors. Developed the SQL code that would transform the transactional ODS data to a linear model of time sequences to measure the length of claim processing and repair cycles at various point.

Involved with SOX security audit and setup of role base groups in Dev, QA, UAT, and Production.

Self Employed Free Lance SQL Server Consultant 2013 - 2016

Lift 361, Inc., Duluth, GA FullTime 2015 - 2016

Titles of Responsibility: Database Engineer DBA, SSIS ETL & T-SQL Developer, EDW Data Modeler

Industry: Retail Marketing

Engineered 3 Data Migration and Integration of retail POS data warehouse from concept to implementation.

Created customer dimension table to manage merging multiple customer accounts into one Account.

Developed algorithm using SQL for exact pattern matching and SSIS fuzzy matching to find customer account that would roll up to one account.

Automated with SSIS, address standardization, DPV, and CASS, geocoding, and profile mapping.

Automated with SSIS NCOA (National Change of Address) process to send and receive address information.

Implemented a reverse append process that would send method of payment credit card information to a 3rd party vendor that would send back a customer name and address for processing

Collaborated with Data Analysis team to create Customer Segments by analyzing shopping patterns such as purchases, visits, tenure, and also creating Geographic Profiles buy analyzing loyalty and closest store.

Created various operational reports about sales data and identify data quality issues.

ASAP, Inc., Norcross, GA Contract

Titles of Responsibility: EDW, T-SQL Developer,

Industry: Retail 2014 - 2015

Collaborated in a 4-person Data Migration and Integration team to document online web store data warehouse from data source to fact and dimension tables.

Used Excel to create mapping data flow documentation and used Visio to create data flows diagram.

Worked with system Architects to understand and document business processes.

Worked with senior partners to create project plans to assign task and resources.

o

Matrix Resource: – Atlanta, GA Contract 2011 - 2014

Titles of Responsibility:

Database Engineer DBA, SSIS ETL & T-SQL Developer, Data Modeler,

Project 1 VHA– Atlanta Georgia

Industry: HealthCare

Data Migration and Integration 32 Hospital data sets into a Datamart for reporting and benchmark analytics.

Assigned ownership of Healthcare Business Intelligence application for Cardiac Catheterization Lab (CCL) and Ortho Spine and Joint information management systems.

Ex (Best in Class, National Averages, Volume Class Averages, by Quantity Used, Inventory Cost, Total Cost, Procedure Time, and Length of Stay (LOS); in addition to, grouping the data by procedure classes such as CRM, EP, Ablation, Stenting, Ballooning, Value replacement, by various vascular location or cardiac defect.

A star schemas type 1 model of cases was used to control sample size and data quality reporting.

In addition, summary statistic, such as, central tendency, standard deviation, percentile, quartile, skewness, kurtosis, five-number summary where derived from the star schema model.

Created an Excel dashboard to display 400+ benchmark outcomes and transaction data used.

Design mapping tables to map department (cost centers), activity, and UB92 codes to standard transaction Identification.

Loaded Star schema Fact and Dimension tables with results.

Project 2 Cardlytics– Atlanta GA

Industry: Transaction Base Marketing

Data Migration and Integration of national banking institution Saving and Checking purchase to analysis shopping behavior

Created 2008 R2 SSIS ETL Bus framework, with the following components: Batch File Control system to load files and provided an audit trail of when and who processed the file, if the file completed processing and added metadata to the record to track what file the record came from or what file and record provided the change.

Created a SSIS Batch Scheduling Control system to create data files by tracked the date range of records in the files and if the file was ever created.

Optimized SSIS packages and SQL Server 2008 R2 to insert 1 billion record files.

Create star schema model to support both Type 1 and Type 2 record inserts and updates with a partition design both using federated tables and SQL Server partition indexes’

Created operational SSRS Reporting Service reports.

Performance tuned data warehouse workloads by change locking, threading, and index strategies.

Tested and bench marked NAND Flash SSD Storage Solutions: Violin Memory, Kaminario K2, and FusionIO with Data warehouse loads and as TempDB accelerators.

Additional position on request 2005 - 2010

Avanade: – Seattle, Washington Fulltime Sep 03 – Sep 05

INDUSTRY: Premiere Microsoft System Integrator

Roles: Solution Developer / Database Engineer, SQL Server DBA, ETL Developer, T-SQL Developer

Project 1 Avanade (Siemens/Accenture) – Murray Hill, New Jersey

INDUSTRY: Hosted Web Services/Provisioning

Project 2 Avanade (Microsoft Financial Service) – Atlanta, Georgia

INDUSTRY: Banking /Financial Services

Project 3 Avanade (Suntrust/Accenture) – Atlanta, Georgia

INDUSTRY: Banking /Financial Services

Project 4 Avanade (Boston Scientific/Accenture) – Natick, Massachusetts

INDUSTRY: Medical Device Manufacturing

Accenture: – Atlanta, Georgia Fulltime Fed 03 – Sep 03 Bell South – Atlanta, Georgia

INDUSTRY: Telecommunication

EDUCATION

Gwinnett Technical College- Lawrenceville, Georgia 1997, 1999, 2016, 2017

Contact this candidate