We provide IT Staff Augmentation Services!

Sql Server Production Dba Resume

IL

Summary:

  • Over 8+ years of experience in Database Administration, Supporting, MS SQL Server 2008/2005/2000/7.0 Production/ Replication/Mirroring & Cluster Server Environments
  • Experience in MS SQL ServerInstallation, Performance Tuning, Client Server Connectivity, Building Servers, Troubleshooting, Clustering, Query optimization, back-up/recovery, running Database Consistency Checks using DBCC and Troubleshooting on large databases, maintaining and supporting, monitoring production and test environments
  • Experience in Upgrading,Service Packs and Migrating SQL Server 2005 databases to SQL Server 2008
  • Experience on SQL Server 2005/2008 tools like SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent, Execution Plan, Performance monitor, DBCC commands and troubleshooting and SQL Server Surface Area Configuration, Database Engine Tuning Advisor
  • Knowledge of tools of MS SSRS, SSAS, SSIS
  • Managed day-to-day User activities like creating logins, granting permissions, applying security for new users, manually running the jobs etc.
  • Experience working in a clustered OLTP/OLAP environment with Very Large Databases (VLDB)
  • Monitoring Databases and server, estimating the growth of the databases, and maintain Fill Factors
  • Experience in implementing of High Availability such as Clustering, Database Mirroring, Log Shipping, and Replication
  • Good knowledge in T-SQL programming skills (DDL- data definition language and DML- data manipulation language)
  • Experience with Software Development Life Cycle (SDLC) and project methodologies.
  • Excellent troubleshooting techniques and experience with Replication, Migration and DTS
  • Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT
  • Good knowledge in utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services(DTS), and Data Stage and ETL package design, and RDBM systems like SQL Servers
  • Experience in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services(SSIS) with .NET. Used the SSIS Import/Export, migrated the Heterogeneous Database like Oracle, Sybase and Access database, flat files to SQL Server
  • Automating the Database Maintenance tasks by creating Jobs and Alerts using the Database Mail and SQL Server Agent
  • Good understanding of RDBMS, Normalization /De-normalization, Normal Form and database modeling
  • Experience working with Production 24/7 Environments
  • Experience in Database Mirroring, Database Snapshot and Isolation Levels
  • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional

Technical Skills:
Database : MS SQL Server 2008R2/2008/2005/2000/7.0
O/S : Windows 95/98/Me/2000,Windows7, Windows NT, Windows Server 2003/2008R2
Windows XP, Windows Vista, Windows 7, Unix
Languages : Auto Lisp, Micro station Basic
Tools : OLTP, OLAP, Data stage, SQL Server Services SSMS, SSRS, SSIS, SSAS
SQL Server Profiler, Perfmon (System Monitor)
Packages : All MS-Office, Lotus 123, 3D Studio, 3D MAX, Corel Draw, Microsoft Axapta an
ERP package (modules: AR, AP, Inventory Management, CRM)
Designing Packages : Staad III, Design Review, Frame Works Plus, StruCAD (pertaining to
Engineering) Micro Station, AutoCAD

Experience:
Confidential, IL Nov. 2011 - Till Date
SQL Server Production DBA

Project: Administering SQL Server 7.0/2005/2008/2008R2 and later upgraded to SQL Server 2005, 2008 which made it easier for the user and to meet the customer needs

Responsibilities:

  • Upgraded SQL 2005 Server to SQL 2008 Server forprocessing critical databases.
  • Monitored SQL software license usage, requested additional licenses when needed.
  • Created and maintained various databases in Production environment using SQL Server 2008R2/2008/2005/2000/7.0
  • Planning the location of Data, Index, and Transaction log files on the disk
  • Provided support for Transactional Replication/Mirroring
  • Installed and configured 2-node Cluster Configuration (Active/Passive) in SQL Server 2005/2008/2008R2
  • Created documentation to Install SQL Server 2005/2008, apply Service Packs, Hot Fixes
  • Responsible for MS SQL Server 7.0/2005/2008/2008 R2 configuration and provide 24*7 support to all Production Servers
  • Used SSIS, DTS to extract, transform and consolidate data from different sources
  • Conducting root cause analysis of application availability and narrow down to issues related to database bottlenecks.
  • Resolving locking and blocking issues
  • Migrated and tested DTS packages to SQL Server 2008/2005/2000/7.0 to Integration Services (SSIS). Tuned the Production Server to get Performance improvement by using SQL Profiler, SQL Commands and Database Tuning Advisor
  • Enhanced Performance by reviewing Disk Configuration and storage allocation
  • Documented changes to support change control procedures in the company
  • Involved in Performance tuning for Source Databases, Target Databases
  • Maintain reliability and availability of existing MS SQL environment.
  • Suggesting Cost saving Techniques, Designing/ Implementing Backuppolicies for Databases.
  • Involved in automated daily, weekly and monthly system maintenance tasks such as database. Backup, Replication verification, Database Integrity verification and Indexing updates.
  • Managed Server Roles, Adding Login's, User Roles, Groups to MS SQL Server and maintaining proper security procedures.

Environment: MS SQL Server 7.0,2005, 2008, 2008R2 Windows 2003 Server Enterprise, IIS Web Server, XML, Visual studio 2005, .NET, MS Share Point, T-SQL, OLAP/OLTP, TCP/IP, SAN, SSIS, ETL, XSLT, Informatica, Tivioli, Microsoft report analyzer, HP-UX, AIX, Best Practices Analyzer (BPA), System Center Operations Manager 2007 (SCOM), VB script , HTML, CSS, JavaScript, DNS, network IP, Windows 2003, 2008, MS Office, IIS and Oracle, Sybase

Confidential, Cincinnati OH. Jun 2008 - Oct. 2011
SQL Server Production DBA

Project: Multi-Tasked, administering System Development Life Cycle (SDLC). SQL Server 2005 and later upgraded to SQL Server 2008, which made it easier for the user and to meet the customer needs. The reporting service included ability to integrate with Microsoft Axapata.

Responsibilities:

  • UpgradedSQL 2005 server to SQL 2008 server forprocessing critical databases.
  • Monitored SQL software license usage, requested additional licenses when needed.
  • Create and maintained various databases in Production environment using SQL Server 2005/2008
  • Planning the location of data, index, and Transaction log files on the disk.
  • Provided support for Transactional Replication.
  • Installed and configured 2-node Cluster Configuration (Active/Passive) in SQL Server 2005.
  • Created documentation to install SQL Server 2005, apply service packs, hot fixes and clustering installation.
  • Responsible for MS SQL Server 2005 configuration and provide 24*7 support to all Production Servers.
  • Used SSIS to extract, transform and consolidate data from different sources into Data Warehouse.
  • Conducting root cause analysis of application availability and narrow down to issues related to database bottlenecks, or network latency.
  • Resolving locking and blocking issues.
  • Migrated and tested DTS packages to SQL Server 2005 Integration Services.
  • Tuned the Production server to get performance improvement by using SQL Profiler, SQL Commands and Database Tuning Advisor.
  • Enhanced performance by reviewing disk configuration and storage allocation.
  • Documented changes to support change control procedures in the company.
  • Involved in Performance tuning for source databases, target databases.
  • Maintain reliability and availability of existing MS SQL environment
  • Suggesting Cost saving Techniques, Designing/ Implementing Backuppolicies for databases.
  • Involved in automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
  • Managed Server roles, adding Login's, User roles, groups to MS SQL Server and maintaining proper security procedures

Environment: MS SQL Server 2005, 2008, Windows 2003 Server Enterprise, IIS Web Server,
XML, Visual studio .NET, MS Share Point, T-SQL, OLAP/OLTP, TCP/IP, SAN, Share point, SSIS, ETL, XSLT, Microsoft report analyzer, HP-UX, AIX, Best Practices Analyzer (BPA), VB script , HTML, CSS, JavaScript, DNS, network,IP,Windows 2003, 2008, MS Office,IIS and Octopus

Confidential, Beaverton, OR Jul 2007 - Jun 2008
SQL Server Production DBA

Project: Upgraded its existing framework from 2005 SQL Server to SQL Server 2008 Enterprise Edition to enhance scalability and availability. My Job involved upgrading from SQL Server 2005 to 2008.

  • Installed, configured, administered and secured SQL Server 2008. Upgraded SQL Server 2005 to 2008.
  • Designed and created databases to support the user interfaces.
  • Performed Log Shipping on multiple SQL Server databases.
  • Provided support for High availability and Disaster Recovery (DR) of for critical database systems.
  • Provided support for complex Transactional Replication environments.
  • Performed Database Backups to ensure minimum loss of data during disasters and restored from Backup when the need arise.
  • Set up security and roles, DTS packages and maintenance plans, Jobs, Alerts and Operators in SQL Server.

Environment: SQL Server 2005 & 2008, Windows 2000/2003 Server, VB script , IBM WebSphere, Crystal report, MS Office ,ETL, Service Oriented Architecture, T-SQL, OLAP, Performance Point, .NET, DB2, DDL, DML, OSSQL, ETL, TCP/IP,SAN,DTS, SSIS, Team Foundation Server, J2EE, VB script, ProClarity, Powershell , Microsoft report analyzer, windows 2000, 2003, HTML, CSS, JavaScript, IIS,XML, DNS

Confidential, Chicago, IL Nov. 2005 - Jun. 2007
SQL Server Production DBA

Responsibilities:

  • Active participation with customers in understanding their business process and suggesting optimal database structure, practices and tools on specific projects, ensuring high customer satisfaction rates.
  • Setting up processes for regular backups and restore methods, and ensuring the processes are followed.
  • High emphasis on database security, permissions, user management and following best industry practices.
  • Setting up monitoring through batch scripts
  • Installing, upgrading and applying the latest service packs/hot fixes.
  • Provided High availability through Clustering, Mirroring, Replication (Transactional)
  • Production database administration of highly critical databases.
  • Migration/Moving database servers between different platforms/locations and setting up test, QA and production database environments.
  • Installation of SQL Server 2005. Upgrading SQL Server 2000 to SQL Server 2005 using side-by-side methods
  • Planning for the DR

Environment: SQL Server 2000/2005 Enterprise Edition, Performance Point, Crystal Report, SAN, ProClarity, Java script, HTML, Enterprise Manager, ERStudio , UML, ETL, MS Project, DDL, DML, OSSQL, MS Office ,VBScript, MS Access 2000 & Windows 2K, 2005 platform, Java, IIS XML, J2EE, HP-UX, AIX, Perl, UNIX Shell Source Control Tools, IBM WebSphere, HTML, CSS, JavaScript , Team Foundation Server , Service Oriented Architecture

Confidential, Albuquerque, NM Oct. 2004 - Oct 2005
SQL Server DBA

Confidential, is New Mexico\'s only private not-for-profit healthcare system and is the largest provider of healthcare. It provides the best practices in medical care and customer service and to bring the latest technology to every hospital and physician in NM statewide system. The aim of that project was to create and maintain backend.

Responsibilities:

  • Technologies involved in this application include SQL Server 2000, 2005 Replication, Microsoft Analysis Services and Microsoft DTS (ETL).
  • Created DTS packages for the data cleansing/transfer (ETL) and transformation.
  • Designed Database Schema using third party tools like Erwin (ER Studio).
  • Created job schedules to automate the routine tasks.
  • Performed Database Normalization.
  • Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
  • Generated report using Microsoft report analyzer.
  • Implemented PMI Project Lifecycle Methodology processes.
  • Migrated databases from SQL server 2000 to SQL server 2005.
  • Migrated old dts packages into SSIS packages.
  • Determine the problems such as dead lock, blocking and fix the problem.
  • Partitioned tables, Views to run query faster.
  • Supported 24*7 production support and solved all kinds of critical problems.
  • Created reports by using bar chart to analyze critical data in SSRS 2005.

Environment: T-SQL, SQLServer2000, 2005 OLAP, Performance Point, .NET,DB2, MS Office ,DDL, DML, OSSQL, ETL, TCP/IP,SAN,DTS, SSIS, Team Foundation Server, J2EE, VB script , ProClarity, Powershell , HP-UX, AIX, Microsoft report analyzer, windows 2000, 2003, HTML, CSS, JavaScript ,IIS,XML, DNS, Perl, UNIX Shell , Unix, ORM, Service Oriented Architecture ,Source Control Tools ,ERStudio 7.x.

Confidential, PA, USA Jan. 2004 - Sept. 2004
Database Administrator

Responsibilities:

  • Installing, upgrading and applying the latest service packs/hot fixes.
  • Performed Database Backups to ensure minimum loss of data during disasters and restored from back-up when the need arise.
  • Provided support for Transactional Replication environments.
  • Supported 24*7 production support
  • Performed Database Normalization.
  • Setting up processes for regular backups and restore methods, and ensuring the processes are followed.

Environment: Windows NT, Windows 2000/2003 server, ETL, MS SQL Server 2000, Java, VBScript, MS Access, IBM Websphere, Service Oriented Architecture

EDUCATION:
BS Degree in Engineering

Hire Now