We provide IT Staff Augmentation Services!

Senior Sql Developer Resume

0/5 (Submit Your Rating)

Novi, MI


  • 8+ years of IT experience with extensive expertise in SQL Server technologies like MS SQL Server 2005/2008 suite of products like SSRS, SSAS and SSIS including development, deployment, testing and support.
  • Experience with software development life cycle (SDLC) and Project Management Methodologies.
  • Performed Migration of databases from SQL 2012 to SQL 2014 using SSIS.
  • Experience in SQL Server Programming, Analysis Services and Reporting services 2005/2008.
  • Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008 .
  • Experience in Data Warehouse Development environment using Microsoft DTS, SSIS and SSRS.
  • Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
  • Experience in data Extraction, Transformation and Loading (ETL) processes using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
  • Involved in logical design of database using ERWIN.
  • Experience in mapping data into database objects.
  • Very strong Transact - SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and Functions.
  • Expertise in Creation and Maintenance of Procedures, Triggers and Functions.
  • Experience in creating, maintaining and implementing SQL scripts.
  • Involved in creation of MRP (Master Release Plan).
  • Experienced in the migration and implementation from other databases to MS SQL Server.
  • Experience in providing technical support to internal developers and external clients
  • Experienced in Data Loading using T-SQL, Fine Tuning of Database and improving Performance, Creating new Database, Creating and Modifying Table space and Optimization.
  • Experienced in DTS and BCP of SQL Server to populate the data from various sources in various formats
  • Excellent Communication, Analytical skills and Interpersonal skills. Versatile team player with proven problem solving skills and ability to quickly learn new technologies.


Programming Languages: T-SQL, C, C#, C++, Assembly, HTML, DHTML, HTTP, Shell Scripting

Databases Tools: SQL Server Enterprise Manager, SQL Server Management Studio, Query Analyzer, SQL Profiler, Data Transformation Services(DTS), ETL, Query Builder, BCP, Bulk Insert, SSIS,SSAS,SSRS, BIDS,VSS, Crystal Reports, ERWIN.

Databases\Data Access: SQL Server 2000/2005/2008 , Oracle 9i/10g, Sybase, MS Access.

Other tools: MS Word 2003/2007/2010 , MS Excel 2003/2007/2010 , MS Outlook 2003/2007/2010 , MS Visio, SharePoint Server 2007.

Operating Systems: Windows NT/ 2000/2003/2008/ XP/7


Confidential, Novi MI

Senior SQL Developer


  • Understand Business Requirements.
  • Worked primarily on the request made by front end developer depending on the business need.
  • Created and modified stored procedures, functions, views and indexes to provide best performance.
  • Created table, views, columns and constraints as per Java developer’s request.
  • Created Sql server script and managed its implementation.
  • Manually maintained an Excel sheet with charge code, companies name and various Information to manage implementation of scripts.
  • Worked with DBA and QA in development of MRP
  • Was primarily responsible for making sure scripts ran according to the MRP.
  • Provided technical support to internal developers and external clients.
  • Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting.
  • Worked closely with other DBAs in the design and implementation process for deploying, upgrading, managing, archiving and extracting data for reporting
  • Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
  • Worked on DTS and BCP of SQL Server to populate the data from various sources in various formats.

Environment: SQL Server 2005/2008, Windows XP,SQL Enterprise Manager, Query Analyzer, SSIS, SSRS, SSAS, T-SQL, Visual studio2005, MS Excel

Confidential, Statesville, NC

SQL Developer


  • Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
  • Worked with SSIS to design the packages for ETL Support.
  • Generated T-SQL scripts for application development.
  • Created Stored Procedures and User Defined functions.
  • Created Indexes to speed up the queries.
  • Created roles and permissions for the data warehouse applications.
  • Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedures
  • Programmed SQL Server 2005 Reporting Services using Microsoft Visual Studio 2005.
  • Performed Migration of databases from SQL 2012 to SQL 2014 using SSIS.
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
  • Scheduled Jobs and Alerts using SQL Server Agent
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
  • Involved in logical design of database using ERWIN and mapping the data into database objects.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2012/2014, Windows 2000/XP Query Analyzer, MS Excel (pivot tables) SSIS, SSRS, SSAS, T-SQL, Visual studio2005, ERWIN

Confidential, Charlotte, NC

SQL Server Developer


  • Working in upgrading the DTS process to SSIS in SQL Server 2012
  • Designed ER diagrams and normalization of database
  • Generated SQL Scripts to create tables, Views, columns and constraints as per the requirement.
  • Created various stored procedures to implement the Business logic
  • Monitored the database using the tools Database Engine Tuning Advisor and SQL Profiler
  • Created SSIS Packages to Extract, Transform and Load data from different environments.
  • Applied SSIS Data Conversion & Data mapping to Import data from heterogeneous systems into MS SQL Server.
  • Involved in data cleansing process by using SSIS Fuzzy Lookup Transformation & Data Quality Services in MS SQL Server 2012.
  • Converted Reports from Crystal Reports to SSRS.
  • Created SSRS Reports using variety of features like Reports, Charts, Filters, Sub-Reports, Drill Down, Multi-valued parameters as per the requirements.
  • Scheduled Jobs to fire SSIS packages by using SQL Server Agent

Environment: SQL Server 2000/2005/2012 , SQL Server Integration Services 2012, SQL Server Reporting Services 2012

Confidential, Irving, TX

SQL Server developer (Offshore)


  • Extensively wrote T- SQL codes for the project.
  • Created Stored Procedures for Batch Processing.
  • Developed stored procedures, triggers and functions and manipulated tables for data extraction, transformation, and data loading (ETL).
  • Developed and modified the SSIS packages for ongoing data support.
  • Manipulated tables, columns, triggers using TSQL.
  • Worked with Business Objects and SSRS.
  • Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data.
  • Developed, maintained and supported the enterprise data warehouse using SSIS and SSRS system throughout the SDLC.
  • Delivered SQL server reports to SharePoint to enhance team collaboration
  • Generated reports according to business requirements using crystal reports and reporting services 2005.
  • Created monthly reports using reporting wizard with Visual Studio
  • Involved in Scheduling backups and maintenance.
  • Upgraded DTS packages to SSIS.
  • Modified an Existing crystal reports and SQL Reporting Services Reports.
  • Created indexes to improve the performance of the queries
  • Created backups and restore of the databases.
  • Used data conversions to convert different data types
  • Created Views for Extracting Data using TSQL.
  • Performed Migration of databases from SQL 2000 to SQL2005
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Created Distributed Partitioned Views.
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSISand also used BCP and Bulk Insert.

Environment: MS SQL 2000/2005,Sharepoint Windows NT/2000/XP,SSAS,SSIS, SSRS, Crystal reports Visual studio 2005, ASP 3.0,Business Objects, ORACLE 10g, MS Excel(Creating reports), SQL Query Analyzer, Enterprise Manager, MS Access, MS Word.


Sql Server Developer


  • Installed and configured MS SQL Server on Advanced Windows 2003 server.
  • Generated Script files for changes made to stored procedures or views or any other database objects.
  • Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
  • Managed the use of disk space, memory and connections.
  • Ran DBCC consistency checks, and fixed data corruption in application databases.
  • Installed SQL Server service packs based on the errors and flaws that are found in the application.
  • Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
  • CreatedSSISpackage to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
  • Monitored MS SQL server forperformance and network issues.
  • Created and Rebuild the Clustered & Non Clustered indexes at regular intervals for better performance.
  • Generated MIS reports usingCrystal Reports.
  • Installed SQL Server service packs based on the errors and flaws that are found in the application.
  • Provided problem resolution, troubleshooting, tracked and resolved issues in the database environment.

Environment: SQL server 2000/2005, Windows 2000/2003, Windows Cluster Server2003 MS Office, Crystal Reports, Visual Studio.NET, C#.NET.

We'd love your feedback!