Database Administration
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Experience
- Database Security & Monitoring 2+ years of Java and Spring Boot development experience.
- Posting language
- English
- Posted
Original job description
Key Responsibilities Database Administration Administer and support Microsoft SQL Server and Azure SQL Managed Instance environments.
Monitor database performance| availability| security| and capacity.
Implement and manage HA/DR solutions including Always On Availability Groups| replication| backup| and recovery.
Perform database patching| upgrades| migrations| and maintenance activities.
Troubleshoot production issues related to performance| locking| blocking| and connectivity. Database Development Design and develop T-SQL objects including Stored Procedures| Functions| Views| and Triggers.
Optimize SQL queries| indexing strategies| and execution plans.
Develop and support ETL processes using SSIS and Azure Data Factory (ADF).Collaborate with application teams to ensure database design follows best practices. Java / Spring Boot Development Develop| enhance| and support Java-based applications using Spring Boot.
Build REST APIs and microservices supporting enterprise applications.
Integrate Spring Boot applications with SQL Server and Azure SQL MI databases.
Participate in application troubleshooting| performance optimization| and production support.
Support CI/CD deployments and development best practices.(Spring Boot experience is desirable but not the primary focus of this role.)
Essential Skills
Required Skills7+ years of SQL Server DBA and Database Development experience.
Strong expertise in: Azure SQL Managed Instance (SQL MI)| T-SQL Programming
Query Optimization & Performance Tuning
SSIS| SSRS| Azure Data Factory
Database Security & Monitoring 2+ years of Java and Spring Boot development experience.
Experience with REST APIs and Microservices.
Exposure to Azure DevOps| Git| and CI/CD pipelines.
Strong troubleshooting and problem-solving skills.
Preferred Skills Experience with Azure cloud services and database migrations.
Knowledge of Power BI| Databricks| or Synapse.
PowerShell scripting and automation experience.
Azure or Microsoft SQL certifications preferred.
Monitor database performance| availability| security| and capacity.
Implement and manage HA/DR solutions including Always On Availability Groups| replication| backup| and recovery.
Perform database patching| upgrades| migrations| and maintenance activities.
Troubleshoot production issues related to performance| locking| blocking| and connectivity. Database Development Design and develop T-SQL objects including Stored Procedures| Functions| Views| and Triggers.
Optimize SQL queries| indexing strategies| and execution plans.
Develop and support ETL processes using SSIS and Azure Data Factory (ADF).Collaborate with application teams to ensure database design follows best practices. Java / Spring Boot Development Develop| enhance| and support Java-based applications using Spring Boot.
Build REST APIs and microservices supporting enterprise applications.
Integrate Spring Boot applications with SQL Server and Azure SQL MI databases.
Participate in application troubleshooting| performance optimization| and production support.
Support CI/CD deployments and development best practices.(Spring Boot experience is desirable but not the primary focus of this role.)
Essential Skills
Required Skills7+ years of SQL Server DBA and Database Development experience.
Strong expertise in: Azure SQL Managed Instance (SQL MI)| T-SQL Programming
Query Optimization & Performance Tuning
SSIS| SSRS| Azure Data Factory
Database Security & Monitoring 2+ years of Java and Spring Boot development experience.
Experience with REST APIs and Microservices.
Exposure to Azure DevOps| Git| and CI/CD pipelines.
Strong troubleshooting and problem-solving skills.
Preferred Skills Experience with Azure cloud services and database migrations.
Knowledge of Power BI| Databricks| or Synapse.
PowerShell scripting and automation experience.
Azure or Microsoft SQL certifications preferred.
More about this job
Responsibilities
Administer and support Microsoft SQL Server and Azure SQL Managed Instance environments, including performance monitoring and HA/DR implementation. Develop T-SQL objects and support Java-based microservices using Spring Boot.
Requirements
Requires over 7 years of SQL Server DBA and development experience and at least 2 years of Java/Spring Boot experience. Proficiency in Azure cloud services, ETL processes, and CI/CD pipelines is essential.
Skills
- Microsoft SQL Server
- Azure SQL Managed Instance
- T-SQL
- Query Optimization
- SSIS
- SSRS
- Azure Data Factory
- Java
- Spring Boot
- REST APIs
- Microservices
- Azure DevOps
- Git
- CI/CD
- Performance Tuning
- Database Security
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Software
- Technology
- Consulting
- Administrative
Keywords
- Microsoft SQL Server
- Azure SQL MI
- T-SQL
- SSIS
- SSRS
- Azure Data Factory
- Java
- Spring Boot
- REST APIs
- Microservices
- Azure DevOps
- Git
- CI/CD
- Always On Availability Groups
- Power BI
- Databricks
- Synapse
- PowerShell
- Database Administration
- Performance Tuning
- ETL
- Database Migration
- IT Services
- IT Consulting