We provide IT Staff Augmentation Services!

Senior Ms Sql Server Db/production Support Resume

Huntersville, NC

SUMMARY:

  • Nine Plus years of solid experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2014/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 with Ticketing and Change Management.
  • 7+ Years experience in managing OLTP, DSS and Virtual environments in Clustered and Mirrored environments
  • Hands on Experience in Upgrading and Migrating SQL Server from lower versions to SQL 2014/2012
  • 3+ Years experience in Cloud computing and Microsoft Azure configurations
  • 3+ Years experience in SQL Server 2012 and setting up AlwaysON Availability groups
  • 5+ Years experience in Database design, warehouse, modeling, relationship using ERWIN and VISIO
  • Expert in MS SQL Server installation Installations and updating and Patching servers with Hot Fixes.
  • 7+ Years experience in Planning and Implementing HA and DR strategy
  • 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 2012/2008 R2.
  • Expert in setting up Snapshot and Transactional Replication
  • Expert in implementing SQL Server 2008/2005 Database Mirroring.
  • Experience in implementing Snapshot and Transactional replication models.
  • Heavy duty migration of SQL Server DTS packages to SSIS
  • Expert in working on Dell, EMC, Equallogic SAN boxes and SAN configurations
  • 2+ Years experience in Powershell Scripting
  • Expert in capacity planning, performance tuning, troubleshooting and finding bottlenecks
  • Strong experience in designing databases, creating tables, views, strored procedures and Triggers.
  • Documented disaster recovery plans and participated in disaster recovery drills.
  • Developed backup and recovery strategies for production environment.
  • 7+ Years experience in SQL Server Integration Services (SSIS).
  • 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, Foglight and SQL Sentry for MS SQL Server.
  • Strong Team player with excellent verbal and written communication skills

TECHNICAL SKILLS:

  • Windows Server 2012
  • 2008 R2/2003
  • MS SQL Server 2014/2012/2008 R 2/2008/2005/2000
  • Enterprise Manager
  • Query Analyzer
  • SSIS
  • SSRS
  • SSAS
  • Clustering
  • Mirroring
  • AlwaysON
  • Log Shipping
  • Replication
  • Oracle 10g/11i
  • DTS
  • MS 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
  • VMware
  • Net Backup.

GOOD APPLICATION EXPERIENCE IN

  • Setting up AlwaysOn Availability groups with SQl Server 2012
  • Setting up Active/Active and Active/Passive Clustering on SQL Server 64 bit environment.
  • Setting up Replication using MS SQL Server 2012/2008 R2/2008
  • SSIS (SQL Server Integration Services).
  • SSRS (SQL Server Reporting Services).
  • Setting up Log Shipping (Manual/Wizard) in SQL 2012/2008 R2.
  • Setting up SQL Server Database Mirroring in SQL Server 2012/2008 R2

PROFESSIONAL EXPERIENCE:

Confidential, Huntersville, NC

Senior MS SQL Server DB/Production Support

Responsibilities:

  • Worked as a Production Support DBA giving 24/7 support and On-call support
  • Supported SQL Server systems by working on Ticketing and Change management applications
  • Monitored SQL thru SQLSentry and Spotlight.
  • Responsible for doing weekend SQL deployments in production.
  • Installed SQL 2012/2014 SQL servers in Development and Production environment.
  • Actively Involved in Setting up AlwaysON and Clustered environments
  • Worked on VMware and Virtual Instances of SQL Server databases.
  • Worked on SQL servers running thru Prophix budgeting system.
  • Managed back end SQL servers of SharePoint environment.
  • Responsible for managing SQL Data warehouse and updates related to it.
  • Migrated SQL Codes thru RedGate tool.
  • Performance tuning, and optimization of procedures and queries.
  • Responsible for creating and deploying SSRS reports to TEST, UAT and production environments.
  • Worked SQL servers running thru RockySoft Forecasting tool.
  • Worked on JIRA ticketing system for time tracking purpose.
  • Responsible for managing Offshore(Canadian, Indian) SQL servers and offshore resources.
  • Involved in monitoring the backup jobs and fixed the failed jobs.
  • Managed cubes processing for production OLAP servers.
  • Involved in creating Roles, Dimensions and Measure groups for SSAS cubes.
  • Created custom assemblies for OLAP servers.
  • Involved in creating SSIS packages.
  • Created and scheduled SQL jobs in control - M tool.
  • Worked on Source Tree tool to manage SQL codes in Stash repositories.
Confidential, Tallahassee, FL

Senior MS SQL Server DBA/Production Support

Responsibilities:

  • Managed MS SQL Server 2012, 2008 R2 and 2005 in Production, Development and QA environment
  • Managed Databases in Physical and Virtual environment
  • Worked extensively on VMware and Virtual Instances of SQL Server databases
  • Installed SQL Servers for Active/Active and Active Passive Clustering
  • Implemented Mirroring and Log Shipping for Disaster Recovery
  • Created the maintenance plans for integrity checks, Rebuilding Indexes, Reorganizing indexes and optimization for Production, Test, Uat and development servers.
  • Created SQL backups and scheduled for Production, Test, Uat and Development servers.
  • Worked with SQL server Profiler for creating Audit log of SQL users.
  • Created SQL users in Development, Test, Uat and Prod Environments. Removed orphan users from SQL servers for all Environments.
  • Created SSIS packages to Extract and Load data from flat files of DHSMV source.
  • SQL Server 2008R2 set up in Development, Test and Prod Environments.
  • Reporting services' set up in Development, Test, Prod and DR (Installed BIDS for SSIS, SSRS and SSAS)
  • Removed errors from previously set up SQL jobs on Development servers.
  • Database mail set up on SQL Servers in all environments.
  • Set up operators for all SQL job notifications.
  • Applied TDE for mission critical databases.
  • Created Transactional Replication for Test and Prod databases.
  • Publishes in all Environments with SQL Scripts and Red Gate tool.
  • Created local windows accounts for report users, included them in groups and added those groups on Report manager to have access on Report server for users.
  • Created linked servers for OpenQuery statements.
Confidential, Pennsylvania

Senior MS SQL Server DBA

Responsibilities:

  • Installed, configured and maintained MS SQL fail over clustering for 2 mission critical servers
  • Involved in monitoring the backup jobs and fixed the failed jobs.
  • Scheduled package execution in SSIS
  • Experienced in troubleshooting production servers and fixed the user and application issues.
  • Involved in restore operations to refresh the data from production to test servers.
  • Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
  • Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
  • Created the DTS packages to import and export the data from Oracle, MS Access and text files to SQL Server.
  • Worked with SQL Server Reporting Services (SSRS).
  • Experienced in creating backup strategy for production, test and development servers.
  • Involved in disaster recovery procedures and restore the production databases.
  • Created the maintenance plans for integrity checks and optimization for production, test and development servers.
  • Tunes SQL queries and stored procedures to improve the SQL Server performance.
  • Involved in trouble shooting SQL Server production issues. Worked with the report team to fix the reporting issues.
  • Gathered end user requirements through meetings with manager and users
  • Work for upgrading of SQL Server 2000, 2005 and 2008 to SQL Server 2008R2
  • Created the standard documents for Disaster recovery testing and implemented them.
  • Experienced Working on Citrix Reporting Services.
  • Took the windows and SQL backups using Net Backups.
Confidential, New Jersey

Senior MS SQL Server DBA

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 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
  • 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 ( Tabular, Matrix )
  • 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, New York, NY

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.
  • 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.
  • Experience in creating and executing SQL Server Integration Services (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.
Confidential, Orlando, FL

Senior MS SQL Server DBA

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 Services (SSRS).

Hire Now