Banner Image

All Services

Programming & Development Database Design & Administration

Oracle Database administrator.

$8/hr Starting at $25

  • Installation of Grid and RAC databases along with the migration of data.

  • Building and administering 10g, 11g, and 12c databases.

  • Upgrading 10g, 11g, and 12c databases in both RAC and Non-RAC environments and configuring wallet for security.

  • Scheduling jobs in Cron for the purpose of monitoring, clean-up, archiving, gathering stats, and other health check purposes.

  • Performing RMAN database Backup and recovery (Hot and Cold Backups).

  • Migration of databases from on-prem to Azure cloud.

  • Tuning the performance of the databases using various tools like AWR, ADDM, SQLT, Oracle Health Check, TKPROF, SQL Trace, etc.

  • Monitoring and troubleshooting database backups and failures in Commvault.

  • Setting up Physical Standby for DataGuard(DR) configuration and performing switchovers in RAC and Non-RAC environments.

  • Setting up GoldenGate for data replication in homogeneous and heterogeneous environments.

  • Creation of User accounts, granting privileges, and other role specifications to the users in the database.

  • Schema, Table, and Database Refresh using DataPump utility.

  • Provide 24/7 support for all the production and non-production databases.


About

$8/hr Ongoing

Download Resume

  • Installation of Grid and RAC databases along with the migration of data.

  • Building and administering 10g, 11g, and 12c databases.

  • Upgrading 10g, 11g, and 12c databases in both RAC and Non-RAC environments and configuring wallet for security.

  • Scheduling jobs in Cron for the purpose of monitoring, clean-up, archiving, gathering stats, and other health check purposes.

  • Performing RMAN database Backup and recovery (Hot and Cold Backups).

  • Migration of databases from on-prem to Azure cloud.

  • Tuning the performance of the databases using various tools like AWR, ADDM, SQLT, Oracle Health Check, TKPROF, SQL Trace, etc.

  • Monitoring and troubleshooting database backups and failures in Commvault.

  • Setting up Physical Standby for DataGuard(DR) configuration and performing switchovers in RAC and Non-RAC environments.

  • Setting up GoldenGate for data replication in homogeneous and heterogeneous environments.

  • Creation of User accounts, granting privileges, and other role specifications to the users in the database.

  • Schema, Table, and Database Refresh using DataPump utility.

  • Provide 24/7 support for all the production and non-production databases.

Skills & Expertise

Crystal ReportsData BackupData WarehouseDatabase AdministrationDatabase DesignDatabase DevelopmentDB2Microsoft AccessMicrosoft SQL ServerMongoDBMySQLOracleOracle DatabasePL/SQLPostgreSQLQuery OptimizationSQLSQLiteStored ProceduresTransact SQL

0 Reviews

This Freelancer has not received any feedback.