Senior Database Administrator/Manager

5/2005 - Present

Individual Contributor

10/2003 - 5/2005

QCSI - Trizetto

Individual Contributor

• Supervised database developers and junior/senior database administrators. Performed MS SQL Server 2000 database administrative duties. Managed 5 servers with 40+ databases including database implementation, maintenance, security issues. SQL Development included database design and development of all database structures, maintaining database data integrity. Database backup and restores. Database and table design. Supported developers in development and coding issues. Researched and supported changes to enable data integrity and quality. Used Reporting Services and Crystal Reports to create reports from databases. Scheduled reports for On Demand Server and exported to HTML documents for web site viewing. Data load creation and extraction using DTS. Creation of logons, users and roles using NT and SQL Authentication. Responsible for the tuning of stored procedures and trigger codes. Responsible for system analysis and complete system and database documentation. Set up and administer QA product Test Director Databases and product administration.

2/2003 - 10/2003

Wireless Retail Inc

Manager

• Managed 15+ servers with 25+ databases including database implementation, maintenance, security issues. Database and table design. Supported developers in development and coding issues. Researched and supported changes to enable data integrity and quality. Merged and Transactional Replication. Data load creation and extraction using DTS. Creation of logons, users and roles using NT and SQL Authentication. Responsible for the tuning of stored procedures and trigger codes. Responsible for the resolution of all data inconsistencies and anomalies. Responsible for system analysis and complete system and database documentation. Supervised database developers and junior/senior database administrators. Supported Solomon and Kronos Databases and Administration. Supported Oracle 9i installation and database administration. Supported development of WMS (warehouse management systems).

10/2001 - 2/2003

Rohm and Haas Company

Individual Contributor

• Performed MS SQL Server 6.5, 7.0 and 2000 database administrative duties. Managed 110+ servers with 1500+ databases including database implementation, maintenance, security issues and performance tuning. SQL Server 6.5 migration to SQL Server 7.0 and 2000. Snapshot and Transactional Replication. Data load creation and extraction using DTS. Responsible for the resolution of all data inconsistencies and anomalies. Responsible for system analysis and complete system and database documentation. Creation of logons, users and roles using NT and SQL Authentication. Maintenance of Data Warehouse servers. Responsible for the performance tuning of all back-end processes for financial, PRS(problem resolution systems) and manufacturing systems hosted on multiple MS SQL-Server 6.5, 7.0 and 2000 servers, including tuning of stored procedures and trigger codes, and operating system configuration. Creation of OLAP cubes and star schemas. Development creation of snowflake schemas. Responsible for the resolution of all concurrency bottlenecks, including lock contention and deadlocks. Supervised database developers and junior database administrators. Supported Peoplesoft Databases and Administration.

2009

Master Degree

University of Phoenix

• Information Systems

2006

Bachelor Degree

University of Phoenix

• Information Technology