This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
The database developer is responsible for the design and development of database objects and procedural code to support various products for the organization. The database developer also creates programs to populate and maintain the data in the department’s transaction processing and data warehousing systems. This involves the creation of ETL programs along with the supporting stored procedures, functions, triggers, and constraints. The position requires extensive hands-on experience developing database queries, ETL, and associated code in a Microsoft SQL Server environment.
Job Responsibility:
Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements
Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems
Design, develop and maintain SQL Server Reporting Services reports
Maintain source code for database and ETL projects
Ensure that projects build successfully in a continuous integration environment
Diagnose and resolve database performance issues
Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standard best practices
Analyzing requirements in order to create software designs
Estimation and timely completion of tasks
Documenting developed modules
Supporting application developers and software testers
Creating and executing unit tests for developed code
Resolving problems in the production system
Following quality assurance processes
Participate in daily team stand-ups, planning sessions, etc.
Requirements:
Experience with data modeling tools such as ER/Studio or ERWin
Experience using version control systems (e.g., TFS, Git)
Familiar with Agile software development process
8+ years of experience working with Microsoft SQL Server with emphasis on database code, ETL and Reporting Services development
Database design skills including normalization and data warehouse design
Strong hands-on T-SQL development skills including stored procedure, function, and trigger creation
Excellent query optimization and performance tuning skills
Extensive experience developing SSRS reports
Strong SSIS skills
Detailed analytical skills
Structured troubleshooting skills
BS in Computer Science or Information Systems
Nice to have:
Working experience with Azure DB technologies and Azure deployments is a plus