Job Description
We are seeking a professional DBA with the technical skills and knowledge that extends across Application/ Server/ Storage/ Network technologies administer a large, complex production DB environment and troubleshoot and provide system level guidance/ solutions. This includes Oracle databases for production, testing, and staging environments across the system. This opportunity will suit an Oracle DBA who enjoys providing technical guidance and plays a key role in supporting and driving forward our database developments.
Responsibilities:
Execution of data migration jobs and scripts as required.
Ensure DB availability.
Researching and recommending solutions that best meet business needs and enterprise operational requirements.
Contribute to the creation and maintenance of disaster recovery plans.
Working as necessary with internal and external support functions when major incidents occur.
Assist the infrastructure team in sizing hardware used for the DB.
Take ownership of performance and capacity monitoring aspects of the DB.
Proactively manage and maintain security standards and controls.
Create a reliable backup strategy. Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality.
Performance testing and evaluation to ensure data security, privacy and integrity. Identification of bottle necks and deadlock issues.
Job Requirements
Ability to use Shell Scripting with Bash.
Experience in Oracle 12c RAC based environment- architecture, installation, building, upgrading and maintenance of Oracle RAC based environment in production.
Strong practical experience of ORACLE in a production RAC (ASM) environment (11gR2).
Must be a self- starter with a strong attention detail.
Extensive experience in Oracle DataGuard replication and physical standby for Disaster recovery.
Knowledge and expertise in other DBs (Postgres, SQL server,…), NoSQL (Cassandra, Mongo DB), Python is more advantage.
Experience in database/application performance tuning and monitoring tools such as AWR, ADDM, ASH and Statspack.
Must have solid Oracle RAC and DataGuard experience.
In- depth knowledge and hands- on experience in the installation, configuration and troubleshooting of Oracle products and patches, including Oracle 12c, RAC, ASM, Clusterware, GoldenGate, Dataguard, Oracle Database Appliance (ODA), Oracle Enterprise Manager 12c.
Oracle management tools (Data Guard, RMAN, Data pump).
Good problem solver, focused and dedicated developer with ability to work on your own as well as with a team.
Operating system experience in Linux.
Minimum experiences: 5 years.
Strong working experience with RMAN configuration, Job maintenance and backup & recovery.
Hands on experience with DB standards and end user applications- translating capacity requirements in infrastructure deployment technology.
Extensive experience with Oracle database installation / configuration best practices and Database upgrade/migration approaches.
Work Place:
Da Nang.