senior database administrator
Tamkeen Technologie( Riyadh – KSA )Senior Database Administrator
Total years of experience :7 years, 8 Months
• Supporting many production database 12C in EXADATA X6.2
• Monitoring and administration Exadata database machine ( RAC DB nodes, CELLS, IB switches)
• Working with oracle support on Exadata prepare process and contact with oracle support if any issue happen
• Good knowledge on the Exadata Hardware Architecture which includes Database Grid, Storage Grid and Infiniband
• Good Knowledge in Exadata features including smart scan, Columnar Compression, Exadata Storage Index and Exadata Storage
• Experience in implementing DR solution, High Availability of database servers using Oracle Grid infrastructure ( RAC ), Failover cluster, Database mirroring, replications and Log Shipping, ORACLE data Guard
• Using replication between tables-schemas-databases through GOLDEN GATE tools
• Installation Oracle10g, 11g, 12C RAC database under Linux
• Managing the database’s storage structures
• upgrade, migrate, patching database
• Establish and maintain backup and recovery policies and procedures.
• 11g-12C databases, oracle grid control agents, Oracle ASM 11g, 12C
• Strong knowledge of backups, restores, recovery models, database shrink operations, ORACLE RMAN, ORACLE PUMP .. etc..
• Proactively monitoring the database’s health and taking preventive or corrective action as required.
• Responsible for full Installation and configuration for Oracle Web Logic Server
• Perform database tuning and performance monitoring.
• Work as part of a team and provide 7x24 support when required.
• Perform general technical trouble shooting and give consultation to development teams.
• restore all backup daily in new environments to check the backup was taken good without any issues
• did script to move all daily backup to tap
• Using new tools for replication (Materialized Views) on table level
• SQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
• prepare SYNC server to be updated every day from production to developer
• Prepare BI environments update every day plus important tables become updated Every 10 minutes from production by using Materialized View to get the updated data for the report
• monitors and check performance for all these database and do tuning once it needed
• investigate on bugs and solving them
• Managing the database’s storage structures
• Install and configure all databases required for development, testing, and production usage ( ORACLE )
• Supporting many production database 12C in EXADATA X6.2
• Using replication between tables through GOLDEN GATE tools
• Installation Oracle10g, 11g, 12C RAC database under Linux
• Managing the database’s storage structures
• upgrade, migrate, patching database
• Establish and maintain backup and recovery policies and procedures.
• 11g-12C databases, oracle grid control agents, Oracle ASM 11g, 12C
• Responsible for Database Backup and restore operations using RMAN and net backup.
• Proactively monitoring the database’s health and taking preventive or corrective action as required.
• Responsible for full Installation and configuration for Oracle Web Logic Server
• Perform database tuning and performance monitoring.
• Work as part of a team and provide 7x24 support when required.
• Perform general technical trouble shooting and give consultation to development teams.
• do migration for the our database storage from SAN 5500 to SAN 5600
• implement a lot of scripts by all type of backups (DATADUMP-RMAN-CLASSIC EXPORT)
• restore all backup in new environments to check the backup was taken good without any issues
• did script to move all daily backup to tap
• Using new tools for replication (Materialized Views) on table level
• prepare SYNC server to be updated every day from production to developer
• Prepare BI environments update every day plus important tables become updated Evey 10 minutes from production by using Materialized View to get the updated data for the report
• support developers for a lot of request and help the for running some tasks for specific times related to business
• monitors and check performance for all these database and do tuning once it needed
• investigate on bugs and solving them
• Managing the database’s storage structures
• Have multiply environement (prod-preprod-develoepement-QA)
• Data guard Installation and support
• Installation Oracle 9i, 10g database & create scheme, table space and datafile under linux
• Creating Oracle databases
• Starting up and shutting down the database
• Managing the database’s storage structures
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Managing schema objects, such as tables, indexes, and views
•
• Proactively monitoring the database’s health and taking preventive or corrective action as required
•
• Used parallelism to improve performance. By setting parallel_automatic_tuning to true the degree of parallelism is set automatically by oracle.
• Monitor systems using Enterprise Manager
• Perform database tuning and performance monitoring.
• Configuring the network environment for an Oracle client-server systems.
• Work as part of a team and provide 7x24 support when required.
• Perform general technical trouble shooting and give consultation to development teams.
• Responsible for import and export data (Data pump) Install and deploy more than one Oracle RAC environment
•Proactively monitoring the database’s health and taking preventive or corrective action as required
•Used parallelism to improve performance. By setting parallel_automatic_tuning to true the degree of parallelism is set automatically by oracle.
•Monitor systems using Enterprise Manager
•Perform database tuning and performance monitoring.
•Configuring the network environment for an Oracle client-server systems.
•Work as part of a team and provide 7x24 support when required.
•Perform general technical trouble shooting and give consultation to development teams.
•Responsible for import and export data (Data pump)
Computer science