We provide IT Staff Augmentation Services!

Ms Sql Dba And Etl Developer Resume

Alexandria, VA

PROFESSIONAL SUMMARY:

  • Microsoft certified SQL DBA, SQL Developer, SSIS/SSRS Developer, ETL Developer,
  • 6 years of experience in SQL server Database Administration, Data Warehouse model development, ETL package building, SSRS development using MS SQL Server versions 2005, 2008, 2008 R2, 2012 and 2014,
  • Experienced in setting up high availability and DR options like log shipping, mirroring, replication (Transactional or Snapshot) and Always On Availability Groups,
  • Proficient with SQL Server Disaster Recovery, Backup/Restore and creating Business Continuity Planning,
  • Experience in Database Migration, Migrated SQL Server 2008 to SQL 2008R2, SQL Server 2008R2 to 2012,
  • Extensively worked on SQL Server and T - SQL in constructing database objects, tables, triggers, user functions, views, indexes, stored procedures, join, user profiles, and relational database models,
  • Hands on experience in creating Maintenance plans, scheduling SQL Server Jobs, Automatic administrative task and Configuring Database Mail,
  • Proven experience in creating implementing Database objects like Stored Procedures, Triggers, Views, User Defined Functions,
  • Experience in implementing SQL Server security and managing permission to the Database through Database roles, Creating Users and Logins,
  • Applied Service Packs and security updates for SQL server instances,
  • Proficient in Data Analysis, Data Modeling, Database Design and Data Migration, data loads, database integration/conversions, performance tuning and optimization,
  • Proficient in developing Custom Reports and different types of Chart, Tabular, Matrix, Ad hoc reports and distributing reports in multiple formats using SSRS.
  • Excellent in High Level Design of ETL Packages for integrating data from heterogeneous sources (OLE DB, Access, Excel, Oracle, flat file, Text Format Data, XML, Raw file,).
  • Proficient in working on all activities related to the development, implementation, administration and support of ETL processes for Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008R2.
  • Skilled in Database programming for Data Warehouses (Schemas), proficient in Stars Schema Modeling, Snow Flake Modeling and reporting tools,
  • Executed for fine tuning of the database, user administration, memory management, and running DBCC (Rebuilding Indexes and fine-tuning Stored Procedures),
  • Proficient in Data Warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture),
  • Expert in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache also developed drilldown reports using MDX and SQL,
  • Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
  • Experienced in generating on-demand and scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008/2012 (SSRS)
  • Well experienced in Query Optimization, Client/Server connectivity, Performance Tuning, Database Consistency Checks using DBCC utilities, DMV's.
  • Experienced on working with production Servers and 24 x 7 On-Call environments.
  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills as well as flexible to learn advancements in the IT industry.
  • Highly motivated, dedicated, well organized, interpersonal communicational skills and goal oriented.

TECHNICAL SKILLS:

  • MS SQL Server 2014/2012/2008/ R2/2005
  • SQL Server Management Studio (SSMS)
  • SQL Server Data Tools
  • Business Intelligence Design Studio (BIDS)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Analysis Service (SSAS)
  • Rapid SQL
  • Data Transformation Services (DTS)
  • Oracle Data Base
  • SAP Crystal Report
  • Query Analyzer
  • Erwin Designer
  • ER-Studio
  • Visual Studio
  • MS Excel
  • MS Office
  • MS Access
  • Share Point
  • Power Point
  • Team Foundation Server (TFS)
  • Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

MS SQL DBA and ETL Developer

Responsibilities:

  • Created staging tables and SQL scripts to implement business logic loaded data from sources such as Relational tables, Flat files, MS SQL Server and DB2 tables to Data Warehouse and target tables.
  • Schedule jobs to run automatically using SQL server agent and created variables and configured files to make the SSIS package more dynamic.
  • Designed and converted different DTS packages in to one SSIS package and created email notification SQL task inside the package to send an email if tasks in the package workflow succeed or fail.
  • Performed data cleansing and massaging using various transformation components in SSIS including Conditional Split, Derived Column, Merge Join, Multicast, Sort, Union, Fuzzy lookup all and Row Count Transformations.
  • Creating tables, schemas and DDL for Test, Development and Production environments.
  • Testing and preparing Testing documents for the SSIS packages before moving into production environment.
  • Developed summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services.
  • Performed performance tuning like partitioning of sources, targets, mappings and SQL queries used in Source Qualifier to provide maximum efficiency.
  • Performed Unit, Integration and Regression Testing of ETL jobs, applications and data in target tables and checked data integrity and any quality related problems.
  • Preparing documentation using the sample template for future reference and maintenance.
  • Administered the SQL Server security by creating logins (Windows authentication and SQL server Authentication mode) and grant the minimum privileges to the users and actively monitoring them
  • Involved in automating database administration tasks like scheduling Tasks, Setting Alerts, configuring SQL server agents, Managing Task Scheduling, setting up SQL database Mail, Managing Alerts and operators, Monitoring and Tuning SQL Server
  • Identified orphan users and troubleshoot by creating similar SID (security ID) value for the users and logins
  • Worked curiously in avoiding single point of failure by implementing the best fit high availability solutions (Always-on, Failover Clustering, Mirroring, Log Shipping, Replication)
  • Executed for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).

Environment: MS SQL Server 2014/2012, MS-SQL Server Integration Services (SSIS), Oracle Data Base, SAP Crystal Report, T-SQL, ER-Studio, Visio, Windows 7.

Confidential

MS SQL DBA, SQL Developer, SSRS Developer

Responsibilities:

  • Installed new SQL instances, applied service packs, performed in-place and side-by-side upgrades based on the build requests.
  • Created Stored Procedures, triggers, cursors, tables, and views and Join statements for applications by using T-SQL.
  • Created Sub-reports, drill down Reports, Summary Reports, Parameterized Reports, and Ad-hoc Reports using SSRS and developed complex stored procedures and functions to generate dash board reports.
  • Created jobs, alerts to run SSAS, SSRS packages periodically, automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
  • 24x7 Production DBA support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
  • Designed, Implemented and Maintained Database Schema, Entity Relationship Diagrams, Data Modeling, Tables, Stored Procedures, Functions, Triggers, Constraints, Indexes, Views and complex SQL statements.
  • Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins and created clustered/non-clustered indexes.
  • Used T-SQL for creating various Complex Objects like Tables, View, Functions and Stored Procedure for storing and processing data in required form.
  • Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task.
  • Worked extensively with business users gathering requirements to generate customized SQL reports using SSRS.
  • Troubleshooting issues in Production, Development, QA, and Testing environments
  • Scheduled backups and performed restore operations for system test data depending on developers’ requirement.
  • Involved in disaster recovery procedures for production servers.
  • Performed T-SQL tuning and optimizing queries.
  • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.

Environment: Windows Server 2012, SQL Server 2008 and 2008 R2, SQL Profiler, SQL Query Analyzer, SSIS, Upgrade Advisor

Confidential

SQL Server DBA

Responsibilities:

  • Installed new SQL instances, applied service packs, performed in-place and side-by-side upgrades based on the build requests.
  • Created Stored Procedures, triggers, cursors, tables, and views and Join statements for applications by using T-SQL.
  • 24x7 Production DBA support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
  • Troubleshooting issues in Production, Development, QA, and Testing environments
  • Scheduled backups and performed restore operations for system test data depending on developers’ requirement.
  • Involved in disaster recovery procedures for production servers.
  • Performed T-SQL tuning and optimizing queries.
  • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.

Environment: Windows Server 2003, SQL Server 2008 and 2008 R2, SQL Profiler, SQL Query Analyzer, SSIS, Upgrade Advisor, DTS Designer Tools

Hire Now