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 Applications Development Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.
Job Responsibility:
Design, develop, and implement robust, scalable, and secure database solutions (e.g., schemas, tables, views, stored procedures, functions, triggers, indexes, complex PLSQL codes) primarily using [e.g., MSSQL Server, Oracle]
Collaborate with application developers to define data structures, enforce data integrity, and ensure efficient data access
Write and optimize complex SQL queries and ETL processes for data extraction, transformation, and loading. Proficiency in using advanced features like cursors (including REF CURSORS), collections (NESTED TABLES, VARRAYS, INDEX BY TABLES), bulk binding (BULK COLLECT, FORALL), autonomous transactions, and dynamic SQL
Develop and maintain scripts for database automation, routine tasks, monitoring, and data manipulation using shell and/or batch scripting
Experience with data loading and extraction using tools like SQL*Loader and Oracle-supplied packages (UTL_FILE, DBMS_JOB, DBMS_SCHEDULER, DBMS_SQL)
Monitor database performance, identify bottlenecks, and implement solutions for performance tuning and optimization (e.g., query optimization, indexing strategies)
Perform database capacity planning and contribute to architectural decisions related to database infrastructure
Develop and maintain documentation for database designs, configurations, and operational procedures
Ensure data security, integrity, and availability through best practices, including backup and recovery strategies
Troubleshoot and resolve database-related issues in development, testing, and production environments
Participate in code reviews and contribute to the continuous improvement of database development standards and processes
Stay up to date with emerging database technologies and trends
Requirements:
2-4 years of professional experience as a Database Developer, SQL Developer, or similar role
Strong proficiency in SQL and experience with at least one major relational database system (e.g., MSSQL Server, Oracle)
Solid understanding of database design principles, data modeling (conceptual, logical, physical), and normalization
Good experience with shell scripting (Linux/Unix) and/or batch scripting (Windows) for automation and task execution
Experience with performance tuning and optimization techniques, including query analysis and indexing
Familiarity with ETL processes and tools
Experience with version control systems (e.g., GitHub, Light Speed Enterprise)
Excellent problem-solving and analytical skills
Strong communication and interpersonal skills, with the ability to work effectively in a team environment
Nice to have:
Experience with NoSQL databases (e.g., Redis) is a plus
Familiarity with cloud database services (e.g., AWS RDS, Google Cloud SQL)
Knowledge of data warehousing concepts and Business Intelligence (BI) tools