We provide IT Staff Augmentation Services!

Ms Sql Server Dba Resume

4.00 Rating

Atlanta, GA

PROFESSIONAL SUMMARY:

  • Senior MS SQL Server DBA with Extensive knowledge in Managing SQL Server environment.
  • Over 6+ years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2014,2012,2008 R2 and 2005 in Production, Development & Replication Environments.
  • 6+ years of experience in installation, configuration, and maintenance of MS SQL Server 2014/2012/2008 R2/2005
  • 3+ Years’ experience in SQL Server 2012 with setting up AlwaysON Availability groups
  • 5+ Years of experience as a MS SQL Server Developer with extensive experience in SSIS/SSRS.
  • Proficient experience in upgrading and migrating from SQL server 2005/2008 to SQL server 2014/2012.
  • Expert working in Virtual Environment using VMWARE for SQL Server.
  • 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 2008 R2/2005/2000 to provide robust database solutions.
  • Expert in Active/Passive and Active/Active Clustering.
  • Expert in implementing log shipping for Disaster Recovery and Reporting
  • Expert in implementing database mirroring which includes Sync and Async Mirroring
  • 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.
  • Experience in managing security of SQL Server 2000/05/08/08 R2 by creating Database Users, roles and assigning proper permissions according to business requirements.
  • 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).
  • Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation from previous versions.
  • Created maintenance plans to perform index defragmentation, re-indexing and update Statistics.
  • Proficient in troubleshooting database issues.
  • Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
  • Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications.
  • Team player with Good communication, interpersonal and business analysis skills.

TECHNICAL SKILLS:

  • MS SQL Server 2014/2012/2008 R2/2008/2005
  • Windows Server 2008 R 2/2008/2003/2000
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft SQL Server Reporting Services (SSRS)
  • Microsoft SQL Server Analysis Services (SSAS)
  • Data Modeling, Erwin 4.0/3.5, Star Schema Modeling
  • Oracle 10g/9i/8i, MS SQL Server 2008/2005, OLAP Tools
  • HPQC 9.2, SQL, PL/SQL, Perl, Visual Basic
  • TOAD, SQL* Loader, IDERA Diagnostic Manager
  • Apex SQL Monitoring Tools.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

MS SQL Server DBA

Responsibilities:

  • Worked primarily as a PRODUCTION support DBA giving 24/7 Support.
  • Installed, configured and patched SQL Server 2014 and implemented new features
  • Managed PRODUCTION, DEVELOPMENT, QA and UAT environments.
  • Worked extensively on Virtual and VMware Environments.
  • Worked across 90 servers and more than 200 databases with OLTP Database Size 2 TB.
  • Involved in Performance Tuning on Production, QA and Staging servers of teh current project.
  • Upgraded 20+ MS SQL Server from lower version to SQL Server 2014
  • Managed Production environment for High Availability in Active/Active and Active/Passive mode.
  • Involved in Monitoring Performance of different production servers.
  • Implemented Database Mirroring and Log Shipping for Disaster Recovery (DR).
  • Maintained various databases for Production and Testing using SQL Server 2008 R2.
  • Upgraded SQL Server 2008 instances to SQL Server 2008 R2 and SQL Server 2012 environment.
  • Worked on Implementing AlwaysON availability groups
  • Implemented AlwaysOn with Sync and Asyn configuration.
  • Experience in working with setting up HA groups with teh help of Always ON.
  • Implemented AlwaysON availability groups with three replicas for reporting and backup on SQL Server 2012; Heavy duty SQL Server Upgrade/Migration from Lower version to Higher Version.
  • Planning teh location of data, index and transaction log files on teh disk (SAN).
  • Performance tuning and optimization of procedures and queries.
  • Extensive use of SQL Server DMV's for Performance Tuning.
  • Worked extensively with SQL server Profiler for performance problems and bottlenecks.
  • Created teh Backup and Restore strategy for production and development environment.
  • Used new security feature called AUDIT in SQL 2008 on both server level and database level.
  • Worked on ETL Process creation and SSIS package Creation
  • Deployed SSIS packages from various Dev environments to QA and Prod
  • 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 scheduling SQL Server Integration Services (SSIS) packages.
  • Managing schema objects such as tables, views, clusters, indexes, procedures, triggers and maintaining referential Integrity depending on user requirements and converting them into technical specifications. Database and Transaction log backups & restoration, backup strategies, scheduling teh backups. Backing up system & user databases and restoring them.
  • Performing fine Tuning of Database Application. Cleansing and solving Database troubles.

Environment: MS SQL Server 2014/2012/2008 R2/2008, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003, VMWARE, Clustering, Mirroring, Log Shipping, Replication, IDERA, RedGate, LiteSpeed, ERWIN.

Confidential, IL

Senior MS SQL Server DBA

Responsibilities:

  • Installed SQL Server 2012/2008/2008 R2/2005 on Windows 2012/2008 R2 environment.
  • Worked extensively on SQL Server 2012/2008 R2 Transactional Replication.
  • Involved in monitoring and troubleshooting replication issues.
  • Configured Server Memory for maximum performance and TEMPeffective utilization.
  • Configured Temp DB for to increase teh performance of SQL Server.
  • Monitoring SQL server performance using profiler to find performance and deadlocks.
  • Used SQL Diagnostic Manager and SQL Compliance for analyzing locks, Blocking and Memory Utilization. Involved Design, Troubleshooting and Deployment of SSIS packages.
  • Migrated DTS packages to SSIS packages.
  • Deployed Custom Reports to QA and PROD environments by working with QA and Engineering team.
  • Refresh teh Production databases to DEV and QA environments for new releases.
  • Used Dynamic Management Views (DMV) for monitoring teh performance of teh server.
  • Worked and generated reports using SQL Server 2008 R2 Reporting Services (SSRS).
  • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner. Maintaining teh database consistency with DBCC at regular intervals.
  • Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security.
  • Policies for various categories of User Support.
  • Created Maintenance Plans dat helped in TEMPeffective disk utilization and index maintenance.
  • TEMPEffectively managed disk space using LITE SPEED for Data base Backups.
  • Worked on TORTOISE SVN and maintained teh data in Source control.
  • Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
  • Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
  • Extensively worked on 24X7 Production support and also involved in on call rotation.
  • Worked in REMEDY ticketing system and resolved tickets ranging from P1 to P4.
  • Extensively worked with Native and SQL SAFE compression Backups.
  • Extensively used IT Change Request (ITCR) tool to document, track, authorize and record.

Environment: Windows 2012/2008 R2, MS SQL Server 2005/2008/2008 R2/2012, MSCS, Mcrosoft IIS 6, SharePoint2007, Microsoft.NET, SSRS,SSAS, MS Visual Studio 6.0, REMEDY, IDERA.

Confidential, Austin, TX

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 teh time database migration from SQL Server 2005 to SQL Server 2008. Interacted with Developers in troubleshooting application and database issues.
  • Identified, tested and resolved database performance issues to ensure data optimization.
  • Managing Production SQL Servers on VIRTUAL and PHYSICAL environments
  • Installing and Configuring SQL Server 2005/2008/2008 R2.
  • Supported teh business 24/7, maintaining 99.999 uptimes depending on teh application and business SLA requirements. Involved in database design, database standards, and T-SQL code reviews.
  • Configured Active/Active and Active/passive SQL Server Clusters.
  • Implemented Mirroring and Log Shipping for Disaster recovery
  • Configured transactional and snapshot replication.
  • Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
  • Documented teh 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 teh performance issues for different database applications.
  • Deployed SSIS packages to MSDB database and file system using manifest file and teh wizard utility in SQL Server 2008. Involved in setting up database mirroring for production server.
  • Configured replication methods like snapshot, transactional and merge replications.
  • Monitoring and scheduled jobs on production and staging environment.
  • Responsible in monitoring and troubleshooting SQL Server Performance issues.
  • Used teh Execution Plan to improve teh optimization of teh T-SQL code.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Resolving performance related issues to Blocking, Deadlocks and long running queries
  • Provided 24 x 7 Production support for teh database and application issues.

Environment: MS SQL Server 2008 R 2/ 2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003, ERWIN, CLUSTERING, MIRRORING, LOG SHIPPING, Data Modelling.

Confidential

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 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 for HA.
  • Managed SQL Server Clusters in a SAN environment.
  • Implemented Database Mirroring on SQL Server 2008 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 teh 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.
  • Implemented Database Mirroring on SQL Server 2008 environments. Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
  • 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 teh standard documents for Disaster recovery testing and implemented teh documents.
  • Experienced with database sizing and capacity planning for production servers.
  • Experienced with creating logical and physical database design for development projects.
  • Created teh DTS, SSIS packages to import teh 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).Scheduled package execution in SSIS.
  • Created extensive reports using SSRS (Tabular, Matrix).
  • Created teh backup schedule for production, test and development servers.
  • Worked with Developers to create database schema changes and database restore requests.
  • Involved in restore operations to refresh teh data from production to test servers.
  • Experienced in troubleshooting production servers and fixed teh user and application issues.

Environment: MS SQL Server 2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008, 2003.

We'd love your feedback!