Database Developer

Job Responsibilities:

1. Database Design and Development:

   • Design, develop, and maintain database systems for applications.
   • Optimize database structures and queries for performance.

2. Query and Script Writing:

   • Create and optimize SQL queries, stored procedures, and triggers.
   • Address complex query performance issues.

3. Data Integration and ETL:

   • Develop and manage data integration processes using ETL tools.
   • Ensure accurate data migration and transformation between systems.

4. Database Maintenance:

   • Monitor database performance and implement optimizations.
   • Conduct routine maintenance tasks such as backups, indexing, and troubleshooting.

5. Collaboration:

   • Collaborate with software developers, data analysts, and business teams to meet data requirements.
   • Provide ongoing support for applications interacting with databases.

6. Compliance and Security:

   • Ensure database security and privacy in compliance with organizational policies and regulations.
   • Maintain and manage database access controls.

7. Documentation:

   • Create and update technical documentation for databases.
   • Maintain logs of system changes and updates.

Required Skills:

1. Technical Proficiency:

   • Expertise in SQL and relational databases (e.g., Oracle, MySQL, PostgreSQL, Microsoft SQL Server).

2. Programming Knowledge:

   • Familiarity with programming languages like Python, Java, or C# for database integration.
   • Experience with ORMs (Object-Relational Mapping), such as Hibernate, is a plus.

3. Tools and Platforms:

   • Proficient with database management tools and platforms.

4. Problem-Solving Skills:

   • Strong ability to troubleshoot performance issues efficiently.
   • Analytical mindset to address complex data-related challenges.

5. ETL and BI Tools:

   • Experience with ETL tools like SSIS, Informatica, or Talend.
   • Familiarity with BI tools like Tableau or Power BI is a plus.

6. Version Control and CI/CD:

   • Experience with version control systems (e.g., Git) and CI/CD pipelines for database changes.

Qualifications:

• Education:

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

• Experience:

  • 4-5 years of hands-on experience in database development or administration.