Database Administrator

DBA+PLSQL / SQL Developer

• Good knowledge of Oracle database architecture
• Good knowledge of Oracle internals and performance diagnostic.
• Experience in Database Designing
• Experience in Database Performance Tuning
• Experience in Database migration.
• Experience in developing stored procedure, functions, triggers
• Complex query writing and Query profiling
• Slow query identification and optimization / Query tuning.
• Partitioning, indexing, horizontal and vertical scaling
• Implementation data archiving and purging policy
• Experience in Managing data warehouse.
• Shell / Perl / Python scripting for Reports / ETL
• Knowledge of installation and setup stand alone, RAC, Extended RAC
• RMAN, Backup, Restore, Recovery.
• HA and DR(active / standby)
• Oracle Golden Gate Replication.
• Version upgradation and patching.
• User role and access management.
• Data Security and encryption
• DB health check, alerting and monitoring.

Good to have :