Job Description
• Should be able to write Complex Queries ? Must Have
• Knowledge of Oracle 12C ,18C and 1+C Database
• Knowledge of ATP and ADW database
• Implement appropriate indexes for performance improvement.
• Implement optimal backup and recovery.
• Understand and optimize query performance.
• Create and publish database health checks to monitoring systems for the following:
• Identify slow queries
• Replication lags
• Node failures
• Index usage patterns
• CPU usage
• Memory usage
• Locks
• Number of connections
• Any other relevant params
• Evaluate, plan and perform the DB upgrades.
• Maintenance during release/outage etc.
• Implementing best practices for backups, replication, and health checks.
• Database hardening implement best practices.
• Design and implement DR plans & HA solutions and recommendations.
• Work closely with the application team to understand what changes are coming in a build/patch/hotfix, do an impact analysis, fine-tune the queries if any.
• Automate the process of deploying DB changes so that we can support this for a new build/patch/hotfix.
• Act as an application DB during the design process.
• Installation and setup stand alone, multi node cluster and sharded cluster , resync replica set member, reconfigure existing replica set .
• Version upgradation and patching.
• User role and access management.
• Query profiling , performance diagnostic, slow query identification and optimization , implementation data archiving and purging policy,
• Strong scripting experience - Unix/Shell Scripting/ Python
• Technical knowledge of Linux & Windows-based platforms
• Strong analytical and problem-solving
• Knowledge of Oracle 12C ,18C and 1+C Database
• Knowledge of ATP and ADW database
• Implement appropriate indexes for performance improvement.
• Implement optimal backup and recovery.
• Understand and optimize query performance.
• Create and publish database health checks to monitoring systems for the following:
• Identify slow queries
• Replication lags
• Node failures
• Index usage patterns
• CPU usage
• Memory usage
• Locks
• Number of connections
• Any other relevant params
• Evaluate, plan and perform the DB upgrades.
• Maintenance during release/outage etc.
• Implementing best practices for backups, replication, and health checks.
• Database hardening implement best practices.
• Design and implement DR plans & HA solutions and recommendations.
• Work closely with the application team to understand what changes are coming in a build/patch/hotfix, do an impact analysis, fine-tune the queries if any.
• Automate the process of deploying DB changes so that we can support this for a new build/patch/hotfix.
• Act as an application DB during the design process.
• Installation and setup stand alone, multi node cluster and sharded cluster , resync replica set member, reconfigure existing replica set .
• Version upgradation and patching.
• User role and access management.
• Query profiling , performance diagnostic, slow query identification and optimization , implementation data archiving and purging policy,
• Strong scripting experience - Unix/Shell Scripting/ Python
• Technical knowledge of Linux & Windows-based platforms
• Strong analytical and problem-solving
💡 Quick Summary
Seeking a career-building opportunity? The Oracle DBA with SQL position is now open for candidates interested in the Database Administrator sector. This role in Bangalore offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.