We provide IT Staff Augmentation Services!

Senior Ms Sql Server Dba Resume

Charlotte, NC

SUMMARY:

  • Over 9+ years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2016, 2014, 2012, 2008R2, 2008 and 2005 in Production, Development, UAT & Test Environments
  • Extensive experience in installation, configuration, and maintenance of MS SQL Server 2016, 2014, 2012, 2008R2, 2008, and 2005
  • Expert in Upgrading and migrating from SQL server 2008/2005 to SQL server 2016/ 2014/2012/2008 R2
  • Extensive experience in Data Mapping and Database migration/testing for SQL Server Environments
  • Experienced in working with production 24/7 Environment
  • Expert working in Virtual Environment using VMWARE for SQL Server
  • Expert in implementing/installing/configuring and migrating SQL Server to Microsoft Azure based cloud
  • Expert in upgrading SQL Server environments from one data center to Microsoft Azure cloud
  • Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection
  • Experienced in working in OLTP and OLAP environment that includes Production (24x7), QA and development databases in SQL Server 2016/ 2014/2012/2008 R2/2008
  • Experienced in working of Client/Server and Web based applications using Visual Basic 6.0, ASP, ASP.NET (1.1/2.0/3.5), ADO.ENT, C#, VB.NET, and Web Services.
  • Experienced in Database Backup, Recovery and Disaster Recovery procedures.
  • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification
  • Extensive experience in Maintaining High Availability using Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005 to provide robust database solutions
  • Experience in Amazon Web Services (AWS), and Microsoft AZURE
  • Implemented Always ON functionality on SQL Server 2014/2012
  • Expert in Active/Passive and Active/Active Clustering
  • Expert in implementing Log shipping and Mirroring for HA and DR
  • Expert in Performance tuning using SQL Server DMV's
  • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
  • Extensive experience with SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.
  • Expert in Active Directory / SQL based Security of SQL Server 2016/ 2014/2012/2008 R2/2008/2005 by creating logins, groups, Database Users, Roles and assigning proper permissions according to business requirements
  • Experience in creating roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks
  • Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
  • Experience with Reporting Services (SSRS) and Analysis Services (SSAS)
  • Created maintenance plans to perform index defragmentation, re-indexing and update Statistics
  • Proficient in troubleshooting database issues
  • Team player with Good communication, interpersonal and business analysis skills

TECHNICAL SKILLS:

MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005, Windows Server 2012R2/2012/2008R2/2008/2003, DTS, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), Microsoft AZURE, Amazon Web Services (AWS), OLAP Tools, SQL, Perl, Visual Basic, VB.Net, TOAD, SQL* Loader, IDERA Diagnostic Manager, Apex SQL Monitoring Tools, Red-Gate SQL Backup Tool, Lite Speed Backup Tool, VMWARE.

PROFESSIONAL EXPERIENCE:

Confidential, CHARLOTTE, NC

Senior MS SQL Server DBA

Responsibilities:

  • Provided 24/7 support for Production environment on on-call basis
  • Installed, Configured and Maintained SQL Server 2016, 2014, and 2012 in PROD, PFIX, UAT, DEV, and SIT environment.
  • Configured and Maintained SQL Server Clustering.
  • Implemented AlwaysON availability groups for 2 replicas.
  • Worked exclusively on Microsoft Azure for cloud based implementation of SQL Server. Worked on Azure SQL server, databases, SQL Data Warehouse.
  • Set up and Managed Auditing, alerts and monitoring in Azure environment.
  • Highly skilled in implementation and managing High Availability Environments like Always On Availability
  • Configured and maintained Log Shipping for DR environment.
  • Experience in implementing Transactional Replication on basis of business specification.
  • Databases created and maintained in shared farm servers and dedicated servers.
  • Used Lite speed backup tool and Native backup tool for database backups and restores.
  • Migrated databases from SQL Server 2008R2 to SQL Server 2016 and 2014.
  • Ensured the integrity and security and auditing the SQL Servers.
  • Used Performance Monitor/Profiler, trace flags to solve Dead Locks/Long running queries.
  • Used SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code.
  • Created automated daily and weekly system maintenance tasks such as database backup, database integrity, and database indexing.
  • Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues and disk I/O issues, created baselines stats.
  • Managed capacity planning and implement database security for multiple instances of PROD, PFIX, UAT, DEV, and SIT environments.
  • Maintained change control and release management process for all database objects like tables, views, procedures, and triggers.
  • Created Linked Servers between SQL Server 2012, 2014, 2016 and Oracle databases.
  • Managing security tasks like granting and revoking permissions.

Environment: MS SQL Server 2016/ 2014/2012/2008 R2, SSIS, SSRS, SSAS, Windows Server 2012R2/2012/2008 R2/2008, Clustering, Mirroring, Replication, Log Shipping, AlwaysON, Foglight monitoring tool, Lite Speed Backup Tool, VMWARE.

Confidential, SAN RAMON, CA

Senior MS SQL Server DBA

Responsibilities:

  • Worked as a Production DBA with primary database comprising of SQL Server 2016/ 2014/2012/2008 R2/2008/2005
  • Performed side by side migration and followed both pre and post checklist for database migration
  • Migrated SQL Server Databases from SQL Server 20 R 2/2012/2014/2016 on working hours as well as weekends
  • Installed SQL server 2016/2014/2012 instances on VMware server
  • Expert in using VMWARE Server
  • Migrated all databases and servers from San Ramon data center to San Antonio data center
  • Working knowledge of Double Take SQL migration tool
  • Migrated SSIS packages from SQL Server 2008R2 to SQL Server 2012
  • Resolved all migration related issues after the databases migration and created database maintenance plan for the performance of SQL Server which covers Database Integrity Checks, Update Statistics, and Re-indexing
  • Implemented best practices for Database Monitoring, Backups and Restores
  • Used Lite speed backup tool for database backups and restores
  • Configured linked servers to enable the SQL Server Database Engine to execute commands against OLE DB data sources of the instance of SQL Server
  • Used SQL Azure extensively for database needs in various applications
  • Import data from different data source to create Power BI reports and dashboards
  • Created Power BI Visualizations and Dashboards as per the requirements
  • Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance
  • Used various Transformations in SSIS Dataflow, Control Flow using for Loop Containers and Fuzzy Lookups
  • Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Wrote ad-hoc T-SQL queries for data analyzing, research, unit testing and identifying and resolving bugs
  • Experience in using SQL Server Profiler and Database Engine Tuning Advisor (DTA)
  • Planned and Implemented AlwaysON availability groups for 3 replicas
  • Documented and managed AlwaysON availability groups
  • Involved in designing cloud deployment strategies that mitigate risk while meeting infrastructure
  • Responsible for designing and implementing cloud - based solutions
  • Planned and Implemented SQL Server in Microsoft Azure and Cloud based systems
  • Installed, configured, and managed the AWS cloud servers
  • Created AWS Multi-Factor Authentication (MFA) for instance RDP/SSH logon, worked with teams to lock down security groups
  • Implemented Database Mirroring with high-performance and high-safety mode
  • Configured and maintained Log Shipping for DR environment
  • Experience in implementing different types of Replication models like Snapshot, Merge and Transactional on basis of business specification
  • Created Users, Logins, Roles and granted appropriate permissions
  • Performed SQL DBA activities on mission critical SQL Databases on which SAP ECC 6.0 was hosted
  • Maintained SOX compliance
  • Provided 24/7 support for Production environment

Environment: MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005, SSIS, SSRS, SSAS, Windows Server 2012R2/2012/2008 R2/2008/2003, AlwaysON, Microsoft AZURE, AWS, IDERA Diagnostic Manager, Lite Speed Backup Tool, VMWARE.

Confidential, TOWSON, MD

Senior MS SQL Server DBA/Team Lead

Responsibilities:

  • Managed PRODUCTION database server with 24/7 support and On-Call environment
  • As a Production support DBA Managed Multiple SQL Servers in Production, Development and QA Environment
  • Managed off shore team (3 resources) for migration project
  • Migrated multiple SQL Servers from SQL Server 2008 R2 and 2005/2008 R2 to 2012
  • Planned Database Migration steps, Mappings and Data transfer for migration of SQL Servers
  • Implemented Database Mirroring on SQL Server 2008 R2 for DR/HA.
  • Did heavy duty In-Place and Side by Side Migration/Upgrade of SQL Servers
  • Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for production environments.
  • Created linked server in Production, Development, and QA Environment
  • Installed SQL Server 2014 on windows server 2012 in Dev and Test environments.
  • Mapped Data from various sources to SQL Server Destinations
  • Implemented and maintained MS SQL Server 2012 in Production, Dev, and Test environments
  • Monitored and scheduled jobs on Production, Development, and QA servers
  • Managed Database backup and restore in Production, Development, and QA environment
  • Maintained / managed database agent jobs, check for failures and resolve failure issues
  • 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.
  • Resolved performance related issues like Blocking, Deadlocks and long running queries
  • Experienced with improving SQL Server using windows performance monitor to improve the server performance.
  • Designed robust stored procedure for business continuity
  • Analyzed existing stored procedure, queries, views and processes for performance bottlenecks
  • Deployed SSIS packages to MSDB database and file system in SQL Server 2008 and 2008 R2
  • Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
  • Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
  • Created SSIS packages for Data Mapping and Data Transfer between sources
  • An exclusive experience working with User Controls with VB.NET code-behind files, debugging and Quality Testing of the code.
  • Worked on IDERA Diagnostic Manager tool for performance issues
  • Experienced in troubleshooting production servers and fixed the user and application issues
  • Created, maintained the users, roles and granted appropriate privileges

Environment: MS SQL Server 2014/2012/2008 R2/2008/2005, SSIS, SSRS, SSAS, Windows Server 2012/2008 R2/2008/2003, IDERA Diagnostic Manager, Red-Gate SQL Backup Tool, VB.Net, VMWare SQL Servers.

Confidential, DES MOINES, IA

Senior MS SQL Server DBA

Responsibilities:

  • As a Production and development support DBA responsible for maintaining SQL Servers database servers in production, Development and QA Environments
  • Installed SQL Server 2012, SQL Server 2008 R2 and SQL Server 2008 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 for HA
  • Managed SQL Server Clusters in a SAN environment
  • Implemented Database Mirroring on SQL Server 2008 R2 environments for DR/HA.
  • Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR.
  • Implemented transactional replication for data refresh
  • Managed and Administered databases in SCOM
  • 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 R2/2012
  • Mapped Data for Data Transfer and Data Migration
  • 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 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
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load
  • Created extensive reports using SSRS ( Tabular, Matrix )
  • 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.

Environment: MS SQL Server 2012/2008 R2/2008/2005, SSIS, SSRS, SSAS, Windows Server 2012/2008 R 2/ 2008/2003.

Confidential, WICHITA, KS

Senior MS SQL Server DBA

Responsibilities:

  • Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
  • Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008 R2.
  • Interacted with Developers in troubleshooting application and database issues.
  • Identified, tested and resolved database performance issues to ensure data optimization.
  • Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
  • Implementation of system wide security policies and trouble shooting.
  • Involved in installing SQL Server 2008/2008 R2 on Development, Production and WTC (Testing) machines.
  • Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
  • Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.
  • Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
  • Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2.
  • Involved in troubleshooting all the performance issues for different database applications.
  • Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool.
  • Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Documented all the steps and procedures for future s.
  • Created performance baseline reports using RML tool and documented for future use.
  • Involved in setting up database mirroring for production server
  • Configured snapshot and transactional replications.
  • Monitoring and scheduled jobs on production and staging environment.
  • Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
  • Used the Execution Plan to improve the optimization of the T-SQL code.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Provided 24 x 7 Production support for the database and application issues.

Environment: MS SQL Server 2008 R2/2008/2005, SSIS, SSRS, SSAS, Windows Server 2008 R 2/2008/ 2003.

Hire Now