We provide IT Staff Augmentation Services!

Sr.sql Server Dba Resume

West Chester, PA

SUMMARY

  • Having 7+ years of experience as Database Administrator and Developer in SQL Server 2005/2008/2008 R 2/2012/2014/2016 in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP).
  • Extensive experience in Architecting, Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2005/2008/2008 R 2/2012/2014/2016 standalones and Failover Clusters both on Physical and Virtual environments.
  • Planning and Designing DB Servers wif thorough understanding of underlying Hardware, To Architect Database Servers including Sizing, Capacity planning wif thorough understanding SAN/RAID levels by working wif SAN team for IO Optimization, Bench marking, and Implementation of DR/HA strategies wifin SQL Server in accordance wif RPO/RTO meeting SLAs.
  • Hands on experience in Side by Side and In - Place Upgradation/Migration of SQL Server 2005/2008/2008 R2 instances to SQL Server 2012/2014.
  • Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAPtechnologies.
  • Solid experience and outstanding knowledge in implementing the High Availability and Disaster Recovery designs using the SQL Server Solutions like AlwaysOn Availability groups (AAGs), Mirroring, Log Shipping, Replication and SQL Failover Cluster Instances.
  • Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
  • Experience inDisaster Recovery Planning, Execution and Testing at remote site.
  • Very knowledgeable at SQL Server Internals and well experienced wif database admin skills including Backups/Recovery, Database Maintenance, Troubleshooting, Performance Tuning, Optimization, Designing HA and DR solutions in SQL Server 2005/2008/2008 R2/2012 and 2014.
  • Experienced in developing Stored Procedures, Triggers and Cursors using T-SQL.
  • Extensive experience wif SQL Server Business Intelligence solutions - SSIS, SSRS and SSAS.
  • Solid experience in designing ETL solutions using SSIS(SQL Server Integration Services)for data extraction, transformation and loading in SQL Server 2005/2008/2008 R2/2012 using tools likeImport and Export Wizard, Package Installation and SSIS Package Designer (BIDS/Data Tools).
  • Experience inDTS package Migrationto SSIS Package using Package Migration Wizard and troubleshooting migration related issues and rewriting the ActiveX Scripts to .Net Scripts.
  • Implemented data models, database structures, design, backup and recovery processes.
  • Extensive experience in dealing wif BI solutions including deploying ETL packages, SSRS reports and SSAS Cubes.
  • Thorough understanding and hands on experience configuring and managing SQL Server 2012/2014 Always ON Availability Groups and FCIs.
  • Extensive work experience on system analysis, design, development, testing and implementation of projects wif fullSDLC(Software Development Life Cycle).
  • Experience wif Designing/Deploying/Managing SSRS reports and managing the Report Server/Report Server security.
  • Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards. Served as primary DBA for critical SOX Complaint Applications wif Internal and External Auditors.
  • Expertise in Performance Tuning and Query Optimization to achieve high database efficiency.
  • Expertise in wif T-SQL Development skills including writing Stored Procedures, Indexes, CTEs, Indexed views, Triggers, User Defined Functions and Distributed Queries.
  • Extensive experience wif third party SQL Server Supporting, Monitoring and Alerting tools like Red Gate, SQL Sentry, Idera, Confio and Dell.
  • Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
  • Strong Communication, Management skills and Excellent Team player.
  • Very passionate in learning new features and technologies. Ability to mentor/guide fellow team members as required.
  • Exceptional focus and follow-through skills. Quickly and easily establish professional rapport wif peers, management and application developers.
  • 24/7 on Call Support for Production Databases.
  • Experience in raising the Service Requests and keep tracking of requests

TECHNICAL SKILLS

RDBMS\DBMS: MS SQL Server 2005/2008/2008 R 2/2012/2014/2016, MySQL 5.1/5.5, Oracle 9i/10g/11g and MS Access.

Languages: C, C++, T-SQL, ANSI SQL, Power Shell, C# .Net, ActiveX, HTML Script and PLSQL.

Web Server: Internet Information Server.

Operating Systems: Windows Server 2003/2003R2/2008/2008R2/2012/2012R2/2016 and Windows 98/XP/Vista/7/9/10.

Other DB Tools and Softwares/Services: SQL Server Enterprise Manager, SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SSRS, SSIS (as ETL), SSAS, Informatica, SQL Server Data Tools, Visual Studio, SQL Developer, SQL Server Migration Assistant, SQL Server Upgrade Advisor, VMware VCenter, VMware VSphere, Nutanix, Idera Diagnostic Manager/SQL Doctor, SQL Sentry Power Suite 8.1/Plan explorer, MS system center operations Manager (SCOM), dbForge SQL Complete, Red Gate SQL Backup/SQL Compare/Data Compare, light speed, CA Erwin, MS Visio, MS Project, 4.0, Microsoft Team Foundation Services (TFS), MS-Office 2007/2010/365 Suite, MS Visio, TOAD, Crystal Reports, Windows Active Directory, MAP Tool, SharePoint, Solarwinds Performance Analyzer, Azure, Dell Foglight, SQLIO, PSSDIAG, KeePass, WinDirStat, IIS, PlanView, BMC remedy and Service Now.

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

Sr.SQL Server DBA

Responsibilities:

  • Installed, configured and upgraded 75 servers wif service packs and cumulative packs on SQL server 2008R2, 2012, 2014 and 2016 in Test, Development and Production environments.
  • Designing and creating backups & recovery strategy and meet RPO/RTO objectives.
  • Implemented and maintained HADR solution, AlwaysOn High availability Groups on Two nodes and Three nodes critical production and development servers in SQL server2012/14/16.
  • Implemented encryption of sensitive data in the databases using Data Encryption Standards like TRANSPARENT DATA ENCRYPTION(TDE).
  • Migrated very large databases and servers from 2008R /2016 good experience in fixing orphaned users.
  • Configured and Maintained Log Shipping and Database Mirroring.
  • Worked on data refresh on regular basis from Prod to Test and Dev databases using backup/restore and Import/export.
  • Implemented snapshot and transactional replication between prod and vendors for data transfer.
  • Developed T-SQL scripts to implement new tables, views and stored procedures as per the business requirements and Normalization standards.
  • Having good knowledge on T-SQL developed different database level objects like tables, view, stored procedures, schemas and constraints maintaining data integrity, data quality as well as to reduce data redundancy .
  • Good knowledge in troubleshooting system databases and restoring them when they gets corrupted.
  • Supported several application by developing and deploying fixes to resolves errors in DDL and DML.
  • Worked closely wif provisioning and Change management team to resolve critical SQL server issues.
  • Worked extensively on server level and database level security in providing appropriate privileges by creating logins, users, configuring permissions to views, stored procedures and tables.
  • Experience in query optimization & performance tuning. Experience in using Database Tuning Advisor execution Plans, DBCC Commands, and WAIT TYPES.
  • Experience in Detecting and Resolving Locks, Deadlocks, CPU, Memory and Disk I/O using the Trace Flags and tools like Profiler, Windows Perfmon, Extendedevents, SCOM and IDERA.
  • Strong experience in monitoring and tuning SQL server databases for optimum performance and assistance in capacity planning of SQL server databases.
  • Redesigned several queries by adding necessary constraints as part of query tuning to improve performance and optimization.
  • Monitored index fragmentation and performed index rebuild or re-org at regular intervals depending on the fragmentation levels.
  • Experience in working wif Microsoft Azure hosted SQL databases
  • Used Dynamic management views(DMV’s) and Database Console Commands to check and gather several server level information and to perform integrity checks.
  • Experience on Migrating DTS packages to SSIS packages; worked on building and deploying SSIS packages.
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Migrated data wif transformations from different sources including flat files, MS EXCEL, to SQL SERVER and vice-versa by using SSIS.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.

Environment: Windows Server 2008/2008R2/2012/2012R2/2014/2016,Azure,SSMS, Enterprise Manager, MS-SQL Server 2005/2008/2008 r 2/2012/2014/2016, Red Gate tools, .NET Framework, Visual Studio, SCOM monitoring tool, SQL Sentry Power Suite 8.1/Plan Explorer, SSIS/DTS and SSRS, VMware machines, Data Tools, Query Analyzer, Idera Diagnostics manager/SQL Doctor, Dell LiteSpeed, Commvualt, Idera SQL Secure, SharePoint, VMware VCenter, SQLIO, WinDirStat, BMC Remedy, ServiceNow, SQL profiler.

Confidential, New York, NY

Sr.SQL Server DBA

Responsibilities:

  • Successfully upgraded 60+ SQL Server instances from SQL 2008/20012 to SQL Server 2014/2016 and redesigned the corresponding 100+ DTS packages to SQL Server 2012/2014.
  • To research, recommend, implement and maintain third party monitoring tools for SQL Server environment for monitoring and alerting purposes.
  • Responsible for analyzing the environment for missing standards and providing the best practices to manage and maintain the SQL Server instances TEMPeffectively and efficiently.
  • Installed and providing support for various Database Engines, SSRS and SSIS for Production, Development and Testing environments at different plants for local developer and application teams.
  • Used TFS for source control and managing development via tasks/bugs.
  • Extensively used repositories like Team Foundation Server (TFS), Visual source safe and clear case for Data Archival.
  • Developed some codes to work on Visual Studio 2008 and Team foundation server (TFS) also used the same code in SSRS to generate Reports.
  • Involved in building SQL Server instances, databases and other required components for upgrading core applications like Team Foundation Services, Trend Micro (Anti-virus), Equitrac (Printing) and System Center Configuration Manager (SCCM).
  • Implemented AlwaysOn Availability Groups(AAG) as HA solution for Missions Critical applications in SQL Server 2012/2014.
  • Architected Log Shipping and Replication topologies on the SQL Server 2012 as per the business requirements.
  • As a SME, was responsible for recommending the best HA/DR strategies from database environment based on the application Sensitivity/criticality and RTO/RPO as per SLA.
  • Implemented complex heterogeneous transactional replication from SQL Server to Oracle.
  • Designed different SQL Server db Performance and maintenance related KPI reports using the SSRS for Management and Peers.
  • Handling the database components for different Business Critical/Sensitive application releases and bug fixings.
  • Primary support Contact for AlwaysOn Availability Groups and Replication related issues for mission critical instances. Handled 24/7 production issues.
  • Configuring Oracle/PostgreSQL client tools and drivers for installing the heterogeneous Linked servers.
  • Working wif Internal and External auditors on audit requirements/regulations to make sure the SQL Server database environment is SOX Compliant.
  • Performed R&D and Implemented POC on new features/technologies in SQL Server. Designed and demonstrated POC on Contained Databases, Always On Availability Groups in SQL Server 2012, Column store Indexes, Buffer Pool Extensions and In-memory Tables in SQL Server 2014 and Query Store in SQL Server 2016.
  • Pro Active monitoring of all mission critical SQL Servers and fixing the highly critical issues before they start impact Production lines.
  • Implemented and configured database monitoring tools like SCOM/Idera Diagnostic Manager to focus on providing a highly available SQL Server instances/Databases.
  • Documenting the new feature/technology implementations and Best practices for managing SQL Servers.
  • Providing guidance (Mentoring) to the teammates on fixing critical issues, SQL Server best practices and Company standards/Procedures/Methods.
  • Configured Database Mirroring in High Performance and High Availability mode and troubleshooting issues wif witness servers.
  • Working on production change deployments, stage migrations and other regular requests and issues wif different application teams.
  • Working closely wif Change Management team on different Production cutovers.
  • Actively involved in setting up Active-Active/Active-Passive clusters in production and Testing Environments and troubleshooting issues wif the same. Applied hot fixes and Service Packs in clustering environments.

Environment: Windows Server 2008/2008R2/2012/2012R2/2014, SSMS, Enterprise Manager, MS-SQL Server / 2005/2008/2008 r 2/2012/2014/2016, Red Gate tools, .NET Framework, Visual Studio, SCOM monitoring tool, SQL Sentry Power Suite 8.1/Plan Explorer, SSIS/DTS and SSRS, VMware machines, Data Tools, Query Analyzer, Idera Diagnostics manager/SQL Doctor, Dell LiteSpeed, Confio Ignite, MAP, Apex, Idera SQL Secure, SharePoint, VMware VCenter, SQLIO, WinDirStat, BMC Remedy, ServiceNow, SQL profiler.

Confidential, St. Louis, MO

Sr.SQL Server DBA

Responsibilities:

  • Implemented data models, database structure design, backup and recovery processes.
  • Involved in installation of SQL Server 2012, 2008 and 2008 R2 on Consolidated and Standalone environments and maintains development and production databases (e.g., SQL Server databases).
  • Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG (Always On Availability Groups).
  • Involved in Installation of SQL Server wif Multiple instances, Service packs and Hot Fixes
  • Audits and maintains small-scale to large-scale databases.
  • Worked on SQL Server 2012 failover clustering which is built on top of a Windows 2003 server cluster.
  • Installed, configured Team Foundation Server (TFS). Also, Deployed code from TFS to SQL Server.
  • Worked on Active/Active and Active/Passive Clustering.
  • Involved in creating SQL Login accounts and Users wif appropriate permissions on Production and development servers.
  • Responsible for verifying all data to be entered database meets set standards and requirements.
  • Involved in creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application based on standard process.
  • Worked on Performance Tuning and Optimization, wif strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
  • Involved in migration of SSIS (2008) packages to SSIS (2012) packages.
  • Developed, deployed and monitored SSIS Packages for new ETL Processes.
  • Identifies tests and resolves complex database issues (e.g., monitoring and tuning).
  • Involved in database system management functions (e.g., software installs, version upgrades and configuration management).
  • Participated in a 24x7 production support on-call rotation.
  • Performed SQL Code Index Reviews.
  • Worked wif Database tools IDERA, SQL Diagnostic manager, Site-scope for Multi Queries, Space analyzer, SQL alerts (Disk space alerts, SQL Service alerts, CPU utilization alerts).
  • Involved in Ensuring optimal performance and availability of databases.
  • Involved in creating SQL jobs and troubleshoot failed jobs.

Environment: MS SQL Server 2005/2008/2008 R2/2012, SSRS, SSIS/DTS, SSMS, Enterprise Manager, SQL Profiler, Windows Server 2003/2003R2/2008/2008R2/2012, Active Directory, SQLIO.

Confidential, Hamilton, OH

SQL Server DBA

Responsibilities:

  • Installed and Upgraded fromSQLServer2000, 2005 and R2, 2012.
  • Migrated Databases fromSQLServer2000, 2005 and R2, 2012 andSQL2008 R2toSQL2012.
  • Installed and configuredSQL2012 Always On Availability Groups.
  • Installed and Configured Active-Passive, and AlwaysOn Availability Groups environment as a High availability DR solution.
  • Migrating and new installations ofSQLServeron Hyper-V & VMWARE environments and Supporting theSQLServerinstances, which are lying on the Windows Hyper-V servers.
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
  • Upgraded SharePoint 2007 to SharePoint 2013 (SQLserver2005 toSQLServer2012)
  • Performing Backup/Restore to/from Legatoserver(Tape) and Disk
  • Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Expert in configuring TempDB.
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
  • Created complex stored Procedures, Triggers, Cursors, Tables and otherSQLJoins and Statements for Applications by using T-SQL.
  • Checking Database Health by using DBCC Commands and DMVS.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Experience in Database security and integrity planning
  • Prepared Documentation for the Disaster Recovery plan.
  • Designed Data Integrator jobs wif Error Handling and email notifications.
  • Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
  • Generated periodic reports based on the statistical analysis of the data usingSQLServerReporting Services (SSRS).
  • Daily routineDBAtasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • RoutineDBAjobs like Backups and Restores.
  • 24/7 on Call Support for Production Databases.

Environment: MSSQLServer2012, 2008 R2, 2008, 2005 and 2000, T-SQL, ASP.Net 3.0, SSAS, SSIS (ETL), SSRS, SharePointServer2007, 2010 and 2013, Windows 2003, 2008 and 2012 Servers.

Confidential, Detroit, MI

SQL Server DBA

Responsibilities:

  • Installing, configuring and maintainingSQLServer2005, 2008, and 2008 R2.
  • Involved in migrating theSQLserver2008 fromSQL2005.
  • Implemented Mirroring wif Synchronous mode wif automatic failover.
  • Tuned complexSQLQueries.
  • Provided day-to-day administration tasks like space and log management.
  • Responsible for fine tuning of the database, troubleshooting, memory management.
  • Maintained databases wif DBCC (Rebuilding Indexes, Integrity Checks)
  • Created reports based on database usage and perform capacity planning.
  • Responsible for creating user groups and assigning permissions.
  • Developed stored procedures for generating Reports as per management requirement.
  • Optimized stored procedures and indexed query using Index Tuning Wizard.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy forSQLServers.
  • Setup and maintained Linked Servers.
  • Solving the Bugs and issues reflected by the Testing team.SQLServer2005/2000 Database Administration.
  • Migrated databases fromSQLServer2000 toSQLServer2005.
  • Implemented the newSQLServer2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
  • Created Documentation for steps need to be taken while upgrading theSQLServer2000 toSQL Server2005.
  • Daily routine Developer/DBAtasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • Designed and facilitated the implementation of data warehouses required by application systems
  • Supported OLAP team to providing data fromSQLServers.
  • Assisted wif various ad hoc query requests.

Environment: MSSQLServer2005/2008, ANSISQL, SSAS, SSIS, BO XI, Informatica, MSSQLServer Reporting Services 2005 (SSRS), DDL, SharePoint MossServer, ASP.Net, ETL, C#.Net.

Confidential

SQL Server DBA

Responsibilities:

  • Worked wif application teams on upgrading SQL Server instances from SQL Server 2005 to SQL server 2008 R2 on Various Production Servers.
  • Configured and maintained Transactional, Merge and Snapshot replications regarding the business needs on production servers.
  • Worked on Site Scope Monitoring tools and Lite Speed Backup Tool from Quest.
  • Performed Capacity Planning, data modeling and Logical/Physical database Design.
  • Recommended and configured the Database Mirroring wif and wifout witness Server in SQL server 2008R2/2008/2005 as the HA/DR strategy for Mission Sensitive applications.
  • Developed, deployed and monitored SSIS Packages for new ETL Processes.
  • Installed Oracle and PostgreSQL drivers to configure the linked servers.
  • Designed and implemented comprehensive Backup and Recovery plans and disaster recovery strategies for different environments.
  • Recommended and demonstrated the HA/DR solutions to the application teams considering their business requirements.
  • Designed and supported Multi-Instance clusters.
  • Provided support to the application developers to fulfill their needs on the application databases. Worked closely wif BI developers to Deploy/Troubleshoot/Upgrade issues related to SSIS/SSAS/SSRS.
  • Involved in creating maintenance plans for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application based on standard process.
  • Responsible for fine tuning of the databases, troubleshooting, user administration and resource management on SQL Server instances.
  • Implemented best SQL Server practices on existing SQL Server services to make the SQL Server database perform efficiently.
  • Suggested best practices for servers and hardware RAID configuration solutions for Enterprise Solutions.
  • Worked on Performance Tuning and Optimization, wif strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located at different sites.
  • Working wif Internal/External Auditors on Audit Requirements/Regulations and making sure dat we are SOX Compliant.
  • Involved in Change Control Management, it is the discipline of systematically identifying and controlling production change migrations and deployments.
  • Managed SQL Server security and recommended best practices to the team as needed.
  • Took the lead in many occasions to Analyze/Fix Performance Issues of Applications.
  • Documenting SQL Server Best Practices for our environment and LOB specifics for Supporting SQL Servers.

Environment: Windows Server 2003/2008/2008 R2, SSMS, Enterprise Manager, MS-SQL Server 2005/2008/2008 R2, SQL Server Upgrade Advisor, Red Gate SQL Tool-Belt, .NET Framework, Visual Studio, SCOM monitoring tool, SQL Sentry Power Suite/Plan Explorer, SSIS/DTS and SSRS, VMware machines, Data Tools, Query Analyzer, Idera Diagnostics manager, Dell LiteSpeed, Confio Ignite, MAP, Apex, Idera SQL Secure, SharePoint, VMware VCenter, SQLIO, WinDirStat, BMC Remedy, Database Tuning Advisor, SQL profiler.

Hire Now