Sql Server Database Administrator
Resume:
Gizachew Kiflemedihin Email: ********.************@*******.***
Database Administrator
Cell phone:
SUMMARY
I am a competent, experienced, and highly dependable professional with over 6 years of IT experience in database administration, system analysis and design, development, and support of SQL server databases.
I am proficient at producing and completing quality outputs and recognized for performing all duties and responsibilities in compliance with standard operating procedures. I am well known for demonstrating an exceptional work ethic for being well-equipped with strong communication and interpersonal skills. I am enthusiastic to learn new technology and easily adapt to a new environment.
PROFESSIONAL SUMMARY
Have hands-on experience migrating scripts in a production environment and large experience in creating and modifying stored procedures, triggers, cursors, and functions to meet business requirements.
Experienced in SQL Server Reporting Services Installation, Configuration, and Maintenance using Visual Studio and Reporting Services.
Experienced in implementing SQL Server Security and object permission like maintaining the creation of users, configuring permissions database authentication modes, and assigning roles of users.
Expertise in implementing different types of high availability and disaster recovery mechanisms like replication models, log shipping, database mirroring, and clustering.
Worked on Clustering and server consolidation, troubleshooting production issues, and raising high availability.
Created Linked Servers between SQL Server 2012 & 2016, and also created a DTS package for data transfer between the two environments.
Sound knowledge stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.
Expert in tuning databases by choosing indexes and using tools Database Engine Tuning Advisor, and SQL Profiler.
Experience in troubleshooting database issues like space issues, deadlocks, performance, and blocking.
Experienced in SQL Server tools like Enterprise Manager and SQL Query Analyzer.
Experienced in allocating system storage and planning future storage requirements for the database system.
Experienced in Monitoring and optimizing the performance of the database.
24 X 7 Production Database on Call Support.
Gizachew Kiflemedihin Email: ********.************@*******.*** Database Administrator
Cell phone:
TECHNICAL EXPERTISE
Platforms Windows Server 2019/2016/2014/2012
Languages T-SQL, Power shell
RDBMS Microsoft SQL Server 2012/2014/2016/2017/2019 IDE Microsoft Visual Studio 2019/2022
SQL Server Tools SSMS, SSCM, SSRS, Azure Portal, SQL Azure Migration Wizard, Data Migration Assistant
Third-Party Tools Red Gate performance monitoring, Redgate SQL Backup, Service Now ticketing system, Spotlight diagnostic tool
BI and Modeling
Tool
SSIS, SSRS, SSAS
PROFESSIONAL EXPERIENCE
SQL Server Database Administrator
Wells Fargo Las Vegas Nevada January 2022 – Present Responsibilities
Involved in the configuration of maintenance plans for Backup and Recovery strategies
following the company’s Recovery Point Objective (RPO), Recovery Time Objective
(RTO), and the Retention policy
Monitor and optimize database performance by implementing various techniques such
as index optimization, query tuning, and server configuration changes
Performed backup using backup compression and Data compression in My SQL Server 2016 in a clustered environment.
Design, develop, and deploy SSIS packages for data Integration and Transformation
Involved in scheduling the reports to run on a daily and weekly basis in Report Manager.
Maintaining referential integrity, domain integrity, and column integrity by using the available options such as constraints.
Collaborate with developers, analysts, and project managers to provide database support and ensure database designs meet business requirements
Administrated and managed the SQL Server 2016, and 2012 production and non- production servers.
Experienced in creating SSIS packages using proper control and data flow elements.
Export and import data from sources like flat files, and row files using DTS, SQL Server Integration Services.
Gizachew Kiflemedihin Email: ********.************@*******.*** Database Administrator
Cell phone:
Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.
Migrated SQL Server 2012 databases to SQL Server 2016 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, indexes, stored procedures and functions, advanced queries, and 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 other 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 that the backup operations, batch commands, and scripts have been completed successfully.
Contacted various users in gathering the requirements and documented the necessary changes.
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.
Migrated on-premises SQL Server to Azure SQL Database
Reviewed and optimized SQL queries, stored procedures, views, and triggers from other developers to achieve maximum efficiency and scalability. Provided consultation for development teams regarding performance review and the correct usage of database objects listed the most resource-intensive queries on the server and suggested ways to improve performance on each
Performed backup using backup compression and Data compression in SQL Server 2016 in a clustered environment.
Involved in scheduling the reports to run on a daily and weekly basis in Report Manager.
Maintained referential integrity, domain integrity, and column integrity by using the available options such as constraints.
Administrated and managed SQL Server 2017, 2016, 2014, and 2012 production and non-production servers.
Experienced in creating SSIS packages using proper control and data flow elements.
Export and import data from sources like flat files, and row files using DTS, SQL Server Integration Services.
Implemented high availability on the various servers using Replication, Log-Shipping, and Mirroring.
Implemented and tested the point-in-time recovery of production databases.
Developed and created the new database objects including tables, views, indexes, stored procedures and functions, advanced queries, and 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 Gizachew Kiflemedihin Email: ********.************@*******.*** Database Administrator
Cell phone:
tables, established joins, and created indexes whenever necessary.
Loaded or deployed data into other 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 that the backup operations, batch commands, and scripts have been completed successfully.
Contacted various users in gathering the requirements and documented the necessary changes.
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. SQL Server Database Administrator
AT & T Las Vegas Nevada March 2017- December 2021 Responsibilities
Installed, configured, and maintained SQL Server 2012, 2014, and 2016 in development, testing, and production environments
Installed, configured, and maintained Fail-over Clustering using SQL Server 2016
Configured log shipping as a Standby database from the Production database for reporting purposes
Configured and maintained replications (Transactional)
Involved in the development of databases including creating new databases, updating old databases, and modifying existing databases
Responsible for Extracting, Transforming, and Loading data from Excel, Flat file, CSV, and to Microsoft SQL Server using Microsoft SQL Server SSIS
Maintained database security by creating and managing logins, roles, and permissions following company policy and procedures
Monitored database performance and resolved issues by implementing performance-tuning techniques
Applied Hot Fixes on SQL Server 2016
Scheduled jobs to automate different database-related activities including backup, monitoring database health, disk space, backup verification
Monitored SQL Server Error Log to troubleshoot problems.
Developed and deployed SSRS reports and dashboards for business intelligence reporting
Designed and implemented SSIS packages to automate ETL processes.
Modified database structure, when necessary, from information provided by application developers and owners
Participated in disaster recovery planning and execution Gizachew Kiflemedihin Email: ********.************@*******.*** Database Administrator
Cell phone:
Responsible for Database Migration and Upgrade in Development, Test, and Production environments
Applied Service packs (SP) on SQL Server 2016
Installed and configured various editions and versions of SQL Server in standalone, and clustered nodes.
Installed, and Configured SQL Server Fail-Over Cluster for SQL Server 2012, 2014, 2016, and 2019.
Applied service packs, hotfixes, and cumulative updates.
Upgraded SQL Server 2005, 2008, and 2008 R2 Database into SQL Server 2012 and 2014.
Created and maintained logins, Users, and Roles, and managed security of databases.
Implemented a Disaster recovery plan by performing routine backups and restore.
Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach
Performed data Extracting, Transforming, and Loading (ETL) from different data sources.
Rebuilt /reorganized indexes to reduce fragmentation and enhance SQL server performance.
Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, and Notifications, and configured database Mail. Education
Addis Ababa University Addis Ababa, Ethiopia
Bachelor of Science, Management Information Systems - 2009
Contact this candidate