We provide IT Staff Augmentation Services!

Senior Database Engineer/architect Resume

CA

SUMMARY

  • Over 15 years of experience in software analysis, design, development, and implementation with focus on highly scalable systems.
  • Proven track record of definition and implementation of architecture strategy.
  • Proven ability to lead and mentor group of people
  • Excellent ability to resolve complex technical issues.
  • Strong analytical skills. Extremely strong troubleshooting skills. Proven ability to lead and mentor groups of people.
  • Extensive experience in data modeling and design
  • Good knowledge of Hadoop, HDFS, Big Data, Hive
  • Experienced on working with Big Data and Hadoop File System (HDFS).
  • Strong technical hands on experience in Oracle 11g/10g/9i/8i MySQL 5.1/5.6 databases
  • Experience in developing web applications using MySQL, Oracle PL/SQL, Perl, CGI, TSQL, Tcl/Tkl, as well as other SQL flavors, ETL tasks, database and query optimization (Analyze, Explain Plan, TKPROF)
  • Strong analytical skills including the ability to transform complex business requirements into a successful system design
  • Database/System Administration with 8 years of professional experience in administrating various
  • Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment
  • Hand - on experience writing backward compatible code
  • Excellent interpersonal and communication skills and willingness to learn new tools, concepts and environments
  • Working knowledge of Git, Maven, and Jenkins

TECHNICAL SKILLS

Databases: Oracle, Sybase, Microsoft SQL Server, MySQL

Operating systems: UNIX (Solaris, HP-UX, IBM AIX), Linux (Red Hat), Windows NT, PICK/REALITY Operating System, OS/MVS

Languages: PL/SQL, Perl, Tcl, Expect, JavaScript, UNIX shell, SQL

Big Data Ecosystems: Hadoop, MapReduce, HDFS, Hive, Pig, Sqoop,MongoDB

Applications and Tools: PL/SQL Developer, TOAD, Oracle Enterprise Manager, Brio 6.0, SQL*LoaderSQL*Plus, DB Artisan, Oracle Parallel Server, Oracle Application Express, Sybase ASE 11.9/12.0/12.5 , Sybase Central, Replication Server 12, SQL Advantage, BMC SQL-BackTrack, Legato Networker, IBM ADSM, Veritas Volume Manager, Veritas NetBackup, Jenkins/Hudson, Cruise Control

MC/Service: Guard, HP Glance Plus, HP Omni Back II v.255, Remote Control

Web Servers: Apache Web Server 1.3/2.0, Apache Tomcat 4, Netscape Enterprise Server 6.0

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Engineer/Architect

Environment: MySQL, Windows, Unix, Hadoop

Responsibilities:

  • Responsible for design/development of distributed data storage platform and web applications for Online Marketplace, Catalog/Inventory/Order Management Systems as well as Data Analytics/BI tools in big data paradigm
  • Implemented analytical solution on Big Data using Hadoop/Hive/Sqoop/Pig/Shell
  • Was responsible for development of Hive-MapReduce-streaming Shell modules using Hive
  • Evaluated benchmark and compile metrics for total MapReduce CPU time spending while running Hive aggregates.
  • Provided technology direction, lead the development efforts
  • Trained, led and mentored to onsite and off-shore developers.
  • Led architecture and design of a high performing/highly available and horizontally scalable application
  • Conducted POC for new releases of MySQL
  • Support the existing framework and implementation of new store procedures for the feeding the data to the various systems using store procedures and scripts (MySQL 5.1/5.6 on Fedora/RHEL5)
  • Perform data modeling and design new database objects to support new functionality
  • Support and implementation of new program for the Eventual Consistency to support Data Sharding
  • Implement store procedures for the ETL process to load the data from the External Providers through the staging environment to the main entities
  • Leveraged Platfora for Data Visualization
  • Responsible for Data Retention and Pruning, SQL performance and tuning
  • Development of data strategy/best practice and associated policies
  • Selection of compatibility and systems to meet business information needs

Confidential, CA

Senior Database Engineer/Technical Lead

Environment: Oracle/MySQL, Windows, Unix

Responsibilities:

  • Responsible for database side implementation and development various new releases using Oracle/MySQL
  • Designed and implemented hierarchical data structure and all the database related functionalities
  • Responsible for the OLTP and OLAP data modeling
  • Lead and participated in DB performance enhancement efforts, In-house ETL development

Confidential, Menlo Park, CA

Senior Database Engineer/Developer/DBA

Environment: Oracle 9i/10g/11g, Windows, Unix

Responsibilities:

  • Responsible for the database side implementation and development of PES (Partner Engagement System) releases using PL/SQL, SQL and Unix Shell scripting
  • Design and implement data warehousing to facilitate reporting using Pentaho
  • Migration of through ETL processing from transactional systems to reporting systems
  • SQL query optimization using Hints and utilities like Explain Plan, Auto Trace.
  • Extensively used PL/ SQL blocks Collection, Procedures, Functions, Packages and Triggers for implementing complex business logic.
  • Develop and maintained DB utilities to extract and load sets of between the different systems
  • Performed automated load using shell scripting and Oracle tools and techniques such as: SQL*Loader, export/import, external tables
  • Automated load for I18N project using Unix shell scripting and Oracle tools and techniques such as: SQL*Loader, export/import
  • Perform analysis to evaluation the existing interfaces, business needs and provide solution
  • Translated requirements into functional and technical specifications
  • Perform unit and integration testing and debugging and set test conditions based on code specifications
  • Responsible for designing, developing, specification of test plans

Confidential, Newark, CA

Senior Database Developer/Product Quality Lead

Environment: s: Oracle 9i, Unix, Perl, JavaScript

Responsibilities:

  • Developed a number of entirely new applications, store procedures, packages for reporting different product metric/scorecards with the goal of improving product availability and quality using PL/SQL, Tcl, Perl, CGI, JavaScript, Lout, Unix Shell Scripting
  • Assisted in the implementation Oracle OLAP, mapping, migration
  • Implemented automated syntactic CLI test software for Honeycomb products using Perl, Tcl/Expect
  • Design, develop and implement Health Check tracking process to improve customers quality experience using PL/SQL, HTML, Tcl, Perl, CGI, JavaScript
  • Performed mining, created, and delivered custom reports, models to halp analyze different product quality metric (Escalations, Bugs, Radiance Cases, Install Base, FIN/FCO's, CPAS and etc...) using Brio, Perl for the Network Storage products
  • Built Web Pages with HTML, Java Script and CSS
  • Perform analysis utilizing establish scorecards of the Remote Monitoring/Telemetry Compatibility
  • Fault tolerance/management metric, identifying product quality highlights and low lights
  • Design, develop and implement NWS QCC Lesson Learned database and application utilizing PL/SQL, Perl, CGI, HTML

Hire Now