SQL SERVER DATABASE ADMINISTRATION

Name : JERMAIN ARREY

Houston TX

Cell : 302-***-****

Email : ac7nn9@r.postjobfree.com

Green Card Holder Authorize to work for any employer

SQL Server DBA with over 4 years of IT experience in Maintenance, Automation of jobs, Backup, Recovery and Disaster recovery procedures, Design, Development, Installation, Configuration, Performance Tuning, Query Optimization, Client/Server Connectivity and Consistency Check, security and Implementing HADR solutions in Production, QA, Development environments. Managed SQL Server database upgrading, migrations and development in production and non-production environments. I am dedicated, hard working team player who can work both under stress / as part team to resolve complex database task and project while meeting datelines.

SQL SERVER DBA

State Farm

Houston TX

February2016 – September 2018

Responsibilities:

Expertise experience in installing new instances of SQL Server 2008/2008R2/2012/2014/2016 on Microsoft Windows Server 2012 R2/ 2008 following best practices.

Manage and administer over 100+ database in both SQL Server standalone and cluster servers,

Highly experience on handling VLDB ranging very 500gb to 80T on different database VM/ Physical servers.

Installed and administered 2-Node cluster on Microsoft Windows Server 2012 R2 Enterprise Edition on SAN environment setup Active / Passive mode

Strong experience in Database Normalization, Optimization and Tuning, Backup/Restore, Troubleshooting, and Data Import/Export.

Expertise in designing and implementing the processes and standards for database systems recovery and back-up checks as well as user performance and data security.

Updated database systems by reviewing, planning, testing and installing database security patches and service packs.

Expertise in troubleshooting SQL Server Agent jobs, Error Logs, Windows Logs to resolve failure job component.

Upgraded / Migrated SQL Server PROD/DEV/TEST database from SQL 2008 to 2012 and from 2012 to 2014 following best practice.

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

Strong experience using DMVs, DBCCs and SPs from SQL Server 2008R2 to 2014 for checking database health and performance.

Expertise in monitoring performance using SQL Profiler, Activity Monitor, Perfmon inorder to find locking, blocking and deadlock issues and for database performance optimization

Expertise in planning and manage database administration projects including data archiving, patching, hot fixes and service pack upgrades.

Experienced in recovering the databases from disasters and implemented Point-In-Time Recovery solution.

Automated daily tasks including backup and restore by using SQL Server 2008/2008R2/2012 native SSMS tools as well as TSQL scripts.

Expertise with HADR solution such as Always On, Cluster, Mirroring and Log Shipping.

Experienced in advising Developers in fine tuning and rewriting and restructuring store procedures and views with T-SQL.

Expertise in writing technical reports for the management and for other of Production support.

Provided 24x7 production support for critical Production SQL Server databases

Environment: MS SQL Server 2014/2012/2008R2, T-SQL, SSIS, Asana, Red-gate, LiteSpeed,, SQL Profiler, Performance monitor, BCP, Log Shipping, Mirroring, Clustering, Windows Server 2012R2, .Net Framework, C#.Net, JavaScript, MS TFS, MS-Access, SharePoint 2010, Oracle 10g, IIS 6.5,7.5, 8.0, SolarWinds, and PAL tool.

SQL SERVER DBA

Pros Holding Inc

Houston, TX

January 2014 – February 2016

Responsibilities

Experience in Installing, Configuring, Administration and Maintenance of more than 200 huge and mission critical client databases in SQL Server 2008R2, 2008, 2012, 2014 and 2016 versions.

Experience in working on Very Large Databases (VLDB) over 40 TB for OLTP.

Extensive Experience in Upgrading / Migration to SQL Server (In place Up gradation and Side by side Up gradation) based on application compatibility and fixing the orphan users.

Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users.

Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using the ticketing tool Service Now

Experience in implementing database Audit procedures and SOX compliance.

Experience in managing the SQL monitoring tool i.e. SCOM, Remedy and Nagios

Participated in quarterly database DR Exercises

Good Experience in database / server capacity planning

Good experience with implementing and troubleshooting High Availability of database servers using Log Shipping, Database Mirroring, failover clustering and HA/Always ON.

Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans and Database Mail Configuration.

Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues using different tools like SQL Profilers, Perf mon, Activity Monitor, Resource Monitor, store Procedures and DMV’s

Administer, maintain, develops and recommends policies and procedures for ensuring the security and integrity of the company's databases.

Performed Backup and recovery & Automation of Backups using maintenance plans.

Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Responsible routine DBA jobs like Backups and Restores.

Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment

Experience in deploying / applying SQL Server Service packs and Hot Fixes

Managing and administrating tasks in SQL server using TSQL scripts.

Basic knowledge in AWS Relational Database Management system, Azure SQL servers and EC2.

Responsible for performance tuning of stored procedures and queries using SQL Profiler, Database Tuning wizard and Query Store.

Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.

Experience on configuring and maintaining automation strategies like Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index optimization and index maintenance like index rebuild, index reorganize based on fragmentation.

Work as part of a team of 6 DBAs in and 24/7 on call rotation.

Environment: SQL Server 2008/2008 R2/2012/2014 Enterprise Edition with Clustering environment that includes Production (24x7), Logshipping, Mirroring, Always On, Migration, ETL, Microsoft, Windows /2003/2008R2/2012 Server, SSIS, Erwin, Visual studio

Contact this candidate