Database and applications supervisor
Ooredoo - Other Locations
Total years of experience :12 years, 8 Months
• Wataniya Palestine Mobile
Senior DBA
December 2009 - present
Responsibilities:
• Manage End To End commercial and business meetings to get the requirements for the New Projects.
• Manage IT Infrastructure Projects.
• Team leader player to manage daily work and projects through juniors DBAs.
• Assign tasks and continue monitoring DBAs tasks.
• Install and patch Oracle Software, configure and create Oracle Database in UNIX-based and Windows Platforms with best practices
• Manage daily operation and performance of production databases running Oracle RAC under multiple O/S platforms, by proactively monitoring core statistics and react on reported findings.
• Managing Large Databases (up to 5 TB) allocated on different Disks (Storages, Verities Raw Devices, and Oracle ASM)
• Install, Configure and administrate Oracle RAC and Data Guard.
• Install manage and administrate Oracle Grid Control.
• Coordinates implementation activities with other parts of the enterprise.
• Configure database with Maximum Availability Architecture (MAA) using oracle Data Guard, Oracle Real Application Cluster and Oracle Streams (Replication)
• Control all migrations of Oracle schema objects
• Evaluate Oracle features and Oracle related products
• Enrolling users and maintaining system security and Implements database encryption.
• Perform database tuning and performance monitoring
• Perform application tuning and performance monitoring
• Setup and maintain documentation and standards
• Interface with Oracle Corporation for technical support
• Allocating system storage and planning future storage requirements for the database system
• May coordinate activities of the project team and assist in monitoring project schedules and costs.
• Tunes and optimizes SQL Statements, Instance Parameters, and Data Storage, including the identification of performance related issues
• Planning for backup and recovery of database information using netback and RMAN scripts.
• Contacting database vendor for technical support
• Working with different RDBMS environment (Oracle, Microsoft SQL Server, and MySQL database)
• Administrate, Managing and maintain Microsoft SQL Server in Cluster Environment
• Administrate, Managing and maintain MySQL in Cluster and Replication Environments
• Installation, configuration and upgrades of MySQL on Unix
• Monitor the MySQL and MSSQL Server Databases, handle dynamic schema updates, troubleshoot database issues, and perform and validate regular backups.
• Keep the MySQL and MSSQL Sever Databases operational and responsive, scales the current infrastructure to handle greater levels of reliability using data storage methods such as shading, partitioning and data modeling.
• Write Shell scripting on different Unix OS (AIX, HP, Sun, and Redhad Linux)
• Oracle Application Server Administrator (Infrastructure and identity management)
• Oracle ERP Apps DBA (Managing patch and maintain Oracle ERP R12)
• Oracle ERP Techno Functional
• Provide Oracle ERP modules support (finical and HR)
• Hulul Business Solutions
DBA
September 2007 - November 2009
• Creates and maintains all databases required for development, testing,
education and production usage.
• Performs ongoing tuning of the database instances.
• Backing up and restoring the database
• Under general direction, design, implement and maintain complex databases.
• Setup, configure, maintain and upgrade work on the application and Database Management System (DBMS) and its host servers. Includes maintenance of database dictionaries, overall monitoring of standards and procedures, and integration of systems through database design. Competent to work at the highest level of all phases of database management.
• Coordinate with the System Administrator to partition the SAN for database use, develop standard operating procedures, test and install appropriate server upgrades and patches as necessary.
• Perform daily, weekly and monthly backups of the DBMS, its data and hosts, conduct periodic restoration tests of backed up data, support the customer's COOP/Disaster Recovery, and support incident response policies and procedures including reporting and resolution.
Provide monthly reports regarding SQL Server usage, uptime, and capacity to the customer and COR as required.
• Responsible for developing data warehousing, evaluating hardware and software platforms, and integrating systems.
• Evaluates reusability of current data for additional analyses.
• Conducts data cleaning to rid the system of old, unused, or duplicate data.
• Reviews object and data models and the metadata repository to structure the data for better management and quicker access.
• Responsible for all aspects of database administration for SQL Server databases including problem solving, configuration, and implementation efforts for large and / or complex projects with an emphasis.
• International Consultant Center For System And Telecommunications
October 2006 - August 2007
Oracle Junior DBA
Responsibilities:
• Working in the support team and supporting the database plan, design and implementation. Managing security, backup and recovery by using enterprise manager and RMAN strategy, tuning and maintenance using oracle 9i&10g.
2002 - 2007 October 6 University - B.A. degree in Computer Engineering. fFaculty of Engineering. fa s