Senior Database Architect and Data Engineering Leader

Konstantin Besschetnov

+1-339-***-**** ************@*****.*** Needham, MA 02494

SUMMARY

●15+ years of experience with various database systems: Oracle, MS SQL, PostgreSQL, Vertica, MySQL, Snowflake, Sybase, Teradata, DB2, MariaDB, MongoDB, DynamoDB, etc.

●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, business intelligence, data warehousing, data modeling, database analysis, system design, data modeling, schema conversion, data integration, ETL, SQL 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: AWS (EC2, S3, RDS, Lambda, Glue), GCP (GKE, GCK, SQL), Azure, Oracle

Tools: Power BI, ODI, OBIEE, SSIS, SSAS, Erwin, Power Designer, Toad, SQL Developer, Designer, Forms, Reports, GoldenGate, Informatica, Pentaho, Talend, InfoArchive, AppBuilder, Tableau, Terraform, GitHub, Splunk, Nagios, TFS, JIRA, Jenkins

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

Addison Group Remote March 2025 – Current

Senior Database Engineer

Database support of a critical application for a large-scale enterprise technology organization in the financial services space Detailed understanding of database design and business requirements; implementation of robust and scalable database architecture for high-performance systems

Database performance improvement and optimization:

- Identified system bottlenecks and suggested appropriate optimal changes to database schemas

- Analyzed and optimized T-SQL stored procedures for performance, ensuring high efficiency and scalability.

- Refactored and rewrote poorly performing SQL queries into efficient, scalable, and optimized code

Freelance / Consulting Remote October 2023 – February 2025

Database Engineer / Consultant

Worked on various short-term projects (on prem and cloud), including but not limited to:

- Database migration, upgrade, schema conversion, ETL/ELT, replication, complex stream and/or batch data integration solutions (ODI) for various databases: Oracle, PostgreSQL, MS SQL, MySQL, Vertica, 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-December 2023

Principal Database Engineer

As a key member of the Data Archiving team working in Agile/Scrum environment:

Set objectives and strategies; defined KPIs; identified risks and supported change management processes, prepared SOPs for archiving and decommissioning of the corporate legacy applications.

Lead the design and implemented the enterprise data archiving solutions using OpenText InfoArchive / AppBuilder.

Worked closely with business and technical teams gathering requirements (retention policies, role-based permissions, data encryption, customized searches, GUI's look and feel, user acceptance tests, etc.), estimating efforts and coordinating on timelines and delivery deadlines, documenting architecture, creating detailed design, and defining implementation plans.

Created table archives to migrate structured data in application tables and linked files from transaction systems.

Used SIP data model (based on OAIS) to ingest structured, semi-structured, and unstructured data into SIP archives (file, data-record, and compound-records archives).

Provided database administration and support for various RDBMS platforms (Oracle, SQL Server, PostgreSQL, DB2, etc.) Monitored archiving batches, Power BI reports, and retention policy compliance

Acted as a point of contact for access to archived legacy data

Prepared and maintained white papers, user training materials, and project documentation.

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; solved database performance problems, architectural challenges, and production issues

As a developer, personally completed design, development, and deployment of 6 custom InfoArchive applications.

As a separate project, the team completed a full upgrade of InfoArchive with migration of components from on-prem to the cloud.

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.

As a part of the 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.

Helped developers to create and optimize program code for various database applications in Agile/Scrum environment:

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 systems across a range of database platforms.

Installed, maintained databases, and 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-today 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 a full software development lifecycle within the Agile/Scrum environment.

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

Worked with product managers and business analysts in translating business requirements into high level functional design specification.

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

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 capacity planning, backup/recovery, export/import, database connectivity, database refresh, data cleansing, de-duplication, etc. Communicated and managed change 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 Power BI reports, 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 Sanofi's cross-functional business Subject Matter Experts and other technical resources to ensure the proposed design is well communicated.

Performed Oracle database enhancement tasks including but not limited to database tuning, capacity planning, data replication,

creating partitioned tables, customized views, materialized views and database links, writing complex SQL queries, stored PL/SQL program units, SQL scripts, Power BI dashboards and reports, ETL/data integration jobs to efficiently extract data from the data warehouse environment, etc.

Conducted performance improvement and tuning of the developed solution to ensure that requirements are met Communicated and managed change in requirements over the project life cycle; partnered with the project manager 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 different scheduled and ongoing tasks, including, but not limited to server installation, patching, database creation, user initialization and data export/import, deployment of customized applications or sandbox schemas as appropriate.

According to the 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.

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

Within the Mergers and Acquisitions team took responsibilities 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.

Performed data quality check for migrated / newly created databases.

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 the 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 (Ab Initio)

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: 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: International Institute of Education, 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