Database Administrator at JPS Tech Solutions — NeverHard
Database Administrator at JPS Tech Solutions in New Brunswick, Canada. Skills: Database Administration, Database Performance Tuning, Database Troubleshooting, High Availability, Microsoft Access. Apply on NeverHard.
Company
JPS Tech Solutions
Location
New Brunswick, Canada
Type
not_specified
Required skills:
Database Administration
Database Performance Tuning
Database Troubleshooting
High Availability
Microsoft Access
Microsoft SQL Server
Power BI
Reporting Services
SQL
SSAS
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.
#J-18808-Ljbffr