Security Sql Server

Olumide Majiyagbe

********@*****.*** 347-***-**** Microsoft SQL Database Administrator

Professional Summary:

Around 2 years of experience as Microsoft SQL Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, high availability solutions, space management, database security, migration and documentation.

Excellent knowledge on database administration on complex databases of SQL Server 2016, SQL Server 2014, SQL Server 2012 and 2008 R2 with experience within very large-scale database environment.

Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test and production environment

Hands on experience in test, production and development databases.

Proficient in database design for OLTP and OLAP.

Extensive experience in Backup and Recovery of Databases based on the RTO and RPO of the company.

Expertise in supporting client server GUI software and Operating system.

Created development, testing, staging, production and standby databases.

Extensive experience in database security and protect the data from SQL injection

Migrated existing databases into Azure cloud platform.

Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database, profiler and extended events.

Experienced in performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and Troubleshooting tools.

Experience in data migration using Database Migration Wizard

Implemented automated backup strategy using database maintenance task and power shell.

Expertise in maintaining Database Security and creating database and server level roles.

Experience in applying security patches to the databases.

Effective troubleshooting of database and Performance problems.

Configured and Managed High Availability (HA) and Disaster Recovery (DR) Solutions (Log Shipping, Mirroring, Always On, Clustering, and Replication), TDE (Transparent Data Encryption), IPSec and SSL

Developed various T-SQL stored procedures, triggers, views and adding and changing tables for data load, transformation and extraction

Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Experience with partitioned schemas and tables, creating File groups using SQL Server.

Experience in SQL Server Performance Tuning, Query Optimization, Client Connectivity and Database Consistency Checks Using DBCC.

Experience in Administering SQL Server security by Creating User Logins with appropriate roles, monitoring user accounts, granting privileges to users and groups.

Experience with Implementation of Team Foundation Server and its packages.

Experience in using PowerShell, Git and GitHub, SSMS, VC code etc

Extensive knowledge of SQL Architecture, parsing and algebraizing process.

Experienced with Power BI, SSAS, SSRS administration.

Extensive experience in managing Windows servers and Implementation of Team Foundation Server and its packages

Extensive Experience in using PowerShell, Git and GitHub, SSMS, VC code etc

Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills, Good co- ordination and communication with system administrators, business data analysts and development team.

Professional Experience:

Company Name: A&E Consult.

July ’17- Present

SQL Server Database Administrator

Environment: SQL, SQL 208R2, 2012, 2014, and 2016 Windows, Postgres SQL, TOAD, MS Office, Import/Export

Responsibilities:

lDaily database administration tasks including scheduling backup, verifying night backups and recovery.

lInstallation, configuration, maintenance and tuning of databases.

lSuccessfully upgraded SQL server 2008 to 2016.

lWorked as a part of team in Data warehouse developing project.

lInvolved in Installation and configuration of SQL Server 2016.

l24x7 remote support and on call Database support for Database developers & end-users.

lInvolved in Database design and architecture, SQL server performance optimization, Scripting on Stored Procedures, Triggers, Index’s, Views etc. using T-SQL.

lInvolvement on performance Tuning, complex query tuning and Schema refinements

lInvolvement on Disaster Recovery Strategies design, and involvement on monitoring, troubleshooting and managing issues and problems related with Replication, especially on Transactional Replication and other tolerance capabilities including Failover Clustering, Mirroring and Log shipping

lExperienced in implementing SQL Database advanced security practices.

lCreated File groups, Table Partitioning, and created Index

lDatabase Sizing, Tablespace Management, Transaction Management and Security Administration.

lRelational and non- relational Database Administration on Azure and AWS

lCreated Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

lAutomated backups for the Production and Test Databases using power shell and maintenance plans.

lExperienced in Design, implementation and generating documentation of SQL Server on both physical/logical standby databases in high availability mode.

lSQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, profile and extended events.

lExperienced in performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and Troubleshooting tools.

lInstalled, Configured, and Administered Database Mirroring, Always On, and

Replication as High Availability (HA) and Disaster Recovery (DR) Solutions

lPlanning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups based on the SLA

lAssisted SQL developers to optimize the SQL queries and stored procedures.

lExpertise in recovering the database. Performed complete recovery and data file recovery

lExperienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

lApplying security patches both Server side and Client side and Performed testing.

lExperienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

lImplementation of SQL & Application Software Patches and maintaining SW License and maintenance agreements.

lExperienced with PowerBI, SSAS, SSRS administration

lExperience in managing Windows servers and Implementation of Team Foundation Server and its packages

lExperience in using PowerShell, Git and GitHub, SSMS, VC code etc

Education: BSc Geology : University of Ilorin, Ilorin, Kwara State, Nigeria, June 2008;

lSQL Server 2017 DBA + TSQL training from Empire Data Systems - USA

Continuous Education:

lMicrosoft Office, Microsoft Excel, Microsoft Word

lMS SQL Server, TSQL

Reference:

lReference will be provided upon request !

Contact this candidate