Resume

Sign in

Sql Server Data

Location:
Alexandria, Virginia, United States
Posted:
January 04, 2018

Contact this candidate

Resume:

Career Objective: An experienced MS SQL Server Database Admin/Developer having more than 7 (Seven) years of professional experience in Database Design, administration, ETL Processing, Report Development, Data Modeling, SQL/TSQL Scripting, Gathering and analyzing business requirement and Administering Windows Server Operating Systems. Solid working experience in managing and troubleshooting large databases, backup/recovery, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc. Working experience entails strong knowledge on using third party tools like Idera, SpotLite, ERWin, Visio, and Toad Data Modeler. Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency.

Education:

BS, Addis Ababa University, Ethiopia

Certification:

MCSA (Microsoft Certified Solutions Associate) – SQL Server 2012/2014: 70-461 and 70-462

Training on SSRS (SQL Server Reporting Services), Sufia Institute of Science & Technology, Alexandria, VA

Training on Brent Ozar Unlimited

Training on PASS SQL Saturday

Top Professional Skills:

Database Expertise:

SQL Server 2014, 2012, 2008 R2, 2005, 2000, MS Access

Database Migration:

SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

Operating System:

Windows Server 2012, 2008 R2, 2003 R2, 2000, UNIX/Linux, VMware, Cloud

Languages:

SQL, T-SQL, HTML, DHTML, XML, JavaScript, ASP, ASP.net

ETL/Data Warehouse Tools:

SSIS/DTS, BCP

Reporting:

SSRS (SQL Server Reporting Services) – Enterprise Reporting

Data Modeling Tools:

ERWin, Toad Data Modeler, Visio, SSDD (SQL Server Database Diagram)

Third Party Tools:

SolarWinds, OpNet, RedGate, Idera, SpotLite, ERWin, Visio, Toad Data Modeler

Networking:

Active Directory, DNS, TCP/IP

Hardware/Storage:

SAN, RAID, iSCSI

Professional Experiences

Office of Refugee Resettlement July 2015 to Present

Washington, DC

SQL Database Administrator/SQL DBA

Major Responsibilities:

Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment

Configured and Maintained Fail-Over Clustering using SQL Server 2012

Installed and Configured SQL Server Reporting Services (SSRS)

Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files

Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats

Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.

Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2000/2005 to 2008 R2 and 2008 R2 to 2012

Migrated MS Access Databases into MS SQL Server 2008 R2, and 2012

Migrated Oracle 10gR2/11gR2 and MySQL 5.1.23 databases to SQL Server 2008 R2/2012

Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues

Performed database and SQL/TSQL Performance Tuning

Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers

Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification

Developed Different Maintenance Plans for database monitoring

Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications

Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check)

Worked on Data Modeling projects, Backward Engineering, Developed E-R Diagram and used multiple tools like ERWin, Toad Data Modeler, and SQL Server Data Diagram

Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources

Deployed SSIS packages to move data across server, move logins, load data from different data sources

Setup jobs from SSIS Packages

Used Imp/Exp Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources

Manual, on Demand and setup jobs for Database Backup, and design backup strategy

Deployed and Restored database including Point in Time Recovery

Monitor Server Activity, Error Log, space usage and solving problem as needed

African Development Foundation May 2013 – June 2015

Washington, DC

SQL Database Administrator/SQL DBA

Major Responsibilities:

Migrated and Upgraded from SQL Server 2005 to 2008/2008 R2

Configured database software, associated database tools and performance monitoring software.

Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.

Performed acceptance testing to verify that database changes perform without adverse consequences.

Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.

Developed & maintained scripts, utility jobs or implement needed software for database maintenance.

Implemented & managed database clustering, failover and load balance technologies as per client requirement.

Developed, tested & implemented a robust database backup and recovery strategy with client assistance.

Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.

Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.

Adhered to Change Control Procedures and developed & executed scripted changes requests in accordance with change control procedures.

Set up security and access profiles and procedures for database system administrators.

Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.

Handled Logical Data and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.

Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.

Managed security by defining roles and rights.

Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.

Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures.

Working individually, as a member of a team, and lead small teams to collaboratively design and model systems at a high level prior to construction

NYBT June 2010 – April 2013

New York, NY

SQL Database Administrator/SQL DBA

Major Responsibilities:

*Configured, Installed, and Maintained SQL Server 2000 & 2005 in development, test, and production environment

*Installed and Configured Operating Systems, Windows Server (2000 & 2003)

*Installed and Configured SQL Server Reporting Services (SSRS)

*Configured and Maintained Replications, Log Shipping

*Upgraded databases from SQL Server 7.0/2000 to 2005 in testing and production environment

*Upgraded MS Access 2000/97 databases into MS SQL Server 2000, and 2005

*Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003 Enterprise Edition

*Expertise in database Performance tuning

*Writing T-SQL and Stored-Procedures

* Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers

*Data Modeling, developing E-R Diagram using ERWin and SQL Server Data Diagram

*Backward & Forward Engineering with data modeling tools mentioned above

*Export & Import data from Flat file, CSV file, Oracle, and Access to/from SQL Server Database using DTS, SSIS, and BCP

*Generated Report using SSRS and in Excel, html, text from Database as well

*Working experience in Database Backup, Restore and Point-in-Time Recovery

*Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification

*Developed Different Maintenance Plans for database monitoring

*Monitor Server Activity, Error Log, space usage, and solving problem as needed

Citizenship: Green card holder

References: References available upon request



Contact this candidate