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 systems3. 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 alignment4. 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-GuardPerform 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 OracleSolid exposure to AlloyDB in GCP (a version of PostgreSQL)Extensive hands-on experience with Oracle to AlloyDB (PostgreSQL) migrationsMost importantly, excellent communication skills, capable of effectively engaging with(ref : hirist.tech)