- Oracle 10g, 11gR2,
12c Database Administration
- 24/7 production
and development support – Oracle and MS SQL Server Administration
- Software
Development Life Cycle (SDLS)
- SQL Server, MySQL
and Big Data (Hadoop) Administration
- Creating
Databases and managing user securities on both Oracle and SQL server
- Database Security
(Data access, profiles) as per (STIG) Rules
- RDBMS Installation,
Creating and Managing OLTP and OLAP Database
- Patching CPU and PSU,
Oracle Software Upgrade for 10g/11g/12c, Migration Flashback
Technology, Log Miner, ADDM Implementation
- Backups using
RMAN and DATAPUMP/ Backup policy using RMAN and VNB (Veritas Net Backup)
- Perform upgrades
of Oracle DBMS software on heterogeneous platforms
- Implementation of
high availability solutions with Oracle 11g RAC, Physical Standby database,
Data Guard
- Recovery from
Media failure, Block Corruptions, User errors
| - SQL Server, MySQL and Big Data (Hadoop) Administration
- Database Security (Data access, profiles) as per (STIG) Rules
- Patching CPU and PSU, Oracle Software Upgrade for 10g/11g/12c, Migration
- Backups using RMAN and DATAPUMP/ Backup policy using RMAN and VNB (Veritas Net Backup)
- Implementation of high availability solutions with Oracle 11g RAC, Physical Standby database, Data Guard
- Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM
- Experience with Stored Procedures, Functions and Database Triggers
- Disaster Recovery plans by implementing 10g/11g Oracle RAC and Data Guard switchover and failover
- ASM for RAC and NON- RAC configuration
- Data pump for Schema Refresh, Database Object Migration
- Proficient in SQL, PL/SQL, Unix Shell Scripting and analyzed Batch programs
- Administration and Management – Database Links, Oracle Golden Gate (Data Replication)
|