Principal DatABASE Architect Resume

SUMMARY:

Confidential is a “hands on” leader with over thirty years of experience with relational Database technologies. He has been responsible for design, implementation and support of critical enterprise relational database solutions. Throughout his career, Confidential has successfully integrated innovative database solutions to meet both business and technology solutions at all levels of systems development from design through Implementation.

KEY SKILLS:

Microsoft SQL Server

T - SQL

Reporting Services

SharePoint

C#.Net

TECHNOLOGY SUMMARY:

DATABASES: Microsoft SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, Oracle (8i - 11gR2), IBM DB2 LUW (7-10), IBM DB2 Z OS (1-10)

SYSTEMS: Microsoft Windows 8, Windows Server 2012, Windows Server 2008 R2, Linux, UNIX, AIX, z/OS

LANGUAGES: T-SQL, PL SQL, XQuery, I SQL, C#.net, Windows Powershell, Bash Script, Linux Command, Unix Command

SOFTWARE: SQL Server Management Studio, SSRS, SSIS, SharePoint 2010, Visual Studio, Visual Studio Team Foundation Server 2013, Oracle Enterprise Manager, Idera Diagnostic Manager, IBM Control Center

IT EXPERIENCE:

Confidential

Principal DatABASE Architect

Responsibilities:

Hired and Lead Team of DBA’s responsible for HA SQL Server 2016 environment
Lead migration from SQL Server 2008 to SQL Server 2016
Implemented Service Broker for Selective data replication
Introduced use of SSISDB
Implemented Tool Based Database Monitoring strategy
Provided technical guidance to DBA team
Developed and tuned complex SQL solutions to meet business needs

Sr. database Consultant

Confidential

Responsibilities:

Performed technical design and coding of SQL Service Broker solution
Developed procedure to generate Service Broker definitions, triggers and stored procedures for Service Broker solution
Assessed HA/DR solution using AlwaysOn Availability groups
Implemented batch process to load flat file transactions into SQL Tables
Prototyped in memory optimized solution to generate dynamic SQL

Confidential

Sr. Database Administrator

Responsibilities:

Responsible for all aspects of data management for statistical reporting and business operations for an American sports organization that runs a tour for elite female golfers from around the world.
Establish and Maintain Meta Data and Business Data descriptions
Authothored Statistical calculation processes reflecting player performance
Authored Financial Reconciliation processes
Automated creation of data abstraction views and CRUD operations
Performed architectural review of all Tier I application database solutions
Responsible for management of production support group for open database systems
Managed and Mentored 13 staff members supporting over 60 SQL Servers with databases of size ranging from 40GB to 20TB, as well as Enterprise Oracle 11g, 10g, RAC, and UDB on AIX
Responsible for data components necessary to enable business continuity to include annual testing of disaster recovery

Confidential

Reporting Analyst

Responsibilities:

Performed architectural review of all Tier I application database solutions
Designed and implemented database to support and enhance the extract process and its performance.
Designed and created UDB tables.
Performed unloads, loads and run stats In the Unix environment using IBM utilities.
Developed data sub setting process to extract relationally intact data for various testing requirements. Data resided in DB2 and Oracle Including over 1100 tables.
Generated Oracle stored procedures from a rule based metadata repository.
Coded hundreds of lines of complex Oracle SQL for that system.
Provided Advanced SQL Coding and performance consulting to senior technicians.
Design upgrades to batch application architecture to in corporate an error reporting and transaction resubmission capability.
Responsible for designing and implementing a DB2 Database for a metadata model. Developed a Windows GUI application to maintain that database.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship