Database Administrator
Saudi Chevron Philips Chemicals
مجموع سنوات الخبرة :14 years, 9 أشهر
Integral part of Applications Support team, serving end users of varied Applications
Support multiple test, certification to Production databases on Windows, Unix based platforms
Monitor, tune Applications to ensure achieving optimum stable service among all supported Applications
Connect SQL to Oracle Databases using Linked Servers, while also maintaining DB security using Profiles, enforcing Fine grained Access Controls etc.
Continually involved in migrations, Upgrades of various Applications
Prepare and implement Backup, recovery strategies. Ensure clear documentary procedures are available to ensure safe Database restores in the event of catastrophes
Perform periodically DR tests, ensure maintaining associated documentation
Continually involved in transitioning conventional Applications to Highly Available solutions to guarantee zero downtimes
Patching multiple Production and Development Database in order to maintain stable, secure environment
Cloning development Databases with Production data using techniques such as RMAN Duplicate etc.
Conduct capacity planning and maintain associated documentation
Work closely with IT Project managers, developers, coordinators
Effectively improved database performance by identifying bottlenecks, tuning SGA, rebuilding indexes etc.
Balanced I/O by multiplexing of redo log groups, control files, and spread data files across several disks
Enforce block corruption detection within scripts and monitor DB File health regularly
Configured database system security and firewall traffic restriction using SQL*Net, TNS Listener configuration, remote hosts configuration, and listener ports configuration
Enforce DB Security & controls using techniques such as profile management,
Provided multiple database environments for development, integration test and Production
Extensively involved with application support team to serve the end users and support development team as necessary
Implement and maintain database security; create and assign user profiles to
Enhance security
Implement stringent security measures by enforcing access control limitations
Securely linked several Oracle databases with Microsoft access by providing
Access limitations
Applying Oracle released critical patch updates, cumulative updates and patch set updates periodically
Develop and implement backup/recovery policies and procedures
Installing and configuring Oracle Weblogic Server 11g / 12c
Monitoring and maintenance of Oracle Weblogic Server
Virtualized and made fully functional several Physical Test machines featuring
DB, iAS 10g, customized forms based application
Managing and maintaining Oracle Application Server, BI & forms
Installing and configuring Oracle RAC for various production applications
Monitoring and managing Oracle RAC based on UNIX platform
Establishing the needs of users and setting user access and security
Tuning reports server adequately to support small, medium and large sized organizational reports
Deployed Business Intelligence tools (Oracle discoverer)
Installing and configuring Oracle eBS r12
Monitoring and maintenance (includes patching, cloning, upgradation) of
Oracle eBS r12
Monitoring and tuning DB and Application server and ensure optimum service is achieved in terms of availability and performance
Integrating SQL server 2005 / 2008 with Oracle 10g database using linked server
Installing and configuring SQL server 2005 / 2008 for test, development systems
Integrating oracle 9i on UNIX platform with oracle 10g on WINDOWS using database links
Actively participated in successful achievement of Information Security
Management System certification (ISO-27001)
Working closely with IT project managers, database programmers etc.,
Extensively used Automatic Workload Repository (AWR), and Active
Session History (ASH) to collect database statistics
Effectively improved database performance by identifying bottlenecks, tuning
SGA, rebuilding indexes, using hints in queries
Used DB Verify utility to detect database block corruption, used log miner package to mine archive files
Installed, configured, up graded several RAC / non RAC databases
Implement, maintain and manage users & database security
Well versed with Oracle 10g Enterprise Manager Grid Control for space management, init parameter settings, alert message notification, system and database policy definition, database and application server monitoring, and patch installation
Troubleshooting, backup and recovery, proactive database and system maintenance, proactive monitoring, security
Working with team to promote rapid response to know issues
Configuration and maintenance of logical and physical standby database,
Oracle 10g regular databases
Develop and implement backup strategy and recovery procedures
Install, configure and maintain Oracle application server 10g
Tuning report server adequately to attain optimum performance
Linked Oracle 9i databases with 10g while ensuring target databases are fully secured
Migrated several oracle 9i to 10g databases
Communicating regularly with technical, applications and operational staff to ensure database integrity & security
Continuous testing of recovery strategy to minimize the recovery time in case of actual failure
Performance and Tuning of database by identifying bottleneck in SQL queries and batch processes using Explain plan, AWR reports and Grid control
Worked with development team for database object creation, query tuning and
regular database related issues
Provide day-to-day support and maintenance for key databases and services of the enterprise application platform
Bachelors in Computer Applications