Femi Ashaye

**** ******* ***, ******* ** ***** Phone: 443-***-**** E-Mail: ad43dm@r.postjobfree.com

PROFESSIONAL SUMMARY:

Results-oriented Database Administrator with 8 years hands-on professional experience in Database Administration, Azure & AWS cloud experience, System, Hardware/Software Installation. Highly organized individual and team player with the ability to multi-task and prioritize to complete projects on time.

TECHNICAL SKILLS:

Microsoft SQL Server 2008R2/2012/2014/2016/2017 SSIS SSRS Import and Export Wizard Microsoft Azure Power BI SQL Profiler Sentry One Commvault DDBoost GitHub Terraform RDS ELB S3 Log Shipping Replication Database Mirroring Always On AG.

PROFESSIONAL EXPERIENCE:

Transaction Network Services 01/2019 – PRESENT

SQL SERVER ENGINEER

Data Center Migration of all SQL Servers across all environments from On-Prem Data center into AWS.

Analyzed, Developed and executed a plan to migrate eligible applications from on-prem to a cloud solution.

Installation and Administration of SQL Server 2019/2017/2016/2014/2012 on production and Non-production servers.

Performed Migration and Upgrade of SQL Servers from legacy servers to SQL server 2016, 2017 and 2019.

Migration of SQL Server Database for priority services into Microsoft Azure hosted DBs and Managed instances.

Implement and Configure Database Mirroring as a DR solution for a legacy server which hosts in-house Applications.

Upgraded RDS SQL Server 2016 to 2019 in AWS.

Implement RDS Aurora MySQL and PostgreSQL for new application deployment in AWS.

Created Secrets in AWS Secrets Manager for Application connectivity to the database.

Involved in configuring virtual machines, storage accounts, resource groups.

Perform patches and Security Updates for Oracle Databases.

Automate Database Backup and Audit reports using PowerShell scripts.

Added OEM client on new Oracle servers and added them as new target on OEM server for monitoring.

Deploy and Troubleshoot SSIS packages in production environment.

Collaborate with the Data protection Team to implement Commvault as the enterprise backup solution.

Troubleshooted and resolved deployment\configuration\set-up issues and worked with appropriate teams to correct the issues.

Proactively monitor resources and applications using AWS CloudWatch including creating alarms to monitor metrics.

Created business continuity\disaster recovery and failover documentation.

Daily Maintenance of Databases and create Maintenance tasks to accommodate each products SLA.

Created a daily Report of server performance and Jobs status to help proactively monitor the environment.

Configured data link between Oracle server and SQL Servers for data synchronizations.

Provide 24 hours support on Database Administration and maintenance.

FOCUS ON THE FAMILY 07/2016 – 01/2019

Sr. SQL SERVER DBA

Install and Administer SQL Server 2016/2014/2012 on production and Non-production servers.

Implement and configure Windows Cluster and Always On Availability Group for High availability and Disaster recovery solution.

Create a database with Project specifications and support application deployments of the new application database.

Worked using Azure Resource Manager (ARM) to deploy, update and delete multiple Azure resources, as well as migrating on premise resources to Azure with Azure site recovery (ASR), and Azure backups.

Worked on Terraform templates also for provisioning virtual networks and subnets.

Created capacity, architecture plans to create an Azure Cloud environment and migrate servers into IaaS VMs and PaaS role instances for refactored applications and databases.

Upgrade and Migrated the Data Warehouse server from SQL Server 2012 to SQL server 2016.

Implement and Configured SQL Server Always-On solution for our offshore mission critical servers.

Create Instance and Database level SQL Auditing, Change Data Capture and Change Tracking.

Set architectural, operational standards and practices for all systems relating to database products and services.

Create Link Server for data migration from SQL Server to Oracle databases.

Deploy SSIS packages provided by the Developers into the Production environment.

Continuously monitoring and updating Backup and Recovery strategy to recover data using RPO and RTO solutions based on requirements.

Pulled ansible playbooks from GitHub and modified the playbooks pushed back to GitHub

Document requests for change requests and communicate with the development and testing team.

Created a Database Maintenance Plan for Optimal Performance of SQL Server which covers Database Integrity Checks and Index optimization.

Implement and configure a secure and Encrypted connection between the client application and SQL server to comply with PCI DSS compliance rules.

Assisted in deploying ZERTO to replicate data for mission-critical servers to the DR site.

Worked with SCOM team to implement monitoring criteria for Web and SQL servers.

Coordinated physical changes, current space utilization and performance monitoring of two replicated production servers.

Developed implementation strategy and capacity planning on implementing Microsoft High Availability and Disaster Recovery for SQL Server Databases.

Maintained regular monthly backups in Azure for cloud DR.

Involved in troubleshooting and resolving database integrity issues, performance issues, blocking, deadlocks and connectivity issues.

Resolved issues like Locks &Deadlocks using Activity Monitor and SentryOne to improve the performance.

Implemented a job that creates a daily report on every failed and successful SQL Agents jobs.

Upgrade SENTRY ONE monitoring tool and create alerts for optimal server and Database monitoring.

Provide 24/7 rotating support with other team members for after-hours support.

STATE OF MARYLAND 01/2016 – 07/2016

DBA CONSULTANT

Installed, Configured, and Administered SQL Server Instances on both clustered and standalone machines.

Maintained logical consistency of the database by running DBCC statements and rebuilding or reorganizing indexes.

Assisted in complete Life Cycle including Design, Development and Testing of an Application.

Maintained server level, database level and object level security best practices by creating logins and users, configuring permissions and assigning different roles to users.

Extensively used SQL native tools like SQL profiler, Database tuning advisor (DTA), Performance monitor, Activity monitor, Event viewer, Dynamic Management Views (DMV) for monitoring, performance tuning/troubleshooting.

Set up and managed SQL server mirroring and Database Replication for Disaster Recovery (DR) Solution.

Performed database migration from SQL 2008R2 and 2012 to SQL2014 on our SQL Production Server.

Monitored database performance, implement changes and apply new patches and versions when required.

Scheduled jobs to automate different database related activities including Backups and index optimizer.

Deployed SSIS packages on production servers and troubleshoot SSIS job related issue

Built, support and managed Dev/Test/QA environments in addition to Production.

Provided 24/7 rotating support with other team members for after-hours support.

FIDELITY FINANCE COMPANY LIMITED. 02/2013 - 12/2015

DATABASE ADMINISTRATOR

Responsible for all SQL installations, monthly patching and disaster recovery operations.

Monitored Servers activity and worked with clients to solve different problems; moved files between the File Groups and partitioned the tables to improve the performance.

Implemented troubleshooting of SQL Server performance issues using SQL Server Profiler, Trace, Index tuning wizard and Database Engine Tuning Advisor (DTA).

Created and maintained SQL objects like Tables, Constraints, Indexes, Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications.

Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Worked with Oracle team to replicate data from SQL Server databases to Oracle Instances.

Designed and implemented a comprehensive Backup plan and disaster recovery strategies Implemented.

Administered SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).

Imported data from Excel, Flat file and BCP to SQL Server Database using SSIS.

Migrated MS SQL Server 2008R2 to MS SQL Server 2012.

PLUS PLUS IMPACT CONSULT 05/2010 – 12/2012

Jr. DATABASE ADMINISTRATOR/DESKTOP SUPPORT

Installed, configured and upgraded the server to suit the database needs

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.

Gathered and prepared data for research; updated basic tables and queries; build operations documentations; created various ad-hoc reports like table, matrix, and sub-reports etc. as per end user requirements.

Establish new user accounts for company employees, adhering to company's export compliance process.

Responsible for support of a large number of desktops, laptops, printers, and peripherals, along with a wide variety of software including word-processing, spreadsheet, database, emulation, and e-mail packages.

Involved in maintaining SSIS packages to import data into Data Warehouse from Excel, Flat files and OLEDB sources. Install security patches, IPAK's, perform Service account password reset, SSL Certificate renewal and other regular maintenance work.

Documented Disaster recovery plans and participated in disaster recovery drills; monitor SQL Server service status, Application log, Jobs, SQL Server Logs, Dead locks/ Blocking

Assisted end users with software and hardware questions; investigates & resolves network issues including printing, installation, electronic mail, and general system problems.

Maintained excellent client relations and service based on outstanding communication, technical efficiency and problem-solving skills. Provided network support, software development and related services in a Helpdesk setting.

EDUCATION:

Colorado Technical University.

MS. Information Technology.

Lagos State University.

B.SC. Human Resources &Personnel Management.

Professional Certifications and Trainings

MCSA: Microsoft SQL Server 2012/2014 Databases.

ITIL V3 Foundation.

Agile For Teams. (AGILEFORALL).

Oracle Database 12c:Advanced Administration. (OCP)

Microsoft Certified: Azure Administrator

AWS Certified Solutions Architect.

SEC + CE

Building and Managing High Availability Solutions with SQL Server 2016 and 2014. (New Horizon).

Developing SQL Databases. (New Horizon).

Contact this candidate