Database Developer/ DBA Resume Washington, DC - Hire IT People

SUMMARY:

Extensive experience in database development and administration.
Experience in Implementing SSIS, SSRS, and SSAS for data warehouse & data mart solutions.
Extensive experience in designing and documenting Conceptual, Logical and Physical data models.
Extensive experience with SQL server database monitoring, tuning and automation using job creation and analyzing database performance and allocating server resources to achieve optimum database performance.
Excellent report creation skills using Microsoft SQL Reporting Services
Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server.
Extensive experience with T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles.
Experience in developing SSIS Packages, building cubes, data warehousing/BI and data mining.
Excellent working knowledge of ETL.
Experience in design and development of Data warehouse & business intelligence solutions using ETL tool SSIS.
Proficient with Reporting Services such as, building tabular report, matrix report, chart report, parametric reports,
Experience in the Software Development Life Cycle (SDLC) methodologies such as the requirement analysis, design, development, testing and deployment

TECHNICAL SKILLS:

RDBMS: SQL Server 2000/2005/2008

Languages: .NET, T-SQL

MSOffice: Microsoft Office Tools.

Operating Systems: Windows-2k/XP/NT

Internet Tools: HTML, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Database Developer/ DBA

Responsibilities:

Involved in design and implementation of a database
Designed DDL and DML for MS SQL Server 2000/2005/2008 ; developed stored procedures and views for managing efficient data retrieval.
Extensively used SSRS, SSIS and SSAS.
Developed complex Reports for the Finance and Training Departments
Loaded data in to the Data warehouse using SSIS, build cubes for analysis, made through analysis on the data and came up with reports using SSRS.
Developed more than 15 cubes for different projects using SSAS.
Ensured data integrity and performance of databases
Installed, configured and upgraded different SQL Servers
Gathering and analyzing database requirements.

Environment: SQL Server 2008/2005, SSAS, SSRS, SSIS, Windows 2008/2003/2000

Confidential, Alexandria, VA

Database Developer/DBA

Responsibilities:

Created complex stored procedures and functions to support efficient data storage and manipulation.
Created all administration tasks of SQL Server and designed databases.
Created groups, roles, users and assigned access privileges to them.
Monitored and scheduled existing/new jobs on production environment.
Responsible for keeping system and databases up-to-date making necessary changes.
Performed performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS.

Environment: SQL Server 2005/2008

Confidential, Atlanta, GA

Database Developer/ DBA

Responsibilities:

Wrote and implemented functions and stored procedures using MS SQL Server.
Developed and published ad hoc reports and added drill through functionality using SSRS, and created tabular, matrix, and graphical reports from multiple data sources (relational and multidimensional) using SQL Server 2005 Reporting Services.
Managed and implemented SSIS packages to do the nightly refresh of data.
Developed and implemented ETL.
Developed, executed, documented, and maintained appropriate BI procedures.
Met regularly with business clientele to review change requests and produce operational reports.
Answered technical inquiries and responded to troubleshooting requests.

Environment: SQL Server 2005, Analysis Services, Integration Services and Reporting Services

Confidential, Atlanta, GA

Database Developer

Responsibilities:

Create SSIS Packages to Extract, Transform and Load data into database.
Load data from flat files, excel sheets, access database into the target MS SQL Server 2005 database.
Used SSAS and SSRS to create cubes and reports for business users.
Export data from MS SQL Server 2005 database to flat files for internal system usage.
Write stored Procedures, functions, views and index.
Interact with analyst and business users to get requirement for ETL process and Reporting.

Environment: MS SQL Server 2005