- Ability to install, configure, optimize, and document complex Oracle 11g, 11gR2, 12c,18c,19c and SQL 2008,2012,2014,2016,2017 and 2019
- Expert Hands-on install, configure, optimize, and document complex databases
- Expert Hands-on in most current Oracle,SQL,MySQL and PostgreSQL database environment installation
- Expert Hands-on in Database native HA/DR/Replication setup (RAC,Dataguard,FSFO,AOAG,Stream replication)
- Expert Hands-on experience in Oracle, SQL database Migration
- Expert Hands-on experience in cross-platform Migration such as Oracle to MySQL, Oracle to PostgreSQL
- Ability to install, configure, optimize, and document complex Oracle (RAC/A-Data-Guard/RAC One Node/Oracle VM) and SQL Server (Clustering, Always-On-Availability Groups) and Oracle/SQL Replication Architectures
- Ability to install, configure, optimize, and document complex DB2 (Pure-Scale) and DB2 Replication Architectures
- Ability to interact with clients and co-suppliers in clear and concise language. Ability to listen to and respond to the client's needs.
- Ability to logically approach a problem from definition through resolution.
- Ability to define a root cause analysis of an issue and explain causals, contributors and resolutions to clients and other team members
- Ability to work in team of UNIX, Cloud, Application, collaborative engineers, deployment and operations.
- Experience on Oracle/SQL Server Infrastructure upgrade
- Experience on Disaster Recovery Solution like Data-Guard.
- Experience on virtualization solution on Oracle VM and SQL Server (on Hyper-V) and their management tools.
- Cross Oracle/SQL Server/DB2 (Migration Tools) experience – use of Attunity/DoubleTake and other 3rd party tools etc.
- Migration of cross-platform Oracle databases from small, large to very large databases (Data-Pump, Oracle RMAN (TTS), Oracle Golden Gate)
- Oracle / SQL Server / DB2 server-side scripting experience for batch scheduling, event, performance management
Core Technical Skills:
- Oracle, MSSQL, MySQL and PostgreSQL
- Oracle RAC, Data Guard, FSFO, Active Data Guard, BuR
- SQL Server AOAG, Replication
Hands-on Migration skill on below database level migration
- Oracle to PostgreSQL
- Oracle to MySQL
- Oracle to Oracle
- SQL to SQL
- Database upgrade both direct and in-direct path
- Database native HA/DR/Replication solutions design, implementation and testing
- Golden Gate, DMS, DMA ,MTK
- Database Performance tuning
- Database Security and auditing implementation
- Database BuR, Monitoring implementation
- Added knowledge on Exadata, ODA