Sam Mariye

Experience

1. Sql Server Database Administrator

   JPMorganChase

   Feb 2017 — Present · New York City, NY, US

   Install, Configure, Apply Service Pack and Maintain MS SQL Enterprise Server 20••••16 on Development, Test and Production Boxes. Administering SQL Server security by creating User Login with appropriate Roles, Monitoring User Accounts, Creating Groups, Granting Permission to Users and Groups. Setup and Configure Always-On Availability Groups (AAG) HA/DR on SQL Server 2014 Implementing RTO (Recovery Time Objective) and RPO (Recovery Point Objective) Policy in accordance with the Company SLA (Service Level Agreement). Create Alert and Notifications for system Error, Insufficient Resource, Fatal Database Errors, Hardware Errors, Security Breach, etc. Creating Stored Procedures, Triggers, Views and Functions. Working on SSRS\\SSIS Installation, Configuration and Deployment Database package. Create & set up linked servers between SQL Servers & Oracle data sources. Working with team to implement the Transparent Data Encryption (TDE) to encrypt secured data. Troubleshoot Long Running Queries, Dead Lock, Slow Running Servers by using PerfMon, SQL Profiler, Database Engine Tuning Advisor and 3rd Party Tools. Regularly maintains SQL Server Database, Tables, Filegroups & Indexes consistence by running DBCC command. Using DMV and DMF monitor the health of SQL Server Instance, Diagnose Problems & Tune Performance. Perform day to day DBA activities such as Monitoring SQL Server Performance, Job Status, Addressing User Requirements. Documenting new features, procedures and issues resolved using Visio.

Education

• Addis Ababa University

  Bachelor's degree