Job Title: Junior Database Administrator (DBA)
Job Summary:
We are looking for a Junior Database Administrator (DBA) to assist in managing, optimizing, and securing databases for efficient data storage and retrieval. The ideal candidate should have hands-on experience with SQL, database performance tuning, backup and recovery strategies, and database security. This role involves monitoring database health, troubleshooting performance issues, and working with development teams to ensure database efficiency and reliability.
Key Responsibilities:
- Install, configure, and maintain relational database management systems (RDBMS) such as MySQL, PostgreSQL, Microsoft SQL Server, and Oracle
- Monitor database performance, troubleshoot errors, and optimize queries for efficiency
- Assist in database backup, recovery, and disaster recovery planning
- Implement security measures such as user access controls, authentication, and encryption
- Support database maintenance tasks, including patching, indexing, and schema modifications
- Work with developers to optimize SQL queries, stored procedures, and indexing strategies
- Ensure data integrity, consistency, and normalization across database systems
- Automate database tasks using scripting languages (Python, Bash, PowerShell)
- Document database architecture, configuration, and troubleshooting steps
- Stay updated with database technologies, cloud-based solutions, and best practices
Skills and Knowledge Required:
- Proficiency in SQL and relational database management systems (RDBMS)
- Experience with database administration tasks, including indexing, query optimization, and performance tuning
- Understanding of database security principles, including encryption, authentication, and user role management
- Basic knowledge of ETL processes, data integration, and data migration
- Experience with database monitoring tools (SQL Profiler, SolarWinds, New Relic, Nagios)
- Basic familiarity with cloud databases (AWS RDS, Google Cloud SQL, Azure SQL) (optional)
- Scripting skills (Python, Bash, PowerShell) for automation (a plus)
- Familiarity with database backup and recovery tools such as RMAN (Oracle) and SQL Server Backup
- Strong problem-solving and analytical skills
Educational Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field
- Certifications in Database Administration (SQL Server, Oracle, AWS/Azure Databases) are a plus
Experience:
- 1-2 years of hands-on experience in database administration, optimization, or SQL development
- Experience in database performance tuning, troubleshooting, and backup strategies
Key Focus Areas:
- Database Performance Optimization & Monitoring
- Backup, Recovery, and Disaster Planning
- Security Implementation & Access Control
- Query Optimization & Indexing Strategies
Tools and Technologies:
- Database Systems: MySQL, PostgreSQL, Microsoft SQL Server, Oracle
- Query Languages: SQL, PL/SQL, T-SQL
- Database Management Tools: MySQL Workbench, pgAdmin, SQL Server Management Studio (SSMS), Oracle SQL Developer
- Backup & Recovery Tools: RMAN (Oracle), pgBackRest, SQL Server Backup
- Monitoring & Optimization Tools: SQL Profiler, SolarWinds, New Relic, Prometheus
- Version Control & Scripting: Git, Bash, Python, PowerShell
Other Requirements:
- Ability to work independently and collaborate with development teams
- Passion for database security, optimization, and performance enhancement
- Strong problem-solving skills and attention to detail
- Willingness to learn and adapt to new database technologies