Job Summary:
We are seeking an experienced and detail-oriented SQL Developer to join our database development team. The ideal candidate will have a strong proficiency in SQL and database management, with a focus on designing, implementing, and optimizing databases to support business applications and data-driven decision-making processes.
Responsibilities:
- Database Design and Modeling:
- Collaborate with application developers and business analysts to understand data requirements.
- Design and implement database schemas, tables, views, and functions to meet application and business needs.
- SQL Coding and Query Optimization:
- Write and optimize complex SQL queries to extract, transform, and load (ETL) data.
- Implement stored procedures, triggers, and functions to support application functionality.
- Database Performance Tuning:
- Monitor and analyze database performance, identifying and resolving performance bottlenecks.
- Optimize queries and indexing strategies to enhance overall database efficiency.
- Data Integrity and Security:
- Implement and enforce data integrity constraints.
- Work with the security team to ensure the implementation of access controls and data encryption.
- Data Migration and Integration:
- Plan and execute data migration and integration tasks between different databases and systems.
- Collaborate with ETL developers to streamline data flow processes.
- Backup and Recovery:
- Develop and implement backup and recovery strategies to safeguard critical data.
- Perform routine database backups and test recovery procedures.
- Documentation:
- Create and maintain comprehensive documentation of database schemas, processes, and configurations.
- Provide documentation for troubleshooting and support purposes.
Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Proven experience as a SQL Developer with a strong understanding of relational database concepts.
- Proficiency in writing complex SQL queries and database optimization techniques.
- Experience with database design tools and methodologies.
- Familiarity with performance monitoring tools and techniques.
- Knowledge of data warehousing concepts and ETL processes.
- Strong problem-solving and analytical skills.
- Excellent communication and collaboration skills.
