Sql Server Windows

Olaoluwa Siyanbola

**** *********** ***** ****

Houston, TX 77077

Tel: 832-***-****

Email: *********.**@*****.***

Work Authorization: United States Citizen

TECHNICAL SUMMARY

Seven plus years hands-on professional experience in SQL Server database as a DBA

Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication

Experience in troubleshooting and resolving frequent database issues including integrity issues, replication, Error log, mirroring, connectivity, and security related issues etc.

Experience in installing and configuring SQL Server, applying patches and fixes

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

Solid Experience monitoring, troubleshooting and performance optimization related issues

Experience in using SSIS, SSRS and BCP to import/export data from different sources of data into SQL Server Databases and vice versa

Strong knowledge in Configuring SQL Server Agent, create, maintain and monitor jobs

Have 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

Devoted and Quick learner with capability to master and implement new technologies

Excellent presentation and documentation skills

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2000/2005/2008/2012, TSQL, MS Access, MySQL

Tools: SSIS, SSRS, SQL Doctor, BCP, Import and Export Wizard, Profiler, DMV, DTS, SQL Diagnostic Manager, and Forefront Identity Management (FIM)

Microsoft Office (Word, Excel, Power Point, Outlook, Access)

Operating System: Windows server 2005, windows server 2008, Window Server 2012R2 and Vista/windows 7, Windows 8/8.1/Windows 10

Languages: C#, Typescript, HTML5, CSS3, Ruby.

EXPERIENCE

Texas Children’s Hospital August/2009 – Present Present SQL Server DBA

Responsibilities:

Monitoring and Performance Tuning:

Performed database monitoring and Performance tuning.

Monitor Servers activity, and worked with clients to solve different problems.

Performed index and statistics management.

Performed database integrity checks using DBCC utilities and maintenance plan configuration wizard.

Monitoring SQL server performance using profiler to find performance

Implemented troubleshooting of SQL Server performance issues using DMV, SQL Server Profiler, Trace, Index tuning wizard and Database Engine Tuning Advisor (DTA).

ETL Tools:

Used tools like 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.

Security Management:

Created and Managed users, roles, security at object level, data encryption.

Export & Import data:

From/to MySQL, and Access Database including flat files like text, excel, and to SQL Server 2005/2008/2012.

Backup/Recovery:

Work experience and strong knowledge in disaster recovery.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Wrote T-SQL Scripts for database backup jobs and daily/weekly jobs.

Backing up, restoring the database manually and scheduling the jobs and Maintenance Plans.

Reports:

Installed, Configured, and administered SQL Server Reporting Services (SSRS)

Database High Availability:

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

SQL Server & Windows Server Installation:

Installed, Configured, and Administered SQL Server 2005, 2008 and 2012 in development, test, and production environment.

Installed and Configured Operating System, Windows Server (2000, 2003, 2005 & 2008).

Database Migration:

Migrated MS Access 2003/2000/97 databases into MS SQL Server.

Migrated MS SQL Server 2005 to MS SQL Server 2008.

Imported and exported data from Excel, Flat file and BCP to SQL Server Database.

Database Automation:

Created Backup jobs for different types of backup like FULL, BULK LOGGED, and SIMPLE Differential and Transaction Log.

Created Jobs for database maintenance Index fragmentation, rebuild, database statistics.

Configured Database mail

Changed recovery Model to the effectiveness of the backup and restore options

Changed database state form READ_ONLY to READ and WRITE

Created multiple connections to database and changed RESTRICED_USER and ROLLBACK IMMEDIATE.

EDUCATION

Associate of Science

Houston Community College, Houston, Texas.

TRAINING

Certificate of Completion in Microsoft SQL Server 2012: Implementation and Maintenance

REFERENCES

Will be available upon request.

Contact this candidate