SQL Server DBA/Developer

OBJECTIVE

An enthusiastic and detail oriented Database administrator / Developer in a highly transactional database servers and dedicated reporting servers of Microsoft product, fluent in T-Sql scripting, versatile engagements in development, testing and production environment with overwhelming successes in accomplishing individual and team projects, certified as Microsoft SQL Server 2014 Database Administrator and Microsoft Server 2014 Database Developer is seeking for Database Administrator/Developer Position.

PROFILE SUMMARY

• Five productive years of experience as SQL Server Database Administrator/Developer.

• Experienced in hardware and software benchmarking pre-installation of SQL Server.

• Installation, Configuration, Maintenance, Upgrade and Patching of SQL Server of diverse versions and editions.

• Working extensively on TFS, Web Application Servers, Development, Production and Test Servers as a Database Developer.

• Experienced in System Analysis, Design, Development & Support of MS SQL Servers 2008, 2008R2, 2012, 2014,2016 in Production and Development Server Environments.

• Experienced with Designing and Implementation of Relational and Multidimensional Databases.

• Experienced with disaster recovery implementations including backup & recovery, log shipping and mirroring.

• Experienced in dealing with efficient security strategies with respect to Principle of Least Privilege (P.L.P) and bring it to implementation and administration.

• Experienced with implementation of diverse High Availability approaches including Replication and AlwaysOn, depends on business specifications.

• Creating and Managing Database Objects like tables, views, store procedures, triggers, indexes, functions….

• Experienced in creating maintenance plans to update statistics, defragmentation of tables; and rebuilding and reorganizing indexes.

• Virtualizing SQL Server on virtual machines like VMWare. I have also fascinating experiences with SQL Azure and the Cloud.

• Experience with Data Migration tools such as; SSIS, Detach/Attach, Import/export, DB Copy wizard, Backup/restore, BCP and so on.

• Experience with Configuring and Automating Jobs. Creating and configuring Jobs, Alerts, SQL Mail Agent and scheduling SSIS Packages.

• Experience in error handling, troubleshooting and performance Tuning by using SQL Tools such us; DMO's, profiler, activity monitor, tuning adviser, Query analyzer, execution plans, Trace, statistics, index tuning wizard and so on.

• Knowledgeable in upgrading SQL Server by evaluating supported versions and editions.

• Experience on Data warehousing, Data mining and Data purging.

• Experience on created Linked Servers between different source to perform ETL between the two environments.

• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

• Working knowledge in SSIS, SSRS and SSAS

• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

• Report Writing and administrating a dedicated SQL Server Reporting Server (SSRS)

• Being certified in SQL Server Database Development and worked on a dedicated development environment, I have solid scripting experience on DDL, DML, DCL with high granularity and any reasonable level of sophistication, depends on our business need.

TECHNICAL SKILL

• Databases: SQL server 2008, 2008R2, 2012 and 2014, 2016, Oracle Database 11g and 12c.

• Windows Server: Window Server 2012R2/2012/2008R2/2008/2003.

• Virtualizing MS SQL Server on VMWare.

• Languages: Fluent in T-SQL, Moderate in C++, PL/SQL.

• SQL Server Tools: Management Studio, Visual Studio 2005/2010, SSDT, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services.

• Third Party Tools: DB Artisan, Red Gate, Spotlight, and Idera.

• Pentaho Data Integration: Version 5.0, 5.1

• Microsoft BI POWER

• Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, SQL Server Management Studio and Enterprise Manager.

• Powershell

The Avant Network

http://www.theavantnetwork.com/

SQL Server DBA/Developer, Richmond, VA March 2014- Present

• Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.

• Responsible for large scale of database migration from SQL server 2005 to 2008r2, 2012, 2014 and to 2016.

• Responsible for Creating stored procedures, tables, views, functions, triggers and indexes.

• Involved in database backups/restoration and planning backup strategies.

• Backing up master & system databases and restoring them when necessary.

• Rebuilding the Indexes at regular intervals for better performance.

• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.

• Responsible for Installing, configuring and maintaining SQL Failover clustering for two production environments.

• Responsible for configuring and maintaining Transactional, Snapshot and Merge replication in production environments.

• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.

• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

• Working with SSIS package to import and export operations in and out of the SQL Servers.

• Scheduling jobs and alerts using SQL Server Agent. Administrating Microsoft Operation Manager (MOM) 2005 in an existing IT infrastructure.

• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.

DBA/Developer

American Management Association

New York, NY Feb 2012 – Feb 2014

• Responsible for Installing and configuring SQL Server 2005 and 2008 on Windows 2003 and 2008 servers.

• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.

• Worked with SQL DBA team and SQL Developers to optimize the SQL queries and stored procedures.

• Created transactional replication for the reporting applications.

• Installed and configured SQL server 2008 Reporting Services (SSRS), created user roles, managed security built reports and deployed them to production. Worked with configured SSRS to monitor all jobs on daily basis, fixed the failed jobs and re-run them.

• Provided 24 X 7 dedicated supports to hundred and eight Production, development and clustered servers.

• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.

• Used DBCC commands to troubleshoot issues related to database consistency.

• Daily monitoring of two-node active-passive SQL cluster in a host environment.

• Applied service packs and security fixes for all SQL Servers, and provided database administration support.

• Involved in upgrading SQL Server 2005 to 2008 and from SQL Server 2008 to SQL Server 2012.

• Performed the database backups for production, test and development environments.

• Created the backup and restore strategy for the all three environments.

• Worked with the database optimization, Performance tuning and index tuning for optimization of queries.

• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

• Implemented trigger and stored procedures and enforced business rules via checks and constraints.

SQL Junior DBA

Central Statistical Agency of Ethiopia.

Addis Ababa Ethiopia. April 2007- March 2009

• Installing and configuring SQL Server 2005 and 2008 on Windows 2003 and 2008 servers.

• Backup and Recovery on a scheduled periods and ad hoc demands. Responsible to take full, differential and transactional log backup and recoveries.

• Installed and configured SQL server 2008 Reporting Services (SSRS), created user roles, managed security built reports and deployed them to production.

• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.

• Troubleshooting and performance checking.

• Creating database and server level roles and maintaining security of the servers and databases.

• Upgrading SQL Server 2005 to 2008 and from SQL Server 2008 to SQL Server 2012.

EDUCATION

• BSc. in Computer Science. Addis Ababa University.

• Masters in Economic. Lund University, Sweden

CERTIFICATION

• MCSA (Microsoft Certified Solutions Associate)

• Microsoft Certified SQL Server Developer

• Microsoft Certified SQL Server DBA

• Course Certificate: Database Management Essentials. University of Colorado

• Course Certificate: Data Warehouse, Concept, Design and Data Integration. University of Colorado

• Course Certificate: Relational Database Support for Data Warehouses. University of Colorado

• Course Certificate: Coursera Mentor Community and Training Course.

Participation

I am currently mentoring learners of “Data Warehouse Design and Data Integration” course of University of Colorado given by the most prestigious online education platform, Coursera, where I earned the three course certificates of University of Colorado.

Contact this candidate