SQL Server Database Administrator
Resume:
AKEEM KAREEM
ENTERPRISE SQL DBA
**********@*****.*** Atlanta, GA www.linkedin.com/in/akeem-kareem-102622199
I am a self-motivated IT professional with extensive knowledge in SQL Server Administration. A strong team player with excellent communication and collaborative abilities. Enthusiastic and driven with a proven track record of understanding and translating technical requirements to improve system accuracy and reliability and to contribute to the active growth and productivity of the company with excellent customer service skills.
PROFESSIONAL SUMMARY:
Working as a part of a team who are responsible for administering, supporting and assisting in the implementation of new and existing SQL database systems, data conversions and migrations, stored procedure review, deployment and monitoring of the systems.
This includes maintaining legacy system databases and assisting in the migration to new systems.
Day-to-day administration, performance tuning, and maintenance supporting several core systems.
Responsible for reviewing maintenance plans, ensure 100% of databases are backed up, respond to failures, write and test disaster recovery plans.
Build, Install, Configure, Patch and support various critical MS SQL Server environments(Development, Test, QA and Production) and versions ranging from 2008-2017 to meet current technical and security standards
Primary skillset in T-SQL, SQL Server 2008R2, 2012, 2014, 2016, 2017.
Experience with Always On, Log Shipping, Replication; Windows Server 2012R2, 2016, 2019.
Good understanding of performance bottleneck associated with CPU, MEMORY and DISK UTILIZATION.
Having knowledge of implementing, monitoring, and fixing SQL Server Agent jobs
Experienced in troubleshooting SQL Server environment related problems using Activity Monitor, Extended Event tool, SQL Server Profiler tool, alongside using Database Engine Tuning Advisor to fix the workload or result set generated from any Performance Monitoring tools.
Ability to strategies Backup/Recovery plan (Full, Differential and Transaction Log Backup) base on the environment RTO and RPO.
WORK EXPERIENCE:
Inalfa Roof Systems June 2016 – Current
SQL Database Administrator
Responsible for Administration of SQL Server 2008R2, SQL 2012, SQL 2014, SQL 2016 and SQL 2017
Providing production support for over 5000 enterprise instances.
Responsible for Security, Replication, SSIS, SSAS, and SSRS Instances in the Production Environments.
Implemented AlwaysOn 2012,2014 and 2016, MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Node
Responsible for the administration of AlwaysOn Instances with Synchronous and Asynchronous Secondary Replicas in Dev, Test, and Production.
Worked extensively in automating process like creating jobs, and error reporting using Alerts, SQL Mail, and SQL Agent
Developed and implemented comprehensive Backup plan and disaster recovery strategies
Managed a centralized MS SQL Server 2008, 2012,2014 and 2016 Platform consisting of over 15000 mission critical databases
Resolving requests related to database and system issues raised by user support
Responsible for Patching, Maintenance, Backup and Recovery, Disaster Recovery (Setup and Testing), and Change Release Strategy for all customers.
Created and maintained windows domain with 500 number of clients which is spread across multiple locations
Planned and executed many upgrade such as Service Pack, Hot fixes etc.
Responsible for Implementing and Maintaining Database Server Standards according to Federal Guidelines.
Handled Fine Tuning Databases System in-coordination with Application owners to utilize the maximum resources for Database and Applications.
Upgrade of Database from SQL Server 2008R2 and SQL 2012 to 2016 Due Microsoft no longer supporting 2008R2.
Migrated up to 250 servers and over 600 databases from a legacy Datacenter with upgrade to new Datacenter.
Installed & configured database with associated database tools and performance monitoring software.
Responsible for Research, Test, Training, and Implementation of new features of SQL Server across all the environments
Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
Performed acceptance testing to verify that database changes perform without adverse consequences.
Estimated disk storage requirements for database software, database files & database administration needs.
Provided optimal database file layout for utilization of storage and performance acceptable to client.
Configured and manage SQL Server 2012 Always-On solution with 4 replicas and 2014 Always-On solution with 8 replicas.
Participated in meetings impacting databases physical design.
Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will own the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).
Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
Implemented & managed database clustering, failover and load balance technologies as per client requirement.
Developed, tested & implemented a robust database backup and recovery strategy in line with client disaster recovery RTO and RPO objective.
Implemented requested refreshes pre or post restore activities (e.g. data loads).
Database recoveries as per requirements.
Conducted root cause and analysis for database incidents and problems.
Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
Suggested application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
Adhered to Change Control Procedures and worked with Change and Incidents management tools
Apolinari Taxes & Multi-Services March 2013 – May 2016
SQL Database Administrator
Controlled Administration of SQL Server 2005, SQL 2008R2, SQL 2012 and SQL 2014 providing production support for over 800 enterprise instances.
Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Node
Worked extensively in automating process like creating jobs, and error reporting using Alerts, SQL Mail, and SQL Agent
Developed and implemented comprehensive Backup plan and disaster recovery strategies
Managed a centralized MS SQL Server 2008 and 2012 Platform consisting of over 500 mission critical databases
Resolving requests related to database and system issues raised by user support
Created and maintained windows domain with 500 number of clients which is spread across multiple locations
Planned and executed many upgrade such as Service Pack, Hot fixes etc.
Handled Fine Tuning Databases System in-coordination with Application owners to utilize the maximum resources for Database and Applications.
Upgrade of Database from SQL Server 2005 and 2008R2 to SQL 2012.
Migrated up to 250 servers and over 600 databases from a legacy Datacenter with upgrade to new Datacenter.
Installed & configured database with associated database tools and performance monitoring software.
Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
Performed acceptance testing to verify that database changes perform without adverse consequences.
Estimated disk storage requirements for database software, database files & database administration needs.
Provided optimal database file layout for utilization of storage and performance acceptable to client.
Configured and manage SQL Server 2012 Always-On solution with 4 replicas.
Participated in meetings impacting databases physical design.
Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will own the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).
Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
Implemented & managed database clustering, failover and load balance technologies as per client requirement.
Developed, tested & implemented a robust database backup and recovery strategy in line with client disaster recovery RTO and RPO objective.
Implemented requested refreshes pre or post restore activities (e.g. data loads).
Database recoveries as per requirements.
Conducted root cause and analysis for database incidents and problems.
Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
Suggested application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
Adhered to Change Control Procedures and worked with Change and Incidents management tools
Intown Suites, Atlanta GA March2010 – Jan 2013
Desktop/PC Support
Developed & executed scripted changes requests in accordance with change control
Procedures.
Provide tech support via phone, the internet, or in person at the office
Diagnosed software/hardware problems, responding quickly, clearly, and resourcefully.
Installed and Microsoft Windows Servers as well as Windows Desktop OS
Configured and constantly maintain Windows Active Directory.
Upgrade of Database from SQL Server 2000 and 2005 to SQL 2008R2.
Provided overall configuration and change control management for data base components.
Escalated database issues to appropriate approvers (if applicable).
Conducted research and collaborated with vendor if necessary for additional patches.
Provided stopgap solutions if possible and acceptable by business and application team
Set up new user hardware such as Desktops, laptops, iPhones, iPads, and other peripherals
Installed printers in remote and on-site locations
Responsible for preparing broken mobile devices for repair as well as issuing temporary
devices for users.
Provide daily customer support to users by troubleshooting issues both on site and remotely for company's other branches
Microsoft Windows Server Administration Windows 2003/2008 /2012.
Microsoft Windows Desktop Administration /Support/Configuration Windows 95/XP/7.
AD Support/Administration for Windows 2003
Maintain Microsoft Windows Cluster Solutions for current OS and previous OS
RSA Remote Access and System Management for Hardware Failures
Service Desk Incidents / Tickets, Request Support System, Change Controls for Mission Critical Server Support.
Provide Remote System Administration and Remote Site Support via WAN/VPN.
EDUCATION AND TRAINING
Federal University of Technology, Akure, Nigeria (FUTA), (B. ENG in Mechanical Engineering), 2008
ISSUED BY: Microsoft
ISSUED TO: Akeem Kareem
ISSUED ON: 31 Oct 2017
REFERENCE:
Available on request
Contact this candidate