We provide IT Staff Augmentation Services!

Ms Sql Server Dba Resume Profile

Baskin Ridge, NJ

SUMMARY

  • 8 years of IT experience with more than seven years in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2012,2008 R2, also specialize in MS SQL Server 2005/2000 in Production, Test, Development, Replication and Cluster Server Environments.
  • Experience working with 24x7 Production support and On-Call rotation.
  • Extensive knowledge of Relational Database Management Systems.
  • Experience in data normalization and de-normalization.
  • Knowledge of implementation of System Development Life Cycle SDLC .
  • Experience in working with high transaction OLTP systems in SQL Server 2012/2008 R2/2008/2005/2000.
  • Experience in SQL database designing, warehousing, architecture, Data Modeling using AllFusion Erwin 7.1 and Visio.
  • Expert in MS SQL Server installation and configuration.
  • Experience in installing Service Packs for SQL Server and OS.
  • Experience in capacity planning, performance tuning, disaster recovery, troubleshooting, backup and restore procedures.
  • Expert in installation, upgrade and configuration of 64 bit MS SQL Server databases in clustered active/active, active/passive and non clustered environments in SQL 2008 R2/2005.
  • Expert in Log shipping with SQL Server 2000/2005.
  • Expert in implementing SQL Server 2008/2005 Database Mirroring.
  • Experience in implementing Snapshot and Transactional replication models.
  • Documented disaster recovery plans and participated in disaster recovery drills.
  • Developed backup and recovery strategies for production environment.
  • Experience in SQL Server Integration Services SSIS .
  • Expert in Upgrading SQL Server 2000/2005 to SQL 2005/2008 environments.
  • T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures, etc.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
  • Excellent in system tables, DMV's and stored procedures using T-SQL
  • Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services SSIS .
  • Expert in T-SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , SQL Server Integration Services SSIS , and Data Transform Services DTS .
  • Extensive experience in data Extraction Transformation and Loading ETL between homogenous and heterogeneous systems using SQL SSIS tools, Data Transformation Services DTS , bulk insert/delete BCP , and XML operations.
  • Good Knowledge of LiteSpeed, Diagnostic Manager and Log explorer for MS SQL Server.
  • Excellent communication skills.
  • Good team player with strong analytical skills.

TECHNICAL SKILLS:

Windows Server 2008 R2, Windows Server 2003, MS SQL Server 2012,2008 R2/2008/2005/2000, Enterprise Manager, Query Analyzer, DTS, MS SQL SSRS, SSAS, SSIS, SQL Profiler, ASP.Net 2.0, SQL, PL/SQL, Visual Studio 2008/2005, T-SQL, ERWIN, Database Modeling, Microsoft VISIO, IDERA SQL Diagnostic Manager, SQL Litespeed, IDERA, Lumigent Log Explorer, Dell PowerEdge, HP Blade, VMWare.

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL Server DBA

Confidential broadband and telecommunications company and a corporate component of the Dow Jones Industrial Average. The company is based in New York City at 1095 Avenue of the Americas.

Responsibilities:

  • Upgraded most of SQL Server 2000 to SQL Server 2005
  • Involved with upgrade of databases from 2000 to 2005 in a Clustered environment.
  • Worked on SQL Server 2005 with latest Service Packs.
  • Involved in Performance Tuning on Production, QA and Staging servers of the current project.
  • Involved in Monitoring Performance of different production servers.
  • Implemented Database mirroring for disaster recovery.
  • Maintained various databases for Production and Testing using SQL Server 2005.
  • Planning the location of data, index, and Transaction log files on the disk.
  • Performance tuning, and optimization of procedures and queries.
  • Worked with SQL server Profiler.
  • Created the backup and restore strategy for production and development environment.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Using SQL Server Integration Services SSIS tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
  • Experience in creating and executing SQL Server Integration Services SSIS packages.
  • Managing schema objects such as tables, views, clusters, indexes, procedures, triggers maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
  • Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Database and Transaction log backups restoration, backup strategies, scheduling the backups. Backing up system user databases and restoring them.
  • Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
  • Used BCP and Bulk Insert utilities.
  • Worked with SQL Server Reporting Service

Confidential

Senior MS SQL Server DBA

Responsibilities

  • 24/7 Production support for SQL server environment.
  • Installing, Upgradation and configuring of SQL Server 2012, 2008 and 2008R2.
  • Fine tuned and Monitored SQL Servers in Web based and Transaction intensive environments. Implemented Active/Passive, Active/Active SQL Server Cluster servers.
  • Configured and maintained database mirroring for high availability.
  • Implemented different types of Replication Models like Snapshot and Transactional.
  • Extensively worked on Dynamic Management Views DMV's .
  • Patched server with latest SQL Server service packs and Cumulative updates.
  • Managed Microsoft Active Active and Active Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
  • Performed DBCC utilities and fixed data corruption in User databases.
  • Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS.
  • Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.
  • Strong in developing, deploying packages using SSIS from OLTP to OLAP
  • Worked on monitoring and tuning of SQL scripts.
  • Created upgrade scripts for production database and supported it.
  • Created and managed schema objects such as tables, views, indexes, procedures, triggers maintained Referential Integrity.
  • Performed Server Application fine-tuning troubleshooting.
  • Monitored MS SQL Server performance and network issues.
  • Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
  • Worked on more than 10 Data modeling projects and generated E-R Diagram
  • Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
  • Maintained Log Shipping, Mirroring and SRDF for disaster recovery.
  • Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
  • Controlled user access rights, and managed data security.
  • Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV's, Wizards and SQL Profiler.
  • Implemented Backup and Restore in SQL Server using Third party tool VERITAS Net Backup, SRDF, TSM and LITESPEED.
  • Maintained multiple instances SQL Servers with maximum availability.
  • Involved in 24x7 on call support

Confidential

Role: SQL Server DBA

Responsibilities:

  • Worked on SQL Server 2008 R2/2008/2005/2000 Database Administration.
  • Migrated databases from SQL Server 2000 to SQL Server 2005 and 2008 R2.
  • Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
  • Installing, Configuring and Maintaining SQL Server 2008R2/2008/2005 64 bit on Active/Active Cluster with latest Service Packs, Hot Fixes.
  • Worked as Primary DBA for 50 Instances and 70 as Alternate DBA.
  • Experience working with CRM Application issues.
  • Installed and configured Microsoft SQL 2 node Clustering Active/Passive .
  • Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
  • Experience in Database security and integrity planning.
  • Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
  • Deployed multi-campus backup environment based on EMC Data domain storage.
  • Installed and configured Storage Area Networks SAN in a heterogeneous environment.
  • Tuning queries which are running slow using Profiler and Statistics by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Successfully implemented the Capacity planning for different servers.
  • Experienced in configuring Powershell environment for SQL support.
  • Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through Try- Catch statement, Common Table Expression CTE .
  • Worked in Active/passive and Active/Active cluster environment and Installed and Configured more than 50 Clustered SQL Instances
  • Installed Service packs and Builds and Worked with SQL Server 2008 in place and side by side upgrade from SQL server 2005
  • Worked on Project for setting up DB mirroring and troubleshooting.
  • Worked on setting up Transactional Replication push and pull and Merge Replication and troubleshooting along with Slip stream installations and TDE.
  • Working on daily tasks include Backup failures, Login creations, Data refresh and Disk space issues.
  • Implementation of SQL failover cluster and setting up backup jobs and Checking Control Jobs.
  • Creating and Maintaining Database Maintenance Plans and Worked in migrating database to different collations
  • Implementing and Maintaining Server Level Auditing for auditing of Logins, Creating and Dropping Objects.
  • Checking the performance issues on servers as per request by using profiler, perfmon, DBCC and DMVs.
  • Monitoring servers by checking Error Logs, Windows Logs, Creating Logins and Roles with appropriate permissions.
  • Worked in Configurations of IIS Internet Information Service in ISP environment with access to SQL DBs
  • Installed and Configured SSRS and Deploying SSIS packages.
  • Analyzed execution plans, and tuned queries and databases for better optimal performance.
  • Fixing Missing Indexes and Excess indexes using Data Tuning Advisor.
  • Managed schema objects like Triggers, cursors, indexes, procedures.

Environment: SQL Server 2000/2005/2008/2008 R2, Windows Enterprise Server 2000/2003/2008,IIS 6.0, .NET, T-SQL, Microsoft Reporting Service, Microsoft Dynamic NAV 4.0,

Confidential

Senior MS SQL Server DBA

Confidential Its corporate headquarters is reported as 180 Confidential . According to the 2011 Forbes Global 2000 list, AIG was the 29th-largest public company in the world.

Responsibilities

  • As a Production and development support DBA responsible for maintaining 150 SQL Servers out of which 170 servers are production servers in which 100 were mission critical and 70 were business critical servers, remaining test and development servers.
  • Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2, applied service packs and security fix for all servers.
  • Implemented Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit environment
  • Managed SQL Servers in 32/64 bit Clustered environments
  • Implemented Database Mirroring on SQL Server 2008 environments.
  • Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
  • Implemented transactional replication for data refresh
  • Managed all Publisher, Distributor and Subscriber database environments for the replication
  • Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
  • Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
  • Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
  • Created SSIS packages to Extract and Load data from diverse source flat file, excel, xml and oracle
  • Created Data Flow's for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
  • Used containers for repetitive control flow tasks
  • Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
  • Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
  • Scheduled package execution in SSIS
  • Installing packages on multiple servers in SSIS
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load
  • Created extensive reports using SSRS
  • Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
  • Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
  • Created the standard documents for Disaster recovery testing and implemented them.
  • Experienced with database sizing and capacity planning for production servers.
  • Experienced with creating logical and physical database design for development projects.
  • Experienced with improving SQL Server using windows performance monitor to improve the server performance.
  • Created the backup schedule for production, test and development servers.
  • Worked with developers to do the database schema changes and database restore requests.
  • Involved in restore operations to refresh the data from production to test servers.
  • Experienced in troubleshooting production servers and fixed the user and application issues

Confidential

MS SQL Server DBA

Confidential was incorporated in 1977 with the primary objective of meeting a social need that of promoting home ownership by providing long-term finance to households for their housing needs

Responsibilities

  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
  • Planned and modified the permission issues in the server.
  • Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
  • Fine tuning the Database Settings as well as the Server Settings.
  • Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
  • Creating, maintaining the users, roles and granting privileges.
  • Logical and Physical Data Modeling using AllFusion, ERWIN.
  • Configured Snapshot Replication Creating Distribution Databases, updating Publishers, creating managing Publications, managing Replication monitors .
  • Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.
  • Performed analysis and design of the application.
  • Did the database administrative job of Security, Backup/recovery, ODBC connections etc.,
  • Performed Database backups operating system, flat file backups export/import .

Hire Now