Kebede Abebe

• Installed , configured and maintained On - Premises SQL Server 2012,2014,2016,2017,2019 in in clustered and standalone environment.
• Migrated on premises SQL Databases to AWS .
• Designed databases to support business applications, ensuring system scalability, security, performance and reliability.
• Configured and Maintained Always On Fail-Over Clustered high-availability environment in SQL Server 2014.
• Worked on refreshing Oracle data from prod to non - prod Environments.
• Extensively provided ETL Application support , SSIS Package Administration/ Deployment /troubleshooting.
• Performed SSRS server Migration from SQL 2012 to SQL 2016.
• Performed SQL Server database Migrations from SQL 2012 to SQL 2019.
• Configured Transparent Data Encryption (TDE) and backup/Restore strategies on encrypted databases .
• Designed and developed scripts to refresh selective data from production to development, QA and production support environments.
• Engaged in security audits,SQL Patching and disaster recovery measures.
• Interact with developers, network, virtualization, storage and systems operations teams to resolve problems with applications and database systems
• Worked on Backup strategies /Index Maintenance/ Database Consistency Checks as part of database maintenance.
• Administered and monitored 24/7 applications and systems, developing automated alerts to warn of failures.
• Maintained detailed documentation of solution designs and business requirements.
• Worked well in a team setting, providing support and guidance
• Identified issues, analyzed information and provided solutions to problems
• Demonstrated a high level of initiative and creativity while tackling difficult tasks
• Worked flexible hours across night, weekend, and holiday shifts
• Organized and detail-oriented with a strong work ethic

Environment : MS SQL Server 2008r2,2012,2014,2016,2017,2019, Windows 2008r2,2012,2016, SSIS ,SSAS, SSRS , Power BI , MS Access , Oracle 11g,VMware, Solarwinds DPA,Visual Studio 2017,Azure DevOps

• Installed , configured and maintained On - Premises SQL Server 2012,2014,2016 in clustered and standalone environment.
• Extensively provided SQL support for SQL Auditing, Patching, ETL Packages, SSRS/SSAS , Encryption and Backup strategies .
• Extensively worked on HA and DR solutions to meet customer requirements for various state agencies.
• Configured Always-On with synchronous and asynchronous secondary replicas for 2 node cluster.
• Worked on applying Service pack upgrade for SQL 2012 SP3 to SQL 2012 SP4 on 2 node always on cluster.
• Consistently met deadlines and requirements for all production Deployments.
• Worked on CDC (Change Data Capture) and automated CDC process for Data warehousing needs.
• Provided continued Database maintenance support and applied SQL Patches/Bug Fixes for existing Database Servers under Service Pack upgrade Project.
• Installed R on SQL server 2017 for data analytics .
• Extensively worked on Deploying SSIS packages and deploying SSAS cubes as part of data warehousing needs.
• Extensively worked with server level ,Query level tuning for effective performance.
• Extensively worked on configuring SSRS for various agencies (DOC/ETF/DOA/DOT) on SQL server 2016 and installed SSL encrypted certificate.
• Worked on Configuring snapshot & Transnational replication on SQL 2014/2016 servers.
• Worked on creating Crystal Reports using SSRS and Power BI by creating datasets and data sources for sending automated reports.
• Worked on deploying/Developing SQL SSIS packages by validating errors before deploying and resolving them as required in various versions of SQL servers SQL 2012/2014 and 2016.
• Installed SSL encrypted certificate on Windows Cluster to use SQL server Force Encryption for incoming SQL Server connections on database servers.
• Created in house monitoring system using power shell scripts for getting backup reports and various SQL server alerts .
• Migrated SSRS reports from Native SSRS reports to latest SQL Power BI reports.
• Extensively worked on automating manual process like Backup/Restores, Automating SQL server Build processes by creating Templates for SQL 2012/2014/2016 versions.

Environment : MS SQL Server 2008r2,2012,2014,2016,2017, Windows 2008r2,2012,2016, SSIS ,SSAS, SSRS , Power BI ,Crystal reports , MS Access ,VMware, Commvault ,Idera SQL Diagnostic Manager,Windows Clustering,AWS

• Installed , configured and maintained On - Premises SQL Server 2008,2008r2,2012,2014 in clustered and standalone environment.
• Extensively worked on SQL Server database design, development , and implementing to support business needs and deadlines.
• Designed and developed scripts to refresh selective data from production to development, QA and production support environments..
• Consult with Service Owners, Managers and Senior Project Managers in order to prioritize and scope technical needs of Advanced technology / high impact projects.
• Involved and lead effort in setting up SSAS tabular model server & user security as part of Data warehousing project.
• Interface with cross-functional teams and departments to access and understand business needs.
• Implemented company policies, technical procedures and standards for preserving integrity and security of data, reports and access.
• Extensively used SQL Server DB Snapshot for Backup / Restore strategy as part of Quarterly application upgrade .
• Evaluate and test new versions and features of SQL Server 2012.
• Worked on Capacity planning and providing strategies for ongoing increase in data storage and data maintenance.
• Utilized Red Gate Tools SQL Compare and SQL Data Compare for promoting modified objects from development to acceptance and productions
• Work with Server/SAN team to diagnose IO latency occurring with several VM's suffering from - IO taking longer than 15 seconds Configured HADR techniques such as log shipping and Always on.
• Extensively worked on Data migration from physical to Virtual and virtual to virtual across various versions of SQL Server.
• Manage hierarchical security (access control, permissions, encryption keys and certificates) for databases and ensure data integrity using templates and schemas per, Sarbanes-Oxley Act(SOX) and HIPPA rules.
• Engage in security audits, database encryption, and disaster recovery measures.
• Create Server/Database level SQL Auditing (DDL trigger), Change Data Capture (CDC).
• Troubleshoot with connectivity, DNS, security and firewall issues.
• Work with domain admins to create appropriate service principle name (SPN) for implementing Kerberos authentication on all SQL Servers.
• Work with change control process for deploying changes in production servers.

Environment : MS SQL Server 2005,2008,2008r2,2012,2014, Windows 2008,2008r2,2012 ,SSIS , SSRS , SSAS, Redgate Tool Belt , SpotLight ,Power BI ,Crystal reports , MS Access ,VMware,AWS