Database Administrator and Developer Resume Towson, Maryland - Hire IT People

SUMMARY:

Over 20 years of IT experience in MS SQL Database Administration and SQL Development
Designed, maintained and supported OLTP and OLAP databases versions SQL Server 4.2 to SQL Server 2016
Expertise in Transact - SQL (DDL, DML, DCL) and in design and normalization of the database tables
Visual Studio
ETL tools (Informatica, Datastage, DMExpress, SSIS)
Experienced with Windows and Office applications
Designed Data Models with Erwin and Visio

PROFESSIONAL EXPERIENCE:

Confidential, Towson, Maryland

Database Administrator and Developer

Development of SQL procedures, views, SSIS packages used in design and daily loading of the warehouse.
Worked with team to designed and built data warehouse from source system tables.
Daily technical support of database environment and supporting all phases of SDLC.
Proactively monitor systems to ensure services and daily reports are created.
Build and support ETL processes from all incoming source systems.
Create and maintain SSRS reports and report server.
Developed dashboards using SSRS, Power BI and Excel.
Integrate multiple policy source systems and claim systems into data warehouse.
Help develop SSAS cube and DataMart’s for reporting.
Provided administration and maintenance to all SQL environments.
Worked with web services and development teams to deliver content to clients.
Migrated databases from SQL 2008 to SQL 2016.
Maintained company internal SharePoint site permissions and data.
Integrated SSRS reports and dashboards onto SharePoint site.

Confidential, Prince Fredrick, Maryland

Database Administrator and Developer

Implemented disaster recovery procedures, backups, and policies to support expansion of systems to higher availability.
Installed and configured ActiveBatch enterprise job schedule program within two domains.
Setup database jobs and processes within the ActiveBatch creating a daily schedule of jobs and email reporting.
Trained technical support and applications staff to better utilize on-line processing databases environment.
Provided SQL tuning of queries and processes to better support web based applications.
Worked with EDI application to feed billing database.

Confidential

Sr. SQL Developer/DBA/ETL Developer

Responsible for the coding, maintenance, data requirements, database design and specifications to satisfy client business objectives using Microsoft’s SQL Server .
Team leader in the conversion of DataSource, a proprietary data set that fuels omni-channel, people-based marketing across the entire consumer journey, from mainframe to SQL Server data warehouse.
Senior team member in the development of automated DataSource daily processing.
Design and develop data models, implement databases, and write stored procedures.
Implement processes that automate the building of data marts.
Analyze content and quality of databases.
Develop extraction and loading processes.
Provide database administration during full life cycle of systems.
Oversaw implementation of DMExpress (ETL Tool) into corporate environment and provided technical support to database teams.
Developed loading and extracting processes using Informatica 9.1.
Converted SAS “database” into MS SQL Server data warehouse.
Team leader of web base client query tool using SQL Server, IIS and Message Broker.
Technical team leader and designer for automated applications that imported and exported data from SQL Server based off client extraction rules.
Developed online data dictionary and sample count system that provides information on over 1500 database fields and merged information from 35 sources.

Confidential

Self-employed Windows (MCSE) and SQL Server Consultant |

Data Computer Corporation of America: Setup SQL Server replication between Social Security Administration and client.
Department of Justice: Migration of mainframe COBOL systems to new three tier client-server application using SQL Server 7.0, Internet Information Server and Active Server Pages. Provided network administration support on Windows NT Servers, SQL Server 6.5 and 7.0 systems.
GMAC Commercial Mortgage: Provided technical support, performance tuning, relational data modeling, database design, physical SQL / Server & NT support, wrote stored procedures and triggers for client-server based mortgage asset management. Performed database installation, Headed up team to review backup and recovery operations and make recommendations for any disaster recovery options.
NASDAQ: Worked within development team as lead database administrator and SQL developer of Phase 3 Market Watch and the Surveillance Delivery Real-Time project. Installed new systems and setup clustered server configuration.
NAVAIR: Team member responsible for designing and developing database to support Workforce Shaping web based application used to by NAVAIR Command and its human capital strategy.