Data Security

PATRICK DAMISA

Cell: 501-***-**** *********@*****.***

Highly skilled database administration professional with over 5 years hands on experience in SQL Server 2008 through 2016. My key strengths are performance tuning, capacity planning, high availability and disaster recovery solution. Offering support in a 24/7 production environment and handling project for database technology in designing, developing and implementing databases.

Translating business requirements into conceptual, logical and physical data models

Administering, Managing, Developing and configuring SQL Server database design

Performance tuning, Query Optimization and Performance

Production level support for onsite and offshore - On Call 24/7 Environment

SQL Server Performance Dashboard Reports for Monitoring

Handling Locks, Deadlocks, Detect CPU, I/O, Memory Bottlenecks

High Availability Solution - Clustering, Database

Mirroring and Log Shipping

Disaster Recovery Strategy

Performed Data Transfer/Migration using Export/Import and

Azure migration/Deployment of virtual machines and configuring Alwayson.

Managing complex add-ons in (SQL Server 2000- 2016)

Query Store, SSMS, SQL Profiler, Extended Events, etc.

Replication Models (Snapshot/Transactional/Merge)

Clustering Setup in Azure and Onpremises, Troubleshooting and Management

Good T-SQL Writing skills

Configuring Virtual machines scale set

Diagnosing Job Errors and implementing solutions

OMNI HOTELS & RESORT DALLAS, TX January 2020- September 2020

SQL SERVER

Installed SQL Server 2008 on advanced servers, applied security fixes,

Upgrade SQL Server 2005 Servers to SQL Server 2008

Use of wherescape for Data Warehouse and Automation

ETL packages from load, stage, and target tables

Capacity Planning and resource allocation

Monitoring standby databases to ensure high availability

Experience with Transparent Data Encryption (TDE).

Monitoring databases and troubleshooting SQL Server performance issues

Managing Server and database security and identity

SQL Auditing/ solving 'sa' user password issues

Server restart

Troubleshoot and Modify stored procedure in wherescape

Troubleshoot failed/long running SQL Server and wherescape jobs.

SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance

Support in server Production maintenance windows

Automate maintenance jobs in SQL Server Agents and Task scheduler such as back up database, index rebuilding, index.

Power BI backend admin/User (in charge of data refresh and workspaces)

Server Health Check: space. Memory, and performance

MPIT GROUP HOUSTON, TX

SQL SERVER DBA/ PRODUCTION SUPPORT February 2019 – November 2019

Production, Development, and project Support

Replication Analysis and implantation

Clustering maintenance and troubleshooting.

Security compliance and management

User/Group/role management for relevant database instances.

Responsible for HA and Backup/restoration strategies for database environment

Controlling access permissions and privileges

Different levels of encryption

Plan and implement best migration strategy from on premises to Cloud.

Worked on Side-by-Side migration from SQL Server 2000/2005/2008 to SQL Server 2012

Automation Implementation

Managing Virtual machines scale sets and permissions in Azure

SQL Installation, troubleshooting complex Installation issues, SQL Server Upgrades

Query Optimization and performance

Used Transparent Database Encryption (TDE) for encrypting data sensitive databases.

Environmental stability

Ensuring data recovery, maintenance, Data integrity and space requirements for physical database

Deployment of virtual machines in cloud (Azure)

Capacity Planning

organizing, cleaning up and updating statistics

REFRESCO (COTT BEVERAGES) ARLINGTON, TX

SQL SERVER DBA 2017 - 2018

Troubleshooting client connectivity

Applied Service packs and security fixes for all SQL Server and provided database administration support.

SQL Server Performance Dashboard Reports for Monitoring

Integrated Temporal Tables

Performance Baselining

Manage indexes to improve performance.

Schedule jobs using SQL Server Agent

Developed routine jobs for data integrity check.

Code deployment into Production

Information Risk Management Control

Experience in Windows Azure, migrating database to Azure.

Tables Design, views, Stored procedures, Function etc.

Installed and configured MS SQL Server 2008 R2, supported all Production and development servers.

Maintained database response times in 24X7 Production environments.

CONAGRA FOODS RUSSELLVILLE, AR

SQL SERVER DBA/TRAINEE ADMINISTRATOR 2015 - 2017

Managing Firewall Rule, Triggers, Row version, Temporal Tables, Change Data Capture (CDC) etc.

Column Store Index for performance

Contained Databases

Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.

Task Automation

Indexes Maintenance

Stabilized Performance

SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance

Implementation of snapshot isolation and DDL trigger

Stable Replication Topology

Comprehensive Backup plan and disaster recovery strategies

BACHELOR OF SCIENCE: ECONOMICS 2002/2004 – 2008/2009

Ambrose Ali University

MASTER OF SCIENCE: EMERGENCY MANAGEMENT AND HOMELAND SECURITY(Ongoing) 2015 - Present

Arkansas Tech University

Modajpro7 Institute of Technology (Training)

Certificate Issued by the State of Arkansas: Applied Mathematics, locating Information and Readiness for Information

Certificate in Windows System Administration: Nigerian Institute of Information Technology Lagos Nigeria AUGUST 2004 – FEBRUARY 2005

Microsoft Certified System Administrator (MCSA)

Microsoft Certified Solutions Expert: Data Management and Analytics (MCSE)

Contact this candidate