Uploaded File
add photo
Louis
Osemwotalouis231@outlook.com
832-732-3895
1725 Crescent Plaza Drive Apt 3119
Houston, TX 77077
SQL SERVER DBA
14 years experience W2
0
Recommendations
Average rating
4
Profile views
Summary

High Availability solution such as Always On, Cluster, Mirroring and Log Shipping.

  • Experienced in rewriting and restructuring store procedures and views with T-SQL.
  • Expertise in writing technical reports for the management and for other of Production support.
  • Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment. Environment: MS SQL Server /2016/2014/2012/2008R2 T-SQL, SSIS, Asana, Red-gate, LiteSpeed, SQLProfiler, Performance monitor, BCP, Log Shipping, Mirroring, Clustering, Windows Server 2012R2, .Net Framework, C#.Net, JavaScript, MS TFS, MS-Access, SharePoint 2010, Oracle 10g, IIS 6.5,7.5, 8.0, SolarWinds, and PAL tool.

Experience
SQL SERVER DBA
Information Technology
Mar 2019 - present
  • Maintaining 400+ SQL Servers with multiple instances in different environments (RTE, DEV, Pre-prod and Production) and proficiency in deploying new code base release to UAT and Production Environments.
  • Hands-on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server2017/2016/ 2014/2012/2008R2/
DBA SQL SQL Server
Remove Skill
Information Technology
Jan 2008 - present
in standalone and cluster environments and applying service packs hotfixes and cumulative updates.
  • Implementation of automated jobs for database backup on a weekly and monthly basis based on the volatile nature of database tables and indexes.
  • Troubleshooting and resolving day-to-day issues such as job failures transactional log issues blocking and deadlock issues permission issues etc., creation and configuration of databases based on the specifications sent by the client and meet the SLA (Service Level Agreement)
  • Administering database security by creating logins, users, groups and managing roles and privileges assigned to them. Also, used database auditing in auditing for suspicious database activities.
  • Implemented TDE on some critical database and database table with sensitive data to adhere with SOX and PCI compliance.
  • Experience and work as part of a team of DBA's to do monthly test of backups and restore and perform DR drilling scenarios
  • Work on a project to review all server instance bring them update with services packs and also upgraded most of old and legacy applications running on older versions to support SQL Server 2014.
  • Rebuilding / monitoring the indexes at regular intervals for better performance.
  • Created proper Indexes on different tables that improve the performance of T-SQL queries on the database.
  • Using TSQL for developing stored procedures to enhance the performance of the database system.
  • Maintaining the Database Consistency with DBCC commands.
  • Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, and troubleshooting space issues.
  • Set up Database Maintenance Plans to reorganize, rebuild and update the index statistics for better performance.
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
  • Configured log shipping, database mirroring (Synchronous & Asynchronous) and replication (transactional and snapshot) for synchronization of databases.
  • Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS. Created and deployed various reports using SSRS.
  • Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
  • Creation of logins, roles, assigning permissions and mapping users as per the client's request.
  • Performing SQL Server service pack and Windows Service pack upgrades.
  • Scheduling JOBS (Daily, Weekly, and Monthly) as per the client request.
  • Experience in performance tuning of the server, SQL instances, database and queries ran from applications. Help analyze long running and slow queries and tune them using different techniques and tools like SQL PROFILER, execution plans, DMV's, tracing locks, blocks and killing them as need to improve application and system performance.
  • Automated messaging services on server failures, for task completion and success
  • Executed stored procedures requested by the application team to accomplish short-term business goals.
  • Handling Memory configurations for SQL Server and responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • Running Database tuning wizard and continuously monitoring and updating the Backup and Recovery strategy.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
  • Implementation of Database maintenance plan for Database consistency & Integrity
  • Monitoring SQL server performance to find dead locks and blocking to improve the performance.
  • Analyzing database health and consistency by using DBCC Commands and DMVs.
  • Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, Space availability in Storage Devices. Environment: Microsoft Windows Server 32/64 bit, DB2 10.5/11.1 Linux, IBM Data Studio, Windows Enterprise Server
No skills were added
Remove Skill
SQL SERVER DBA
Information Technology
Feb 2016 - Mar 2019
  • Expertise experience in installing new instances of SQL Server 2008 R2, 2012 and 2014 on Microsoft Windows Server2012 R2 and following best practices.
  • Monitored and administered SQL Instances on standalone servers and Cluster environment
  • Highly experience on handling VLDB such ranging from 500Gb to 3T on different VMs which added up to a total of 50T both in UAT/DEV & PROD environments.
  • Installed and administered 2 Node cluster on Microsoft Windows Server 2012 R2 Enterprise Edition on SAN storage.
  • Strong experience in Database Optimization and Tuning, Backup/Restore, Troubleshooting, and Data Import/Export.
  • Expertise in designing and implementing the processes and standards for database systems recovery and back-up checks as well as user performance and data security.
  • Updated database systems by reviewing, planning, testing and installing database security patches and service packs.
  • Expertise in troubleshooting SQL Server Agent jobs, Error Logs, Windows Logs to resolve failure job component.
  • Extensive experience in monitoring and making recommendations for performance improvement in hosted databases, this involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics.
  • Strong experience using DMVs, DBCCs and SPs from SQL Server 2008R2 to 2014 for checking database health and performance.
  • Expertise in monitoring performance using SQL Profiler, Activity Monitor, Perfmon in order to find locking, blocking and deadlock issues.
  • Expertise in planning and managing SDLC projects such patching, hot fixes and service pack upgrades and migrations .
  • Experienced in SQL Server Migrations of various versions. Planned/Designed and migrated 7 PROD Database servers, 6 DEV DB servers, 5 UAT DB severs from SQL SERVER 2008 to SQL SERVER 2014 used both in place and out place upgrades.
  • Experience with dealing with ITOPS change review meetings for changes to be approve for implementations on PROD environment.
  • Experienced in recovering the databases from disasters and implemented Point-In-Time Recovery solution.
  • Analyzed and defined capacity planning for maintenance of the different Database Backups and Restore scenarios
  • Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
  • Set up linked servers and troubleshooting any issues related to ODBC connectivity.
  • Automated daily tasks including backup and restore tools by using SQL Server 2008/2008R2/2012/2014 native SSMS tools.
  • Experienced to work in coordination with different Teams (like Network Team, Windows Admins, Storage Admins, and other application Teams) as well with Stakeholders and customers.
Database Backups Database Upgrades DBA Disaster Recovery Patch Management SAN SQL SQL Server Storage Administrator Windows Server
Remove Skill
Jan 2012 - Jan 2014
SSRS, PowerShell ISE, .NET, T-SQL, SQL Server Enterprise Edition 2014.
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Science National Open University
Skills
DBA
2021
5
SQL
2021
5
SQL Server
2021
5
Database Backups
2019
3
Database Upgrades
2019
3
Disaster Recovery
2019
3
Patch Management
2019
3
SAN
2019
3
Storage Administrator
2019
3
Windows Server
2019
3
.NET
0
1
IIS
0
1
JavaScript
0
1
MS SharePoint
0
1
MS TFS
0
1
Oracle
0
1
Production Support
0
1
SolarWinds
0
1
SSIS
0
1
T-SQL
0
1