Oracle Database Administrator Job at IBM Nigeria

Started by Jobrib, Aug 11, 2013, 09:31 PM

Jobrib

Job Title: Oracle Database Administrator

Employer: International Business Machines (IBM)

Job ID: GTS-0597541

Job type: Full-time Complementary

Work country: Nigeria

Position type: Professional

Work city: Any

Travel: 25% travel annually

Job area: Consulting & Services

Business group: Global Technology Services

Job category: Technical Services

Business unit: Int Tech Svcs

Job role: Systems Support Specialist

Job role skillset: General

Commissionable/Sales-Incentive jobs only: No      

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.

Required:

•   Bachelor's Degree: Bachelor of Science in Computer Science or Related discipline

•   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 to this job