Summary
Overview
Work History
Education
Skills
Work Availability
Quote
Timeline
Generic

Ikome Monono

Fort Worth,TX

Summary

  • Over 7 years of experience in Database Administration for very large and complex databases in SQL Server 2019,2017,2016, 2014, 2012, 2008, 2005.
  • Performed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, installation, configuration, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution.
  • Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping.
  • Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers as requirement on SQL Server Environments.
  • Planning and implementation of Database backup/restore and disaster recovery
  • Installed SQL Server 2005-2019 on following Microsoft best practices, applied Patches and security fixes.
  • SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.
  • Configured and supported replication and log shipping in both SQL 2008 and 2012.
  • Maintained database response times in 24/7 in Production environments.
  • Monitoring standby Databases to ensure high availability
  • Automation of DBA tasks using PowerShell scripts and monitoring
  • Configured and managed Contained Database
  • Managed and provisioned Azure SQL databases and services.
  • Configured and supported replication and log shipping in both SQL 2008 and 2012.
  • Managed and reduced cost by effectively monitoring the databases elastic pool
  • Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud

Installed and configured MS SQL Server VM in Azure Database

Overview

7
7
years of professional experience

Work History

MS SQL SERVER DBA

EdgeLink
El Segundo , CA
2020.01 - Current
  • Planning the Installation of Microsoft SQL Server 2005SP4, 2008R2, 2012, 2014, 2016, 2017, 2019, building, designing, Configuration, Upgrade, Migration and application of Windows and SQL Patches during scheduled database non production hours to ensure databases are up to date in Virtualized environments
  • Implement and define a vigorous Backup and Recovery strategy and Capacity planning following the company's SLA that is Recovery Point Objective (RPO) and Recovery Time objective( RTO) and the Retention policy
  • Recommend and implement data security by creating users and assigning permissions based on the principle of least privileges and also with technologies such as Always Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure clients sensitive data
  • Using SQL server in-built tools such as SQL Server profiler, Extended Events, activity monitor to monitor performance and system health; Database Integrity checks to ensure database integrity, stability, and system availability.
  • Configured High Availability (HA) and Disaster Recovery (DR) Solutions on production in standalone and Clustered environments such as Always On, Traditional Failover Clustering (Windows Server Failover Cluster - WTFC), Database Mirroring, Replication such as transactional replication and Log Shipping to make sure the databases are always available and participating in disaster recovery.
  • Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlock issues, updating statistics for query optimization using performance and activity monitor, event viewers, extended events.
  • Managing and providing end to end support and problem resolution for SQL Server databases through multiple product lifecycle environments, such as development, testing to mission-critical production systems.
  • Create and update database documentation about company standard procedures, technology features and production issue troubleshooting.
  • Analyze, solve and correct issues in real time and provide end-to-end problem resolution such as hardware and software purchases, server configuration changes and assisting developers with query/index tuning, Partitioning, compression and updating statistics to enhance speed and maximize system performance.
  • Creating and monitoring maintenance plans and agent jobs that automates backups and reorganize/rebuild indexes for query performance.
  • Hands-on database tuning and troubleshooting of SQL Server service outages as they occur, including providing On call support during after-hours and weekends. Providing scheduled maintenance, supporting application deployment, and hardware/software upgrades after hours and 24 x 7 support.
  • Review scripts submitted by the development team and Working with other teams like systems analysts, developers, business analysts, and project teams to perform the capacity planning required to create and maintain the Databases.
  • Control and establish appropriate database user access control levels by provisioning and deprovisioning users based upon company policy to control access for each segment of the Databases. Develop database security guidelines and perform audits.
  • Migrate SQL server databases from on prem to AZURE using Data Migration Assistant.
  • Develop and monitor system and application alerts to ensure Health monitoring and performance tuning
  • Create and maintain azure managed SQL instances and databases

JUNIOR MS SQL SERVER DBA

American Airlines
Fort Worth , TX
2015.05 - 2018.01
  • SQL Database Administrator, Database Programming.
  • resolve highly complex, technical, and escalate support incidents. troubleshoot and diagnosis issues in SQL Server environment.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Rebuilding indexes at regular intervals for better performance in large datasets
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Deploying new code base release to UAT and Production Environments.
  • Perform SQL Server service pack and Windows Service pack upgrades.
  • Working with customers on Application rollouts and server migrations.
  • Extensively worked on Enterprise Manager for managing the database.
  • Troubleshoot performance problems and fine-tuning of databases.
  • Converting DTS packages into SQL Server 2005 Integration Services.
  • Migrating SQL Server 2000 data bases into SQL Server 2005.

MS SQL SERVER DBA

Texas Department Of Criminal Justice
Wichita Falls , TX
2018.02 - 2019.12
  • Manage infrastructure performance, data security and make recommendations for improvements
  • Manage infrastructure performance, data security and make recommendations for improvements
  • Assist in the monitoring and review of Strong analytical, planning, and organizational skills with ability to manage competing demands
  • Involved in the planning, setup and implementation of new servers across the entire enterprise
  • Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database.
  • Planned and deployed monthly windows and SQL server patches.
  • Planning and implementation of Database backup/restore and disaster recovery
  • Create and work on High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Writing basics TSQL scrips, stored procedures, functions and triggers, data transformations using BIDS
  • Implementation of snapshot isolation and DDL triggers
  • Migration of SQL Server 2005 servers to SQL Server 2008
  • Stable Replication Topology
  • Installed SQL Server 2008 on advanced servers, applied security fixes
  • SQL Server Upgrade
  • Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud
  • Installed and configured MS SQL Server 2008 R2, supported all Production and development servers
  • Maintained database response times in 24X7 Production environments
  • Developing SQL scripts for maintaining administration tasks
  • Capacity Planning and resource allocation
  • Monitoring standby databases to ensure high availability
  • Troubleshoot, resolve issues related to computer software and hardware controlling production equipment application
  • Production level support for onsite and offshore Clients
  • Support Patch Management
  • Integrated Temporal Tables

Education

M.D. - Chemical And Natural Gas Engineering

Texas A&M University - Kingsville
Kingsville, TX
12.2019

Bachelor of Science - Geology

University of Buea
Cameroon
12.2011

MS SQL SERVER DBA And TSQL

Empire Data System
Texas
12.2014

Skills

  • Microsoft SQL server 2005, 2012, 2014, 2016, 2017, 2019
  • Windows server 2008, 2012, 2012 r2, 2016, 2019
  • Microsoft office suite (Word, Excel, power point, office 365)
  • Windows Remote Desktop
  • Service manager
  • Service Now
  • Active directory
  • Windows (7,8,10)
  • Hyper-V, VMware Workstation
  • Solarwind
  • Jira
  • SQL Server Tools SSMS, Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS, SSASRDBMS MS SQL server 2005/2008/2012, MS Access, ETL DTS, SSIS

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins

Timeline

MS SQL SERVER DBA

EdgeLink
2020.01 - Current

MS SQL SERVER DBA

Texas Department Of Criminal Justice
2018.02 - 2019.12

JUNIOR MS SQL SERVER DBA

American Airlines
2015.05 - 2018.01

M.D. - Chemical And Natural Gas Engineering

Texas A&M University - Kingsville

Bachelor of Science - Geology

University of Buea

MS SQL SERVER DBA And TSQL

Empire Data System
Ikome Monono