What are the responsibilities and job description for the Database Administrator -- MAZDC5784951 position at Compunnel Inc.?
Job Summary
The Database Administrator is responsible for managing and maintaining database environments within a SaaS-based, AWS-driven ecosystem. This role focuses on PostgreSQL administration, performance optimization, and ensuring database reliability, security, and scalability across cloud and on-premises platforms.
Key Responsibilities
- Manage daily operations of production and non-production database environments across cloud and on-premises systems
- Administer PostgreSQL databases, including installation, configuration, upgrades, and patching
- Monitor database performance, troubleshoot issues, and optimize queries and indexing strategies
- Develop and maintain backup and recovery processes to ensure data integrity and availability
- Implement and maintain database security controls and access management
- Review database designs and recommend enhancements for performance and scalability
- Support database migrations and integrations using AWS services such as DMS and Glue
- Contribute to database strategy and architecture for relational data platforms
- Collaborate with cross-functional teams to support data-related initiatives
- Provide guidance to stakeholders on database capabilities and improvements
- Support occasional after-hours activities as needed
Required Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Business, or a related field, or equivalent experience
- 5 years of experience in database administration
- Strong hands-on experience with PostgreSQL administration
- Strong SQL scripting skills including query optimization and performance tuning
- Experience with AWS services including Amazon Aurora, Redshift, AWS DMS, and AWS Glue
- Experience with Amazon RDS and Aurora PostgreSQL environments
- Understanding of Redshift architecture, access control, and security models
- Experience monitoring and troubleshooting database performance and availability
- Strong analytical, problem-solving, and communication skills
- Ability to manage multiple tasks and meet deadlines
Preferred Qualifications
- Database certifications in PostgreSQL or Oracle
- Experience with AWS Lake Formation and data lake environments
- Familiarity with Oracle databases
- Experience working in SaaS environments
Certifications
PostgreSQL or Oracle database certifications (if applicable)