Resume

Sign in

Sql Server Engineer

Location:
Brentwood, California, 94513, United States
Posted:
May 17, 2018

Contact this candidate

GABRIEL A. TUNC

ac5hz1@r.postjobfree.com 510-***-****

LinkedIn: www.linkedin.com/in/gabriel-t-a819b757

SUMMARY

Experienced database engineer seeking position as a Senior Database Engineer in the San Francisco Bay Area. Developed and tuned existing data ingestions (ETLs) to populate the Vertica data warehouse. Designed and coded the structure of various Vertica database objects to support data loading. Designed complex (ETL) SSIS processes that provided enterprise data services for business users, and applications for reporting, analytics, and business intelligence. Designed, developed, and maintained production databases (OLTP) for large-scale enterprise applications. Responsible for the implementation and management of bank’s database auditing software for internal security and regulatory compliance (Sarbanes-Oxley).

CORE CAPABILITIES

Database design, maintenance and tuning

Designing and implementing complex ETL flows in a mixed database environment

Creating automated management key performance reports

PROFESSIONAL EXPERIENCE

YP.COM [DEXYP] Jan 2015 – Feb 2018 DexMedia acquired YP.COM becoming DexYP

Senior Database Engineer

Technologies: Vertica, SQL Server 2014, Oracle 12c, Hadoop, Postgres, HBase

Identified datasets needed for building analytic models and reports

Originated, maintained and tuned existing data ingestions (ETLs) to populate the Vertica data warehouse

Designed and coded the structure of the various Vertica database objects to support data loading, high availability and querying downstream

Developed the migration plan of moving a SQL Server-based data-mart to Vertica as part of a company-wide data consolidation effort

YP.COM Jan 2012 – Jan 2015

Lead / Senior Database Architect

Technologies: SQL Server 2014/12, SSIS, Oracle 12c, Toad

Led and coordinated cross functional teams to communicate database-design-related-activities with a wide range of technical, non-technical and third-party teams

Designed complex (ETL) SSIS processes that provided enterprise data services for business users, and applications for reporting, analytics, and business intelligence for the Ad Engineering and Email Marketing groups

Created automated management key performance reports using SSIS to handle end-to-end production and delivery

YP.COM August 2008 – Jan 2012

Database Architect

Technologies: SQL Server 2008/5, SSIS, Oracle 11g

Designed, developed, and maintained production databases (OLTP) for large scale enterprise applications

Developed and modified complex stored procedures, triggers, views, and ad-hoc queries

Created database coding standards, set code review rules and created documentation around all related projects

Evaluated and proposed database schema changes, their potential impact on the data load processes, propose and implement the necessary modifications.

Managed and mentored the work of two mid-level SQL Database Developer

Developed and optimized database queries, and assisted front-end team members in database-related questions and performance issues

FIRST REPUBLIC BANK May 2006 – Aug 2008

Sr. Database Administrator

Technologies: SQL Server 2005, DTS, Sagent, Quest Lightspeed/Spotlight

Responsible for the overall administration and 24x7 support for OLTP and OLTP production databases

Managed and maintained monthly ETL data load process

Implemented database mirroring and database snapshot for the banks foreign currency exchange

Led the corporate IT project to identify, select and implement an enterprise level database backup, monitoring and alerting system

Responsible for the implementation and management of bank’s database auditing software for internal security and regulatory compliance (Sarbanes-Oxley)

Managed, trained and mentored the work of a mid-level SQL Database Administrator

HEALD COLLEGE Jun 2005 – May 2006

Sr. Database Administrator

Technologies: SQL Server 2005/2000, DTS, PeopleSoft, Veritas i3, VBscript

CHELA Education Financing Mar 2004 – Jun 2005

Sr. Database Administrator/BU Oracle DBA

Technologies: SQL Server 2000, DTS, Oracle 8i, Informatica

Prudential California Realty May 2002 – Mar 2004

Database Administrator/Developer

Technologies: SQL Server 2000, DTS, VBscript

EDUCATION

B.S., Finance, San Jose State University

University of California Berkeley Extension,

Certificate, Oracle Data Base Administration, August 2000

TRAINING

Vertica Advanced Analytics

Microsoft MTA

Designing Security for Microsoft SQL Server 2008

Designing High Availability Database Solutions Using Microsoft SQL Server 2008

SKILLS

Database: SQL Server 2014/12/08, Vertica 7/6, Postgres 9, HBase, Oracle 11g/10g /9, Hadoop

Tools: Visual Studio, SSIS, Aqua Design Studio, Sagent Design and Automation, Toad, (Spotlight/Lightspeed and Capacity Manager), Lumigent Audit DB and Log Explorer, VERITAS i for SQL Server, SQL Plus, SQL Navigator, Idera SQL Diagnostic Manager, PyCharm, Eclipse Mars2, MS Office, MS Visio, Jira, GIT, Stash, SVN

Language: T-SQL, PL/SQL, VB Script, HTML, XML, Python 3.x

O.S.: Windows Server, Linux (CentOS)



Contact this candidate