Search Jobs
Search by job, company or skills
Search by job, company or skills
Position: Sr DBA Administrator
Location: Bangalore / Hybrid / Remote
Experience: 7-12 Years
Notice Period: Immediate to 30 Days
Job Description:
This role ensures databases are run effectively and securely. It requires a high focus on analysing and resolving the issues within the assigned SLA. It also needs a good sense of ownership of the problems and maintaining communication with concerned team to keep them updated on the status and work with various teams to get to the resolution. Must adhere to the guidelines while implementing changes to production. Production DBA Team.
Position Responsibilities:
Database Administration experience with on-premise and cloud-based environments
Experience working on MySQL/Postgres/AWS RDS MySQL/Aurora /Postgres/ Amazon Redshift environment.
Experience working on OCI DBCS, ADW environment.
Working experience of Hadoop
Having knowledge of working with CLI command line tools like OCI CLI & Strong experience with Python
Proactive monitoring of databases both from a performance and capacity management perspective.
Experience with backups, restores and recovery models. Proactive housekeeping/ archiving
Experience in Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
Should have enough knowledge on OCI services like DBCS, Autonomous services, cloud storage, notifications and alarms.
Experience in monitoring Oracle databases via SQL developer, OMC tool, OCI metrics & performance hub.
Experience in implementing Oracle alerts via OCI alarm & metrics.
Experience in monitoring ASM usage and archive log usage via scripting.
Should have enough knowledge in troubleshooting Oracle tablespace issue, index issue & database mount issues.
Familiar with Oracle CDB's and PDB's and experience in moving PDB's across environments.
Should have knowledge on administrating and working with ADW database.
Experience in working with wallets and ability to create password-less wallets.
Familiarity with Database Monitoring and alerting tools SolarWinds DPA, CloudWatch, Opsgenie
Experience in troubleshooting and resolving database problems using various troubleshooting tools.
Ability to detect and troubleshoot and resolve database related CPU, memory, I/ O, disk space and other resource contention issues.
Experience in implementing operational automation using Shell/Perl/Python scripts
Perform database maintenance activities such as backup/recovery, replication, rebuilding and reorganizing indexes.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking/deadlocking issues, connectivity issues, data replication issues etc.
Experience in raising support ticket with various vendors like AWS, Oracle, Solarwinds and work with them and get issue to the closure.
Good interpersonal, communication and documentation skills.
Date Posted: 24/07/2024
Job ID: 86250867
Relevance Lab is a leading technology solutions and services company specializing in comprehensive IP-led services in Cloud, Automation, Product Engineering, and Data & AI. We offer purpose-built solutions and prebuilt platforms, catering to diverse client needs. Our expertise lies in integrating cutting-edge technology for fueling innovation alongside strategic methodologies and a DevOps approach focused on continuous improvement. This combination enables us to effectively address friction points for our clients, enhancing their capabilities to optimize customer experiences, modernize processes, and boost overall performance.
Cloud, Automation, Data and AI Services | Relevance Lab
