Candidate Information Title Sql Server Information Systems Target Location US-WA-Seattle Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes

Name: YORDANOS, GEBRESELAMAJob Title: MSSQL SERVER DBACell Phone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLELinkedIn URL LinkedIn URL: https://LINKEDIN LINK AVAILABLE SUMMARY: Almost 7+ years of Bachelor of Science Information Systems (BS-IS) SQL Server Database Installation, Configuration, Administration, Maintenance, Performance Tuning, Backup/Restore and disaster recovery experience in SQL Server 2019/2017/2016/2014/2012. Hands-on experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, cursors, and functions to meet business requirements. Experience in SQL Server Reporting Services Installation, Configuration, and Maintenance using Visual Studio and Reporting Services. Proficient in using third-party tools such as Redgate Backup, Redgate Monitor, Redgate Data Compare, and Golden Gate. Skilled in Production Support, ensuring the continuity and performance of database systems. Experienced with Sybase ASE and Sybase IQ, including installation, configuration, performance tuning, and maintenance. Looking forward to a position in which I can fully utilize my experience in management, assistance, and development.WORK EXPERIENCE:Title: SQL DBAClient: US BANK, Seattle, WADuration: April 2023  PresentResponsibilities: Monitors and analyzes performance, including capacity planning. Experience with DB backups, restore, and recovery models. Installation, Upgrade, Configuration, and Migration of MySQL Server in clustered and non-clustered production environments. Provides day-to-day management and implementation of the Banks database environment including administration, backup, and recovery activities, and change control. Setting up Transactional Replication between SQL Server databases and from SQL Server to Oracle databases. Modifying the database structure, as necessary, from information given by application developers. Planning for backup and recovery of database information. Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer, and Database Engine Tuning Advisor. Created reports in SQL server using SSRS as per the requirements provided by the Front- End users. Worked on Integration services for the purpose of Transforming data from the cubes and storing it into SQL Server tables. Extensively worked on upgrading Microsoft SQL server, failover clustering, log shipping, and replication, using System Monitor and SQL Server Profiler. Involved in the development of databases including creating new databases, converting old databases to new databases, and modification of existing databases. Processes service tickets troubleshoot system issues, resolves database-related incidents, and completes maintenance requests. Configures, tests, installs, and migrates new instances and databases in multiple environments.Title: SQL Database AdministratorClient: HP, Seattle, WADuration: January 2020 - March 2023Responsibilities: Performed backup using backup compression and Data compression in MySQL Server on a clustered environment. Installation, upgrade, configuration, and migration of SQL Server in clustered and non- clustered production environments. Performed tuning and optimization of databases using tools like SQL Profiler, Query Analyzers, and Database Engine Tuning Advisor. 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 available options such as constraints. Administrated and managed the SQL Server 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, row files using DTS, SQL Server Integration Services. Installed and configured SQL Server Reporting Services (SSRS) and maintained the Reporting Servers. Responsible for data migration from Excel, Flat file, Sybase, Oracle to Microsoft SQL Server using BCP and DTS utilities. Worked with third-party tools such as Redgate Backup, Redgate Monitor, Redgate Data Compare, and Golden Gate to extract data from SQL Server to Oracle. Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer, and Database Engine Tuning Advisor. Created reports in SQL server using SSRS as per the requirements provided by the Front- End users. Worked on Integration services for the purpose of Transforming data from the cubes and storing it into SQL Server tables. Responsibilities included providing day-to-day management and implementation of the Banks database environment including administration, backup, and recovery activities, and change control. Processes service tickets troubleshoot system issues, resolves database-related incidents, and completes maintenance requests. Configures, tests, installs, and migrates new instances and databases in multiple environments. Monitors and analyzes performance including capacity planning. Title: SQL Database AdministratorClient: Amegy Mortgage Capital, Woodland, TXDuration: October 2016 - December 2019Responsibilities: Responsible for data migration from Excel, Flat file, Sybase, Oracle to Microsoft SQL Server using BCP and DTS utilities. Prepared, maintained, and modified SQL server installation and configuration documents. Performed backup using backup compression and Data compression in MySQL Server on a clustered environment. Installation, upgrade, configuration, and migration of SQL Server in clustered and non- clustered production environments. Performed tuning and optimization of databases using tools like SQL Profiler, Query Analyzers, and Database Engine Tuning Advisor. 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 available options such as constraints. Administrated and managed the SQL Server 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, row files using DTS, SQL Server Integration Services. Installed and configured SQL Server Reporting Services (SSRS) and maintained the Reporting Servers. Setting up Transactional Replication between SQL Server databases and also from SQL Server to Oracle databases. Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer, and Database Engine Tuning Advisor. Created reports in SQL server using SSRS as per the requirements provided by the Front- End users. Worked on Integration services for the purpose of Transforming data from the cubes and storing it into SQL Server tables. Responsibilities included providing day-to-day management and implementation of the Banks database environment including administration, backup, and recovery activities, and change control. Processes service tickets troubleshoot system issues, resolves database-related incidents, and completes maintenance requests. Configures, tests, installs, and migrates new instances and databases in multiple environments. Monitors and analyzes performance including capacity planning. Worked on SQL Server 2016 migration from SQL Server 2022. Worked on Change data capture and change tracking enabling on the database. Monitored the real-time database events using Change Data Capture tool and wrote them into appropriate tables. Performed daily tasks including backup and restore by using SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor. Daily backup and scheduling Jobs.Title: SQL Server Database AdministratorClient: Dex Media, Seattle, WADuration: June 2014 - September 2016Responsibilities: Involved in Install, configure, monitor, upgrade, patch, and tune different SQL Server servers. Performed Performance Tuning of the database, Stored Procedures, and SQL queries. Setting up Transactional Replication between SQL Server databases and also from SQL Server to Oracle databases. Installing and upgrading the Oracle Database server and application tools. Modifying the database structure, as necessary, from information given by application developers. Planning for backup and recovery of database information. Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer, and Database Engine Tuning Advisor. Created reports in SQL server using SSRS as per the requirements provided by the Front- End users. Worked on Integration services for the purpose of Transforming data from the cubes and storing it into SQL Server tables. Designed and implemented Logical and physical database design upon requirement, also the patching of critical servers\instances. Involved in designing, configuring, monitoring, and troubleshooting replication methodologies, log shipping, and mirroring on critical databases and quickly resolving issues. Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving, and purging), issue problem maintenance and management, Incident management, Security maintenance, etc.EDUCATION: Bachelor of Science in Information Systems (BS-IS) Mekelle University, Tigray, EthiopiaJanuary 2005 - July 2007SKILLS: Database Administration: SQL Server, MySQL, Sybase ASE, Sybase IQ Third-Party Tools: Redgate Backup, Redgate Monitor, Redgate Data Compare, Golden Gate Production Support: Incident Management, Change Management, Performance Monitoring, Automation Backup and Recovery: Strategies and Implementation, Disaster Recovery Planning Performance Tuning: Query Optimization, Resource Management, Database Engine Tuning Advisor Security Management: User Accounts, Permissions, Security Policies Scripting: SQL, Shell, Python Data Integration: SSIS, DTS, ETL Processes Reporting: SSRS, Visual Studio Replication: Transactional Replication, Log Shipping, Failover Clustering Data Migration: BCP