Jr. Database Administrator [URGENT HIRING]
Job Summary
The Junior Database Administrator (DBA) is responsible for supporting the administration, monitoring, security, and maintenance of the organization's MySQL and PostgreSQL database environments. The role assists in maintaining database performance, executing backup procedures, monitoring ETL/ELT processes, and supporting the Data Lake infrastructure to ensure reliable and secure access to business data.
Key Responsibilities
Database Administration
Monitor MySQL and PostgreSQL database health and performance.
Perform routine database maintenance activities.
Assist in database configuration, patching, and upgrades.
Support query tuning and optimization efforts.
ETL/ELT Operations
Monitor ETL/ELT jobs and investigate processing failures.
Assist in troubleshooting data synchronization issues.
Support data validation and reconciliation activities.
Data Lake Operations
Assist in maintaining Data Lake structures and storage organization.
Support file management, partitioning, and data retention activities.
Help maintain data quality and accessibility.
System Monitoring
Monitor database and pipeline alerts.
Escalate performance or availability issues as needed.
Maintain operational documentation and monitoring reports.
Security & Compliance
Assist in managing database user accounts and permissions.
Support security reviews and audit activities.
Ensure adherence to data governance and security policies.
Backup & Disaster Recovery
Execute scheduled backups and verify backup completion.
Assist in restoration testing and disaster recovery exercises.
Qualifications
Education
Bachelor's Degree in Computer Science, Information Technology, Information Systems, or related field.
Experience
1–2 years of experience supporting databases, data engineering, or related technical functions.
Technical Skills
Basic knowledge of MySQL and PostgreSQL.
Understanding of SQL query development and troubleshooting.
Familiarity with ETL/ELT concepts.
Basic understanding of Data Lake and data warehousing concepts.
Familiarity with Linux environments.
Preferred Skills
Exposure to AWS services such as RDS, S3, Glue, or Athena.
Experience with Python, Airflow, or similar automation tools.
Knowledge of backup and recovery processes.