We provide IT Staff Augmentation Services!

Ms Sql Server Dba Resume

Summary:

  • Over 13 years of experience in SQL SERVER database development and administration.
  • Certified MS SQL Server Database Administrator 7.0
  • Extensive experience writing T-SQL, triggers, tables, user functions, views, stored procedures, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Performance Monitor and SQL Profiler to tune and analyze DB performance and allocate server resources to achieve optimum db performance.
  • Good experience in DTS, BCP, SSIS and SSRS. Log Shipping, User Management, Security, Backup/Recovery.
  • Data Modeling and use of ERWIN Tool.
  • Strong troubleshooting and organizational skill.

Technical Skills:

Languages

SQL, PL/SQL, T-SQL, Basic, COBOL, C

Databases

MS SQL Server 7.0, MS SQL Server 2008/2005/2000, Oracle, MS Access

Operating Systems

Windows NT/95/98/2000/XP/Vista, UNIX, MS DOS

Tools

ERWIN, Crystal Reports 11.0, Power Builder, Visual Basic

Protocols

TCP/IP, HTTP, FTP

Experience:

Confidential, November 2010 - Till Date
MS SQL Server Developer DBA

Environment: MSSQL Server 2008/2005, VB.Net, ASP.NET, Windows 7

Confidential
Confidential, is a Centralized Device Management software which discovers devices connected to the network. FedEx Office has over 1800 centers which are divided into 12 regions and data are loaded into 5 different databases, for 2 or 3 regions per server. Data is consolidated in a different database and reports are generated.

Responsibilities:

  • Database Design and data modeling using Erwin 4.0. Physical and logical database design.
  • Deployed physical model into database.
  • Installation of SQL Server 2008 R2.
  • Created Tables and Indexes. Coded stored procedures, Functions, Views and SQL Scripts.
  • Performance tuning and Query optimization.
  • Loaded data from Excel Sheet to different tables from SQL Server using SSIS.
  • Created functions for cleaning the loaded data.
  • Consolidated data from 5 different databases to one database. Loaded data into different tables using SQL Server Jobs in a 4 hour interval.
  • Generated Reports regularly using SQL Jobs.
  • Database Normalization.
  • Created Backup strategies on Development Servers.
  • Database Maintenance is handled using DBCC commands regularly.
  • Maintenance Plans are created for Backups - Full and Transactional Log.

PPA (Pre-Production Assistant)
PPA is a document modifier application developed to convert any files into professionally printed documents. It provide a fast, easy way to apply popular pre-set printing and finishing options to your files or choose customize to apply your own printing and finishing options.

Responsibilities:

  • Scheduled Nightly jobs to load data from more than 1800 FedEx Office Centers.
  • For good performance created clustered and non-clustered Indexes.
  • Coded stored procedures, Functions, Views, Triggers and SQL Scripts.
  • Performance tuning and Query optimization.
  • DBCC commands are used for database maintenance.

dbBudget
It is a Financial application which holds the financial information of all the projects and the employees and contractors working on each project.

Responsibilities:

  • Created Maintenance Plans for regular Backups.
  • Required Constraints and Indexes are created for good performance.
  • Coded stored procedures, Functions, Views, Triggers and SQL Scripts.
  • Performance tuning and Query optimization.
  • Loaded data from Excel Sheet to different tables from SQL Server using SSIS.
  • Database Maintenance is handled using DBCC commands regularly.

Confidential, January 2009 - October 2010
Confidential, Little Falls, NY MS SQL Server Developer, DBA

Environment: MS SQL Server 2008/2005, VB.Net, ASP.Net, Windows NT

An individualized educational plan means one that is designed to meet the unique educational needs of one child, as defined by federal regulations. 34 CFR 300.320 The IEP must be tailored to the individual student\'s needs as identified by the evaluation process and must help teachers and related service providers understand the student\'s disability and how the disability affects the learning process.

Responsibilities:

  • Created and maintained database design using Erwin 4.0
  • Created tables, stored procedures, Functions, Views and SQL Queries.
  • Checked the standards of stored procedures written by other programmers and logged.
  • Designed reports using SSRS.
  • Migrated data from source database to development, test and production databases using SSIS.
  • Maintained the code in Development, Testing and Production servers.
  • User Management, Security.

Billing Projects

  • Migrated DTS Packages to SSIS.
  • Developed complex T-SQL Queries and SSIS Packages to load data from flat files, Excel and load database.
  • Designed SSIS packages using several transformations to do Cleansing and Transformation of data from load database to production database.
  • Created SSIS packages to load data to MS ACCESS after performing several operations from MS SQL SERV

Confidential, July 2006 - December 2008
Confidential, Little Falls, NY MS SQL Server Developer, DBA
Projects: MAXCAPTURE, RMS (Random Moment Sampling), ATR (Access To Recovery), NY

Responsibilities
  • Used Erwin 4.0 to design the database and created logical and physical models.
  • Tables are created from the DDLs generated from the physical model.
  • Wrote stored procedures, UDFs and Views.
  • Designed the reports using Crystal Reports 11.0 and SSRS
  • Development, Testing and Production servers are monitored regularly.
  • Loaded data from old system to Development, Testing and Production servers using SSIS.
  • Used SQL Profiler tracked the errors and performance tuned the code.
  • Maintained the release files for the production servers for different states.
  • Environment: MS SQL Server 2005/2000, VB.Net, ASP.Net, Windows NT

Confidential, MS Oct 2002 - June 2006
Education Department of Mississippi, Jackson, MS MS SQL Server Developer, DBA
Responsibilities:

  • Did database design and implemented OCN system using Visio 2000.
  • Maintained server using Log Shipping.
  • Migrated data from Excel Sheets to SQL Server.
  • Migrated flat files from SQL Server to Main Frames Box using FTP.
  • User Management, Security.
  • Environment: MS SQL Server 2000, VB.Net, ASP.Net, Windows NT

Confidential, AR June2000 - Sept 2002
Department of Information System, Little Rock, AR MS SQL Server Developer

The Arkansas Professional Licensure System (APLS) has the responsibility to issue licenses to persons for the state of Arkansas that teach in the public or private sector. The process of issuing a license involves evaluating each teacher's academic background and test scores as well as a criminal background check.

Responsibilities:

  • Design and Implementation of APLS using Data Modeling and Data Designing Tool ERWIN 3.5.2
  • Creation of tables and indexes are done from the Design
  • Performance tuning of Stored Procedures and other database objects.
  • Migrated data from Development Server to Production Server using DTS.
  • Designed a separate database for Data Warehousing purpose.
  • DTS packages are used to move data from SQL Server to Flat Files for reports purpose.
  • Created Audit Database for APLS System and used Triggers to load data into the Audit Database.
  • Scheduled nightly job to update the Work Flow Status of the applicants of Professional Licensure System.
  • Environment: MSSQL Server (2000 / 7.0), WebLogic 4.5, EJB, Java, HTML, WINDOWS 2000
Confidential, VA Aug 1999 - May 2000

Federal Aviation Administration, Washington D.C. MS SQL Server Developer
Responsibilities:

  • Data modeling. Coded Stored procedures
  • Migrating data from Tandem, Flat Files to MS SQL Server using DTS.
  • Allocated resources and estimated storage capacity for database objects.
  • Monitored the growth of the database objects for capacity planning,

Environment: MS SQL Server ( 7.0 / 6.5 ), Visual C++, Visual Basic, ASP

Confidential, MO Dec 1998 - July 1999

Missouri Department of Elementary and Secondary Education MS SQL Server Developer
Responsibilities:

  • Installed, configured and performed database administration of SQL Server
  • Performance tuning of Stored Procedures and other database objects.
  • Running full nightly database dumps & hourly log dumps
  • Complete database maintenance tasks (DBCC's)
  • Initial load/data for the user databases, user privileges

Environment: MS SQL Server 6.5, Visual Basic

Confidential, MD June 1998 - Nov 1998

Maryland Port Administration MS SQL Server Developer
Responsibilities:

  • Installed Microsoft SQL Server
  • Designed the Database. Developed the data model using ERWin.
  • Fine tuning and optimization of SQL Servers.
  • Checking database integrity, backup and restore.

Environment: MS SQL Server 6.5, Visual Basic

Education:

Masters in Computer Science

Hire Now