Install, configure, and maintain relational and/or NoSQL databases (e.g., SQL Server, MySQL, PostgreSQL, Oracle, MongoDB).
Monitor database performance and optimize queries, indexing, storage, and configurations.
Implement, manage, and test
backup and disaster recovery (DR)
strategies.
Ensure high availability through clustering, replication, and failover mechanisms.
Perform regular database upgrades, patches, and security updates.
Troubleshoot database issues related to performance, connectivity, and data integrity.
Collaborate with developers to optimize SQL queries, stored procedures, and schema design.
Manage user roles, permissions, and authentication following security best practices.
Monitor database capacity, plan for scaling, and forecast storage requirements.
Implement automated scripts for maintenance tasks using Shell, PowerShell, or Python.
Support ETL processes, data migration projects, and integrations.
Maintain documentation for database architecture, configurations, procedures, and policies.
Participate in on-call rotations for critical database support.
Required Skills & Qualifications
Bachelor's degree in Computer Science, Information Technology, or related field.
Strong hands-on experience with at least one major RDBMS:
SQL Server, PostgreSQL, MySQL, Oracle
, or
MariaDB
.
Deep knowledge of SQL, stored procedures, triggers, indexing, and query optimization.
Experience with database performance tuning and monitoring tools (e.g., SQL Profiler, pgAdmin, OEM, SolarWinds, Dynatrace).
Strong understanding of backup/restore strategies, clustering, replication, and high availability.
Knowledge of database security, encryption, and compliance standards.
Experience with scripting languages such as PowerShell, Bash, or Python.
Familiarity with Linux/Windows server environments.
Excellent troubleshooting, analytical, and documentation skills.
Job Type: Full-time
Pay: $70,000.00-$120,000.00 per year
Work Location: In person
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.
Job Detail
Job Id
JD3238474
Industry
Not mentioned
Total Positions
1
Job Type:
Full Time
Salary:
Not mentioned
Employment Status
Permanent
Job Location
Toronto, ON, CA, Canada
Education
Not mentioned
Apply For This Job
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.