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:
Evaluate database schema changes and develop SQL scripts (Oracle and SQL Server) in accordance with company standards, ensuring they meet application requirements.
Design and implement complex queries with a focus on optimization and performance tuning.
Troubleshoot and resolve SQL query performance issues, improving scalability and efficiency.
Design, debug, and optimize PL/SQL scripts, stored procedures, functions, and triggers, ensuring performance and data manipulation accuracy.
Review and analyze SQL and PL/SQL code authored by developers and provide recommendations for performance improvement.
Collaborate with development teams to implement database solutions, providing feedback on design and performance.
Database Integrity:
Perform schema and data comparison to identify discrepancies and ensure data consistency between different environments.
Support synchronization efforts to ensure accurate data alignment across systems.
Schema Management:
Design, develop, and manage database schemas in line with application requirements and business logic.
Implement schema version control using appropriate database tools.
Conduct impact analysis of schema changes and coordinate their integration into the overall product.
Database Artifacts for Product Packages:
Create, maintain, and version control database artifacts, including SQL scripts, stored procedures, triggers, and ER diagrams, as part of product release packages.
Ensure database-related artifacts are documented, versioned, and aligned with the product development lifecycle.
Design and maintain ERDs that accurately represent the relationships and structure of the database.
Collaborate with business analysts, developers, and architects to translate business requirements into effective database design.
Regularly update ERDs to reflect changes in the schema and ensure they are aligned with product releases.
Database Management & Administration:
Install and configure Oracle and SQL Server databases, ensuring proper setup for required versions and configurations.
Perform regular database maintenance tasks, including monitoring and optimization.
Database Backup, Restore, and Maintenance:
Oversee regular database backup processes and ensure successful completion.
Restore databases from backups as required, ensuring minimal downtime and recovery of critical systems.
Monitor and report on backup processes, addressing issues proactively.
Troubleshooting & Incident Resolution:
Diagnose and resolve database issues, ensuring minimal system downtime.
Conduct root cause analysis of database failures and implement preventive measures.
Documentation:
Create and maintain detailed documentation for database changes, configurations, and other relevant updates.
Ensure proper tracking and sharing of knowledge within the team.
Required Education/Experience:
Bachelor's degree in Engineering, Computer Science, Information Technology, or a related field.
3-5 years of experience in Database Developer or related roles.
Required Skills:
Strong proficiency in SQL and PL/SQL, with a focus on performance tuning.
Solid understanding of database architecture, schema design, and optimization techniques.
Experience in database installation, backup, and recovery processes.
Strong analytical, problem-solving, and troubleshooting skills.
* Good communication skills for interaction with development teams and other stakeholders.
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.