Job Description

JOB DESCRIPTION

JOB TITLE:

Jr. Database Developer

DEPARTMENT:

Product Development - DBA

REPORTS TO:

Senior Manager of Database Systems

FLSA STATUS:

NA

Job Summary

:

This job description in no way states or implies that these are the only duties to be performed by the employee in this position. Employee will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments
A Jr. Database Developer, is mainly responsible for design, develop, implement, and maintain high-performance, resilient, and scalable database solutions.

Key Responsibilities:

SQL & PL/SQL Development:

Assist in evaluating database schema changes and assist in creating and implementing SQL scripts under the guidance of senior team members. Work on writing basic SQL queries for data extraction and report generation. Learn and apply techniques for optimizing SQL queries, with a focus on improving performance and efficiency. Assist in the design and implementation of basic PL/SQL scripts, stored procedures, and triggers.

Database Integrity:

Support in database schema and data comparison to identify discrepancies under supervision. Assist in maintaining consistency across different database environments (Oracle and SQL Server).

Schema Management:

Learn and assist in designing and developing database schemas to meet application requirements. Assist with schema version control using appropriate database tools. Collaborate with senior team members to understand the impact of schema changes.

Database Artifacts for Product Packages:

Assist in creating and maintaining basic database artifacts (such as SQL scripts, stored procedures, and ER diagrams). Ensure that database-related artifacts are properly documented and versioned in coordination with the development team.

Creating Database ERDs (Entity-Relationship Diagrams):

Learn to design basic ERDs and assist in maintaining accurate representations of database structures. Collaborate with developers to understand database relationships and assist in updating ERDs.

Database Management & Administration:

Assist in the installation and configuration of databases. Perform basic database maintenance tasks under supervision.

Database Backup, Restore, and Maintenance:

Learn and assist with regular database backup procedures. Support senior DBAs with database restoration and troubleshooting as required.

Troubleshooting & Incident Resolution:

Assist in identifying and troubleshooting simple database issues. Report database problems and issues promptly to senior DBAs for resolution.

Documentation:

Maintain documentation of database changes and ensure proper tracking of updates.

Required Education/Experience:

Bachelor's degree in Engineering, Computer Science, Information Technology, or a related field.

Required Skills:

Basic knowledge of SQL and PL/SQL. Strong analytical and problem-solving abilities. Ability to learn and apply new technical concepts quickly. * Strong communication skills.