Senior DBA and Technical Lead Database Projects
MTN Nigeria
Total des années d'expérience :19 years, 7 Mois
• Provided technical lead in designing, developing, and managing of large complex databases that are located on multiple servers in diverse hardware environments and using different database management systems which include SQL DBMS - Oracle, Microsoft SQL, MySQL and No-SQL DBMS - Mongodb.
• Analyzed, created solutions for challenging performance-tuning situations; recovered databases; proactively patched and upgraded databases to latest release; performed database change requests; worked closely with Oracle support to debug issues and applied solution. This support model has resulted in 99.9% up time for company's critical databases.
• Acted as technical lead to vendors for complex database-related issues, systems, and implementation projects involving 40 critical application services which aided in achieving improved customer experience from 56% to 89% in 2014 and consistent yearly improvement of 5%.
• Provided on-going performance monitoring and debugging, resulting in a major reduction in downtime and consistent availability of 99.5%
• Upgraded to latest Oracle release enhanced availability and introduced new features for on-going support of these databases.
• Created disaster recovery environment for company critical and essential databases.
• Trained team members and acted as DBA adviser for major HA projects that resulted in 95% successful disaster recovery implementations and reduced downtime for databases by allowing switch-over, fail over and recovering seamless.
• Monitored and tuned systems and databases to optimum levels of performance; performed system upgrades in support of business processing requirements.
• Assisted developers with writing and tuning SQL queries; performed on-call support and problem resolution 24/7.
• Analyzed database performance utilizing Oracle ADDM, OEM, AWR and TFA.
• Diagnosed and troubleshot database problems such as errors and bugs, performance problems, runaway processes, connectivity problems, poor SQL statements, etc.
• Managed technical projects for database upgrades, resource capacity planning, platform migrations, application consolidation, and data center rationalization.
• Responsible for major Oracle, MySQL, MS-SQL and Mongodb server consolidation effort comprised of high-end UNIX servers which was completed ahead of schedule and led to over 1 million dollars in annual savings
• Managed Oracle RMAN backups, MySQL enterprise backup, MS-SQL Backup and Mongodb backup using Symantec Netbackup. Conducted performance tuning analysis and modification, and developed standard operating procedures for the backup infrastructure.
• Proactively provided technical infrastructure solutions to meet strategic business goals including application integration, database design, system consolidation, and database training.
• Responsible for implementing and overseeing enterprise database security standards and ensuring compliance with the corporate IT change management process.
• Implemented database security using Oracle Transparent Data Encryption to ensure safety of customers’ data and integrity.
• Implemented database security using Oracle's unified directory (OUD) Enterprise user security (EUS) integrated with Active Directory (AD) intended for security compliance and centralization of identity and access management of database users.
• Executed and provided ADDM, AWR, TFA and database health check reports to information owners and recommended solutions for improved oracle database performance.
• Designed, developed, tested, deployed and maintained database security and audit solutions
• Engaged subject matter experts and information owners to provide assistance to resolve more complex incidents as required for maximum availability of Oracle applications services, Enterprise resource planning services, Mobile Provisioning services and business intelligence aggregation services.
Operating Systems and database administrator
•Involved in administration of Unix operating systems and oracle database, including
performance monitoring and tuning.
• Involved in the coordination of allocated information technology projects for the bank.
• Involved in preparing daily projects status updates while ensuring smooth running of
production systems.
• Actively participated in the development of web based application for internal
operation of information technology process flow - data center access and
documentation portal.
• Actively participated in administration of oracle database security.
• Involved in the design of physical database schema, data modeling, and
performance tuning.
Business Achievements
• Accomplished Service availability of 95.95% to all the branches of the bank all.
though the year.
• Attained customers’ satisfaction rate of 98.95% on supported services all through the
financial year.
• Realized market growth for the bank within the financial industry which increased the
profit after tax of the bank to 140% in relation to 2007.
• Managed information technology clients across all branches of the bank.
• Ensured all branches of the bank can connect to the main data center in Lagos.
• Attended to all information technology calls.
Master of science in Information Systems Management
Bachelor of Science in Computer Science
Higher National Diploma in Electrical and Electronics Engineering with major in Electronics and Telecommunication Engineering.
