Senior Database Developer/DBA

Posted via LinkedIn Recruiter (not a company profile)

Posted last month

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Senior Database Developer/DBA for 6-8 month hybrid contract in Toronto. Requires 10+ years Oracle/PL/SQL experience, PostgreSQL/MS SQL knowledge, and database performance tuning.

Responsibilities

  • Design, develop, and maintain database schemas, tables, views, indexes, and stored procedures in ETL application & DW packages. Develop and optimize PL/SQL packages, triggers, and functions for Oracle databases. Write efficient SQL queries and scripts for data manipulation and reporting. Development of programs/packages/procedures/functions in Oracle, PostgreSQL, MS SQL Server databases. Implement backup and recovery strategies and ensure data integrity and security. Collaborate with application developers and business analysts to support data-driven solutions. Troubleshoot and resolve database-related issues in development, test, and production environments. Document database architecture, processes, and configurations for compliance and auditing. The position involves majority of time in development & testing and very less time of DBA activities like installation of database software and creation/maintenance of databases.

Requirements

  • 10+ years of experience in Oracle Database and PL/SQL programming. Proficiency in SQL and query optimization techniques. Working knowledge of PostgreSQL and MS SQL Server databases. Experience with database performance tuning and indexing strategies. Understanding backup/recovery, high availability, and disaster recovery concepts. Familiarity with data modeling and normalization techniques. Experience with Unix/Linux environments and shell scripting. Exposure to BI tools and data warehousing concepts (ETL framework). Bachelor’s degree in Computer Science, Information Technology, or related field. Knowledge of cloud platforms (GCP). Experience in working with Telecom Inventory system and Telecom performance data. MUST be able to work 2 days in Toronto office, 3 days WFH. Only qualified candidates who meet the MUST HAVE requirements AND are Canadian Citizen, PR or open work permit.

Job type

Contractor

Experience level

Senior

Salary

Not specified

Degree requirement

Bachelor's degree

Tech skills

OracleSQLPL/SQLPostgreSQLMicrosoft SQL ServerUnix/Linuxshell scriptingGCP

Location requirements

Linkedin Recruiter PostTorontoOntario Toronto

Report this job

Found something wrong with the page? Please let us know by submitting a report below.