We provide IT Staff Augmentation Services!

Sql Server Production Dba Resume

IL

Summary:

  • Over8+years of experience in Database Administration, Supporting,MS SQL Server 2008/2005/2000/7.0 Production/ Replication/Mirroring & Cluster Server Environments
  • Experience inMS SQL ServerInstallation,Performance Tuning, Client Server Connectivity, Building Servers, Troubleshooting, Clustering, Query optimization, back-up/recovery, running Database Consistency Checks usingDBCCand Troubleshooting on large databases, maintaining and supporting, monitoring production and test environments
  • Experience inUpgrading,Service PacksandMigrating SQL Server 2005databases toSQL Server 2008
  • Experience onSQL Server 2005/2008tools likeSQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent,Execution Plan, Performance monitor, DBCCcommands and troubleshooting andSQL Server Surface Area Configuration, Database Engine Tuning Advisor
  • Knowledge of tools ofMS 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 clusteredOLTP/OLAPenvironment with Very Large Databases(VLDB)
  • Monitoring Databases and server, estimating the growth of the databases, and maintain Fill Factors
  • Experience in implementing ofHigh Availabilitysuch asClustering, DatabaseMirroring,Log Shipping, andReplication
  • 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 withReplication,MigrationandDTS
  • Experience in using different Transformation tools likeDTS Packages,SSIS,BCPandBULK INSERT
  • Good knowledge in utilizingETL tools, includingSQL 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 Loopin SQL Server Integration Services(SSIS) with .NET. Used theSSISImport/Export, migrated the Heterogeneous Database like Oracle, Sybase and Access database, flat files toSQL Server
  • Automating the Database Maintenance tasks by creating Jobs and Alerts using the Database Mail and SQL Server Agent
  • Good understanding ofRDBMS,Normalization /De-normalization, Normal Form and database modeling
  • Experience working with Production 24/7 Environments
  • Experience in DatabaseMirroring, Database Snapshot and Isolation Levels
  • Experience in implementing different types ofReplicationModels 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, ILNov. 2011 – Till Date
SQL Server Production DBA

Project:AdministeringSQL Server 7.0/2005/2008/2008R2and later upgraded toSQL Server 2005, 2008which made it easier for the user and to meet the customer needs

Responsibilities:

  • UpgradedSQL 2005 Server toSQL 2008Server forprocessing critical databases.
  • Monitored SQL software license usage, requested additional licenses when needed.
  • Created and maintained various databases in Production environment usingSQL Server 2008R2/2008/2005/2000/7.0
  • Planning the location of Data, Index, andTransaction logfiles on the disk
  • Provided support forTransactional Replication/Mirroring
  • Installed and configured 2-nodeCluster Configuration(Active/Passive) inSQL Server 2005/2008/2008R2
  • Created documentation to InstallSQL Server 2005/2008, applyService Packs, Hot Fixes
  • Responsible forMS SQL Server 7.0/2005/2008/2008 R2configuration and provide 24*7 support to all Production Servers
  • UsedSSIS, DTSto extract, transform and consolidate data from different sources
  • Conductingroot cause analysisof application availability and narrow down to issues related to database bottlenecks.
  • Resolving locking and blocking issues
  • Migrated and testedDTSpackages toSQL Server 2008/2005/2000/7.0to Integration Services (SSIS). Tuned the Production Server to get Performance improvement by usingSQL Profiler, SQL CommandsandDatabase 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 existingMS SQLenvironment.
  • Suggesting Cost saving Techniques, Designing/ ImplementingBackuppoliciesfor Databases.
  • Involved in automated daily, weekly and monthly system maintenance tasks such as database.Backup,Replication verification, Database Integrity verification and Indexing updates.
  • ManagedServer Roles, Adding Login’s, User Roles, Groups toMS SQLServer 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 2005and later upgraded toSQL 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 2005server toSQL 2008server 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 forTransactional 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 forMS SQL Server 2005configuration and provide 24*7 support to all Production Servers.
  • UsedSSISto extract, transform and consolidate data from different sources into Data Warehouse.
  • Conductingroot cause analysisof application availability and narrow down to issues related to database bottlenecks, or network latency.
  • Resolving locking and blocking issues.
  • Migrated and testedDTSpackages 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 forsource databases, target databases.
  • Maintain reliability and availability of existing MS SQL environment
  • Suggesting Cost saving Techniques, Designing/ ImplementingBackuppoliciesfor databases.
  • Involved in automated daily, weekly and monthly system maintenance tasks such as databasebackup,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, ORJul 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.
  • PerformedLog Shippingon multiple SQL Server databases.
  • Provided support forHigh availability and Disaster Recovery (DR)of for critical database systems.
  • Provided support for complexTransactional Replicationenvironments.
  • 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 ondatabase security, permissions, user managementand following best industry practices.
  • Setting up monitoring through batch scripts
  • Installing, upgrading and applying the latest service packs/hot fixes.
  • Provided High availability throughClustering, 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, NMOct. 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 forTransactional Replicationenvironments.
  • 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