Sql Server Management

Location:

Lakeville, MN

Salary:

NEGOTIABLE

Posted:

September 28, 2017

Contact this candidate

Resume:

MAXWEL ICHAI ANGYE

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

St. Paul MN

55117

+1-651-***-****

***********@*****.***

Work Authorization: Permanent Resident

SQL Server DBA – ECOLAB, 3M Dakota premium foods and Fokou Sarl.

CAREER OBJECTIVES

Seeking a position as a SQL Server DBA in initiatives that utilize state-of-the-art, software and/or hardware components with a creative, technology-driven organization in an environment that encourages innovative thinking, recognition and career development.

TECHNICAL

SUMMARY:

5 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 and Replication

Strong knowledge in Configuring SQL Server agents, creates maintain and monitor jobs.

Experience with DB connection pooling via Java/JEE application servers.

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

Experience working with large databases (8T), warehouse databases.

Experience with AlwaysON.

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

Scheduling SQL Server jobs to monitor disk space, CPU activity and index fragmentation.

Experience with EMC SAN storage system.

Strong experience in Setting up Test, Development, Staging and Production Environments.

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

Have knowledge on data modeling.

Experience with change control management and interfaces for database and application migrations.

Experience with of ORM frameworks (like hibernate, ibatis, cayene, jooq, etc.)

Solid experience working in a high availability environment.

Have knowledge on database analysis.

Experience with change control management and interfaces for database and application migrations.

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

Knowledge of AZURE storage system.

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

Experience in Installing, configure, patch and upgrade SQL Server Software.

Excellent presentation and documentation skills.

Experience writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata).

TECHNICAL

SKILLS:

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

Tools: SSIS, SSMS, SQL Doctor, BCP, Import and Export Wizard, Profiler, SQL Diagnostic Manager, Spotlight, Database Tuning Advisor (DTA), Failover cluster manager, Task scheduler.

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/Windows 10

PERSONAL QUALITIES

Strong motivational and leadership skills.

Excellent communication skills in written and verbal both.

Ability to produce the best result in pressure situation.

Ability to work in team as well as an individual

EXPERIENCES:

ECOLAB, MN

Date: Sept 2016– August 2017

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 SQL Server Profiler, Trace, Index tuning wizard and Database Engine Tuning Advisor (DTA).

3M St. Paul MN Date: Oct 2015 – 2016

SQL Server DBA

Responsibilities:

Monitoring and Performance Tuning:

Performed database monitoring and Performance tuning.

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

Extensively used SQL native tools like SQL profiler, Database tuning advisor (DTA), Performance monitor

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

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.

Created Databases, Performed database monitoring, and Performance tuning.

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

Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.

Dakota Premium Foods MN Date Feb 2014 to Oct 2015

Complete documentation about the database. Recovering the databases from backup in disasters.

Export or Import data from other data sources like flat files using Import/Export through DTS.

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

Set up SQL Server configuration settings for better server management.

Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.

Involved in backup and recovery tasks.

Involved in disaster recovery planning.

Implemented database backups and disaster recovery strategies. Developed technical documentation for disaster recovery.

Work beyond regular hours based on business demands. Provided 24x7 on-call production supports.

Managed the migration of SQL Server 2008 databases to SQL Server 2012.

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

Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2012.

Prepared the project management and technical documentation.

Rebuilding the indexes at regular intervals for better performance.

Monitored and modified Performance using execution plans and Index tuning.

Involved in performance monitoring and tuning of the database.

Extensively worked on DBCC commands and Dynamic Management Objects.

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

Date: 2012-2013

Fokou Sarl Cameroon, Africa

SQL server DBA