Senior Database Developer
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Title:- Database Developer
Location :- Toronto ON (Hybrid)
We have new opening for Database developer, If you are available in the Job Market
We are looking for a hands-on Senior Database Developer with strong experience in database design, development, and optimization. The ideal candidate should have solid expertise in Microsoft SQL Server (MSSQL) and the ability to work independently on complex database development tasks within a fast-paced, financial services environment.
Key Responsibilities:
- Design and develop end-to-end database schemas, including tables, relationships, primary/foreign keys, indexes, and constraints based on business requirements.
- Build and maintain data models (conceptual, logical, and physical) ensuring data integrity, consistency, and performance.
- Develop and optimize complex SQL queries, stored procedures, and functions.
- Collaborate with application and analytics teams to integrate data models with reporting and operational systems.
- Implement data quality, governance, and version control processes for schema changes.
- Troubleshoot database performance issues and recommend design or indexing improvements.
- Work closely with architects to align database structures with enterprise data architecture and cloud strategy.
Required Skills and Experience:
- Strong hands-on experience in MS SQL Server (database design, development, and optimization).
- Proven experience in data modeling – building new data structures and schemas from scratch.
- Expertise in SQL query tuning and performance optimization.
- Solid understanding of data normalization, denormalization, relationships, and constraints.
- Experience working with ETL/ELT tools and data integration pipelines.
- Knowledge of data warehousing and dimensional modeling concepts.
- Excellent analytical, communication, and problem-solving skills.
Nice-to-Have Skills:
- Experience with Oracle, PostgreSQL, or similar RDBMS.
- Familiarity with CI/CD pipelines, DevOps tools, or automation in database development.
- Exposure to big data or streaming environments.
More about this job
Responsibilities
Design and maintain database schemas and data models, and develop and optimize SQL queries, stored procedures, and functions. Collaborate with application, analytics, and architecture teams to integrate data, improve performance, and support data quality, governance, and schema version control.
Requirements
Requires strong hands-on Microsoft SQL Server experience, including database design, development, data modeling, and SQL performance optimization. Candidates should also understand relational database principles and have experience with ETL/ELT, data integration, and data warehousing; experience with other RDBMS, CI/CD, or big data is an advantage.
Skills
- Microsoft SQL Server
- Database Design
- Database Development
- Data Modeling
- SQL Query Tuning
- Performance Optimization
- Data Normalization
- Data Warehousing
- Dimensional Modeling
- ETL/ELT
- Data Integration
- Data Quality
- Data Governance
- Database Indexing
- Oracle
- PostgreSQL
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Finance & Accounting
Keywords
- Microsoft SQL Server
- MSSQL
- Database Schemas
- Database Design
- Database Development
- Data Modeling
- Conceptual Data Models
- Logical Data Models
- Physical Data Models
- SQL
- Stored Procedures
- Functions
- Query Tuning
- Performance Optimization
- Indexes
- Data Integrity
- Data Normalization
- Denormalization
- ETL/ELT
- Data Integration Pipelines
- Data Warehousing
- Dimensional Modeling
- Data Quality
- Data Governance
- Version Control
- Enterprise Data Architecture
- Cloud Strategy
- Oracle
- PostgreSQL
- CI/CD