Sql Server Developer

Professional Summary

Jorge has extensive experience in large, mission-critical environments with a proven ability to design high-availability solutions, integrate systems, manage projects, manage resources, and solve problems. He interfaces with customers extremely well and is always willing to go the extra mile to help.

Technical Experience

Software

Microsoft Windows Servers

Microsoft Windows Desktops

VMWare

Microsoft Windows Virtual PC

Microsoft SQL Server (6.5,7,2000 - 2014)

Novell Netware

Unix (Red Hat Linux / Ubuntu)

Windows Software Update Services (WSUS)

Symantec NetBackup

Autosys

Symantec AntiVirus Corporate Edition

Microsoft Access

MS SQL Server SSIS / SSRS / SSAS

Microsoft Visual Studio (.Net 2002 – 2012)

SQL Server monitoring - Spotlight, Foglight

VBA/VBS Visual basic Applications / Scripting

Familiar with NoSQL Databases (MongoDB, HBase, Cassandra, CouchDB) / Hadoop MR.

Microsoft Active Directory

Microsoft Windows Powershell Scripting

NT Shell Scripting

Microsoft Cluster Services (MSCS)

.Net (VB / C#)

Microsoft Internet Information Server (IIS)

Microsoft POWERPIVOT

Microsoft Office

Microsoft (DNS)

Microsoft (DHCP)

Javascript, JSON

Star Team, Team Foundation Server

Proclarity, Tableau, Qlikview

LiteSpeed for SQL Server

WMI Windows Management Instrumentation

Python

MS T-SQL; ORACLE PL/SQL

Career Summary

DHCS - State of California Dept. Health Care Services Jun 2015 – Jun 2016

Database Consultant/DBA/Architect/Modeler

Enterprise Data Modeling using ERWIN r 9.5 to Reverse/Forward engineer – EDW Enterprise Data Warehouse DB2 to MS SQL Server Migration. Automation of script creation (Bulk), parsing table layout and metadata lookup. ETL coding for large Data Marts that will merge into the EDW. Mentoring BI Lead with best deployment process from OLTP to OLAP. (KIMBALL).

Server Upgrade and data migration from MS SQL (2008/2012) to MS SQL 2014 automated through TSQL. (Data/Jobs/Alerts/Assemblies/Operators etc.).Unattended installs through POWERSHELL. Folders, Users, Permissions and Shares mirrored on new box.

Worked with WAA (Web Application Architecture) for implementing best security practices using Windows Authentication of AD (Active Directory) groups as Logins that map to a local database user which is assigned to specific database role(s) for granting access in a tight security environment.

Transparent Data Encryption (TDE) and Column level encryption.

File Table/File Stream implementation for reading table layouts as part of the ETL process.

Debug SSIS migrated packages to new platforms as part of Server Migration/Upgrade.

Social Interest Solutions through Modis Jun 2014 - Feb 2015

Database Consultant/DBA/Architect/Modeler

Enterprise Data Modeling using ERWIN r 9.5 to Reverse/Forward engineer the core Databases with 950+ tables. Layout ER diagrams PK-FKs.

Conceptual, Logical & Physical design.

PTO Performance tuning & Optimization (Queries, Tables-indexes, Server-settings, Database Stored procedures, Views, Triggers etc.).

Removal of duplicate and redundant indexes.

DDL Trigger development for preventing table creation in wrong file groups and creating duplicate indexes.

MS SQL Server 2012 Always On, DBA – Configure AO - Rewrite Jobs for Always On.

On call coverage for troubleshooting failed jobs / processes.

Standardization of user defined data types for highly used columns.

FTP / SFTP files to/from Customers via SSIS/TSQL wrapped jobs.

Planned Parenthood through Robert Half Technology Mar 2014 – Apr 2014

Database Process & Reporting Consultant

Re-engineer procedures for PTO (Performance Tuning and Optimization) and streamlining maintenance [MS SQL Server 2008].

Improve performance and redesign of SSRS Reports [Microsoft Visual Studio 2012].

Automation of MS Excel reports through VBA macros. [MS Excel 2013].

Recommend and document best practices for DBA effectiveness.

Bank of America through Collabera Feb 2011 - Mar 2012

Database Consultant/DBA Production

Enterprise Environment databases running over 35TB size. Cardlytics project.

Managed over 100 Servers in different lanes. (Development, Staging, QA, Production )

EMC Data Domain deduplication backup storage/SAN.HADR.

Server installation/ Table Partition /Server Monitoring /Tuning/ Troubleshooting.

LOG Shipping/Mirroring/Replication/Clustering.

Document Run Book server configurations, DB Users, Disk Space, Log ins.

LiteSpeed and Symantec NetBackup for compressed data backups.

VISA through Ascent Services Group Feb 2011 – Feb 2011

Windows server ADMN SQL DBA / Web Development Generalist

PTO (Performance Tuning and Optimization) for speeding data fetch.

WMI/VBS utilities for accessing local/remote server information.

Microsoft .Net ASPx /AJAX for maintaining Web Application.

SQL server tuning/Ad hoc troubleshooting.

Electronic Arts through JD Strategies Sep 2010 - Dec 2010

Senior BI Architect/Consultant

PTO (Performance Tuning and Optimization) for speeding up reports (SSRS).

Developed C# API to plug in Data Visualization PivotViewer to MS SQL Database.

Evaluating products such as Tableau, ProClarity and MS Silverlight PIVOTVIEWER for slicing data dynamically for data visualization.

Designed project plan for Conformed Dimensional Model detailing every iterative step from initial dimension usage matrix, to logical data map, surrogate keys and index strategy.

SCD Slow changing dimensions (1/2), Snowflake dimensions required.

ETL streamlining. CUBE deployment SSAS/ MS SQL Server 2008R2 with tables with over 6 billion Rows.

Improved reporting SSRS (datasets/design). Troubleshoot existing report inventory.

Detailed step by step documentation of entire process.

Intel Corp. through MindTeck Feb 2010 - Sep 2010

Senior EDW ETL Database Developer/Administrator/Release Manager

As Enterprise Data Warehouse Extract Transformation & Load engineer, developed a Meta Data based flexible Delta Transfer code for MERGE-ing changes or incremental table data loads and not entire loads.

Troubleshoot AUTOSYS (Intra Platform ETL & Job Control System) and SSIS packages as part of the EDW (TERADATA/ORACLE/INFORMATICA).

PTO Performance Tuning and Optimization by hacking EEP (Estimated Execution Plans) index tuning. Improved performance 90% by using proper INCLUDE indexes.

Fine tune queries by matching data types in predicates.

Workers Compensation Insurance Rating Bureau Feb 2009 – Apr 2009

Senior Database Administrator – Application Engineer

DBA PROD 20% and DBA Developer 80%. (MS SQL Server 2005/2008).

ETL & Data scrubbing (TSQL) corrections for Conversion of Mainframe VSAM files to MS SQL Server.

Troubleshoot server loads and performance monitoring, and query/index tuning.

Multiple file groups for performance gains in operational administration.

LIFEMASTERS May 2007 – Sep 2008

Senior Database Developer/Administrator

Work with QA, DBA, and systems support personnel in automating successful code to production.

DTS migration to SSIS. Code maintenance on ETL for operational Data Warehouse.

Develop T-SQL SPROCS to meet business/reporting SSRS requirements.

Data warehouse improvement redesign of DTS processes from 1 or 2 breaks per month to zero.

Very fast paced code development and ETL restructure for PDS (Predictive Dialer System).

Successful deployment of Pharmacy Claims project handling over 80 databases, some distributed over remote servers. CLR (VB/C# .Net) assemblies. Performance Query/Index optimization.

Maintenance Cubes/Reporting SSRS and documentation of operational Data Warehouse ETL.

High Availability (Clustering/Mirroring), Disaster Recovery (Log Shipping/Replication).

Provide on call 24/7 DBA support to production systems.

Integrity Checks, Short Disk Space, Merge replication, CL, DMV, DMF, CTE.

Query improvement through CTE, PIVOT/UNPIVOT, RANK,DENSE_RANK, NTILE .

ECAST through CV Partners Oct 2006 - May 2007

Senior EDW ETL Database Developer/Administrator/Release Manager

DBA Production 50% and DBA Developer 50%. (MS SQL Server 2005).

Monitor/tune queries, slowdowns, Deadlocks using T-SQL and 3rd party tools [SPOTLIGHT/IDERA].

PTO Performance and index tuning.

Multiple file groups Database redesign for improvement on operational performance.

Re-engineering of their billing process to reduce processing time from 25 + hours to just minutes and recover a total of over $17000 year for late arriving revenues.

Variable configurable SSIS wrapper package to flexibly run this script.

CLR (VB/C# .Net) assemblies for extending functionality in SQL2005.

Log shipping for stand by DBs on warm servers - Transactional replication implemented for a heavy transaction (OLTP) environment with large tables with over 950 million rows.

XML extract records generated with .NET C#. Wrapper SSIS for automated extraction.

Automation of Reports/Excel books using VBA and COM.

Lashgroup through YoIT May 2006 - Jun 2006

Senior Front end Developer

Health related application maintenance in VB.net/MS SQL Server.

Code extension (inheritance/interfaces)/Crystal Reports reporting tools.

T_SQL scripts and stored procedures in SQL Server, Data Dictionary and schemas maintenance.

Coding in a shared environment using Borland's Star Team.

Wells Fargo through TMC Nov 2005 - Jan 2006

Senior Front end Developer

Bus architecture Data Warehouse Data modeling. Star Schema – Kimball.

Views improved with TVF (table value functions) for improving data access to inter database entities of over 3 Terabytes. Performance and query/index tuning.

Project manager coordinating two additional IT professionals in SQL scripting and modeling (T-SQL) and documentation areas (VISIO).

Troubleshoot Oracle PL-SQL procedures.

Wells Capital Management through Apex Systems May 2005 – Oct 2006

Senior Front end Developer

Trading System Portfolio/Money Market conversion from MS Access to MS SQL Server.

Data modeling (VISIO) of more than 17 independent MS Access databases to a unified MS SQL server database.

All business functionality in Access’ VBA script translated to DTS Active X and T-SQL.

DTS/ETL developed for replacing VBSCRIPT loading routines from various sources (CSV, MS Excel, SDF).

Crystal reports front end for report generation.

DHC Skin Care Jun 2004 - May 2005

Senior Developer – Migration specialist

Conversion from Visual FoxPro to Client Server SQL-PASS-THRU with MS SQL Server as back end.

Bank of America through Sapphire Technologies Sep 2003 - Jun 2004

Senior Developer – Migration specialist

Maintenance on legacy application (FOXPRO) by translating business needs into code.

CDSS CA Department of Social Services through Eclipse Apr 2003 - Aug 2003

Senior Business Analyst

FSR (Feasibility Study Report) for application architecture transition of their core applications.

Acacia Pacific Holdings May 2001 – Jul 2002

Senior Business Analyst / Developer

Visual FoxPro, SQL Server 2000 DBA/developer DTS/ETL, COM, XML, MSMQ.

Northern California Cancer Center Jan 2001 - May 2001

Senior Business Analyst / Developer

Maintenance Visual FoxPro application level of Effort, HR, Phone audit system.

Bank of America through Analysts International May 2000 - Dec 2000

Senior Business Analyst / Developer

Maintenance FoxPro application credit card chargeback/rebuttals – multiple modules.

Generate Marketing Jan 2000 - May 2000

Senior Business Analyst / Developer

Windows 2000/Novell LAN Systems Maintenance. FoxPro call center application. SQL server 2K.

ProBusiness Oct 1998 – Nov 1999

Senior Consultant Developer

Developer Visual FoxPro tax application. SQL server 7.

TimePoint Corp. Jul 1998 – Oct 1998

Senior Consultant Developer

Developer Visual Foxpro scheduling application. SQL server 6.5.

Direct Marketing Jul 1997 – Jul 1998

Senior Business Consultant Developer

Developer Visual FoxPro for Direct Marketing Campaigns. SQL server 6.5.

Fastek Consultants Nov 1996 – Jul 1997

Senior Business Consultant Developer

Clipper 5.0 Application development Novell Netware LAN.

Electrobaralt Aug 1993 – Apr 1995

IT Manager

Novell Netware LAN, Clipper 87/5.0 app Dev plans, supervised 3 engineers.

Eripe, C.A Feb 1988 – Jul 1993

MIS Manager

Novell Netware LAN, Dbase III plus,Clipper 87/5.0 app Dev plans, Project Manager, supervised 4 engineers. Open Plan project management.

Indulac May 1983 – Dec 1987

Sr Business Analyst

Novell Netware LAN, Dbase III plus,Clipper 87/5.0 app Dev plans, Project Manager, supervised 4 engineers. Open Plan project management.

Kodak de Venezuela Apr 1980 – Mar 1983

Director Market Research and Analysis

Manager market research and analysis. Inventory management system.

Education

UCAB Universidad Catolica Andres Bello Jul 1974 - Jul 1979

Caracas Venezuela

Industrial Engineer – Masters Systems and Production

Contact this candidate