We provide IT Staff Augmentation Services!

Ms Sql Server Dba Resume

Plymouth, MN

Profile

  • 7Years of totalITexperience
  • 6Plus Years ofMS SQL Server DBAexperience

Summary

  • OverSeven yearsof experience in IT of which more than Six years inMS SQL SERVER 2008/2005/2000Database Administration and Development in Windows environment.
  • Extensive knowledge ofRelational Database ManagementSystems(RDBMS).
  • Extensive Knowledge in various states ofSystem Development Life Cycle (SDLC).
  • Expertise in core DBA tasks likeInstallation, Maintenance, Configuration, Backup & Restore, DR, Database Security and, Database designing.
  • Extensive experience in managingMS SQL Server on Windows 2000, 2003 and 2008 Servers.
  • Creation and maintenance of Databases, creatingRoles and managing userpermissions, resolving Blocks and Deadlocks
  • Experience in using tools likeSQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, Idera Diagnostic Manager
  • Creation ofJobs Schedules, Alertsusing SQL Server Agent and Notifications usingSQL Mail and Database Mail.
  • ImplementedDatabase Mirroring in SQL server2005 & 2008with a witness server to configure automatic failover
  • Implementedlog shippingfor SQL Server 2005 and 2000.
  • Expert in implementing different types ofReplicationModels such asTransactional, Snapshot, and Merge.
  • Extensive knowledge of installation and configuration ofSQL Server 2005/2008cluster serverinactive/passiveandactive/activemode.
  • Expertise inupgrading (In-place Upgrades) and migratingdatabases fromMS SQL Server 2000 to 2005 and SQL Server 2005 to 2008.
  • Extensive knowledge inTuning SQL queries & improving the performance of the Database.
  • Expert in working with Third party backup tool likeSQL Lite Speed,Idera SQL Safeto improve performance of backup and recovery
  • Expert level knowledge inServer Consolidation and Data Center migrations.
  • Expert in developingStored Procedures, views, appropriate functions, effectiveDDL/DML Triggersand views on index to facilitate efficient data manipulation and data consistency.
  • Expert in configuring and managingLinked Server, Data transfer between SQL Server.
  • Experience inupgrading SQL server software to new versionssuggested by Microsoft and applyingservice pack and hot fixes
  • Experience in contacting Microsoft and other vendors forproductandtechnical support.
  • Extensively worked on Data extraction using the (SSIS)Microsoft SQL Server integration services.
  • Experience on database design forlarge databases.(terabyte databases)
  • Good understanding ofchange control process
  • Available for24*7productionsupport in mission critical environment.
  • Goodinterpersonal, analyticalandcommunicationskills.

Education & Certificates

  • Bachelor’s Degree in Computer science
  • Microsoft SQL Server 2005 - Implementation and Maintenance (MCTS)
  • Designing a Database Server Infrastructure Using Microsoft SQL Server 2005
  • Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005

Technical Skills

Databases

MS SQL Server (2008 R2, 2008, 2005, 2000, 7.0), MS Access.

Reporting Tools

SQL Reporting Services, Crystal Reports, Active Reports, SSRS, Oracle Forms/Reports Developer.

Programming/Scripting Languages

C, C++, T-SQL, XML, Java script.

Version Control

Rational Clearcase, Subversion, Tortoise SVN.

Operating System

Windows Server 2008/2003, Windows 2000, Windows NT 4.0.

DBA & Others Tools

Toad, Erwin DM, MS Visio, DB Visualizer, Quest Lite Speed, Quest Enterprise, Quest Spotlight, Idera SQL Safe, Idera SQL Diagnostic Manager, Red Gate SQL Compare,

Professional Experience:

Confidential, Plymouth, MN Feb’ 11 - Till date
MS SQL Server DBA

Responsibilities:

  • Installed, Configured and Administered SQL Server2008R2/2008/2005Servers in Production, QA and UAT Environments.
  • Migration ofSQL Server2000to SQL Server2005,SQL Server2005to2008R2
  • Migratedsome databases from Oracle 11g to SQL server 2008R2
  • Worked closely with application team, manager and other DBA’s forplanningandimplementationof themigration.
  • Involved withchange control boardto ensure proper approvals and meet the timeline fordatabase migration.
  • Successfully implementedDatabase Mirroringin SQL Server 2005/2008R2 forhigh availabilityon twoVMware servers.
  • Createddatabases, Logins, Roles and grantedappropriate permissions.
  • ConfiguredDatabase Mailto send out notifications
  • Managing SQL server usingPowerShell scripts
  • InstalledSQLSafeon all the database servers.
  • ConfiguredLog Shippingfor high availability on SQL 2000
  • Configure and manage database maintenance plansfor update statistics, database integrity check, backup operations and indexing updates
  • Installed and Configured 2- node High availability SQL Active/Passive clusters.
  • Created documentation to install SQL Server 2005, applyservice packs,hot fixandclustering installation.
  • Database refreshes fromprod to stage, test and developmentenvironments.
  • Performed Administrative tasks in SQL Server usingPowerShell
  • Conducted databaseperformance monitoringandtuning
  • Proven experience in maintenance of SQL Server in aVLDB environment & experience in troubleshooting and resolving problems.
  • Installed SQL server instance onVMware server.
  • Createdjobs, alerts, activity logs, error logsto capture any possible errors.
  • Creating andmanaging schemaobjects such as tables, views, index, and procedures.
  • Good Knowledge of usingVMware Servers.
  • Experience in working withITGticketing system.
  • Experience in providing excellent24X7Production support.

Environment:Microsoft Windows Server 2008/2003 32/64 bit, MS SQL Server 2008 R2/2005/2000, Idera SQLSafe, T-SQL.

Confidential, New York Aug’09 – Feb’11 SQL Server DBA
Responsibilities:

  • Installed and configuredSQL Server 2005inproductionanddevelopmentenvironment.
  • Upgraded SQL Server2000to SQL server2005/2008in 32 and 64 bit environment.
  • Active involvement in installing and managing multiple2node failover clusterset up inactive/passive environmentas a High Availability mechanism.
  • Successfully implementeddatabase mirroringwithhigh availabilitymode in SQL Server 2005.
  • Configuredtransactional Replicationfrom multiple subscribers for reporting purpose.
  • Involved inperformance tuning, optimizationof stored procedures and queries.
  • Worked with customers to resolve the connectivity issues
  • Set up linked servers in SQL 2005
  • Estimated disk storage requirements for database software, database files.
  • Monitoring and troubleshootingperformance during peak periodswith 1000 to 2000 concurrent connections.
  • Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
  • Use custom scripts so as to help automate routine tasks such asMaintain operators, Alerts, Notifications, Jobs, Job Steps and Schedules.
  • Created automated procedure for daily, weekly and monthly system maintenance tasks such asdatabase backup, replication verification, and database integrity verification and indexing updates.
  • Good Knowledge onSQL Lite Speeda Backup solution for MS SQL Server.
  • Good Knowledge of usingVMware Servers.
  • Experience in providing excellent24X7Production support.
  • Experience in contacting Microsoft forproductandtechnicalsupport.

Environment:Microsoft Windows Server 2008/2003 32/64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008 and SQL Lite speed, spotlight, DELL power edge.

Confidential, Indiana Sept’08 – Aug’09
SQL Server DBA
Responsibilities:

  • Created documentation to install SQL Server 2005, applyservice packs,hot fixandclustering installation.
  • Upgraded SQL Server2000to SQL Server2005in 32 and 64 bitclusteredandnon-clusteredenvironment.
  • Active involvement in installing and managing multiple 2nodefailover clusterset up inactive/passiveenvironment as a ‘High Availability’mechanism.
  • PreparedEstimatesfor Database, table size growth rate forcapacity planning.
  • Successfully implementedDatabase MirroringwithHigh AvailabilityMode in SQL 2005.
  • ImplementedLog Shippingin SQL Server 2005 from Primary server to Standby Server to support DR Solution.
  • Implementandmaintaindatabasesecuritystandards, policies and procedures.
  • Installed and configuredQuest Spotlightfor SQL Server Enterprise.
  • ConfiguredTransactional Replicationfrom Multiple subscribers for reporting purposes.
  • Involved inperformance tuning, optimizationof stored procedure and queries.
  • Upgrade DTS packages to SQL Server 2005 Integration Services(SSIS) packages.
  • Managed indexeson tables using various SQL Server Commands to reduce fragmentation.
  • Expert in working withChange managementandchange control procedure.
  • Tuned the Production Server to get theperformance improvementby using my own DMV’s.
  • Support Development Team indeployingandtestingthe application.
  • Experience in contacting Microsoft and other vendors forproductandtechnicalsupport.
  • Successfully worked in 24x7mission critical environment.

Environment:Microsoft Windows Server 2000/2003 32/64bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005, spotlight, lite speed.

Confidential, NY Oct’07 – Aug’08
SQL Server DBA/Developer

Responsibilities:
  • Involved in Optimization and Performance Tuning of SQL Server usingSQL Profiler and Performance monitor
  • Developbackup and recoverystrategy
  • Configuring Microsoft Cluster on the Servers (4 node Active/Active cluster with 5 instances)
  • Managing the use ofdisk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases
  • Involved in replication setup, configuration and maintenance in transactional replication for student scheduling and Grade reporting application
  • Troubleshooting Replication Errors and handling Logs
  • Manage databaseusers/profiles and security
  • Implementing SQL Server and Database security policies
  • Creating and managing database objects such astables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity
  • Maintaining SQL Script for creation of Database Objects
  • CreatedStored Procedures and Triggersfor the Application
  • Optimized SQL queries for efficiency and provided queries and procedures for the front-end application
  • Involved in scheduling tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL mail, managing alerts, monitoring and tuning SQL Server, SQL Performance monitoring, monitoring and tuning memory and monitoring locks

Environment:Windows 2003 Server, SQL server 2005, Event Viewer, SQL Profiler, T-SQL.

Confidential Feb’07- Sep’07
SQL Server DBA/Developer
Responsibilities:

  • Installation ofSQL Server 2005with latest Service Packs.
  • Worked inActive/Passive ClusteredEnvironment.
  • Writing stored procedures for report generation inmigration processandreplication.
  • Implemented themigrationofSQL Server2000 to 2005.
  • Wrote several SQL Scripts such as findinglong running queries, blocking sessions, archiving datafrom production to archive server and populating reporting data.
  • Experience inmonitoring software toolsused to monitor the environment effectively.
  • Successfully implementedDatabase Mirroringin SQL Server 2005 forhigh availability.
  • Maintain bothDEVELOPMENTandPRODUCTIONserver in sync.
  • Involved inLog Shipping.
  • Extensively involved inreplicationand implementedSnapshot, Merge and TransactionalReplications.
  • Involved inMonitoring Performanceof different production servers.
  • Worked in24x7production environment.
  • Working with the end user gathering requirements for the system.
  • Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
  • CreatingLoginsandRoleswith appropriate permissions.
  • Prepared and documentedBackup & RestorePlans.
  • Creating and MaintainingDatabaseMaintenance Plans.
  • Requirements gathering from the end-users.
  • Extensively involved in designing theSSIS packagesto export data of flat file source to SQL Server database.
  • Involved in analyzing the system for setting up new server andserver configuration.

Environment:Windows 2000/2003 server, MS SQL Server 2000/2005, Erwin, MS Excel, Dell/EMC CX3/CX Series SAN Arrays.

Confidential Jan’06 – Jan’07
Client: Confidential
SQL Server DBA

Responsibilities:

  • Created documentation toinstall SQL Server, apply service pack, hot fix and clustering installation.
  • Designed and implementedmultiple systems using MS SQL Server 2000 and 2005.
  • PreparedEstimates for Database, table size growth.
  • Maintain Operators, Categories,Alerts,Notifications,Jobs, Job Steps andSchedules.Monitor connections,locksandperformanceof SQL server.
  • Responsible for MS SQL Server 2000/2005,configuration,tuningand provide24X7dedicated support to all Production, development and cluster servers.
  • Performed all aspects of database administration, includingbackups andrecovery.
  • Additionally, designed and implemented adisaster recoverysystem.
  • Installed and configured MicrosoftSQL 2 node Clustering (Active/Passive)
  • Involved in the logical and physicaldata modeling using Erwin tool.
  • Created complexstored Procedures, triggers, cursors, tables, viewsand other SQL joins and statements for applications.
  • Developeddatabase monitoringand tuning strategies.
  • ConfiguredLog shippingof one production server and created the DR server.
  • Implemented and configuredTransactional, Snapshot and Merge replication.
  • Assign permissionto user(s), role(s), and object. Supportcolumn level permission. Administrate security for server’s logins (Windows and SQL Accounts).
  • Expertise inSecurity Issuessuch as creation and granting permissions on various Objects.
  • Preparing the reports for theday-to-dayas well as weekly/monthly purposes.

Environment:MS SQL-Server 2000/2005, SQL Diagrams, Erwin, MS Windows 2000 Server, MS Windows 2003 Server, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, HTML 4.0.

Hire Now