About the job
Job Summary
We are looking for a proactive and detail-oriented Junior Database Administrator to join our IT team. In this role, you will support the day-to-day operations of our database infrastructure with a focus on ensuring high availability, reliability, and security of data systems—primarily PostgreSQL and SQL Server. Working closely under the supervision of a Senior DBA, you will assist in monitoring system performance, performing routine maintenance, optimizing SQL queries, and supporting database-related development activities. This is an excellent opportunity for someone eager to build a strong foundation in database administration within a dynamic, growth-oriented environment.
Key Responsibilities
- Assist in the installation, configuration, and ongoing maintenance of PostgreSQL and SQL Server database systems.
- Monitor database performance metrics and assist in identifying, diagnosing, and resolving issues related to performance bottlenecks and slow-running queries.
- Implement and maintain backup and recovery procedures, ensuring data integrity and minimal downtime.
- Support query tuning and optimization activities by analyzing execution plans and proposing indexing or refactoring strategies.
- Manage and maintain database security policies, including user accounts, access controls, and role-based permissions.
- Contribute to ETL processes, including data extraction, transformation, and loading between systems.
- Assist in data migration projects, both within on-premise systems and cloud environments.
- Collaborate with development and DevOps teams to support application releases and troubleshoot database-related issues.
- Keep accurate and up-to-date documentation for database architecture, configurations, standard operating procedures, and incident reports.
- Stay informed about new tools, technologies, and best practices related to database management.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or a related discipline.
- 1 to 2 years of hands-on experience in a database administration or support role.
- Solid understanding of relational database management systems (RDBMS) and core database concepts such as normalization, indexing, and transaction control.
- Experience working with PostgreSQL, SQL Server, or other enterprise-grade relational databases.
- Proficiency in writing, debugging, and optimizing SQL queries.
- Familiarity with database backup and recovery strategies and associated tools.
- Basic knowledge of Linux/Unix systems and exposure to shell scripting is a plus.
- Experience with cloud-hosted databases (e.g., AWS RDS, Azure SQL) is advantageous.
- Strong communication and collaboration skills with a willingness to learn and grow in a fast-paced environment.
