Be A Data Integration

Konstantin Besschetnov

Phone: +1-339-***-**** E-mail: ************@*****.*** Needham, MA

SUMMARY

15+ years of experience with various database management systems, relational and NoSQL.

Seasoned specialist, working in various database environments with complex business-critical applications.

Areas of expertise include numerous industries: utilities, travel, healthcare, insurance, finances, telecommunications, state government agencies, etc.

Highly skilled in database administration, data strategy, database architecture, database analysis, system design, data modeling, schema conversion, data integration, ETL, query tuning, performance improvement, etc.

Very strong in database application development, database programming, and scripting.

Demonstrated analytical mentality, excellent problem-solving and troubleshooting skills, adaptability, and willingness to learn.

SKILLS

Databases: Oracle, MS SQL, PostgreSQL, Vertica, Sybase, Teradata, DB2, MySQL, Snowflake, MongoDB, DynamoDB, CosmosDB

Technologies: Oracle (ASM, RAC, Data Guard, Streams, IDE), AWS (RDS, EC2, S3), GCP (GKE, GCK), Azure

Tools: OEM, SQL Developer, Toad, APEX, Designer, Erwin, Power Designer, ER/Studio, ODI, GoldenGate, Informatica, Pentaho, Talend, InfoArchive, Databricks, Terraform, GitHub, Bitbucket, Kafka, Splunk, TFS, JIRA, Jenkins, Tableau, Boomi, Nagios

Languages: SQL, PL/SQL, PL/pgSQL, T-SQL, shells, Python, COBOL, C/C++, JavaScript

Operating Systems: Linux; UNIX; Mac OS X; Windows

EDUCATION

SPbU

M.S. - Mathematics / Mechanics B.S. - Computer Science

CERTIFICATIONS

Oracle Certified Professional (OCP)

Intensive Cloud Computing Hands-on Training (AWS, Azure, GCP, OCI)

Multi-Cloud, DevOps & AI Intensive Workshop (AWS, Azure, GCP)

Microsoft Azure for Data Engineering

WORK EXPERIENCE

Self-employed October 2023 - Current

Database Engineer / Consultant / SME

Work on various short-term projects (on-prem and cloud), performing the following tasks:

Database migration, upgrade, schema conversion, ETL/ELT, data integration for various databases: Oracle, PostgreSQL, MS SQL, MySQL, Snowflake, etc.

Performance improvement, SQL query tuning, shell scripting

Automated provisioning of EC2 workstations with Terraform and Claude

Deployment of cloud applications (Frontend & Backend) on AWS EKS cluster with Docker

Development of AI assistants using OpenAI and Amazon Bedrock

DevOps automation with CI/CD on the cloud platform

Implementation of multi-cloud solutions with AWS, GCP and Azure

National Grid Waltham, MA June 2022-September 2023

Principal Database Engineer

As a member of the Data Archiving team, worked in Agile/Scrum environment on various projects

Set objectives, strategies, plans; defined KPIs; established standards and procedures for analyzing and archiving corporate legacy applications.

Worked with Lines of Business partners and IT stakeholders to identify, define and clarify archive requirements; liaison with customers to ensure that delivery is as per agreed requirements and expectations.

Provided ongoing support for OpenText InfoArchive applications and services; including but not limited to components installation, system administration, and configuration for enterprise scale deployment in Prod/PreProd environments; performs daily system checkup and disk space monitoring.

Performed extraction and transformation of data from multiple data sources (legacy systems), combining into a single, consistent data store (archive).

Completed design, development, and deployment of 6 InfoArchive applications meeting project timelines.

Solved database performance problems, architectural challenges, and production issues.

SSG Needham, MA October 2021-April 2022

Sr. Database Administrator

Provided database support for various company's projects in the healthcare industry.

Installed, maintained, supported corporate databases: Oracle, MS SQL, PostgreSQL, etc.

Within DevOps team played a key role in the process of setting objectives, strategies, plans, performance standards/measures, and procedures.

Solved complex performance problems, architectural challenges, and production issues, ensuring high availability of critical database systems and services.

Performed overall database design and schema conversion; formulated data strategy for migration from on-premises to cloud platform (AWS/RDS)

Helped developers to modify and optimize program code for various database applications: SQL, PL/SQL, T-SQL, PL/pgSQL, shell scripting, etc.

Built complex ETL data integration jobs across a wide range of database platforms using AWS (RDS, DMS, SCT), Pentaho, etc.

OCTO Telematics, N.A. Newton, MA October 2018-June 2021

Sr. Database Engineer

Built complex distributed ETL/Data Integration IOT systems across a wide range of database platforms.

Created logical and physical data models, generated DDL scrips, developed program code for Oracle and BigData databases.

Solved complex performance problems, architectural challenges, and production issues.

Set up scheduler jobs on Linux servers for data automation and quality analysis.

Was responsible for ensuring high availability of critical database systems and services.

Performed development, implementation, and testing of failover and disaster recovery plans for all critical database systems.

Wrote complex SQL queries for data extraction, automation, and data quality analysis.

As a member of the IT Operations team, participated in the process of setting objectives, strategies, plans, programs, performance standards/measures, and procedures.

Participated in on-call rotation for system administration level 2 support including but not limited to weekends, holidays and after-business hours required to service business needs.

Performed ad-hoc duties as needed such as collaborating with management to create reports about business and operative KPIs measurement.

Stanford Technology Partners New Bedford, MA July 2018-August 2018

Sr. Database Engineer

Client: Infogroup

Designed, coded, and tested major features, as well as analyzed data needs and independently developed logical and physical data models with varying degrees of complexity and scale.

Developed SQL and shell scripts and PL/SQL program units for data auditing and automation.

Performed code review and provided complex software enhancements for CRM, MDM, BI

Designed and developed scalable and reusable ETL/data integration jobs (Talend) with massive data processing.

Constructed and designed documentation to aid in maintenance and code reuse in accordance with team processes and standards.

Verscend Waltham, MA January 2018-June 2018

Sr. Database Administrator

Performed installation and upgrade of enterprise database management systems: Oracle, MS SQL, Vertica, etc.

Performed monitoring, troubleshooting and root-cause analysis of database related issues in support of critical day-to-day business operations.

Established and enforced consistent database standards, access protocols, profiling, benchmarking, development, execution, and measurement of effective service level agreements.

Ensured high availability of critical database systems and services and development, implementation and testing of failover and recovery plans for all critical database systems.

Provided database administration and support as required to service business needs.

SRI Infotech Quincy, MA October 2016-January 2018

Sr. Database Engineer

Client: State Street Bank

Worked on a global team with offshore development engineers participating in full software development lifecycle within Agile/Scrum environment.

Responded to technical requests and directions from VPs, providing technical database design recommendations to management.

Worked with product owners and business analysts in translating business requirements into high level functional design specifications.

Conducted project design and application code reviews, made best design and implementation decisions to ensure quality and efficiency.

Created conceptual, logical, physical data models, synchronized data models and implemented databases by running DDL scripts.

Performed customized SQL and PL/SQL development tasks, query performance tuning, including execution plan improvement, running AWR reports, SQL monitoring, analyzing tables, gathering statistics, using indexing techniques, etc.

Analyzed, debugged, and resolved database application performance issues and developed solutions running AWR reports, SQL monitoring, analyzing tables, gathering statistics, using Oracle SPM baselines, SQL Profiles, indexing techniques, etc.

Tibersoft Westborough, MA April 2016-June 2016

Sr. Database Administrator

Performed database administration and maintenance tasks including but not limited to database capacity planning, gap analyses, export/import, connectivity, data mining, data cleansing, de-duplication, etc.

Communicated and managed changes in requirements over the project life cycle translating nontechnical business requirements into technical action plans.

Conducted performance improvement and tuning of SQL queries and PL/SQL program units.

Modified ETL/data integration jobs (Pentaho) to efficiently process data warehouse data.

Radiant Systems Westborough, MA September 2015-March 2016

Sr. Database Engineer

Client: Sanofi

Implemented design and system enhancement for the company’s Process Data Warehouse (PDW).

Analyzed the existing PDW Oracle database, identifying and resolving areas of risk related to design modifications.

Produced technical specifications with proposed modifications based on the system requirements.

Worked closely with stakeholders, business subject matter experts to ensure the proposed design is well communicated.

Created conceptual, logical, physical data models, supported model implementation and wrote DDL scripts.

Synchronized data models and implemented databases to identify implementation completeness and identify any gaps.

Performed Oracle database enhancement tasks including but not limited to data modeling, performance improvement and tuning, capacity planning, data replication, schema conversion, creating partitioned tables, customized views, materialized views and database links, writing complex SQL queries, stored PL/SQL program units, SQL scripts, ETL/data integration jobs to efficiently extract data from the data warehouse environment, etc.

Communicated and managed changes in requirements over the project life cycle; partnered with the project managers to assess the impact on the project scope.

Generated test data and test scenarios, executed the test scripts, recorded the deviations and drove their resolution and closures.

Contributed to the creation or update of the business and IS related standard operating procedures (SOPs), standard work instructions (SWIs), training materials, etc. as needed for implementation of the new functionality and corresponding processes.

As a primary Oracle SME, provided knowledge transfer to the Sanofi technical personnel.

Google Inc Cambridge, MA April 2011-September 2015

Sr. Database Engineer

Performed various scheduled and ongoing tasks, including, but not limited to server installation, patching, database creation, schema conversion, user initialization and data export/import, deployment of customized applications.

According to rotation schedule worked as an on-call DBA: performed all SOP database activities for the Ops team, Tier 3 support for the SOC and engineering support, when requested.

Monitored database upgrade progress during deployment process, responded in timely fashion to the raised problems; escalated issues appropriately when necessary; reported discovered bugs.

Formulated data strategy and system architecture for database transformation (AWS/RDS).

Installed new database servers, set up data replication between new databases and replication hubs.

Within the Mergers and Acquisitions team took responsibility for all newly acquired environments, maintaining and supporting databases until their transition to Google stack.

Performed migration / merge of legacy database servers to new database servers (Oracle, MS SQL, Vertica, PostgreSQL, Sybase, Teradata, DB2, MySQL, Snowflake, MongoDB, etc.).

Created new and modified existing ETL/data integration jobs using ODI, Data Pump, SQL*Loader, SSIS, Ab Initio, Informatica, Pentaho, etc.

Worked on improvement and tuning of SQL, PL/SQL, PL/pgSQL and T-SQL code.

Improved database performance for very large databases (multi-terabytes).

ITA Software Cambridge, MA July 2008-April 2011

Sr. Database Administrator

Performed server installation, patching, database creation, user initialization and data export/import, deployment of customized applications or sandbox schemas as appropriate.

Worked as an on-call DBA: performed all necessary database activities for the Ops team, Tier 3 support for the SOC and engineering support; performed quality check for newly created databases (Oracle, MS SQL, PostgreSQL, MySQL, etc.).

Completed formal training on PostgreSQL and performed database support for company's environment on rotation schedule.

Monitored database upgrade progress during deployment process, responded in timely fashion to the raised problems; escalated issues appropriately when necessary; reported discovered bugs.

Fulfilled various customized development tasks: suggested and implemented solutions for RAC, wrote shell scripts to execute any administrative tasks, created a sophisticated code-parsing tool to analyze and modify existing program code, worked on performance improvement and tuning.

Performed code review, acting as a primary responder for code change approval requests: validated structural integrity, data consistency and database security, raised concerns regarding potential implications; performed knowledge transfer, walking other DBAs through the whole database requirements review process.

Maintained distributable DBA libraries of SQL/PL/SQL code and shell scripts created by DBAs for diagnostics and administration purposes; worked on enhancements to existing sandbox management application code for deployment.

Auriga, Inc Boston, MA March 2005-June 2008

Database Consultant

Clients/Projects:

Sun Microsystems - Oracle database tuning and performance improvement in data warehouse environment

Philips - Enterprise database system support and enhancement

Verispan, LLC - Data Warehouse / Data Mart support and development

Hartford Life - Database support of full batch cycle for business applications in Prod/QA/Dev environments (Informatica)

eCredit.com, Inc.- Data Processor – customized ETL data integration, verification and control system.

St. Paul Travelers - Multiple projects in various lines of business in a heterogeneous database environment

DCR, Commonwealth of Massachusetts - Administration and support of Oracle database and AS (Infrastructure and middle-tier)

iGate Mastech Springfield, MA September 2004-January 2005

Database Consultant

Client: MassMutual - Application system support for business lines and products of Retirement Services, Life Insurance

Auriga, Inc Boston, MA February 2004-July 2004

Database Consultant

Client: DOC, Commonwealth of Massachusetts - Data migration and massive upgrade of Oracle database and applications: Forms (300+), Reports (200+), PL/SQL programs (600+ triggers, 200+ packages, 500+ procedures/functions)

CTG, Inc Hartford, CT September 2002-January 2004

Systems Advisor

Client: The Hartford - Developed database applications for various lines of business (Informatica).

GRT Corp Stamford, CT April 2000-June 2002

Database Consultant

Clients: IIE, NextWave Wireless, Edgix Corp., RVI, Bell Atlantic DSG

Pacific Fund Systems Global July 1999-April 2000

Database Administrator / Architect / Developer

Created FFCS, the integrated system for hedge fund administration (pacificfundsystems.com) – MS SQL Server

Contact this candidate