Type : Full Time
Location : Bengaluru
Experience Required : 6 Year(s)
Industry : IT-Software/Software Services
Preferred Skills : Database Administration Database Development Database Programming MySQL Oracle Oracle Database Perl Shell Script SQL
Job Description :
Primary skills:
We are looking for a talented DBA with 6+ years of data center and MySQL experience, committed to doing great work and having fun at the same time. Ideal candidates should be passionate to build elegant solutions, high quality implementation, and troubleshoot complex issues.
Responsibilities:
-Designs, installs and maintains (including patching) Oracle databases required for testing & production instances.
-Troubleshooting during outages and performance issues this will be No.1 requirement
-Should be able to work in a large data center production enviornment and take care of operational issues such as change requests (tickets), incidents, troubleshooting, RCA, etc.
-Requires to be on-call for 12X7 on a rotational basis
-Setups and maintains Oracle database replications using Oracle Goldengate and Dataguard
-Performs ongoing tuning of the database instances.
-Identify & automate manual tasks using SQL & shell / perl.
-Enforces and maintains database contraints to ensure integrity of the database.
-Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
Qualifications:
-Oracle DBA experience in large data center production environment
-A good knowledge of O/S and physical database design
-Ability to perform both Oracle and also operating system performance monitoring and the necessary adjustments.
-Excellent knowledge of Oracle backup and recovery scenarios.
-Proficient in designing in implementing high availability and disastor recovery solutions using Oracle Goldengate and Dataguard
-Excellent knowledge of Oracle Goldengate bi-directinal and peer-to-peer replication