Job Summary:
We are looking for a highly skilled Senior SQL Developer to lead the design, development, and optimization of our database systems and queries. As a pivotal member of the team, you will collaborate closely with data scientists, analysts, and business stakeholders to ensure our databases support analytical projects effectively and efficiently.
Key Responsibilities:
- Database Development: Design and implement relational databases to support various applications and business needs, ensuring data integrity and efficiency.
- SQL Query Optimization: Write efficient SQL queries to retrieve, manipulate, and update data, and continually optimize query performance.
- Database Maintenance: Monitor and troubleshoot database performance issues, including identifying and resolving bottlenecks, deadlocks, and other related problems.
- Data Migration: Assist in data migration activities from legacy systems to new platforms, ensuring data accuracy and consistency.
- ETL Processes: Develop and maintain Extract, Transform, Load (ETL) processes to integrate data from multiple sources into the database.
- Security and Compliance: Implement and maintain database security measures to protect sensitive data, adhering to industry best practices and regulatory guidelines.
- Reporting and Analysis: Collaborate with business analysts to develop and maintain data reports, providing valuable insights to stakeholders.
- Backup and Recovery: Perform regular database backups and ensure disaster recovery plans are in place to safeguard data.
- Documentation: Create and maintain technical documentation related to database designs, schema, and processes.
- Collaboration: Collaborate with cross-functional teams to understand data requirements and deliver solutions that meet business objectives.
Qualifications:
- Education:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Experience:
- 2-3 years of hands-on experience in SQL development, database design, and performance tuning.
- Strong understanding of SQL queries, joins, sub-queries, and database functions.
- Knowledge of SSIS, SSAS
- Familiarity with ETL tools and processes for data integration.
- Skills:
- Problem-Solving: Ability to analyze complex data-related problems and provide effective solutions.
- Team Player: Excellent communication and interpersonal skills to work collaboratively within a team.
- Detail-Oriented: Strong attention to detail in database design, development, and maintenance.
- Coding: Ability to write scalable, maintainable, and high-performance code.
- Communication skills: Strong communication and teamwork skills.
- Certifications:
- Any relevant certifications is a plus.
