We provide IT Staff Augmentation Services!

Senior Database Engineer, Senior Oracle Developer Resume

3.00/5 (Submit Your Rating)

Santa-clara, CA

SUMMARY:

  • I am looking for a Senior Oracle/BigData/NoSQL DBA or Senior Database Oracle/BigData/NoSQL Database Engineer position in a challenging environment where I can demonstrate my unique experience with the latest know - how
  • Oracle database technology and database software tools design and development. I have more than 24 years of extensive experience working as Senior Oracle DBA and Senior Oracle/BigData/NoSQL database engineer in production environments and IT consulting companies.
  • I am a well-known expert in Oracle IT community and a lead architect/developer of Oracle database tuning and monitoring software and tools for popular BigData NoSQL databases.
  • I am an author of Oracle10g performance tuning book published in the Aleksei has more than 24 years of experience in Oracle production database administration and support of very large, high-performance and highly available Oracle database systems including Oracle Real Application Cluster databases. I have a very good knowledge and skills in Oracle PL/SQL and Unix shell programming.
  • I used my unique Oracle database background and skills for design and development of software tools which are used by many companies for daily database monitoring, performance tuning and data migrations. Details are available on request.
  • I posses solid experience with setup, management, configuration and software development with Java for such BigData NoSQL database like MongoDB, Apache Cassandra, Apache Hadoop/HBase, CouchDB, Couchbase.
  • 20+ years of extensive experience with Oracle6/7/8/8i/9i/10g/11g/12c database systems under HPUX, Sun Solaris, RedHat AS Linux, Windows environments as Senior Oracle DBA and Senior Systems Engineer.
  • Strong Senior Oracle DBA skills supporting a large number of production databases in heterogonous unix/windows environments.
  • Solid experience and background with NoSQL MongoDB, Cassandra, Hadoop/HBase, CouchDB, Couchbase database management, tuning and troubleshooting.
  • Extensive experience in backend database logical and physical architecture for various application types from telecom to cloud based database services.
  • Strong experience and background in software application and tools design and development for relational Oracle and BigData NoSQL databases.
  • Aleksei is creator of popular Oracle tuning and monitoring tools (Statspack Viewer, Statspack Viewer Enterprise, dbTrends for Oracle, spAnalyzer, spReporter) based on STATSPACK and AWR performance data.
  • I have a strong background working as technical lead for a large number of Oracle database tuning projects. I performed application, SQL, and database instance tuning using a wide range of technologies including ADDM, AWR, STATSPACK, extended SQL trace (event 10046 trace files), OEM Performance Manager, and my custom scripts and software.
  • Aleksei created an automated, enterprise wide monitoring infrastructure using several key technologies including UNIX shell scripts, Windows shell scripts (WSH), my software package dbTrends for Oracle, and SQL. This allowed our operational DBA team to efficiently gather database metadata, exceptions, and performance statistics for remote clients running Oracle databases using a consolidated Intranet approach.
  • Aleksei is creator and developer of data migration software tools between Oracle and NoSQL databases such as MongoDB, Cassandra, Hadoop, CouchDB.
  • Strong background in design and Java development of ETL software for data warehouses based on Oracle and BigData NoSQL databases (MongoDB, Cassandra, Apache Hadoop).
  • Experience in support and configuration Oracle GoldenGate replication environments.
  • Strong skills and experience in administration and support of Oracle 8i/9i/10g/11g/12c Real Application Clusters for HP-UX and Red Hat Linux systems.
  • Strong background in Unix shell scripting (Shell, Bash).
  • Solid experience in design and support of datawarehouses sized > 100 TB and based on Oracle Exadata database machines.
  • Complete projects on limited timeframes. These projects will include evaluation of new Oracle technologies, certification of new hardware or storage, integration of Oracle with third-party applications etc.
  • Strong background in management and performance tuning of VLDB (very large database) systems.
  • A responsible team leader and player, creative self-starter, and a perfectionist always striving for technical excellence. Easy going down to earth personality pleases co-workers, management, and users.
  • Creativity and the ability to work well in a team.
  • Selection, adaptation and development of suitable extraction, transformation, load and test procedures.

PROFESSIONAL EXPERIENCE:

Senior Database Engineer, Senior Oracle Developer

Confidential, Santa-Clara, CA

Environment: Hardware:Intel x86 - 64, Sun SPARC, IBM PPC64 Operating system:RH Linux, Windows, Sun Solaris, AIX Database:Oracle 12.1.0, M12.2.0, MongoDB, CouchDB LanguagesJava 8/9, SWT, SQL, PL/SQL, Oracle WebLogic, Jboss, IBM WebSphere

Responsibilities:

  • As Senior Database Engineer and Senior Java Developer I architect and develop a unique product suite for database and application QA testing - Time Machine.
  • I architect and lead development of such Time machine products as TMConsole Enterprise, Sync Server, Time Machine Framework for Oracle, Time Machine Framework for Oracle WebLogic
  • Time Machine Framework for Jboss, Time Machine Framework for IBM WebSphere.
  • Design, consulting and implementation at customer sites high-availability solutions based on Oracle and MongoDB.
  • As Senior Oracle/NoSQL DBA I provide database related support and consulting services for company customers who use Oracle, SQL Server, MongoDB, Cassandra, CouchDB
  • Couchbase and other relational and NoSQL databases in production environments

Senior Oracle/BigData Datawarehouse Database Engineer

Confidential

Environment: Hardware:Intel x86 - 64, Sun SPARC SuperCluster, Oracle11g Exadata Operating system:RH Linux, Sun Solaris Database:Oracle 11.2.0, 12.10, MongoDB 3.0 LanguagesJava, Unix Bash Scripting, SQL, PL/SQL

Responsibilities:
  • ApplicationsOracle GoldenGate, Informatica, ETL, Hadoop Ecosystem (HDFS, Hive, Spark, HBase, ML), NLP (natural language processing)
  • As a Senior Oracle DBA/BigData Datawarehouse Engineer I support and manage production Oracle11g Exadata based databases serving multiple very big Oracle based datawarehouses sized > 100 TB
  • I design, implement and manage ETL procedures using custom/Informatica based ETL procedures to load data from production databases to Oracle/BigData based data warehouses
  • I design and implement replication solution based on Oracle GoldenGate technology to extract data from different production data sources and load data to Oracle Exadata based data warehouse.
  • I design and implement high - available distributed cluster based solutions based on MongoDB technology.
  • As Senior Java Developer I develop and support backend Java-based ETL applications for Hadoop, data analysis routines suing Spark/Hive/NLP libraries.

Senior BigData Architect/Engineer, Oracle Database Expert, Principal Java Software Developer

Confidential

Environment: Hardware:Intel x86 - 64 Operating system:RH Linux, Windows, Sun Solaris, AIX Database:Oracle 11.2.0, 12.1.0, MongoDB 2.6, CouchbaseLanguagesJava, SQL, PL/SQL, Thrift, HiveQL, Hadoop Ecosystem products (HDFS, Hive, Spark, HBase)

Responsibilities:

  • Successfully performed various data migration projects from Oracle to NoSQL databases and consulting projects at customer sites using different ETL/data migration products .
  • Design, consulting and implementation at customer sites high - availability solutions based on MongoDB and Apache Hadoop clusters.
  • Data ETL/migration software development with Java.
  • Performance tuning and stress-testing of NoSQL database environments in order to ensure acceptable database performance in production mode.
  • Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high-availability in various crash scenarios.

Senior Oracle/MongoDB DBA, Senior Database Engineer

Confidential

Environment: Hardware:Intel x86 - 64 Operating system:RH Linux, Windows Database:Oracle 11.2.0, MongoDB 2.6 LanguagesJava, Unix Bash Scripting, SQL, PL/SQL

Responsibilities:

  • ApplicationsCustom migration software MongoDBPumper, NoSQL Viewer, shell scripts
  • As a Senior Oracle/MongoDB DBA I supported and managed production Oracle and MongoDB databases serving eCommerce platform for payments and data warehouses.
  • As a Senior Database Engineer I performed migration of production data between Oracle and data warehouse based on MongoDB distributed cluster to provide high
  • Performance BI analysis platform. I use my custom developed migration software and tools like MongoDBPumper and NoSQL Viewer.
  • I designed and implemented high-available distributed cluster based solutions based on MongoDB technology.
  • I was involved in backend database design and consulting for cloud-based e-commerce service.

Senior Oracle Team Leader/DBA, Senior MongoDB Database Engineer

Confidential

Environment: Hardware:Sparc SUN, Linux x86 - 64 Operating system:Solaris, RHAS, Windows Database:Oracle 11.2.0 RAC, MongoDB 2.2, Hadoop, MySQL LanguagesSQL, PL/SQL, Java ApplicationsOracle GoldenGate 11.1.1, Oracle Fusion, Telco Cloud Service

Responsibilities:

  • As a Senior Oracle/MongoDB DBA I supported and managed production Oracle/MongoDB databases serving telco real - time billing systems and data warehouses.
  • I designed and implemented high availability solutions for production databases under Oracle11g/MongoDB.
  • I managed, configured and troubleshooted Oracle GoldenGate replication environments in real-time telco environment.
  • I performed various performance tuning activities to improve operation of Oracle RAC databases in real-time telco and data warehouse environments.
  • I managed and configure production NoSQL. MongoDB databases. I transfer and integrate data between Oracle and MongoDB databases.
  • I supported, managed and troubleshooted production and development MySQL databases for telecom cloud SIP telephony system.
  • I was involved in development projects based on Oracle Fusion products like Data Integration and GoldenGate.

Oracle Team Leader, Principal Oracle DBA and Oracle Customer Care and Billing Administrator

Confidential

Environment: Hardware:HP Itanium, Linux x86 - 64 Operating system:HPUX, RHAS, Windows Database:Oracle 9.2.0, 10.2.0, 11.1.0, 11.2.0, MongoDB 2.2 LanguagesSQL, PL/SQL, Java ApplicationsOracle Customer Care & Billing 2.1.0, OEBS 12.0

Responsibilities:

  • As a technical department team leader and Senior Oracle DBA I supported and consulted local customers resolving their oracle database related questions and problems.
  • I perform various Oracle database administrator and Oracle expert tasks like performance tuning, expert advices, capacity planning, backup/recovery management, etc.
  • I remotely manage several terabyte - sized production databases in 24X7 environments.
  • I participated in installation, implementation and administration of Oracle Customer Care and Billing ERP application at a large local customer.
  • I managed a team of Oracle DBAs and consultants.
  • I performed migration of large 2Tb production Oracle database from Oracle9i to Oracle11g on HP Itanium Superdome server.
  • I configured Oracle10g/11g Data Guard environment to provide high-availability data protection.
  • I configured Oracle10g/11g Enterprise Manager Grid Control to monitor production databases.
  • I installed and tested the latest version of Oracle RAC 11gR2 on HP Itanium two nodes cluster.
  • Designed and implemented various high availability solutions for a diverse group of clients running Oracle9i, Oracle10g, and Oracle11g using Data Guard, RMAN, Oracle Real Application Clusters (RAC), Oracle Flashback, and LogMiner.
  • Technical lead for a large number of tuning projects. Performed application, SQL, and database instance tuning using a wide range of technologies including ADDM, AWR, Statspack, extended SQL trace (event 10046 trace files), OEM Performance Manager, and custom scripts.
  • Created an automated, enterprise wide monitoring infrastructure using several key technologies including UNIX shell scripts, Windows shell scripts (WSH), my software package dbTrends for Oracle, and SQL. This allowed our operational DBA team to efficiently gather database metadata, exceptions, and performance statistics for remote clients running Oracle databases using a consolidated Intranet approach.
  • Established and wrote the company s standards and best practices document for all Oracle database environments based on Oracle's Optimal Flexible Architecture (OFA).
  • This document outlined all standards for the DBA Operations Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, coding standards for Java and PL/SQL, policies, practices and procedures.

Oracle Team Leader, Principal Oracle Consultant and Senior Oracle DBA

Confidential

Environment: Hardware:Sun Sparc, Compaq Operating system:Sun Solaris,HPUX,RHAS,Windows Database:Oracle 9.2.0, 10.2.0 LanguagesSQL, PL/SQLApplicationsFUTUR Billing System

Responsibilities:

  • As a technical department team leader and Senior Oracle DBA I supported and consulted Swedish customers resolving their oracle database related questions and problems.
  • I perform various Oracle database administrator and Oracle expert tasks like performance tuning, expert advices, capacity planning, backup/recovery management, etc. I remotely manage several terabyte - sized production databases in 24X7 environment.
  • I administered Oracle10g Application Servers and its infrastructure including latest versions of Identity Management, SOA, BPEL, and Collaboration Suite 10g.
  • I managed a team of Oracle DBAs and consultants.

Oracle Technical Support and Competence Center Team Leader

Confidential

Environment: Operating system:Sun Solaris,HPUX,RHAS Database:Oracle 9.2.0, 10.2.0 LanguagesPL/SQL, XML, HTML, Java, Delphi ApplicationsOracle E - Business Suite 11i

Responsibilities:

  • As a technical department team leader and Senior Oracle DBA I supported our clients resolving their oracle database related questions and problems.
  • As Senior Oracle OEBS DBA I managed Oracle Applications 11.5.9 and 11.5.10 ERP - systems running under Oracle 9.2.0.7 RDBMS and HPUX 11i operating system in North West Telecom company.
  • Installed and configured Oracle 11i E-Business Suite in split environment (DBTier running on the HPUX server and Applications Tier running on the IBM Blade HS20 servers farm under RHAS 3.0 Linux). Performed migration on Linux, cloning instances with RapidClone
  • Install and configure Visibroker for ABM; set up Discoverer Server/Client and End-User-Layer (EUL). Maintain Concurrent Managers, Printers, User Security, Groups, Roles, Applications Desktop Integrator (ADI). Apply patches and customizations.
  • Perform problem diagnostics and performance monitoring.
  • I communicated with Oracle Support Services.
  • I managed corporate and customers Oracle databases.
  • I consulted the customers about Oracle E-Business Suite 11i.
  • I supported customer s Oracle E-Business Suite installations.
  • I managed technical department (5 people).

Principal Oracle DBA, Oracle Expert

Confidential

Environment: Hardware:Sun Sparc Operating system:Win2000, Sun Sparc Solaris Programming languages:Object Pascal, Java, SQL, PL/SQL, XML Database:Oracle 8i 8.1.6,8.1.7 and 9.0.1 Software Tools:Java Server Pages, JDeveloper 3.2,9i, XML*Parser Network/Communication:TCP/IP Type of Applications:Property Management System

Responsibilities:

  • As a principal Oracle Developer and Oracle DBA I was involved in a property management system project development using Oracle 8.1.6, 8.1.7and 9i database servers.
  • I was designing and implementing this project using Java, EJB and a lot of Internet - enabled features of Oracle 8i and 9i databases.
  • Assessment and usage of latest object technologies built in Oracle8i and Oracle9i RDBMS kernel.

Principal Oracle DBA/Developer and Oracle Expert

Confidential

Environment: . Hardware:Sun Sparc Operating system:Win2000, Sun Sparc Solaris Programming languages:SQL, PL/SQL Database:Oracle 8i 8.1.5 Software Tools:Oracle Developer, Designer Network/Communication:TCP/IP Type of Applications:ERP Application

Responsibilities:

  • As a principal Oracle DBA and Oracle Expert, was involved in the installing, configuration, tuning and maintenance of Oracle 8.1.5 Database Server for ERP application. I developed backup/recovery strategies in 24x7 work environment
  • PL/SQL server - side development, designing and implementation sql/shell - based performance monitoring utilities. Tuning and testing database server for production environment. Installation, configuration and testing of client applications.

Principal Oracle DBA/Unix System Administrator

Confidential

Environment: Hardware:HP K9000 Operating system:HP/UX 10.20, Win NT 4.0 Programming languages:C, C++, SQL, PL/SQL Database:Oracle 7.3 Software Tools:Oracle Developer, Pro*C, C++ Network/Communication:TCP/IP Type of Applications:Billing System

Responsibilities:

  • As a principal Oracle DBA/Analyst was involved in designing, implementation, testing and turning in production of billing system for cellular mobile operator in St - Petersburg.
  • This billing system is running on Oracle Parallel Server 7.3.4 on HP/UX platform.
  • The billing system provides tarification/accounting for > 100000 mobile network customers. I designed and developed server software using VLDB (Very Large Database Systems) techniques. Database size was > 100GB.
  • Implemented backup/recovery strategies using OmniBack II backup software for HP/UX.
  • Performance tuning using RAID arrays and raw devices, sql tuning.
  • Administration of HP/UX cluster.
  • Designing software for communication Oracle RDBMS and DX200 switch.
  • Development of migration procedures from old to the new billing system, some HP/UX UNIX administration and other activities connected to the billing system.

We'd love your feedback!