Oracle DBA
Takaful Emarat Insurance
Total years of experience :20 years, 4 Months
•Database Administration of main Production and Staging Servers
•Perform database tuning and performance monitoring
•Database Maintenance plan settings
•Database engine and query Tuning
•Backup and Restore practices
•Perform general technical trouble shooting and give consultation to development teams
•Installation, configuration, Hot Fixing and upgrading of database server
•Database Log and History Analysis
•Establish and maintain sound backup and recovery policies and procedures
•Take care of the Database design and implementation
•Implement and maintain database security (create and maintain users and roles, assign privileges)
•Setup and maintain documentation and standards
•Plan growth and changes (capacity planning)
•Technical responsibilities also includes managing software Development, Technical Analysis, Feasibility reporting, Implementations of software, technical Support, Gap Analysis.
•Taking care of Oracle EBS (OGL) DB and application level issues by corresponding with Vendor
• Involves ensuring that an organization's databases are running efficiently and reliably.
• Administration for Oracle 10g Databases on Windows 2003, SuSe Linux 11 and AIX 5.0 Platform.
• Involved in the physical and logical design of a database, as well as configuring security and access permissions.
• Planning to configuring and maintaining of Standby database.
• Continuous monitoring of all Databases, sizing, tuning and SQL tuning.
• Maintain prod & test instances
• Purge logs & trace files regularly
• Apply patches
• Create shell scripts for task automation
• Implement load balancing and fail over capabilities
• Analyze and sustain capacity and performance requirement
• Analyze, consolidate and tune database for optimal efficiency
• Monitor systems and platforms for availability
• Install upgrades and patches for DB and IAS
• Provide best approach to consolidate for oracle license (recommendation for standard and enterprise)
• Evaluate and recommend new database technologies
• Onsite with 24*7 Coverage for Severity One issues
• Performance Tuning of database parameters after review of software configuration and Recommendations for infrastructure enhancement
• Looking after BASIS administration of SAP (ERP)
• Manage backup and recovery, responsible for database availability, reliability and performance and work with other programmers who are writing software to access the database, etc. Replication of Database objects through SNAPSHOTS
• Installing, creating and migrating Major databases.
• establishing the needs of users and monitoring user access and security
• monitoring performance and managing parameters to provide fast query responses to front-end users
• considering both back-end organization of data and front-end accessibility for end-users
• further refining the physical design to meet system storage requirements
• installing and testing new versions of the DBMS
• maintaining data standards, including adherence to the Data Protection Act
• controlling access permissions and privileges;
• developing, managing and testing back-up and recovery plans;
• ensuring that storage, archiving, back-up and recovery procedures are functioning correctly
• capacity planning
• working closely with IT project managers
• communicating regularly with technical, applications and operational staff to ensure database integrity and security
• commissioning and installing new applications
• Assists head of the department in various tasks which come over on Ad hoc basis.
• Assists in preparing I.T policy for the company
• Involve in development of Business continuity Plan (BCP)
• Involve in Due Diligence Securitize Testing.
• Assists in supporting corporate applications; internal corporate database servers etc
• Assists with basic troubleshooting, backup, and archiving of critical data and servers.
• Get engaged in various administration and maintenance work of Internal Systems programs as well as operating systems used.
• Back up and Restore the over all data on daily basis
• Selection of right Software Vendor(s)
• Maintenance and improvement of IT Infrastructure
• Database Support (Oracle & SQL)
• Coordination with users and compilation of users’ business requirements
• Preparation of Requirement Definition / GAP Analysis
• Selection of Software
• Provide technical and logistic supports during the entire processes of implementation
• Help and assist in Back Log transactions processing and Parallel Processing
• managing database access
• designing maintenance procedures and putting them into operation
• ensuring that databases meet user requirements
• liaising with programmers, applications/operational staff, IT project managers and other technical staff
• testing and modifying databases to ensure that they operate reliably
• providing user training, support and feedback
• writing disaster recovery plans
• archiving data
• Managing LAN of more than 30 computers in a company and solve any query regarding any network issue.
• Over all handling of UHA (Unit Holder Accounting) system for Arif Habib Investment Management Ltd
• Back up & Restore the database of AHIML on main IBM Xeon x235 server by using SQL server 2000
• Installation and initialization of databases on Test and Live Machines
• Dealing with all the System security issues.
• managing database security/integrity and backup procedures
• implementing security measures
• defining objectives through consultation with staff at all levels
• Writing documentation and operating manuals