Database Administrator - PostgreSQL/Oracle DB

Role : PostgreSQL DBA + Oracle DBA (Early joiner)

Shift : 2 PM to 11 PM

Mode : Hyderabad

Job Description :

Requirements :

1. Database Management :

- Design, development, administration and optimization of database systems and infrastructure solutions required for the internal business application-systems employed to conduct operations in satellite broadband data network services.

- Design database solutions for Oracle, Atlas MongoDB, and PostgreSQL

2. Monitoring and Performance Optimization :

- Monitor and analyze database usage trends to forecast future capacity needs.

- Plan and implement measures to scale the database infrastructure to accommodate growth.

- Collaborate with development teams to optimize database interactions in applications.

- Design, install, configure, maintain, and upgrade the Oracle Enterprise Manager system for real-time enterprise-wide central database monitoring across all systems

3. Collaboration and Communication :

- Work closely with development teams to understand application requirements and provide operational support.

- Facilitate communication between development, operations, and quality assurance teams to ensure alignment

4. Automation and Scripting :

- Develop automation solutions using Ansible playbooks and Unix shell scripting for database deployments, maintenance & upgrade operations, and for data obfuscation/masking.

- Develop and code application scripts for the collection and storage of data statistics, reorganizing and cleaning data tables and indexes, and enhancing data-access and execution performance/user data management.

5. Database Backup and Recovery :

- Develop disaster recovery solutions using Zerto for databases, Oracle Data-Guard

- Perform database backup and recovery using Oracle RMAN and expdp/impdp utilities.

6. Security and Compliance :

- Plan and implement rules and processes for User Management and access.

- Implement and enforce security best practices and policies for application and infrastructure.

- Ensure compliance with relevant regulations and standards (e.g., PII, PCI)

7. Incident Management and Troubleshooting :

- Respond to and resolve operational issues, outages, and incidents.

- Perform root cause analysis and implement preventive measures to avoid future incidents.

8. Security Management :

- Implement network security protocols and ensure compliance with security policies.

- Respond to and manage security breaches or threats.

Benefits :

- Senior-level PostgreSQL DBA experience, with some background in Oracle

- Solid exposure to AlloyDB in GCP (a version of PostgreSQL)

- Extensive hands-on experience with Oracle to AlloyDB (PostgreSQL) migrations

- Most importantly, excellent communication skills, capable of effectively engaging with