Database Administrator Customer Service

Chukwuekwu Biose

Cell: 347-***-****

E-Mail: *****.*******@*****.***

PROFESSIONAL SUMMARY:

●Having 7.0+ Years of experience as Microsoft SQL Server Database Administrator in production support.

●24 X 7 Production Database on Call Support.

●SQL Server DBA Production Support, issue resolution tickets with in the SLA’s

●Expertise in Database Administration of SQL Server installation & configuration, of SQL Servers 2008 R2, 2012, 2014, 2016, 2019. And applying service packs.

●Implementing the Backup strategy and restoring the databases whenever required and experience in backup and restoring.

●Administering SQL Server High Availability and Disaster Recovery setup.

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

●SQL Server proactive performance monitoring and SQL Server Migration Expert for in Place & Side by Side

●SQL Server Security Administration and Auditing on weekly and monthly processes

●Experience in Disaster Recovery Planning and Security Management operations.

●Having hands-on experience configuring and monitoring disaster recovery and high availability solutions like Replication, Log Shipping and Mirroring.

●Worked on configuring SQL Server with minimum privileged access.

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

●Maintained individual service accounts for SQL Server services on clusters with different Security groups to raise security marks.

●SQL Server Development or Change Script deployment on production servers.

●Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

●SQL Server, Reporting, Integration, Analysis Services Installation and Service Pack upgrade

●Strong experience in mentoring team members and writing documentation.

●Upgrading SQL server from various versions like 2005 to 2008R2, 2008 to 2012,2014 t0 2017 and 2019.

Technical Expertise:

Databases:

SQL Servers 2008 R2, 2012, 2014, 2016, 2017,2019

Operating System:

Windows 2012/2010/2008/2003 Advanced Server

DBA:

Database Administration of MS SQL Server 2008 R2, 2012, 2014, 2016, 2019

SQL Server Tools:

SQL Server Enterprise Manager, Query Analyser, SQL Server Management Studio, SQL Profiler, Business Intelligence Management Studio, DTA, Perf Mon

Tools:

SQL Sentry,SQL LiteSpeed, Idera 7.2 (SQL Safe& SQL Diagnostic manager).

Ticketing Tools:

BMC Remedy, TFS, Lotus notes, Change Management Process, CA Service Desk Manager.

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SMTP

Professional Experience:

Database Administrator. Sept. 2019 –– Present (Remote Contractor)

Bomex Autos . Atl, GA

Responsibilities:

●Provide DBA 7x24 and on call Support to production teams and perform routine DBA activities for SQL

●Experience in Clustering (Active/Active, Active/Passive).

●Experience monitoring SQL server with Idera.

●Configure and troubleshoot AlwaysON High availability groups.

●Configure and support Replication

●Deployed and maintained SQL clustering environment

●Experience with SQL Server 2008/R2, 2010, 2012, 2014, 2016, 2019 installation, Migration, configuration.

●Performance tuning experience, specializing in database and instance tuning and SQL optimization.

●Installation and configuration of SQL Server in Microsoft Windows Server Enterprise Edition.

●Installing and updating the Mandatory Patches in SQL Servers

●Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

●Expert in Using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.

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

●Designing Backup & Recovery and for point in time recovery

●Providing Security by giving access permission to users at various levels.

●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.

●Performance tuning, high availability testing, and disaster recovery.

●Design and implement a database in accordance with the end user's information needs and views.

●Use high-speed transaction recovery techniques and backup data.

●Design and implement a database in accordance with the end user's information needs and views.

●Determine, enforce and document database policies, procedures and standards.

●Perform tests and evaluations regularly to ensure data security, privacy and integrity.

●Monitor database performance, implement changes and apply new patches and versions when required.

●Supported customer service databases which are more than 2TB.

●Coordinated with project management staff on database development timelines and project scope.

●Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.

●Modified existing databases to meet unique needs and goals determined during the initial evaluation and planning process

Database Administrator. October. 2015 – August 2019

New York Life Insurance, NY

Responsibilities:

●Provide DBA 7x24 and on call Support to production teams and perform routine DBA activities for SQL

●Installation and configuration of SQL Server in Microsoft Windows Server Enterprise Edition. Standalone HP servers in enterprise Data Centres.

●Installing and updating the Mandatory Patches in SQL Servers

●Migrate SQL Database from On-premise to Azure cloud.

●Experience in Clustering (Active/Active, Active/Passive).

●Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

●Expert in Using DMVs, Performance dashboard, Mirroring, and tracking Performance Counters.

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

●Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions

●Expertise in designing databases and capacity planning.

●Configure AlwaysON High availability groups.

●Rebuilding the indexes at regular intervals for better performance.

●Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

●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

●Database upgrades, installation, and configuration of sql server

●Orchestrated data migrations

●Pre-deployment testing.

●Deployment to production services.

●Thorough evaluation of existing environment to gauge systems' health and stability.

●Capacity planning.

●Capacity, performance, and security audits.

●24/7 monitoring, problem resolution, and root-cause analysis.

●Configuration management.

Education:

Bachelor of Arts /Public Administration 2008

University of Calabar Nigeria

Reference

Available on request

Additional Information

Citizen Authorized to work in the US for any employer

Contact this candidate