Data Manager

GENNADY TAMAROV

Flushing, NY 201-***-**** adhor2@r.postjobfree.com

PROFESSIONAL PROFILE

Extensive experience utilizing the systems development life cycle as a SQL Server DBA / Developer in the pharmacy benefit management, insurance, telecommunications, nonprofit and financial industries.

Worked with all phases of data warehouse development lifecycle, including requirements gathering, design, implementation, and maintenance.

Analyzed, designed and supported SQL Server relational database management systems (RDBMS) that integrated to proprietary enterprise applications to improve data extraction, maintenance and security.

Proficient in data analysis, database design, SQL development, query tuning and index optimization.

TECHINICAL SKILLS

Languages:

SQL, T-SQL, Oracle PL/SQL, MS Visual Studio 8/ 10 Visual Basic 6.0, VBScript, VBA, JavaScript, HTML

RDBMS Software:

Accomplished SQL Server Database Administrator with in-depth experience in Database Administration, Software Project Management. In depth knowledge in stored procedures, SSIS, Database Designing, Database tuning. Back up & Recovery, Disaster Recovery Management.

SQL Server Business Intelligence Development Studio (BIDS) 2008/2012/2014/2016/2017

SQL Server Enterprise Manager/Query Analyzer, Oracle 9i/8i, MS Access 2007/2003/2013/2016

RDBMS Tools:

Red Gate SQL Data Compare 8/Dependency Tracker 2, IDERA & SolarWinds (Monitoring & Diagnostic tools), Cohesity – Backup Software

ETL:

SQL Server Integration Services (SSIS) 2008/2012/2014/2016/2017, SQL Server Data Transformation Services (DTS) 2000

Reporting: Software:

SQL Server Reporting Services (SSRS) 2008/2012/2014/2016/2017, SQL Server Report Builder (SSRS) 2012/2008/2014/2016/2017, Crystal Reports 11/9/8, Cognos, MS Access Reports, MS Excel Office 2013

Agile Skills:

Conducted bi-weekly agile sprints with teams sizes over 5+

Used Scrum Agile Methodology in my work (Weekly Scrum Meeting, Planning In-Place Upgrade, Migration, building new environment etc.)

Mentored team to follow best practices in agile and QA

Experience with Jira & Confluence

Operating Systems: Windows 10/7/XP/2000/NT

PROFESSIONAL EXPERIENCE

Express Scripts Inc. Franklyn Lake, NJ 05/2016-Present

SQL Server Database Administrator

Work is done remotely away from the standard office for the past 9 months.

Being adaptable and flexible has enabled me to challenge conventional ways of working and learn new and more efficient SQL Server techniques and diverse work style.

Provide development and design assistance to development and other application support teams

Provide technical leadership to development team thru project leadership and technical documentation

Establishes and builds strong working relations and partnerships with Business Units and Senior Management

Provides database assistance and problem support to application developers, business analysts and business users

Provides technical assistance and mentoring for staff for developing conceptual and logical database design and the physical database

Help developers improve the performance of that query by tweaking it or modifying indexes

Provides support in capacity planning, forecasting, and tuning. Develops performance/tuning evaluation reports

Serve as support for database administration tasks including configuration management, backup/recovery, performance optimization, and space management

Perform database deployments and provide support for application releases

Assist developers with MS SQL Server issues and questions

Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure

Plan and Lead database development, documentation and maintenance of databases including

In-Place Upgrade from SQL Server 2008R2 to 2012, 2014, 2016, 2017 & 2019

SQL Server migration from 2008R2 to 2012, 2014, 2016, 2017 & 2019

Provided & managed support to Environment of more than 350 Database Servers

Proven ability to handle Database of more than 3 TB in Size

Expertise in MSSQL SERVER Database Administration

Set up Log Shipping, Database Mirroring. Configured and Managed Always On Availability Groups for SQL Server 2016/2017

Managed security by defining roles and rights

Projects include:

SQL Server Upgrades, Migrations and building new SQL Servers.

Minimizing downtime during upgrades and migrations

Developing and delivering a details data migration plan

Managing the data and reporting analyst

Identifying the data migration impact of all proposed changes

Owning the quality of the migrated data and the validity of the migration processes and operation

Manage data migration workstream within the established project budgets and advise Project Manager of potential deviation

Provide timely status reporting to the Project Manager

Interpret and complete vendor provided data migration workbooks

As part of the project closure, evaluate and make recommendations for future improvements

Perform source system data analysis in order to manage source to target data mapping

Highly effective working in a team, as well as working independently

Capabilities:

·Experienced DBA with an ability to communicate effectively on a technical or personal level.

·Proficient Database Administrator.

·Configured Security features for Database & Server users for SQL Server.

Local Initiatives Support Corp., New York 10/2005-05/2016

DBA / Database Developer / Programmer Analyst

Lead Database Developer of the IT Department responsible for physical support and maintenance of all the database servers with a significant contribution towards reporting, backend application support, and database tuning of the company’s flagship products such as the Loan System (LMS), Program Action System, Invoice Allocation and EZ Reports. Some of the major responsibilities include advanced performance tuning, database design, capacity planning and establishing standards for SQL Server 2000-2005-2008-2012 installation, maintenance, tuning, and coding standards. Excellent knowledge in developing and designing reports through SSRS and Crystal Reports.

Scheduled DTS Packages for data extraction and loading using DTS in MS SQL Server 2000 and current use of SSIS in MS SQL Server 2005, 200*-****-**** to recalculate data, load Bulk Inserts and import/export requested information for business users.

Projects include:

Designed data warehouse schema and developed ETL transformations that sourced from a variety of heterogeneous sources (application systems, external vendor data, etc.) such as prior versions of SQL Server databases, Microsoft Access, and CSV files to load into a data warehouse repository in denormalized format for faster and reliable access for executive reporting purposes.

Designed and developed graphical reports in SSRS in contribution to company’s new Dashboard system.

Extended graphical report to provide drill-down data based on the selected area of the graph.

Migrated several production SQL Servers from SQL Server 7.0 platform to SQL server 2005; 2005 to 2008. The project included testing all stored procedures and triggers programmatically to compare the output and reconcile the differences in collation, syntax, etc. In addition, all DTS packages were recreated in SSIS.

Developed and designed DTS (SQL Server 2000) & SSIS (SQL Server 2005 or later) packages that provide automated database maintenance, backups, and tuning support.

Design, implementation and maintenance of largest financial data calculation that involves and affects multiple SQL Servers and application systems.

Debugged and modified Loan System (financial application) to add a few forms using VB 6.0. The objective of these forms was to provide users the ability to change interest rates of the loans independently.

Performed analysis of current optimization model and provided recommendations to move to SQL Server 2005 cost-based optimization. Lead the stress test initiative to evaluate the success of this approach.

Designed and implemented a web based solution in HTML and ASP for capturing and reporting Tasks Request Facility, Task Manager (database).

Designed and created control reports using SSIS on company’s financial data whenever a data discrepancy occurred between two or more systems or databases that need IT’s urgent attention. An email would be sent to the specified people in IT when discrepancy would occur. The purpose of the report is to capture a data pattern to address the source of the issue or fix data on issues that cannot be reproduced easily.

Responsibilities:

Create and modify T-SQL objects such as stored procedures, functions, tables, views and triggers for ETL processes, reports and applications on a regular basis.

Responsible for installation and configuration of SQL Server 2005; 2008; 2012; 2014.

Perform backups, restores and implement replication strategies.

Work with Microsoft ETL tools to architect and develop ETL designs.

Responsible for Architecting the Data Warehouse.

Tuned databases and SQL objects to improve performance of ETL loads.

Assist in logical and physical database design and implementation.

Developed VB & Java scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, etc.

Use RedGate for SQL Server to manage SQL or data changes during deployment from one server to another and commit them to source code.

Verizon Wireless, Morristown, NJ 07/2000-07/2005

Programmer/Analyst Consultant

Participated in development Hill Holliday Application used as a physical repository of information for multiple regions in the Northeast Area. (Collecting and analyzing data for various customer types based on recent customer activity using Visual Basic 6.0, CDO (Collaborate Data Object), VBScript, Teradata, Queryman, SQL Server 2000, Stored procedures, ETL, DTS Packages.)

The Enterprise Data Warehouse: A web based application to analyze data to discover patterns and predict customer behavior based on past activity using Cognos, Teradata, and Queryman.

Generate reports: with important performance measures in order to determine sales activity, usage and access statistics.

Prudential Securities, New York, NY 11/1998 – 07/2000

Programmer/Analyst Consultant

Worked on development of financial investment software packages. The applications were created as Graphical User Interface utilizing Visual Basic 5.0/6.0 and MS SQL Server 6.5/7.0 Database. The package allowed collecting customers’ personal and financial profiles, insurance and investment history. Developed multiple inquiry subsystem, which could be dynamically changed based on user’s needs. Coded, debugged, and tested customer data collection subsystem. Modified logic for investment-modeling program based on new production requirements, created and customized statistical reports using Crystal Reports. Created demo program which was a functional production application but with local MS Access Database instead of real data.

Selective Insurance Group, Inc., Branchville, NJ 10/1997 – 11/1998

Programmer Consultant

Participated in development of Claims Processing Subsystem. The system was created in Visual Basic 4.0/5.0 and MS SQL Server 6.0/6.5. Worked on Statistical Reporting part for Administration Subsystem, which allowed viewing territories, lists of agents, producers, banks, policy types, etc. Implemented various validation forms, error and statistical reports. Converted MS Access database application into MS SQL Server 6.5. Analyzed system adjustments to meet current production requirements.

DDCS International, New York, NY 08/1990 – 10/1997

Business Coordinator

For import - export international company worked as business coordinator/administrator. Was responsible for database maintenance using MS Access, sending correspondence to major clients in Eastern Europe and China. Other responsibilities included various administrative duties.

Training

SQL Server 2005 Database Administration

SQL Server 2005 SSIS, SSRS

Crystal Report Version 11.0

Visual Studio.Net, Advanced Visual Basic programming,

Advanced Visual Basic for Applications programming

Cognos Power Play, Power Cubes programming

Education 09/1976 – 06/1981

State University, Dushanbe, Tajikistan

M.S. in Economics, Minor in Mathematics

Contact this candidate