TSEDEY TIZAZU

Phone: 612-***-****

Email: acza7i@r.postjobfree.com

PROFESSIONAL SUMMARY:

* ***** ** ** ********** as SQL Server Database Administrator for very large and complex databases in SQL servers 2016/ 2014/2012/2008- R2/2005.

Proficient in Installing, upgrading, and administering SQL Servers 2016/2014/2012/2008-R2 and 2005 in virtual and physical clustered environments, providing 24/7 support both non- production and production databases.

Performed migrations from SQL Server 2005 to 2008-R2/2012, SQL Server 2008-R2 to SQL Server 2012/2014 and SQL Server 2014 to SQL Server 2016.

Expertise in applying Service Packs, Security Updates and Hotfixes released by Microsoft.

Proficiency and expertise on Database Backup, Recovery, Disaster recovery procedures.

Set up and executed Database Maintenance Plans, Scheduled and Automated SQL Server Jobs, Configured Database mail, Created Alerts, Operators and Notifications.

Troubleshoot and Resolve SQL Server and Database related problems including CPU, Memory, I/O and Disk space.

Established Remote MS SQL Servers as Linked Servers for fetching data.

Experience on HA/DR methods; Log shipping, Database Mirroring, Replication (Snapshot, Merge and Transactional) and Always On.

Experience in controlling the user privileges, monitoring the security and Audit issues.

Experienced in performance Monitoring and Tuning using Performance Monitor, Activity Monitor, SQL logs, SQL Profiler and Third party Tools.

Experience in Query Optimization techniques using DMV's and DMF's, DBCC commands, Index Rebuild / Reorganizing and also used tools to identify slow running queries using Server-side tracing.

Monitoring locking/blocking and space management issues.

Create complex stored procedures, triggers, tables and other SQL joins and statements for applications by using T-SQL.

Experience in writing T-SQL (DDL, DML, DCL and TCL).Reviewing T-SQL code, maintaining coding standards across the board in all SQL server environments.

Perform ETL using SSIS, Import/Export, Bulk insert and BCP utilities.

Experience on installing, configuring, deploying and providing required permissions to users for Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).

Review of physical and logical database design, promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.

Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.

EDUCATION & CERTIFICATION:

Masters of Science -2007, Addis Ababa, Ethiopia.

Microsoft Certified Professional – 70-462 Administering Microsoft SQL Server 2012 Databases.

TECHNICAL EXPERTISE:

Databases:

MS SQL Server 2016,2014,2012, 2008/R2, 2005

Programming:

Transact SQL

SQL Server Tools

Enterprise Manager, Management studio, Profiler, Query Analyzer, Export & Import, DTA, SSIS, Replication, SQL Analysis services, Reporting services, Power Shell

Operating System:

Windows server 2012/2008/2003 Advanced Server, NT & Windows

Third party Tools:

Spotlight, Tivoli, CyberArk, SCOM, Lite Speed, Arcsight, TDP/TSM

PROFESSIONAL EXPERIENCE:

Center for Diagnostic Imaging (CDI) June 2016- Now

Role: SQL Server DBA

CDI is one of the nation's leading providers of high-quality diagnostic imaging and interventional radiology services through its network of imaging centers, ambulatory surgery centers, and mobile imaging solutions. As a SQL Server DBA for managing production and non- production environments by keeping servers are always online, backed up, and corruption-free.

Provides 24X7 support and maintenance for SQL databases to all Production, development and test servers.

Manages and maintains all aspects of SQL 2008, 2012, 2014 and 2016 database servers in clustering and standalone environment.

Tested and applied latest service packs for SQL Servers.

Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO) and Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).

Successfully Upgraded SQL 2008 to SQL 2014 and SQL 2014 to SQL 2016.

Setup and configured Database mirroring and Log shipping in High Performance, High availability mode as standard DR strategy.

Configured and maintain transactional replications.

Designed and deployed SSIS packages in production environment to implement business logics.

Installed and configured Report and Analysis Services.

Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments.

Involved in Change Management, Problem management activities before implementing database changes in production and development activities.

Reviews and implements database production code changes for all development staff, and enforcing development standards to all database objects.

Involved in development of automated daily, weekly and monthly SQL server agent jobs such as but not limited to Database backup, Integrity checks, Indexing Maintenance and Update statistics.

Managing logins, roles, assigning rights and permissions.

Rebuilding / monitoring the indexes at regular intervals for better performance.

Use native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor, Activity Monitor and Spotlight for performance tuning.

When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.

Provide our development team a list of the most resource-intensive queries and suggest ways to improve performance.

Design indexes for existing applications, choosing when to add or remove indexes.

Document the company’s database environment.

Participate in planning, design, Implementation and testing of new and changing database configuration.

Environment: SQL Server 2008-R2/2012/2014/2016, Clustered, SSIS, SSRS, SSAS, TDP, LiteSpeed, Spotlight.

Ameriprise Financial, Minneapolis October 2015 – May 2016

Role: SQL Server DBA

Ameriprise Financial is a leading provider of financial advice. The company provides access to insurance, mutual funds, savings plans, personal trust services, retail brokerage, and other financial products and services. The primary responsibilities of my role include capacity planning, database design, owning, tracking and resolving database related issues, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g.: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs.

Install, configure and administer SQL Server 2005/2008- R2/2012/2014 on clustered and VMware environment.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Implement SQL server security, server audit, PCI complaints and TDE

Involve in creating Schemas, Tables, Clustered and Non-Clustered Indexes, Views, functions and Stored Procedures.

Creating various Jobs, scheduling & running jobs and troubleshooting the failed jobs.

Monitoring and Troubleshooting SQL Server Performance issues using Microsoft System Centre Operations Manager (SCOM) and Spotlight.

Plan for growth and changes (database capacity planning) and request additional SAN/NAS storage

Ensuring that Tivoli Storage Manager (TSM) scheduled backups run and that data is backed up according to requirements.

Coordinating Tivoli Data Protection (TDP) installation with System Administrators

Performance Tuning of Slow Running Queries or inefficient Queries for Optimal Performance using SQL Profiler and Managing Indexes and Statistics.

Involve in general Database Administration and validated some of the existing schema.

Develop administrative tasks of performing daily Backups in a way that meets the business Recovery Point Objectives (RPO) and test the backups to ensure we can meet the business’ Recovery Time Objectives (RTO).

Implemented high availability techniques AlwaysOn, mirroring, Log shipping, Replication and involved in planning and monitoring of the HA/DR methods.

Performance monitoring and taking steps to improve the I/O is one of the most important factors when setting up SQL server.

Installed and Configured Transactional and Snapshot Replication for production servers to other production servers available in remote location.

Successfully implemented AlwaysOn Availability group in SQL 2012 and installed SQL server in a cluster Environment.

Created alerts and notifications for system errors, insufficient resources, and fatal database errors.

Running DBCC Consistency Checks and fixing Data Corruption in user databases.

Scheduled and monitored all maintenance activities including database consistency check, index defragmentation. Rebuilding the indexes at regular intervals for better performance.

Deploying new code base release to UAT and Production Environments.

Installing, configuring, deploying and supporting SSIS, SSRS, and SSAS.

Manage and resolve trouble tickets for database related issues submitted by customer.

Provide 24 X 7 supports for SQL Servers on-call responsibilities.

Environment: SQL Server 2005/2008/2012/2014, Clustered, VMware, SSIS, SSAS, SSRS, Spotlight, SCOM, CyberArk, Arcsight

Blue Shield of California, San Francisco July 2014 – July 2015

Role: SQL Server DBA

Blue Shield Company is a non-for-profit health plan organization working to ensure all its customers have access to high-quality health care at an affordable price. As Sr. SQL DBA responsible to production and non-production SQL Server Database Administration, Monitoring, and troubleshooting to maintain Availability and Integrity of databases along with implementing best Security practices.

Installed and administered clustered and virtual SQL server 2014/2012/2008 and 2005.

Installed Service Packs/Hot fixes and created documentation for tracking and SQL server installation purposes.

Established and Scheduled Database Backup and Other Maintenance plans for User and System databases right after SQL server Installation process is done.

Recovered the databases from backup in disasters. Implemented Point-In-Time Recovery solutions.

Performed migration from 2005/2008-R2 SQL server databases version to SQL Server 2012 and SQL Server database consolidation.

Managed SQL server high availability and disaster recovery strategies including Mirroring, Log shipping, Clustering and Always on availability groups.

Implemented and Maintained Transactional and Snapshot Replication for reporting purposes.

Administered SQL Server/Database level Security and utilized Auditing and Data Encryption (TDE) according to requirements and Integrity with HIPAA requirements.

Created logins and database users, roles and provided permissions to users and roles according to the requirement and security policy.

Implemented Data Masking and Database Security Hardening.

Scheduled jobs and monitored and troubleshooting them. Task automation using power shell script and SQL agents.

Created DDL triggers for auditing any DDL change.

Write, test and maintaining T-SQL and stored procedures as they relate to DBA support.

Performed data partitioning for efficient management of database tables and indexes.

Evaluated CPU, Disk I/O and Memory related bottlenecks using Performance Monitor and improve the SQL server performance.

Fine tune slow running T-SQL queries using Execution Plan and Database engine tuning advisor.

Monitor, troubleshoot, Optimize and fine-tune databases' Performance issues using DBCC, DMVs SQL server Profiler and third party tools like Tivoli.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Resolved blocking and deadlock issues using activity monitor and system stored procedures.

Worked with developers to develop and optimize SQL code for database scripts, triggers and stored procedures to implement database logic and maintenance.

Responsible for reviewing, optimizing and deploying database scripts requested by Application Development Team.

Worked with the application team on the planning, testing and implementing production database software upgrade cycles.

Moved/Copied of Databases from one server to another server using Backup-restore, Attach and detach methods and refreshing databases in development, QA and stage environments using production backup.

Installed, Configured and deployed SSIS, SSRS and SSAS.

Developed MS SQL Server SSIS packages to implement ETL requirements.

Created SSIS package to fulfill the SQL server maintenance tasks including rebuilding index, backing up database and updating statistics.

Provided 24 X 7 dedicated supports for Development, testing and Production MS SQL Servers rotational on-call responsibilities.

Environment: SQL Server 2005/2008/2012, Clustered, VMware, SSIS, SSAS, SSRA, Tivoli, NetBackup

Cybersoft, Addis Ababa, Ethiopia Jan 2012 – Dec 2013

Role: Junior SQL Server DBA

Description: Cybersoft is a technology implementation partner for various big organizations in Ethiopia. The role was to manage SQL Server instances and make sure that SQL Servers are installed correctly, secured, backed up, and when necessary, restored.

Responsibilities:

Monitoring database performance, identifying bottlenecks, and proposing ways to optimize performance on the production server

Working with development teams to incorporate database changes required for release rollouts.

Maintenance of existing trading instruments, and managing updates to their underlying data

Installation of new servers, and upgrade of existing servers with regard to service packs and new versions

Experienced in creating backup strategy for production servers

Involved in disaster recovery procedures and restore the production databases

The provision of extremely high levels of availability for the production, demonstration and test systems

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users

Developed SQL agent Jobs, Operators, Alerts, Notifications and Scheduled those Job accordingly

Design the database physical data storage, maintenance, and access and security administration

Resolution of any problems in these systems in a timely and professional manner

Ensuring compliance with company security procedures

Experienced in installing, configuring, deploying and supporting Integration Services (SSIS) and Reporting Services (SSRS)

Developed, deployed and monitored SSIS Packages

Transferred the data (ETL) to Data ware house by SSIS

Experienced in implementing Database Mirroring

Implemented Replication Models, i.e., Snapshot and Transactional

24 X 7 Production Database on Call Support

Environment: SQL Server 2008/R2/2005, SSIS, SSRS, SSAS

Contact this candidate