SUMMARY:

Database Engineer/DBA with an MS in Computer Science, 15+ years in technology. Seasoned expert in Data Architecture, DB Administration, Implementation, Migration, Reverse Engineering, HA/DR and Big Data. Managed a wide range of hosts including RDBMS, Vertica, and noSQL nodes. Instrumental in building, training an off shore team of 4 to provide off hours support.

TECHNICAL SKILLS:

Data Architecture

DBA

Data Warehousing

Data Analysis

MS SQL Server 2014

Oracle 11g, 12c

MySQL

Vertica

Transact - SQL

PL/SQL

PostgreSQL

SSIS

Informatica

Business Objects

Crystal Reports

ETL

Linux

Perl

Python

MongoDB

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Database Engineer

Responsibilities:

• Gooddata ETL - Development and support for python based ETL that gathers app data from Confidential ’s client base, then transforms\loads it to Gooddata for cross platform global reporting.
• Back-end development of core application. Implemented flyway scripts to Baseline data model for releases 4.0 and 4.1;
• Implemented foreign key constraints throughout MariaDB db for improved data integrity.
• Created a python POC of Confidential Exporter, an ETL to extract and transform core app activity to XML. It meets the Compliance/Data Retention requirements for financial services customers

Confidential, Newark, CA

Database Engineer

Responsibilities:

• Development and support of Big Data solution tracking snmp indicators of data center power devices spanning the globe. 5-minute readings taken from power devices with 4 billion rows loaded daily
• Development and support of a 20 node Vertica cluster - 500 million rows loaded daily - Tracks metrics such as CPU %, Disk IO, and Memory usage of hosts for business groups including iTunes, iCloud and Siri
• Implementation of MongoDB app with 6 nodes in prod and 3 nodes in test including DR
• Implementation of PostgreSQL app. Performed db config and administration
• Migrated Mission critical apps into a Nutanix Distributed Storage Fabric (DSF) environment
• Implemented a Master/Master Solution for HA/DR

Data Architect

Confidential

Responsibilities:

• Database design, development, schema creation, implementation in lab, test, and prod environments for an internal app used to track, forecast data center power and space usage, availability
• Design and development of Daily Power Polling process aggregates and ports readings from MySQL to Oracle DBs
• Requirements definition and design of ops dashboard
• Senior member of the GDCS-APPS-DBA team providing a comprehensive set of db admin services for enterprise systems and applications.
• Dev-ops and production DBA for 125+ MySQL, Oracle, SQL Server, MongoDB hosts with Disaster Recovery and High Availability solutions in place

MySQL DBA

Confidential

Responsibilities:

• Back end implementation of MySQL data repository in dev, test, QA and prod regions
• Designed, implemented, maintained an HA solution using maser/slave replication and automated monitoring and backup via shell scripting
• Performed data migration between dev, test, QA and prod regions
• Analyzed and Optimized complex slow running SQL queries
• Extensive experience in MySQL InnoDB and MyISAM storage engines
• Designed and Maintained backup procedures and performed restores when necessary
• Management of Tablespaces, Data files, Schema Objects, Roles, Users & Profiles including large volume tables with over 1 million rows loaded daily

SQL Server DBA

Confidential

Responsibilities:

• Performed performance analysis and as a result implemented Backup/Maintenance strategies, Security Management, Resource Management
• SQL Clustering, DB Replication, Mirroring, AlwaysOn, HighAvailablity, Recovery
• Established reporting read-only instances via Log Shipping
• Performed SQL Server Recovery DR, troubleshooting, and failover
• Upgraded SQL Server prod hosts from
• Optimized T-SQL queries, procedures and ETL processes
• Data Migration between dev, test, prod regions
• Security permissions administration - defined appropriate schemas and database/server roles
• Capacity planning and monitoring of server performance
• Designed and analyzed relational database and data warehouse structures

Oracle Apps DBA

Confidential

Responsibilities:

• Effectively coordinated, resourced and resourced actions to upgrade db hosts from 11g to 12c in a prod environment
• Management of Tablespaces, Data Files, Schema Objects, Roles, Users & Profiles
• Managed Oracle upgrade of 40+ hosts from 11g to 12c. Leveraged the expertise of the AMP infrastructure as well as GCS dba teams to complete
• Data export import between prod and lower regions using the Datapump expdp and impdp

Confidential, San Francisco, CA

Data Analyst/SQL Developer

Responsibilities:

• Collaborated with business and colleagues within the group in support of existing BI applications.
• Uncovered and defined new needs.
• Implemented solutions in a Teradata/Business Objects/Crystal Reports environment
• Applied a new corporate incentives plan with a discretionary bonus based on performance metrics to the CORE incentives engine.
• Constructed an automated Advisor Services Sales RM report ranking individual sales employees based on NNA, revenue and goals
• Modified Advisor Services Sales Report Card to match compensation plan changes effective Q2 2013
• Modified existing db Schema to receive restructured CSV load files
• Solutions ranged from data support for analytical exercises to leveraging an extensive reporting infrastructure to provide information and reporting to clients.

Confidential

Data Analyst/SQL Developer

Responsibilities:

• Advised product/project teams to identify business requirements and translate them into complex database solutions for the Lockbox GTM Migration Project
• Performed exploratory, in-depth analysis to provide actionable insights to the lines of business
• Interpreted research and analytic findings and explained strategic/tactical implications to business
• Delivered automated SSIS packages to transfer data between db instances for project consumers

Confidential, San Francisco, CA

Data Analyst/SQL Developer

Responsibilities:

• Designed, developed, implemented, database and data warehouse systems using SQL Server, Oracle, MySQL, stored procedures, ETL tools and industry standard financial products.
• Played a key role in maintaining existing systems and building new ones.
• Lead Developer for Composite Management System which was used to gain GIPS compliance certification for the organization
• Used SSIS to automate, extract and send daily transactional data to fund accountant for Confidential family of funds.
• MySQL Schema Table Creation and Modification to load Thompson/Reuters metrics into an Oracle Data Warehouse
• Client Reporting: Developed earnings, holdings, transactions and maturity reports, utilized Informatica as ETL for analytical reports