The SQL Developer will develop, optimize, and manage SQL databases, implement efficient structures and queries, and collaborate with stakeholders to refine data requirements while ensuring database security and optimal performance.
Important Information
- Experience: more than 4-6 years
- Job Mode: Full-time
- Work Mode: Hybrid
Job Summary
- Develop, optimize, and manage SQL databases to meet business requirements.
- Design and implement efficient database structures and queries.
- Collaborate with stakeholders to define and refine data requirements.
- Maintain and improve existing database systems and ensure optimal performance.
- Troubleshoot and resolve database-related issues to minimize downtime.
Responsibilities and Duties
- Design and maintain efficient database structures to support business needs.
- Develop and optimize complex SQL queries for data extraction, transformation, and reporting.
- Monitor database performance, troubleshoot issues, and implement necessary improvements.
- Automate data management tasks and streamline processes using advanced SQL techniques.
- Ensure the security and integrity of databases, including access controls and backups.
- Work closely with application developers and business analysts to support system requirements.
- Conduct code reviews to ensure adherence to best practices and coding standards.
- Provide technical support for database-related queries and reports.
Qualifications and Skills
- Bachelor’s/Master’s degree in Computer Science, Information Technology, or a related field.
- 4+ years of experience in SQL development and database management.
- Advanced proficiency in SQL and relational database systems (e.g. SQL Server, SSIS, T-SQL).
- Strong experience with query optimization and performance tuning.
- Knowledge of data modeling, schema design, and normalization principles.
- Familiarity with ETL tools and processes.
- Understanding of data warehousing concepts and practices.
- Excellent problem-solving and analytical skills.
- Strong communication and interpersonal skills for collaborating with stakeholders.
Role-specific Requirements
- Experience with Business Intelligence and reporting tools like Power BI, Tableau, or SSRS.
- Knowledge of version control systems (e.g., Git) and CI/CD pipelines for database deployment.
- Strong ability to document processes, workflows, and database structures
Technologies
- SQL and relational databases (SQL Server, SSIS).
- Business Intelligence and reporting tools: Power BI, Tableau, SSRS.
Skillset Competencies
- Database design and optimization.
- Query performance tuning and troubleshooting.
- Automation of data workflows and manual processes.
- Ensuring database security, backups, and recovery processes.
- Interpreting business requirements into efficient database solutions.
- Clear and effective communication with technical and non-technical stakeholders.
- Collaboration within international and virtual team environments.
About Encora
Encora is the preferred digital engineering and modernization partner of some of the world’s leading enterprises and digital native companies. With over 9,000 experts in 47+ offices and innovation labs worldwide, Encora’s technology practices include Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering.
At Encora, we hire professionals based solely on their skills and qualifications, and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.
Top Skills
SQL
Similar Jobs
Be an Early Applicant
The Senior SQL Developer will develop, maintain, and optimize complex SQL databases, design SSIS packages, perform data bulk operations, and collaborate with the DEV team to integrate database solutions. Strong skills in query optimization, reverse engineering, and business analysis are required, along with excellent communication abilities.
Be an Early Applicant
The Senior SQL Developer will develop, maintain, and optimize SQL databases and stored procedures, design SSIS packages for data integration, and collaborate with the development team to integrate database solutions. This role requires expertise in SQL Management Studio and Visual Studio, along with strong skills in data import/export, query optimization, and business analysis.
Be an Early Applicant
As a PHP Microservices Engineer at eduki, you will develop Microservices using PHP, integrate them into the existing infrastructure, and participate in architectural decision-making. The role involves working independently and collaborating within an international team to improve educational resources for teachers.
What you need to know about the Dublin Tech Scene
From Bono and Oscar Wilde to today's tech leaders, Dublin has always attracted trailblazers, with more than 70,000 people working in the city's expanding digital sector. Continuing its legacy of drawing pioneers, the city is advancing rapidly. Ireland is now ranked as one of the top tech clusters in the region and the number one destination for digital companies, with the highest hiring intention of any region across all sectors.
