Job Overview
We are seeking an experienced SQL Developer to join GAM DNA team. The successful candidate will design, develop, and maintain database solutions that support our business reporting, data flows, and job scheduling initiatives. You will be responsible for developing stored procedures for business reporting, creating and managing SSIS packages to facilitate efficient data flows, and monitoring active batch processes to schedule and optimize jobs. Your work will directly impact decision-making and operational efficiency across the organization.
Key Responsibilities
- Design, develop, and maintain stored procedures that support business reporting needs.
- Optimize queries and database operations to ensure performance and reliability.
- Collaborate with business to translate reporting requirements into data flows/ Queries
- Create, manage existing SSIS packages to support data extraction, transformation, and loading (ETL) processes.
- Ensure data quality, integrity, and security throughout the data flow process.
- Work closely with data engineering and data architects to understand and implement best practices for data integration.
- Troubleshoot and resolve issues related to job execution and data flow interruptions.
- Develop and maintain automated scripts and workflows to enhance batch job scheduling and maintenance.
- Maintain comprehensive documentation for all developed procedures, packages, and job scheduling processes.
- Ensure that all database solutions adhere to company policies, industry regulations, and security standards.
- Assist with audits and implement improvements based on audit findings.
Must Have
- Proven experience in SQL development, including creating and optimizing stored procedures.
- Strong knowledge of SQL Server Integration Services (SSIS) for developing ETL packages.
- Familiarity with job scheduling and batch processing concepts.
- Proficiency in working with SQL Server and understanding of database design principles.
- Knowledge of UNIX-like operating systems and shell scripting skills.
- Ability to interpret business requirements and translate them into technical solutions.
- Strong problem-solving skills with a detail-oriented mindset.
- Bachelor's/master's degree in computer science, Information Technology, or a related field (or equivalent experience).
- Minimum 7-8 years of relevant experience in SQL development and database management.
Nice to have
- Experience with additional data integration tools and technologies.
- Proficiency in writing and optimizing code in at least one programming languages like Python.
- Familiarity with agile development methodologies.
- Knowledge of data warehousing concepts and data modelling best practices.
