Database Administrator
Resume:
Marta Mengistu
Inver Grove Heights, MN *****
Cell phone: 763-***-****
E-Mail: **************@*******.***
EXPERIENCE
A highly qualified, goal-oriented IT professional with 9 plus years of experience in Microsoft SQL Server Database Administration including performance analysis, database design, security, and maintenance. Well versed in development and support of Microsoft SQL Server 2022/ 2019 / 2017 / 2016 / 2014/ 2012
/ 2008R2 and Windows server 2016 / 2012 / 2012R2 / 2008R2 / 2008 Enterprise server, Microsoft Visual Studio and third-party tools, ServiceNow, Remedy Redgate in 24x7x365 environments including production, development, testing, cluster and replication server. PROFESSIONAL SUMMARY
• Installed and configured SQL server services in standalone and clustered environments.
• Worked on SQL server licensing option and optimization based on server requirements.
• Involved in Transparent Data Encryption (TDE) For security purpose and data protection.
• Expertise in managing and running SQL server on VM aware machines.
• Develop various aspects of database creation conversion and modification.
• Skilled in writing T- SQL scripting and power shell languages.
• managed sox related database and generated quarterly audit reports.
• implemented group level security using windows group account.
• designed backup and recovery procedures for database security recoverability.
• planned and executed database consolidation on multiple and single instance.
• Involved in designing and implementing backend database storage for application. installation as per the requirement of application installation document.
• Migrate numerous databases across multiple environments while coordinating with different teams.
• Extensive experience in creating and modifying stored procedures, index, views, triggers, cursers, and function to meet business requirements.
• Expertise in implementing different types of high availability and disaster recovery mechanisms such as Log shipping, database mirroring clustering and always on availability group setup and configuration.
• Worked on database replication to improve the availability and consistency of data.
• Experienced in SQL server Reporting service (SSRS) installation configuration and maintenance using visual studio.
• Develop integration service (SSIS)for transformation and movement data from SQL and non- SQL database into SQL server.
• Involved in performance tuning and troubleshooting of windows, server and database level issues using SQL server and third-party tools.
• Hands on experience in supporting Azure migrating database to Azure cloud.
• Evaluated and advised new hardware and software for purchase.
• Demonstrate ownership and good skills on problem management.
• Functioned successfully environment within a high pressure to meet deadlines.
• Available responsive and accountable for all action made in database.
• Addressed customer concerns and issues related to database management.
• Helping developers improve their SQL related code writing skill.
• Work well 24X7 production database on call support. WORK EXPERIENCE
Title – SQL Database Administrator
Client —Wells Fargo Minneapolis, MN December 2022 – now
• Installation, Upgrade, Configuration and Migration of SQL Server in clustered and non- clustered production environments.
• Setting up the Snapshot, Transactional and merge Replication in between SQL Servers.
• SQL Server upgrades and migration from lower versions to SQL Server higher versions 2012 / 2014 / 2016 / 2017 / 2019.
• SQL Server Performance Tuning and Query optimization- SQL Profiler, Query Execution plan, indexing strategies.
• Transparent Data Encryption (TDE) For security purpose and data protection
• SQL Sentry to monitor, diagnose, and optimize Microsoft SQL Server environments.
• SQL Server High Availability and Disaster Recovery solutions- Always on Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication
• Capacity Planning, Storage Planning, Hardware Upgrade’s, and Preparing Estimates for database.
• Incident and Problem Management focusing on continuous improvements and quality of service.
• SQL Server Security Auditing, and SQL Statistics for optimization.
• Design and Implement Database Backup and Restore policies.
• Automate routine maintenance tasks using PowerShell.
• T- SQL creating Functions, Store Procedure, View, triggers.
• Build project documentation and troubleshooting guides.
• Participated in capacity planning and reviewing database changes for system impact.
• Performed backup using backup compression and data compression in SQL server databases on clustered environment.
• Worked on database refresh by taking backup from production database to development servers.
• Implemented high availability and disaster recovery setup on the various servers using windows clustering, replication, log-shipping, database mirroring and Always on Availability Group setup. Environment: Microsoft SQL Server 2022/2019/2017/2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third- party Jira, Remedy, Spotlight, Agile Redgate Monitor, Redgate Data Compare, GoldGate. Title- SQL Server DBA
Client- HP, Houston, TX September 2019- November 2022
• Design and Implement Database Backup and Restore policies.
• Performed backup using backup compression and Data compression in SQL Server 2008R2 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 from 2008R2 to SQL Server 2019.
• Set up SQL Server database configuration parameters for SQL Server High Availability and Disaster Recovery solutions- Always On Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication.
• Transparent Data Encryption (TDE) For security purpose and data protection
• Design and Implement Database Backup and Restore policies.
• Automate routine maintenance tasks using PowerShell.
• Build project documentation and troubleshooting guides.
• Participated in capacity planning and review database changes for system impact.
• Implemented high availability and disaster recovery setup on the various servers using windows clustering, replication, log-shipping, database mirroring and Always on Availability Group setup.
• Implemented and tested the point in time recovery of the production databases.
• Worked on database refresh by taking backup from production database to development servers.
• Automate routine maintenance tasks using PowerShell.
• Build project documentation and troubleshooting guides
• SQL Job manager Monitoring, Azure Resources, Auditing and Security Environment: Microsoft SQL Server 2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third-party tools, ServiceNow, Remedy, Redgate
Junior SQL Database Administrator
Center Corporation, Kansas City, MO November 2017 —Augest2019
• Maintaining the integrity and performance of databases and making sure the data is stored securely and optimally.
• Database and Server Decommission and Consolidations.
• Responsible for MS SQL Server 2000,2005 and 2008 and upgrades the servers.
• Installation and configuration and apply service packs and hot fixes.
• Upgrade databases from lower to higher SQL Server in line with application requirements and version support,
• Set up SQL Server database configuration parameters for SQL Server High Availability and Disaster Recovery solutions- Always on Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication. SQL Server Security Auditing, hardening and remediation. Set up SQL Server database configuration parameters.
• SQL Server High Availability and Disaster Recovery solutions- Always On Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication 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.
• Transparent Data Encryption (TDE) For security purpose and data protection
• Design and Implement Database Backup and Restore policies.
• Automate routine maintenance tasks using PowerShell.
• Build project documentation and troubleshooting guides.
• Participated in capacity planning and review database changes for system impact.
• Performed backup using backup compression and data compression in SQL server databases on clustered environment.
• Worked on database refresh by taking backup from production database to development servers. Environment: Microsoft SQL Server 2014/2012/2008R2 and Windows server 2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third-party tools service now, Remedy, Spotlight,
SQL Server DBA
TCF Bank, Minneapolis, MN September 2016 to October 2017
• Installation, Upgrade, Configuration and Migration of SQL Server in clustered and non-clustered production environments.
• Managing Virtual Machine environments linked to MS SQL databases in both physical and VM ware hypervisor.
• Setting up the Snapshot, Transactional and merge Replication in between SQL Server
• SQL Server upgrades and migration from lower versions to SQL Server higher versions 2012 / 2014 / 2016 / 2017 / 2019.
• SQL Server Performance Tuning and Query optimization- SQL Profiler, Query Execution plan, indexing strategies.
• SQL Server High Availability and Disaster Recovery solutions- Always on Availability Groups, Failover Clustering, Mirroring, Log Shipping, Replication.
• Experienced in TDE/Transparent Data Encryption.
• Data modeling, Azure Data factory, Building Pipeline, SSIS, SSRS.
• Capacity Planning, Storage Planning, Hardware Upgrade’s, and Preparing Estimates for database.
• Incident and Problem Management focusing on continuous improvements and quality of service.
• Index review, database maintenance, Query Optimization, Performance monitoring, Alter management issue resolution.
• Involved on SQL Patching. configuring, administering, and troubleshooting AON technologies
(AOFCI & AOAGs)
• SQL Server Security Auditing, hardening and remediation.
• Design and Implement Database Backup and Restore policies.
• Automate routine maintenance tasks using PowerShell.
• Build project documentation and troubleshooting guides.
• Creates incident (ICM) related performance analysis and reporting for review by IT management
• Participated in capacity planning and review database changes for system impact.
• T- SQL creating Functions, Store Procedure, View, triggers.
• Performed backup using backup compression and data compression in SQL server databases on clustered environment.
• Worked on database refresh by taking backup from production database to development servers.
• Implemented high availability and disaster recovery setup on the various servers using windows clustering, replication, log-shipping, database mirroring and Always on Availability Group setup.
• Database and Server Decommission and Consolidations. Environment: Microsoft SQL Server 2019/2017/2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third-party Redgate, Remedy, Spotlight, fresh service.
Education
• Bachelor’s in marketing Rift Valley University, Adama, Ethiopia,
• Associate degree of Engineering in Computer Science, 2005, SDSU
• Microsoft Certified MSSQL Server 2012 Database Administration References available upon request.
Contact this candidate