.

Friday, January 25, 2013

Database Administrator - Qatar Fertilizer Company

Job Description
Operations & Support

• Manages the ERP DB2 UDB databases and ensure availability of database services.
• Monitors & analyzes the databases in order to identify problems and obtains/applies fixes or patches.
• Maintains database consistency & integrity. Defines standards for database schema, objects and layouts.
• Develops guidelines, establishes, manages database security, roles, and profiles. Performs regular security audits.
• Assists ERP team in Software Development Life Cycle (SDLC) process by performing change management.
• Responsible for tracking issues by following documented processes and procedures and meeting SLA.
• Participate in testing phases : Unit, Interface, and User/System Acceptance of ERP modules.
• Designs & implements database system integration & deploys database interfaces. Monitor & maintains interfaces.

Maintenance & Upgrade
• Installs, configures, troubleshoots and maintains database systems to ensure the smooth operation.
• Plans , coordinates & performs database update/upgrade for database software version compliance.
• Diagnoses & corrects database problems resulting from the applications base. Carries out preventive maintenance.
• Escalates issue to respective vendor for support & obtain/ apply solution.
• Defines , designs , deploys & implements physical database layout.
• Manages database storage and growth, purges/archives historical data, reorganizes database as needed.

Performance Tuning & Optimization

• Constantly monitors & analyzes database system performance and identifies performance bottlenecks & opportunities.
• Works closely with development team to perform SQL tuning & optimization.
• Generates database performance reports and defines actions plan for optimization.
• Understands different aspects of performance tuning and demonstrates ability to resolve issues.

Backup & Recovery Management
• Schedules, supervises, performs periodic database backup operations.
• Monitors , analyzes, adopts best practices and implements new enhancements/technologies for improving efficiency.
• Administers & maintains the database environments on primary & disaster site to maintain consistency and fail over readiness
• Defines documents & maintains disaster recovery plans .Carries out periodic DR simulation test.

Qatar Fertiliser Company (S.A.Q.)
P. O. Box: 50001, Mesaieed, Qatar
Telephone: (974) 44228888;
Fax: (974) 44770347