SQL Server Database Developer/ Administrator/Architect

Professional Profile

Experienced SQL Server Database Developer/ Administrator/Architect SSIS, SSRS, 2005, 2008, 2008 R2 Database Design, Tuning, Data Modeling, Stored Procedures, Triggers, Complex T-SQL, ETL, TFS, XML, Database Migration, SDLC, OLTP, OLAP, VLDB. ER Studio, Experience with Health Care Data.

Education

• Master of Information Systems 2012
  Confidential
• Master of Science in Soil Survey 1995
  Confidential, Enschede, Netherlands
• Bachelor of Science with Honors in Geography 1986
  Confidential, Freetown, Sierra Leone

Technical Skills

• Database Skills: MSSQL Server 2000, 2005, and 2008, 2008 R2, SSAS, SSRS, DTS\\SSIS\\ETL, BIDS, Visual Studio 2005 and 2008, 2010; TFS, Oracle 9i, ArcSDE, Access, Excel, dBase, Report Writers, ApexSQL, Idera SQLSafe, RedGate ToolBelt, ER Studio, Erwin
• Languages: T-SQL, SQL, PL/SQL, VB/VBA, HTML, XML .NET
  Operating Systems: Windows, Linux, Unix
• GIS Software: ArcView 3x, ArcInfo, ArcGIS 8, ArcGIS 9, ArcIMS, Integrated Land and Water Illustration System (ILWIS), MapInfo.
• Other Software Microsoft Office products, Graphic Presentation software etc.

Licenses and Certifications

Oracle Certified Associate (OCA)
Microsoft Certified Technology Specialist
Master Certificate in Oracle Database Administration
(Computer Career Institute at Johns Hopkins University)
Several ESRI short course certificates

Career Progression

Confidential, Vienna VA January 2012 – Present
DBA (Sub-Contractor)
Federal Transit Administration (FTA) Transportation Electronic Award Management System (TEAM) provides functionality for monitoring FTA awards and grants. As DBA, my role is to provide database support for migration of TEAM application databases from Ingres database platform to Microsoft SQL Server 2008. The tasks involve but not limited to

• Data migration and cleansing from Ingres to Microsoft SQL server 2008
• Data migration and cleansing from MSSQL 2008 to Oracle 11g Database
• Recreating database and programmability objects in Microsoft SQL Server
• Re-architecting database design for normalization and performance enhancement.
• Translating application reports to Microsoft Reporting Services
• Database Disaster Recovery and Data Testing Documentation
• Create Data Dictionaries
• Documenting recommendations for best practice standards, required application and database changes for next generation application.

Confidential, Rockville MD July 2011 – December 2011
Database Architect\\DBA (Sub-Contractor)
Integrated Partner Management (IPM) Project
Federal Student Aid (FSA), Washington DC.

• IPM project is intended to consolidate seven disparate systems that provided FSA with functional capabilities to process, monitor, and manage federal student aid. As database architect \\DBA, I was responsible for translating project requirements into logical data model and eventual physical database design using Embarcadero ER/Studio.
• Support source to target mapping for ETL data migration.
• Developing complex stored procedures, and other database programmability objects to support data movements between tables and management of historic data.

Confidential, Washington DC February 2011 – April 2011
Sr. SQL Developer\\DBA (Sub-Contractor)
Investigative Data Analytics (IDA) Project
Internal Revenue Service (IRS), Washington DC.

• IDA project provides data from different sources to facilitate the Crime Investigation Department of IRS conduct investigations. As DBA\\Developer, I developed complex stored procedures, functions, and other database programmability objects to expedite the acquisition, cleansing, transformation, and loading of data from different data sources into a data mart to support entity search engines.
• Other duties included developing reports to support ETL processes, performance tuning and index optimization, backup, recovery, and disaster recovery.

Confidential, Columbia, MD August 2010 – February 2011
Sr. SQL Developer\\DBA (Consultant)
Ameritox provides laboratory test results for pain medication monitoring. As a consultant, my major accomplishments included providing technical leadership to accomplish the following

• The implementation of High Database Availability through Mirroring, Replication, and Log Shipping strategies using SQL 2008 R2.
• Managed migration of SQL 2005 databases to SQL 2008 R2.
• Managed database backup, restore, disaster recovery, and high availability.
• Database maintenance, performance tuning and index optimization
• Developed complex stored procedures and other programmability objects to expedite various business processes
• Designed and developed ETL solutions for data loads and extraction using SSIS for test data refresh.
• Installation, configuration, and documentation.
• Coordinated database security and server access with system administrators.
• Designed, developed, and automated reporting using SSRS.
• Debugged, analyzed, and resolved long running queries.

Confidential, Silver Spring, MD February 2010 – August 2010
Sr. IT Consultant (Contactor)
Harris Corporation is one of the biggest federal defense contractors. Harris Health Solutions provides IT solutions for managing the Department of Veteran Affairs health related information. As senior IT consultant,

• Designed and developed ETL packages to extract data from various database systems into a central Registries Data Warehouse using SQL 2008.
• Redesigned and developed on-demand reports with SSRS.
• Provided DBA support for Backup, Restore, and migration of Databases
• Developed complex stored procedures to expedite ETL processes.
• Performed database performance tuning and optimization
• Worked with database architect to design and build data marts.

Confidential, Columbia, MD August 2009 – February 2010
Contract IT Consultant
AscendOne and its family of businesses provide consumer debt management and resolution by providing an umbrella of services.

• Designed and developed an enterprise reporting solution using SSRS 2008
• Automated daily routine reporting from Excel to Reporting services
• Designed and built new reports in support of executive and management decision support processes.
• Developed complex stored procedures to support reporting projects.

Confidential, Bethesda, MD March 2008 – August 2009
Senior Database Developer
CoStar provides information services to commercial real estate professionals in the United States and the United Kingdom

• Provided technical team leadership and documentation for database development team.
• Successfully migrated the Enterprise Databases from MS SQL 2000 to 2005 and 2008
• Developed complex T-SQL scripts, stored procedures, functions, views and other database objects.
• Created and deployed ETL\\SSIS packages to meet project requirements.
• Performed database performance tuning and query optimization.
• Researched and resolved all production T-SQL related application errors and job failures.
• Performed database change impact analysis
• Used database administration experience to work with DBA team to implement database schema and programmability changes
• Created database performance reports using Microsoft Reporting Services.

Confidential, Germantown MD January 2008 – February 2008
SQL Developer
Developed scripts for building database objects and data loads from external flat files

Confidential, August 2006 – December 2007
SQL DBA
On contract to Social Scientific Systems (SSS) as DBA for US State Department projects.
These projects were implemented with Microsoft SQL server 2000 and 2005.

• Installed and configured SQL Server2005 instances including service packs,
• Migrated SQL 2000 Databases to SQL 2005 environment
• Performed database backup, recovery , maintenance and disaster Recovery
• Coordinated database change mechanism and database change impact analysis
• Implemented database Mirroring, replication and Log shipping
• Database performance tuning and query optimization
• Developed database objects including complex T-SQL scripts and stored procedures, functions, views, tables, indexes, etc...
• Coordinated database security and server access with system administrators.
• Developed and deployed SSIS packages to expedite ETL processes
• Provided documentation on server configuration and databases
• Researched, documented, troubleshoot and resolved production problems

Confidential, Bethesda, MD January 2006 – July 2006
SQL Database Administrator/ Developer
Sub-contractor to Fannie Mae as a Microsoft SQL Server 2000 Database Administrator/ Developer.
As DBA/Developer, I was solely responsible for maintaining and reporting on the central database that supported Software management Systems (SMS) within Fannie Mae. These responsibilities include besides running queries for specific information

• Improved Software Management System(SMS) reporting
• Created and managed related databases
• Created tables, views, stored procedures, and indexes to support SMS reporting.
• Created DTS packages to implement SMS ETL process.
• Designed and build custom reports
• Performed database backup, recovery and maintenance.

Confidential, March 2005 – December 2005
Database Analyst
DC&C is an IT company providing web based applications and online database management

• Created and maintained databases for clients based on DD&C model databases
• Designed and created DTS packages
• Created stored procedures, functions, triggers, tables, views and other database objects
• Designed and build client specific custom reports
• Migrated MS Access databases to SQL Servers 2000 databases;
• Performed data massage, scrubbing and processing with third party tools

Confidential, Netherlands January 2001 – December 2003
Geographic Information Systems Analyst

• Data capture, transformations, analyses, interpretation and presentation
• Administered non spatial geo-database in SQL Server 2000;
• Developed project based reports
• Designed and developed database entry templates
• Cartographic production and distribution of quality digital maps and hard copies
• Contact person between the department, research bureaus, and other agencies collaborating in GIS related data and information management.
• Provided training to new GIS users
• Provided senior management with reports to support decision management systems.
• Served as departmental representative to various inter-departmental and regional technical support groups.

Clearance: Public Trust