Oracle Database Administartor
Ministry of Interior (MoI)
Total years of experience :9 years, 5 Months
• Monitoring Database performance and managing parameters to provide fast query responses to 'front end' users.
• Refining the 'physical design' to meet system storage requirements - Installing and testing new versions of the database management system (DBMS).
• Writing database documentation, including data standards, procedures and definitions for the data dictionary 'metadata' and controlling access permissions and privileges.
Developing, managing and testing backup and recovery plans.
• Ensuring that storage, archiving, backup and recovery procedures are functioning correctly.
• Managing all Crystal Reports system requirements: fine tuning existing reports, structuring new reports.
• Communicating regularly with technical, applications and operational staff to ensure
Database integrity and security.
• Performance tuning of database, monitoring alert logs, Oracle RAC and Table space.
• Proactively manage changes in project scope, identify potential
crises, and devise contingency plans.
• Resolves and/or escalates issues in a timely fashion.
Define project success criteria and disseminate them to involved parties
throughout project life cycle.
• Constantly monitor and report on progress of the project to all stakeholders.
• Develop best practices and tools for project execution and management.
• Project evaluations and assessment of results.
• Ensures project documents are complete, current, and stored appropriately.
• Assures project legal documents are completed and signed.
• Holds regular status meetings with project team and facilitates team
and client meetings effectively.
• Understands how to communicate difficult/sensitive information tactfully.
• Possesses general understanding in the areas of application
programming, database and system design.
• Understands Internet, Intranet, Extranet and client/server
architectures. Maintains awareness of new and emerging technologies.
• Leads a project team, ad/or nominated individuals from merchandising, operations, warehouse, finance, HR, Audit or other functions. Deliver an integrated business system solution and implement it for Retail in a timely and cost effective manner.
• Involved in projects related to Oracle Financials implementation, Oracle Payroll, HRMS projects.
• Manage the preparation and participate in end user systems testing. Ensure results of testing meet functional requirements as specified by IT. Developing, testing, migrating, documenting, and maintaining applications.
• Installing, configuring and maintaining multiple web servers as needed for production, development and testing.
• Performs administrative support tasks in supported applications, such as setting up news as well as changing/troubleshooting user and system settings authorities for existing users.
• Monitor overall performance of all support applications regarding response times, issues or problems.
• Participates in team meetings and identifies ideas for improvements.
• Work with system administrators to ensure backup and recovery procedures are in place.
• Work with system administrators to validate that regularly scheduled backups are completing properly.
• Proactive monitoring and application Health check.
• Reviews the application SQL for performance and standards.
• Install and maintain the web server.
• Install and maintain the application server.
• Develop technical plans in relation to application installations, including the ability to determine hardware and software requirements for application installations.
• Supporting development and production environments.
• Installing, monitoring & upgrading enterprise application integration systems.
• Basic understanding of multiple operating systems such as HP-UX, Linux, Solaris and Windows.
• Write reports, business correspondences, & procedural manuals.
Responsible for the following: -
• Plan, install, configure, administer, and support Oracle Database servers.
• Monitor database performance and prepare application performance and tuning plan to execute IT.
• Perform database backup and recovery tasks using Oracle RMAN and VERITAS software.
• Plan and implement disaster recovery solutions.
• Use Oracle Enterprise Manager and Quest Central tools.
• Prepare the data conversion plans and execute the data conversions.
• Transfer and replicate data between servers.
• Analyze the user requirements and prepare the data security implementation plan.
• Implement security procedures to protect database resources from unauthorized use.
• Create physical databases using logical data model diagrams.
• Prepare scripts for database creation from physical data model.
• Create and maintain database objects such as tables, triggers, stored procedures, etc.
• Plan and create elements for physical database objects.
• Establish and enforce standards for database server objects.
Responsible for the following:-
• Maintenance for all the network sites and equipments.
• Fault and performance monitoring. Ensures spontaneous reporting and intervention to minimize down time.
• In addition, attend course in “Arab Academy for Science and Technology (AAST)” for - Oracle Devolper6i, Java Programming, Visual Basic and Turbo C++. - Microsoft Windows 2000 Servers, Microsoft Project, CISCO (CCNA) and UNIX. - Proficient in all Windows Applications such as (Word, Excel, PowerPoint and Access). - Design, analysis and implementation of database project. - Features :( Specification Analysis, Data Normalization, E/R Diagram Design, Design of Forms, Deign of Reports and Implementation by Ms Access). - SQL server 2000. - A+ certification & HTML (self-study). - Well experience with Active Directory & ISA & Microsoft Exchange server. - Well experience with Citrix Met frame Server. Designed, installed, tested and implemented windows 2000 network - Installed and configured windows 2000 active directory service (Domain controller) and other related services. - Managed all functions required for the day-to-day operations of the IT system. - Documented the network hardware component. - Configured, examined and implemented group policies. - Verified the integrity of the network services. - Distinguished and troubleshoot network hardware (computers, cables, switches) and network services problems. - Performed backup operation for critical service. - Suggested alternative low-cost solutions. - Installed and configured Linux system
Greek & Latin
