Database Administrator

JPS Tech Solutions

New Brunswick

On-site

CAD 90,000 - 120,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

JPS Tech Solutions Pvt Ltd seeks a Database Administrator to design, secure, maintain, and optimize enterprise databases across SQL Server, Oracle, and Snowflake. The role emphasizes performance tuning, high availability, and BI reporting with SSRS/Power BI. Cloud experience with AWS or Azure is a plus, along with migration of Access databases.

The ideal candidate will manage security, backups, and maintenance while supporting enterprise IT projects and reporting needs.

Qualifications

  • Bachelor’s degree in Computer Science or related field with 2+ years of relevant experience.
  • 2 years building, maintaining, securing, and backing up Microsoft SQL Server databases.
  • 2 years with SQL clustering, mirroring, replication, scripting, stored procedures, functions, performance tuning, and troubleshooting.
  • 2 years with SSAS, SSIS, or SSRS.
  • 2 years with reporting tools such as Power BI and SSRS.

Responsibilities

  • Design, develop, administer, and secure enterprise databases.
  • Build, maintain, secure, and back up Microsoft SQL Server databases.
  • Develop database models, definitions, standards, and structures across platforms.
  • Implement SQL Server clustering, mirroring, replication, and high-availability solutions.
  • Develop and maintain SQL scripts, stored procedures, functions, and database objects.
  • Perform database performance monitoring, tuning, and troubleshooting.
  • Support SSAS, SSIS, and SSRS.
  • Develop and support reporting solutions using Power BI and SSRS.
  • Plan and coordinate database structure implementation and maintenance.
  • Support database security, backup, recovery, and data integrity requirements.
  • Participate in enterprise IT projects and align with IT standards.
  • Assist migrating legacy Access databases to SQL Server.
  • Support databases hosted in AWS and Microsoft Azure.

Skills

Database administration
Performance tuning
Security
Backup & recovery

Education

Bachelor's degree in Computer Science or related

Tools

SQL Server
Oracle
Snowflake
SSAS/SSIS/SSRS
Power BI

Job description

Job Summary

We are seeking a Database Administrator to design, secure, maintain, and optimize enterprise databases used to store and manage critical business information. The role will support database planning, development, administration, security, backup, and maintenance across enterprise database platforms. The ideal candidate will have hands‑on experience with Microsoft SQL Server, database performance tuning, high availability, reporting services, and database troubleshooting. Experience migrating legacy Microsoft Access databases to SQL Server is highly desirable.

Key Responsibilities
  • Design, develop, administer, and secure enterprise databases to support business applications and critical information systems.
  • Build, maintain, secure, and back up Microsoft SQL Server databases.
  • Develop and maintain database models, definitions, standards, and structures across supported platforms.
  • Implement and manage SQL Server clustering, mirroring, replication, and high-availability solutions.
  • Develop and maintain SQL scripts, stored procedures, functions, and database objects.
  • Perform database performance monitoring, tuning, optimization, and troubleshooting.
  • Support SQL Server Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS).
  • Develop and support reporting solutions using Power BI and SSRS.
  • Plan and coordinate database structure implementation and ongoing maintenance.
  • Support database security, backup, recovery, and data integrity requirements.
  • Participate in enterprise IT projects and ensure database solutions align with established IT standards and frameworks.
  • Assist with migrating legacy Microsoft Access databases to Microsoft SQL Server.
  • Support databases hosted in cloud environments, including AWS and Microsoft Azure.
Required Qualifications
  • Bachelor’s degree in Computer Science or a related field from an accredited college or university, along with at least 2 years of experience supporting an operating system, database management system, or related field; OR 2 years of experience at the Database Administrator 1 level or an equivalent position.
  • 2 years of experience building, maintaining, securing, and backing up Microsoft SQL Server databases.
  • 2 years of experience with SQL clustering, mirroring, replication, scripting, stored procedures, functions, performance tuning, and troubleshooting.
  • 2 years of experience with SQL Server Analysis Services, Integration Services, or Reporting Services.
  • 2 years of experience with reporting tools such as Power BI and SSRS.
Preferred Qualifications
  • 2 years of experience with Oracle databases.
  • 2 years of experience supporting cloud environments such as AWS and Microsoft Azure.
  • Experience migrating legacy Microsoft Access databases to SQL Server.
  • Experience with Snowflake.
Technical Skills
  • Database Platforms: Microsoft SQL Server, Oracle, Snowflake.
  • SQL Development: SQL scripting, stored procedures, functions, replication, clustering, mirroring.
  • Database Administration: Security, backup and recovery, performance tuning, troubleshooting, database maintenance.
  • Microsoft BI Tools: SSAS, SSIS, SSRS, Power BI.
  • Cloud Platforms: AWS, Microsoft Azure.
  • Migration: Microsoft Access to SQL Server.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Administrator
Database Administrator

Eizie • Kitamaat

On-site
CAD 90,000 - 120,000
Competitive salary
Health benefits
Professional development
+5
SQL Database Administrator
SQL Database Administrator

HCL Technologies Limited • Calgary

On-site
CAD 100,000 - 130,000
Database Administrator (Oracle & SQL Server)
Database Administrator (Oracle & SQL Server)

Astra-North Infoteck Inc. • Calgary

On-site
CAD 85,000 - 110,000
DBA
DBA

Virtusa Corporation • Toronto

On-site
CAD 110,000 - 170,000
Database Administrator - Senior
Database Administrator - Senior

The Code Crackers Inc. • Toronto

On-site
CAD 90,000 - 130,000
Database Administrator
Database Administrator

Tata Consultancy Services Limited • Calgary

On-site
CAD 80,000 - 110,000
Senior Database Administrator
Senior Database Administrator

Alberta Pensions Services Corporation (APS) • Edmonton

On-site
CAD 110,000 - 140,000
Database Administrator (MS SQL/Azure)
Database Administrator (MS SQL/Azure)

HRBrain Inc. • Toronto

On-site
CAD 96,000 - 107,000
11902
11902

Maarut • Toronto

On-site
CAD 120,000 - 150,000
Senior SQL Server DBA - High Availability & Security Expert
Senior SQL Server DBA - High Availability & Security Expert

Rubicon Path • Toronto

On-site
CAD 90,000 - 120,000