Jim Akhere Okoduwa

Senior SQL Database Administrator

Jonesboro, AR

US Citizen

ad3pcm@r.postjobfree.com 404-***-****

https://www.linkedin.com/in/jim-okoduwa-513382226?

PROFESSIONAL SUMMARY

•Experienced and results-driven Senior Database Administrator Professional with strong organizational and interpersonal skills.

•Proven track record of providing accurate and comprehensive database solutions.

•Over 13 years’ experience performing as a DBA resolving outages and implementing code deployments into TEST, DEV, PROD environments.

•Extensive experience in MS SQL Server including SQL Server 2000, 2008, 2008R2, 2012, 2014, and 2016 - 2019, 20 standalone and High Availability (HA) solutions.

•Skilled in failover clustering, database mirroring, log shipping, and replication.

•Strong troubleshooting and analytical skills.

.

TECHNICAL SKILLS

Databases

Azure SQL, Azure Data Factory, AWS RDS, MS SQL Server 2019, 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7; Oracle 11G, 10G, 9i, 8i

Languages / Scripting

SQL, T-SQL, shell

Operating Systems

Linux, Windows

Tools

SQL Loader, SQL Backup, SQL Analyzer, SQL Debugger, SQL Sentry, SQL Enterprise Manager, Space Manager, Idera, DBArtisan, SQL LiteSpeed, Spotlight, MS BI Suite (SSAS, SSIS, SSRS), Toad, ServiceNow, MS Office

COMPETENCIES

•AlwaysOn

•Business Intelligence (BI)

•Change Management

•Cloud Computing / Azure

•Cluster Analysis

•Configuration

•Connectivity

•Data Architecture

•Data Integration

•Data Migration

•Data Mirroring

•Data Modeling

•Database Administration

•Database Design

•Database Security

•Database Upgrades

•Disaster Recovery

•Documentation

•Failover Clusters

•Grid Controls

•High Availability (HA)

•Log Shipping

•Maintenance

•Patch Management

•Performance Tuning

•Process Control

•Replication

•Scripting

Troubleshooting

PROFESSIONAL EXPERIENCE

Access Holdings International – June 2023 Till Date

Database Administrator

Provided Primary DBA (Database Administration) responsibilities including support of the various application development teams through advising on design, implementing solutions and optimizing databases for the applications.

Worked as a MS SQL Server expert for the firm.

Evaluated and Adopted features in new releases of the MS SQL Server product.

Worked closely with Engineers across all Business Units to design, develop and optimize databases for diverse application workloads.

Monitored SQL performance.

Protected the database against threats or unauthorized access.

Regularly worked with ITR leadership, ITR solutions team and the ITR Technical Services Team

Worked closely with ITR solution team in the design of databases and the ongoing performance of queries, stored procedures, and views.

Ensured that the database server is adequately backed up.

Developed, implemented, Database Recovery Plan

Vertisystem Inc. - Las Vegas, NV January 2022 – June 2022

Database Administrator Consultant

Vertisystem is a Cloud Solutions Provider specializing in Data Solutions, Data Warehouse Solutions, Application Modernization and Cloud Migration.

Tasks and Responsibilities:

supported both daily operations and development initiatives. As a SQL Server DBA, I Collaborated with diverse teams (web devs, network team, business analysts) to ensure AGR's ERP system (NetSuite) and auxiliary systems ran smoothly and efficiently.

I used shell scripting when I administered Oracle on Unix-Linux platform.

•Performed all duties and responsibilities of a SQL Database Administrator including, but was not limited to, installation and configuration, backup and recovery, performance tuning and troubleshooting, query analysis and optimization, Azure SQL Database administration, and security implementation.

•Responded to and resolved requests from users related to database issues.

•Provided proactive monitoring of the environment, resolved alerts, and assigned tickets.

•Worked on MS SQL Server versions 2008 - 2022 with clustering.

•Granted privileges, such as user access and permissions and role-based access controls.

•Implemented change management controls and virtualization with high-level proficiency in Active Directory.

•Leveraged knowledge in implementation of Windows operating system, applications, networking, and storage.

Client: Aristocrat Technologies, Inc. - Las Vegas, NV April 2021 – December 2021

Database Administrator Consultant

Aristocrat Technologies designs, manufactures, and markets gaming machines, progressive systems, and casino management systems. They serve class III gaming establishments in North America, Latin America, and the Caribbean.

Tasks and Responsibilities:

•Installed, configured, maintained, monitored, and administered SQL Server databases, managed performance tuning of database hardware and software, conducted troubleshooting, security implementation, and responded to and resolved requests from users relating to database issues.

•Managed day-to-day operational support of Development, Test and Production database environments, including backup and recovery of production systems, and cloning of databases to non-production systems, on a scheduled and ad-hoc basis as required.

•Implemented Azure SQL Database Administration, Data Factory.

•Responsible for query analysis, performance, and tuning recommendations, including plan analysis, index recommendations, and database server configurations.

•Collaborated with application teams in the design and implementation of database schemas to meet business objectives and technical requirements.

•Monitored and reported project status to ensure that projects were completed on time and within budget.

•Participated in rotation of on-call duties for 24x7 support.

Client: Lagical Point Technology - Marlton, NJ November 2016 – April 2021

Database Administrator Consultant (remote)

Lagical Point Technology is an IT Consulting and Service Integration company serving clients throughout the US.

Tasks and Responsibilities:

•Performed installation and configuration of MS SQL Server database, backup and recovery, on-prem to on-prem database migrations and database upgrades, performance tuning and troubleshooting, query optimization, and capacity planning.

•Conducted patching and (HA) solutions of SQL Server which included failover clustering, database mirroring, log-shipping, replication, AlwaysOn availability groups implementation, and ticket resolutions.

•Proficient in the implementation of PII (Personally Identifiable Information) data security standards which could be used to identify, locate, or contact an individual including such information as name, date of birth, place of residence, credit card information, phone number, race, gender, criminal record, age, and medical records. Implemented Code deployment/Code migration coupled with high level T-SQL proficiency.

•Responded to user alerts and requests and performed proactive monitoring of SQL Server databases.

Client: Marquette University - Milwaukee, WI September 2016 - November 2016

Database Administrator Consultant (remote)

Marquette is a Catholic, Jesuit university with more than 11,000 undergraduate and graduate students in 11 nationally and internationally recognized colleges and schools. Marquette was established in 1881.

Tasks and Responsibilities:

•Created and configured SQL Server database, backup and recovery, database migration, database upgrade, performance tuning and troubleshooting, capacity planning and patching.

•High-level proficiency in Azure SQL Database administration.

•Managed security implementation and all high-availability solutions of SQL Server which included failover clustering, database mirroring, log-shipping and replication, and AlwaysOn availability groups.

Client: Station Casinos, LLC - Las Vegas, NV March 2016 – August 2016

Database Administrator Consulting (onsite)

Station Casinos is an American hotel and casino company based in a suburb of Las Vegas. Station Casinos, along with Affinity Gaming, Boyd Gaming, and Golden Entertainment, dominate the local casino market in Las Vegas, Nevada.

Tasks and Responsibilities:

•Manage database migration, code deployments, backup and recovery, database upgrade, performance tuning and optimization, troubleshooting and error resolution, database login creations and granting of privileges for OLTP, OLAP.

•Worked extensively with SQL LiteSpeed, Spotlite, and SQL database security.

•Monitored and tuned multiple SQL Server databases (versions 2005, 2008, 2008 R2, 2012, 2014).

Client: Johnson Controls International - Milwaukee, WI March 2014 – March 2016

Database Administrator Consultant (onsite)

Johnson Controls is a technology and multi-industrial company that engineers, develops, manufactures, and installs building products and systems. Johnson Controls is a world leader in smart buildings.

Tasks and Responsibilities:

•Provided online support and configuration of SQL Server database. Handled performance tuning, backup and recovery, and all high-availability solution work for SQL Server which included failover cluster, database mirroring, log shipping, and extensive replication efforts.

•Assisted with training and provided knowledge transfer to offshore DBA support.

•Engaged in diagnosing and fixing slow running queries by modifying the design, resolving parallel issues of fragmentation, and too many indexes.

•Performed troubleshooting and problem resolution, deploying, and upgrading engines and clients using T-SQL, stored procedures, triggers, views, constraints, and cursors.

•Worked with the MS BI product tool suite SSRS, SSAS, SSIS.

•Provided configurations, monitoring and on-call support for development, test, and production environments.

•Supported migrations and coded stored procedures and triggers.

•Provided 24 x 7 production, staging, and development database support and ensured that all critical database problems were resolved in a timely manner.

•Initiated discussions with users or external groups to resolve issues.

•Provided technical knowledge to junior team members, System Analysts, and Application Developers.

•Identified opportunities for continuous improvement in performance, automation, and exception processes. Assisted in developing departmental technical policies and procedures.

•Experienced in capacity management and performance tuning of databases. Provided problem diagnosis and resolution with minimal business impact.

•Worked with SQL Server 2000, 2008, and 2012 standalone and high availability (HA) systems such as standard SQL Server clustering and availability groups.

•Used T-SQL in triggers, stored procedures, views, etc., backups, change data capture, and extended events.

Client: Xerox Corporation - Webster, NY December 2013 – December 2014

Database Administrator Consultant (onsite)

Xerox is a provider of document management and business equipment solutions. The company's major products include copiers, sensors, printers, scanners, and digital presses.

Tasks and Responsibilities:

•Worked in Windows 2008 and 2012 environments.

•Implemented preservation of data integrity (e.g., referential integrity).

•Implemented the requirements for different types of applications (e.g., OLTP vs. Reporting) database disk utilization and performance tuning concepts and tools.

•Worked with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

•Implemented disaster recovery (DR), backup and recovery. Worked with SQL Server 2005/2008 standby and clustered databases.

•Managed multi-TB production databases both standby and clustered systems using ACTIVE-PASSIVE clustering.

•Managed and maximized availability of database arsenal to minimize both planned and unplanned downtime with SQL Server database mirroring. Logical and physical database modeling.

•Used Oracle Data Guard to synchronize primary with standby databases.

•Configured and supported databases (SQL, T-SQL tuning, application tuning etc.) and database cloning for SQL Server 2000/2005/2008r2/2012/2014.

•Used Query Analyzer and Profiler to tune SQL Server 2000/2005/2008 R2/2012/2014 databases.

Client: SuperValu, Inc. - Boise, ID December 2012 – December 2013

Database Administrator Consultant (onsite)

SuperValu was an American wholesaler and retailer of grocery products. SuperValu was acquired by United Natural Foods (UNFI) in 2019, one of the largest distributors of natural food products in the United States and Canada.

Tasks and Responsibilities:

•Partnered with offshore DBA resources thoroughly documenting processes to ensure successful implementation by offshore staff and Production Control. Managed and ensured database objects (views, stored procedures, triggers, constraints, etc.) and SQL statements to insure performance and security objectives.

•Maintained the integrity of data within the production environment including the execution of proper backup and restoration policies and procedures which provided point-in-time restore capabilities.

•Provided development and testing support to programmers and engineers to efficiently utilize databases. Determined security user access levels and application security models. Implementation of database schema level objects to support logical/physical model. Insured Oracle DBA best practices (e.g., schema management, index optimization, and use of hints. Managed the on-site backup and recovery process and / or support of the off-site backup and recovery team.

•Created, configured, maintained, and supported SQL Server 2005 and SQL Server 2008 systems. Built high availability systems by using clustering, mirroring. Researched and resolved SQL Server software and database issues. Established and maintained backup and recovery processes. Worked with BMC Patrol for SQL Server. Worked extensively with SQL LiteSpeed. Worked extensively with SQL database security. Monitoring and tuning of SQL Server 2005 & 2008 system.

•Worked with T-SQL, stored procedures, triggers, views, constraints, and cursors.

•Logical and physical database design, performance tuning, scalability, and query monitoring with high proficiency. Backup recovery, high availability/Cluster and DR. Extensive Replication. Provided configuration, monitoring and on-call support for development, test, and production environments.

•Provided 24 x 7 production, staging, and development database support and ensured that all critical database problems were resolved in a timely manner. Initiated discussions with users and external groups to resolve issues. Provided technical knowledge to junior team members, system analysts, and application developers.

Client: Verizon Communications, Inc. - Dallas, TX December 2010 – December 2012

Database Administrator Consultant (onsite)

Tasks and Responsibilities:

•Performed health checks as they pertained to performance tuning, backup and recovery, etc. in a heterogeneous environment.

•Supported SQL Server 2000, 2008, 2012 standalone and high availability (HA) systems such as standard SQL Server clustering and availability groups.

•Performed advanced level T-SQL including triggers, stored procedure, views, etc. database backups, change data capture, and extended events.

•Worked on preservation of data integrity (e.g., referential integrity) and preservation of the requirements for differing types of applications (e.g., OLTP vs. Reporting).

•Managed database disk utilization and performance tuning concepts and tools.

•Worked with SSIS, SSAS, and SSRS.

•Performed database automation tasks using Windows and UNIX shell scripts. SQL Server databases, T-SQL, performance tuning, database design and data warehousing.

•Managed large volume data extraction, transformation, and loading (ETL) logic and tools.

•Supported cross-platform database migration and database instance consolidation.

•Supported database upgrades and applied hot patches.

•Created, monitored, managed backup and recovery, and tuned SQL Server 2000/2005/2008 R2 databases in a multi-platform environment.

•Identified opportunities for continuous improvement in performance, automation, and exception processes.

•Assisted in developing departmental technical policies and procedures. Capacity management and performance tuning. Provided problem diagnosis and resolution with minimal business impact.

•Worked with SQL Server 2000, 2008, 2012 standalone and high availability systems such as standard SQL Server clustering and availability groups.

•Worked with T-SQL including triggers, stored procedure, views, etc.

•Performed database backups, change data capture, and extended events.

•Worked in Windows 2008 and/or 2012 environments. Preserved data integrity (e.g., referential integrity).

•Gained understanding of the requirements for differing types of applications (e.g., OLTP vs. Reporting). Database disk utilization and performance tuning concepts and tools.

•Performed SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services. Implemented disaster recovery (DR). SQL Server 2005/2008 standby/clustered databases. Implemented backup and recovery in SQL Server.

•Experienced in managing multi-terabyte production databases both Standby and Clustered systems using Active-Passive clustering. Managed and maximized the availability of the database arsenal to minimize both planned and unplanned downtime with SQL Server database mirroring. Logical and physical database modeling.

•Used Oracle Data Guard to synchronize primary with standby databases. Configured and supported database (SQL, T-SQL tuning, etc.). SQL Server 2000/2005/2008 R2 database cloning. Used Query Analyzer and Profiler to tune SQL Server 2000/2005/2008 R2 databases.

Pacific Systems, Inc. December 2007 – December 2010

Database Administrator

Tasks and Responsibilities:

•Maintained, administered, and monitored, production Oracle databases.

•Implemented Oracle database maintenance tasks.

•Performed database upgrades, working with project managers, and managing individual upgrade projects.

•Implemented backup and recovery using RMAN. Applied patches and upgraded database versions.

•Installed and built database structures. Developed and maintained shell scripts.

•Developed high-performance relational databases to store scientific, inventory, and transactional data.

•Collaborated with development and administration teams on the design, implementation, and management of database services, data stores, stored procedures, and replication.

•Provided recommendations and design considerations for database table and query design.

•Managed the design and implementation of security and data access methods to ensure services were properly controlled, monitored, and audited.

•Developed/implemented maintenance and administration procedures for database systems, including the usage of metrics, to ensure optimal performance.

•Proactively monitored database statuses to determine early warning signs of issues and optimize performance.

•Investigated performance anomalies, performed root cause analysis for database and interface issues, and improved database performance to optimal levels.

•Established summarized and scalable data schemas to deliver high-performance historical reporting and near-real-time data feeds.

•Authored, documented, and maintained scripts to perform aspects of data management/system administration.

•Created, documented, and maintained data schema and data dictionaries.

•Ensured backups were performed regularly on all databases.

•Evaluated new technologies, frameworks, and methodologies to scale our data infrastructure for future customer growth and new products.

EDUCATION

•Bachelor of Science in Economics (BS) University of Benin, Benin City, Edo State, Nigeria

•Bachelor of Science in Nursing (BSN) (incomplete) Indiana University Northwest, Gary IN & Marian University Indianapolis, IN (3-years completed)

Contact this candidate