Sr. SQL Server Database administrator to design, configure, maintain, and optimize a SQL Server[]

3 weeks ago


Old Toronto Ontario, CA S I Systems Full time
Sr. SQL Server Database administrator to design, configure, maintain, and optimize a SQL Server Database for a Fin-Tech Client

Our Fin-Tech Client is in need of a Sr. SQL Server Database administrator to design, configure, maintain, and optimize a SQL Server Database

In response to the rapidly changing payments landscape and the multiyear Payments Canada modernization initiative. Our clients resources are in year two of a multi-year project to move to a payments as a service model with their vendor. They are also intent upon streamlining the payments functions between the three Centrals. The goal is to ensure prairie credit unions are competitive in payments and have access to efficient, cost-effective, modernized payments processing infrastructure.

Must Have:

  • 6+ years experience as a SQL Server Database Administrator (DBA) managing relational databases in a production environment
  • database design , installation, configuration , and maintenance
  • database performance tuning and optimization techniques.
  • 4+ years experience writing complex SQL queries , stored procedures, triggers, and functions, etc.
  • 1+ years experience with high availability and disaster recovery solutions
  • database mirroring, log shipping, and clustering.
  • SQL Server Administration Certificate

Nice to Haves:

Key Responsibilities

The SQL DBA will be responsible for the design, development and sustainment of the SQL Server Environment, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. Provide expertise with enterprise application for database usage for OLTP type environment and associated database tools.

  • Manage and monitor SQL Server databases to ensure optimal performance, availability, and security.
  • Implement and maintain database backup and recovery strategies to minimize data loss and downtime.
  • Perform regular database maintenance tasks, such as index rebuilding, query optimization, and database tuning.
  • Proactively identify and resolve database performance issues and bottlenecks.
  • Collaborate with developers, system administrators, and other stakeholders to ensure efficient and effective use of database resources.
  • Develop and implement database security policies and procedures to protect sensitive data.
  • Monitor and analyze database performance metrics and provide recommendations for improvement.
  • Plan and execute database migration and upgrade projects.
  • Troubleshoot and resolve database-related problems in a timely manner.
  • DBA on-call support
  • Daily checks and action on monitoring alerts
  • Apply SQL Server patches
  • Set up and maintain SQL database backups
  • Retrieve backups for application users
  • Restoration of databases if required
  • Provide user permission support as per client request
  • Major incident service calls
  • Engagement on performance issues
  • Provide suggestions and solutions as part of RCA or design remediations
  • Perform scheduled maintenance and supporting release deployment activities after hours (ex. ensure SQL services are up and running after server maintenance)
  • DR test
  • Database migration to different server
  • Database upgrade (to newer version or different edition)
  • Install new SQL Server instances
  • SQL Server instances unreachable (Send SMS alert to on-call person)
  • Low disk space usage (Send SMS to on-call person if usage over 90%)
  • Tagging but not alerting: Database backup failures, Overdue database backups, Blocking sessions, High CPU usage.
  • Top queries, server CPU and memory usages, types of wait
#J-18808-Ljbffr

  • Old Toronto, Ontario, CA Precision Castparts Full time

    Summary:Responsible for the implementation, configuration, maintenance, and performance management of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our division applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.The...


  • Old Toronto, Ontario, CA Momentum Financial Services Group Full time

    Momentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing store, we provide access to...


  • Old Toronto, Ontario, CA Broadridge Full time

    At Broadridge, we've built a culture where the highest goal is to empower others to accomplish more. If you’re passionate about developing your career, while helping others along the way, come join the Broadridge team. We are currently seeking a highly skilled and detail-oriented Database Lead. Selected candidate will join a global DB Operations team...


  • Old Toronto, Ontario, CA Talentworld Full time

    Put your Oracle 12c & 19c skills to work in an exciting role where you'll manage and enhance a vital database infrastructure. Take charge of RMAN backups, data encryption, SQL optimization, and OEM management. Enjoy a flexible hybrid work model while contributing to essential applications and systems. Ready to drive excellence? Apply today!TalentWorld is...


  • Old Toronto, Ontario, CA Broadridge Full time

    At Broadridge, we've built a culture where the highest goal is to empower others to accomplish more. If you’re passionate about developing your career, while helping others along the way, come join the Broadridge team. We are currently seeking a highly skilled and detail-oriented SQL Server and related DB technologies Operations specialist to join our...

  • SQL Developer

    1 month ago


    Old Toronto, Ontario, CA Nexus Systems Group Inc. Full time

    Location Address: Toronto – hybrid – onsite 3x/week Contract Duration: 10 months Possibility of extension & conversion to FTE Number of Positions: 1 Schedule Hours: 9am-5pm Monday-Friday (Possible OT) Reason: additional workload Story Behind the Need Business group: Global Cash Management The team focused on internal treasury reporting around liquidity...

  • Senior Data Engineer

    1 month ago


    Old Toronto, Ontario, CA Insight Global Full time

    Job DescriptionInsight Global is seeking a Senior Data Engineer to join a global housing market data insights and solutions firm. As a Senior Data Engineer, you will play a crucial role in designing, implementing, and optimizing our data infrastructure. You will be embedded in an application scrum team working on a large-scale application. Your expertise in...


  • Old Toronto, Ontario, CA ALLTECH CONSULTING SVC INC Full time

    Job Description: • Creation of functional and technical specifications for database development, analyze requirements and help project team in solution, technical design, implementation, and support. • Work with the project team in completing all relevant and required documentation in alignment with OPS standards. Experience and Skill Set...


  • Old Toronto, Ontario, CA AddSource Full time

    Skills And Responsibilities5+ years of experience in application support on distributed technologies.Experience with ITIL Framework and processes - Incident Management, Problem Management, Change Management knowledge.Expertise in Scripting Language (Shell / Linux).Experience with Python and database skills - DB2, Oracle, SQL Server. Expertise in writing...


  • Old Toronto, Ontario, CA ACV Full time

    August 22, 2024If you are looking for a career at a dynamic company with a people-first mindset and a deep culture of growth and autonomy, ACV is the right place for you! Competitive compensation packages and learning and development opportunities, ACV has what you need to advance to the next level in your career. We will continue to raise the bar every day...

  • SQL Oracle Developer

    1 month ago


    Old Toronto, Ontario, CA PHM Search Group Inc. Full time

    Job Title:Database DeveloperEducation:Bachelor's Degree in Computer Science, Database Administration, Data Science, or a related fieldJob Summary:Ourclientprovides innovative health benefit solutions forCanadians. and has long been recognized as the leading alternative to the traditional insurance companies, by using technology, creative product...


  • Old Toronto, Ontario, CA CG Consulting Group Full time

    SQL, YAML, Power BI Developer - MontrealMultiple positions available for 2 clients in Montreal - two intermediate + two senior.Must have strong MS Power BI, SQL, YAML, and JavaScript experience; financial experience is preferred but not mandatory.French skills / Bilingual is NOT needed.Responsibilities:Design, develop, and maintain Power BI visualizations...


  • Old Toronto, Ontario, CA ProViso Staffing Full time

    Story Behind the Need: Business group: Cloud Engineering – main teams are responsible for creating platform (Kubernetes) and all connections for logging monitoring chargeback and setting up all processes around creating/establishing Cloud resources for different projects; creating processes for automating releases; spearheading creation and management of...

  • Intermediate Cloud

    3 weeks ago


    Old Toronto, Ontario, CA S I Systems Full time

    Intermediate Cloud (Azure) Administrator to migrate servers and applications to the cloud using Azure Site Recovery and Azure Migrate - RQ00076Our valued public sector client is seeking an Int. Cloud (Azure) Administrator to migrate servers and applications to the cloud using Azure Site Recovery and Azure Migrate - RQ00076Duration: 6 month contract...


  • Old Toronto, Ontario, CA Ministry of the Solicitor General Full time

    Come showcase your project management, team leadership and technical consulting expertise in data management and database administration with the Justice Technology Services Division at the Ministry of the Solicitor General. As a crucial member of our team, you will play a pivotal role in supporting mission-critical Police applications, leveraging your...

  • Senior OFSAA

    4 weeks ago


    Old Toronto, Ontario, CA Scotiabank Full time

    Title: Senior OFSAA / Datastage DeveloperRequisition ID: 204049Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.The TeamWe are looking for a Datastage Developer to join the Global Finance & Risk Technology group.Is this role right for you? In this role you will:Develop strategies for Extraction,...


  • Old Toronto, Ontario, CA ACV Full time

    If you are looking for a career at a dynamic company with a people-first mindset and a deep culture of growth and autonomy, ACV is the right place for you! Competitive compensation packages and learning and development opportunities, ACV has what you need to advance to the next level in your career. We will continue to raise the bar every day by investing...


  • Northwestern Ontario, Ontario, CA Pinchin Ltd. Full time

    GIS System Administrator IDS Any Pinchin Office (Hybrid) Pinchin is looking for an experienced GIS System Administrator to join the Integrated Digital Services (IDS) Team. The GIS System Administrator will be responsible for the management, maintenance, and optimization of the organization's Geographic Information System (GIS) infrastructure. This role...


  • Markham, Ontario, I3P, CA Pet Valu Full time

    Database Services Manager page is loaded Database Services Manager Apply locations 0001 – Markham Office time type Full time posted on Posted 3 Days Ago job requisition id R21202 Location: Markham, OntarioJob Description:Job OverviewA hands-on Manager Database Services who thrives in a dynamic work environment, this role involves leading a database...


  • Old Toronto, Ontario, CA ALLTECH CONSULTING SVC INC Full time

    Job Description: Experience and Skill Set Requirements: • The Corrections Systems Portfolio requires a temporary Programmer/Developer (L3) with 10+ years’ experience to support critical solutions in the portfolio, for the design, coding and unit testing of enhancements, troubleshooting, along with break/fix solutions support. • The successful proponent...