Sr. DBA Engineer
E-finance
Total years of experience :15 years, 10 Months
Install, administrate and upgrade database engine and application server.
Work in coordination with database application developers to design/modify database schema
Support and maintain e-finance database systems, and ensure its reliability and availability.
Monitor, maintain database systems and troubleshoot problems that may arise.
Monitor databases using Oracle Enterprise Cloud 12C.
Develop and implements backup / recovery strategy (hot / cold backup).
Maintain database dictionary for various database applications.
Create and manage multiple databases and assist in capacity planning.
Maintain data integrity and security (manage roles and permissions of database users).
Use tools like SQL Profiler and Oracle Enterprise Cloud 12C for database tuning. Generate traces,
Execution plans, identify performance issues, deadlocks/contention and resolve them.
Create and manage constraints, triggers, function, procedures and indexes.
Support software developers with database operations including the development of complex SQL,
tuning of DML and the creation of stored procedures.
Manage production, and development database environments.
Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
Set up and maintain database infrastructure for the company’s needs.
Create Oracle DB, instances, users, listener and troubleshoot different DB issues.
Manage the routine operations for both development and production databases.
Install, configure, patch, and upgrade database software as needed.
Create security function to implement profile security as company policy requirement.
Create different user’s profile and manage idle time, password policy for different users.
Create Linux shell script to automatic startup, shutdown, restart oracle database and golden gate.
Create Linux shell script to take hot backup incremental using RMAN (database, archive logs,
Control file, and spfile) and send mail with log to administrator.
Create Linux shell script to take full database ‘cold backup’ at midnight and compress it
Create Linux shell script to export, import database, metadata (expdp, impdp utility).
Create script to check database space and archive logs space and send mail to take action.
Install, configure and utilize Oracle Enterprise Manager (OEM) 12c for managing and monitoring
The database and hosted servers environments. Provide training on enterprise databases tools to
System administrators, junior DBA’s and other technical resources.
Upgrade oracle engine from 10g to 11g and 12c on Linux and windows environment.
Create FGA policy for auditing to monitor tables or columns.
Move and cloned database between servers using duplicate database script.
Monitor database transaction with enterprise manager 12c and check the EM advisor (memory, sql.Etc) to increase the performance.
Import data from text file; excel file and Microsoft access to oracle database.
Create ODBC connection and link oracle database with Microsoft access.
Create Linux shell script to Purge logs & trace files regularly.
Implement and configure Golden Gate 11g and 12c.
Create golden gate script to monitor status and send mail when services status changed.
Implement and configure RAC on san storage and create Linux shell script to monitor the nods and performance.
Implement and manage grid infrastructure on Linux and windows.
Implement and configure data guard in main office and smart village site.
Create Linux shell script to monitor data guard apply and send mail if there are gab.
•Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new and monitor the performance and scheduled tasks on existing databases systems.
•Plan, coordinate and implement security measures and backup strategy to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
•Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
•Build and manage test cases identical to Production environment as part of diagnostics and resolving production support requests.
•Specify users and user access levels for each segment of database.
•Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
•Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
•Establish and calculate optimum values for database parameters, using manuals and calculator. Revise company definition of data as defined in data dictionary.
•Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
•Working on UNIX, Linux and/or Windows platforms
•Responsible for 4 Oracle 11G, 10G Databases (2 Production - 2 Development ) on Windows Server 2008 R2.
•Verify All Instances Are Up.
•Implement Backup Strategy Plan.
•Oracle 11G, 10G Databases Daily Backup and Recovery.
•Testing Backup Validity.
•Database Cloning From Production to Test Development.
•Monitoring DB Performance and DB Hit Ratios.
•Monitor DB Datafiles and Tablespaces Growth.
•Manage DB Security.
•Installation, Configuration of Oracle Server Software and Related Products.
•Provide Help, Support and Training for Database Users.
•Migrating From File System To ASM.
•Perform the Capacity Planning Required to Create and Maintain the Databases.
•Dealing with Real Application Clusters (RAC)
- Responsible for 4 Oracle 11G, 10G Databases (2 Production - 2 Development ) on Windows Server 2008 R2.
- Verify All Instances Are Up.
- Implement Backup Strategy Plan.
- Oracle 11G, 10G Databases Daily Backup and Recovery.
- Testing Backup Validity.
- Database Cloning From Production to Test Development.
- Monitoring DB Performance and DB Hit Ratios.
- Monitor DB Datafiles and Tablespaces Growth.
-Manage DB Security.
- Installation, Configuration of Oracle Server Software and Related Products.
- Provide Help, Support and Training for Database Users.
- Migrating From File System To ASM.
- Perform the Capacity Planning Required to Create and Maintain the Databases.
- Dealing with Real Application Clusters 10g &11g & 12c (RAC)
- Implementing and Configuring Oracle Data Guard
• Responsible for Database maintenance and troubleshooting
• Cloning Production databases to Test Databases using RMAN or Control file creation method
• Backup and Recovery polices for both Production and DEV DBs
Using both RMAN backup & recovery and Export & Import Utilities (Data Pump )
• Ability to handle all invalid objects, duplicate items and Creating scripts for different DBA tasks
• Creating Schema objects, Managing users, roles and Auditing.
• Technical Support for HRMS (Oracle DB issues ) Customers
• Disaster Recovery solution & Failover (Data guard for oracle applications) Standby database
• Automating most of DBA tasks by creating Scripts /Procedures for common DB tasks ( RMAN Backup, Validate Backup, Startup, Shutdown, alertlog DB-error notice….etc)
• Install Configure and Manage Oracle Server on UNIX & Linux Platforms
• Providing full support in hardware and software.
• Responsible for the technical support department.
• Indoors and outdoors support.
• Responsible for processing incoming orders.
• Responsible for goods receiving and all incoming and outgoing goods.