Senior Database Developer Jobs in Ontario (NOW HIRING)

Responsibilities:<\/span><\/b>
<\/p>\n

\n
• De<\/span>signing and developing data pipelines from source to end user
  <\/span><\/li>\n
• Optimizing data pipelines
  <\/span><\/li>\n
• Creates physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery<\/span>
  <\/span><\/li>\n <\/ul>

   <\/span>
  <\/p>

  General Skills:<\/span><\/b>
  <\/p>\n

  \n
  • Experience <\/span>with one or more operating systems Experience with one or more database technologies
    <\/span><\/li>\n
  • Experience in one or more programming languages Experience in the use of information retrieval packages and proficiency with query languages Experience in monitoring and enforcing database rules
    <\/span><\/li>\n
  • Experience in Incident, Change and Configuration Management procedures
    <\/span><\/li>\n
  • Experience with one or more communications protocols Excellent analytical, problem\-solving and decision\-making skills; verbal and written communication skills; and interpersonal skills
    <\/span><\/li>\n
  • A team player with a track record for meeting deadlines<\/span>
    <\/span><\/li>\n <\/ul>

     <\/span>
    <\/p>

    Desirable Skills:<\/span><\/b>
    <\/p>\n

    \n
    • Experience <\/span>with distributed data systems
      <\/span><\/li>\n
    • Experience with middleware and gateways
      <\/span><\/li>\n
    • Experience with researching and implementing cyber security vulnerability remediations
      <\/span><\/li>\n
    • Awareness of emerging IT trends and directions
      <\/span><\/li>\n
    • Experience with Computer Aided Software Engineering (CASE) tools
      <\/span><\/li>\n
    • Knowledge and understanding of Information Management principles, concepts, policies and practices
      <\/span><\/li>\n
    • Experience in Database Administration, Maintenance Optimization<\/span>
      <\/span><\/li>\n <\/ul>

       <\/span><\/b>
      <\/p>

      Additional Responsibilities\/Skills for Data Warehouse including Oracle OBIEE<\/span><\/b>:<\/span>
      <\/p>\n

      \n
      • Subject matter expert in database design of the data warehouse or data marts.
        <\/span><\/li>\n
      • Skills:
        <\/span><\/li>\n
      • Experience and expert knowledge in technology and\/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning<\/span>
        <\/span><\/li>\n <\/ul>

         <\/span>
        <\/p>

        Additional Skills for Case Management and ERP<\/span><\/b>:<\/span>
        <\/p>\n

        \n
        • Experience <\/span>in designing\/developing an automated data distribution mechanism
          <\/span><\/li>\n
        • Knowledge and understanding of object\-oriented analysis and design techniques.
          <\/span><\/li>\n
        • Experience in developing enterprise architecture deliverables (e.g. models) based
          <\/span><\/li>\n
        • Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
          <\/span><\/li>\n
        • Knowledge and understanding of Information Management principles, concepts,
          <\/span><\/li>\n
        • policies and practices
          <\/span><\/li>\n
        • Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
          <\/span><\/li>\n
        • Experience in technical design, planning and implementation of specific technology or suite
          <\/span><\/li>\n
        • Experience with database administration and vendor support services
          <\/span><\/li>\n
        • Additional Skills for Cloud Database Administrator:<\/span>
          <\/span><\/li>\n
        • Expertise and experience in Cloud DB Administration, Data Development<\/span><\/b> (DevOps\/DataOps) & Operations, Data Integration, Automation tools and technologies. Further research suggested on a potential need for a role of a Senior DevOps\/Cloud DBA at a rate similar to a Senior DevOps\/Could Engineer<\/span>
          <\/span><\/li>\n <\/ul>

           <\/span>
          <\/p>

          Additional Skills for Oracle Database Administrator:<\/span><\/b>
          <\/p>\n

          \n
          • Experience in e\-Business Suite Applications R12.2 and Oracle Data Guard application (installation, config<\/span>uration, maintenance, patching, upgrade, and cloning)
            <\/span><\/li>\n
          • Knowledge and experience in configuring the latest version of WebLogic, OEM Grid Control
            <\/span><\/li>\n
          • Expert level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux \/ Red Hat Enterprise Linux 5.x\/6.x\/7.x
            <\/span><\/li>\n
          • Expert level knowledge of Advanced Compression, Data partitioning processes
            <\/span><\/li>\n
          • High level knowledge of data masking using Oracle patches and database scripts
            <\/span><\/li>\n
          • Performance tuning of e\-Business Suite R12.2\/19c in multi\-node RAC
            <\/span><\/li>\n
          • Developing database backup and restore strategy utilizing Flash Recovery Area (FRA) for RMAN and ASM.
            <\/span><\/li>\n
          • Expert level knowledge of Oracle 12c\/19c database administration, maintenance, security implementation, upgrade and patching, database performance tuning, sizing and capacity planning, database backup and recovery using RMAN
            <\/span><\/li>\n
          • Knowledge of Configuring Oracle E\-Business Suite Release 12.2 using Logical Host
            <\/span><\/li>\n
          • Knowledge of Online patching
            <\/span><\/li>\n
          • Knowledge of UNIX OS (Operating System) and Linux OS, utilities, shell scripting<\/span>
            <\/span><\/li>\n <\/ul>\n
            \n
            \n <\/div><\/span>
            Requirements<\/h3>

            Experience and Skill Set Requirements:<\/span><\/u><\/b>
            <\/p>

            Must Haves:<\/span><\/u><\/b>
            <\/p>\n

            \n
            • 7-10+ years of experience in Database Administration, including design, implementation, operations, and optimization of enterprisescale database systems.
              <\/span><\/li>\n
            • Proven expertise administering cloud database platforms, with a strong focus on Azure PaaS and IaaS database services.
              <\/span><\/li>\n
            • Experience managing cloud data services for project delivery, including storage, repositories, virtual machines, disks, key vaults, Data Lake, Data Warehouse, and Data Lakehouse platforms
              <\/span><\/li>\n
            • Expertise in Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
              <\/span><\/li>\n
            • Advanced performance tuning and troubleshooting, including:
              <\/span><\/li>\n <\/ul>\n \n
              \n
              • Query optimization and indexing strategies
                <\/span><\/li>\n
              • Azure SQL Query Store analysis
                <\/span><\/li>\n
              • Intelligent Performance & automatic tuning features
                <\/span><\/li>\n
              • Review of wait statistics and IO analysis
                <\/span><\/li>\n
              • TempDB optimization
                <\/span><\/li>\n
              • Understanding and mitigating Azure throttling limits
                <\/span><\/li>\n <\/ul>\n <\/blockquote>

                 <\/span>
                <\/p>

                Skill Set Requirements:<\/span><\/u><\/b>
                <\/p>

                Core Skills and Experience:<\/b>
                <\/p>\n

                \n
                • 7-10+ years of experience in Database Administration, including design, implementation, operations, and optimization of enterprise<\/span>scale database systems.
                  <\/span><\/li>\n
                • Proven expertise administering cloud database platforms, with a strong focus on Azure PaaS and IaaS database services.
                  <\/span><\/li>\n
                • Extensive experience creating logical and physical database designs, including schema optimization for OLTP and analytical workloads.
                  <\/span><\/li>\n
                • Demonstrated experience in database performance tuning, capacity planning, growth forecasting, and lifecycle management.
                  <\/span><\/li>\n
                • Hands<\/span>on experience in database installation, configuration, migration, and upgrades, including modernization from legacy platforms to cloud environments.
                  <\/span><\/li>\n
                • Proven ability to design and support high availability (HA) and disaster recovery (DR) strategies for mission<\/span>critical systems.
                  <\/span><\/li>\n
                • Experience managing cloud data services for project delivery, including storage, repositories, virtual machines, disks, key vaults, Data Lake, Data Warehouse, and Data Lakehouse platforms.
                  <\/span><\/li>\n
                • Experience supporting structured, semi<\/span>structured, and unstructured data ingestion, exchange, and provisioning for enterprise data warehouse and lakehouse solutions.
                  <\/span><\/li>\n
                • Demonstrated application of DataOPS principles, including monitoring, alerting, performance optimization, and operational tuning across environments.
                  <\/span><\/li>\n
                • Strong background in incident, change, and configuration management within ITIL<\/span>aligned or governed public<\/span>sector environments.
                  <\/span><\/li>\n <\/ul>

                   
                  <\/p>

                  Technical & Engineering Skills:<\/b>
                  <\/p>\n

                  \n
                  • Expertise in Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
                    <\/span><\/li>\n
                  • Expertise in Azure Storage, Azure Data Lake, Databricks Lakehouse, Azure Data Factory
                    <\/span><\/li>\n
                  • Experience with relational and distributed database systems; exposure to NoSQL or distributed data platforms is an asset.
                    <\/span><\/li>\n
                  • Knowledge of cloud networking concepts, including VNET integration, private endpoints, firewalls, and communication protocols.
                    <\/span><\/li>\n
                  • Expertise in logical and physical data modeling, including normalization, denormalization, and partitioning strategies.
                    <\/span><\/li>\n
                  • Experience designing multi<\/span>tenant database architectures.
                    <\/span><\/li>\n
                  • Advanced performance tuning and troubleshooting, including:
                    <\/span><\/li>\n
                  • Query optimization and indexing strategies
                    <\/span><\/li>\n
                  • Azure SQL Query Store analysis
                    <\/span><\/li>\n
                  • Intelligent Performance & automatic tuning features
                    <\/span><\/li>\n
                  • Review of wait statistics and IO analysis
                    <\/span><\/li>\n
                  • TempDB optimization
                    <\/span><\/li>\n
                  • Understanding and mitigating Azure throttling limits
                    <\/span><\/li>\n
                  • Expertise designing data tiers that balance performance, scalability, and cost.
                    <\/span><\/li>\n
                  • Expertise implementing Azure authentication and authorization, including Azure AD integration and role<\/span>based access control (RBAC).
                    <\/span><\/li>\n
                  • Strong experience with data protection and encryption, including Transparent Data Encryption (TDE) and key management.
                    <\/span><\/li>\n
                  • Experience reviewing and enforcing network security, firewall rules, and access controls.
                    <\/span><\/li>\n
                  • Proven experience ensuring compliance with audit standards, data classification standards, and regulatory requirements (e.g., PHIPPA).
                    <\/span><\/li>\n
                  • Experience researching and implementing cybersecurity vulnerability remediation in database environments.
                    <\/span><\/li>\n
                  • Exceptional analytical, problem<\/span>solving, and decision<\/span>making abilities.
                    <\/span><\/li>\n
                  • Strong verbal, written, and presentation skills, with the ability to explain complex technical concepts clearly to both technical and non<\/span>technical stakeholders.
                    <\/span><\/li>\n
                  • Proven interpersonal and negotiation skills, with experience collaborating across infrastructure, security, application, and data teams.
                    <\/span><\/li>\n
                  • Strong organizational skills with the ability to manage multiple priorities and meet fixed deadlines.
                    <\/span><\/li>\n
                  • Demonstrated ability to function as a senior technical resource, providing guidance, mentoring, and operational leadership.
                    <\/span><\/li>\n
                  • A collaborative team player with a track record of successful project delivery in regulated environments
                    <\/span><\/li>\n <\/ul>

                     
                    <\/p>

                    General Skills:<\/b>
                    <\/p>\n

                    \n
                    • Exceptional analytical, problem\-solving, and decision\-making abilities.
                      <\/span><\/li>\n
                    • Strong verbal and written communication skills, with the ability to present technical concepts clearly.
                      <\/span><\/li>\n
                    • Proven interpersonal and negotiation skills, with experience building strong stakeholder relationships.
                      <\/span><\/li>\n
                    • Demonstrated critical thinking and troubleshooting in complex data environments.
                      <\/span><\/li>\n
                    • Effective consulting and facilitation skills, with a track record of engaging diverse stakeholders.
                      <\/span><\/li>\n
                    • Excellent customer service orientation, applying tact and diplomacy to manage client needs.
                      <\/span><\/li>\n
                    • Highly motivated, flexible, detail\-oriented, and creative team player with strong organizational and multi\-tasking abilities.
                      <\/span><\/li>\n
                    • Proven ability to meet strict deadlines in fast\-paced, data\-driven environments.
                      <\/span><\/li>\n
                    • Experience with digital product development, data analysis, and data security.
                      <\/span><\/li>\n
                    • Familiarity with Data Lakehouse architectures and emerging cloud\-native technologies.
                      <\/span><\/li>\n
                    • Hands\-on experience with mainstream cloud providers (AWS, Azure, GCP) and their data services.
                      <\/span><\/li>\n
                    • Knowledge of data governance, compliance, and security frameworks in enterprise environments.
                      <\/span><\/li>\n <\/ul>

                       
                      <\/p>

                      Public Sector Experience:<\/b>
                      <\/p>\n

                      \n
                      • Proven public sector experience, particularly within environments supporting legacy systems, formal governance models, and regulated data.
                        <\/span><\/li>\n
                      • Experience working under Ontario Public Service (OPS) or similar audit standards, data classification frameworks, and compliance requirements.
                        <\/span><\/li>\n
                      • Knowledge of and experience complying with PHIPPA and other public<\/span>sector regulatory obligations.
                        <\/span><\/li>\n <\/ul>\n
                        \n
                        \n <\/div><\/span>
                        \n <\/body>\n<\/html>

            Report