• Lead the administration, configuration, performance tuning, and complex troubleshooting in production environments for MySQL and PostgreSQL. • Manage, monitor, and scale databases hosted on Amazon AWS, primarily utilizing RDS (Relational Database Service). • Design and implement seamless data migration and replication strategies from transactional systems to the Datalake using AWS DMS (Data Migration Service). • Collaborate on the architecture of real-time data pipelines leveraging data streaming tools such as Kafka or Kinesis. • Actively participate in data validation, integrity control, and data discrepancy analysis between source systems and analytical repositories. • Define optimal data modeling and structures that impact the Datalake and satellite systems.

Role Description T-Rex Solutions is looking to select a Database Subject Matter Expert to support our Internal Revenue Service (IRS) EDOS program. The overall mission of this program is to modernize the IRS legacy Tax processing systems and is critical to the overall modernization of the IRS to improve taxpayer experience, increase voluntary compliance, and reduce the IRS’s reliance on costly and unsustainable legacy technology. Qualifications - 8+ years of overall experience - US Citizenship required - Must possess an active IRS MBI Clearance and have current GFE - Methodology for Java/J2EE, Oracle DB, IBM DB2, SQL, Windows, IBM z/OS mainframe, COBOL, JCL, disaster recovery strategies, and system architecture - 6+ years of experience in highly specialized IT disciplines - 6+ years of experience in database programming and/or administration - 4+ years of experience with IBM DB2 database management - 4+ years of experience using IBM z/OS mainframe operating systems - Strong understanding of government security requirements - Excellent project management and organizational skills - Ability to manage multiple tasks and meet tight deadlines Requirements - Bachelor's degree preferred Benefits - PTO available to use immediately upon joining (prorated based on start date) - Paid parental leave - Individual and family health, vision, and dental benefits - Annual budget for training, professional development, and tuition reimbursement - 401(k) plan with company match fully vested after 60 days of employment Company Description Established in 1999, T-Rex Solutions, LLC is a proven mid-tier business providing data-centric mission services to the Federal government as it increasingly tries to secure and leverage the power of data. We design, integrate, secure, and deploy advanced technical solutions for our customers so they can efficiently fulfill their critical objectives. T-Rex offers both IT and professional services to numerous Federal agencies and is a leader in providing high quality and innovative solutions in the areas of Cloud and Infrastructure Services, Cyber Security, and Big Data Engineering. T-Rex is constantly seeking qualified people to join our growing team. We have built a broad client base through our devotion to delivering quality products and customer service, and to do that we need quality individuals. But more than that, we at T-Rex are committed to creating a culture that supports the development of every employee's personal and professional lives. T-Rex has made a commitment to maintain the status of an industry leader in compensation packages and benefits which includes competitive salaries, performance bonuses, training and educational reimbursement, Transamerica 401(k) and Cigna healthcare benefits. T-Rex is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex (including pregnancy and sexual orientation), parental status, national origin, age, disability, family medical history or genetic information, political affiliation, military service, or other non-merit based factors. In compliance with pay transparency guidelines, the annual base salary range for this position is $80,000 - $140,000. Please note that the salary information is a general guideline only. T-Rex considers factors such as (but not limited to) scope and responsibilities of the position, candidate’s work experience, education/training, key skills, internal peer equity, as well as market and business considerations when extending an offer.

Role Description Designs, implements and oversees the physical design and operation of the organization’s databases in order to maintain security and integrity controls. - Oversees operations of on-premises and cloud-based database environments, including production, non-production, and disaster recovery systems. - Designs, implements, and supports hybrid database architectures across on-premises and cloud-based environments. - Leads database migration efforts, including cloud transition strategies with low- to near-zero downtime. - Implements and supports data replication, synchronization, and change data capture solutions. - Designs, configures, and supports virtualized database environments with a focus on performance and scalability. - Develops, maintains, and tests enterprise backup and disaster recovery strategies across hybrid environments. - Collaborates with infrastructure teams to optimize database storage performance across SAN/NAS and cloud-based storage environments. - Designs and develops advanced SQL solutions, including high-performance stored procedures, indexing strategies, and query tuning. - Builds, deploys, and maintains SSIS packages and modern ETL pipelines. - Implements and maintains high availability and resiliency solutions, including Always On Availability Groups, clustering, replication, and geo-replication. - Automates database administration, monitoring, deployment, and maintenance processes using scripting and infrastructure automation tools. - Monitors system health and performance; proactively resolves bottlenecks. - Establishes and enforces database security standards, including encryption, identity integration, and auditing. - Advises leadership on data strategy, cloud adoption, and modernization efforts. Qualifications - Bachelor’s degree in a computer related field from an accredited college or university and six (6) to eight (8) years of experience in related field; or an equivalent combination of education, certification, training, and/or experience. - Microsoft Certified: Azure Database Administrator Associate. - Azure Data Engineer Associate or AWS equivalent. - Oracle Certified Professional (OCP). - Oracle GoldenGate certification preferred. - Ability to organize work for timely completion. - Ability to speak, write, read, and understand English. - Ability to follow complex oral and written instructions. - Ability to communicate effectively orally and in writing. - Ability to establish and maintain effective and cooperative working relationships with those contacted in the course of work. - Skill in Microsoft Office applications. - Skill using database platforms, including Microsoft SQL Server, Oracle Database, Azure SQL Database, and Amazon RDS. - Skill using cloud platforms, including Microsoft Azure and Amazon Web Services. - Skill using data integration and replication tools, including Oracle GoldenGate, SQL Server Integration Services, and Azure Data Factory. - Skill using virtualization technologies, including VMware and Oracle VM. - Skill using automation, scripting, and infrastructure automation tools, including PowerShell and Terraform. - Ability to travel up to 10% of the time. - Ability to commute with personal transportation. Requirements - Ability to exert light physical effort in sedentary to light work, which may involve some lifting, carrying, pushing and/or pulling of objects and materials of light weight (up to 20 pounds). - Functions are regularly performed inside without potential for exposure to adverse conditions, such as inclement weather, atmospheric elements and pathogenic substances. - The noise level in the work environment is usually moderate.

Role Description TEHORA est présentement à la recherche d’un(e) Administrateur(trice) de bases de données MySQL visant à assurer la disponibilité et la stabilité des services critiques, un service de support opérationnel, incluant une capacité d’astreinte 24/7 et le respect de niveaux de service stricts. - Assurer le support opérationnel des bases de données MySQL dans un contexte de gestion déléguée, incluant les environnements de production et hors production. - Prendre en charge l’ensemble des incidents liés aux bases de données, via les outils de billetterie, de surveillance ou de communication définis, en assurant une couverture continue (24/7 pour la production). - Diagnostiquer et résoudre les incidents, notamment en lien avec : - la disponibilité des bases de données - la réplication des données - la performance et le fonctionnement général des systèmes - Respecter les niveaux de service (SLA) en vigueur, incluant les délais de réponse et de résolution selon la criticité des incidents. - Assurer le support des environnements hors production durant les heures ouvrables, incluant le suivi et le traitement des demandes opérationnelles. - Réaliser, sur demande, des interventions spécialisées telles que : - l’installation et la mise à niveau des bases de données MySQL - l’application de correctifs - la modification de configurations - la migration ou l’évolution des bases de données - Accompagner les équipes internes en répondant aux besoins d’expertise technique liés aux bases de données. - Maintenir un niveau de service conforme aux exigences contractuelles, incluant la traçabilité, le suivi des interventions et le respect des processus établis. Qualifications - Expérience significative en administration MySQL (en production). - Capacité à intervenir en environnement critique avec SLA stricts. - Expérience en support opérationnel (incident management). - Maîtrise des concepts suivants : - Réplication MySQL - Sauvegarde et reprise - Performance et disponibilité - Capacité à travailler en mode support (et non développement). - Capacité à assurer une astreinte 24/7. - Capacité à répondre à un incident critique en 15 minutes. - Maîtrise du français (oral et écrit). - Capacité à évoluer dans un environnement conforme aux exigences de sécurité gouvernementales, incluant : - Possession ou obtention d’une attestation de sécurité valide. - Participation obligatoire à une formation en sécurité de l’information. - Respect des exigences de confidentialité et signature d’engagements requis. Benefits - Du télétravail et de la flexibilité pour s’adapter à vos obligations familiales. - Une culture entrepreneuriale favorisant la créativité et l’innovation. - Horaires flexibles (selon le type de contrat de travail). - Congés en cas de maladie et à l’occasion d’événements familiaux. - Outils informatiques adaptés. - Espace de travail épanouissant et motivant. - Initiatives sociales et environnementales. - Programme d’apprentissage en milieu de travail. - Cheminement de carrière. Company Description TEHORA est une firme québécoise multidisciplinaire reconnue pour l’excellence de ses services professionnels, de nature technique et de gestion de projets à l’échelle nationale et internationale. Notre mission est d’accompagner nos clients dans la concrétisation de leurs projets par l’excellence de notre savoir-faire et de notre créativité. Depuis sa création en 2017, notre équipe de professionnels connaît une croissance exponentielle en répondant aux besoins importants en gestion de projets multidisciplinaires, dans le domaine des transports, du génie civil, du TI et plus. Nos collaborateurs travaillent sur des mandats aussi bien à l’interne que chez des clients d’envergure. TEHORA se distingue par sa culture d’entreprise, axée sur le bonheur de ses employés et la diversité. Chez TEHORA, chaque collaborateur est un membre important de l’équipe qui contribue à notre succès collectif. Nos membres ont la flexibilité requise pour avoir un équilibre entre le travail et leur vie privée, tout en menant une carrière enrichissante. Nous offrons un environnement de travail motivant. La diversité des projets, la grande autonomie et l’interaction directe avec les clients sont appréciées. Une telle proximité est possible en raison de notre structure organisationnelle horizontale, qui se traduit par des relations de confiance et une communication efficace entre notre équipe et les clients.