Rodedrick Ikhane

Database Migration & Administration

• Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
• Administer and supporting Microsoft SQL Server Oracle, MySQL database systems.
• Managed cloud-based databases (AWS), ensuring scalability, performance, and high availability.
• Led the deployment, configuration and maintenance of cloud databases, optimizing for cost and efficiency.
• Performed proactive monitoring and maintenance to ensure database health, minimizing downtime and reducing operational costs.

Security & Access Management

• Set up and controlled user access levels across databases, ensuring data protection and compliance.
• Implemented robust security measures to protect critical business data and ensure system integrity.
• Managed user profiles and access rights to safeguard sensitive data.

Optimization & Troubleshooting

• Streamlined backup and recovery processes, improving system stability and availability.
• Reduced data retrieval times and optimized performance through indexing and stored procedure optimization.
• Provided timely resolution of production issues, minimizing downtime and mitigating revenue loss.
• Standardized database object naming conventions, simplifying management and troubleshooting.

Collaboration & Documentation

• Collaborated with cross-functional teams to design custom applications and meet business objectives.
• Developed comprehensive documentation for database architecture, simplifying future upgrades and maintenance.
• Worked with stakeholders to determine optimal database specifications based on business requirements.

Disaster Recovery & High Availability

• Ensured high availability by implementing disaster recovery strategies and failover systems.
• Regularly tested and updated backup strategies, ensuring minimal downtime during failures.
• Administered database management systems to ensure optimal performance and reliability.
• Implemented backup and recovery plans to safeguard data integrity and availability.
• Developed and maintained documentation for database configurations and processes.
• Monitored system performance, identifying areas for improvement and optimization.
• Collaborated with cross functional teams to support application development needs.
• Led initiatives to streamline database operations, enhancing efficiency across departments.
• Evaluated new technologies to improve database functionality and user experience.
• Streamlined backup and recovery processes, enhancing overall system stability and availability.
• Ensured database security with implementation of role-based access control and regular vulnerability assessments.
• Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
• Built databases and table structures for web applications.
• Set up and controlled user profiles and access levels for each database segment to protect important data.
• Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.
• Modified databases to meet needs and goals determined during planning process.
• Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Set up and controlled user access levels across databases to protect important data.
• Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.
• Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
• Created and updated database designs and data models.
• Collaborated with cross functional teams to develop custom applications that supported business objectives and met user needs.
• Evaluated emerging technologies to identify opportunities for improving database operations and reducing costs.
• Developed scripts and processes for data integration and maintenance.
• Standardized database object naming conventions across multiple systems, resulting in easier management of objects during troubleshooting sessions.
• Developed comprehensive documentation on database architecture, simplifying future upgrades and maintenance tasks.

Database Administration & Optimization

• Proposed and implemented database changes to streamline monitoring and reduce administrative effort.
• Developed automated processes to support database creation and management in virtualized and cloud environments.
• Monitored, analyzed, and optimized database activity, proactively identifying performance issues and recommending improvements.
• Designed, tested, and implemented comprehensive backup and recovery strategies for OLTP and DSS applications, ensuring 24/7 database availability.
• Generated and analyzed STATSPACK reports to fine-tune performance and resolve database issues in real time.
• Led migrations and upgrades from Oracle 10G to 11G and 12C to 19C, ensuring seamless transitions across both Windows/Unix environments.

Collaboration & Cross-Functional Support

• Fostered strong working relationships with cross-functional teams to understand IT requirements and provide DBA support for various applications.
• Liaised with system administrators to monitor, troubleshoot, and resolve database incidents, ensuring minimal disruption to services.
• Provided resources and expertise to support DBA functions and work closely with third-party vendors and customers.

Security & User Access Management

• Set up and controlled user access levels to secure sensitive data across databases.
• Managed security administration, including user creation, role management, and privilege granting for database access.

Database Design & Development

• Designed and developed analytical data structures, ensuring efficient data processing for business intelligence applications.
• Created and maintained database schemas, including tablespaces, tables, views, and indexes, for OLTP and OLAP systems.
• Allocated system storage and planned for future growth, ensuring database scalability.

Incident Management & Troubleshooting

• Played a key role in situation management of incidents, minimizing production downtime and resolving database issues efficiently.
• Recovered databases from corrupted or lost data files in real-time, ensuring business continuity.
• Administered Oracle databases, ensuring optimal performance and availability across multiple environments.
• Developed and implemented backup and recovery strategies to protect critical data assets.
• Monitored system performance, diagnosing issues to enhance database efficiency and reliability.
• Collaborated with development teams to optimize SQL queries and improve application performance.
• Implemented security measures, managing user access to safeguard sensitive information within databases.
• Led database migration projects, streamlining processes for seamless transitions between systems.
• Conducted regular audits of database configurations, identifying opportunities for improvement and compliance adherence.
• Assisted in migrating databases to newer versions or alternate platforms, minimizing disruption to business operations.
• Conducted regular performance audits, identifying areas for improvement and adjusting configurations as needed.
• Troubleshot database issues to create and resolve trouble tickets.
• Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
• Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
• Reviewed database design to recommend enhancements or improvements.
• Worked with customers and other third parties to support DBA functions.
• Developed automated processes to manage database creation in virtualized or cloud environment.
• Provided resources and skill sets to support DBA functions for applications.
• Proposed database changes to ease monitoring and administrative effort.
• Participated in situation management of incidents to support database operations.
• Established working relationships across various departments to understand existing and emerging IT requirements.
• Streamlined backup processes, ensuring timely recovery in case of data loss or system failure.
• Served as a subject matter expert in meetings with stakeholders discussing project requirements related to Oracle Databases integration.
• Improved database performance by optimizing SQL queries and implementing indexing strategies.
• Provided technical support to end users, troubleshooting database related issues and offering guidance on best practices.

• Provided resources and skill sets to support DBA functions for applications.
• Proposed database changes to ease monitoring and administrative effort.
• Established working relationships across various departments to understand existing and emerging IT requirements.
• Involved in the continuous enhancements and fixing of production problems. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
• Recovered databases from corrupted/lost data files on production systems.
• Installed and Configured Oracle on both Windows and Linux Server.
• Reviewed database design to recommend enhancements or improvements.
• Responsible for Logical/HOT/Cold backup of Oracle Databases.
• Database patching and upgrade support.
• Follows, defines and manages enterprise level policies and procedures that ensure security, optimization and integrity of Oracle database environments.
• Designs, implements and maintains physical and logical database solutions.
• Anticipates and resolves database performance, capacity and replication issues.
• Diagnose and address database performance issues.
• Managed database backup & recovery procedures, disaster recovery preparation and the associated exercises.
• Collaborates with SAN (Storage Area Network – disk behind servers), server, applications and operational staff in support of database objectives.
• Assist development staff with application design and efficient use of database technology.
• Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
• Troubleshot database issues to create and resolve trouble tickets.
• Developed automated processes to manage database creation in virtualized or cloud environment.
• Conducted tests to identify issues and make necessary modifications.
• · Supports project plans and schedules relative to database requirements
• Administered Oracle databases ensuring optimal performance and availability for supply chain operations.
• Implemented backup and recovery strategies to safeguard critical data integrity and accessibility.
• Optimized query performance through tuning and indexing to enhance application efficiency.
• Led database migration projects, streamlining transitions between environments with minimal disruption.
• Developed and maintained database security protocols to protect sensitive information from unauthorized access.
• Mentored junior DBAs, fostering skill development and enhancing team productivity in database management tasks.
• Streamlined database administration tasks through the creation of custom scripts and automation tools, increasing productivity.

• Provided resources and skill sets to support DBA functions for applications.
• Installing and configured Oracle Enterprise Manager (OEM) / Grid Control for monitoring and administrative tasks purposes.
• Responsible for all post migration analysis and tuning.
• Installed and configured Oracle Data Guard on standby servers to online transfer and apply archived log files to keep standby server in sync with primary database.
• Administered Oracle databases, ensuring optimal performance and uptime for retail applications.
• Implemented backup and recovery strategies to safeguard critical data integrity.
• Monitored database health using performance tuning techniques, proactively resolving issues before impact.
• Maintained up-to-date documentation on database systems, ensuring accurate records of configurations, processes, and changes made over time.
• Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
• Participated in situation management of incidents to support database operations.
• Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
• Troubleshot database issues to create and resolve trouble tickets.
• Developed and updated databases to handle customer data.
• Installed and configured middleware in Linux and Windows environments.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Set up and controlled user access levels across databases to protect important data.
• 24 X 7 Production Support. Responsible for Backup & Recovery for Oracle Database.
• Adhered to set schedules to test databases for flaws and reduce downtime.
• Conducted tests to identify issues and make necessary modifications.
• Cloning of production databases to test environment for testing and training purposes.

• Created and updated database designs and data models.
• Designed and Installed the Oracle 8i, 9i, 10g, and 11g databases.
• Responsible for pre-install analysis, activities, and installation of 8i, 9i, 10g and 11g software on server and clients and post-install testing and analysis.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Tested programs and databases to identify issues and make necessary modifications.
• Set up and controlled user profiles and access levels for each database segment to protect important data.
• Planned, tested and performed Database backup and recovery plan and upgrade from Oracle Database 11.2.0.4 to 12.1.0.1
• Created user accounts and granted them appropriate roles and disk quotas for production usage.
• Managed various users' sessions both in UNIX and WINDOWS environments.
• Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
• Built databases and table structures for web applications.
• Developed scripts and processes for data integration and maintenance.
• Enhancing SQL statements performance using Explain Plan and Oracle optimizer hints
• Troubleshooting ORA-xxxx errors, adding data files to tables paces during data load operation if required.
• Analyzed complex datasets to identify trends and inform business decisions.
• Developed comprehensive reports for stakeholders, enhancing data-driven decision-making processes.
• Collaborated with cross-functional teams to streamline data collection and reporting procedures.
• Drove process improvements that increased operational efficiency and reduced turnaround times for reports.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.