Post Job Free

Resume

Sign in

Sql Server Manager

Location:
Greenbelt, MD, 20770
Posted:
October 27, 2018

Contact this candidate

Resume:

Daniel K. Musa

**** *********** **. *********, ** 20770

Phone: 240-***-**** Email: ac7ivz@r.postjobfree.com _

Open to Relocation and Work from Home

EMPLOYMENT

UPS SQL Database Administrator 2017-Present

Job Experience:

Extensive experience on both SQL Server Administration and T-SQL Application Development Knowledge of Normalization/ Demoralization techniques for OLTP and OLAP environments.

Used SQL Indexes for improving query performance, lower storage and maintenance cost.

Experience in optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) And Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Hands-on working experience in Installing, configuring, upgrading and managing SQL Server 2008/2012 and upgrading Service Packs for multiple instances.

Valuable experience in user management for DBs, maintaining of databases, and providing SQL

Server security by assigning logins, server and database roles and server permissions.

Participated in Disaster prevention and Recovery Strategies and supported High availability features like Snapshot Replication, Clustering (Active/Passive) and Database Mirroring.

Experience in Log Shipping from Primary to Standby servers and SQL maintenance plans. Experience involved in using tools like SQL profiler for Monitoring and Tuning MS SQL Server.

Proficient in developing business application logic using SQL Stored Procedures and Functions.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2008/2008R2, SQL Server 2012, SQL Server 2014.

Experience in Disaster Recovery Planning, Execution and Testing at remote site.

Experience in using SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

Solid experience on High availability (Always-On) SQL Server solutions, including Replication Models (Snapshot/Transactional).

Expert in setting up maintenance plans, creating jobs, database.

Expert in E.T.L TOOLS (S.S.I.S, B.C.P, Import & Export Wizard).

Expert in S.S.R.S PROFESSIONAL EXPERIENCE Workplace (UPS) Duration SQL DBA

Microsoft SQL Server DBA with 5+ years of experience in design, Development and Administration using MS SQL Server 2008, 2012 database environments.

DHL Express: SQL Database Administrator 2012-2017

Job Experience

T-SQL queries and maintained code repository in Visual Source Safe (VSS) for deployments.

Created and maintained SQL objects like Tables, Constraints, User defined Functions, Indexes.

Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications.

Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL

Server agent and monitoring and troubleshooting jobs, event notifications using Database Mail.

Developed Tabular Reports, Matrix Report, and Charts using SSRS and deployed to Report Server.

Extraction, Transformation and Loading (ETL Tools) data using DTS/SSIS Import/Export utility (Another Workplace) Duration Responsibilities.

Experience in restoring full back, transaction and differential log back-up and to bring online.

Experience in exporting file from one database the other.

References will be provided upon request



Contact this candidate