Database Administration Resume Profile, GA - Hire IT People

TECHNICAL SUMMARY

SQL Server Management Studio, 2012, 2008 R2, 2005, 2000
ETL, SQL Server 2012 Data Tools, BIDS
SSIS Integration Services
SSAS Analysis Services
SSRS Reporting Services
TSQL, Stored Procedures
DBA Database Administration

EXPERIENCE

Confidential

Database Administration

Working on new production server system build out project, implementing SQL Server 2012 AlwaysOn Availability group database failover in a clustered architecture environment. Upgrade from 2005.
Managing scheduled production job system for database backups, Database maintenance admin scripts, recoveries to Dev and QA environments.
Working with problem tools including SQL Profiler, analyzing execution plans to determine best course of remediation from TSQL redesign, index tuning, and statistics updates.
Development of TSQL database maintenance scripts.

Confidential

ETL Data Integration Developer

Expected responsibilities were to include research, analysis and development of TSQL, SSIS and Talend ETL ESB data movement application packages, for Data Warehouse and BI reporting structures. Project canceled.

Confidential

ETL Data Integration Developer

Work with Business Analysts to analyze data sources and define business and IT requirements.
Design and develop SSIS packages for ETL data conversion, transformation and aggregation BI reporting.
Tools include SQL Server 2008 Integration Services SSIS 2008, Business Intelligence Development Studio BIDS 2008, TSQL stored procedure, VB scripts and Tortoise SVN source management.
Provide scheduling, production support and maintenance of IT data operations.

Confidential

SQL Server 2005 Development/System Database Administration

SQL Server Database Administration, monitor server system resource activity, develop TSQL Stored Procedures implementation scripts to perform database maintenance routines, SDLC migrations, index maintenance tasks, user account administration, performance tuning, and production support for SAAS Internet Procurement system for 50 database multi-server and 300 database single-tenant schema systems.
Tools included SQL Server 2005, development of T-SQL Stored Procedures, Performance Monitor, SQLdm, Litespeed, SQL Profiler, Tuning Advisor and implementation of SQL query best practices.
Developed Reporting Services SSRS management reports, TSQL Stored Procedures and Integration Services SSIS maintenance routines.
Transitioned to Ariba, responsible for 24x7 on-call production operation support. Implemented application code migrations, user account administration and escalated production trouble ticket.

Confidential

DBA, Data Analyst

Consultant on Database Administration best practices, data integrity and analysis on DBMS Primary/Foreign Key constraints, Indexes and configurations.
Work with Business Analysts to define and document data integrity best practices, exception handling requirements for State Medicare/Medicaid billing reconciliation and administration.
Develop, schedule and maintain DTS packages, T-SQL Stored Procedures, data system documentation, dataflow diagrams, monitoring of performance statistics and SQL queries.
Tools included SQL Server 2000, SQL Query Analyzer, DTS and MS Visio.

Confidential

Solutions/Business Analyst

Facilitated requirement gathering sessions with business users and project stake holders.
Database/Tools included Teradata, Erwin, and SQL Assistant/Queryman.

Confidential

Sr. Business Analyst

Meet with business users, define and communicate IT and business requirements, defined and implemented system plans for paperless policy declaration implementation project.

Confidential

Sr. IT Engineer/Programmer Analyst, ETL Data Warehouse Development

Developed ETL COBOL data movement applications, developed data approach strategies for major airline reservation booking and marketing BI reporting data warehouse in MVS JCL Mainframe environment.
Major accomplishments as senior lead developer include reengineering monthly source feed for MIDT data warehouse comprised of 800 million data rows and development of a daily detail level BI reporting capability. Optimize application production batch system runtimes to increase batch window.
Attended Data Warehouse Institute conferences, Advanced SQL Techniques, IBM, DB2 User Group.

Confidential

Sr. Programmer Analyst Insurance/Finance

Performed Y2K impact analysis, developed technical specifications and documentation and modified DB2 database applications. Functioned as lead analyst on mission critical project for development and consolidation of Agency Sales, Policy administration system. Lead system test analyst.

Confidential

Sr. Programmer Analyst Insurance/Finance

Analysis, development and testing of COBOL/II, IDMS 12.0, CICS, VSAM and JCL utilities.

Confidential

Sr. Programmer Analyst Manufacturing/Distribution

Developed ETL data extract and data conversion applications for integration from Mainframe IDMS to SAP Customer Master, Vendor Master, and Material Master on Unix Client Server platform.

We provide IT Staff Augmentation Services!

Database Administration Resume Profile

GA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship