.

.

DAVID OKON

Email: adlyrn@r.postjobfree.com

Tel: 323-***-****

Location: Los Angeles, CA (Willing to relocate)

SKILLS

A Seasoned SQL Server database administrator with over 6 years of Strong Experience with SQL Server 2005 through 2019 Administration

Interacts with clients, application team and project managers to design, implement and support solutions to meets client need.

Migrated, Installed and Upgraded 2008 R2/ 2012, 2014, 2016,2017 and 2019 database standalone / cluster instance.

Experience in deploying SQL Server Patches (window patches, sql server patch, hot fixes, CU, Service packs)

Provide DBA support and technical expertise for multiple applications in Development, Test, QA, and Production.

Controlling access permissions, privileges, and overall security in a database environment.

• Administering, Managing, developing, and configuring SQL Server database design

• Performance tuning, Query Optimization and Performance Baselining

• Performed Health checks and Automation of routine tasks.

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

• Comprehensive Backup and restore plan working with company SLA.

• Verified backups, check error logs and troubleshoot any failures or alert problems, and open tickets if necessary.

• Experienced in and understanding of SQL Server performance dashboard reports for monitoring.

• Optimized numerous queries by various techniques such as execution plan analysis and re-writing the parts of query resulting in faster timely reports to business users.

• Handling Locks, Deadlocks, Detect CPU, I/O, Memory bottlenecks

• Configured High Availability Solutions- Traditional Clustering, AlwaysOn / Availability Groups and Log Shipping

• Experienced in setting up and managing Always-ON Availability Groups and HA/DR Troubleshooting.

• Experienced in implementing disaster recovery strategy.

• Experienced in using Query Store, SQL Profiler, Extended Events, External monitoring tools.

• Configured and managed Transactional Replication set up.

• Experience in supporting large databases (VLDB) 500GB – 5TB.

• Good knowledge in Virtualized Environments (Hyper V, VMWare)

• Building of Window server clusters.

• Performed Code deployment in production environment.

• Information Risk Management Control (Configured Transparent Data Encryption and Dynamic Data Masking to protect valuable information and data).

• Capacity Planning, diagnosing Job Errors and implementing solutions.

• Performed Database migration from an On-Premises SQL Server Environment to Azure database in the cloud.

• Good T-SQL Writing skills

• Writing Database \ technical documentations including data standards and procedures as required for all projects.

• Experience with incident ticketing systems such as Service NOW.

• An Excellent Team player with a positive ‘CAN DO’ attitude.

·

CERTIFICATIONS

Microsoft Certified Professional

Microsoft Certified Solution Associate

Microsoft Certified Azure Administrator Associate

Microsoft Certified Trainer

.

.

EXPERIENCE

MS SQL Database Administrator / MPIT TECH --- Houston, TX December 2015 - Current

[End Clients: Kodiak Gas, Chevron, XSport Fitness, CDW, HID Global, Sanford Health]

• Installed various versions of SQL Server from 2008 to 2017, applied Service packs and security fixes for all SQL Server and provided database administration support.

• Performed installation of SQL Server using Powershell, and automation of tasks using Powershell.

• Set up a Clustering environment, maintenance and troubleshooting in Active/Passive Environments

• Security compliance and management, controlling access permissions and privileges, grant minimum access privileges to users to maintain security and to attain high ratings in SOC audits.

• Refreshed Production Databases to Dev/Test Environments

• Configured Different levels of database encryptions: Transparent Data Encryption, Dynamic Data Masking

• Performed SQL Server Upgrades (side by side and In-Place upgrades), Patches and Cumulative updates

• Experienced in Table design, Views, Stored Procedures, Functions

• Maintained database response times in 24/7 Production environments, administer and monitor applications and systems, developing automated alerts to warn of failure.

• Migration of databases, Logins, Agent jobs, Maintenance jobs, Stored procedures

• Enabling Log Shipping and setting a DR site synchronizing databases via Log Shipping

• Capacity Planning, Resource allocation and automate maintenance jobs in SQL Server Agents and Task scheduler such as backups, index rebuilding, index reorganize, cleaning up and updating statistics.

• Performance Baselining

• Work with team to review change requests and perform change requests.

• Configured and supported Replication: Transactional replication and Snapshot replication.

• Participating in on call rotation.

• Supports day to day operational duties for the database platform such as Service now requests and tickets, and other tasks as assigned or expected from DBAs.

• Providing support to Cloud based environments: Azure PaaS and IaaS

• Set up Window Server Failover Cluster, Enabling AlwaysON and setting up Availability groups.

• Regular monitoring of servers, which includes backup jobs monitoring, Disk space monitoring, Services monitoring, and blocking monitoring and troubleshooting using SSMS. Developed routine jobs for data integrity check.

• Deploying SSIS packages and providing support to SSRS servers.

• Experience with third party monitoring tools like SolarWinds DPA and Redgate SQL monitor to proactively monitor SQL server state.

• Rebuild, reorganize, and monitor indexes at regular intervals for better performance.

• Query Optimization and performance using in-built and external monitoring tools.

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

• Setup Comprehensive Backup and restore strategy based on company’s RPO and RTO, planning of disaster recovery strategies working with company SLA.

• Check error logs and troubleshoot any failures or alert problems, and open tickets if necessary.

• Documented process for Installation, Clustering, Availability group set up and SQL Server Patching. Jnr SQL Database Administrator / NESLA CONSULTING -- Greenbelt, MD. November 2014 – September 2015

• Monitoring standby databases to ensure high availability.

• Created Triggers for Security check.

• Configured Transparent Data Encryption on mission critical databases.

• Configured Dynamic Data Masking to protect sensitive columns on a table.

• Configured and supported replication and log shipping

• Capacity planning and resource allocation

• Set up and configured database audit and server audit.

• Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database.

• Creating and Modifying Tables, Stored Procedures, Views, Indexes,

• User-define Functions and Triggers etc. as requirement on SQL Server Environments.

.

.

• Installed SQL SERVER 2012 and applied security fixes and patches.

• Documented processes for installations, clustering, availability group setup, and patching. EDUCATION AND TRAINING

BSc: University of PortHarcourt

Electrical \ Electronics Engineering

MCSA: Certificate of completion (Microsoft SQL Server 2016): Certified 2020. Implementation database installation, maintenance, configuration, and provisioning tasks. MICROSOFT CERTIFIED: Azure Administrator Associate MCT: Microsoft Certified Trainer

Contact this candidate