Requirements Description and Requirements Position Summary The SQL Database Administrator is responsible for the design, implementation, and support of database systems for applications across MSSQL Dtababase platform (MSQL 2019,20222 server) Administrator is a part of the Database end to end delivery team working and collaborating with Application Development, Infrastructure Engineering and Operation Support teams to deliver and support secured, high performing and optimized database solutions. Database Administrator specializes in the SQL database platform. Job Responsibilities Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex SQL & Sybase databases. Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance. Identifies and resolves problem utilizing structured tools and techniques. Provides technical assistance and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance. Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards. Implement industry best practices while performing database administration task Work in Agile model with the understanding of Agile concepts Collaborate with development teams to provide and implement new features. Able to debug production issues by analyzing the logs directly and using tools like Splunk. Begin tackling organizational impediments Learn new technologies based on demand and help team members by coaching and assisting. Education, Technical Skills & Other Critical Requirement Education Bachelor’s degree in computer science, Information Systems, or another related field with 10+ years of IT and Infrastructure engineering work experience. Experience (In Years) 10+ Years Total IT experience & 7+ Years relevant experience in SQL Server + Sybase Database Technical Skills Database Management: expert in managing and administering SQL Server, Azure SQL Server, and Sybase databases, ensuring high availability and optimal performance. Data Infrastructure & Security: Expertise in designing and implementing robust data infrastructure solutions, with a strong focus on data security and compliance. Backup & Recovery: Skilled in developing and executing comprehensive backup and recovery strategies to safeguard critical data and ensure business continuity. Performance Tuning & Optimization: Adept at performance tuning and optimization of databases, leveraging advanced techniques to enhance system efficiency and reduce latency. Cloud Computing & Scripting: Experienced in cloud computing environments and proficient in operating system scripting, enabling seamless integration and automation of database operations. Management of database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers, and declarative integrity constraints Strong database analytical skills to improve application performance. Should have strong working Knowledge of database performance Tuning, Backup & Recovery, Infrastructure as a Code and Observability tools (Elastic). Must have experience of Automation tools and programming such as Ansible and Python. Strong knowledge in ITSM process and tools (ServiceNow). Ability to work 24*7 rotational shift to support the Database and Splunk platforms. Other Critical Requirements Excellent Analytical and Problem-Solving skills Experience managing geographically distributed and culturally diverse workgroups with strong team management, leadership and coaching skills Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders. Prior experience in handling state side and offshore stakeholders Experience in creating and delivering Business presentations. Demonstrate ability to work independently and in a team environment About MetLife Recognized on Fortune magazine's list of the 2024 "World's Most Admired Companies" and Fortune World’s 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world’s leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East. Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we’re inspired to transform the next century in financial services. At MetLife, it’s #AllTogetherPossible . Join us! Show more Show less

We are looking for a results-driven Senior Data Engineer to join our engineering team. The ideal candidate will have hands-on expertise in data pipeline development, cloud infrastructure, and BI support, with a strong command over modern data stacks. You'll be responsible for building scalable ETL/ELT workflows, managing data lakes and marts, and enabling seamless data delivery to analytics and business intelligence teams. This role requires deep technical know-how in PostgreSQL, Python scripting, Apache Airflow, AWS or other cloud environments, and a working knowledge of modern data and BI tools Responsibilities Design and optimize complex SQL queries, stored procedures, and indexes. Perform performance tuning and query plan analysis. Contribute to schema design and data normalization. Migrate data from multiple sources to cloud or ODS platforms. Design schema mapping and implement transformation logic. Ensure consistency, integrity, and accuracy in migrated data. Build automation scripts for data ingestion, cleansing, and transformation. Handle file formats (JSON, CSV, XML), REST APIs, cloud SDKs (e. g., Boto3). Maintain reusable script modules for operational pipelines. Develop and manage DAGs for batch/stream workflows. Implement retries, task dependencies, notifications, and failure handling. Integrate Airflow with cloud services, data lakes, and data warehouses. Manage data storage (S3 GCS, Blob), compute services, and data pipelines. Set up permissions, IAM roles, encryption, and logging for security. Monitor and optimize the cost and performance of cloud-based data operations. Design and manage data marts using dimensional models. Build star/snowflake schemas to support BI and self-serve analytics. Enable incremental load strategies and partitioning. Work with tools like DBT, Fivetran, Redshift, Snowflake, BigQuery, or Kafka. Support modular pipeline design and metadata-driven frameworks. Ensure high availability and scalability of the stack. Collaborate with BI teams to design datasets and optimize queries. Support the development of dashboards and reporting layers. Manage access, data refreshes, and performance for BI tools. Requirements 4-6 years of hands-on experience in data engineering roles. Strong SQL skills in PostgreSQL (tuning, complex joins, procedures). Advanced Python scripting skills for automation and ETL. Proven experience with Apache Airflow (custom DAGs, error handling). Solid understanding of cloud architecture (especially AWS). Experience with data marts and dimensional data modeling. Exposure to modern data stack tools (DBT, Kafka, Snowflake, etc. ) Familiarity with BI tools like Power BI, Apache Superset, or Supertech BI. Version control (Git) and CI/CD pipeline knowledge are a plus. Excellent problem-solving and communication skills. This job was posted by Suryansh Singh Karchuli from ShepHertz Technologies. Show more Show less

Country India Working Schedule Full-Time Work Arrangement Hybrid Relocation Assistance Available No Posted Date 29-May-2025 Job ID 9050 Description and Requirements Job Responsibilities Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex Oracle databases from version (11g,12c,19c and 21c (CDB/PDB and Standalone) on (Linux/AIX) Operating System. Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance; Makes use of advanced database features such as partitioning, advanced compression, multitenant architecture, etc. Design, implement and maintain automated infrastructure solutions using Infrastructure as Code tools like Ansible, Elastic and Terraform. Develop and manage of Azure DevOps CI/CD pipelines to automate infrastructure deployments using Ansible and Elastic.Provides technical advice and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance. Troubleshoot and resolve, in conjunction with Operational/Customer DBAs, database application issues across production, test and development environments Customer-facing position and may require interaction with senior customer leadership on matters concerning design, engineering, or functional areas Identifies and resolves problem utilizing structured tools and techniques. Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards. Participates in a 24X7 pager rotation, providing Subject Matter Expert support to the on-call DBA as needed Identify, participate and resolve complex Root Cause Analysis (RCA) Maintains, and administers data infrastructure security policies safeguarding information, evaluating existing data infrastructure security procedures and identifying new areas of risk. Extensive knowledge of ServiceNow ticketing system. KB article creation and maintenance, and CMDB maintenance 7+ years of experience with Performance Tuning, physical database design, database programming skills, and shell scripting Working experience with Cloud infrastructure, Elastic, Ansible, data replication and project management Working knowledge of other database technology such as UDB, Informix, PostgreSQL or MSSQL preferred Education, Technical Skills & Other Critical Requirement Education Bachelor’s degree in computer science, Information Systems, or another related field with 10+ years of IT and Infrastructure engineering work experience. Experience (In Years) 10+ Years Total IT experience & 7+ Years relevant experience in Oracle database Technical Skills 7+ years of related work experience on Oracle 11g,12c, Oracle 19c database administrator with specific knowledge on ASM, GoldenGate, Data Guard, RMAN, Patching, AND/OR Security ,Active Data Guard and data pump 6 years Unix, Linux and Windows operating systems and 3 year’s shell scripting. Strong database analytical skills to improve application performance. Management of database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers, and integrity constraints Engineering and support experience with PeopleSoft financials application databases and Goldengate replications. Should have strong knowledge in configuration and implementation Backup and recovery strategy as per Industry best practice using backup tools (RMAN, Data Pump, BCV and Rubrik) Expertise in database performance tuning with hands on experience on AWR, ADDM, SQLTRPT skill. Experience in Data guard configuration (DR) (Active Must have extensive experience in Database switchover and failover. Strong Experience in Cloud computing (Azure, OCI) Data security by managing roles and privileges to User and groups. Strong knowledge in configuring and implementing data replication between complex databases using Goldengate. Experience in installation and configuration of OEM Agent and monitoring. Experience in working Ticketing tools (ServiceNow) Understanding of modern IT infrastructure such as Cloud Architecture as well as Agile DevOps Framework. Ability to organize tasks for self and others, prioritize and balance tasks, and lead complex projects Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders. Strong Automation skills and programming such as Python and Ansible Should have good experience in Database monitoring installation, configuration and monitoring using OEM and Elastic. Ability to work 24*7 rotational shift to support for production, development, and test databases Other Critical Requirements OCP 12c/19c, Azure and OCI cloud certification preferable. Should have Project management experience for creating and delivering Business solutions. Demonstrate ability to work independently and in a team environment About MetLife Recognized on Fortune magazine's list of the 2024 "World's Most Admired Companies" and Fortune World’s 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world’s leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East. Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we’re inspired to transform the next century in financial services. At MetLife, it’s #AllTogetherPossible. Join us!

5 - 7 Years 10 Openings Trivandrum Role description Role Proficiency: Act creatively to develop applications and select appropriate technical options optimizing application development maintenance and performance by employing design patterns and reusing proven solutions account for others' developmental activities Outcomes: Interpret the application/feature/component design to develop the same in accordance with specifications. Code debug test document and communicate product/component/feature development stages. Validate results with user representatives; integrates and commissions the overall solution Select appropriate technical options for development such as reusing improving or reconfiguration of existing components or creating own solutions Optimises efficiency cost and quality. Influence and improve customer satisfaction Set FAST goals for self/team; provide feedback to FAST goals of team members Measures of Outcomes: Adherence to engineering process and standards (coding standards) Adherence to project schedule / timelines Number of technical issues uncovered during the execution of the project Number of defects in the code Number of defects post delivery Number of non compliance issues On time completion of mandatory compliance trainings Outputs Expected: Code: Code as per design Follow coding standards templates and checklists Review code – for team and peers Documentation: Create/review templates checklists guidelines standards for design/process/development Create/review deliverable documents. Design documentation r and requirements test cases/results Configure: Define and govern configuration management plan Ensure compliance from the team Test: Review and create unit test cases scenarios and execution Review test plan created by testing team Provide clarifications to the testing team Domain relevance: Advise Software Developers on design and development of features and components with a deep understanding of the business problem being addressed for the client. Learn more about the customer domain identifying opportunities to provide valuable addition to customers Complete relevant domain certifications Manage Project: Manage delivery of modules and/or manage user stories Manage Defects: Perform defect RCA and mitigation Identify defect trends and take proactive measures to improve quality Estimate: Create and provide input for effort estimation for projects Manage knowledge: Consume and contribute to project related documents share point libraries and client universities Review the reusable documents created by the team Release: Execute and monitor release process Design: Contribute to creation of design (HLD LLD SAD)/architecture for Applications/Features/Business Components/Data Models Interface with Customer: Clarify requirements and provide guidance to development team Present design options to customers Conduct product demos Manage Team: Set FAST goals and provide feedback Understand aspirations of team members and provide guidance opportunities etc Ensure team is engaged in project Certifications: Take relevant domain/technology certification Skill Examples: Explain and communicate the design / development to the customer Perform and evaluate test results against product specifications Break down complex problems into logical components Develop user interfaces business software components Use data models Estimate time and effort required for developing / debugging features / components Perform and evaluate test in the customer or target environment Make quick decisions on technical/project related challenges Manage a Team mentor and handle people related issues in team Maintain high motivation levels and positive dynamics in the team. Interface with other teams designers and other parallel practices Set goals for self and team. Provide feedback to team members Create and articulate impactful technical presentations Follow high level of business etiquette in emails and other business communication Drive conference calls with customers addressing customer questions Proactively ask for and offer help Ability to work under pressure determine dependencies risks facilitate planning; handling multiple tasks. Build confidence with customers by meeting the deliverables on time with quality. Estimate time and effort resources required for developing / debugging features / components Make on appropriate utilization of Software / Hardware’s. Strong analytical and problem-solving abilities Knowledge Examples: Appropriate software programs / modules Functional and technical designing Programming languages – proficient in multiple skill clusters DBMS Operating Systems and software platforms Software Development Life Cycle Agile – Scrum or Kanban Methods Integrated development environment (IDE) Rapid application development (RAD) Modelling technology and languages Interface definition languages (IDL) Knowledge of customer domain and deep understanding of sub domain where problem is solved Additional Comments: Client Job Description - Looking for talented and creative iSeries/AS400 Developer for Application Development ,Solutions support, Reverse Engineering Projects. The developer will be working with one of the leading Wholesale retailers in the US. The ideal candidate should have the ability to work creatively and analytically in a problem-solving environment. The ideal candidate must possess excellent written and verbal communication skills with the ability and knowhow to collaborate effectively with domain experts and IT leadership team. Responsibilities: • Analyzes and develops iSeries code that support various applications in Retail Domain. • Creates functional specifications for applications supported using standard practices, processes and procedures. • Performs code reviews, unit testing, coordinates with development team members on development and QA tasks. • Adheres to client’s IS division development standards and deployment processes and procedures. • Collaborates with Product Owner, business area, team members and QA to ensure requirements are clearly defined, understood and documented. • Participates in development estimation, deployment and release planning to ensure delivery of solutions. • Responsible for 2nd level support resolution of daily incident tickets, creation of KB articles for 1st level support and provide on-call support. • Responsible for continued personal growth in areas of technology, business knowledge and Client policies. • Perform peer reviews on source code to ensure reuse, scalability and the use of best practices • Participate in collaborative technical discussions that focus on software user experience, design, architecture, and development Requirements: Must Have • Excellent programming skills on the ISeries platform – Analyze and Create new programs using RPG, RPG ILE, SQLRPGLE and Control Language (CLP/CLLE). • Very good knowledge of SQL concepts – Analyze and modify complex SQL queries, embedded SQL in SQLRPGLE, Cursor programming. • Database Concepts – Create and Analyze Physical files, Logical Files, SQL tables, Indexes, Views, Stored procedures. • Good working knowledge in screen programming – Display Files, Subfiles and Printer files. • Document business rules effectively and should be able to create data mapping documents after analyzing program flows and data flows • ILE Programming – Analyze and Create program modules, binding directories, service programs. • Working knowledge of MQ, MQ Trigger and embedding XML tags in RPG Programs • Good communication skills and job will involve owning a project task completely based on the communication with the analysts at the client site Good to Have • Good working knowledge in Turnover – the code configuration management tool • Good working knowledge in X- Analysis – cross reference tool for ISeries. • Knowledge on Triggers, Message Queuing for inter program/ inter system communication • ROBOT job scheduler – knowledge in creating and setting up scheduled jobs in the ISeries. • Knowledge of normalized, de normalized tables, Star Schema databases • Working knowledge on ISeries Navigator – to run queries and analyze the performance of SQL queries. • Knowledge in Retail Domain especially in areas like Lawson ERP, Finance and Membership. Skills Ibm Iseries,Sql,IBM As400 About UST UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.

Job Purpose The Senior SQL Developer will design, develop, and maintain database systems, including SSIS projects and custom reports, while collaborating with the data team to address SQL issues and ensure efficient data management within a fast-paced environment. Duties & Responsibilities Develop SSIS projects to handle ETL, transmission, encryption, and archiving files received and generated SQL Database Tuning and Performance Design, develop, and maintain database tables, stored procedures, and supporting objects Build and support operational reports for company and clients Work with data team to provide operational support, resolve recurring problems Document database topology, architecture, processes and procedures Develop SQL queries and support ad hoc requests for data Assist with capacity planning and resource expansion through data aggregation and analysis Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement Identify inefficiencies in the database platform and provide solutions to the management Use problem-solving skills to assist in resolution of business problems Develop analytical skills to resolve technical problems Identify root causes for problems and propose solutions to prevent recurring. Use, protect and disclose patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards Understand and comply with Information Security and HIPAA policies and procedures at all times Limit viewing of PHI to the absolute minimum as necessary to perform assigned duties Qualifications Bachelor’s degree in Computer Science/Information Technology required Minimum five years working as a Database engineer or a related role Minimum of three years extensive SSRS\SSIS\T-SQL experience Minimum of two years’ experience with C# and\or VB.NET Thorough understanding of database structures, theories, principles, & practices Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints Extensive knowledge of MS SQL Server 2012 or later with emphasis on query performance Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations Require ability to work independently with minimal supervision Ability to multi-task with several complex and demanding projects Proficiency in Microsoft Office Suite Strong interpersonal skills, ability to communicate well at all levels of the organization Strong problem solving and creative skills and the ability to exercise sound judgment and make decisions based on accurate and timely analyses High level of integrity and dependability with a strong sense of urgency and results oriented Excellent written and verbal communication skills required Gracious and welcoming personality for customer service interaction Working Conditions Work Set-Up: Fully Remote Work Schedule: US Hours (Night Shift) Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear. Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress. Work Environment: The noise level in the work environment is usually minimal. Med-Metrix will not discriminate against any employee or applicant for employment because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, veteran status, other non-merit based factors, or any other characteristic protected by federal, state or local law.

Country India Working Schedule Full-Time Work Arrangement Hybrid Relocation Assistance Available No Posted Date 29-May-2025 Job ID 9033 Description and Requirements Position Summary The SQL Database Administrator is responsible for the design, implementation, and support of database systems for applications across the Enterprise. Database Administrator is a part of the Database end to end delivery team working and collaborating with Application Development, Infrastructure Engineering and Operation Support teams to deliver and support secured, high performing and optimized database solutions. Database Administrator specializes in the SQL database platform. Job Responsibilities Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex SQL & Sybase databases. Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance. Identifies and resolves problem utilizing structured tools and techniques. Provides technical assistance and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance. Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards. Implement industry best practices while performing database administration task Work in Agile model with the understanding of Agile concepts Collaborate with development teams to provide and implement new features. Able to debug production issues by analyzing the logs directly and using tools like Splunk. Begin tackling organizational impediments Learn new technologies based on demand and help team members by coaching and assisting. Education, Technical Skills & Other Critical Requirement Education Bachelor’s degree in computer science, Information Systems, or another related field with 7+ years of IT and Infrastructure engineering work experience. Experience (In Years) 7+ Years Total IT experience & 4+ Years relevant experience in SQL Server + Sybase Database Technical Skills Database Management: Proficient in managing and administering SQL Server, Azure SQL Server, and Sybase databases, ensuring high availability and optimal performance. Data Infrastructure & Security: Expertise in designing and implementing robust data infrastructure solutions, with a strong focus on data security and compliance. Backup & Recovery: Skilled in developing and executing comprehensive backup and recovery strategies to safeguard critical data and ensure business continuity. Performance Tuning & Optimization: Adept at performance tuning and optimization of databases, leveraging advanced techniques to enhance system efficiency and reduce latency. Cloud Computing & Scripting: Experienced in cloud computing environments and proficient in operating system scripting, enabling seamless integration and automation of database operations. Management of database elements, including creation, alteration, deletion and copying of schemas. databases, tables, views, indexes, stored procedures, triggers, and declarative integrity constraints Strong database analytical skills to improve application performance. Strong knowledge in ITSM process and tools (ServiceNow). Ability to work 24*7 rotational shift to support the Database and Splunk platforms. Other Critical Requirements Automation tools and programming such as Ansible and Python Excellent Analytical and Problem-Solving skills Experience managing geographically distributed and culturally diverse workgroups with strong team management, leadership and coaching skills Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders. Prior experience in handling state side and offshore stakeholders Experience in creating and delivering Business presentations. Demonstrate ability to work independently and in a team environment About MetLife Recognized on Fortune magazine's list of the 2024 "World's Most Admired Companies" and Fortune World’s 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world’s leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East. Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we’re inspired to transform the next century in financial services. At MetLife, it’s #AllTogetherPossible. Join us!

Work Location: Vadodara, Ahmedabad, Bangalore, Pune Experience: 4-6 Years Tech. capability required - Angular, Typescript, .NET 6+ , SQL Server, Stored proc, ADO.NET / EF; Unit Testing frameworks (jasmine, karma, msunit or xunit etc.), API development, Identity server, JWT token, Communication – must. Tech Skills: .NET Core, .NET MVC, .NET 8, Web API SQL Server, Stored procedures, Fun, Tables, Indexes, EF Angular, JavaScript, Typescript Unit testing framework and test case writing GitHub working experience, use of CI/CD Team leadership and Business requirement understanding JIRA and other tools understanding Independent client communication & team collaboration Kind Regards, Pranita Birla Senior Talent Acquisition Partner | Rishabh Software Job Type: Full-time Pay: ₹1,000,000.00 - ₹1,800,000.00 per year Schedule: Day shift Ability to commute/relocate: Atladara, Vadodara - 390012, Gujarat: Reliably commute or planning to relocate before starting work (Required) Work Location: In person

Requirements Description and Requirements Position Summary The SQL Database Administrator is responsible for the design, implementation, and support of database systems for applications across the Enterprise. Database Administrator is a part of the Database end to end delivery team working and collaborating with Application Development, Infrastructure Engineering and Operation Support teams to deliver and support secured, high performing and optimized database solutions. Database Administrator specializes in the SQL database platform. Job Responsibilities Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex SQL & Sybase databases. Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance. Identifies and resolves problem utilizing structured tools and techniques. Provides technical assistance and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance. Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards. Implement industry best practices while performing database administration task Work in Agile model with the understanding of Agile concepts Collaborate with development teams to provide and implement new features. Able to debug production issues by analyzing the logs directly and using tools like Splunk. Begin tackling organizational impediments Learn new technologies based on demand and help team members by coaching and assisting. Education, Technical Skills & Other Critical Requirement Education Bachelor’s degree in computer science, Information Systems, or another related field with 3+ years of IT and Infrastructure engineering work experience. Experience (In Years) 3+ Years Total IT experience & 2+ Years relevant experience in SQL Server + Sybase Database Technical Skills Database Management: Should have Basic knowledge in managing and administering SQL Server, Azure SQL Server, and Sybase databases, ensuring high availability and optimal performance. Data Infrastructure & Security: Basic knowledge in designing and implementing robust data infrastructure solutions, with a strong focus on data security and compliance. Backup & Recovery: Skilled in developing and executing comprehensive backup and recovery strategies to safeguard critical data and ensure business continuity. Performance Tuning & Optimization: Adept at performance tuning and optimization of databases, leveraging advanced techniques to enhance system efficiency and reduce latency. Cloud Computing & Scripting: Basic knowledge in cloud computing environments and proficient in operating system scripting, enabling seamless integration and automation of database operations. Management of database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers, and declarative integrity constraints . Basic knowledge analytical skills to improve application performance. Basic knowledge of database performance Tuning, Backup & Recovery, Infrastructure as a Code and Observability tools (Elastic). Strong knowledge in ITSM process and tools (ServiceNow). Ability to work 24*7 rotational shift to support the Database platforms Other Critical Requirements Automation tools and programming such as Ansible and Python are preferrable Excellent Analytical and Problem-Solving skills Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders. Demonstrate ability to work independently and in a team environment About MetLife Recognized on Fortune magazine's list of the 2024 "World's Most Admired Companies" and Fortune World’s 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world’s leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East. Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we’re inspired to transform the next century in financial services. At MetLife, it’s #AllTogetherPossible . Join us! Show more Show less

Role Description Role Proficiency: Provide expertise on data analysis techniques using software tools. Under supervision streamline business processes. Outcomes Design and manage the reporting environment; which include data sources security and metadata. Provide technical expertise on data storage structures data mining and data cleansing. Support the data warehouse in identifying and revising reporting requirements. Support initiatives for data integrity and normalization. Assess tests and implement new or upgraded software. Assist with strategic decisions on new systems. Generate reports from single or multiple systems. Troubleshoot the reporting database environment and associated reports. Identify and recommend new ways to streamline business processes Illustrate data graphically and translate complex findings into written text. Locate results to help clients make better decisions. Solicit feedback from clients and build solutions based on feedback. Train end users on new reports and dashboards. Set FAST goals and provide feedback on FAST goals of repartees Measures Of Outcomes Quality - number of review comments on codes written Data consistency and data quality. Number of medium to large custom application data models designed and implemented Illustrates data graphically; translates complex findings into written text. Number of results located to help clients make informed decisions. Number of business processes changed due to vital analysis. Number of Business Intelligent Dashboards developed Number of productivity standards defined for project Number of mandatory trainings completed Outputs Expected Determine Specific Data needs: Work with departmental managers to outline the specific data needs for each business method analysis project Critical Business Insights Mines the business’s database in search of critical business insights; communicates findings to relevant departments. Code Creates efficient and reusable SQL code meant for the improvement manipulation and analysis of data. Creates efficient and reusable code. Follows coding best practices. Create/Validate Data Models Builds statistical models; diagnoses validates and improves the performance of these models over time. Predictive Analytics Seeks to determine likely outcomes by detecting tendencies in descriptive and diagnostic analysis Prescriptive Analytics Attempts to identify what business action to take Code Versioning Organize and manage the changes and revisions to code. Use a version control tool for example git bitbucket. etc. Create Reports Create reports depicting the trends and behaviours from analyzed data Document Create documentation for worked performed. Additionally perform peer reviews of documentation of others' work Manage Knowledge Consume and contribute to project related documents share point libraries and client universities Status Reporting Report status of tasks assigned Comply with project related reporting standards and processes Skill Examples Analytical Skills: Ability to work with large amounts of data: facts figures and number crunching. Communication Skills: Communicate effectively with a diverse population at various organization levels with the right level of detail. Critical Thinking: Data Analysts must review numbers trends and data to come up with original conclusions based on the findings. Presentation Skills - facilitates reports and oral presentations to senior colleagues Strong meeting facilitation skills as well as presentation skills. Attention to Detail: Vigilant in the analysis to determine accurate conclusions. Mathematical Skills to estimate numerical data. Work in a team environment Proactively ask for and offer help Knowledge Examples Knowledge Examples Database languages such as SQL Programming language such as R or Python Analytical tools and languages such as SAS & Mahout. Proficiency in MATLAB. Data visualization software such as Tableau or Qlik. Proficient in mathematics and calculations. Efficiently with spreadsheet tools such as Microsoft Excel or Google Sheets DBMS Operating Systems and software platforms Knowledge regarding customer domain and sub domain where problem is solved Additional Comments Over 6+ years of experience in developing BI applications utilizing SQL server/ SF/ GCP/ PostgreSQL, BI stack, Power BI, and Tableau. Practical understanding of the Data modelling (Dimensional & Relational) concepts like Star-Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables. Ability to translate the business requirements into workable functional and non-functional requirements. Capable of taking ownership and communicating with C Suite executives & Stakeholders. Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints, and Indexes using various DDL and DML commands. Experienced in creating SSAS based OLAP Cubes and writing complex DAX. Ability to work with external tools like Tabular Editor and DAX Studio. Understand complex and customize Stored Procedures and Queries for implementing business logic and process in backend, for data extraction. Hands on experience in Incremental refresh, RLS, Parameterization, Dataflows and Gateways. Experience in Design, development of Business Intelligence Solutions using SSRS and Power BI Experience in optimization of PBI reports implementing Mixed and Direct Query modes. Skills Power Bi,Power Tools,Data Analysis,Fabric Show more Show less

Analyst – MySQL Database Administration Job Description  Perform all technical research, analysis, design and architecting of IT Database systems ensuring that the documented business and technical requirements are met and implemented to industry best practice standards.  Drives short & long term architecture strategy for IT Database systems. Communicates and validates database architecture with the technology services and development management teams.  Lead technical design discussions working closely with Development and project team members to ensure documented requirements are being met within proposed solutions.  Install, configure, maintain, and database systems, schema, tables, indexes, procedures, and permissions.  Create backup / recovery of databases for MySQL.  Ensure SQL Transactional Replication (Create / monitor / resolve) is occurring successfully.  Track performance metrics of maintained databases; identify potential capacity / performance issues and resolve or recommend changes to meet business requirements.  Conduct regular performance tuning, indexing, and normalization of database systems.  Develop and test SQL scripts for task automation and reporting.  Provide monitoring support for critical database servers and supporting services.  Meet project deliverables for new and / or changes to existing technology within project requirements.  Install/Migrate/Administrate MySQL to Mariadb.  Ensure server downtime resulting from maintenance and improvements are limited to non-production hours whenever possible.  Identify new opportunities that reduce costs while maintaining adequate functionality and support, improve technology performance and / or stability and improve existing processes therefore reducing effort or increasing productivity.  Db patching and db upgrade/migrate. Resource monitoring and requirement analysis.  Develop and document issue resolution knowledge base.  Provide second and third level support for all database systems.  Availability for on-call 24/7 support. Position Requirements  Bachelor’s degree in Information Technology, Computer Science or other related discipline a plus.  Minimum of five (5) years of experience in database administration.  Minimum of four (3) years of administrator experience in an IT Enterprise organization which practiced ITIL methodologies.  Thorough training and demonstrated analytical and technical skills in installing, configuring, integrating and administering MySQL within the Linux / LAMP stack.  Experience including, but not limited to, MySQL, Mariadb, Linux RedHat, Apache, and PHP or other scripting languages.  Hands-on experience supporting Highly Available (HA) database environments with solutions such as clustering. This should include supporting a (3) node MySQL cluster.  Experience in systems engineering design, analysis, integration, and life-cycle engineering in support of large information systems projects.  Excellent written and verbal communication skills.  Ability to work as a team member in a fast paced environment.  Ability to manage and communicate project tasks, status, and deadlines. Preferred Qualifications  Experienced in working within a multi-tiered architecture environment, supporting B2B and/or hosting operations.  Experience with open-source software, including LAMP software bundle.  Working knowledge in NoSQL/MongoDb Show more Show less

As a MS SQL Database Administrator (DBA), you will be responsible for overseeing the administration, maintenance, and optimization of the organization's database systems. This role is crucial in ensuring the reliability, security, and performance of databases that support critical business applications and services. Responsibilities: Design and maintain proper indexing strategies to speed up data retrieval, including both clustered and non-clustered indexes. Design, implement, and maintain database structures (tables, stored procedures, views) within SQL Server or other relational databases. Optimize SQL queries to ensure efficient execution, minimize resource consumption, and improve response times, using EXPLAIN plans, indexes, and appropriate query writing techniques. Utilize database caching techniques, such as in-memory databases or Redis, to improve performance for frequently accessed data. Write and optimize stored procedures, functions, and triggers to encapsulate business logic and automate database operations. Write complex and optimized SQL queries for data retrieval, reporting, and transformation, ensuring they scale efficiently for large data volumes. Additional Skills and Knowledge Technical Proficiency : Strong understanding of system architecture, networking, and database management. Project Management : Ability to manage infrastructure projects effectively, including scheduling and resource allocation. Communication : Clear and effective communication with project managers, development teams, and other stakeholders. Desired Qualifications Candidates should possess a BE/BTech, MCA, MSc IT They should have a minimum of 5 years of overall experience , with at least two software application development projects. SQL - PostgreSQL/ MySQL / MS SQL Server, etc. No-SQL - Cassandra/ MongoDB, and Offline databases, such as SQLite/ CouchDB, etc Working experience in E governance projects will be preferable. Show more Show less

Job Title: SQL Developer Trainee Location: Remote Job Type: Internship (Full-Time) Duration: 1–3 Months Stipend: ₹25,000/month Department: Data & Engineering Job Summary: We are seeking a detail-oriented and motivated SQL Developer Trainee to join our team remotely. This internship is designed for recent graduates or students who want to gain practical experience in database development, writing SQL queries, and working with data in real-world applications. Key Responsibilities: Write, test, and optimize SQL queries for data extraction and reporting Assist in designing and maintaining database structures (tables, views, indexes, etc.) Help ensure data integrity, accuracy, and security across systems Support the team in troubleshooting and debugging database-related issues Collaborate with developers and analysts to fulfill data requirements for projects Document query logic and database-related processes Qualifications: Bachelor’s degree (or final year student) in Computer Science, Information Technology, or related field Strong understanding of SQL and relational databases (e.g., MySQL, PostgreSQL, SQL Server) Familiarity with database design and normalization Analytical mindset with good problem-solving skills Ability to work independently in a remote setting Eagerness to learn and grow in a data-driven environment Preferred Skills (Nice to Have): Experience with procedures, triggers, or functions in SQL Exposure to BI/reporting tools (Power BI, Tableau, etc.) Understanding of data warehousing concepts Familiarity with cloud-based databases or platforms What We Offer: Monthly stipend of ₹25,000 Remote work opportunity Hands-on experience with real-world datasets and projects Mentorship and structured learning sessions Certificate of Completion Potential for full-time employment based on performance Show more Show less

Job Purpose Seeking a Senior SQL Developer to join our data team in analyzing, developing SSIS projects, custom reports and work closely with the team on any SQL issues. This is an excellent opportunity for an ambitious and agile person looking to grow and learn in a very fast paced environment Duties And Responsibilities Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated. SQL Database Tuning and Performance Design, develop, and maintain database tables, stored procedures, and supporting objects. Build and support operational reports for company and clients. Work with data team to provide operational support, resolve recurring problems. Document database topology, architecture, processes and procedures. Develop SQL queries and support ad hoc requests for data. Assist with capacity planning and resource expansion through data aggregation and analysis. Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement. Identify inefficiencies in the database platform and provide solutions to the management. Use problem-solving skills to assist in resolution of business problems. Develop analytical skills to resolve technical problems. Identify root causes for problems and propose solutions to prevent recurring. Qualifications Requires a four-year degree in Computer Science/Information Technology Minimum five years working as a Database engineer or a related role. Minimum of three years SSIS experience Minimum of two years’ experience with C# and\or VB.NET Thorough understanding of database structures, theories, principles, & practices. Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints. Extensive knowledge of MS SQL Server 2012 or later Extensive knowledge with SSRS\SSIS\T-SQL Experience with C# and\or VB.NET. Technical knowledge of MS SQL Server internals with emphasis on query performance. Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations. Require ability to work independently with minimal supervision Ability to multi-task with several complex and demanding Projects Working Conditions Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear. Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress. Work Environment: The noise level in the work environment is usually minimal. Med-Metrix will not discriminate against any employee or applicant for employment because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, veteran status, other non-merit based factors, or any other characteristic protected by federal, state or local law. Show more Show less

Work Location: Vadodara, Ahmedabad, Bangalore, Pune Experience: 4-6 Years Tech. capability required - Angular, Typescript, .NET 6+ , SQL Server, Stored proc, ADO.NET / EF; Unit Testing frameworks (jasmine, karma, msunit or xunit etc.), API development, Identity server, JWT token, Communication – must. Tech Skills: .NET Core, .NET MVC, .NET 8, Web API SQL Server, Stored procedures, Fun, Tables, Indexes, EF Angular, JavaScript, Typescript Unit testing framework and test case writing GitHub working experience, use of CI/CD Team leadership and Business requirement understanding JIRA and other tools understanding Independent client communication & team collaboration Kind Regards, Pranita Birla Senior Talent Acquisition Partner | Rishabh Software Job Type: Full-time Pay: ₹1,000,000.00 - ₹1,800,000.00 per year Schedule: Day shift Ability to commute/relocate: Atladara, Vadodara - 390012, Gujarat: Reliably commute or planning to relocate before starting work (Required) Work Location: In person

About Company: The healthcare industry is the next great frontier of opportunity for software development, and Health Catalyst is one of the most dynamic and influential companies in this space. We are working on solving national-level healthcare problems, and this is your chance to improve the lives of millions of people, including your family and friends. Health Catalyst is a fast-growing company that values smart, hardworking, and humble individuals. Each product team is a small, mission-critical team focused on developing innovative tools to support Catalyst’s mission to improve healthcare performance, cost, and quality. POSITION OVERVIEW: We are looking for a highly skilled Senior Database Engineer with 4+ years of hands-on experience in managing and optimizing large-scale, high-throughput database systems. The ideal candidate will possess deep expertise in handling complex ingestion pipelines across multiple data stores and a strong understanding of distributed database architecture. The candidate will play a critical technical leadership role in ensuring our data systems are robust, performant, and scalable to support massive datasets ingested from various sources without bottlenecks. You will work closely with data engineers, platform engineers, and infrastructure teams to continuously improve database performance and reliability. performance bottlenecks. KEY RESPONSIBILITIES: • Query Optimization: Design, write, debug and optimize complex queries for RDS (MySQL/PostgreSQL), MongoDB, Elasticsearch, and Cassandra. • Large-Scale Ingestion: Configure databases to handle high-throughput data ingestion efficiently. • Database Tuning: Optimize database configurations (e.g., memory allocation, connection pooling, indexing) to support large-scale operations. • Schema and Index Design: Develop schemas and indexes to ensure efficient storage and retrieval of large datasets. • Monitoring and Troubleshooting: Analyze and resolve issues such as slow ingestion rates, replication delays, and performance bottlenecks. • Performance Debugging: Analyze and troubleshoot database slowdowns by investigating query execution plans, logs, and metrics. • Log Analysis: Use database logs to diagnose and resolve issues related to query performance, replication, and ingestion bottlenecks • Data Partitioning and Sharding: Implement partitioning, sharding, and other distributed database techniques to improve scalability. • Batch and Real-Time Processing: Optimize ingestion pipelines for both batch and real-time workloads. • Collaboration: Partner with data engineers and Kafka experts to design and maintain robust ingestion pipelines. • Stay Updated: Stay up to date with the latest advancements in database technologies and recommend improvements. REQUIRED SKILLS AND QUALIFICATIONS: • Database Expertise: Proven experience with MySQL/PostgreSQL (RDS), MongoDB, Elasticsearch, and Cassandra. • High-Volume Operations: Proven experience in configuring and managing databases for large-scale data ingestions. • Performance Tuning: Hands-on experience with query optimization, indexing strategies, and execution plan analysis for large datasets. • Database Internals: Strong understanding of replication, partitioning, sharding, and caching mechanisms. • Data Modeling: Ability to design schemas and data models tailored for high throughput use cases. • Programming Skills: Proficiency in at least one programming language (e.g., Python, Java, Go) for building data pipelines. • Debugging Proficiency: Strong ability to debug slowdowns by analyzing database logs, query execution plans, and system metrics. • Log Analysis Tools: Familiarity with database log formats and tools for parsing and analyzing logs. • Monitoring Tools: Experience with monitoring tools such as AWS CloudWatch, Prometheus, and Grafana to track ingestion performance. • Problem-Solving: Analytical skills to diagnose and resolve ingestion-related issues effectively. PREFERRED QUALIFICATIONS: • Certification in any of the mentioned database technologies. • Hands-on experience with cloud platforms such as AWS (preferred), Azure, or GCP. • Knowledge of distributed systems and large-scale data processing. • Familiarity with cloud-based database solutions and infrastructure. • Familiarity with large scale data ingestion tools like Kafka, Spark or Flink. EDUCATIONAL REQUIREMENTS: • Bachelor’s degree in computer science, Information Technology, or a related field. Equivalent work experience will also be considered Show more Show less

Job Title: SQL Developer Trainee Location: Remote Job Type: Internship (Full-Time) Duration: 1–3 Months Stipend: ₹25,000/month Department: Data & Engineering Job Summary: We are seeking a detail-oriented and motivated SQL Developer Trainee to join our team remotely. This internship is designed for recent graduates or students who want to gain practical experience in database development, writing SQL queries, and working with data in real-world applications. Key Responsibilities: Write, test, and optimize SQL queries for data extraction and reporting Assist in designing and maintaining database structures (tables, views, indexes, etc.) Help ensure data integrity, accuracy, and security across systems Support the team in troubleshooting and debugging database-related issues Collaborate with developers and analysts to fulfill data requirements for projects Document query logic and database-related processes Qualifications: Bachelor’s degree (or final year student) in Computer Science, Information Technology, or related field Strong understanding of SQL and relational databases (e.g., MySQL, PostgreSQL, SQL Server) Familiarity with database design and normalization Analytical mindset with good problem-solving skills Ability to work independently in a remote setting Eagerness to learn and grow in a data-driven environment Preferred Skills (Nice to Have): Experience with procedures, triggers, or functions in SQL Exposure to BI/reporting tools (Power BI, Tableau, etc.) Understanding of data warehousing concepts Familiarity with cloud-based databases or platforms What We Offer: Monthly stipend of ₹25,000 Remote work opportunity Hands-on experience with real-world datasets and projects Mentorship and structured learning sessions Certificate of Completion Potential for full-time employment based on performance Show more Show less

Job Title: SQL Developer Trainee Location: Remote Job Type: Internship (Full-Time) Duration: 1–3 Months Stipend: ₹25,000/month Department: Data & Engineering Job Summary: We are seeking a detail-oriented and motivated SQL Developer Trainee to join our team remotely. This internship is designed for recent graduates or students who want to gain practical experience in database development, writing SQL queries, and working with data in real-world applications. Key Responsibilities: Write, test, and optimize SQL queries for data extraction and reporting Assist in designing and maintaining database structures (tables, views, indexes, etc.) Help ensure data integrity, accuracy, and security across systems Support the team in troubleshooting and debugging database-related issues Collaborate with developers and analysts to fulfill data requirements for projects Document query logic and database-related processes Qualifications: Bachelor’s degree (or final year student) in Computer Science, Information Technology, or related field Strong understanding of SQL and relational databases (e.g., MySQL, PostgreSQL, SQL Server) Familiarity with database design and normalization Analytical mindset with good problem-solving skills Ability to work independently in a remote setting Eagerness to learn and grow in a data-driven environment Preferred Skills (Nice to Have): Experience with procedures, triggers, or functions in SQL Exposure to BI/reporting tools (Power BI, Tableau, etc.) Understanding of data warehousing concepts Familiarity with cloud-based databases or platforms What We Offer: Monthly stipend of ₹25,000 Remote work opportunity Hands-on experience with real-world datasets and projects Mentorship and structured learning sessions Certificate of Completion Potential for full-time employment based on performance Show more Show less

Location Hyderabad, Telangana, India Category Technology Careers Job Id JREQ191357 Job Type Full time Hybrid Job Description: Provides highly skilled technical support/delivery capability as technical lead for the current and future delivery, support, and maintenance of future production services in the technical operations environment. Leads technical and procedural consistency within a team focused on the implementation, service delivery, and support of products, systems, & networks. Leads initiatives for driving down incident rates and working with 1st line operations to improve service recovery times. Leads the implementation process to ensure that all aspects of operability are delivered whilst ensuring that existing service levels are maintained or improved. Complies with operational standards, procedures, and best practice. Operations Engineers within specialist functional teams may have compliance assurance responsibility. About the Role In this opportunity as Senior Software Engineer, you will Provides a high level of technical and subject matter expertise in one or more technologies and serves as a point of escalation for technical issues related to specialty. Produces, delivers, and maintains appropriate documentation for systems in accordance document control standards and procedures. Provide input to records, quality systems and management reports as required Contributes to the definition and implementation of improved operability on new and current systems. Uses innovative methods including the redesign of process and providing technical solutions to reduce the volume and mean time to recover incidents in assigned business unit. Identifies risks & issues and takes ownership to deliver appropriate resolutions. Provides technical expertise for root cause analysis and problem management. Provides detailed implementation/project plans across multiple, complex work streams according to agreed standards and ensures project processes and timelines are understood and followed. Works and cooperates with internal and external groups when required in order to fully support environments and maintain service. Adheres to change management procedures in defining, planning and implementing change in such a way that ensures appropriate coordination with other teams, minimizes service disruption, and ensures adherence to Service Level Agreements. Improves change management processes and procedures to ensure the most efficient processing of change within appropriate service risk constraints. Provides specialist support during complex and/or major incidents. May be asked to lead recovery efforts during major incidents within business unit. Deputize for the team manager as required. Contributes to or author technical documentation such complex changes instructions. Reviews, and updates as appropriate, operations procedures, standards, and technical policies. May be asked to assist with production of white papers on technical R&D projects Collaborates with business, third party vendors, developers, application support and technical operations groups to determine appropriate hardware/software needed and to resolve any issues impacting the application processes. Stays abreast of recent developments in related technical community, including new technology and business news that may impact vendors’ ability to provide service. Responsible to seek out all information and to fully understand all aspects of each device’s technology configuration and uses all approved engineering tools available to implement conforming change. Leads the analysis and design of complex solutions and requirements definition, including translating technical and business requirements into physical installations, costing design elements, and obtaining agreement to proposed solutions. Reviews and coordinates the implementation of proposed modifications, and changes to the production environment. Provides direction into standards and procedures for monitoring, capacity planning, tuning, maintenance, performance optimization, backups and recovery; ensures infrastructure will meet capacity requirements to deliver projects on time. Database Engineer: Provides direction for: proactive health and performance monitoring of databases, indexes and logs, and troubleshooting of reported issues. Reviews implemented scripts, stored procedures, and reports generated by automated database maintenance scripts. Participates in the technical design process as it relates to database implementations, reviews technical documents, and communicates any risks or issues using the appropriate escalation procedures. Provides directions to Technical Recovery plans (Database Standby and Replication, Backup and Recovery) About You Yo: u’re a fit for the role if your background includes: .Platform Engineer: Packages company-approved hardened versions of targeted operating systems. Ensures stack of agents for management systems are properly installed and connected. Maintains patch levels in accordance with change management and security standards. Storage Engineer: Provides leadership for storage-related projects, including switch installations, disk consolidations, disk assignments, replication, and more. Works closely with architecture teams to set, communicate, and maintain storage standards. Network Engineer: Reviews the network infrastructure documentation/ run book for standards adherence. Complies with all routing and rules sets, sequences, defaults, and standards. Documents and maintains all applicable configuration standards. Assures all NIC and port speeds are appropriately locked down. Application Engineer: Fully familiarizes self with all aspects of the developed code. Recognizes design problems and errors and takes corrective action from a design perspective on the object code environment.Interfaces with development teams on system design enhancements and the elimination of intermittent hardware/software problems.. #LI-SM1 What’s in it For You? Hybrid Work Model: We’ve adopted a flexible hybrid working environment (2-3 days a week in the office depending on the role) for our office-based roles while delivering a seamless experience that is digitally and physically connected. Flexibility & Work-Life Balance: Flex My Way is a set of supportive workplace policies designed to help manage personal and professional responsibilities, whether caring for family, giving back to the community, or finding time to refresh and reset. This builds upon our flexible work arrangements, including work from anywhere for up to 8 weeks per year, empowering employees to achieve a better work-life balance. Career Development and Growth: By fostering a culture of continuous learning and skill development, we prepare our talent to tackle tomorrow’s challenges and deliver real-world solutions. Our Grow My Way programming and skills-first approach ensures you have the tools and knowledge to grow, lead, and thrive in an AI-enabled future. Industry Competitive Benefits: We offer comprehensive benefit plans to include flexible vacation, two company-wide Mental Health Days off, access to the Headspace app, retirement savings, tuition reimbursement, employee incentive programs, and resources for mental, physical, and financial wellbeing. Culture: Globally recognized, award-winning reputation for inclusion and belonging, flexibility, work-life balance, and more. We live by our values: Obsess over our Customers, Compete to Win, Challenge (Y)our Thinking, Act Fast / Learn Fast, and Stronger Together. Social Impact: Make an impact in your community with our Social Impact Institute. We offer employees two paid volunteer days off annually and opportunities to get involved with pro-bono consulting projects and Environmental, Social, and Governance (ESG) initiatives. Making a Real-World Impact: We are one of the few companies globally that helps its customers pursue justice, truth, and transparency. Together, with the professionals and institutions we serve, we help uphold the rule of law, turn the wheels of commerce, catch bad actors, report the facts, and provide trusted, unbiased information to people all over the world. About Us Thomson Reuters informs the way forward by bringing together the trusted content and technology that people and organizations need to make the right decisions. We serve professionals across legal, tax, accounting, compliance, government, and media. Our products combine highly specialized software and insights to empower professionals with the data, intelligence, and solutions needed to make informed decisions, and to help institutions in their pursuit of justice, truth, and transparency. Reuters, part of Thomson Reuters, is a world leading provider of trusted journalism and news. We are powered by the talents of 26,000 employees across more than 70 countries, where everyone has a chance to contribute and grow professionally in flexible work environments. At a time when objectivity, accuracy, fairness, and transparency are under attack, we consider it our duty to pursue them. Sound exciting? Join us and help shape the industries that move society forward. As a global business, we rely on the unique backgrounds, perspectives, and experiences of all employees to deliver on our business goals. To ensure we can do that, we seek talented, qualified employees in all our operations around the world regardless of race, color, sex/gender, including pregnancy, gender identity and expression, national origin, religion, sexual orientation, disability, age, marital status, citizen status, veteran status, or any other protected classification under applicable law. Thomson Reuters is proud to be an Equal Employment Opportunity Employer providing a drug-free workplace. We also make reasonable accommodations for qualified individuals with disabilities and for sincerely held religious beliefs in accordance with applicable law.

Location Hyderabad, Telangana, India Category News & Editorial Careers Job Id JREQ190761 Job Type Full time Hybrid Job Description Summary: Analyse, create, and deliver content that enhances the research value to customers of Thomson Reuters legal information, within parameters established by management and/or editors. Act as a resource for junior staff in handling both substantive content and production issues related to responsibilities Commentary Law: As a member of the Global Commentary editorial team, you will work closely with other teams and individuals to collaborate on your work. Relationship management, meeting deadlines, and strong editorial skills are necessary to maintain our indexes as part of our world-class commentary collection. About the Role: In this role, you will provide legal interpretation to create or update existing indexes for Thomson Reuters Legal in all media. Members of this team are also tasked with ensuring that published indexes contain and deliver appropriate legal concepts and terms to create a quality finding aid for our customers. There are several key responsibilities of the Attorney Editor role: Create back-of-the-book indexes: Our Attorney Editors generate back-of-the-book indexes by creating original content or by updating an existing index. When applicable they incorporate their index into an existing general index. They follow the required style guidelines and deliver within extremely strict and tight time deadlines. Editorial Responsibility: Members of this team adhere to editorial publishing schedules and quality standards. They also verify their own work for accuracy and completeness and ensure that the information is properly presented and organized. In this role, attention to detail, knowledge of legal concepts and “terms of art” of how legal concepts fit together, and the ability to synthesize complex material are required. Individual and Leadership Development: As a part of a larger team, you will attend and participate in meetings and take part in the employee evaluation process (both wider feedback and self-evaluation). To be most effective at your job, you will develop knowledge of Thomson Reuters Legal publications and products related to your responsibilities, and those of competitors. Members of our team prioritize their own work and understand the roles and responsibilities of each collaborator/team member and how each role impacts production. You will also be required to demonstrate competence on company-specific systems necessary to perform your job functions. About you: Education: Legal degree from an accredited law school. Self-starter with an aptitude for legal concepts and “terms of art” of how legal concepts fit together Analytical thinker who uses logic and collaborates to solve difficult problems Decisive with a focus on making quality decisions quickly Driven by deadlines and can deliver results Ability to interpret, analyze, organize, and communicate complex legal material. Comfortable with personal computers and familiar with word processing and online applications Can prioritize tasks and projects and pursue them with energy and drive Great teammate who will work successfully in a shared environment. Strong communicator who can speak and write clearly and effectively with all contacts, both in and outside Thomson Reuters. #LI-AM1 What’s in it For You? Hybrid Work Model: We’ve adopted a flexible hybrid working environment (2-3 days a week in the office depending on the role) for our office-based roles while delivering a seamless experience that is digitally and physically connected. Flexibility & Work-Life Balance: Flex My Way is a set of supportive workplace policies designed to help manage personal and professional responsibilities, whether caring for family, giving back to the community, or finding time to refresh and reset. This builds upon our flexible work arrangements, including work from anywhere for up to 8 weeks per year, empowering employees to achieve a better work-life balance. Career Development and Growth: By fostering a culture of continuous learning and skill development, we prepare our talent to tackle tomorrow’s challenges and deliver real-world solutions. Our Grow My Way programming and skills-first approach ensures you have the tools and knowledge to grow, lead, and thrive in an AI-enabled future. Industry Competitive Benefits: We offer comprehensive benefit plans to include flexible vacation, two company-wide Mental Health Days off, access to the Headspace app, retirement savings, tuition reimbursement, employee incentive programs, and resources for mental, physical, and financial wellbeing. Culture: Globally recognized, award-winning reputation for inclusion and belonging, flexibility, work-life balance, and more. We live by our values: Obsess over our Customers, Compete to Win, Challenge (Y)our Thinking, Act Fast / Learn Fast, and Stronger Together. Social Impact: Make an impact in your community with our Social Impact Institute. We offer employees two paid volunteer days off annually and opportunities to get involved with pro-bono consulting projects and Environmental, Social, and Governance (ESG) initiatives. Making a Real-World Impact: We are one of the few companies globally that helps its customers pursue justice, truth, and transparency. Together, with the professionals and institutions we serve, we help uphold the rule of law, turn the wheels of commerce, catch bad actors, report the facts, and provide trusted, unbiased information to people all over the world. About Us Thomson Reuters informs the way forward by bringing together the trusted content and technology that people and organizations need to make the right decisions. We serve professionals across legal, tax, accounting, compliance, government, and media. Our products combine highly specialized software and insights to empower professionals with the data, intelligence, and solutions needed to make informed decisions, and to help institutions in their pursuit of justice, truth, and transparency. Reuters, part of Thomson Reuters, is a world leading provider of trusted journalism and news. We are powered by the talents of 26,000 employees across more than 70 countries, where everyone has a chance to contribute and grow professionally in flexible work environments. At a time when objectivity, accuracy, fairness, and transparency are under attack, we consider it our duty to pursue them. Sound exciting? Join us and help shape the industries that move society forward. As a global business, we rely on the unique backgrounds, perspectives, and experiences of all employees to deliver on our business goals. To ensure we can do that, we seek talented, qualified employees in all our operations around the world regardless of race, color, sex/gender, including pregnancy, gender identity and expression, national origin, religion, sexual orientation, disability, age, marital status, citizen status, veteran status, or any other protected classification under applicable law. Thomson Reuters is proud to be an Equal Employment Opportunity Employer providing a drug-free workplace. We also make reasonable accommodations for qualified individuals with disabilities and for sincerely held religious beliefs in accordance with applicable law.

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less

Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid Estimated Start Date: 2025-07-02 Estimated End Date: 2026-04-02 #Business Days: 248.00 Extension : Probable after the initial mandate Hours per day or Week: 7.25 hours per day Security Level: CRJMC Description Responsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining the main entities and their relationships. Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects. Implement designs showing how data will be stored, including tables, columns, indexes, and relationships. Design diagrams showing how different data systems and databases interact and are integrated. Document standards and policies for data management, including naming conventions, data quality standards, and data security policies. Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity. Compile detailed descriptions of data elements, their meanings, and their relationships. Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization. Document and design processes for extracting, transforming, and loading data from various sources. Strategize and schedule the movement of data from legacy systems to new systems or platforms. Detail the design of the data warehouse, including the schema, dimensions, and fact tables. Set up and configure BI tools and dashboards. Regularly report on the quality of data, identifying issues and areas for improvement. Develop strategies and methods for cleaning and improving the quality of data. Plan and diagram how data security will be implemented and maintained. Document compliance with relevant regulations and standards. Develop strategies for improving the efficiency and performance of data systems. Detail plans for data architecture projects, including timelines, milestones, and resources required. Document technical specifications for all data architecture components and processes. Experience And Skill Set Requirements Public Sector Experience – 5 Points 5+ years of experience working with federal/provincial/broader public-sector healthcare providers. Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices. In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies. Knowledge and experience with Public Sector Health related projects. Knowledge and understanding of Ministry policy and IT project approval processes and requirements. Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies. Experience with large complex IT Health-related projects. Technical Skills And Experience – 50 Points 7+ years experiences in the following: developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas. Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer). developing and implementing common data models and master data management strategies design schemas that balance agility, schema flexibility, data governance, and quality. Expertise in creating schemas that allow flexible querying and analysis across various data formats. defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns. implementing schemas and metadata structures that support efficient data management. Understanding of data governance principles and practices, especially in designing schemas and metadata structures. Experience in creating Architecture Artefacts based on enterprise standards. 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse. 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment. Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks. Core Skill And Experience – 30 Points 10+ years experience with Solutions development. Experience in addressing complex data integration challenges and design efficient, scalable data models. Experience in monitoring and enforcing data modelling/normalization standards. Experience with the privacy and security requirements or software development in a health context, or equivalent. Demonstrated knowledge of leading technical design, security and recovery procedures for application development. Experience with relational and hierarchical database technologies. Demonstrated understanding and experience with the use of information retrieval packages using query languages. Experience in production environment troubleshooting and tuning to improve performance. Knowledge and experience of Information Management tools, principles, concepts, policies and practices. General Skills – 15 Points Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols. Knowledge of performance considerations for different database designs in different environments. Experience in structured methodologies for the design, development and implementation of applications. Experience in systems analysis and design in large or medium systems environments. Awareness of emerging I&IT trends and directions Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders. Experience working with cross-functional teams, including IT, business, and data engineering teams. Strong analytical skills to understand and model complex data relationships and structures. Meticulous attention to detail in designing and implementing data models and schemas. Note This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager. Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 2, 2026. HSC may exercise its option(s) to extend a SOW beyond April 2, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW. Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com Without mandatory documents, we cannot submit a candidate. Updated Resume in word format (Mandatory) Skills Matrix and References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348. Show more Show less