KEY RESPONSIBILITIES
- Installing and upgrading the database server and application tools
- Allocating System storage and planning future storage requirements for the database system
- Modifying the database structure, as necessary from information given by application developers.
- Enrolling users and maintaining system security
- Ensuring compliance with database vendor license agreement
- Controlling and monitoring user access to the database
- Monitoring and optimizing the performance of the database
- Planning for backup and recovery of database information.
- Maintaining archived data
- Contacting Database Vendor for technical support
- Generating Various reports by querying from database as per need
- Perform database monitoring, tuning and capacity planning
- Architect and define backup/ recovery strategies
- Optimize database access and allocate/ re-allocates database resources for optimum configuration, database performance and cost.
- Manage schema changes and Implementations
- Implement advanced database security features
- Install and maintain database products
- Audit user activity to ensure integrity and performance of the database
- Establish standards, policies, and procedures for database administration
- Define and Implement alerts on data.
SKILLSET
- 10 years plus Oracle DBA experience with following components
- Oracle versions (12c; 19C 21C)
- Oracle Forms and Reports
- Oracle Apex
- Oracle Rest Data Services (ORDS) preferable
- Experience working with Oracle container databases (CDB’s) and pluggable databases (PDB’s)
- Linux experience
- Oracle PAAS and SAAS experience preferable
- Oracle OCI experience preferable
- Database and Code performance tuning and optimisation experience required
DELIVERY EXPECTATIONS
- Standard DBA support of 26 Prod databases and 40 non-prod databases.
- Database Performance Tuning
- PL/SQL performance Tuning
- Troubleshooting application issues
- Oracle DB patching Database environment optimisation
Desired Skills:
- Oracle PAAS and SAAS