Sql Server Dba Analyst

North York, ON, Canada

Job Description

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

:

About the Role

The candidate will be a contract database developer for the No-SQL Databases team within Data Management Services (DMS). The No-SQL database team is responsible for support various cloud based and on-premises database platforms. The successful candidate will have a passion for database development related technologies and will need to be able to pick up, understand and become proficient in a wide range of database products in a short period of time. This is an opportunity for someone who is willing to become a developer in multiple database platforms and architectures, including NoSQL and SQL, OLTP, and OLAP. An ideal candidate would have 3 to 5 years of experience in relational and non-relational database technologies such as SQL Server, PostgreSQL, Oracle, MySQL, MongoDB etc. We also welcome new graduates who have majored in computer engineering, computer science or other computer-related majors who have a satisfying GPA, the ambition, and the confidence to learn on their jobs.

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
  • Work closely with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services
  • 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.
  • Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of Database as well as frontend. With different project development model like SDLC, Agile, SCRUM etc.
  • 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 minimum of five years Canadian residency.

What's in it for you:
  • Joining an organization that the industry calls 'one of the best places to work'
  • Being part of our journey in developing the next greatest digital experience
  • Flexible Benefits from the day you join to meet the needs of you and your family
  • Wellness programs that support the three pillars of your health - mental, physical and financial
  • An extensive support system for continual learning including company-run courses, access to online learning platforms, opportunity for rotations, etc.
  • A flexible work schedule, as long as it includes core working hours
The Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results.

Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.

Persons with disabilities who need accommodation in the application process or those needing job postings in an alternative format may e-mail a request to .

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range: 58,700/58 700 - 93,900/93 900

Job Category: IT - Technology Services

Posting End Date:

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD2061776
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    $58700 - 93900 per year
  • Employment Status
    Permanent
  • Job Location
    North York, ON, Canada
  • Education
    Not mentioned