Resume

Sign in

Sql Server database Administration

Location:
Bowie, MD
Posted:
October 25, 2018

Contact this candidate

Resume:

Objectives

A position as MS SQL server Database Developer and Database Administrator (DBA) that would enable me to release all the experience I have had in database Implementation and Administration.

Summary

6+ years of experience in Relational Database Administration (RDBMS), Design Development and Support of MS SQL Server 2014/2012/2008R2/2008/2005 in Production, Test, Development and Cluster Server Environments.

6+ years of Experience in MS SQL Server Installation, Configuration, Upgrading of Microsoft® SQL Server 2014/2012/2008R2/2008/2005.

4-year Experience in Developing SQL Server 2012,2014 Integration Services (SSIS) packages, stored procedures, tables, views, scripts, etc., for processing data.

Extensive experience of performing all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO),

Developed SQL Server 2012,2014 Integration Services (SSIS) packages

Developed stored procedures, tables, views, scripts, etc., for processing data.

Experienced in using DMV and dynamic management functions for finding out long running queries.

Expert in Database Administration on Production Servers performance tuning and maintenance with great troubleshooting capabilities.

Experience in T-SQL Programming in writing Stored Procedures, Functions and Triggers.

4+ years extensive use of Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Agent Services (SSAS), SQL Server Reporting Services (SSRS).

Excellent interpersonal, teamwork, presentation, analytical and communication skills

Provide 24/7 technical support and monitoring.

Professional Experience

Distributed Information Technologies, Inc. Oct 2017 – June 2018

Position: Database Developer and Administrator

DIT is known business that provides world-class IT consulting and developmental and operational services. I was Responsible for designing, implementing and documenting IT solutions in a fast-paced, quick-turn production environment.

Responsibilities:

Develop and manage Business intelligence solutions using SSIS, SSAS and SSRS.

Developed SQL Server 2012,2014 Integration Services (SSIS) packages

Developed stored procedures, tables, views, scripts, etc., for processing data.

Worked on reports using data warehouse projects,

Administered, maintained security, and performed backups and recovery

Created SSIS packages for data migration, and Schedule Database Maintenance job,

Used statistical techniques for hypothesis testing to validate data and interpretations,

Presented findings and data to team to improve strategies and operations,

Proposed solutions to improve system efficiencies and reduce total expenses,

Utilized SSIS and SSAS to import and analyze data,

Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis,

Conducted reports for implementation of marketing strategies.

Distributed Information Technologies, Inc. Nov.2016-October 2017

Position: MS SQL Server Database Administrator

The main purpose of this position is to administer Microsoft SQL Servers, which include implementation, performance tuning, ongoing maintenance, backup/ recovery, security, auditing, production support, migration, and providing On-Call support.

Responsibilities were:

Installation of SQL Server 2014/2012/Enterprise Edition with latest Service Pack in different environment;

Provided daily operational activities such as backups/restores, application troubleshooting, log monitoring, moves and changes;

Administered SQL Server security as needed to applications’ programmers;

Assisted in Developing and maintaining technical specifications, standards, procedures, and techniques for collecting, processing, storing, and distributing data;

Assisted in Developing and maintaining processes that optimize databases and queries to ensure response times are kept to a minimum;

Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Requirements Using T-SQL;

Implemented Always on clustering, Replication (Transactional and Snapshot) and Log shipping;

Assisted in troubleshooting and technical system support for the database group when required, including the monitoring and reporting of group activities;

Recommended hardware configurations as they pertain to database performance and high availability;

Created SQL Server Integration Systems (SSIS) Packages that push data to SQL server databases from Flat Files, Excel File and SQL databases, Using Tableau;

Maintain indexes, rebuild and re-organize periodically to improve the performance;

Worked closely with other IT groups to coordinate current and future plans and activities including coordination and technical assistance to facilitate specific development projects that involve the computing environment, the coordination of software upgrades and the installation of new products;

Acquired ability to analyze SQL database objects including indexes, stored procedures, and views for optimization purposes;

Index rebuild and reorganize;

Cleaned up over indexing;

Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail;

Managed 1.2 TB + Database.

Participated in the on-call production support rotation and may occasionally be required to do work at the office during non-business or late night hours;

Obtained ability to provide assistance under pressure;

Supported production environment 24X7.

Environment: MS SQL server 2014/2012/2008/2005, Windows 2012/2008 Servers, SSIS, SSRS, SQL profiler.

ReEcoSan International PLC July. 2013 - July.2016

Position: MS SQL Server Database Developer and Administrator

This company is working within the Waste Management and Refabricated material Production industry. The RDBMS of this company provides a centralized view of data that can be accessed by multiple users.

My Responsibilities were:

Installed and configured MS SQL Server 2005.

Created New Databases and accomplished maintenance of existing User Databases and System Databases.

Performed Backup and recovery and Automation of Backup.

Received responsibility for Designing and implementing the backup strategy required as per the requirement.

Managed security tasks like granting and revoking permissions.

Re-organize and Rebuild clustered Indexes as part of performance enhancement.

Performance and Fine Tuning of Stored Procedures and SQL Queries and User Defined Functions

Performed Data Transfer/Migration using Export/Import and SSIS.

Achieved reorganization of existing databases to standardize the placement of various databases related files.

Created user logins and adding users to respective databases.

Accomplished Performance Monitor for monitoring memory, processor, Disk I/O and user connections and fine-tuning.

Generated MIS Reports using SSAS and SSRS

Environment: MS-SQL Server 2005

Chemical Industry Corporation Ethiopia, (CIC) Nov. 2010- May.2013

Position: MS SQL Server Database Administrator (DBA) and Data Analyst

The Corporation is managing state owned chemical manufacturing enterprises including three companies. The Relational Database system of this company provides support to the company’s key processes.

My Responsibilities were:

Installed and Configured new SQL Server 2005 Database Server instances,

Prepared Backup strategy and perform Full, Differential and Transaction Log Backups and restore them whenever necessary.

Performed Regular Monitoring of SQL server.

Upgraded SQL server 2005 to SQL server 2008 in production.

Installing and configuring new SQL Server 2008 Database Server instances.

Resolved various performance issues and running DBCC commands, SQL Tracer, SQL Profiler.

Administered the MS SQL Server security by Creating User Logins with appropriate roles, dropping and locking the logins,

Monitored the user accounts, creation of groups, granting the privileges to users and groups.

Performed creating users and assigning permissions using Windows and SQL Authentication.

Implemented SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) for Development, Testing and Production Environment.

Examined maintenance and Correction of Transact SQL (T-SQL) Statements.

Implemented SQL server high availability tools like Log shipping and SQL Server mirroring to minimize downtime.

Carried out Troubleshooting SQL Server Problems related to SQL Server service, Concurrency (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution.

Rebuild clustered and non-clustered Indexes as part of performance tuning.

Managed 500 GB + Database.

Environment: MS-SQL Server 2005, MS-SQL Server 2008, MS-Project

APPSCO April, 2003 – July, 2009

Position: Sales Officer

My Responsibilities were:

Ensured that the company's products are sold competitively;

Responded quickly to sales orders and makes every effort to satisfy customer needs;

Plans and coordinates the sales and distribution activities;

Forecasted sales based on market survey and past sales pattern of the company;

Increased annual sales by 33 percent within first year;

Significantly enhanced annual revenue by establishing and growing various new client relationships;

Ensures that products are sold according to prices set by the company’s policies and procedures;

Ensures that sales revenues are transmitted to the Finance Department on time;

Handles problems and complaints (dissatisfactions) raised by customers;

Makes sure that the sales activities of the company are being performed as per the orders, specifications and standards of customers;

Gathers customers' ideas, comments, suggestions, etc on the product and the sales performance of the company;

Meeting the new target customers and converting them into customers;

Ensures that packaging and delivery of the different products are performed as per the needs of the customers;

Prepares periodic reports on sales activities;

Improves product marketability and profitability by researching, identifying, and capitalizing on market opportunities; improving product packaging; coordinating new product development;

Sustains rapport with key accounts by making periodic visits; exploring specific needs; anticipating new opportunities;

Provides information by collecting, analyzing, and summarizing data and trends;

References Available upon Request

Certification

Administering Microsoft SQL Server 2012/2014 Databases

Education

Bachelor Degree in Management Information Systems from Unity University.

Bachelor Degree in Plant Science from Alemaya University.

Masters Degree in Business Administration from LINCOLN University.

Technical Skills

Languages: Java, C#, T-SQL, VB-Script

RDBMS: MS SQL Server 2000, 2005, 2008, 2012, 2014, MS-Access 2003/2007

Front End: MS Visual Basic, Developer 2000

Reporting Tools: MS Power BI, Tableau

Server Operating Systems: Windows 2000, Windows 2003

Web Servers: Apache Server.

Packages: Microsoft Office, MS Visio 2003, MS-Project

Hardware: HP, Compaq, Dell, Cisco routers.



Contact this candidate