Oracle DBA ( Database Administrator)
Ministry of environment water and agriculture, Saudi Arabia
Total years of experience :10 years, 2 Months
Achievement
• InPlace and OutPlace upgrade to 19c from 12c
• Upgraded Red hat Linux to 7.6 from 6.7
• Upgraded and Migrated to 12c CDB on Linux DB from 10g DB Windows 2003 R2
Duties & Responsibilities:-
• Database upgrade from 10g-12c, 11g-12c, 12c-19c
• Administers Container database (CDB) and Pluggable Database (PDB)
• Stimulation of Production dB using Data pump Api and Data pump utility
• User Management (Roles and privileges at CDB and PDB level)
• Tablespace Management
• Memory Management (SGA+PGA)
• Performance Tuning
• Memory Tuning
• SQL Tuning
• Flashback Database
• Flashback Data Archive (FDA or FBA) automatically tracking transactional changes to data over very long periods.
• Data Recover - Point in time Database, Point in time Tablespace, Point in time Table
• Unified audit, FGA fine-grained Audit, Traditional audit
• Implemented and Managed Data Guard - physical standby database and snapshot database (DR).
• Applying interim Patch and Patchset
• Configured Data Guard Modes- Failover and Switchover
• Automation of Database on server reboot
• In-Depth knowledge of Oracle Architecture & design
• Secured sensitive data by Data redaction policies
• Data Replication using Golden gate
• Memory and Storage management of Servers
• Proficient in Database and third-party software installation, up-gradation, and patching for Oracle on LINUX and UNIX platforms.
• Implemented backup solutions using Oracle conventional and third-party backup tools.
• Implemented High Availability solutions, disaster recovery strategies
• Migration of Database from one platform to another using Golden Gate.
• 12c Multi-tenant database as a pluggable database or container database
• DBA process and policies, manuals documentation for team reference and compliance.
• Installation and maintenance of DB Server
• Linux Server Administration
Duties & Responsibilities:-
• Stimulation of Production dB to TEST and Development environment
• Automation of dB refresh on daily basis
• Backing up the database in case of disaster or data loss
• Testing the backups to make sure the database can be recovered
• Recovering lost data in the event of an incident
• Reviewing security logs to ensure that the database has not been accessed inappropriately
• Monitoring the database software’s vendor information feeds for security alerts, patches, and upgrades
• Scheduling and applying patches and upgrades when required
• Adjusting the security settings of the databases to respond to threats
• Authorizing new users and applications to access the database
• Monitoring processor and memory utilization of the database server
• Creating and managing schemas—that is, categorization of data
• Assisting software developers with database questions
• Managing extract, transform, and load (ETL) tools
• Monitoring disk utilization of the database server
• Adding more storage or migrating the storage, if necessary
• Planning for future capacity requirements for the database
• Troubleshooting errors and other database problems
• Installing, monitoring and troubleshooting disaster recovery DR site
• Replicating data from one platform to another
• Uni and bi direction Data replication
• Flashback the data at the desire time
• Auditing the operations of Users and DBAs
• Administering Multi instance (multi-node) RAC database.
• Adding, Removing nodes from RAC.
• Upgrades RAC to latest version.
• Load balancing of session in RAC
• Applying patches in rolling on RAC Environment.
• Installing and maintaining dB servers
• Working with business users and developers to define data models for new applications or modules
• Oracle RDBMS & GRID(ASM+CRS) Installation (single node and multi-node)
• Database migration from non-ASM to ASM.
• Expert in Installing RAC REAL APPLICATION CLUSTER 11g/12c
• Upgrading RAC environment 11g/12c
• Migration of Database from one platform to other using Golden Gate.
• Well versed in Creating ASM instance for RAC, Cluster Ready Services CRS, Cluster monitoring utilities mounting.
• Discovery of LUN in SAN environment
• Troubleshooting Network issues
Achievement: Developed Car racing game on iPhone using Objective c Language.