We provide IT Staff Augmentation Services!

Sql Server Developer/dba Resume

5.00 Rating

New York City, NY

SUMMARY

  • Over 7 years of extensive experience in Database Solutions and BI Solutions using Microsoft Technologies
  • Experience in installation, configuration of MS SQL Server 2005 & 2008
  • Knowledge of upgrade from SQL Server 2005 to SQL Server 2008
  • Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2000/2005/2008 for Batch Processing using DDL, DML, DCL commands for various business applications and Data warehousing Systems (SSRS,SSIS, SSAS)
  • Experience in database programming in writing T - SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, Unique) Indexes and Batch Scripts using various DDL and DML commands
  • Master in designing and creating highly flexible database architecture to accommodate the requirements and enhancements of the client
  • Experience in Writing Complex T-SQL Queries, Dynamic-queries and Complex joins
  • Good experience with managing VLDB with SQL Server cluster for OLTP systems.
  • Thorough knowledge of addressing Performance Issues and Involved in Query Tuning, Index Tuning, Data Profiling and other database related activities
  • Involved in Huge Data Migrations and Data Transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert
  • Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying the packages across Development, UAT and Production environments
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
  • Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Access
  • Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 )
  • Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS
  • Experience in developing applications with ASP.NET, C#.
  • Experience in Developing and Extending SSAS Cubes, Dimensions and Data Source views SSAS - Data Mining Models and Deploying and Processing SSAS objects
  • Expert in Scheduling Database Backup and recovering the Database from Disaster
  • Experience in creating Jobs, Alerts, Database Mail, SQL Mail Agent and scheduled DTS/SSIS Packages.
  • Extensive experience in Database administration activities like DB Security (creating users, roles, and assigning permission to them)
  • Good understanding of Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services
  • Worked with End Users / Customers to understand business requirements, recommended technical solutions and documented functional requirements

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2000/2005/2008 , Oracle 9i, MS Access 2000/2003/2007

Operating Systems: MS-DOS, Windows Vista/95/98/NT 4.0/XP/2000/2003 Server, UNIX, Linux

Programming Languages: T-SQL, PL/SQL, Dynamic SQL, C, VBA, Visual Basic 6.0, C# .NET, VB .NET, ASP .NET, ADO.NET, XML, HTML, DHTML

Data Design Tools: ER/Studio, ERWIN, MS Visio, Rational Rose, Smart Draw

BI Tools: SQL Server Reporting Services (SSRS 2000/2005/2008 ), SQL Server Integration Services (SSIS 2005/2008), SQL Server Analytical Services (SSAS 2005/2008), Data Transformation Services (DTS), Visual Studio

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Performance Point Server, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, XML

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

SQL Server Developer/DBA

Responsibilities:

  • Interacted with Business Analyst and Team Lead to understand business and system requirements
  • Converted Logical Data Model into Physical Data Model using the balanced Normalization in 2nd and 3rd Normal Form for highest performance
  • Successfully implemented Physical Database on MS SQL Server 2008
  • Moved the static data from various heterogeneous sources like MS Access, MS Excel and text files to SQL Server 2008 Database using BCP, SSIS and dynamic DTS packages
  • OLAP experience like Analysis Services, Reporting Services, Business Intelligence, Integration Services
  • Created SSIS Packages to migrate slowly changing dimensions
  • Fine Tuned Database by creating Indexes on different tables that improve the performance of T-SQL queries on the Database
  • Maintained database response times, proactively generated performance reports
  • Automated most of the DBA Tasks and monitoring stats using SQL Server Agent and Scripts
  • Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment
  • Automated many operations by scheduling multiple DTS packages using jobs
  • Built Drill Down, Drill through, linked and sub reports using SSRS 2008 to generate all EOD, Weekly, Monthly and Quarterly Reports
  • Used SQL Server Profiler to trace the queries with longer execution times and optimized the query execution with the use of Index Tuning Wizard and Rebuild indexes, where necessary
  • Used Internet Information Services(IIS) to deploy test applications
  • Designed GUI to run SSIS Package from Front End Application. Implemented Class And method with the use of C#, ASP.net
  • Participated in designing Disaster Recovery plan for SQL Server Database and actively monitored the maintenance of database backup at scheduled time

Confidential, Albany, NY

SQL Server Developer/DBA

Responsibilities:

  • Attended the Business Requirements walk through sessions and Design Walk Through sessions to understand about the project
  • Worked closely with the Data Modeler during the creation of a Physical Data Model
  • Involved in Logical and Physical Data Modeling Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS
  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined Data Types and functions in SQL Server 2008
  • Created Backups for Databases and automated the process in Production environment
  • Created Transactional Replication, Pull Subscription and defined editions for data transfer
  • Created Indexes on all the tables for fast retrieval of the data and involved in Performance Tuning of various scripts to reduce the execution time of the jobs
  • Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages for Data Warehousing
  • Wrote Merge SQL scripts to incorporate the Insert Else Update Logic for the data extracted using ETL Tool (Ab Initio)
  • Created audit trails of activities on Database using triggers on backend
  • Helped the ETL Development Team during Historical Data Load ( Extracting few gigs of UNIX files received from the source team and bulk loading the same into the target)
  • Created SSIS Packages to support business process and data transformations through Sql Server 2008/2005
  • Developed and Tested SSIS (SQL Server Integration Services) Packages for data extraction, transfer, and loading for Aggregated Reporting
  • Wrote stored procedures for Automatic Scripting to backup transaction logs
  • Deployed and Scheduled the SSIS Packages to various destinations
  • Good experience and knowledge of working with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager
  • Created different user level groups, and assigned appropriate permission level to the Databases
  • Created Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones
  • Helped the team resolve pre-prod / UAT issues
  • Provided Production support, for the application built, during warranty period (before transitioning the application to Level 3 Production Support Team)

Confidential, Northbrook, IL

SQL Server Developer

Responsibilities:

  • Participated in the daily/weekly onsite & offshore calls to discuss about the requirements, design decisions and the deliverables / milestones
  • Involved in System Analysis & Design of the Enterprise Data Warehouse implementation
  • Identified various source systems for data feeds and worked closely with the source teams to understand the data file formats and file exchange methods
  • Was responsible in the relational modeling of the Data Warehouse
  • Created mappings to load data extracted from flat files, COBOL files and XML files to staging area using SQL Server SSIS
  • Extracted customer data from SQL Server database and loaded to warehouse
  • Implemented Ralph Kimball Star schema methodologies with subject area data marts
  • Implemented SSIS with SQL Server stored procedures for data manipulations
  • Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for Enterprise Data Warehouse (EDW)
  • Implemented Type II slowly changing dimension to maintain current information and history information in dimension tables
  • Hands on Development with ASP.NET and C#.
  • Worked with the ETL Team for Creating Connected and unconnected transformations to look up the data and handle the claims
  • Developed and maintained SSIS packages to load data into the warehouse using Extract, Transform, and Load (ETL)
  • Created E-mail notifications tasks using stored procedure scripts
  • Wrote stored procedures to implement business rules and validations
  • Setup Log Shipping or Replication for mission critical databases for High Availability and Disaster Recovery
  • Created procedures to drop and recreate the indexes in the target Data warehouse before and after the ETL loadings
  • Performance tuning of SQL Scripts and stored procedures and Used scheduler for scheduling jobs as batch process on timely basis
  • Troubleshoot and monitor of MS SQL Server issues

Confidential 

SQL Server Developer

Responsibilities:

  • Participated in daily Offshore - Onsite Calls to understand about the module requirements, and about the weekly deliverables status
  • Setup meetings with the Onsite Coordinator to get the issues/doubts clarified, before owning up responsibility for the respective module(s)
  • Extensive participation in logical and physical database design, and normalizing the database to accommodate possible changes in the requirement
  • Wrote Stored Procedures to handle complex calculations and wrote logic to maintain the history of entities which was also passed on to the application via Stored Procedures
  • Explored the use of User Defined Functions to encapsulate commonly used logic in the stored procedures and maximized the readability of such Stored Procedures
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert
  • Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard
  • Created and managed users, roles and groups and handled database security
  • Maintained database and Backup/recovery, Defined Database Maintenance Plan which was a scheduled job
  • Enforced Referential integrity of data by creating different constraints
  • Participated in monitoring Database performance and trouble-shooting at the server and database level
  • Provided support during the release of various patches by creating tables, populating data and granting privileges to users and roles
  • Coordinated with TRA/Commercial DBA’s and core group(working at Onsite) in solving Application problems

We'd love your feedback!