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 (http://www.jobnavy.com/job/22426/oracle-database-administrator-job-at-ibm-nigeria/)