Sql Server Data
Resume:
MORAYOOLA E. FRANKULIN
******.*********@*****.***
PROFESSIONAL SUMMARY
10+ years hands-on professional experience in SQL Server database as a DBA, System Analysis, SQL Server 2000 through 2017, Replication and Cluster Server Environments.
Experienced in installing and configuring SQL Server, applying patches and fixes
Experienced in Database Administration on Production Servers.
Experienced in Performance Tuning and maintenance, with outstanding troubleshooting capabilities.
Experienced in High Availability/Disaster Recovery solutions; Failover Clusters and AlwaysOn Availability Groups, Replication, Log Shipping and Mirroring.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Strong knowledge in setting up and managing database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.
Strong knowledge in Configuring SQL Server Agent, create, maintain and monitor jobs.
Experience in troubleshooting and resolving frequent database issues including integrity issues, replication, error log, mirroring, connectivity, and security related issues etc.
Experience in using SSIS, SSRS and BCP to import/export data from different sources of data into SQL Server databases and vice versa.
Experience with PowerShell scripts.
Experience in installing and managing MongoDB.
Experience with MongoDB Atlas.
Skilled at T-SQL, stored procedures, tables, indexes, views, functions, and triggers.
Excellent analytical, problem solving, communication and interpersonal skills with ability to interact with people at all levels and can work as part of a team or independently.
Excellent presentation and documentation skills.
Good interpersonal communication and problem-solving skills and multilingual with knowledge of 2 different languages.
CORE QUALIFICATIONS
Operating Systems:
Windows Server 2016, 2012R2/2012, 2008R2/2008, 2003R2/2003
Databases:
Microsoft SQL Server 2017, 2016, 2014, 2012, 2008R2/2008, 2005, 2000
Microsoft Access 2013/2010/2007/2003/2000
MongoDB 4.2, 3.6
PostgreSQL 12.0, 11.5, 10.10
Hardware/Storage:
SAN, RAID.
Reports Development/Management:
SSRS (SQL Server Reporting Services), MS Access, Excel.
Languages:
T-SQL, Powershell
ETL Tools/Applications:
SSIS, SSRS and Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.
Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
Foglight, Spotlight, Litespeed, SCOM, Tanium, Studio 3T, Redgate, pgAdmin.
PROFESSIONAL EXPERIENCE
Station Casinos LLC, Las Vegas, NV
SQL SERVER DBA September 2016 - Present
Strong on database and performance tuning.
Schedule jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, monitor SQL Server Error Log, space usage.
Wrote T-SQL, Trigger, and Stored Procedures.
Created and migrated partially contained databases within AlwaysOn Availability Groups.
Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
Developed and tested in production and QA which included documentation of processes, creation of test scenarios and execution of tests, via T-SQL scripts, to ensure UI standards met the required specifications.
Assisted database developers to optimize SQL queries and Stored Procedures.
Export & Import data from flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP.
Knowledgeable and working experience in database backup and disaster recovery.
Perform database high availability installs, configure and maintain database mirroring including automatic fail-over.
Configure log shipping as standby database from production database for reporting purposes.
Install and manage clustering across a variety of versions of SQL Server.
Use of DBCC to check database health, fix database corruption, rebuild indexes and other database maintenance functions.
Installation, Configuration, and administration of SQL Server Reporting Services (SSRS).
Develop DBA Reports, user reports using SSRS and Report Builder 3.0. Deploying reports and managing security of report server.
Importing & Exporting data from Flat file, CSV file to/from SQL Server database using DTS and SSIS.
Importing & Exporting to/from databases like MySQL, iSeries DB2 and Access to/from SQL.
Perform server database upgrades.
Perform server patching using Tanium.
Designed and implemented comprehensive backup plan and disaster recovery strategies Implemented.
Installed, configured, and administered SQL Server Reporting Services (SSRS).
Developed Tabular Reports, Matrix Report, and Charts using SSRS and deployed to Report Server.
Migrated older MS SQL Server 2000/2005/2008 to newer MS SQL Server 2012/2014/2016
Imported data from Excel, Flat file and BCP to SQL Server Database.
Export data from SQL Server Database using Import export wizard and BCP to Excel, Flat file.
Installed, configured and managed Database Mirroring, Replication and Log Shipping.
Installed, configured and maintained Fail-Over Cluster Servers in SQL Server 2005/2008/2012/2014/2016.
Installed, configured, and administered SQL Server 2012 in development, test, and production environment.
Installed and configured Operating System, Windows Server 2008/2012/2016.
Verizon, Laurel, MD
SQL SERVER DBA April 2016- September 2016
Created and maintained SQL objects like Tables, Constraints; User defined Functions, Indexes, Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications.
Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
Provided SQL Server problem resolution and 24x7 production support and server outages.
Provided disaster recovery and high availability solutions and database migrations from SQL server 2005 to SQL server 2008R2 and 2012.
Installed, configured and maintained AlwaysOn High Availability Group in SQL Server 2012
Created and migrated partially contained databases within AlwaysOn Availability Groups.
Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
Developed and Tested Production QA which included documentation of processes, creation of test scenarios and execution of tests, via T-SQL scripts, to ensure UI standards met the required specifications.
Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.
Backed up master & system databases and restoring them when necessary.
Optimized Indexes, adding/deleting them when necessary for better performance.
Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary, to work with technicians from other departments.
Used SQL Indexes for improving query performance, lower storage and maintenance cost.
Created and managed Index (Cluster/Non-Cluster), Constraints
Backing up, restoring the database manually and scheduling the jobs and Maintenance Plans.
Rebuild databases using backups.
Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
Installed, configured, and administered SQL Server Reporting Services (SSRS).
Developed Tabular Reports, Matrix Report, and Charts using SSRS and deployed to Report Server.
Migrated MS SQL Server 2008 to MS SQL Server 2012.
Imported data from Excel, Flat file and BCP to SQL Server Database.
Export data from SQL Server Database using Import export wizard and BCP to Excel, Flat file
Installed, configured and managed Database Mirroring, Replication and Log Shipping.
Installed, configured and maintained Fail-Over Cluster Servers in SQL Server 2005, 2008 & 2012.
Installed, configured and maintained AlwaysOn High Availability Group in SQL Server 2012
Installed, configured, and administered SQL Server 2012 in development, test, and production environment.
Installed and Configured Operating System, Windows Server (2008 & 2012).
Created backup jobs for different types of backup like FULL, BULKLOGGED, and SIMPLE Differential and Transaction Log.
Created Jobs for database maintenance Index fragmentation, rebuild, database statistics.
Created BAT programs to move backup and other files to backup servers.
Configured database mail
Created database that can store FILESTREAM data
Changed recovery model to the effectiveness of the backup and restore options
Used PowerShell to automate admin tasks
Changed database state form READ_ONLY to READ and WRITE
Created multiple connections to database and changed RESTRICED_USER and ROLLBACK IMMEDIATE.
CVS HEALTH, Washington, DC
SQL SERVER DBA June 2009- April 2016
Installed and configured Microsoft Windows Clustering and SQL Server Clustering on Windows 2012 Server.
Monitored server activity and worked with clients to solve different problems.
Performed index and statistics management.
Used optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and Windows Performance Monitor for monitoring and tuning MS SQL Server performance Monitoring SQL server performance using profiler to find performance
Implemented troubleshooting of SQL Server performance issues using SQL Server Profiler, Trace, Index tuning wizard and Database Engine Tuning Advisor (DTA).
Performed Disk space monitoring, services monitoring, and block monitoring and troubleshoot using SEM (SQL Enterprise Manager).
Performed database integrity checks using DBCC utilities through automated scripts for checking the database growth, probing the alert log files, monitoring the rollback segments and temporary space usage.
Created stored procedures and triggers for data consistency.
Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
Created and managed users, roles, security at object level, data encryption.
Installed, configured and managed Database Mirroring, Replication and Log Shipping.
Installed, configured and maintained Fail-Over Cluster Servers in SQL Server 2005 & 2008.
Installed, configured and maintained AlwaysOn High Availability Group in SQL Server 2012.
Migrated MS Access 2003/2000/97 databases into MS SQL Server.
Migrated MS SQL Server 2005 to MS SQL Server 2008.
Imported data from Excel, and BCP to SQL Server Database.
Exported data from SQL Server Database using Import export wizard and BCP to Excel.
Created backup jobs for different types of backup like FULL, BULK LOGGED, and SIMPLE Differential and Transaction Log.
Changed recovery Model to the effectiveness of the backup and restore options.
Changed database state form READ_ONLY to READ and WRITE.
Created Jobs for database maintenance Index fragmentation, rebuild, and database statistics.
Configured SQL Server Integration Services (SSIS) & SQL Server Integration Services (SSRS) and granted required access.
Participated in the on-call schedule to respond to SQL Server alerts and potential production database issues.
Strategic Intelligence Technologies, LLC, Laurel, MD
SQL SERVER DBA INTERN December 2007- May 2009
Analyzed MS SQL Server production databases.
Provided customer assistance and support pertaining to database system queries and complaints.
Configured, installed and administrated the SQL database systems and tools.
Configure SQL Server monitoring utilities to minimize false alarms.
Ran database queries using SQL.
Assisted in setting up hardware devices.
Assisted members of the System Operations team with various ad hoc projects.
Assisted in basic system administration and other administrative tasks.
University of the District of Columbia, Washington, DC
SQL SERVER DBA INTERN June 2006- October 2007
Configured, installed and administrated the SQL database systems and tools.
Tracked all service requests in the systematic help desk system.
Assisted central IT staff and contractors when installing network equipment, servers, and switches in school and administrative buildings.
Provided end user training on the use of equipment and general software use.
Desktop software and hardware deployment processes and procedures; ensuring the successful integration of desktop systems components.
Installed and managed Active Directory.
Resolved hardware and software application technical issues and computer lockouts to maintain computer lab operations, including maintaining up-to-date computer software applications on Macs and PCs.
Monitored student activities while in the computer lab to maintain a safe environment that is conducive for learning.
Performed equipment repair.
Instructed students, professors, and university staff in computer lab tech and software application to enhance their understanding of lab operations and technical concepts.
Ability to deploy, configure and troubleshoot peripheral devices connected to Macintosh computers, providing expert info and assistance, and coordinating support resources to provide support and maintain an enterprise desktop infrastructure.
EDUCATION:
Kaplan University School of Business May 2014
Master of Business Administration
University of the District of Columbia, Washington, DC May 2009
BS in Biology
CERTIFICATIONS:
MCTS, MCSA
Certified Scrum Developer (CSD), 2018
References:
Available upon request
Contact this candidate