Ivan Ciobotar

Phone: 732-***-****

E-mail: adir1u@r.postjobfree.com

Summary

Senior Oracle Database Professional with over 20 years of progressively increasing responsibilities and accomplishments in the areas of data management and enterprise software development, with hands-on experience in leading effective and scalable development teams; Proven skills in designing, developing, tuning, and supporting databases for business and financial applications; Affirmed ability to constructively communicate with teams of technology staff, executive management, clients and vendors across projects.

Professional Experience

Senior Database Developer

Biswas Information Technology Solutions Inc, Herndon, NA (October 2020 – Present)

Build a flexible and scalable architecture, build data models (physical and logical) with data dictionaries;

Migrate data from legacy system to Oracle database in Cloud environment;

Develop ETL processes, custom query for data load process, SQL Loader, Oracle utilities, or use third party ETL tool to upload data;

Develop applications using quality and efficient SQL and PL/SQL code;

Write Stored Procedure, Packages, Functions, Triggers, Views, including Oracle 12C features;

Tune SQL and PL/SQL code to improve performance of the applications;

Provide technical support related to database processes, data entry and data extraction as well as general software inquiries;

Interact with web developers to assist building front-end applications.

Senior Database Engineer

DATA INC, Edison, NJ (Consultant at Bank of America, NYC, NY) (September 2018 – September 2020)

Working on enhancing and maintaining the consolidated, firm wide repository of risk-related data, used by internal and external consumer groups, with purpose of delivering a unified Authorized Data Source (ADS) for accounting, price verification, reporting and attribution, and Business Intelligence (BI);

Integrated, merged, and rewrote existing PL/SQL and Python code base to be used across multiple domains;

Wrote new PL/SQL packages and Python code modules for table partitioning, statistics management, historical data purging, data copy between databases, and tablespace management;

Redesigned and implemented permissions sets for PL/SQL objects;

SQL query performance tuning on Oracle 12c Exadata using parallel processing, bush filtering, restructuring, hints, SQL Monitor Report, and Optimizer statistics maintenance;

Delivered Python modules for database maintenance jobs, configuration of job templates and schedules;

Mentoring and overseeing development efforts of a team of database programmers transitioning from other platforms;

Involved in implementation of Lean Agile practices to software development life cycle (SDLC);

Closely engaged in code promotion throughout environments, from development to production releases;

Participated in assessing functional business requirements for new features and their impact on existing modules and applications.

Senior Database Developer

Vitech Systems Group, NY, NY (August 2011 – August 2018, May 2004 – August 2006)

Re-wrote client's pension calculation batch while applying innovating approaches to improve efficiency of database calls, bulk fetching and caching of intermediate data, and modularizing the code. Applied object-oriented techniques for communication between APIs. As a result improved batch's efficiency by cutting its execution time by 72%, allowed client to implement process logging and debugging;

Implemented checking of compiled PostgreSQL PL/pgSQL code for run-time errors. This improved system's reliability by avoiding crashes due to untested APIs, and lowered costs related to system stagnation while problems were remedied;

Responsible for developing, implementing, and supporting of back-end program modules for mission critical enterprise system that offers Pension and Retirement, Healthcare Insurance, Claims, Payroll, Billing, Enrollment and Financial Accounting business modules as well as CRM, Self Service, Workflow, Imaging, Reporting, Data Analytics, Audits, Contracts, Disbursement, Tax, Document, Security and System Interface service modules;

Maintaining a high number of in-house and client Oracle (10g, 11g, and 12c) and PostgreSQL (9.6) databases;

Technical and tutoring leadership among teams of Oracle and PostgreSQL developers (product and client). Making major design and implementation decisions on all aspects of DB related components;

Writing software specifications, application prototypes and templates, code standardization guidelines and documentation;

Schema design and engineering, creating entity relationship diagrams using tools such as PL/SQL Developer from Allround Automations, SQL Developer from Oracle, ERWin Data Modeler;

Coding PL/SQL and PL/pgSQL objects to encapsulate modules grouped by application entities and subject areas. Introduction and promoting of object-oriented methodologies in procedural coding;

Performance tuning of SQL using UTL_XPLAN, Cost-based Optimizer statistics, hints, index redesign, table partitioning;

Performance tuning of PL/SQL using DBMS_PROFILER, DBMS_HPROF, code restructuring, data caching in PL/SQL packages, function result caching;

Involved in end-to-end testing, profiling, code coverage, debugging, troubleshooting and code inspection;

Monitoring and maintaining database scheduled jobs using DBMS_JOBS;

Developed in-house ETL processes (using PL/SQL packages) to move clients' data into staging schema.

Manager of Data Services/Senior Database Architect

Atypon Systems, Inc., NY, NY (November 2008 – August 2011)

Macrovision Solutions Corporation - Rovi Corporation, NY, NY (August 2006 – November 2008)

Actively participating in the entire life cycle of department's primary software application, RightSuite, providing hands-on expertise in design, development, installation, and support for the database related aspects.

The application, an Online Content Access and Management System, requires well tuned On-Line Transaction Processing (OLTP) mechanisms and well organized background processing modules:

Stand-alone SQL queries, stored in XML;

Database procedural code, written in PL/SQL (triggers, procedures, functions, and packages, built-in as well as user-defined modules) or static Java classes;

Scheduled jobs written as PL/SQL packages or Java.

Most client installation projects require a data load/migration phase, which is implemented using a set of reusable SQL*Plus scripts, employing utilities such as SQL*Loader, External Tables, Dynamic SQL, Import/Export, Data Pump, data load acceleration tactics (INSERT ALL, MERGE), etc.

Implementing custom adjustments to the core application often requires changes to non-core database objects (altering tables, column, and constraints, data objects partitioning), SQL Tuning (indexing, statistics, Explain Plan, optimizer hints, and tracing), additional SQL queries and PL/SQL objects.

Application's reporting module requires porting the data from production database into the reporting database, implemented using Pentaho Data Integration (Kettle), and Extract, Transform, and Load (ETL) utility.

Reporting schema is implemented using Data Warehouse Star Schema architecture.

My additional responsibilities included:

Customer's data analysis and documentation for load/migration purposes;

Estimation of impact from database related aspects on installation project's timeline, providing feedback to Project Managers and QA Analysts on solutions, priorities, scope, resource allocation, risk management and client expectations;

Direct interaction with customer's database development and support teams for knowledge transfer and support;

Delivering database code translation for Microsoft SQL Server databases

Leading efforts to adopt best practices for database code design and programming;

Mentoring developers of various teams on Oracle and SQL subjects.

Senior Oracle Database Engineer

Concentra Integrated Services, NY, NY (August 2001 – May 2004)

Managed a full cycle of design, development, implementation and support of the back-end (Oracle 8i and 9i) of a three-tier application, while leading a group of four database developers, supporting company's Oracle infrastructure. The databases served as a data repository of all application entities, communicating with the middle-tier via a multitude of PL/SQL packages, communicated to a WebLogic Server via JDBC modules, delivering services for Medical Insurance Claim processing and Independent Medical Evaluation workflow.

Programmer / Developer / System Analyst

Associated Press, NY, NY (February 2000 – August 2001)

Involved in re-engineering, implementation, and support of the Freelancer Payment System Application designed to generate payment checks and transaction reports (related to rewarding freelancers for posting their news with our company). The final release of the application contains sophisticated stored packages (using PL/SQL), as well as database scripts (SQL, SQL*Plus, Export / Import, SQL*Loader), forms and reports, using Developer 2000 (Forms 6i / 4.5 and Reports 6i / 2.5). The application also contained Pro*COBOL code that I translated into PL/SQL.

Programmer / Analyst

Seaman's Furniture, Woodbury, NY (November 1998 – February 2000)

Worked on design and implementation of the Customer Service System Application, and Parts System Application, containing numerous system scripts written using Oracle's SQL, PL/SQL and SQL*Plus languages, forms and report submission screens, using Developer 2000/Forms 5.0, and reports using Pro*C language. The application provided a fast and easy way in entering and finding information and reports on written sales and exchanges, setting up services and order parts for existing customers.

Technical Background

Architecture

Service Oriented Architecture, Client Server, Web Based Three Tier, VMWare

RDBMS

Oracle PL/SQL, schema and non-schema objects design, implementation, and maintenance. Tutoring, promoting, implementing, and overseeing of best practices.

PostgreSQL PL/pgSQL translation from Oracle PL/SQL.

Microsoft SQL Server. Database and user configuration, schema objects maintenance

Software

Oracle SQL, PL/SQL, Performance Tuning (Code Profiling, Statspack, TKPROF, Database Traces, Wait Events), SQL*Plus (scripting), SQL*Loader, Import/Export, Data Pump, Python 2 and 3, static Java classes;

PostgreSQL: PL/pgSQL, tuning, plpgsql_check, plprofiler;

Microsoft SQL Server, SQL, T-SQL;

IDE: Allroundautomations PL/SQL Developer, RazorSQL, Oracle SQL Developer, Embarcadero DBArtisan, Embarcadero Rapid SQL, Quest Toad, CA ERWin, DB Designer Fork, Pentaho Data Integration (Kettle);

Management Tools: Microsoft Project, Word, Excel, Powerpoint, Visio, PVCS, Subversion, Visual Source Safe, WinCVS,

Operating System

Microsoft Windows, Linux, Unix, VAX

Education / Certification / Courses

Oracle 10g SQL Tuning Course

Oracle University, May 2006

Advanced course for Oracle DBA

New Age Training, Inc., New York, NY, 2000 – 2001

Advanced course of C, C++, and Unix

Digital Edge, Inc., Brooklyn, NY, 1999

Advanced Oracle SQL and PL/SQL, Forms 2000

New Age Training, Inc., New York, NY, 1997-1998

Member of New York Oracle User Group since 2006.

References

Will be furnished upon request.

Contact this candidate