Database Administrator Resume Profile

SUMMARY OF EXPERTISE

4 years' experience in Database Administration and MS SQL Server Development, including implementing and modeling Data Warehouse/Data Marts objects, Scripting and Tuning TSQL query, Developing and Tuning SSIS packages, SSRS reports, and SSAS cubes.
Experience in gathering and transferring business details from end users to technical requirements. Experienced in technical documentation such as Data Mapping Docs and Data Dictionary.
Experience in optimizing Data Warehouse/Data Marts objects, such as dropping and rebuilding Indexes, Creating Column Stored Indexes and Creating Partitions. Expert in performance tuning of TSQL queries.
Extensive experience in planning, designing and creating ETL packages to conduct Data Migration and Cleansing. Expert in manipulating Slowly Changing Dimension with Type 1 and Type 2 SCD by using SSIS.
Expert in performance tuning and debugging SSIS packages by configuring Buffer, redirecting Error Flow, setting Breakpoints and using Event Handler. Expert in parameterization of SSIS packages.
Experience in generating various kinds of reports using SSRS, including Parameterized Drill-down/Drill-through reports, Sub-reports and Linked reports. Expert in creating Pie Charts, Bar Graphs and Maps in SSRS.
Experience in developing Tabular Models in SSAS, including loading data, scripting DAX/MDX queries, and building Hierarchies inside Tabular Models.
Possess Good work ethics with excellent communication and interpersonal skills. Strong attitude towards learning new technologies and quickly applying to the project supporting.

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server DBA/ETL Developer

Worked with enterprise Data Warehouse Environments, participated in designing and modeling data models for Snowflake/Star Schemas for Data Warehouse/Data Marts. Conducted normalization and de-normalization for dimensions. Created Entity Relationship Diagram using Microsoft Visio and Erwin.
Gathered and transferred business requirements from clients to specific technical requirements. Created technical documentation for developing database schemas and objects.
Reviewed Complex TSQL queries created by team members and manipulate database objects including Tables, Views, Indexes, Stored Procedures, UDFs and Triggers. Managing roles to maintain database security.
Managed Transactions in database development by configuring the Isolation Levels.
Conducted ETL process for data migrating and data cleansing using SSIS Dataflow Tasks. Using SSIS control flow tasks to migrate large scale data files between different servers.
Implemented Slowly Changing Dimensions in SSIS to manipulate regularly updated data, using Type 1 and Type 2 SCD. Used SSIS control flow tasks to implement Auditing and Linage.
Prepared shared and embedded datasets from various sources such as tables, views and analysis services cubes using TSQL queries and Stored Procedures.
Generated various kinds of reports using SSRS such as Drill-down/Drill-through reports, Cascading Parameterized reports, and Linked reports. Configured Report Manager and deployed reports to end users.
Developed Tabular Models for OLAP process using SSAS. Used DAX/MDX queries to retrieve data and debugging error.

Confidential

MS SQL Server Developer/ETL Developer/Database Administrator

Designed, and generated Views and Staging Tables for migrating data, by scripting TSQL Routines such as UDFs and Stored Procedures, and using complex Inner and Outer Joins.
Developed SSIS packages to conduct ETL process to migrate data from Enterprise-wide Data Warehouse on Mango DB and MySQL environment. Scripted SQL query in Script Component and Execute SQL Task.
Tested and debugged existing packages using Event Handler. Configured packages and conducted parameterization to existing packages to increase the reusability.
Provided production support. Optimized queries and ETL packages used in populating and data migration by using the techniques such as using Query Optimizer, creating Column Stored Indexes and Partitions
Created SSIS packages to automate maintenance, database backup and restoration, update statistics, re-build indexes as well as create error log for event during data load.
Optimized existing packages to reduce the storage use and increase the runtime performance, by modifying the package structure and configuring the tasks.
Conducted Software upgrade from MS SQL Server 2008 R2 to MS SQL Server 2012. Planed the databases and files migration.

Confidential

MS SQL Server Developer/Database Administrator

Worked with enterprise Data Warehouse environment, modeled dimensional schemas based on requirement
Migrating data from existing Excel and Flat Files to MS SQL databases using SSIS.
Created various T-SQL queries including creating tables, views, triggers, stored procedures and UDFs
Generated Drill-down/Drill-through reports and Cascading Parameterized reports using SSRS
Conducted regular database backup and restore.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship