SEARCH

MSSQL Server Production DBA Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
MSSQL SERVER PRODUCTION DBA
Experience
MSSQL Server Production DBA
May 2016 to CurrentCompany Name － City, State
  • 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 fix 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, Windows2003/2008/2012, DTS/SSIS, SSRS, Visio, Lite speed, SQL Diagrams, Index tuning wizard, SQL Profiler, Query Analyzer, HPSM, PowerShell.
SQL Server Production DBA
April 2015 to April 2016Company Name － City, State
  • Roles and responsibilities Installed, configured, administered and secured SQL server 2005, 20008R2, 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/2008r2, 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
January 2013 to February 2015Company Name
  • Roles and responsibilities Installed and configured SQL Server 2008 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 R2/2008/2005, T-SQL, MS SQL Server Integrated Services (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2008/2003 server, Visual Studio, and.Net Framework.
Education
Bachelor's degree : Electrical Engineering, July 2012Addis Ababa UniversityElectrical Engineering
Summary
Seeking a position with a company that will allow me the opportunity to expand my knowledge and experience in the area of SQL Server and becomes an entrusted professional in an organization that is technology oriented and encourages innovative thinking by delivering the best quality services emanating from my creative ability, knowledge, and experience. 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 and Applying Service packs, patches, hotfixes and cumulative updates. Installing and Configuring SSIS, SSRS and SSAS Servers 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 2012R2 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
Skills
MCSA: Administering Microsoft SQL Server 2012/14 Databases
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • Addis Ababa University

Job Titles Held:

  • MSSQL Server Production DBA
  • SQL Server Production DBA
  • SQL Server DBA

Degrees

  • Bachelor's degree : Electrical Engineering , July 2012

Similar Resumes

View All
MID-SQL-SERVER-DBA-resume-sample

MID SQL SERVER DBA

Atlanta, Georgia