Oracle DBA with SQL
Published date: 2024/01/10
- Location: Bangalore, Karnataka, India
• Should be able to write Complex Queries ? Must Have
• Knowledge of Oracle 12C ,18C and 19C 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 19C 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
0 page views
Related listings
-
Mongodb DBA /MS SQL DBADatabase AdministratorHello Folks We are hiring for L3 Support Mongodb DBA Or MS SQL DBA with one of our MNC Client (Permanent Role ) Skills : • L3 Level experience with MSSQL DBA / Mongodb DBA • Experience with databases hosted on Windows/ Linux is must. • Extensive expe...2026/11/09
-
Senior Database AnalystDatabase Administrator9993411707 Routematic from Nivaata Systems... Job Title: Sr. Database Programmer Analyst Location: Bangalore EXPERIENCED ONLY Responsibilities Technical 1. Translate and implement database re-engineering requirements to perfection using Microsoft and...2026/11/09
-
SAP HANA AdministratorDatabase AdministratorTyson Foods, Inc. (NYSE: TSN) is one of the world’s largest food companies and a recognized leader in protein. Founded in 1935 by John W. Tyson and grown under three generations of family leadership, the company has a broad portfolio of products and ...2026/11/09