Serve as a Oracle DBA providing core database administrative, innovation, support, database infrastructure and architecture design. Position requires the ability to provide on-call, after-hours/weekend support, when necessary.
Responsibilities
- Production databases 24X7 running support, and database daily operation.
- Troubleshoot and resolve Database issues.
- ORACLE database schema designing and assessments.
- Database performance tuning.
- Working with AWS to keep the database in latest patching and version.
- Day to Day database monitoring and performance analyst.
- Provide the database technology service for new project developments.
- SQL Tuning and Optimization of newly develop and existing applications
- Database recovery / duplication / restore by application requests.
Requirements
Required Skills:
- Minimum of 5 years of software / database development experience
- Minimum of 6 years of experience as an Oracle DBA
- Experienced in Database infrastructure and architecture design
- Experienced in Oracle AWS RDS
- Experienced in Oracle Enterprise Manager
- Experienced in executing and writing Oracle PL/SQL in the most efficient way
- Experienced in database optimization and performance tuning
- Experience with backup and restore, table space allocation/management, managing the overall health and status of the database, managing the database schema, creating triggers and stored procedures, monitoring the Oracle alert logs and resolving database-related issues.
- Must have experience in configuring 11g/12c database in Linux
- Must have experience with Oracle product troubleshooting and problem resolution
- Able to communicate in English and Chinese in view of business requirements (no requirement on reading or writing in Chinese)
- Partake in meetings to give advice and recommendations
Desired Skills:
- Experience with Oracle products such as, Oracle GoldenGate, Real Application Clusters, Application Server, Replication and Streams
- Experience with other database products such as Redis, AWS Redshift, etc.
- Working knowledge of J2EE architecture and an understanding of object-oriented modeling languages such as Java.
- Experience in system accreditation using proxy users, virtual private database technology and label security.
- Familiar with technologies related to high volume data handling and ingestion and high data rate extraction with integrity checking and indexing.
- Knowledge in data warehousing
Required Education (including Major):
- Bachelor's in Computer Science, Software Engineering, Database Administration, CIS or related Technical major.
