Senior Database Engineer Resume
San Francisco, CA
SUMMARY:
- Software Engineer with more than 1 2 years of industry experience.
- Solid background and practical experience in problem analysis, design and implementation of heterogeneous applications with emphasis on data related projects such as database supported data mining and process modeling.
- Full system life cycle hands - on experience: analysis, design, coding, testing, performance tuning, deployment and support.
TECHNICAL SKILLS:
Programming Languages: Java, SQL, PL/SQL, PL/pgSQL, Perl.
IDEs and Modeling Tools: IntelliJ IDEA, Eclipse, Borland JBuilder, Oracle JDeveloper, Oracle Procedure Builder, Quest SQL Navigator, Quest Toad, Rational Rose, Platinum Erwin.
Operating Systems: Sun Solaris 7, 9, Linux, Windows, Mac OS X.
Databases and Tools: Pentaho Data Integration (Kettle,) PostgreSQL, Oracle 11g, 10g, 9i, 8i, 8.0.4, 7.3, Oracle SQL Loader, Oracle export/import, Microsoft SQL Server, Data Transformation Services, MySQL.
PROFESSIONAL EXPERIENCE:
Confidential, San Francisco, CA
Senior Database Engineer
Responsibilities:- Developed utilities to monitor changes in PostgreSQL database.
- Developed backend API in form of PostgreSQL functions for multiple RPX applications.
- Created ETLs (Pentaho) to acquire data from external sources.
- Improved ETL processes for populating legal and patent data (Pentaho ETLs, PL/pgSQL.)
- Designed database schema to store Acquiflow application data.
Confidential, Redwood Shores, CA
Database Developer
Responsibilities:- Led the effort to redesign complex PL/SQL packages to achieve required performance metrics for Revstream application.
- Improved performance of SQL queries on Oracle 11g.
- Designed and developed PL/SQL packages and procedures for data processing.
- Designed and developed UI elements for Revstream application using Oracle APEX.
Confidential, Mountain View, CA
Database Developer
Responsibilities:- Developed PL/SQL ETL packages for Noosh datamart.
- Designed database schema for Noosh data warehouse (MySQL.)
- Created ETL packages for Noosh data warehouse (Pentaho Data integration (Kettle), Oracle PL/SQL)
- Designed, developed and customized reports.
- Supported Noosh production system on Oracle 11g.
Confidential, San Mateo, CA
Database Developer
Responsibilities:- Developed Contract Registration System for USPS that provides negotiated custom rates for high volume customers, such as Confidential, Confidential etc., and switches rate tiers automatically based on volume and revenue.
Technologies used: Oracle 11g, PL/SQL (procedures, packages, triggers, bulk loads, materialized views, database links, dynamic SQL.)
Confidential, San Francisco, CA
Software Engineer
Responsibilities:- Developed pipeline and forecasting functionality for Confidential sales automation application (Oracle PL/SQL, Java.)
- Created Java components that handle execution of Apex code for pipeline and forecasting module.
- Optimized SQL queries and created PL/SQL procedures for the pipeline and forecasting module.
- Ensured consistent encoding throughout the modules to prevent cross-site scripting (XSS) attacks.
Confidential, San Francisco, CA
Software Engineer
Responsibilities:- Developed Confidential document review system (Oracle 10.2, PL/SQL, Java) that facilitated Confidential E-Discovery services.
- Diagnosed and fixed pathology in the document review system that was negatively impacting application's performance.
- Monitored application after it went into production and fixed all performance-related bugs.
- Developed and implemented the migration strategy for 1Tb client’s documents database (Oracle 10.2.0.1, Oracle import/export utilities, custom scripts).
- As a member of R&D team, developed next version of Confidential regular expression evaluation engine using Apache Lucene search engine.
- Researched and developed technology for fast regular expression evaluation engine for a large corpus of documents.
Confidential, Menlo Park, CA
Database Engineer
Responsibilities:- Developed next release of Sun’s “Partner Engagement System”
- Developed PL/SQL packages to process partner’s data and to create events for Partner Call Centers.
- Deployed “partner engagement system” to train employees at Sun’s Partner Call Centers.
- Installed, configured and upgraded (from 9.0.1) Oracle 9.2 database on Sun Solaris platform.
- Developed Java tool for automated Oracle database export-import.
Confidential, Scotts Valley, CA
Programmer Analyst
Responsibilities:- Worked with financial and sales executives on project requirements.
- Designed database schema for Financial Data Warehouse.
- Created data loading procedures (ETL) to populate regional data marts (MS SQL Server stored procedures) from various Scala systems, as well as ETLs for global data warehouse (using Oracle PL/SQL procedures and Microsoft Data Transformation Services.)
- Developed set of views for reporting purposes to facilitate Brio reports drill-down capability.
- Developed, deployed and managed Brio reports.
Software: Oracle Financials 11.0.3, Scala, SalesLogix, Oracle 8.1, Microsoft SQL Server 7.0, 2000, Oracle PL/SQL procedures, Microsoft DTS packages, Brio Reports, Brio Designer, Brio On-demand Server, Broadcast Server.
Confidential, Sunnyvale, CA
Software Engineer
Responsibilities:- Designed, developed, and deployed membership-based web application for a major client.
- This 3-tier application utilized WebLogic Servlet Engine capabilities to provide end users with dynamic database-driven content.
- Oracle 8i database.
- WebLogic Application Server 5.1.
- Apache Web Server.
- Internet browser on the client’s side.
- Designed database schema based on client’s requirements for the future application (Platinum ERwin).
- Performed preliminary research and created Java servlet for retrieving binary information stored in Oracle BLOB columns.
- Participated in object - oriented design (Rational Rose).
- Wrote JavaBeans representing business objects.
- Used and improved in-house developed Java package for JDBC support, connection pooling, log-, error-, and property-files management.
- Created JSP pages.