About the Job
We are seeking a highly skilled Senior Database Administrator (PostgreSQL/Oracle) with strong expertise in database design, optimization, automation, and security. This role will be responsible for managing and scaling enterprise-grade database systems that power our satellite broadband data network services. The ideal candidate will have hands-on experience in PostgreSQL, Oracle, MongoDB, and AlloyDB, with proven success in Oracle-to-PostgreSQL migrations. This role requires not only technical depth but also excellent communication skills to collaborate effectively with cross-functional teams and business stakeholders.
Education Requirements
- Bachelor’s degree in a related discipline.
Experience 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.
- Conduct regular security assessments and audits to identify vulnerabilities.
- Respond to and manage security breaches or threats.
