Database DeveloperJob Responsibilities:Database Design and Development: Design, develop, and maintain database systems for applications. Optimize database structures and queries for performance.Query and Script Writing: Create and optimize SQL queries, stored procedures, and triggers. Address complex query performance issues.Data Integration and ETL: Develop and manage data integration processes using ETL tools. Ensure accurate data migration and transformation between systems.Database Maintenance: Monitor database performance and implement optimizations. Conduct routine maintenance tasks such as backups, indexing, and troubleshooting.Collaboration: Collaborate with software developers, data analysts, and business teams to meet data requirements. Provide ongoing support for applications interacting with databases.Compliance and Security: Ensure database security and privacy in compliance with organizational policies and regulations. Maintain and manage database access controls.Documentation: Create and update technical documentation for databases. Maintain logs of system changes and updates.Required Skills:Technical Proficiency: Expertise in SQL and relational databases (e.g., Oracle, MySQL, PostgreSQL, Microsoft SQL Server).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.Tools and Platforms: Proficient with database management tools and platforms.Problem-Solving Skills: Strong ability to troubleshoot performance issues efficiently. Analytical mindset to address complex data-related challenges.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.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.