SQL Server DBA

Mary Belay

Email adk5ix@r.postjobfree.com

Phone 301-***-****

Rockville,MD

Professional Summary

Seeking new opportunity due to Covid-19 related layoff.

Over 7 year experience in Administering and Managing of MS SQL Server Databases in Production and non-Production environments. Dedicated, Problem solver handled multiple projects, excellent team player and has the ability to work in stressful environment under minimal or no supervision.

Managed Installation, Upgrade, Configuration and Administration of MS SQL Servers 2014 in Standalone and Clustered environments.

Streamlined Server/Database level Security and utilized SQL Server Auditing and Data Encryption.

Performed SQL server Upgrade/Patching and done Migration from MS SQL Server 2008 to 2016.

Experience working on relational database applications including online databases

Set up and executed Database Maintenance Plans, Scheduled and Automated SQL Server Jobs, Configured Database mail, Created Alerts, Operators and Notifications.

Administered SQL Server High Availability and Disaster Recovery strategies including Mirroring, Log shipping, Replication, Clustering and Always on Availability Group.

Troubleshoot and Resolved SQL Server and Database related problems including but not limited to Application, CPU, Memory, I/O and Disk space.

Implemented MS SQL Server Performance Tuning and Monitoring tools like Database Engine Tuning Advisor, SQL Server Profiler, Activity Monitor, Windows Performance monitor, DBCC, Store Procedures, and DMVs.

Conducted Root Cause Analysis and used SQL Server Profiler, DMVs and Error Logs for Troubleshooting.

Installed and Configured SSIS, SSRS and SSAS.

Successful Completion of Microsoft Certification (70-432,70-450,70-461,70-462 & 70-463)

Established Remote MS SQL Servers as Linked Servers for fetching data.

Provided a 24x7 dedicated support for users in Production, Development and Testing servers and Responded on Tickets based on Requirements.

Created and Managed Databases, SQL joins, views, triggers, sub queries, Tables, Indexes, Views, trigger and Store procedures.

Articulated a very good Communication and Interpersonal Skills, Improved helping Mentality with an Excellent team Sprit.

Business Skills / Technical Skills:

MS SQL server 2008/2012/2014/2016 MS SQL server Integration Service 2012, SQL server analysis Services 2012, SQL server reporting services 2012,MS Microsoft Access, OLAP and OLTP, Outlook, MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, Visual Basic 6.0, T-SQL, Visual Studio, SQL Server Management Studio, Microsoft Office, SSDT, Idera, Redgate, Customer Relation Management, Windows XP/Vista/7/8/10

Education

Bachelor Degree in computer science Ethiopia

Professional Experience

Client: Centene Corporation Chesterfield, MO Mar 2018- Sep 2020

Role: Senior SQL Server DBA

Responsibilities:

Providing 24 / 7 Production support as an On-Call Production support DBA for all SQL Servers Instances

Knowledge of using Ticketing system software Jira issue tracking and Service now ticketing System to proper track and escalation issues in the multiple environments

Maintained the data, database backups and restoration, backup strategies, scheduled backups.

Involved in complete backing up of Database and restored the database from Disaster Recovery.

Check the SQL Server for any dependent objects (SQL Agent Jobs and Linked Servers)

Check, if the database is part of any maintenance plan

Solid understanding of complete SDLC And Agile methodologies

Flexibility and adaptability outside the assigned service area

Passion for learning new technologies and learning on the fly

Install SQL Server 2017,2016,2014,2012

Knowledge of 3rd party DBA tools and applications ( fog light, SCCM,TSM )

Knowledge in a scripting language like Power Shell

Centene Backup report and HNT backup failures

Different kind tickets ( REQ,INC,ITASKS, CHANGE TASKS )

Perform activities associated with database monitoring,management of database, database backups and restores, index maintenance, integrity checks, account management, performance monitoring, SQL patching, security configuration and investigations related to database-related failures

Client: Vidoori Silver Spring, MD Feb 2015 – Feb 2018

Role: MS SQL/ ETL/SSIS/SSRS Developer

Responsibilities:

Scheduled SSIS packages for running monthly/weekly/daily feeds from and to various vendors using SQL server Agent.

Reports weekly to the manager of reporting and analytics using the prescribed report format or other agreed upon format.

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations

Strong experience working in an Agile development environment

Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers

Works with the development and database teams to implement the reports in client/server and web applications for both internal product development and external consulting projects.

Extracted data from heterogeneous sources and transformed, processed the data using SSIS.

Client: Wipro Nashville, TN Nov 2013 - Feb 2015

Role: SQL Server DBA

Responsibilities

Working with large databases, troubleshooting issues and documenting the causes, on MS SQL Server database administration, include configuring Scheduled Tasks, Jobs for regular Database Backup and Maintenance Activities.

Provided 24 X 7 dedicated supports for Development, testing and Production MS SQL Servers.

Implemented Migration and Upgrade on MS SQL Servers 2005/2008R2/2012/2014 and applied service packs.

Created an implementation document for the step-by-step Migration of SQL server data to the new instance.

Involved in development of automated daily, weekly and monthly SQL server agent jobs, Database backup, Integrity checks, Indexing Maintenance and Update statistics.

Administered SQL Server/Database level Security and utilized Auditing and Data Encryption according to requirements.

Managed SQL server high availability and disaster recovery strategies including Mirroring, Log shipping, Clustering and Always on availability groups.

Installed, Configured and deployed SSIS, SSRS and SSAS.

Implemented SSIS Import/Export tool and migrated heterogeneous data from access, flat files, excel in to SQL server database and vice versa.

Deployed periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Monitored and Troubleshoot Server performance and database activities of particular users using SQL Profiler, Performance Monitor, Extended Event, Trace flags, Activity Monitors, Store Procedures, DBCC, and DMVs.

Fine tune slow running T-SQL queries using Execution Plan and Database engine tuning advisor.

Client: HUD, Washington DC Jul 2012 – Oct 2013

Role: Jr SQL DBA

Responsibilities

Assist Installed, Configured, and Managed SQL Server 2008 & 2008r2 in development, test, and production environment

Run database queries using SQL

Migrate data from old systems to new system.

Collect the information of dependent applications, make sure application services will be stopped during the database migration

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard

Maintained the data, database backups and restoration, backup strategies, scheduled backups.

Involved in testing, bug fixing and documentation for the project.

Job Monitoring and making sure all jobs run successfully every night.

References will be provided upon request.

Contact this candidate