VLADIMIR ISAEV

SAN DIEGO, CA

303-***-****; ad2v7u@r.postjobfree.com

SKILLS: DBA (with T-SQL DEVELOPMENT and DEVOPS)

• Production DBA, SQL Server and Query Performance Analyst (hands-on), SQL Server Developer, SSIS/ETL, Solutions and DevOps Analyst, Business Intelligence Analyst/Developer, Data Analyst, IT problem solver hands-on programming, deployment, QA, technical support, offshore teams collaboration.

•PRIMARY/PREFERRED IT ROLES: DBA, Business Intelligence (BI)) and Database Performance Analyst/DBA, Systems Analyst, Project Integration Specialist; Database Server and Query Performance issues investigator, researcher, and hands-on T-SQL refactoring coder for query performance optimization and reducing server resources consumption.

•OS: Windows Server 2003/2008/2012 /2016 UNIX, Linux (multiple flavors);

•DATABASES: Microsoft SQL Server 2000/2005/2008/R2/2012/2014/2016/2017/2019/2022; Oracle 12, MS Access, MySQL, Postgre SQL, DB2, Teradata, and Sybase (ASE);

•LANGUAGES: SQL, TRANSACT-SQL (T-SQL), PL/SQL, VISUAL BASIC 5.0/6.0/.NET, JavaScript, XML, JSON, .NET/C#, Python;

•SOFTWARE/TOOLS: Windows Server Management tools, AppDynamics, ERWin, TFS, SVN, RedGate Tools (all), Toad (Oracle), SQL Server Reporting Services (SSRS), SSAS, SSIS, Crystal Reports (Business Objects), SOLAR WINDS, Oracle (Toad, SQL Developer), SQL-Optimizer, Solar Winds, AQUA Data Studio, and a number of custom tools developed by myself (SQL Agent Jobs Management Utility; BLT – Block and Lock Tracing), LAG system (Latency Analysis).

•WEB DEVELOPMENT: IIS/ASP, VBScript, JavaScript, HTML, XML, .NET.

•BUSINESS INTELLIGENCE (BI)/REPORTING: SSRS (SQL Server Reporting Services), Business Objects, Cognos, Data Warehousing (DW) Architecture and Implementation, Dashboards, ETL (Talend, SSIS), Power BI.

EXPERIENCE

SR. SQL DBA/PERFORMANCE ANALYST

WNS - HealthHelp, LLC. · Full-time (Houston, TX)

Oct 2020 - Present

•Healthcare environment: Day to day DBA, DevOps, Performance Analysis, and Query Optimization.

•Monitoring operational data loads, Replication, AAG, BI processes, and performance/behavior of Production SQL Servers, including Operational Analytics and development of proactive alerting both programmed in T-SQL as proprietary solutions and using third party tools such as Red Gate and App Dynamics.

•Identifying and remediating Web user-reported GUI, IIS, and back-end latencies critical to company’s clients and SLAs; supporting global call center and operational activities. Designed and developed enterprise-wide proactive alerting system named LAG (Load-At-A-Glance) allowing to promptly evaluate rapidly escalating workload and server bottlenecks at the early stages of their escalation (before any latencies are reported by global end-users).

•Development and Stored Procedures refactoring (targeting performance improvement). SSIS /ETL daily support.

SQL SERVER DBA

GUARDIAN LIFE INSURANCE COMPANY · (via PRI TECHNOLOGIES) (OWINGS MILLS, MD)

Oct 2019 - Oct 2020

•As a part of 3 teams (DevOps, DBA, and SQL Development teams), performed a number of duties primarily related to troubleshooting production issues, creating SQL CPR (Custom Performance Repository) as a Baselining and Monitoring solution targeted at Healthcare/Claim Adjudication business transactions and ETL loads (Brigdegate, SSIS). Power BI, Jira/Agile, and Programming and Query Optimization hands-on tasks.

•Involved into Solutions Architecture and re-design of existing projects as well as brainstorming and inception of the new initiatives. Data Modelling and Object Dependencies Analysis. Load and Process Troubleshooting.

•Database Development, Query Optimization, Administration of SQL Servers; Monitoring tools (App Dynamics, Footlight, Zenoss, Analysis of Production failures and Deployments (DevOps team). Review of Python/BI logic.

Created routines for quick and efficient analysis of Performance Tuning and other T-SQL and environment modifications before and after code optimization, upgrades, and migrations. post-migration and DR testing.

Sr. SQL INTEGRATOR/DBA

IRON MOUNTAIN (COLLEGEVILLE, PA) (SQL Experts, LLC. and Beacon Hill Technologies)

11/2017-10/2019

•Co-designed a Commissioning System for UK sales representatives of the company based on the US System for commissions issuance to sales representatives as a part of a larger solutions coalesced with Sales Force system.

•Integrating, programming, and testing the newly designed solution into a larger solution (.NET, MS Access, SQL Server 2012/2016). Re-factored SSIS processes (daily ETL) to include the new United Kingdom system for processing sales commissions and modifying a number of MS Access and SSRS reports to accommodate the rules of the new application. Developed new SSRS reports and modified existing reports in .Net (primarily middle tier).

•Analysis and re-design of VB 6 applications to .NET and SQL Server environment. Migration of databases from SQL Server 2005, 2008 to version 2016 Enterprise; resolving predicted and new issues, analyzing roadblocks and Cardinality Estimator incompatibilities. Using Extended Events and Query Store along with 3rd Party Tools (Redgate, SolarWinds).

DBA/DATABASE PROGRAMMER

COTIVITI HEALTHCARE, (CONSHOHOCKEN, PA) (via Randstad Technologies)

3/2017-10/2017

•As a part of the CMS Government Engineering group within Cotiviti (formerly Connolly) Health care and as a Business Intelligence and Performance Analyst with strong knowledge of T-SQL and Data Analysis -- investigated, troubleshooted, and proposed solutions to production issues that cause slowdown of major overnight ETL processes. Via fine-tuning SQL Server configuration options, indexing, and re-writing essential blocks of T-SQL, I have achieved performance gain that can be quantified not only by seeing reduced I/O on the server but also via run-time (reduced from 15 to 8 hours overall duration of the overnight report building process.)

•Setup, Tuned, and tested the first SSRS environment in the company, and supervised and developed and the first suite of SSRS reports in the company (using certain prototypes of reports formerly developed in MS Access and Excel yet scalability requirements called for a different, more robust environment like SSRS and/or Business Objects.

SQL SERVER BI DEVELOPER/DW DBA

STATE OF DELAWARE, (DOVER, DE), Department of Education

07/2014- 01/2017

•As Sr. Business Intelligence Developer, Analyst, Database Problem Solver, and DBA provide day to day input into maintaining Production and Development servers, as well as actively participate in SSRS and SSAS solutions in MS SQL Server 2008 R2 and 2012 Enterprise. Closely work together with network engineering, Share Point administration, and product development and delivery teams. Performance analysis and optimization (including custom performance base-line data collection), DR (Disaster Recovery) and High-Availability solutions, big data management, and supervising and supporting ETL/SSIS developers and ETL processes. Database architecture and change management. T-SQL code refactoring and testing. DR Documentation and Report Portal Analysis.

DATABASE CONSULTANT

CLIENT CSC (COMPANY SERVICES CORPORATION) via DIAMOND TECHNOLOGIES, INC. (WILMINGTON, DE)

11/2013 – 06/2014

•As Data Analyst, DBA, Performance Investigator, and SQL Developer/BI Developer closely collaborate with both Infrastructure and Development groups to identify and remediate major Database Server performance issues, particularly focusing on optimization and tuning of T-SQL within Stored Procedures and Functions that house the main business logic for the company’s most essential software products, primarily high-concurrency and high-volume web-based .NET and .Java applications, .NET Web Services, Windows Services, and Databases (multi-terabyte SQL Server and Oracle databases).

SQL SERVER DBA

HEXAART, INC. (PHILADELPHIA, PA)

10/2010 – 09/2013

•Worked for several clients, both remotely and on-site. Specializing in T-SQL Development and code reviews, Data Analysis, ETL Solutions, DR (Disaster Recovery) solutions, BI/OLAP/Reporting, Performance Analysis and Optimization. Setting up Clusters, Programming in T-SQL, Complex Stored Procedures, SSIS, using all the latest features of SQL Server 2008 along with 2005 and 2000 versions. Providing data migration (cross-version) architecture. SSIS. SSRS, and SSAS.

•Hired/Interviewed other SQL Server specialists especially in SQL Development and DBA areas. Extensively communicated with the clients, gathered, analyzed, documented and ratified user requirements.

•Provided monitoring tools (both 3-rd party and written by self) for production SQL Servers. Ensured performance/uptime.

DBA/BI ANALYST (HANDS-ON)

LEGAL EDGE SOFTWARE, INC. (WAYNE, PA)

5/2007- 8/2010

•Project Coordination/Management, User Requirements analysis, SQL Server Developer and DBA duties. Data Warehousing/BI, Reporting, SSIS, Database Design and Redesign. Production and development support and DBA functions, including SQL Server 2000, 2005, and 2008 installations, backups, DR (Disaster Recovery) Plans, migrating databases from SQL Server 2000 to 2005 and Oracle. Database Performance analysis and enhancement. Systems

redesign, and QA of redesigned solutions. Data Mining and BI Solutions Architecture and Optimization. T-SQL, PL/SQL, and OOP Development. More than 50% of work was done in a remote/telecommuting setting in an extended team.

•QA TESTING and hands-on code enhancements and bug fixing throughout the entire project lifecycle with focus on reporting layer. Resolved numerous issues with end-user and customers, both technical and business. Networked with a small team (2 to 4 developers) in joint efforts to implement a Legal Case Management report engine (MSSQL, Oracle, Java, SQL, HQL). Conducted the full process of data mapping and data migration (MS SQL Server, Oracle, XML, Reporting system redesign and enhancements).

SQL SERVER DBA

IMS HEALTH (PLYMOUTH MEETING, PA)

11/2006 – 02/2007

•As a part of the DBA team, performed production support and core DBA functions, such as Performance Analysis and Query Optimization, installations of SQL Server 2000 and 2005, creating standards and practices documentation, managing database users and security, data modeling and database design, as well as overall environment monitoring and fulfilling data migration requests of various business segments within the company.

SQL SERVER DBA (DTS Admin)

CONSULTANT THROUGH TEKSYSTEMS, INC.; CLIENT: TYCO INTERNATIONAL, INC. (PRINCETON, NJ)

10/2005 – 10/2006

Business Intelligence (BI) solutions for Financial Reporting and Auditing. OLAP/Data Analysis. Cognos 7.

•Designed, coded, monitored, enhanced, and supported Risk Control Tracking System (RCTS), including Datamart (MS SQL Server 2000, Cognos 7), a cumulative system containing daily information from six major segments of Tyco for SOx assessments/auditing and corporate headquarters’ financial reporting purposes. Utilized efficient combination of business analysis and systems architecture and programming (T-SQL, VB, ASP, .NET). Redesigned and improved a multi-faceted Datamart loading process (ETL tool: DTS). Coached junior developers and advanced users. Delivered comprehensive SQL Instruction course for departmental managers and directors.

DATABASE SPECIALIST

CLIENT: TELEGLOBE, INC. (PRINCETON, NJ)

10/2004 – 8/2005

•SQL Server DBA and Developer duties. .NET Programming. Evaluated overall performance of the AutoADDDNIS system, originally designed to test new international call placement provider lines and area codes. Estimated projected systems re-design efforts and technical steps. Proposed and documented the new architecture.

Pursuant to time and resource estimate, prototyped and coded the new software using Transact-SQL (primarily stored procedures programming), ASP.NET/C# middle tier and presentation layer, and the existing Teleglobe proprietary subsystems.

SENIOR INTEGRATION SPECIALIST

ACSIS, INC. (MARLTON, NJ)

7/2002 – 8/2004

•As Database Analyst, Programmer and DBA Supported over 50 SQL Servers located worldwide. As an Integrator and Developer participated in full life cycle of software development. Data Architecture, Performance Analysis, Transact-SQL and PL/SQL Programming and DBA (50%), .NET/VB/C#/ASP Programming and Project Lead (25%), integration/PM (25%)

•Designed a solution to safely collect information in production run-time, save and transform data and metadata for further analysis. Coded SQL Task Manager utility (VB 6), which allows client managers to monitor SQL Agent Jobs and DTS Packages, scheduled for recurrent execution. Wrote a utility application that provided DBAs and Project Management Personnel with fast database comparison functionality (faster than RedGate software tools and most of other tools available on the market).

•Designed and fine-tuned new databases, and wrote an RFID Config Reporting tool in C# (C#, XML, SQL, MS Excel).

•Noted as a good communicator and earnest learner. Extensive Software Integration practices in Matrix Teams.

PROGRAMMER/ANALYST

APS FINANCIAL (JENKINTOWN, PA)

7/2001 – 7/2002

•Type of applications: Internet Marketing and E-Commerce, Financial and Billing programs and SQL Server 2000 RDBMS (programming, design, data modeling, and Application DBA). Marketing Lead Processing System: Auto Responder Email business objects. Implemented System Architecture. Involved in planning, and hands-on development. Primary technologies: ASP, VB 6, SQL Server 2000, COM, SOAP, COM+, XML, and VB.NET. Responsible for overall system and project documentation and production turnover.

SYBASE SQL SERVER DBA

BRANDYWINE TECHNOLOGY PARTNERS (DE)

CLIENT: WEFA/ HIS GLOBAL INSIGHT

10/2000 – 6/2001

•DBA with Application analysis and hands-on development: Environment: ColdFusion, ASP, VB 6, JavaScript, and XML. Sybase Adaptive Server. Designed and coded the XPAT software used internally for extracting multi-spreadsheet Excel data (building in-memory hierarchies into XML DOM and displaying the dynamic tree in a GUI treeview controls and saving it to XML files upon user verification). XDLoader application: Wrote stored procedures processing hierarchical structures.

EDUCATION

1990 -1995 – Dnipro State University and Kiev Technical University (USSR/Ukraine); B.S. Degree in Computer Science.

Special Talents and Abilities:

Master Level Chess player and coach, Data Science and BI Concepts instructor;

Knowledge of 5 human foreign languages and ability to work with 6 programming languages;

Current ON-GOING learning:

Embarking on a learning journey/new and on-going learning curve:

* Python and Machine Learning;

* New (advanced) features of SQL Server 2019 and their further evolution in version 2022;

* MS Visual Studio 2022.

Contact this candidate