We provide IT Staff Augmentation Services!

Additional Knowledge And Skill Areas: Resume

Sql Engineer Service Contractor Baltimore, MD

OBJECTIVE:

Database Architect, SQL Server DBA, SQL Server Developer.

SUMMARY:

  • Over 18 years in all aspects of MS SQL Server, and more than 20 years of overall experience with Database architecture and design; SQL language; Data conversions; Development and deployment of new products, migrations to new versions; Solid experience in data mining, decision support, BI and data warehousing using OLAP data cubes.
  • Expertise in relational structure design and full system logic performance using key constraints.
  • Strong knowledge of multiple table queries for customized complex reports with related sub - reports; Usage of locks and multilayer transactions within stored procedures, triggers and functions.
  • Highly skilled in analyzing information and converting from legacy data files to fully functional database system. Built comprehensive systems with heavy internal calculations for accounting and finance departments with data storage and compliance functionality.

ADDITIONAL KNOWLEDGE AND SKILL AREAS:

  • Database Architecture
  • System Development
  • System Migration
  • Data Migration
  • SQL Server Administration
  • Performance Tuning
  • Transaction handling
  • Data Mining & Reporting
  • Project Management
  • Full SQL Server Documenting
  • Production Support / Consulting
  • Teamwork & Communications

TECHNICAL SKILLS:

MSSQL Server: 7-2016 (SSMS, SSIS, SSAS, SSRS, Business Intelligence Studio/SSDT), PowerShell, Windows Core, Hyper-V, VMWare, Windows/SQL Server Clustering, AlwaysOn HA/DR, Hadoop, Perfmon, VS 2013, SharePoint, Visio, MS Project, Erwin, C gn s, MS Access, r cle, Cobol/DB2, Sybase, MySQL, V, / ++/ #/J v, EBCDIC; L, J v S ript, VBScript, AS, S .NET, XML, erl, GI, IIS, Apache Hive, SVN;

SQL Server tolls: Foglight, SpotLight, Red Gate, Solarwinds, Idera, SQL Sentry, wide set of T-SQL scripts;

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

SQL Engineer/Service Contractor

Responsibilities:

  • Dived into large SQL environment; Assessed current production problems;
  • Uncovered series of problematic issues; Provided discovery tools and solving recommendations;
  • Finished small project on discovering SQL Blocking scenarios in the enterprise environment;
  • Assessed company’s current HA/DR environment;
  • Evaluated production system load;
  • Came out with Hardware system requirements for an upgrade to SQL Server 2014 with utilizing its newest features and supporting annual rising of daily workload;
  • Serviced client (Ciena, Hanover MD) as SQL Server Architect:
  • Jumped into a conversion project of MySQL legacy database to SQL Server platform;
  • Did a full assessment of legacy database structure with profiling the data and documenting all interface calls;
  • Built a high level SQL database model suitable for the converted historical data, ongoing operational processing and future data warehousing and Cube reporting;
  • Designed Stored Procedures’ and SSIS packages templates for historical data conversions and day-to day user operations;
  • Made full assessment of most critical SS and provided fixes for found problems;
  • Established DR procedure and developed monitoring set of alerts;
  • Did an evaluation of current SS licensing situation within a department;
  • Developed T-SQL compliance script to check SS for compliance with IRS SCSEM;Came up with consolidation strategy for SS Databases and MS Access databases migration;
  • Did a migration from SS version 2008R2 to 2012 on Windows Core edition server;
  • Designed a database structure for newly implemented State Government application;
  • Developed set of SSIS packages to load third party historical data into the new database;
  • Serviced client (Apria, CA) as SQL Server Engineer:
  • Reviewed business logic of set of more than 50 queries’ ETL process and redesigned it in order to easy run and get process logging info; Improved process performance by decreasing execution time from 9 hours to 15 minutes;
  • Overlooked another ETL process contained 6 extractions of the same data. Simplified the process to reduce execution steps by combining queries and using temp table to read the data only once;
  • Made recommendations on overall SQL server performance; Provided metrics on Memory/CPU/Disk usage;
  • Provided expertise on building SSAS cube over the transformed data to provide reporting to higher management;
  • Designed SSAS Data Warehouse and developed Data Mart ETL process;
  • Researched the problem with client’s mirroring. The problem was with too many mirrored databases, which generated too many working threads that their CPUs weren’t able to support;
  • Suggested usage of SIOS DataKeeper to avoid multithreading issues;
  • Serviced client (AlliedServices, PA) with SSIS/ETL consulting:
  • Researched the problem with existing SSIS package and provided fixing solution.
  • Performed full analysis of three SQL Servers, including: SharePoint, Clustered Node, SS2012;
  • Documented five biggest/most complex databases;
  • Provided to client a list of steps to improve performance of the system;
  • Set up additional SAN drives in clustered environment and attached them to the SQL Server;
  • Performed complex set of activities to improve performance of company’s SQL Servers;
  • Detected that VMWare gives to the SQL Server 2x16 CPUs instead of 16x2 CPUs;
  • Found some queries that have unnecessary joins and functions usage in a WHERE clause. These improvements improved execution time from 7 hours to 1.5 hours;
  • Assessed 6TB DB and queries against it. Found that slowness is caused by incorrectly built execution plans. Provided solutions to avoid that problem (hints, deleting plans, manage statistics);
  • Operated with a database with more than 80,000 tables (SAP);
  • Documented and built relationship diagrams for several databases with up to 1,000 tables and 17,000 columns in each database;
  • Documented all production Data Warehouses (9 in total) and built Bus Matrixes for them.
  • Solved problem with Backup slowness on 7TB SAP DB. Rearranged BU strategy to do BU individual files;
  • Went through 33 production servers with different versions (2000/2005/2008 (R2)/2012). Assessed DB backups, their sizes and compression ratios;
  • Reverse engineered SAP scheduler RedWood (about 1700 tables) and built series of queries to deliver SAP schedule to SharePoint;
  • Assessed of newly proposed implementation of DB nightly loading process. Recommended to move data to a DB with simple recovery mode, use multi not-logged inserts to partitioned view;

Confidential, Baltimore, MD

Responsibilities:

  • Implemented handling slowly changing dimensions for pricing and market areas;
  • Administered four SQL Servers (Back Up, user access, scheduled jobs);
  • Monitored SQL Servers and DBs performance. Tuned Stored Procedures and Queries if necessary;
  • Supported SSIS Framework that updates SSAS based data warehouse;
  • Build several SSRS reports to provide users with additional data;
  • Enhanced some SharePoint dashboards based by adding new KPIs;
  • Performed migration of one of the servers from SQL Server 2000 to SQL Server 2012;
  • Redesigned customer’s back-end system accordingly to business process changes. That included:
  • Database redesign;
  • Rewriting of multiple Stored Procedures;
  • Tuning slow running reports;
  • Complete database and change documentation;
  • Developing automated testing procedures, and etc.

Confidential, Annapolis, MD

Database Architect, SQL Admin/Developer

Responsibilities:

  • Handled small project of conversion Oracle based system to SQL Server.
  • Accessed Sensitive personal information for more than 20 thousands individuals and businesses;
  • Reverse engineered of multi-database data structure on Oracle server;
  • Built multiple ETL processes to extract data from Oracle Databases to SQL Server 2012 (SSIS);
  • Designed new database data structure to accommodate Enterprise solution of merging 25 separate databases into single system;
  • Produced more than 70 stored procedures of different complexity to cover all aspects of data access. Such as user setup, password handling, filling customers’ data, performing core operations, handling secure data (SSN, TAX ID etc.), various reporting with elements of business intelligence, historical data logging, access tracking etc.
  • Planned future database growth; Tuned most complex queries for best performance;
  • During design process met with end users and stakeholders; Gathered requirements, identified business flow, produced supporting documentation and built process accordingly.
  • Provided training for “ Confidential ” staff to be familiar with SQL Server, new data structure and procedures;

Confidential, Washington, DC

SQL Engineer

Responsibilities:

  • Worked on a project of improving performance of daily loading of financial data warehouse. Project’s highlights:
  • Source system: Oracle, PeopleSoft. More than 150 tables and more than 10 million transactions.
  • Original full data loading process on development server took about 30 hours.
  • Improved data loading process on development server takes about 6 hours.
  • Higher Data loading performance was reached by multithreading execution of hundreds independent loading processes in SSIS using SQL Server Broker loading queue.
  • Faster execution speed of data warehouse loading was achieved by tuning multiple stored procedures and views, eliminating unnecessary inline functions and data redundancy.
  • After the project left series or recommendations for further improvements, such as: unloading staging and legacy data from warehouse database to staging and legacy databases; splitting data mart on multiple files to decrease possible locking of resources during high volume loading; replace big data extracting queries by smaller loading and update statements, etc.
  • During the project also consulted in different aspects of SQL Server, such as: Security, tracking user activity, etc.

Confidential, Landover, MD

Senior Database Administrator

Responsibilities:

  • Handled core part of the project
  • Designed migration process for Confidential and Confidential Eligibility records;
  • Developed migration and production ETL processes;
  • Developed data migration validation procedure;
  • Closely worked with Java portal developers; Supply them by Stored Procedures for my area;
  • Provided integration between SQL server and ActiveVOS and Hibernate;
  • Supplied data for reporting team data warehouse; Support testing team with performance metrics;
  • Besides main responsibilities managed multiple reference and valid values data sets;
  • Helped data architect with data model design, supply analysts with current data model structure;
  • Worked side-to-side with Lead SQL Dev with DB allocation and deployment strategies;
  • In the beginning of the project designed team’s policies, ETL error handling and logging procedures;

Confidential, Hanover, MD

SQL Server Administrator/Developer

Responsibilities:

  • Administer corporate SQL Server: Backup, DR, User access, maintenance, deployment, updates;
  • Administer SQL Reporting and Analysis Servers, develop new cubes and reports;
  • Develop new ETL processes based on SSIS;
  • Analyze business processes and build appropriate data flows for BI reporting;
  • Manage corporate Data Warehouse and provide additional analysis and reporting functionality;
  • Design data architecture for new databases and data warehouses;
  • Redesign existing databases and normalize or de-normalize data sources if necessary;
  • Design and develop Cast Iron Orchestrations;
  • Provide full life cycle of application development;
  • Provide visual documentation for all existing and new processes.
  • 24/7 Support of 30 company’s SQL Servers (2005/2008)

Confidential, Baltimore, MD

Project Manager / SQL Server Database Administrator

Responsibilities:

  • Managed the development of a master data set of financial trading Database;
  • Administered (24/7) medium size environment (12 SQL Servers 2000/2005);
  • Went through migration from SQL 2000 to 2005; Converted multiple Confidential packages to SSIS;
  • Defined, plan, coordinate, control and review all business intelligence-related project activities;
  • Developed strategy around master data management;
  • Designed and implement SQL Server based solutions;

Confidential, Baltimore, MD

SQL Server Database Administrator

Responsibilities:

  • SQL server Administration; Managed migration of four Servers to SQL 2000;
  • Supported several Database accessing Intranet Trust applications;
  • Designed and developed an Audit Reporting system;
  • Provided DBA support for Development/Application team;
  • Developed and supported numerous Confidential packages;

Confidential, Baltimore, MD

SQL Server Database Administrator

Responsibilities:

  • Administrated set of corporate SQL Server 2000; Supported several WEB based applications:
  • Developed new reports; Improved structure of data storage;
  • Provided Physical & Logical design for new SQL Databases;
  • Troubleshot Cobol Programs; Implemented Fixes and Changes; Created new reports;

Confidential, Baltimore, MD

Electronic Engineer

Responsibilities:

  • Provided Software/Hardware support including troubleshooting for clients;
  • Built wired and wireless networks, installed security systems;
  • Performed as a consultant for customers

Hire Now