DAVID OKON
Database Administrator / Cloud Engineer
Atlanta,GA
Overview
9
9
years of professional experience
Work History
Database Engineer/ Azure Cloud Engineer
Modaj Pro IT Solutions
03.2024 - Current
- Company Overview: [End Clients: Microsoft]
- Provide database management and server setup support for a wide range of clients
- Deliver personalized solutions for multiple clients, stabilizing environments built with a variety of tools and technologies
- Manage and reduce costs by managing database elastic pools
- Analyzing on-premises cost and Azure cost as per customer requirements
- Develop and implement disaster recovery strategies for efficient crisis management
- Oversee cloud migration projects, ensuring a smooth transition to Azure
- Ensure cloud solutions meet security requirements and comply with industry regulations
- Collaborate with cross-functional teams to maintain high-performing, reliable cloud services
- Work closely with stakeholders to understand business needs and translate them into technical solutions
- Recommend and implement performance monitoring and tuning to optimize databases and cloud infrastructure
- Stay current with emerging cloud technologies and trends to continuously enhance service offerings
- [End Clients: Microsoft]
Snr Database Administrator
Rivian Automotive LLC
07.2022 - 02.2024
- Installed various versions of SQL Server from 2016 to 2019, Patches, Service packs and security fixes applied for all SQL Server and provided database administration support
- Performed installation of SQL Server using PowerShell, and automation of tasks using PowerShell
- Set up Window Server Failover Cluster (WSFC), Enabling AlwaysON and setting up Availability groups
- Security compliance and management, controlling access permissions and privileges, granting minimum access privileges to users to maintain security and attain high ratings in SOC audits
- Refreshed Production Databases to Dev/Test Environments
- Configured Different levels of database encryption: Transparent Data Encryption, Dynamic Data Masking
- Performed SQL Server Upgrades (side by side and In-Place upgrades), Patches and Cumulative updates
- Configured 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 up 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, indexing maintenance strategies, cleaning up and updating statistics
- Performance Baselining
- Set up Table partitioning to manage large tables
- 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
- Developed routine jobs for data integrity check
- Monitor server and instance health and status which includes backup jobs monitoring, disk space monitoring, Services monitoring, and blocking monitoring and troubleshooting using third party monitoring tools like Dynatrace and Datadog
- Set up Index maintenance jobs, rebuild, reorganize, and monitor indexes at regular intervals for better performance
- Setup Comprehensive Backup and restore strategy based on company’s RPO and RTO, planning of disaster recovery strategies working with company SLA
- Query Optimization and performance using in-built and external monitoring tools
- Used SQL Server Profiler, Extended Events, Query Store and performance tuning
- 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
Database Administrator Level 3
Wipro / Citibank
12.2020 - 06.2022
- Managed multiple Data Centre disaster recovery exercises that addressed a broad span of disciplines (On-Premises SQL servers servers, Databases, Storage)
- Update SQL Server Patches and Cumulative Updates
- Configured Disaster recovery solutions
- Performing COB tests quarterly to ensure DR site is functional
- Configured High Availability Solution- Failover Clustering, Always On Availability Groups, Database Mirroring and Log Shipping
- Resolved TempDB bottlenecks, CPU saturation, Memory and IO bottlenecks, deadlocks and locking issues
- Investigate root cause for database related application errors (SQL timeouts, deadlocks, unexpected data condition, etc
- Configured and supported Replication: Transactional replication
- Participating in on call rotation
- Ensured databases adhere to corporate standards and policies, including database auditing
- Capacity Planning and resource allocation
- Good use of Dynamic Management Views (DMVs)
- Monitoring standby Databases to ensure high availability using SolarWinds DPA
- Planning and implementation of Database backup/restore and disaster recovery
- Good use of SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance
- Production level support - On Call 24/7 environment
- Responded to and resolved all database access and performance issues
- Troubleshoot Stored Procs, functions and complex queries
- Configured Database Mail, Operator and Alerts
- Attend to ticket issues using ServiceNow and Jira
- Modifying database structure or deploying schema changes because of new requirements
- Reviewed T-SQL Script before deployment into a production environment
- Configured transparent data encryption on mission critical databases
- Work with team to review change requests and perform change requests
- Support Data warehousing databases
SQL Server Database Administrator
Modaj Pro IT Solutions
12.2015 - 11.2020
- Worked with multiple clients, managed SQL Server Databases On-Prem and Azure SQL Databases and Azure VMs
- Update SQL Server Patches and Cumulative Updates
- Installed various versions of SQL Server from 2012 to 2014, Service packs and security fixes applied for all SQL
- Set up Failover Clustering environment, maintenance and troubleshooting in Active/Passive Environments
- Migration of SQL Server from 2012, 2014 versions to SQL Server 2017
- Migration of databases from On-Prem to Azure SQL database (PaaS) using Data Migration Assistant (DMA)
- Management of Azure and services
- Provision of Azure databases, Elastic pools, Managed Instance and Azure VMs (IaaS)
- DevOps (CI/CD for Databases)
- 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 configure 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 (UDF) and triggers etc
- As requirement on SQL server environments
- Documented processes for installations, clustering, availability group setup, and patching
- Developed routine jobs for data integrity check
- Deploying SSIS packages and installing and providing support to SSRS servers
Education
BSc - Electrical\ Electronics Engineering
University of Portharcourt
MICROSOFT CERTIFIED - Azure Administrator Associate
MCT - Microsoft Certified Trainer
MCSA - Certificate of completion (Microsoft SQL Server 2016)
01.2020
Skills
- SQL Server Administration
- Database Migration
- SQL Server Patches
- DBA Support
- Database Security
- Database Design
- Performance Tuning
- Query Optimization
- Health Checks
- Automation
- Backup and Restore
- Monitoring
- Query Store
- SQL Profiler
- Extended Events
- Replication
- Disaster Recovery
- Virtualized Environments
- Windows Server Clusters
- Information Risk Management
- Capacity Planning
- Azure Management
- T-SQL Writing
- Technical Documentation
- Incident Ticketing Systems
- Power BI
- Tableau
- Task Automation
- Team Collaboration
Timeline
Database Engineer/ Azure Cloud Engineer
Modaj Pro IT Solutions
03.2024 - Current
Snr Database Administrator
Rivian Automotive LLC
07.2022 - 02.2024
Database Administrator Level 3
Wipro / Citibank
12.2020 - 06.2022
SQL Server Database Administrator
Modaj Pro IT Solutions
12.2015 - 11.2020
MICROSOFT CERTIFIED - Azure Administrator Associate
MCT - Microsoft Certified Trainer
MCSA - Certificate of completion (Microsoft SQL Server 2016)
BSc - Electrical\ Electronics Engineering
University of Portharcourt
Similar Profiles
Bret MurrayBret Murray
Shop Owner/operator at Bowler Solutions Pro Shop / Aka Bret's Pro ShopShop Owner/operator at Bowler Solutions Pro Shop / Aka Bret's Pro Shop
Michael Rivera-CentenoMichael Rivera-Centeno
Project Manager at Century Pro SolutionsProject Manager at Century Pro Solutions
APRIL PRESTONAPRIL PRESTON
CNA at 24/7 Pro Solutions Home HealthCNA at 24/7 Pro Solutions Home Health
Abriyah RobinsonAbriyah Robinson
Office Assistant at HHC Medical StaffingOffice Assistant at HHC Medical Staffing
AMAR SEHMIAMAR SEHMI
Senior Software Engineer at BackbaseSenior Software Engineer at Backbase