Resume

Sign in

Sql Server Data

Location:
Marietta, GA
Salary:
110,000
Posted:
January 13, 2020

Contact this candidate

Resume:

ANTHONY BASSEY

404-***-****

adbajc@r.postjobfree.com

OBJECTIVE:

Continue my career as a Database Administrator utilizing my strong technical and Communication skills to provide 24x7 production support for SQL Server databases. Interface with other DBA's to provide front line support on problem analysis, monitoring and implementations for all Production, DR, Cert, Test and Dev hosts.

SKILLS SUMMARY:

6 plus years of SQL Server database and SQL programming experience.

Great working knowledge installing, patching, maintaining and upgrading all MS SQL Server software.

Control user privileges and closing production support tickets with client satisfaction in timely manner.

Monitor database activity and file usage, and ensures necessary resources are present.

Determine data to collect and analyzes information as appropriate.

Supported migration of databases from on-premise to Azure and AWS cloud for IaaS and SaaS environment.

Investigate and resolve technical database issues of significance.

Utilize third party performance tuning tools to analyze and determine database performances. Characteristic, informational needs and elements, data flow, storage requirements, data output and reporting capabilities for complex databases.

Backup/Restore, Troubleshooting databases for performance tuning.

Read, write and understand T-SQL

Planned and implemented high availability solutions

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

Energetic self-starter with excellent analytical and organizational skills.

Excellent Financial, business management and development skills

Strong people, leadership and team building skills

Excellent interpersonal, verbal and written communication skills

Detail oriented, and ability to prioritize while completing multiple tasks

PROFESSIONAL EXPERIENCE:

NextGen Healthcare OCT 2014 - Present

Consultant SQL Server DBA

Provided 24/7 production support, maintenance, and administration of SQL Server 2016/ 2014/2012/2008

Installed and configured SQL Server 2016 on new servers

Routinely performed query tuning and other performance tuning practices to resolve issues and ensure that databases were working at their maximum capacity.

Worked on data migration from Oracle 11g to MS SQL 2014 server instances.

Support and troubleshoot very large databases (VLDB) with 500 GB to 3 TB.

Extensively worked on Active-Active and Active-Passive two node Clustering and three node

clustering (Active-Active-passive).

Created and modified Stored Procedures and Functions to generate reports for data migration using TSQL.

Extensively worked on Snapshot and Transactional Replication.

Migrated SQL Server databases from 2008 R2 to 2012/2014.

Implemented Always On, HA and worked with 2014 new concepts like Delayed Durability,

Partition-Table Parallelism, Data Compression, Table and Index Partitioning, Buffer pool

extension, Resource Governer for scalability and Performance enhancements.

Migrated Databases from SQL Server 2000/2005 to SQL Server 2008R2/2012 in Production and test Environments.

Installed, configured, and maintained MS SQL Failover clustering and configure SQL Server

2014/2012 AlwaysOn High Availability to provide server high availability solution for different environments.

Configured tempdb on SQL Server instances by adding tempdb data files proportional to the

number of processor cores and setup file growth parameters.

Reconfigured the default locations of the data files, log files and error log files onto the SAN

environment for all the servers.

Developed complex mappings and tune mappings for better performance.

Installed and performed maintenance of SQL Server 2014, 2012 and 2008R2 on Test and

Production Environments.

Worked with SQL Server 2012 in place and side by side upgrade from SQL server 2005.

Worked with tools like SQL Server Agent, SSCM, SMO, Database Tuning Advisor, SQL Server dashboard, SQL Profiler and Activity Monitor for event monitoring, performance monitoring and made recommendations based on the results.

Implemented data availability solutions like online Restore, Online index Operation, Database

Snapshot, and Fast Recovery.

PACIFIC SYSTEMS INC.

Clients: (FST Financials, Airwatch, Comerica Bank)

Consultant SQL Server DBA May 2012 to AUG 2014

Installing SQL Server with standard access privileges service account to improve security and to attain high ratings in SOC audits.

Installed, configured SQL Server 2008R2 Clustering on Microsoft Clustering services (MSCS) for Active-Passive and Active-Active cluster Nodes.

Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2008R2.

Have experience on SAN and RAID levels and building SQL Cluster servers on SAN storage.

Perform SQL Server service pack and Windows Service pack upgrades.

Designed and implemented comprehensive Backup plan using Native SQL and Lite Speed.

Resolved and tweaked memory pressures caused during production release.

Worked with customers on Application rollouts and server migrations.

Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and 2014

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

Strong experience in mentoring team members and writing documentation.

Troubleshoot performance problems and fine-tuning of databases.

Expertise in designing databases and capacity planning.

Experience with rebuilding the indexes and statistics update at regular intervals for better performance.

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

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

Provide 24x7 production support for SQL Server databases on standalone and Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Monitored and modified Performance using execution plans and Index tuning.

Transferring the data (ETL) to Data ware house by SQL Server 2005 and 2008R2 Integration Services.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Implemented and Scheduled Replication process for updating our parallel servers.

Designed and created databases, tables, views, store procedures and triggers.

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

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

Monitoring the server for High availability and performance of the servers.

Proficiency and expertise in configuring and managing SQL Server Replication.

Using database level triggers code for database consistency, integrity and security.

Tested and Implemented procedures to detect poor database performance, collecting required information, archiving old data and root cause analysis.

Environment Software and Applications: SQL Server 2005/2008R2/2012/2014/2016, .NETFramework4.5, Windows server 2008R2/2012R2/2016 Server, Always-On, EMC DDBost, Performance Monitor, Backup Utility, SCOM, BUR, MS Outlook 2010/2013, Windows 7/8.1, HP ITSM, HP SiteScope, Idera, ServiceNow.

EDUCATION:

University of Benin, Nigeria

Bachelors, Mechanical Engineering Completed 2011

COIN Technology Associates, Atlanta, GA

MS SQL Server Database Administration (Implementation & Maintenance) DEC 2011 – FEB 2012

Microsoft Certification: SQL Server 2012 (MCITP) 2014

REFERENCES:

Available on request



Contact this candidate