Sql Server Maintenance
Resume:
Daniel W. Ebrahim
Professional summary
• *+ years in-depth experience in managing multiple MS SQL Server
****/****/****/**/****/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/2008/2005/2000, apply periodic service packs and hot fixes
(cumulative updates) and complimentary third party tools.
• Experience in configuring logical drives/ array and their RAID level using HP array
configuration utility.
• Experience with database maintenance, management and performance monitoring using
third party tools including Spotlight, IDERA and REDGATE.
• Expertise in creating database objects and structures including databases, tables, indexes,
views, snapshots, stored procedures, triggers, functions 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 Procedures 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.
• 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 and transactional log
backups and other SSIS package tasks.
• Extensive experience in using Version control system tools for deploying scripts and
packages.
• Architects, monitors, and maintains the Microsoft SQL Server Database environments
which support applications.
• Experienced in configuring, maintaining and troubleshooting server-class hardware and
operating systems.
• Experience in Extract, Transform and Load (ETL) data from heterogeneous data Sources
like Oracle, MS Access, and DB2 using MS SQL Integration Services (SSIS), DTS, BCP
and Bulk Insert.
• Experienced in creating, managing and delivering server based reports with interactive
views that provide valuable insight for business heading using MS SQL Reporting
Services (SSRS).
• Experience with MSSQL Server Analysis Services (SSAS).
• Configuration and Administration of SharePoint Server 2007/2010 farms.
• Excellent communication, coordination, presentation and analytical skills; worked on
24X7 Production support, involved in an on call rotation.
• Experience in SQL Server Policy-based Management.
• Experienced in writing, troubleshooting, modifying and enhancing complex PowerShell /
T-SQL scripts.
• Migration from Sybase, Oracle and DB2 to SQL Server.
• Proficient using Microsoft SQL Server, MS SQL Server Management Studio (SSMS),
MS Access, MS Visual Basic, Excel and other applications associated with query and
reporting.
• Advanced proficient in normalizing data received from a wide variety of sources, creating
and executing database queries that organize data in a format suitable for analysis by
auditors.
Skills
• DBMS: MSSQL Server 2000/2005/2008/2008 R2/2012/2014, MYSQL, Oracle, MS-
Access, Sybase, IBM DB2.
• Operating Systems: Windows Server 2003/2008/2008 R2/2012/2012 R2, Windows
/XP/Vista/7/8/8.1, MAC, Linux, Ubuntu.
• Third party tools: Symantec, Redgate, Idera Diagonestic Manager, Idera Frag Manager
Spotlight.
• ETL tools: MS SQL Server integration services /SSIS/, DTS.
• Reporting tools: SAP Crystal Report, MSSQL Server Reporting Services /SSRS/,
PowerPivot.
• Programming Languages: T-SQL, PowerShell, XML, HTML, VB.NET, JDBC, C++,
Java, Objective C, Swift, and C #.
• Applications: IIS, Visual Studio, FTP, Adobe Photoshop suite, Dreamweaver, Oracle
CRMOD/CCOD, JIRA, SharePoint.
• Networking: SAN, NAS, LAN, WAN.
Work History
American University.
SQL Server Database Administrator
Washington DC, DC
December 2014 – Recent
American University (AU or American) is a private, coeducational, liberal arts curriculum,
doctoral and research-based university in Washington, D.C., United States, affiliated with the
United Methodist Church.
Responsibilities
SQL Server 2014 installations, patches and upgrades, including both standalone and
•
clustered environments of production, test and development.
• Responsible for SQL server logical and physical database design, implementation, and
maintenance.
Database maintenance, management and performance monitoring using third party tools
•
including IDERA and Spotlight.
• Using dynamic management views (DMV) and Dynamic Management Functions (DMF),
TSQL scripts, Triggers, and Store Procedures for troubleshooting and performance tuning
that include finding out long running queries and query costs.
• Automate maintenance jobs in SQL Server job agent and task scheduler: such as
shrinking database, index rebuilding, creating filtered indexes, index reorganizing, cleaning
up, and updating statistics.
• Analyzing Locks, Dead Locks using both Spotlight and DMVs and DMFs, and handling
the isolation Level and Concurrency Effects.
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.
Manage users and groups (roles) from Active Directory or SQL, provide appropriate
•
server roles, map them to specific databases and grant specific privileges over selected
database securable objects to ensure security and integrity.
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.
Architects, monitors, and maintains the Microsoft SQL Server Database environments
•
which support applications.
Use Commvault to restore full, differentia, and transactional log backups.
•
Migrate data from a Unidata to SQL Server.
•
Provides expert level database administration support to developers and others as needed.
•
Works on a HADR strategy, especially on Always On Availability Groups and SQL
•
Server Clustering.
Configure, maintain and troubleshoot server-class hardware and operating systems.
•
Monitoring with team members and write a well-defined documentation for future use.
•
Walmart Stores Inc.
SQL Server Database Administrator
Bentonville, AR
March 2014 – October 2014
Wal-Mart Stores, Inc., is an American multinational retail corporation that runs chains of large
discount department stores and warehouse stores.
Responsibilities
Perform SQL server logical and physical database design, implementation, and
•
maintenance.
• Install, configure SQL Server 2005/2008/2008R2/2012/2014 and apply periodic service
packs and hot fixes (cumulative updates) for Dev, Staging and Prod environments.
• Manage and work across 50+ servers and more than 200 databases with OLTP databases.
Perform daily checkups on SQL jobs, replication, hardware diagnostics for hard drives,
•
backups, 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.
Manage users and groups (roles) from Active Directory or SQL, provide appropriate
•
server roles, map them to specific databases and grant specific privileges over selected
database securable objects to ensure security and integrity.
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 transactional log shipping, SQL Server Mirroring (Synchronous/
•
Asynchronous), Fail over clustering and Transactional replication in multiple environments
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.
Implement database refresh using SSIS packages and automated backup/restore jobs.
•
Auditing of database for logins, users transactions, and database activities and resolving
•
orphan users.
Migrated data and database objects from Oracle and Sybase to SQL Server 2012 and SQL
•
Server 2014.
Configured SMTP Server for Database Mail setup and received Alerts.
•
Installation, Configuration and Administration of SharePoint Server 2007/2010/2013
•
farms.
Install new versions of the Oracle RDBMS and its tools and any other tools that access
•
the Oracle database.
Plans and implements backup and recovery of the Oracle databases.
•
Implements and enforces security for all of the Oracle Databases.
•
Data Migration to and from various sources using SQL Server Integration Services
•
(SSIS).
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.
•
Remote Tiger Inc.
SQL Database Administrator
Greenbelt, MD
October 2013 – March 2014
Remote Tiger Inc. is a full service IT consulting firm offering end to end service and
implementation solutions to clients worldwide.
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 transactional 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.
Documents Authentication and Registration Office
SQL Server Database Administrator/SSRS/SSIS Developer
Addis Ababa, Ethiopia
September 2009 – August 2013
Documents Authentication and Registration Office provide a reliable means of evidence through
authentication and registration of documents, to facilitate contractual and other relations between
persons and organizations both at domestic and International level and thus support the Justice
System and Investment, besides ensuring the availability of documents whenever they are
required.
Responsibilities
Installing, configuring, administering and securing test and production servers.
•
• Create and optimize database objects, e.g. Tables, Views, indexes, cursors, stored
procedures, functions, CLR code and Triggers.
Scheduling and automating maintenance plans using SQL Server Job Agent.
•
Administer, maintain, develop and implement policies and procedures for ensuring
•
security and integrity.
Enrolling and mapping users following company policies and procedures.
•
Scheduling and automating full/differential/ transactional backups and implementing
•
recovery strategies.
Configured and monitored database replication as high availability and disaster recovery
•
strategy.
Upgrading the SQL Server Databases, Monitoring and Performances tuning.
•
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).
Implement data models, database designs, data access and table maintenance codes.
•
Installing and monitoring SQL agent jobs.
•
Certificattions
• Microsoft Certified Professional in “Querying Microsoft SQL Server 2012”.
• Microsoft Certified Professional in “Administering Microsoft SQL Server 2012
Databases”.
• Trainings in SQL Server and T-SQL.
Education
• M.Sc. in Mathematics and Information Technology, Addis Ababa University, Addis
Ababa, Ethiopia.
• B.Sc. in Mathematics and Information Technology, Addis Ababa University, Addis
Ababa, Ethiopia.
Contact this candidate