Konstantin Besschetnov

Needham, MA ***** ad4ubx@r.postjobfree.com +1-339-***-****

Summary

15+ years of experience with various database systems: Oracle, MS SQL, PostgreSQL, Vertica, MySQL, etc.

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

Areas of expertise include database systems in numerous industries: utilities, travel, healthcare, insurance, finance, telecommunications, state government agencies, etc.

Highly skilled in database administration, database analysis, system design, data modeling, schema conversion, 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.

Technical Skills

Databases: Oracle, MS SQL, PostgreSQL, Vertica, MySQL, Sybase, Teradata, MongoDB, etc.

Technologies: RAC, ASM, Data Guard, GoldenGate, BigData, AWS, GCP, Azure, CI/CD

Tools: Forms, Reports, OEM, SQL Developer, Toad, Oracle Designer, Erwin, Power Designer, Informatica, Pentaho, Talend, InfoArchive, Terraform, Git, TFS, JIRA, Jenkins

Languages: SQL, PL/SQL, T-SQL, PL/pgSQL, COBOL, XML, Python, Perl, shells

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

Certification

Certificate: Oracle Certified Professional (OCP)

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

Education

SPbU: M.S. - Mathematics & Mechanics / B.S. - Computer Science

Professional Experience

National Grid, Waltham, MA June 2022 – September 2023

Database Engineer

As a member of Data Archiving Team works in Agile/Scrum environment on various projects; sets objectives, strategies, plans; defines KPIs; establishes standards and procedures to analyze and archive decommissioned applications.

Works 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.

Provides 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.

Works on design, development, and deployment of InfoArchive applications as required to meet project timelines.

When working within Oracle database environments, created customized SQL queries and PL/SQL procedures to generate meta-data needed for further data processing and load into InfoArchive.

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

SSG, Needham, MA October 2021 – April 2022

Database Engineer

Provided database support for various company projects in the healthcare domain.

Installed, maintained, supported corporate database systems: Oracle (12c/19c), MS SQL (2014/2016), PostgreSQL, etc.

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

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

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

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.

Refactored and developed complex SQL queries for Oracle and PostgreSQL databases.

Built distributed ETL systems across a wide range of database platforms using various technologies (AWS, RDS, DMS, SCT, Pentaho, etc.)

Created complex jobs for data extraction, automation, and data quality analysis.

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

Database Engineer

Built distributed ETL systems across a range of database platforms and technologies

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.

Using refactoring approach 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, Bedford, MA July 2018 – August 2018

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 procedures for data auditing and automation.

Participated in code reviews and worked jointly with other team members to provide complex software enhancements for CRM, MDM, BI

Designed and developed scalable and reusable ETL jobs to perform complex database processes.

Constructed and designed documentation to aid in maintenance and code reuse in accordance with company’s standards.

Verscend., Waltham, MA January 2018 – June 2018

Sr. Database Engineer

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.

Participated in database administration support as required to service business needs.

SRI Infotech, Quincy, MA October 2016 – January 2018

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 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.

Refactored and developed complex SQL queries for Oracle databases.

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.

Tibersoft, Westborough, MA April 2016 – June 2016

Database Engineer

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 ETL routines to efficiently load and extract the data warehouse data.

Radiant Systems, Westborough, MA September 2015 – March 2016

Database Engineer

Client: Sanofi

Database design and system enhancement for the international pharmaceutical company

Analyzed the existing Process Data Warehouse (PDW) Oracle database, identified and managed areas of risk related to requirements and design.

Generated technical specifications that describe the proposed modifications to the system to meet the requirements.

Worked closely with Genzyme 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, creating partitioned tables, customized views, materialized views and database links, writing complex SQL queries, and PL/SQL program units, SQL scripts, ETL routines 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 Genzyme technical personnel.

Google Inc., Cambridge, MA April 2011 – September 2015

Database Engineer

Database administration, maintenance, support and system enhancement

Performed different scheduled and ongoing tasks, including, but not limited to server installation, patching, database creation, user initialization and data export/import.

Monitored multiple database environments, 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 hubs.

Performed migration / merge of legacy database servers to new database servers.

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, etc.)

Performed quality check for newly created databases.

Worked on performance improvement and tuning of PL/SQL and SQL code.

Improved performance for very large databases (multi-terabytes)

ITA Software, Cambridge, MA July 2008 – April 2011

Database Engineer

Database administration, maintenance, support, and system enhancement

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 rotation schedule worked as an on-call DBA: performed all necessary 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.

Performed various DBA customized development tasks: suggested and implemented solutions for RAC environment, wrote shell scripts to execute any administrative tasks.

Created a Code Processor, the sophisticated code-parsing tool to process / analyze/ modify all existed PL/SQL programs, which, in fact, allowed to automatically generate new PL/SQL code.

Performed code review, acted as 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 the code; modified existing sandbox management application code to be deployable and versioned like other database schemas.

Refactored complex SQL queries for Oracle and PostgreSQL databases.

Performed quality check for newly created databases.

Worked on performance improvement and tuning.

Auriga, Inc. March 2005 – June 2008

Database Consultant

Projects:

Sun Microsystems, Boston, MA

Oracle database tuning and performance improvement in data warehouse environment

Philips, Boston, MA

Enterprise database system support and enhancement

Verispan, LLC, Waltham, MA

Data Warehouse / Data Mart Support in a database environment with significant load of data Performed support for multiple data warehouse databases within Windows and UNIX environment (production, testing and development) targeted to improve the efficiency and effectives of pharmaceutical, medical/surgical and clinical development functions for healthcare industry.

Hartford Life, Windsor, CT

Database support in production/QA/development environments, monitoring and maintenance of full application batch cycle for various business applications

eCredit.com, Inc., Boston, MA

Data Processor – original customized verification and control system to load business critical data from different external data sources into Oracle database.

St. Paul Travelers, Hartford, CT

Multiple projects in various lines of business and products in a heterogeneous computing environment

Commonwealth of Massachusetts, Boston, MA

Database and application installation, upgrade, maintenance, and support for the Department’s Information System

iGate Mastech September 2004 – January 2005

Database Consultant

Client: MassMutual Financial Group, Springfield, MA

Application System support in a heterogeneous computing environment (development, testing and production) at various business lines and products of Retirement Services, Life Insurance

Performed technical system support for specific business applications.

As part of Bugs/Enhancements team and independently worked on code debugging, enhancements, and changes in accordance with on-going business requirements, following the established standards and technical specifications.

Fulfilled various tasks: SQL tuning, performance improvement, database analysis, troubleshooting and testing.

Wrote functional and technical specification based on system analysis and gathered business requirements.

Auriga, Inc. February 2004 – July 2004

Database Consultant

Client: Commonwealth of Massachusetts, Boston, MA

Database and application upgrade for the customer’s Information and Reporting System

A small team of 4, meeting aggressive deadline, implemented full Oracle database upgrade from version 8i to 9i; application upgrade (Forms 5 to 9i, Reports 3 to 9i) in a timely manner.

Developed a unique method for automatic bulk upgrade of Forms (300+) and Reports (200+)

Implemented reverse engineering using Oracle Designer

Fulfilled database analysis, data conversion, performance tuning, and troubleshooting.

Performed product installation, configuration, overall system support, migration, upgrade, re-hosting, testing, and patching.

Investigated and resolved all issues related to the transition from client-server to 3-tier architecture during the upgrade process.

Wrote/modified UNIX shell scripts, batch files for upgrade operations.

Completed all phases of application upgrade; tested, and deployed Oracle objects and program units (600+ tables, 600+ triggers, 200+ packages, 500+ stand-alone procedures/functions)

CTG, Inc. September 2002 – January 2004

Systems Advisor

Client: The Hartford Insurance Group, Hartford, CT

Different projects in various lines and products of Insurance business

Performed reverse engineering, database analysis and design, data modeling, system optimization, and performance improvements, and troubleshooting.

Supported user interfaces and produced site activity reports.

Upgraded / rewrote existing application code supporting database migration to new platforms.

Designed and developed complex solutions from customer’s business rules; translated analysis business/functional requirements into code.

Based on established application development standards, implemented system enhancements in accordance with customer’s business rules being translated into technical specifications.

Developed, modified, tested, and deployed hundreds of Oracle forms, reports, Pro*COBOL code, PL/SQL procedures, functions, packages, triggers, tables, SQL queries and views.

Wrote/modified ETL jobs, UNIX shell scripts, batch files.

Contact this candidate