Oracle Database Administrator in Lagos, Nigeria

at IBM

Industry
Computer Software
Specialization
Computer Software
Minimum Qualification
Bachelor's Degree
Required Experience
1 - 3 years
Employment Type
Full Time
Gender
Male or Female
Share this job

Job Description

Assist with creating Oracle server environment complete with administrative policies, procedures and documentation.
Incident and problem resolution
Assist with governing tasks such as monitor performance, space, backups, availability and resources, and size of physical database objects to support ongoing capacity management and promote continuous service.
Periodic Recovery Testing
Assist with governing, planning or performing the following:
Database software patching
Data load and Refresh
Data archival and purging
Apply maintenance and corrective service for database products and associated DBMS products and tools.
Database system level database backup and recovery
Perform database system level space management and monitoring
Run Database system level reorganizations, statistics and other applicable utilities to ensure proper database function and performance
Perform automated startup and shutdown of the production database (this does not include business applications)
Move database objects between physical structures (i.e., development to production)
Maintain database security accesses at database and object level
Setup and retain use of DBMS System Administration ID & privileges
Manage database transaction logs (active and inactive)
Provide monthly reporting statistics as required
Provide SME consultation to project teams implementing developed or third party solutions that require database component(s) in the design. Review and recommend changes where necessary and/or support the established database policies, guidelines, procedures, etc. as they apply to development and implementation of new database objects, etc.
Other duties as assigned

Ability to develop trend and analysis reports indicating database growth and load to anticipate storage, CPU and memory needs;
Ability to research new products, tools, methodologies, and standards related to all aspects of the database environment and its security and make recommendations.
Occasional evening and weekend work to perform maintenance and upgrades, and emergency troubleshooting.
Experience in data warehouse tuning and best practices including partitioning.
Knowledge of Informatica and Business Objects tools would be desirable
Strong Sun Solaris OS (Unix). Understands how Oracle parameters interact (cause/effect) with the OS system and can quickly ascertain problem areas and make accurate recommendations for improvement.

Requirements

Required

  • Bachelor's Degree
  • At least 2 years experience in IT Professional with industry experience of Oracle database administration and maintenance using versions through 11g
  • At least 2 years experience in Strong hands-on aptitude in performing administration functions such as installations and configurations, creating databases, backups and restores, and database migrations
  • At least 2 years experience in database optimization and performance tuning including SQL optimization,index creation and rebuilds and triggers, views and stored procedures
  • At least 2 years experience in Practical experience in managing Oracle security best practices
  • At least 2 years experience in Practical knowledge of database recovery models including Mirroring, Clustering and Log Shipping
  • English: Fluent

Preferred

  • Master's Degree in Engineering
  • At least 3 years experience in IT Professional with industry experience of Oracle database administration and maintenance using versions through 11g
  • At least 3 years experience in Strong hands-on aptitude in performing administration functions such as installations and configurations, creating databases, backups and restores, and database migrations
  • At least 3 years experience in database optimization and performance tuning including SQL optimization,index creation and rebuilds and triggers, views and stored procedures
  • At least 3 years experience in Practical experience in managing Oracle security best practices
  • At least 3 years experience in Practical knowledge of database recovery models including Mirroring, Clustering and Log Shipping
  Apply Now

Sponsored Jobs in United States

Ads by Careerslip