We provide IT Staff Augmentation Services!

Senior Ms Sql Server Dba Resume

Omaha, NE

SUMMARY:

  • Ten Plus years of IT experience with more than five years in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2016/2014,2012,2008 R2 and 2005 databases in Production, Test, Development, Replication and Cluster Server Environments.
  • Very good experience in Installation, configuration and maintenance of SQL Server 2016/2014,2012/2008 R2/2005.
  • Extensive knowledge of Relational Database Management Systems and Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and De - normalization and building Referential Integrity Constraints using AllFusion Erwin 7.1 and Visio.
  • Expert in cloud implementation with Microsoft Azure and Amazon AWS.
  • Expert in VMware and Virtualization technologies
  • Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
  • Experience in MS SQL Server upgrades from MS SQL Server 2000/20 / 2014/2012/2008 R2.
  • Expert in Setting up High Availability (HA) with AlwaysON Availability Groups and Clustering
  • Expert in HA and DR with Clustering, Mirroring and Log Shipping
  • Experienced in working in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server 2016/ 2014/2012/2008 R2.
  • Knowledge of implementation of software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
  • Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs Interacted with the users and troubleshooting the problems involved with the development of stored procedure.
  • Experience in capacity planning, performance tuning, disaster recovery, troubleshooting, backup and restore procedures.
  • Expert level skills in High Availability, Disaster Recovery, Virtualization and Replication
  • 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 2014/2012/2008 R2.
  • Expert in Log shipping/ Database Mirroring with SQL Server 2016/ 2014/2012/2008 R2.
  • Experience in implementing Snapshot and Transactional replication models with SQL Server 2008 R2.
  • Developed Backup and Recovery strategies for PRODUCTION environment.
  • T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures, etc.
  • Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities and using SQL Server latest DMV's.
  • 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).
  • Created complex SSIS packages using SQL Server Data Tools (SSDT) and SQL Server Business Intelligence Development Studio
  • 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.
  • Expert in T-SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and Data Transform Services (DTS).
  • Good Knowledge of LiteSpeed, IDEARA Diagnostic Manager, Foglight for MS SQL Server.
  • Expert in database modeling and reverse engineering in ERWIN and VISIO
  • Excellent communication skills, good team player and can work independently.

TECHNICAL SKILLS:

Windows Server 2012/2008 R2/2003, MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 , Enterprise Manager, Query Analyzer, Oracle 10g/11i, DTS, MS SQL SSRS, SSAS, SSIS, SQL Profiler, ASP.Net 3/2.0, SQL, PL/SQL, Visual Studio 2008/2005, T-SQL, ERWIN, Database Modeling, Microsoft VISIO, IDERA SQL Diagnostic Manager, SQL Litespeed, Lumigent Log Explorer, Dell PowerEdge, HP Blade, Microsoft AZURE, VMWare, Amazon AWS

PROFESSIONAL EXPERIENCE:

Confidential, Omaha, NE

Senior MS SQL Server DBA

Responsibilities:

  • As a Database Administrator responsible for managing Production, Development QA and Integration Environment.
  • Worked Heavily on the Installation, Configuration and Maintained SQL Server 2008R 2/2012/2014/2016 on Windows 2003, 2008, 2008R2, 2012.
  • Planned and Implemented SQL Server in Microsoft Azure and Cloud based systems.
  • Worked extensively for the database sizing and capacity planning for production servers and QA servers.
  • Responsible for Installing and configured SSRS, SSIS and SSAS Tabular Model.
  • Configured SQL Server 2012/2014 AlwaysON Availability Group for High Availability.
  • Responsible for Implementation of Backup and Restoration Strategy for Production, QA and Development Environment.
  • Created Database Maintenance Planner for the Production Databases which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Implemented Replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for Transactional Replication.
  • Exclusive Knowledge of Database security including creation of roles/login/user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant /revoke permission to access data and how to make a security plan matching your business needs.
  • Managed SQL Servers in 32/64 bit Clustered environments.
  • Implemented Database mirroring for disaster recovery in Production Environment.
  • Configured Log shipping architecture to provide backup server solution for many environments.
  • Monitored and managed all Publisher, Distributor and Subscriber database environments for the replication.
  • Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
  • Created the SSIS packages, DTS to import the data from one Environment to other Environment.
  • Installing packages on multiple servers in SSIS
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load
  • Created extensive reports using SSRS ( Tabular, Matrix )
  • Worked with developers to do the database schema changes and database restoration requests.
  • Managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications
  • Involved in restore operations to refresh the data from production to test servers.

Environment: SQL Server 2016/ 2014/2012/2008 R2, AlwaysOn Availability Group, Microsoft Azure, clustering, Mirroring, Logshipping, VMWARE, ERWIN, VISIO, T-SQL, Windows Server 2012 R2, 2012, 2008 R2, SSIS, SSAS, SSRS, LiteSpeed, Redgate, Foglight, IDERA Diagnostic Manager

Confidential, Omaha, NE

Senior MS SQL Server DBA

Responsibilities:

  • As a Production support DBA responsible for managing production, development and QA environments and participated in on call 24/7 support.
  • Responsible for the database sizing and capacity planning for production servers.
  • Responsible for the Install, Configured and Maintained SQL Server 2005/2008/2008 R2/2012 on Windows 2003, 2008, 2008R2, 2012.
  • Worked heavily on Space Management, I/O tuning, managing migration process, performance analysis and production support for large and complex database up to 6 TB.
  • Exclusive Knowledge of Database security including creation of roles/login/user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant /revoke permission to access data and how to make a security plan matching your business needs.
  • Configured SQL Server 2012 AlwaysON Availability Group for High Availability.
  • Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries.
  • Implemented Replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for Transactional, Merge and Snapshot Replication.
  • Responsible for the Database backup and Restoration using SQL native tool.
  • Developed and Maintained SSIS Package to Extract and Load data from diverse source (flat file, excel, xml and oracle).
  • Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
  • Worked heavily on Disaster recovery planning and Database Security for 180 servers.
  • Did heavy duty Migration / Upgrades from lower version of SQL Server 2008 R2 to SQL Server 2012.
  • Worked heavily on BCP utility to publish table output to text file.
  • Implemented Maintenance plane for the various databases and also responsible for the Database consistency check for all Databases.
  • Implemented Database Mirroring on SQL Server 2012 environments.
  • Configured and Maintained Log shipping on Primary and Secondary server with or without witness server on MS SQL 2012.
  • Design and Configured Partitioning of table and Indexes to Improve query performance in SQL 2012.
  • Implemented Data and backup compression to reduce I/O and maintained security respectively.
  • Simplify and Optimize complex query that involve multiple tables by using multiple joins and sub-queries to maintain administrative tasks.
  • Monitor server performance using SQL Profiler, Index tuning and debug T-SQL and fine tune SQL queries.
  • Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2008/2012.
  • Extensively worked with Developers to do the Database Schemas Changes.
  • Extensively worked with Developers and QAs for the Database restoration and Refresh the data from production to Pre-Production, QA and Development Environments.
  • Developed internal control technical documentation that sufficiently describe the maintenance responsibility for the production support team.

Environment: MS SQL Server 2012/2008 R 2/2008/2005/2000 , Windows Server 2012, 2008 R2/2003/2000, Vmware, Vsphere, Virtualization, Ideara Diagnostic Manager, RedGate, SQL Delta, SSIS, SSRS, Clustering, Mirroring, Log Shipping, Replication.

Confidential, Harrisburg, PA

Senior MS SQL Server DBA

Responsibilities:

  • As a Production support DBA responsible for managing production, development and test environments.
  • Did heavy duty Migration / Upgrades from lower version of SQL Server to SQL Server 2012/2008 R2
  • Migrated Oracle Databases in SQL Server 2012.
  • Worked heavily on critical stored Proc. And Functions.
  • Installed / configured SQL Server in Virtual Environments using VMWare.
  • Installed SQL Server 2012/2008 R2/2008 and SQL Server 2005 on windows 2008 and 2003 servers, applied service packs and security fix for all servers.
  • Exclusive Knowledge of Database security including creation of roles/login/user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant /revoke permission to access data and how to make a security plan matching your business needs
  • Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
  • Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
  • Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle) and also Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
  • 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
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load
  • Created the standard documents for Disaster recovery testing and implemented them.
  • Experienced with database sizing and capacity planning for production servers.
  • Created the backup schedule for production, test and development servers.
  • Worked with developers to do the database schema changes and database restore request.
  • 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.

Environment: MS SQL Server 2012/2008 R 2/2008/2005/2000 , Windows Server 2008 R2/2003/2000, Vmware, Vsphere, Virtualization, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Confidential, Windsor, CT

Senior MS SQL Server DBA

Responsibilities:

  • As a Production support DBA responsible for managing production, development and QA environments.
  • Managed multiple instances of SQL Server in Virtual and Physical environments with 32 / 64 bit environments
  • Installed / configured SQL Server in Virtual Environments using VMWare.
  • Installed SQL Server 2008 R2/2008 and SQL Server 2005 on windows 2008 and 2003 servers, applied service packs and security fix for all servers.
  • Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2005/2008
  • Implemented Database Mirroring on SQL Server 2008 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL 2005/2008.
  • Implemented replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for transactional, merge and snapshot replication
  • Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
  • Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
  • Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle) and also Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
  • 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
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load
  • Created the standard documents for Disaster recovery testing and implemented them.
  • Experienced with database sizing and capacity planning for production servers.
  • 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.

Environment: MS SQL Server 2008 R 2/2008/2005/2000 , Windows Server 2008 R2/2003/2000, Vmware, Vsphere, Virtualization, Ideara Diagnostic Manager, RedGate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Confidential, Chicago, IL

Senior MS SQL Server DBA

Responsibilities:

  • As a Production and development support DBA responsible for maintaining 150 SQL Servers out of which 100 servers are production servers in which 30 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 and 2003 servers, 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
  • Worked extensively with SQL Server DMV's for resolving performance bottlenecks
  • Worked extensively on Windows Perfmon for I/O bottlenecks
  • 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.
  • Installing packages on multiple servers in SSIS
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load
  • Created extensive reports using SSRS ( Tabular, Matrix )

Environment: MS SQL Server 2008 R 2/2008/2005/2000 , Windows Server 2008 R2/2003/2000, Vmware, Vsphere, Virtualization, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Confidential, NJ

Senior MS SQL Server DBA

Responsibilities:

  • Managed All Production, Development and QA Environments running MS SQL Server 2005/2000.
  • Involved in Migration of Production Database Servers from SQL Server 2000 to SQL Server 2005.
  • Involved in Performance Tuning on Production, Staging and Test Servers.
  • Worked with Off-shore teams for builds and releases
  • Involved with maintenance of ACTIVE/PASSIVE Cluster Environments
  • Implemented Database mirroring for High Availability.
  • Maintained various databases for Production and Testing using SQL Server 2005.
  • Used AllFusion ERWIN to deploy any changes to the database and objects from test to production.
  • Worked with SQL Server Profiler and Perfmon.
  • Involved in Monitoring Performance of different production servers.
  • Planning the location of data, index, and Transaction log files on the disk.
  • Performance tuning, and Optimization of Stored Procedures and Queries.
  • 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.
  • Involved in creating reports using SQL Server Reporting Services (SSRS) as per the requirement.
  • Migrated DTS packages to SSIS packages.
  • Involved in Migration of Reporting Servers from SQL Server 2000 to SQL Server 2005.
  • Managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
  • Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies and by creating proxy accounts.
  • Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
  • Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
  • 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.

Environment: MS SQL Server 2008 R 2/2008/2005/2000 , Windows Server 2008 R2/2003/2000, Vmware, Vsphere, Virtualization, Ideara Diagnostic Manager, RedGate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Confidential, Trenton, NJ

SQL Server DBA

Responsibilities:

  • Upgraded most of SQL Server 2000 to SQL Server 2005
  • Involved with upgrade of databases from 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 and Worked with SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2005/2000, Windows Server 2003/2000, Vmware, RedGate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Hire Now