Sql Server Maintenance

OLUYINKA DAVID AJALA

**** ****** ****, ***. *** MARIETTA GA 30067 USA

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

Phone: 678-***-****

Microsoft Certified IT Professional (MCITP) with core experience in database security, database consolidation, database performance tuning, disaster recovery, backup and recovery, high availability solutions, data warehousing, database and application upgrades and patches with SQL server.

SKILLS SUMMARY

Experience working with merge and transactional replication.

Experienced in creating database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL.

Experience recovering Primary Data Centers to DR Centers

Having experience on Data center servers and handling 2.5 TB databases.

Experienced in Analysis Services (SSAS), Reporting Services (SSRS).

Experience in Migration, Consolidation to virtualized environments (VMs).

Built both windows 2008r2 and 2012 Clusters and SQL Server clusters.

Experience with implementing Database Disaster Recovery and Planning.

Proficient in writing and optimizing T-SQL codes and stored procedures.

Expert in reviewing overall physical database structure for overall stability.

Proficient in use of tools like SQL Server profiler and Windows performance monitor.

Have good understanding of Disk and Server configuration for SQL Server.

Proficient in SQL Server 2005/2008/2008R2/2012 and 2014.

Experience in Using DMVs, Performance dash board, Mirroring and tracking Performance Counters.

Rebuilding / monitoring the indexes at regular intervals for better performance.

Proficient in performance of SQL Server software new installation and upgrades, patches, hot fixes.

RDBMS

MS SQL Server 2005/2008/2008R2/2012/2014

PROGRAMMING LANGUAGES:

SQL, T-SQL, BATCH SCRIPT

OPERATING SYSTEMS

Windows NT/2003/2008/2012

SQL Server DBA

TATA Consultancy Services

Jan 2014 till Present

RESPONSIBILITIES:

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems with 24 X 7 Production Database on Call Support.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on configuring SQL Server with minimum privileged access.

Experience in Disaster Recovery Planning and Security Management operations.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Having hands on experience in DR processes including Log Shipping and Database Mirroring.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write

effective documentation and specifications.

Expertise in T-SQL writing stored procedures, triggers and functions.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Expertise in T-SQL writing stored procedures, triggers and functions,

individual service accounts for SQL server services on cluster with different Security groups to raise security mark.

Having Experience on Data center servers and handling 1.4 TB databases

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration.

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.

SQL Server DBA

Newport Integrated Behavioral Health care

Jan 2013 to Dec 2013

RESPONSIBILITIES:

Implemented High Availability & Disaster Recovery solutions such as Clustering (Both Active-Active Passive), Database Mirroring, Transactional Replication and Log Shipping and mirroring.

Installed SQL Server and configured 2008R2/2008 on Windows Clustered environment

Expert in implementing the snapshot isolation and DDL triggers.

Experience Installing, configuring and managing SQL Server 2008 Reporting Services (SSRS).

Day-to-day administration of live production SQL Servers with monitoring and troubleshooting performance using DMVs, SQL activity monitor.

Maximum performance and uptime in production environment.

Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.

Experience in installation, maintenance of different versions of SQL Servers (2008R2/2008/2005) in both OLTP and OLAP lower regions and Production environments.

Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.

Manage internal SQL Server databases, from planning and testing stages through implementation and support.

Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.

Having Experience on Data center servers and handling VLDBs databases.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Experience in Disaster Recovery Planning and Security Management operations.

Experience in using DMV and dynamic management functions for finding out long running queries.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Extensive experience in HA/DR Troubleshooting.

Installed and configured SQL Server SSIS, SSRS and SSAS for the various Services.

Experienced in using SSIS for data transfer.

Experience in DTS packages .

Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

To analyze long running slow queries and tune the same to optimize application and system performance.

Configuring and deploying DTS packages, BCP for updating Servers.

Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Education:

Kennesaw State University

BBA Accounting -2014

Certification:

Microsoft Certified IT Professional (MCITP) - 2016

Contact this candidate