Advisory Software Engineer Resume Foster City, CA - Hire IT People

SUMMARY:

10 Years of experience with DB2 database administration starting with Ver 8.2 to db2 10.5
15 Years of experience with Oracle Database and Developer tools
Managed offshore support team consisting of 2 resources.
Collaborate effectively with software developers, QA, product managers and production operation teams
Design, develop and review data models, database schemas, and complex SQL queries
Develop frameworks to automate administration, configuration, upgrade, monitoring, alerting and deployment (data and schema)
Proficient in DB2 LUW capacity designing, configuration, production DB2 tuning and troubleshooting. Helped the customers Wal - Mart, Target, Safeway, Stop-&-Shop etc. build stable and optimal DB2 environment and reduce the risk of downtime.
Architected the data archiving solution to handle high data volume and improve application performance.
Successfully architected and implemented DB2 Monitoring solution JAMM for 100+ Demandtec Customers.

AREAS OF EXPERTISE:

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Advisory Software Engineer

Responsibilities:

DB 2/10.5/9.7/9.5 LUW DBA for partitioned and non - partitioned multi-terabyte databases (10+ TB), performance tuning, SQL tuning & Query optimization working with in-house application projects.
Architected and constructed a flexible dynamic framework Akka Patch Deployment tool comparable to Ansible to automate database build process across 100+ databases.
DB2 database engineering, working with different developer teams on multiple applications and database design/Architecture and schema optimization and other DB2 aspects.
Proactive DB2 v9.7 monitoring & performance tuning in large / medium size OLTP databases.
Plan & implement HADR for disaster recovery at remote site for two separate applications. Currently working on multiple projects on configuration of HADR set up as well as HADR / TSA set up.
Planned and implemented Data/Database migration project from one data center to another with zero down time for multiple projects.
Performed multiple databases redirected restores from production to various other environments.
Involved in resolving all database performance issues, performanc enhancements and tuning strategies
Mentoring Java/Database engineers on SQL code standards and best practices.
Spearheaded the implementation of new Features of db2 10.5 databases including the database encryption in motion.

Confidential, San Mateo, CA

Principal Database Engineer

Responsibilities:

Support over 20 products and 100+ Engineers across 3 time zones for all data related activities.
Design, develop and review data models, database schemas, and complex SQL queries.
Design and develop OLTP and OLAP solutions using Netezza (massively parallel appliance based on Postgres), DB2, MySQL, Microsoft SQL server across various products suites within DemandTec.
Develop frameworks to automate administration, configuration, upgrade, monitoring, alerting and deployment (data and schema)
Developer and implemented a web - based JAMM tool to monitor performance across 80+ Db2 databases.
Design and document frameworks for Performance tuning and upgrade of Multi-terabyte db2 and Netezza databases.
Collaborate effectively with software developers, QA, product managers and production operation teams.
Design and architect solutions using Storage Area Network and performance tuning for very high I/O throughput.
Managed/supported 100+ customers, 100+TBs of data, 200+ DB2 instances (including DPF) and 3 NZ (MPP) clusters in Cloud
Architect the development environment for offshore team and handled critical issues such as data masking of sensitive information.

Confidential, San Francisco

Senior Oracle DBA

Responsibilities:

Supported Oracle databases as part of the Production support team, this was a smaller portal of ticketmaster.com
Performed Oracle database upgrades/Monitoring/SQL tuning being part of 24x7 monitoring team.

Confidential, Oakland, CA

Senior Oracle DBA

Responsibilities:

Single handedly supported 30+ Navis Oracle customer databases as part of the 24x7 Operations team
Resolved/Addressed all customer and developer performance issues.
Architected and automated the migration of 100+ Oracle forms from Version 4.5 to Oracle Forms 10.

Confidential, Oakland, CA

Oracle DBA

Responsibilities:

Wrote PL/SQL scripts to do statistical analysis of gene expression data with Oracle.
Supervised Oracle Pl/SQL code and approved it before it moved into production.
Performed all DBA functions for installation, upgrading and migration of Oracle database version 8 thru 9.