Email: adm08n@r.postjobfree.com (c) +1-414-***-****

Address: *** ***** ******, *********, **

ADEOLA SANNI

PROFESSIONAL SUMMARY

* ***** ******* ** * Database Administrator.

* **** ********** **ploying database solutions in the cloud (Azure, Aws,& GCP)

Less than 2-year experience working with Postgres Database (opensource)

In- depth understanding of security and backup procedures to ensure database integrity.

Excellent Documentation, communication presentation, analytical and problem-solving skill.

Expertise in Performance Tuning, Maintenance, High Availability and Disaster Recovery (HADR) solutions.

Expertise in setting up and troubleshooting AlwaysOn setup, Failover Clustering, Database Mirroring, Log Shipping, including Replication models.

Experiencing working with SSIS, SSRS, PowerBi, and Tableau.

Experienced in supporting and maintaining Very large databases in an OLTP and OLAP environment

Responsible for securing SQL server, user management, assigning and revoking permissions and roles.

Experienced in maintaining the health and performance of SQL servers as home grown applications using SQL native tools and several other third-party solutions.

Experienced using TSQL and Power Shell Script.

ACHIEVEMENTS

Database Modernization from legacy to SQL Server 2019 and Azure SQL Instance, using microservices.

Migration Database workload from OnPremise to Azure, AWS, for webapps sitting in the cloud.

Redesigning HADR strategy for Onprem and cloud DB Server

EXPERIENCE

Afroswagg, MD, United States 01/2018- present

SQL Server Database Administrator

Responsibilities:

Managed over 300 Database Servers (Production, QA, and Staging environment)

Monitor SQL server and database performance and proactively address potential performance issues.

Provide solutions for database issues including capacity, redundancy, replication, and performance.

Review, design and develop data models in conjunction with application development team.

Responsible for installing, configuring, and maintaining SQL failover clustering for production environments.

Worked with installation, configuration, and creation of SSRS.

Monitoring daily, weekly, monthly, and quarterly Maintenance Task, ensuring that it is successful and jumping into resolve issues when its necessary

Responsible for providing SQL server problem resolution and 24/7 production support and server outages.

Responsible for securing SQL server, User Management, and taking care of Permissions and Roles.

Created automation of day-to-day operations, critical SQL server alerts and repetitive tasks.

Migrates SQL Data from on premises to Azure SQL Database.

Involved in Technical decision for Business requirements, interaction with Business Analysts, Client team, Development team, capacity planning and upgrading of SQL servers.

Responsible for setting up and maintaining High Availability and Disaster Recovery Solutions.

large-scale Database migrations from SQL server 2005 to SQL server 2008R2 and 2012/2014/2016.

Performing weekly patching of standalone and cluster instances.

Waves Services & Logistics, Lagos, Nigeria 08/2012 -11/2017

SQL Server Database Administrator

Responsibilities:

Created database maintenance plans for SQL backups, optimization, and integrity check and t-log backups.

Managed over 300 databases and VLDB across multiple data centers.

Created checklists for proper / unattended install of SQL server, applied service packs and security fix.

Migrated SQL server databases from SQL server 2005 to SQL server 2008R2.

Created, administered, and maintained SQL server databases on Production, Test and Staging for various groups and ensured the availability of the database servers.

Supported SQL server developers working on different projects with various requests.

Perform database administration activities such as Storage management, Backup, Recovery, and Performance Tuning.

Review, design and develop data models in conjunction with the application team.

Install SQL server 2012/2014 with the AlwaysOn (2 &3 replica).

Expert in configuring, Maintaining, and troubleshooting Log Shipping, Mirroring, AlwaysOn Availability Groups, Replication, SQL server Failover Cluster on same and multiple subnets.

Managing permissions and security.

Provisioning database and configuring appropriate HA/DR strategy based on the RTO/RPO of the company.

Leverage, Lagos, Nigeria 02/2002 -10/2012

Financial Analyst

Responsibilities:

Synthesizing and analyzing financial data (like budgets and income statement forecasts) with consideration for the company’s goals.

Creating alternatives and recommending courses of action to reduce costs and improve the company’s finances.

Generating reports, charts, and tables on financial information.

Developing financial models.

Conducting benchmarking and process analysis.

Doing business studies on past, future, and comparative performance and developing forecast models.

Identifying trends.

Tracking actual financial results in comparison with company forecasts.

Comparing and correcting data regarding transactions

Consulting with upper management to influence long-term, strategic decision making.

Coordinating with other team members.

Keeping financial information confidential.

Training new employees

Improving process efficiency.

Troubleshooting problems with financial systems.

Researching economic conditions

EDUCATION

Bachelor of Business Administration 1997-2001

Olabisi Onabanjo University, Ogun State, Nigeria

CERTIFICATIONS

SQL Server Database Administration

Leicester Academy, Leicester, United Kingdom 2012

Contact this candidate