Sql Server Manager
Resume:
Selamawit (Mawit) T. Teshome
SQL Database Administrator (DBA)
Tel: 240-***-****, Email: ************@*****.***
Summary of qualifications:
7+ years in-depth experience in managing multiple MS SQL Server 2000/2005/2008/ 2008R2/ 2012/2014 servers with very large OLTP Databases in development, testing/QA and production environments while ensuring their performance, high availability and internal/external security.
Logical and physical planning of relational databases; manage internal databases from planning and testing stages through implementation and support.
Hands on experience in Installation, Configuration and Migration of SQL Server 2014/2012/2008 R2/2005/2000, apply periodic service packs, hot fixes, cumulative updates, and complimentary third party tools.
Experience extracting data from Oracle using ETL.
Experience working on SQL DBMS Database Managements System and Relational databases.
Experience in configuring logical drives/array and their RAID level using HP array configuration utility.
Experience with database maintenance, management and performance monitoring third party tools including Idera and Redgate.
Expertise in creating database objects and structures including databases, tables, indexes, views, snapshots, stored procedures, triggers, functions, synonyms and cursors.
Experience in developing complex TSQL scripts and stored procedures to perform administrative tasks and multiple DDL, DML, and DCL activities to carry out business requirements.
Extensive experience in performance tuning / analysis, troubleshooting and query optimization using native tools like MSSQL server profiler, activity monitor, performance monitor, event viewer, index tuning advisor, database tuning advisor (DTA), Dynamic Management views (DMV),services and protocols, and configuration manager.
Experience in using dynamic management views (DMV) and dynamic management functions (DMF), TSQL scripts, Triggers, and Store Procedure for troubleshooting and performance tuning that include finding out long running queries and query costs.
In-depth understanding of user management and database security at different levels to ensure database integrity and secure databases from unauthorized intrusions and data corruption.
Extensive experience in designing, implementing and maintaining high availability and disaster recovery plans including: back-up and restore, log shipping, replication (transactional/merge), database mirroring, failover clustering and Always-on availability group.
Expertise in automating maintenance jobs in SQL server job agent and task scheduler: such as Shrinking database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, updating statistics and full/differential/transactional log backups and other SSIS package tasks.
Extensive experience in using Version control system tools for deploying scripts and packages.
Experience in Extract, Transform and Load (ETL) data from heterogeneous data sources like Oracle, MS Access, and DB2 using MS SQL Integration Service (SSIS), DTS, BCP and Bulk insert.
Experienced in creating, managing and delivering server based reports with interactive views that provide valuable insight for strategic decision making: using MS SQL Reporting service (SSRS).
Experience with MS SQL server Analysis Services (SSAS).
Experience scripting Windows Batch and PowerShell.
Experience migrating mainframe DB2 tables to SQL server.
Configuration and Administration of SharePoint Server 2007/2010/2013 farms.
Excellent communication, coordination, presentation and analytical skills; worked on 24X7 Production support, involved in an on call rotation.
Technical skills summary:
Relational DBMS: Microsoft SQL Server 7.0/2000/2005/2008/2008R2/2012/2014, MySQL, Microsoft Access.
Server Operating Systems: Windows Server 2003/2008/2008R2/2012/2012R2.
Database Programming: T-SQL, PL/SQL.
Programming: HTML, JDBC, XML, VB.NET, ASAP.NET.
Database modeling: VISIO 2003/2010/2013, Toad Data modeler, ERWIN.
ETL tools: Data transformation services [DTS], MS SQL Server integration services [SSIS].
Reporting: SAP Crystal report, SQL Reporting Service [SSRS].
Third party tools: Symantec, Red Gate, Idera SQL Safe, Idera Diagnostic Manager,
SQL compliance manager, SQL Safe Backup.
Applications: IIS, Visual Studio, FTP, Adobe Photoshop suite, Dreamweaver, Oracle CRMOD/CCOD, JIRA, Guardian RX (Care Point, POS), SharePoint.
Networking: SAN, NAS, LAN, WAN.
Professional Experience:
SQL Server Database Administrator (DBA)/Developer
WABCO Vehicle Control Systems: September 18, 2017 to date
R H Sheppard Co Inc : April 2017 to September 18, 2017
Responsibilities:
Managed over 40 SQL servers and more than 250 OLTP and OLAP databases used by different applications.
Provides SQL Server Database Administration and monitoring support across production, development and staging environments.
Responsible for SQL server logical and physical database design, implementation, and maintenance.
Installed and configured SQL server 2005/2008/2008R2/2012 and apply periodic service packs and hot fixes (cumulative updates) for Dev, Staging and Prod environments.
Experience working on SQL DBMS Database Managements System and Relational databases.
Designed databases and apply normalization to minimize data redundancy.
Managed SQL Server security by granting appropriate server and databases roles/permissions and by having frequent security checks for inappropriate access.
Manage users and groups (roles) from Active directory and SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.
Deployed, managed, and operated scalable, highly available, and fault tolerant systems on AWS and Azure.
Implemented and controlled the flow of data to and from AWS and Azure
Migrated an existing on-premises application to AWS and Azure.
Perform daily checkups on SQL jobs, replication, and hardware diagnostics for hard drives, backups, and disk-space, SQL and windows error logs as part of proactive maintenance plan.
Develop TSQL scripts to create database objects and perform DML and DDL tasks.
Create Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers, Cursors and Dynamic SQL queries.
Scheduling and automating maintenance plans using SQL Server job agent.
Design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures.
Set up and manage log shipping, Mirroring (Synchronous/Asynchronous), Fail over clustering and Transactional replication as part of disaster recovery plan and load balancing strategy.
Extensively used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/analysis and troubleshooting.
Performance tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), Statistics, partitions, Client/Server Connectivity and structure modification.
Analyzing Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.
Analyze and deploy scripts and packages in prod/test environments provided by developers and vendors.
Auditing of database Guardian RX application vendor based on CR/change request process and in compliance with HIPAA.
Implement database refresh for logins, user’s transactions, and resolving orphan users.
Configured SMTP Server for Database Mail setup, notifications, and received Alerts.
Installation, Configuration and Administration of SharePoint Server 2007/2010/2013 farms.
Data Migration to and from various sources using SQL Server Integration Services (SSIS).
Experience migrating mainframe DB2 tables to SQL server using ETL.
Developed automated procedures to produce client data files on schedule using Microsoft Integration Services (SSIS) packages.
Develop reports using SQL Server Reporting Services (SSRS).
Identify, recommend, and implement new database administration technologies.
Worked with a team of ETL developers, application developers, network engineers, server administrators, system analysts and testers.
Environment: Windows 2003, Windows 2008/R2, Windows 2012, SQL Server 2000, SQL Server 2005, SQL Server 2008/R2, SQL Server 2012, SQL Server 2014, Redgate SQL backup Pro, Idera Diagnostic Manager, JIRA ticketing tool, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint
Professional Experience:
SQL Server Database Administrator (DBA)
Cystic Fibrosis Foundation (CFF): August 2014 to March 2017
Responsibilities:
Responsible for SQL server logical and physical database design, implementation, and maintenance.
Installed and configured SQL server 2005/2008/2008R2/2012 and apply periodic service packs and hot fixes (cumulative updates) for Dev, Staging and Prod environments.
Managed over 70 SQL servers and more than 300 OLTP and OLAP databases used by different applications.
Provides SQL Server Database Administration and monitoring support across production, development and staging environments.
Designed databases and apply normalization to minimize data redundancy.
Managed SQL Server security by granting appropriate server and databases roles/permissions and by having frequent security checks for inappropriate access.
Manage users and groups (roles) from Active directory and SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.
Deployed, managed, and operated scalable, highly available, and fault tolerant systems on AWS and Azure.
Implemented and controlled the flow of data to and from AWS and Azure
Migrated an existing on-premises application to AWS and Azure.
Perform daily checkups on SQL jobs, replication, and hardware diagnostics for hard drives, backups, and disk-space, SQL and windows error logs as part of proactive maintenance plan.
Develop TSQL scripts to create database objects and perform DML and DDL tasks.
Create Databases, Tables, Indexes, Stored Procedures, Views, database management policies and Constraints, Defaults, Rules, Functions, Triggers, Cursors and Dynamic SQL queries.
Scheduling and automating maintenance plans using SQL Server job agent.
Design, implement and manage database maintenance and disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures.
Set up and manage log shipping, Mirroring (Synchronous/Asynchronous), Fail over clustering and Transactional replication as part of disaster recovery plan and load balancing strategy.
Extensively used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/analysis and troubleshooting.
Performance tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), Statistics, partitions, Client/Server Connectivity and structure modification.
Analyzing Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.
Analyze and deploy scripts and packages in prod/test environments provided by developers and vendors.
Auditing of database Guardian RX application vendor based on CR/change request process and in compliance with HIPAA.
Implement database refresh for logins, user’s transactions, and resolving orphan users.
Configured SMTP Server for Database Mail setup, notifications, and received Alerts.
Installation, Configuration and Administration of SharePoint Server 2007/2010/2013 farms.
Data Migration to and from various sources using SQL Server Integration Services (SSIS).
Experience migrating mainframe DB2 tables to SQL server using ETL.
Developed automated procedures to produce client data files on schedule using Microsoft Integration Services (SSIS) packages.
Develop reports using SQL Server Reporting Services (SSRS).
Identify, recommend, and implement new database administration technologies.
Worked with a team of ETL developers, application developers, network engineers, server administrators, system analysts and testers.
Strong experience in mentoring with team members, documentation and 24/7 on call production support.
Environment: Windows 2003, Windows 2008/R2, Windows 2012, SQL Server 2000, SQL Server 2005, SQL Server 2008/R2, SQL Server 2012, SQL Server 2014, Redgate SQL backup Pro, Idera Diagnostic Manager, JIRA ticketing tool, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint
SQL Server Database Administrator
Convenience, Value, and Service (CVS): June 2012 to August 2014
Responsibilities:
Responsible for SQL server logical and physical database design, implementation, and maintenance.
Create new databases, manage database security, enroll and map users.
Creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors, Temp tables and Dynamic SQL queries.
Experience in Normalization, Database design, Performance Analysis and Production Support.
Scheduling and automating maintenance plans using SQL Server job agent.
Design, implement and manage database maintenance and disaster recovery plans including full/differential /transactional backup and recovery procedures.
Set up and manage log shipping, SQL server Mirroring (Synchronous/ Asynchronous), Fail over clustering and transactional replication.
Strong Experience in Performance Tuning including Updating Statistics, Re-Indexing Query Optimization, Client/Server Connectivity and structure modification.
Extensively used the native tools like Index tuning wizard, Database tuning advisor, SQL profiler, Performance monitor, Activity monitor, Event viewer for performance analysis.
Implement database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
Experience in analyzing Locks, Dead Locks and handling the Isolation Level and Concurrency Effects.
Analyzing execution plans and index management for better Query Optimization.
Configured SMTP Server for Database Mail setup and received Alerts.
Auditing of database for users transaction, login and database action and removing orphan users.
Upgrading and downgrading SQL server instances.
Develop reports using SQL Server Reporting Services (SSRS).
Data Migration to and from various sources using SQL Server Integration Services (SSIS).
Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
Strong experience in mentoring with team members, documentation and 24/7 on call production support.
Environment: Windows 2003, Windows 2008, SQL Server 2005, SQL Server 2008, SQL Server 2012, Redgate SQL backup Pro, Idera Diagnostic Manager, ITSM ticketing tool, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint.
SQL Server Database Administrator
A&G Management Company, February 2010 – May 2012
Responsibilities:
Installing, configuring, administering and securing development, test, and production servers.
Create and optimize database objects, e.g. Tables, Views, indexes, cursors, stored procedures, functions, CLR code and Triggers.
Implement data models, database designs, data access and table maintenance codes.
Administer, maintain, develop and implement policies and procedures for ensuring security and integrity.
Enrolling and mapping users following company policies and procedures.
Created roles and grant permissions to users upon proper approval from business.
Scheduling and automating full/differential/ transactional backups and implementing recovery strategies.
Configured and monitored database replication as high availability and disaster recovery strategy.
Supported disaster recovery project planning, testing and implementation.
Setup and managed Transactional Replication databases and make sure the latency is current.
Upgrading the SQL Server Databases, Monitoring and Performances tuning.
Performed migration of databases from SQL 2000/2005 to SQL 2008 after careful analysis of Upgrade Advisor reports.
Developed reports using SSRS, Crystal Reports with T-SQL, MS Excel and Access.
Developed automated procedures to produce client data files on schedule using Microsoft Integration Services (SSIS).
Supported change projects where database objects are designed, reviewed and created as per change requirement and ER Diagrams produced using Erwin tool.
Proactively checked the SQL Error log and take appropriate action to avoid downtime.
Assisting development teams with data cleansing, migration and loading in addition to assisting and supporting development teams with reviewing, building, testing and maintaining database structures and SQL scripts.
Managed space on database servers by proactively forecasting the DB growth.
Imported/Exported data as per user request using import export wizard and BCP.
Environment: Windows 2000, Windows 2003, Windows 2008, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008R2, Webstar ticketing tool, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint
Certification:
Microsoft Certified IT Professional (MCITP) : SQL Database Administrator
Microsoft Certified IT Professional (MCITP): SQL Database Developer
Microsoft Certified Database Administrator (MCDBA) – Implementation and Maintenance.
Awards:
Dr. Harry Harden, Student Academic Excellence Award 2013 and 2014.
Phi Theta Kappa Honor Society Award 2013.
Education:
Degree in Business Administration (Secretarial Science and Office Management), Unity University, Addis Ababa, Ethiopia.
Associate Degree in Art, Montgomery College, Takoma
Contact this candidate