SQL DBA

Seifu Mekonnen

Phone 469-***-****

*****.********@*****.***

Career objective

Database administrator with extensive knowledge, experience and having a superior communication, presentation, detail-oriented with technical, analytical, problem-solving skills. I am dedicated, hardworking and certified Database Administrator with experience in installation, configuration, maintenance, security, and backup and restore.

Professional summary

Over 7 years of experience in Microsoft SQL server database installation, configuration, administration, maintenance and performance tuning, backup/restore and disaster recovery experience in SQL server 2017/2016/2014/2012/2008/2005/2000.

Experienced in SQL Server Reporting Services installation, configuration and maintenance using visual studio and reporting services.

Worked on virtual machine environments for SQL Servers in both physical and VMWare hypervisor.

Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.

Managed internal databases starting from planning and testing stages to implement security and backup and recovery procedures to ensure database integrity.

Background in developing backup and disaster recovery plans for nationwide offices.

Having hands on experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, indexed views, triggers, cursors and functions to meet business requirements.

Involved in implementing SQL Server security and object permission like maintaining creation of users, configuring permissions database authentication modes and assigning roles of users.

Expertise in implementing different types of high availability and disaster recovery mechanism like replication models, log shipping, database mirroring and clustering.

Participated on clustering and server consolidation, troubleshooting production issues and raising high availability.

Created linked servers between SQL server 2014, 2012, 2008 & 2008 r2, also created DTS package for data transfer between the two environments.

Expert in monitoring, performance tuning and troubleshooting of database issues by choosing indexes and using tools database engine tuning advisor and SQL profiler.

Skillful in allocating system storage and planning future storage requirements for the database system.

Involved on Scripting and automation experience using; bash, jenkins

Helping developers improve their SQL related code writing skill.

Work well 24 x 7 production database on call support.

Professional experiences

Target Corp (TGT) / Houston, TX May 2017– present

SQL Server DBA

Target Corporation (NYSE TGT) is an international upscale discount retailer that provides high-quality, on-trend merchandise at attractive prices in clean, spacious and guest-friendly stores from the founding in Minnesota in 1962.

Involved in installation, upgrade, configuration and migration of SQL server in clustered and non-clustered production environments of SQL server.

Experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, indexed views, triggers, cursors and functions to meet business requirements.

Managing virtual machine environments for SQL Servers in both physical and VMWare hypervisor.

Worked on Integration Services for the purpose of transforming data from SQL and non-SQL databases in to the SQL server tables.

Expertise in performance monitoring & tuning, query optimization, client/server connectivity and database consistency checks using DBCC utilities, SQL profiler and database engine tuning advisor.

Responsible for data migration from excel, flat file to SQL server by using BCP and DTS utilities as well as extracting, transforming and loading of data using SQL server SSIS and DTS.

Worked with Change Data Capture (CDC) feature in SQL server to capture all the changes during migration of data between databases.

To ensure recoverability of the Data Warehouse with minimal loss of information which includes extensive testing of the backup and recovery processes and taking backups full and incremental as needed.

Worked on installation, configuration, support, maintenance and backup of SQL server databases and IIS Web server.

Developing and planning for backup and recovery of database information, recovery strategies, mechanism and recovery drills for various environments. Successfully implemented log shipping for DR solutions.

Proactively managed SQL server instances at the corporate office by developing SQL scripts for creation and upgrade of databases, maintenance plans, user logins, automation of network and server monitoring with exception reporting via database mail notifications, and a SQL server failover system.

Extensively worked on upgrading SQL server, failover clustering, log shipping, and replication, using system monitor and SQL server profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.

Involved in development of database including creating new databases, converting old databases to new databases, modification of existing databases, creating reports to meet business needs.

Configured SQL server security in line with business requirement such as server logins, user account and passwords along with database object permissions.

Setting up the snapshot, transactional and merge replication in between SQL server databases.

Environment: Microsoft SQL Server 2017/2016/2014/2012/2008R2/2008 and Windows server 2016/2012/2008 Enterprise server and platforms Linux, Informix and third-party tools Erwin, Idera, SQL* PlusRed Gate, HPDM, Squirrel.

Cadence bank / Houston, TX Nov 2014 – Apr 2017

SQL Server DBA

Cadence bank serves commercial and business banking, treasury management, specialized lending, commercial real estate, foreign exchange, wealth management, investment and trust services, financial planning, retirement plan management, personal insurance, consumer banking, loans, mortgages, home equity lines and loans, and credit cards.

Participated in installation, upgrade, configuration and migration of SQL server in clustered and non-clustered production environments of SQL server.

Performed backup using backup compression and data compression in SQL server on clustered environment.

Involved in scheduling the reports to run on daily and weekly basis in report manager.

Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.

Administrated and managed the SQL server 2014, 2012, 2008r2, and 2005 production and non-production servers.

Experienced in creating SSIS packages using proper control and data flow elements.

Export and import data from source like flat files, row files using DTS, SQL server integration services.

Installed and configured the SQL Server Reporting Services (SSRS) and maintenance of the reporting servers.

Migrated SQL server 2005 databases to SQL server 2012 databases including DTS to SSIS packages.

Implemented high availability on the various servers using replication, log-shipping and mirroring.

Implemented and tested the point in time recovery of the production databases.

Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using query analyzer and enterprise manager on the existing servers.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.

Loaded the data into another data sources like SQL server using SSIS.

Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows for better performance.

Scripting the database consistency checks (DBCC), scheduling the scripts to run daily and weekly basis.

Monitoring SQL server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.

Created necessary templates for various requirements gathering and documentation.

Application support for front end feeds and resolved application connectivity issues like connection timeouts, connection pooling issues and memory leaks.

Monitored log shipping and transactional replication and troubleshooting of errors.

Environment: Microsoft SQL Server 2012/2008R22008/2005, DB2, Windows 2012/2008 Enterprise server, Windows 2000 Advanced Server, Visual Source Safe 6.0, Crystal Reports, SSRS, Business Intelligence Development Studio.

Eldorado casino resort/ Shreveport, La Nov 2012 –Sep 2014

SQL Server DBA

Eldorado resort casino is a hotel and casino headquartered in reno, Nevada. It anchors a network of connected hotel-casinos that includes timeless luxury and friendly personal service in a non-stop gaming excitement and are owned and operated by Eldorado resorts.

Maintaining the integrity and performance of databases and make sure the data is stored securely and optimally.

Responsible for SQL server 2000, 2005 and 2008 and upgrades the servers.

Installation and configuration and apply service packs and hot fixes.

Upgrade databases from SQL server2000 to 2008r2 in line with application requirements and version support,

Set up SQL server database configuration parameters for optimum performance.

Configured and audited SQL server security in line with business requirement, managed SQL server logins, user account and passwords along with database object permissions.

Migration of databases along with users and logins.

Design and implement comprehensive backup plan and disaster recovery strategies, implement and schedule replication process for updating parallel servers

Create automatically running SQL tasks for day-end operation using SQL server agent

Configure and manage linked servers, effect performance tuning, monitored database performance for bottlenecks and space availability

Creation and management of database maintenance plan for various database consistency checks.

Creation and maintenance of user security permissions and migrating the entire database objects from one server to another server as required by the business

Designed and implemented backup policies and recovery procedures utilizing san

Implemented disaster recovery for SQL server production database as failover or standby servers. Used log shipping technique for warm backup solution for SQL server databases including always on availability solutions.

Managed the SQL server in database mirroring and clustered environment.

Identified and resolved the query performance using SQL profiler tuning wizard

Used data transformation services DTS to populate database from various data source.

Install all software upgrades and service packs for SQL server

Monitor connections, locks and performance of SQL server

Configured server database mail setup and received alerts for the threshold values

Derived and documented the root cause analysis for production issues

Estimation of database table size growth

Worked with complex stored procedures, triggers, cursors, views, tables and other SQL joins and statements for applications

Environment: Microsoft SQL Server 2008/2005/2000, DB2, Windows 2008/2003 Enterprise server, Windows 2000 Advanced Server, Visual Source Safe 6.0, Crystal Reports, Business Intelligence Development Studio.

Barksdale federal credit union/bossier city, la Apr 2011 –Oct 2012

SQL Server DBA

Barksdale federal credit union was established to serve military and civilian personnel at Barksdale air force base in Bossier City to provide financial services to credit union members in local communities based on from 24 branch locations in 13 cities and 2 state

Monitoring connections, indexes, locks, alerts, notifications, jobs, schedules and performance of SQL server.

Administering of SQL server 2000, 2005 and updating with service packs.

Handling memory configuration for SQL servers on window server.

Developed and managed SSIS packages and scheduled jobs for periodic and nightly batch processes

Assigned permissions to users and roles, administered secure authenticated logins and supported columns level permission and other security related issues including creation and granting permissions on various objects

Backing up and restoring the database manually and also by scheduling the jobs and maintenance plan as required.

Auditing of database for user transactions, login and database action and in removing orphaned user

Resolving blockings, locks, deadlocks and isolation levels

Handling multiple SQL instances in clustered environment for server consolidation projects built on san using required raid levels

Designing maintenance procedures and putting them into operation.

Planning and implementing database security logins, users, roles and assigning permissions to them.

Writing reports, documentation and operating manuals.

Testing and modifying databases to ensure that they operate reliably.

Keeping databases up to date.

Environment: Microsoft SQL Server 2005/2000, DB2, Windows 2003 Enterprise server, Windows 2000 Advanced Server, Visual Source Safe 6.0, Crystal Reports, Business Intelligence Development Studio.

Education

Bachelor of Science in information technology, May 2005, Ethiopia.

Bachelor of art in accounting, June 2009, Ethiopia.

Certification

Microsoft Certified SQL Server 2012/2014 Database Administration.

Contact this candidate