Sql Server Management

Jose Tigeleiro

** ******* *****, **** ****, NJ **828 • 973-***-**** • *************@*******.***

An experienced SQL Database Professional with Project Management and Consulting skills. Worked in both technical and managerial positions with experience in full project life cycle: requirements gathering, business definition requirements, functional and technical specifications, business process, impact and gap analysis, as well as agile development methodology. Experienced in design, modeling, development, deployment, documentation, training, production support, problem resolution, and client support. Microsoft Certified Professional working as Database Administrator possessing excellent communication and interpersonal skills.

Linkedin:

http://www.linkedin.com/in/joetig/

Technical Skills:

Databases: Microsoft SQL Server (2000/2005/2008/2012/2014), MYSQL

Programming Languages/Tools: MS SQL Server Management Studio, Visual Studio (2005, 2008, 2010), T-SQL, DTS, SSIS, SSRS, Agile Methodology, PowerShell, Microsoft Project, Microsoft Access, Visual Basic (3/6), Erwin, Microsoft Office (2003/2007/2010), XML, Visio, Redgate SQL Backup, Redgate Schema Compare, Crystal Reports, LiteSpeed

Environments: Windows [Various]

Relevant Experience:

Scholastic 7/2011-10/2016

Manager of eCMS Engineering 1/2016- 10/2016

Managed the database team responsible for migration of databases to AWS Cloud EC2

Managed the database effort to upgrade customized DAM utilized by the clubs group used for workflow of cover images to AWS and SQL Server 2014

Managed the database effort to upgrade main DAM utilized by the firm to manage their book assets (database size over 1 tb and physical storage over 60tb) to SQL Server 2012 Always on

Provided both physical and metadata assets for migration as part of a sale of business

Performed comprehensive database management and migration to AWS and SQL Server 2012 for the Digital Product Distribution System (DPD) (Dev, QA, Prod)

Lead DBA/Developer 7/2013- 12/2015

Worked with Ops group to develop PowerShell scripts to perform SQL Server installs

Installed and configured SQL Server 2012 Always on Availability Groups to achieve high availability and disaster recovery in AWS EC2 cloud (Dev, QA, Stage, Prod)

Lead upgrade of DAM solution for newly supported operating and database systems

Reviewed performance of Vendor DAM application and made index changes that resulted in 20% improvement overall

Enabled Snapshot Isolation on Vendor DAM application to reduce blocking

Upgraded Digital Processing Distribution System and DAM to SQL2008R2

Designed and implemented changes using T-SQL to the metadata distribution process of DPD application to create ONIX utilizing industry standard formats to distribution partners and to also parse metadata based on packs for the Intuitional subscription model

DBA/Developer 7/2011- 6/2013

Implemented the Digital Product Distribution to production, enabling users to send metadata to distribution partner

Created procedures for the Electronic Management System using T-SQL that retrieved metadata stored in the Digital Asset Management System

Designed the dynamic Ebook Promotions Module which enabled the firm to easily implement Ebook promotions to customers as they logged in

Designed and implemented Wishlist database used to store children “wish list” items

Created biweekly feed to a vendor which generated emails to Parents to inform them of items requested by their children

Performed various Performance Monitoring tasks and implemented enhancements

CSG Systems [Database Administrator] 5/2011- 7/2011

Utilized Redgate SQL Compare to generate scripts for deployment

Created new environments (DEV / QA) for new customers

Scholastic [Consultant] 11/2010- 5/2011

DBA / Developer on the Digital Product Distribution (DPD) project to place orders for digital products directly with vendors by interfacing with the Digital Asset Management system that warehoused the corporate digital assets

Developed performance tuning for database objects, indexes, stored procedures and functions

Created procedures using T-SQL to create and parse xml documents sent and received from vendors as order updates

Created SSIS packages to import Excel data feeds and update database accordingly

Pearson Education (Intellipro) [Database Administrator] 12/2007 –9/2010

Responsibilities included product upgrades, performance monitoring

Created automated custom processes using T-SQL that identified index fragmentation to rebuild indexes and identify indexes that needed a statistics update

Defined partitioning scheme for large volume table to avoid deadlocking and maintenance procedures to remove and add partitions as needed

Implemented database mirroring for an online learning site

Developed process using PowerShell that created reporting data in a spreadsheet format

Developed procedures using T-SQL to automate the capture of application statistics used for administrative analysis. Utilized PowerShell to extract and create csv files

Developed a process using T-SQL to capture deadlock graphs using alerts and email them to the DBA staff

Developed and implemented clr process with functions using T-SQL to compress and uncompress xml data that was stored in the database for debug analysis outside the application

Setup automated process utilizing Redgate Backup to perform log shipping backups and restores for the reporting database server

Developed and implemented log shipping to migrate VLDB (2 tb) from SQL Server 2005 to SQL Server 2008 setup on new Windows2008 clustered servers

Documented processes used to establish new servers and database standards

Experienced with ETL process which was used to extract, transform and load data from the OLTP database to the data mining database

Maintained changes across all environments and ensured databases consistency utilizing Redgate SQL Compare product and SQL Tablediff utilities

Online Resources Card and Credit Services [Database Administrator] 9/2005 – 11/2007

Performed product upgrades and implemented Client Custom code across four separate environments (Dev, QA, UAT, and Production) for various clients

Part of a team (4) that provided production support (24 by 7) of MS SQL Server databases used by the web sites

Integrated client private label credit card brand and the virtual collection product into the existing Client account presentation site

Created a monthly activity and enrollment report used by management for client billing

Generated custom monthly reports supplied to the clients

Utilized DTS / SSIS to migrate data between environments

Performed initial client testing and implementation of MS SQL Server version 2005 across the various environments

Performed SQL Performance and indexing tuning as needed

Champion Workflow Systems [Managing Consultant] 1/2003 – 9/2005

Conducted client requirements gathering, generation of specifications documents and design of customized document storage destinations

Designed and created database stored procedures for web sites developed for client back-office sections that allowed them to maintain their own sites

Developed SQL backup/recovery scripts and participated in client disaster testing

Created and executed customized training programs for clients

Developed an application using Excel object and document management system to automate the branch reporting and daily totals which eliminated 90 minutes of work daily

Built DTS scripts to load client account information and wrote applications that were used to scan and index images for back file projects

Previous Employers:

Ciber Information Services [Consulting] 3/1996 – 2/2002

Bank of New York [Stock Transfer] – Client 4/2001 – 2/2002

Society General [SG Cowen] – Client 12/1998 –3/2001

JP Morgan [Private Client Group] – Client 10/1997 –11/1998

Chase [Chase Investment Services] – Client 3/1996 –10/1997

Bankers Trust Company 10/1986 – 2/1996

Training:

Microsoft SQL Server Administration & Microsoft SQL Server Programming

Microsoft Visual Basic & Microsoft Advanced Visual Basic

Certificates:

Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. - MS 070-229

Groups:

Member of North Jersey NJSQL, Central Jersey NJSQL, PASS

Contact this candidate