We provide IT Staff Augmentation Services!

Mssql Server Dba Resume

Laurel, MD

SUMMARY:

  • interested in a position that aligns with my knowledge and experience in Microsoft SQL Server production. As a Microsoft certified DBA, I have an extensive experience in backup, recovery, maintenance, automation, high availability and disaster recovery along with performance tuning and query optimization skills. I opt for an environment that promote and value interpersonal skills, lifelong learning, innovation and analytical skills.
  • Microsoft certified Professional in SQL Server administration with more than 5 years of proven experience in providing 24/7 support on production and non - production environments.
  • Excellent understanding of conceptual, logical and physical database modeling and software development life cycle(SDLC)
  • Strong understanding of the database development life cycle including data modeling, database coding, testing, and implementation
  • Provisioning an Azure SQL Server and SQL Azure database through Azure web portal and Azure Powershell
  • Configuring server level and database level firewall rules to connect to secure SQL Azure server
  • Setting up Active Geo-Replication using Azure web portal and Powershell
  • Database administration on Production and non-production MSSQL Servers with server configuration, performance tuning, and maintenance with troubleshooting capabilities.
  • Installing and configuring SQL Server on standalone and clustered environments, SSIS, SSRS and SSAS and Applying Service packs, patches, hotfixes and cumulative updates.
  • Excellent understanding of SQL Server architecture and Database storage structure
  • Have experience with Normalization (1NF, 2NF, and 3NF) techniques for improved database performance in OLTP environments.
  • Worked in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency
  • Experience in implementing Business logic by using T-SQL statements like stored procedures, triggers, and user-defined functions (UDF).
  • Working on Virtualization technologies like VMware, Virtual Box, and Hyper -V
  • Migration of databases Side-by-side and in place upgrade from old version to newer version and from one edition to another edition
  • Experience in analyzing Performance, Query optimization and tuning, creating Indexes and re-written stored procedures
  • Worked with system administrators and developers to migrate databases from SQL Server 2008 to SQL Server 2012 and SQL Server 2016
  • Identified the I/O and memory bottlenecks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans
  • Solid experience and outstanding knowledge on High availability (HA) and Disaster recovery (DR) solutions like log shipping, Mirroring(HIGH safety and High performance), Replication(Snapshot & Transactional), Clustering and Always on
  • Designing and implementing database Backups including Full, Differential & Transactional log and restoring databases based on the company’s RPO and RTO
  • Excellent knowledge of point-in-time recovery of databases
  • Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL agent and monitoring and troubleshooting Job Failures
  • Owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs.
  • Responding to database related alerts and escalations and working with engineers
  • Experience in Managing Windows server, Active Directory and SAN disk configurations
  • Experience in Creating and deploying SSRS reports
  • Rebuilding databases including user and system databases at the time of server crash and bringing back the server to online state
  • Experience in Data Extraction, Transforming and Loading (ETL) packages and deploying on a production server
  • Experience in supporting production environment 24/7

PROFESSIONAL EXPERIENCE:

MSSQL Server DBA

Confidential, Laurel, MD

Roles & Responsibilities:

  • Responding to developer issues and guiding them to write performing T-SQL codes.
  • Worked on Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to multiple Terabytes.
  • Developed and created new database objects including tables, views, index, stored procedures and functions, Subqueries, Joins, UNIONS and also updated statistics
  • Created Entity-Relationship diagrams and flow diagrams using Visio and documenting
  • Created maintenance plans to automate updating statistics, reorganizing and rebuilding Indexes and check the consistency of databases
  • Addressed SQL Server security issues by creating user logins with the principle of least privilege and monitoring those user accounts regularly by using SQL Profiler
  • Planned and implemented Database Backup strategy with associated Disaster Recovery procedures according to RPO, RTO, and SLA of the company
  • Used Windows Powershell and different Maintenance plans to automate tasks like updating statistics, reorganizing and rebuilding Indexes and check the consistency of databases
  • Solved Concurrency problems of blocking and deadlocks, by viewing and tracking them using Activity Monitor and Management Studio summary page and Profiler
  • Configured SQL Server Reporting service, developing and publishing reports
  • Worked with developers during Capacity planning, logical and conceptual modeling and ER- diagram development of databases and placement of data
  • Implemented and monitored SQL server high availability and disaster recovery solutions like Log Shipping, Mirroring, Clustering and Always On Availability Group
  • Evaluating CPU, Disk I/O and Memory related bottlenecks, blocking and deadlocks by using activity monitor, SQL logs, SQL Profiler & other tools
  • Installed and Configured SQL Server on virtual like VMware and Virtual server
  • Responding to requested tickets and fixes any database issues.
  • Working with CDC, Data Compression, and TDE
  • Set up baseline workloads using the SQL profiler and database tuning advisor (DTA) which resulted in providing the missing and superfluous indexing on tables.
  • Configured SSRS using configuration manager, created and maintained security roles
  • Responsible for creating and deploying reports based on requirements using SSRS.
  • Used Various SSIS tasks such as Conditional Split, Derived column for Data Scrubbing
  • Used SSDT to extract data from multiple sources (Excel and flat files) and load into SQL Server databases and from SQL Server to Spreadsheets.
  • Deploy SQL scripts in production environments, applying patches, performing code review/optimize SQL for reporting, interfaces and data conversions.
  • Executed Change management scripts on daily/weekly basis

Environment: MSSQLServer2008R2/2012/2014, MSAccess, Azure, Windows 2003/2008/2012, DTS/SSIS, SSRS, Visio, Lite speed, SQL Diagrams, Index tuning wizard, SQL Profiler, Query Analyzer, HPSM, PowerShell

SQL Server Production DBA

Confidential, Louisville,KY

Roles and responsibilities

  • Installed, configured, administered and secured SQL server 2005, 2008R2, 2012/2014 on production and non-production in Clustered and Standalone server environments.
  • Configured and monitored Always On availability group on windows failover cluster
  • Re-synced availability database on all replicas using T- SQL script and manually.
  • Implemented SQL Security and object permissions like creating end users and logins and assigning roles to the users and managing user permissions
  • Identify orphan users in the servers, successfully migrated end users between multiple servers.
  • Developed and approved T-SQL scripts to production SQL server databases
  • Worked on production issues like log space full, blocking and deadlocking
  • Worked in a process based environment, responded to trouble tickets with various severity levels and fix any database issues promptly to meet SLA of the company
  • Implemented Change requests and infrastructure service requests on a regular basis
  • Redesigned and placed the physical files of a tempdb database on their own drives.
  • Reassessed database capacity growth patterns, and set up accounts for the SQL Server to avoid using the SA account.
  • Posting an Incident resolution ticket, perform Root cause analysis and documenting solutions
  • Performed Server buildups and decommissioning on a regular basis
  • Monitored Maintenance plans and jobs to maintain database quality and troubleshooting Job Failures when they occur in the system.
  • Tested Backup and Recovery strategies by simulating various recovery scenarios like loss of data files, Transaction logs, Point in time recovery
  • Worked on data maintenance tasks like Reorganizing and rebuilding indexes
  • Checked database Health and consistency by using DBCC commands and DMVs
  • Created SSIS Packages to Extract, Transform and Load data into Reporting instance to generate the reports easily and quickly

Environment: Windows 2008R2, 2012R2, MS-SQL Server 2016/ 2014/2012/2008 r2, T-SQL, MS SQL Server Integrated Services (SSIS), SQL Server Agent, SSRS, SQL Profiler, Visual Studio, TFS, Service Now and JIRA Ticketing System.

SQL Server DBA

Confidential, Pittsburg, PA

Roles and responsibilities

  • Installed and configured SQL Server 2008R2 on Windows 2003/2008 servers, applied service packs and security fixes in Clustered and Standalone environments.
  • Worked extensively on installation, upgrade and configuration of MS SQL server 2008 and 32/64 bit SQL Server Cluster for SQL 2008
  • Configured Merge and Transaction Replication from production to DR Servers and reporting server with multiple subscribers.
  • Implemented high availability solutions for mission-critical databases with clustering and Always on Availability group
  • Configured Log shipping using SQL Server Management Studio.
  • Created and scheduled maintenance plans for tasks like backups and cleanups
  • Monitored job and alerts, CPU utilization, Data and log file sizes and space availability Verify backups and error logs on the servers and troubleshoot any failures alerts
  • Respond to trouble tickets assigned to me and fix any database issues promptly
  • Tested Backup and Recovery strategies by simulating various recovery scenarios
  • Monitored database quality including database consistency check with DBCC, Defrag, and index tuning and monitored error logs.
  • Created ETL packages with different data sources (SQL Server, Flat Files, and Excel etc) and loaded the data into destination tables by performing different transformations using SSDT.
  • Worked with system administrators to plan and estimate drive capacity and storage
  • Created and modified tables, stored procedures, views, indexes triggers and UDFs
  • Tuned queries and improve performance by using tools like DTA and SQL Server Profiler
  • Created Active Directory Users, Computers, and Organizational Units and assigned NTFS permissions by interacting with system administrator
  • Installed Virtual box and created multiple VMs and installed Windows Server 2008 R2
  • Worked with System administrator for configuring DHCP and Static IP Addresses for different machines

Environment: MS SQL Server 2008/2005, T-SQL, MS SQL Server Integrated Services (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2008/2003 server, Visual Studio, and.Net Framework.

SQL Server DBA

Confidential

Responsibilities:

  • Perform support roles for small projects and key projects
  • Installing and configuring MS SQL Server 2005, 2008, 2008R2 on Windows Server 2003,2008 and 2008R2 in standalone environments
  • Tune and troubleshoot database performance issues
  • Perform maintenance on servers to address security vulnerabilities and patching
  • Setting up Mirroring, replication and log-shipping.
  • Working with senior database administrators to manage multi-server SQL server environments
  • Perform backup, recovery, installation, configuration, upgrade, and migration of SQL servers and databases
  • Provide support in production, test and development environment
  • Troubleshooting server and database connectivity issues
  • Troubleshooting performance issues, security issues, locks and deadlocks
  • Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
  • Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
  • Working with Remedy Tickets (Any changes on staging and development environment need to Create Remedy Tickets)
  • Involved in all ITIL process like Change management, Incident Management & Problem Management.
  • Developed and deployed stored procedures, created triggers and audits.
  • Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
  • Developed automated processes to perform ETL and data validation
  • Extracted and converted data from various sources like excel, flat file, SQL server etc.
  • Performed event-handling, error-handling and debugging
  • Tasked with database backup and restore, managing securities, scheduled jobs, alerts, and database mail
  • Performed database integrity checks using DBCC utilities and maintenance plan configuration wizard
  • Troubleshooted SQL server performance issues using execution plans, SQL profiler, statistics, index-tuning wizard, perfmon
  • Performed database upgrade and migration from SQL server 2005 and 2008 to SQL server 2012 and 2016

Hire Now