- Collaborate with software development teams to understand database requirements and optimize data storage and retrieval processes.
- Design, develop, and implement database solutions using SQL programming and related technologies.
- Write efficient and optimized SQL queries, stored procedures, and functions to meet application requirements.
- Develop and maintain database schemas, tables, and relationships to ensure data integrity and consistency.
- Participate in performance tuning and optimization of database systems for improved speed and efficiency.
- Troubleshoot and resolve database-related issues, such as data inconsistencies, performance bottlenecks, and system failures.
- Collaborate with Data Architects to ensure that database designs align with overall data architecture and best practices.
- Implement security measures to protect sensitive data and ensure compliance with relevant data protection regulations.
- Work closely with QA teams to validate and verify data accuracy and quality.
- Stay current with industry trends and emerging database technologies to suggest improvements and innovations.
- Provide technical guidance and support to development teams regarding database-related matters.
Requirements:
- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
- Proven experience as an SQL Software Developer or a similar role.
- Proficiency in SQL programming and strong knowledge of relational database concepts.
- Experience with database management systems such as Microsoft SQL Server, MySQL, or PostgreSQL.
- Ability to write efficient and optimized SQL queries, stored procedures, and functions.
- Familiarity with database design principles and normalization.
- Knowledge of database performance optimization techniques.
- Strong problem-solving skills and attention to detail.
- Excellent communication and collaboration skills.
- Understanding of data security and compliance requirements.
- Experience with data migration and ETL processes is a plus.
- Familiarity with NoSQL databases is a plus.
- Knowledge of version control systems such as Git is a plus.
- Previous experience in software development is a plus.