Database Architect

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:

• Experience in PostgreSQL, MySQL, NoSQL databases like mongodb.
• 3-5 Experience