DBA (PostgreSQL/Oracle) in AWS

PradeepIT Consulting Services Pvt Ltd; Bengaluru; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A dynamic IT consulting firm in Bengaluru is seeking a DBA (PostgreSQL/Oracle) with 5 years of experience. The position requires expertise in database administration, performance tuning, and AWS cloud services. Work is hybrid with three days in the office and requires strong analytical and problem-solving skills. Join us to manage critical databases and ensure security and optimization for our clients.

Qualifications

• Proven experience as a DBA with expertise in PostgreSQL or Oracle.
• Strong understanding of relational database concepts and SQL.
• Hands-on experience with performance tuning and troubleshooting.

Responsibilities

• Manage master database of PostgreSQL and Oracle installations.
• Ensure database security and compliance with best practices.
• Develop backup and recovery strategies for critical data.

Skills

PostgreSQL database administration

Oracle database administration

SQL

Database performance tuning

Backup and recovery strategies

AWS services

Database security best practices

Analytical skills

Problem-solving skills

Tools

AWS

Terraform

CloudFormation

Database administration tools

Job description

About the job DBA (PostgreSQL/Oracle) in AWS

Overview

Work type: Hybrid (3 days a week).

Shift: 8:30 AM to 5:00 PM IST / 12:00 PM to 8:30 PM IST

Required Experience: 5 Years

Responsibilities

• Proven experience as a DBA, with specific expertise in PostgreSQL or Oracle database administration.
• Strong understanding of database concepts, including relational database models, SQL, and database architecture.
• Hands-on experience with database administration tools and utilities.
• Proficiency in performance tuning, optimization, and troubleshooting techniques.
• Knowledge of backup and recovery strategies, including disaster recovery planning.
• Familiarity with database security best practices and compliance requirements.
• Experience working within the AWS cloud environment, specifically with RDS, Aurora, EC2, S3, CloudWatch, CloudFormation, and IAM.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.

Qualifications

• Required Experience: 5 Years
• Required Skills: Proven experience as a DBA, with specific expertise in either PostgreSQL or Oracle database administration; strong understanding of database concepts, SQL, and database architecture; hands-on experience with database tools; performance tuning and troubleshooting; backup and recovery, security, and AWS services.

Desired Skills

• AWS Certifications (e.g., AWS Certified Database Specialty, AWS Certified Solutions Architect).
• Experience with other AWS services relevant to database administration.
• Experience with Infrastructure as Code (IaC) tools like Terraform or CloudFormation.
• Experience with database automation and scripting.
• Experience with both PostgreSQL and Oracle (even if specializing in one).