Data Engineer

LanceSoft

  • Montréal, QC
  • Permanent
  • Temps-plein
  • Il y a 22 jours
Location: Montreal (day 1 onboarding onsite / in-office attendance required 3x/week)
Years of Experience: 5-7 yearsThe candidate will be expected to work closely with our IT partners in analyzing and delivering on business requirements. Development will utilize an agile methodology, which is based on scrum (time boxing, daily scrum meetings, retrospectives, etc), and XP (continuous integration, refactoring, unit testing etc.) best practices. Candidates must therefore be able to work collaboratively, demonstrate good ownership and be able to work well in teams. Work will include designing, enhancing and developing applications across different database environments. The job will involve considering all aspects of the project life cycle and includes proof-of-concept evaluations, coding, designing, testing, implementing, deploying, and continued support of project releases as well as on-call Level 3 support. Collaboration with the firm’s engineering teams is expected.Major Role & Responsibilities:
  • Database Infrastructure Engineering for stability, scalability and capacity planning.
  • Application DBA functions: plan & execute database schema changes, bottleneck analysis, outage prevention/resolution, server/database performance improvements, database maintenance, database recovery, etc.
  • Database development (stored procedures, ETL, tools) and queries/stored procedures review and optimization.
  • Enforce database security, standards & guidelines.
Technical Skills Requirement:
  • 3-7 years of experience with relational databases - especially with DB2 Linux or Sybase
  • Scripting on linux platforms in languages such as Perl/Python and Unix / K-Shell
  • Strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts, memory management, database configurations, etc.
  • Create high quality and optimized stored procedures and queries
Skills Desired:
  • Knowledge of other databases like Greenplum is a big plus
  • Familiarity with Datalakes
  • Finance domain background is a plus.
  • Familiarity with CI/CD tools
*//
EEO Employer
Minorities/ Females/ Disabled/ Veterans/ Gender Identity/ Sexual Orientation
//*

LanceSoft