SQL Server Dba Analyst

Vous êtes unique, comme le sont votre parcours, votre expérience et votre façon de voir les choses. Ici, on vous encourage et on vous motive à donner le meilleur de vous-même, et on vous donne les moyens de le faire. Vous travaillerez avec des collègues dynamiques - experts dans leur domaine - qui sont impatients de partager leurs connaissances avec vous. Vous aurez des gestionnaires inspirants qui vous aideront à développer votre potentiel et à atteindre de nouveaux sommets. Chaque jour, vous aurez de nouvelles occasions de rendre la vie de nos Clients plus radieuse - ils sont au cœur de tout ce que nous faisons. Découvrez comment vous pouvez faire une différence dans la vie des gens, des familles, des collectivités - ici et partout dans le monde.

**Description de poste**:
**About the Role**

**What will you do?**
- T-SQL Programming (Views, Functions, Stored Procedures, Ensure performance, security, and availability of databases)
- PowerShell Programming
- Design and development of data union between various database management systems
- Build high-quality reusable code that can be used as a framework for data integration
- Responsible for monitoring and testing of SQL databases
- Creating and executing unit testing for every new functionality being developed
- Prepare documentations and specifications
- Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
- Collaborate with other team members and stakeholders.
- Manage small to medium size development projects
- Participate in projects throughout the entire project lifecycle, and define, manage, and track project deliverables using defined technologies
- Working independently in the team with ability to promote code across dev and test environments and ensuring quality code is delivered into test and production
- Assisting with problem support and resolution
- Troubleshoot databases to identify and correct malfunctions and other operational difficulties
- Support project development following documented standards, policies and procedures (Change Management Process)
- Participate, on occasion, in after-hours and weekend support of production implementations, and various disaster recovery exercises
- Define, document, and implement consistent standards and procedures
- Contribute ideas for best practice improvements, process improvement, and innovative solutions

**What experience and skills should you have?**
- University degree in Computer Science or related information technology degree/diploma
- 3+ years of experience working with multiple platforms and types of data repositories (Relational, NOSQL, Datawarehouse, OLAP, OLTP etc.)
- Experience/familiarity with the operations and maintenance of production database systems
- Understanding of relational schema design, index design, operation optimization, query (or explain) plans
- Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
- Expert of Object-oriented programming in order to write robust and re-usable code.
- Expert in PowerShell scripting
- In-depth experience in data management using tables, views, packages, procedures, functions, triggers, permissions, etc.
- Fast learner
- Problem solving, technical and conceptual skills
- Ability to lead technical discussions and self manage workloads
- Excellent interpersonal and communication skills
- Strong organizational skills with the ability to multitask efficiently
- Ability to contribute solutions that meet or exceed business requirements

**What would you be nice to have**:

- 3+ years advanced administration experience in SQL
- Demonstrated understanding of the MongoDB query and command functionality, e.g. CRUD operations, Aggregation framework, etc.
- Expertise in snapshot, import/export, db optimization with the help of explain plan.
- Expertise in database migration Innodb storage engine to increase performance and betterment of integrity constraints.
- Experience with identifying and correcting slow operations, using log analysis (experience using mtools a plus)
- Holding a certification of Microsoft certified DBA or developer
- A developer background or experience working with development teams closely
- Experiences in any of the NoSQL (DynamoDB, Neptune or other), Redshift, MySQL, Oracle, or Sybase
- Understanding or experience working with CloudWatch, CloudTrail, AWS Config, AWS Backup and/or AWS DMS
- CloudFormation, Glue and/or Lambda scripting experience
- Understanding or experience with DevOps or Agile methodologies
- Experience with Security Architecture(s)
- Knowledge of database backup and recovery strategies (including DR strategies)
- Experience working in the AWS cloud environment is strongly desired
- Experience working with Django and Angular web languages
- Experience with coding in Python
- Knowledge of Data Warehousing
- Knowledge of REST API, JSON, XML an Asset

This role requires a minimu