Database Administration
Database Administration on Oracle, SQL Server, Postgres Database.
Extensive experiences in database administration, implementation, trouble shooting and quality management.
Proficient database backup & recovery strategies plan and implementation such as RMAN backup with/without catalog, cold and hot backup, full/incremental backup.
Solid experience in Oracle RAC, Grid, ASM, DataGuard, GoldenGate installation, configuration, trouble-shooting, and performance tuning.
Created Oracle database objects(tables, partition tables, b-tree and bitmap indexes, constraints, views and materialized views), PL/SQL Procedures/Functions/Packages, SQL and shell Scripts and develop transaction processes based on created objects to support business needs and report’s needs. Developed Linux shell scripts to perform a nightly refresh of the test system from Production databases.
Certification
• Oracle Certified Professional (OCP)
Technical Skills
Database | Oracle, SQL Server,Postgres |
Database Language | SQL and PL/SQL, Bash Shell, Powershell |
Platform | Linux, Windows |
Tools | SQL/Plus, SQL Developer, Oracle OEM |