Ahmedabad, GJ, India
Information Technology
Other
Prodapt
Overview
Overview:
Oracle DBA:
Install, configure, and upgrade Oracle database software.
Apply quarterly patches for Grid and Oracle home
Configure and maintain standby database.
Monitor database performance and implement optimization strategies.
Ensure database security and compliance with organizational policies.
Perform regular backups and recovery operations.
Collaborate with developers to design and implement database solutions.
Troubleshoot and resolve database-related issues promptly.
Develop and maintain database documentation and standards.
Plan and execute database migrations and upgrades.
Setup Oracle golden gate both uni-directional and bidirectional.
Maintain Oracle Golden Gate synchronization with source.
Identify the Oracle Golden Gate sync related issues and implement the best practices.
Identify the performance issues and implement the best practices.
User creation and access management.
Storage capacity planning to ensure ASM and tablespace were maintained under threshold and avoided repetitive space related incidents.
Create and maintain RAC with Data guard.
Administration of RAC database.
AWS RDS instance administration, Rehydration, engine upgrade and certificate renewal
PostgreSQL Administration & Maintenance
Assist with the installation and basic configuration of PostgreSQL instances on Linux/Unix environments.
Assist with the installation and basic configuration of PostgreSQL instances on Linux/Unix environments.
Execute database upgrades and minor version patching under the guidance of senior DBAs.
Perform AWS RDS administration tasks, including instance rehydration, engine upgrades, and SSL/TLS certificate renewals.
Monitor storage and space management, ensuring tablespaces and disks do not reach critical thresholds.
Replication & High Availability
Monitor and maintain replication health using tools like repmgr or pgpool-II.
Monitor and maintain replication health using tools like repmgr or pgpool-II.
Support the setup of basic physical and logical replication; monitor lag and restart failed replication slots.
Understand and observe complex concepts like Multi-master or Group replication while assisting in their daily operational checks.
Troubleshooting & Performance
Identify performance bottlenecks using pg_stat_activity, pg_badger, and basic pgAdmin dashboards.
Identify performance bottlenecks using pg_stat_activity, pg_badger, and basic pgAdmin dashboards.
Troubleshoot common user issues, including connection limits, permission errors, and "generic" database errors.
Diagnose basic OS-level issues using Unix commands (CPU, Load, I/O) to ensure the database has sufficient resources.
Utilize monitoring tools like oswatcher to collect system-level metrics for senior review.
Backup, Recovery & Security
Perform and verify routine backups and restores using standard PostgreSQL utilities (pg_dump, pg_restore, or pg_basebackup).
Perform and verify routine backups and restores using standard PostgreSQL utilities (pg_dump, pg_restore, or pg_basebackup).
Manage user access, roles, and privileges (RBAC) to ensure security compliance.
Respond promptly to system alerts and incidents to minimize service disruptions.
Documentation & Collaboration
Maintain detailed documentation of database configurations, standard operating procedures (SOPs), and troubleshooting logs.
Maintain detailed documentation of database configurations, standard operating procedures (SOPs), and troubleshooting logs.
Collaborate with L1/L2 support teams to resolve escalated tickets and provide clear technical updates.
Interface with storage and network teams to help isolate issues affecting database connectivity or performance.
Oracle DBA:
Install, configure, and upgrade Oracle database software.
Apply quarterly patches for Grid and Oracle home
Configure and maintain standby database.
Monitor database performance and implement optimization strategies.
Ensure database security and compliance with organizational policies.
Perform regular backups and recovery operations.
Collaborate with developers to design and implement database solutions.
Troubleshoot and resolve database-related issues promptly.
Develop and maintain database documentation and standards.
Plan and execute database migrations and upgrades.
Setup Oracle golden gate both uni-directional and bidirectional.
Maintain Oracle Golden Gate synchronization with source.
Identify the Oracle Golden Gate sync related issues and implement the best practices.
Identify the performance issues and implement the best practices.
User creation and access management.
Storage capacity planning to ensure ASM and tablespace were maintained under threshold and avoided repetitive space related incidents.
Create and maintain RAC with Data guard.
Administration of RAC database.
AWS RDS instance administration, Rehydration, engine upgrade and certificate renewal
Similar Jobs
View All
1 Day ago
Senior Software Engineer I - Java Production Support
Information Technology
- Ahmedabad, GJ, India
Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data an...
1 Day ago
Sr .NET Full Stack Developer
Information Technology
- Ahmedabad, GJ, India
Job Description About Persistent We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our offerings and pro...
1 Day ago
Senior Technical Lead - C#, Python, C++
Information Technology
- Ahmedabad, GJ, India
Delhi, Delhi Job Summary The Senior Technical Lead will be responsible for providing technical leadership in c#, python, and c++ programming languages. The role involves leading a team of developers, designing and implementing technical solutions, an...
1 Day ago
Technology Services Business Analyst II
Information Technology
- Ahmedabad, GJ, India
Join Teleperformance – Where Excellence Meets Opportunity! Teleperformance is a leading provider of customer experience management, offering premier omnichannel support to top global companies. Our diverse service locations, including on-site and wor...
1 Day ago
Java FullStack Developer
Information Technology
- Ahmedabad, GJ, India
Project description As an Integration Engineer, you'll drive the design and delivery of integration components that connect Loan IQ with upstream and downstream systems. You'll lead technical implementation within your pod, mentor mid-level developer...
1 Day ago
C++ developer
Information Technology
- Ahmedabad, GJ, India
Job Description Strong programming skills in:C++ (mandatory)Good understanding of telecom protocols:SIP (mandatory)IMS / VoLTE (preferred)Hands-on with:Linux (process, memory, networking)Debugging tools (gdb, logs, traces)Experience in:Mu...
1 Day ago
Sr. Software Tester
Information Technology
- 15000 - 25000 INR - Monthly
- Ahmedabad, GJ, India
Job Title: Software TesterLocation: Goregaon East, MumbaiExperience: 1–2 YearsSalary: ₹15,000 – ₹22,000 per monthJob Description:We are looking for a Software Tester to ensure the quality and functionality of software applications. The candidate will...
1 Day ago
Senior Technical Lead - Java, Spring Boot, AWS, Docker
Information Technology
- Ahmedabad, GJ, India
Chennai, Tamil Nadu Job Summary The Senior Technical Lead will be responsible for leading technical teams in the development, implementation, and maintenance of Java applications using Spring Boot, Amazon Web Services, and Docker. The role involves e...
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in