Scrum Master Server

Rodin Akum

● Dallas ● Texas, ***** ● Tel.: 240-***-**** ● E-Mail:************@*****.***

CAREER SUMMARY

• Enhanced database performance, implemented recovery procedures and achieved 99.9% uptime on all SQL Servers. Over 8 years of experience managing storage of very large SQL Server tables .

• Experience in supporting Very Large databases (VLDB) 500GB – 2TB and troubleshooting the problems.

• Production level support for onsite and offshore - On Call 24/7 environment.

• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting.

• Configured and supported replication(Snapshot/Transactional/Merge) and log shipping in both SQL 2008 and 2012, 2014, 2016, and 2017 Servers. SQL Server Performance Dashboard Reports for Monitoring.

• Increased efficiency 25% by providing optimum database performance with efficient backup(according to the SLA: RPO, RTO, Retention period, & Availability) and restore processes.

• Years of experience conducting code reviews with application developers to ensure best practices for data access are used. Actively resolving tickets to resolve DBA related issues end-to-end.

• Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs.

• of Visual Studio and deployment of SSIS packages, Active Directory, and other Windows server features.

• Strong Experience with SQL Server 2008 through 2019 Administration in standalone and cluster environment. Windows and SQL patching of servers with the latest Service packs available.

• Using powershell cmdlets to automate a range of task like AlwaysOn, Replication, Mirroring setup, Sql Installation, correcting issue of orphan users, Patching, upgrade, Backups, creating databases, tables, etc

• applications in development, test, QA and production - SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 environments.

• Performed Database Migration and Database Upgrade from one version of SQL server to another in both Clustered and standalone environment. Database, and database object designs.

• Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud

• Installed and configured MS SQL Server VM in Azure Database

• Build and configure Window Clusters for different HA Solutions

• Performance Tuning & optimizationstor, Performance Baselining and Query Optimization.

• High Availability Solution- Clustering, FCI, AlwaysOn, Database Mirroring and Log Shipping.

• Building of Window Server Clusters. Installation and configuration of SSIS, SSRS & SSAS.

• Query Store, Import/Export Wizard, SSMS, SQL Profiler, Extended Events, Red-Gate tools.

• Experience in T-SQL writing stored procedures, triggers and functions.

• Knowledge on SentryOne, Spotlight, and SolarWinds Monitoring Tools.

• Excellent knowledge on Server Virtualization with Hyper-V(hypervisor).

• Data Collector for Performance Tuning & Querry tuning. Performance Tuning and Optimization(PTO).

• Assess Databases for Cloud Migration using the DMA tool, and correct Migration Blockers.

• Migrate Databases from on-premises to Azure SQL, Azure Managed Instance as well as Azure VMs. Have also used Transactional Replication, Export/Import Data-tier Application methods, etc.

• Time Management and prioritization skills. An excellent team player with a very positive can do attitude.

• Experience working in a highly cultural diversified team-oriented and collaborative environment.

• Agile mindset as a Scrum Master. A go-getter, reliable and a driven mindset. Focus on Quality.

• Proven track record of providing Excellent Customer Relationship. Rodin Akum

● Dallas ● Texas, 76123 ● Tel.: 240-***-**** ● E-Mail:************@*****.*** PROFESSIONAL EXPERIENCE

1. Position: SQL DBA 10/2020– present

Company: F-Wave

Responsibilities:

• Indexes Maintenance and Performance tuning. Planning and resource allocation.

• SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA), Triggers for performance. Tables Design, views, Stored procedures, Function etc.

• Configure an entire Virtual enironment using HyperV (Hypervisor) and setting up VMs, Installing SQL servers on them, and configuring HADR solutions on them as well.

• Configured and administered Database AlwaysOn, Log Shipping, Replication on SQL Server 2016.

• Monitored Performance and managing parameters and responded fast to front-end users and other members of the IT application Team. Providing Production Support on daily bases.

• Planned and deployed monthly windows and SQL server patches.

• Capacity Planning and resource allocation

• Backup and Restored automation using SQL Native tool and Veeam.

• Troubleshoot Performance issues (client connectivity or Logins, Performance, Security, etc).

• Performed Upgrade, Migration and Server Decommissioning; SQL Server 2008 to SQL server 2016.

• Responded timely and professionally to tickets from clients (ServiceNow).

• Backup and Restore (Using both native SQL Server and Veeam External backup tool).

• Monitoring Performance and managing parameters using SentryOne external monitoring tool.

• Biweekly Database Refresh from PROD to TEST & DEV environments.

• Installed and configured MS SQL Server 2005 - 2019, supported all Production and development servers.

• Maintained database response times in 24X7 Production environments.

• Automation some tasks in SQL Server Agent using T-SQL scripts and powershell scripts.

• Server passwords documentation using KeePass. Clusters. Installation &ag

• Configuration of SSIS, SSRS & SSAS.

• General security data management and compliance. Basic system troubleshooting.

• Ensures compliance with company standards, policies, and procedures

• Troubleshooting and performing root cause analysis of problems and recommend solutions to resolve the problems

• Expert in Performance Tuning and Query Optimization, Partitioning, Compression, indexing, etc.

• Server evaluation using Dave Bland Scripts and also Brent Ozar SQL-Server-First-Responder-Kit.

• Documented processes for installations, clustering, availability group setup, and patching.

• Troubleshooting Database performance issues or live issues.

• Security: Operating system security(SQL Server related service account and Local OS related permissions and SQL Server SVC account options), Security Considerations for a SQL Server Installation, Principals and Database Object Security, TDE and TDE with EKM, Column Level Encryption and various functions used for Encryption/Decryption, Always Encrypted, Dynamic Data masking, etc.

• After-hours support for emergencies, routine scheduled maintenance and database server patching. 2. Position: Database Administrator 04/2015– 06/2020 Company: Mbah & Co Law Firm

Responsibilities:

• Database designing, development, Performance Tuning and Query Optimization in MS SQL Server

• SQL Server Database Services

• Actively involved in Database management (Planning, designing, implementing, and supporting).

• Proactively Monitoring and maintaining DBs server performance, health, availability and security.

• using inbuilt tools(Activity Monitor, DMVs, etc) and some third party tools(SentryOne, and Redgate). Resource Governor and management. Completing User and Application tasks via, ServiceNow ticketing system.

• Database administration procedures and documentation development and maintenance. Creating Views.

• Handling Database security: creating Logins, Users, and assigning required permission levels (Roles).

• Databases Migration and Server Decommissioning. Table partitioning and Data compression for VLDBs. Rodin Akum

● Dallas ● Texas, 76123 ● Tel.: 240-***-**** ● E-Mail:************@*****.***

• Perform database backup/recovery

• SQL Server Integration Service

• Proficient in Always-on/Mirroring

• Setting-up a comprehensive platform for both Database Backups and Disaster Recovery Strategies.

• Proactively Creating and monitoring of maintenance plans and scheduling of jobs.

• Proficient in Performance Tuning, Partitioning, Compression and indexing

• Expert in T-SQL performance optimizing and capacity planning

• Creating users and assigning permissions based on the principle of least privilege

• Implement monitoring procedures to maximize availability and performance of the database/instances

• Configure database mirroring, always on and SQL replication as part of Disaster Recovery and high availability Strategy

• Implementing of SQL Logins, Roles, and Authentication Modes as a part of Security Policies for various Users. Performed Database refresh. SQL server Installation and Configuration. Indexes Maintenance.

• Set and maintain database standards. Experience with backup/recovery best practices.

• Displayed quality skills in planning & designing servers for backup & recovery in Azure; restoring application/VMS etc. in case of crash/ emergencies & maintaining high availability with configuration.

• Experience utilizing various high availability (HA) and disaster recovery (DR) options for MS SQL Server.

• Extensive experience with query tuning and troubleshooting.

• Consolidation, Upgrade and Re-design of an entire SQL Server Environment.

• Hands-on experience in managing configuration, Windows Azure Migration, Deployments, maintenance, software application & hardware devices with a focus on systems and Windows Azure environments.

• Expertise in Always-On Availability Groups (AAG), Database Mirroring and Log Shipping and HA/DR Troubleshooting

• Planning and implementation of Database backup/restore and disaster recovery

• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc. as requirement on SQL Server Environments.

• SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance. EDUCATION

• Advanced MSSQL Server DBA training with AkumTech IT Services LLC, 2021

• Diploma in Computer Science – Pauls Computer Institute, 2020 CERTIFICATION

• Microsoft Azure Fundamentals – AZ-900

Contact this candidate