وظائف SQL في مصر

Job Description:• Own the day-to-day administration of all production databases — installation, configuration, patching, user management, and routine maintenance.• Monitor database health continuously — performance metrics, resource utilization, replication lag, connection counts, lock contention, and storage growth — with proactive alerting before thresholds are breached.• Manage database user accounts and access controls — implement and enforce least privilege access, role separation, and periodic access reviews.<br>• Design, implement, and manage database high availability solutions — • Define and maintain the database disaster recovery strategy — RPO and RTO targets, tested failover procedures, and documented recovery runbooks.• Implement and manage automated backup solutions • Test backup and recovery procedures regularly — restore drills must be documented, scheduled, and performed, not just assumed to work.• Implement and manage database migration tooling — ensuring schema changes are version-controlled, repeatable, and automatically applied through the deployment pipeline.<br><br>Work with application development teams — review data models, advise on schema design, and ensure applications interact with the database efficiently.• Work with the data engineering team — define data pipeline requirements, ensure ETL processes do not degrade production database performance, and maintain clean data contracts.• Work with the infrastructure team — define storage requirements, I/O performance specifications, and server configuration standards for database hosts.• Work with the Dev Ops team — integrate database change management into the CI/CD pipeline, define automated testing requirements for database changes.<br>Job Responsibilities:Experience• 4 to 7 years of hands-on database administration experience — in production environments, not just development or support roles.• Demonstrable experience with Postgre SQL in production — administration, performance tuning, replication, and high availability. Postgre SQL is the primary platform.• Experience implementing and managing database HA solutions — replication, automatic failover, and connection pooling in production.• Experience in a regulated environment — financial services, healthcare, or equivalent — with understanding of audit requirements and data security controls.• Experience participating in or supporting database disaster recovery testing — not just designing the plan, but executing and validating it.<br>Technical Skills• Postgre SQL — administration, configuration, performance tuning, replication (streaming, logical), Patroni, PgBouncer, pg Back Rest.• SQL — advanced query writing, execution plan analysis, index design, and query optimisation.• Database monitoring — pg_stat views, Prometheus postgres_exporter, or equivalent monitoring stack integration.• Backup and recovery — pg Back Rest, pg_dump, WAL archiving, point-in-time recovery.• Database security — role management, row-level security, SSL/TLS configuration, audit logging.• Linux system administration — sufficient to manage database server operating systems, storage configuration, and performance tuning at the OS level.• Shell scripting — Bash or Python for automation of routine DBA tasks.• Additional database platforms are an advantage — Oracle, SQL Server, MySQL — particularly for understanding cross-platform migration and integration scenarios. Education• Bachelor's degree in Computer Science, Information Technology, or a related field. Arabic and English fluency — written and spoken

<ul><li><p>الواجهات الأمامية: HTML, CSS, JavaScript وإطارات العمل مثل React.js أو Next.js.</p></li><li><p>الواجهات الخلفية وخوادم التشغيل: Node.js, Python/Django, أو PHP/Laravel.</p></li><li><p>قواعد البيانات: التعامل مع SQL (مثل PostgreSQL أو MySQL) وNoSQL (مثل MongoDB).</p></li><li><p>أدوات الإدارة والرفع: Git، نظام تحكم النسخ، وأساسيات الخوادم السحابية (AWS) والحاويات (Docker)</p></li></ul><p></p><p><strong>Requirements</strong></p><p></p><ul><li><p><strong>الأساسيات:</strong> HTML5, CSS3, JavaScript (ES6+).</p></li><li><p><strong>أطر العمل والمكتبات (Frameworks/Libraries):</strong> إتقان أحد الأطر الحديثة مثل React.js, Vue.js, أو Angular (مع زيادة الطلب على إطار Next.js أو Nuxt.js لتطوير واجهات متقدمة وداعمة للـ SEO).</p></li><li><p><strong>أدوات التنسيق وتجربة المستخدم:</strong> Tailwind CSS, Bootstrap, أو Sass لتصميم واجهات متجاوبة (Responsive Design) تعمل على مختلف الشاشات.</p></li><li><p><strong>إدارة الحالة (State Management):</strong> Redux, Zustand, أو Context API.<br><strong>Node.js / Express.js / NestJS</strong> (الأكثر طلباً للربط المباشر مع JavaScript/TypeScript).</p></li><li><p><strong>Python</strong> (Django أو Flask).</p></li><li><p><strong>PHP</strong> (Laravel).</p></li><li><p><strong>C#</strong> (.NET Core) أو <strong>Java</strong> (Spring Boot).</p></li></ul><ul><li><p><strong>واجهات برمجة التطبيقات (APIs):</strong> تصميم وبناء RESTful APIs و GraphQL، ومعالجة Webhooks.<br><strong>قواعد البيانات العلائقية (Relational / SQL):</strong> PostgreSQL, MySQL.</p></li><li><p><strong>قواعد البيانات غير العلائقية (NoSQL):</strong> MongoDB, Redis (للتخزين المؤقت - Caching).</p></li><li><p><strong>أدوات إدارة قواعد البيانات (ORMs):</strong> Prisma, TypeORM, Mongoose, أو Sequelize.<br><strong>دارة النسخ البرمجية:</strong> إتقان Git و GitHub/GitLab لتتبع التغييرات والعمل مع الفرق.</p></li><li><p><strong>النشر والسحابة (Deployment &amp; Cloud):</strong> فهم أساسيات التعامل مع خدمات مثل AWS, Vercel, Render, أو Docker لتجميع ونشر التطبيقات.</p></li><li><p><strong>الأمان (Security Fundamentals):</strong> حماية التطبيقات من الثغرات الشائعة (مثل CORS, CSRF, XSS, SQL Injection) وتطبيق آليات المصادقة (JWT, OAuth).</p></li></ul><p></p>

<ul><li><p>الواجهات الأمامية: HTML, CSS, JavaScript وإطارات العمل مثل React.js أو Next.js.</p></li><li><p>الواجهات الخلفية وخوادم التشغيل: Node.js, Python/Django, أو PHP/Laravel.</p></li><li><p>قواعد البيانات: التعامل مع SQL (مثل PostgreSQL أو MySQL) وNoSQL (مثل MongoDB).</p></li><li><p>أدوات الإدارة والرفع: Git، نظام تحكم النسخ، وأساسيات الخوادم السحابية (AWS) والحاويات (Docker)</p></li></ul><p></p><p><strong>Requirements</strong></p><p></p><ul><li><p><strong>الأساسيات:</strong> HTML5, CSS3, JavaScript (ES6+).</p></li><li><p><strong>أطر العمل والمكتبات (Frameworks/Libraries):</strong> إتقان أحد الأطر الحديثة مثل React.js, Vue.js, أو Angular (مع زيادة الطلب على إطار Next.js أو Nuxt.js لتطوير واجهات متقدمة وداعمة للـ SEO).</p></li><li><p><strong>أدوات التنسيق وتجربة المستخدم:</strong> Tailwind CSS, Bootstrap, أو Sass لتصميم واجهات متجاوبة (Responsive Design) تعمل على مختلف الشاشات.</p></li><li><p><strong>إدارة الحالة (State Management):</strong> Redux, Zustand, أو Context API.<br><strong>Node.js / Express.js / NestJS</strong> (الأكثر طلباً للربط المباشر مع JavaScript/TypeScript).</p></li><li><p><strong>Python</strong> (Django أو Flask).</p></li><li><p><strong>PHP</strong> (Laravel).</p></li><li><p><strong>C#</strong> (.NET Core) أو <strong>Java</strong> (Spring Boot).</p></li></ul><ul><li><p><strong>واجهات برمجة التطبيقات (APIs):</strong> تصميم وبناء RESTful APIs و GraphQL، ومعالجة Webhooks.<br><strong>قواعد البيانات العلائقية (Relational / SQL):</strong> PostgreSQL, MySQL.</p></li><li><p><strong>قواعد البيانات غير العلائقية (NoSQL):</strong> MongoDB, Redis (للتخزين المؤقت - Caching).</p></li><li><p><strong>أدوات إدارة قواعد البيانات (ORMs):</strong> Prisma, TypeORM, Mongoose, أو Sequelize.<br><strong>دارة النسخ البرمجية:</strong> إتقان Git و GitHub/GitLab لتتبع التغييرات والعمل مع الفرق.</p></li><li><p><strong>النشر والسحابة (Deployment &amp; Cloud):</strong> فهم أساسيات التعامل مع خدمات مثل AWS, Vercel, Render, أو Docker لتجميع ونشر التطبيقات.</p></li><li><p><strong>الأمان (Security Fundamentals):</strong> حماية التطبيقات من الثغرات الشائعة (مثل CORS, CSRF, XSS, SQL Injection) وتطبيق آليات المصادقة (JWT, OAuth).</p></li></ul><p></p>

<section><p class="heading jdMain">Job Description</p><p class="heading">Roles &amp; Responsibilities</p><div class="paragraph"><p>As a Data Analyst at Prepit, you will be responsible for analyzing data, building and maintaining ETL processes, ensuring data quality, and delivering insights that drive product and business decisions. You'll collaborate closely with Product, Engineering, and Business teams to develop scalable reporting solutions and support a data-driven culture.</p><p>Key Responsibilities</p><ul><li>Collect, clean, transform, and analyze data from multiple sources.</li><li>Design, develop, and maintain ETL/ELT pipelines to ensure reliable and timely data availability.</li><li>Write efficient SQL queries to extract, validate, and analyze data.</li><li>Build and maintain dashboards and reports using Metabase.</li><li>Partner with Product, Engineering, and Business teams to define KPIs and reporting requirements.</li><li>Monitor data quality and implement validation checks to ensure data accuracy.</li><li>Perform ad hoc analyses to identify trends, opportunities, and business insights.</li><li>Support data modeling and optimize datasets for reporting and analytics.</li><li>Document data sources, ETL processes, and reporting logic.</li><li>Continuously improve data workflows through automation and process optimization.</li></ul></div></section><section><p class="heading">Desired Candidate Profile</p><p class="paragraph"></p><ul><li>Bachelor's degree in Computer Science, Data Science, Information Systems, Statistics, Engineering, or a related field.</li><li>2 years of experience as a Data Analyst or in a similar role.</li><li>Strong proficiency in SQL.</li><li>Hands-on experience designing and maintaining ETL/ELT processes.</li><li>Experience working with relational databases (PostgreSQL, MySQL, or similar).</li><li>Experience creating dashboards and reports using Metabase.</li><li>Good understanding of data modeling and data warehousing concepts.</li><li>Experience with Python (Pandas) for data analysis or automation is a plus.</li><li>Familiarity with cloud platforms and modern data architectures is an advantage.</li><li>Excellent analytical, problem-solving, and communication skills.</li><li>Ability to work independently in a fast-paced startup environment.</li></ul><p></p></section>

<p>Flairstech is looking for a Senior Database Administrator to join our engineering team, reporting to the CTO. You'll own how we design, operate, and govern data at the database layer schema and migration standards, performance tuning and capacity planning, backup and disaster-recovery discipline, and access security across our production MySQL and PostgreSQL databases, partnering closely with engineering and DevSecOps rather than working in isolation. This role also plays an integral part in a major new initiative: a procurement and catalog platform built around a canonical product/supplier-offering data model, master data governance, and an event-driven architecture, much of it extending our existing PostgreSQL environment (including the pgvector extension for semantic search and relationship modeling for a knowledge graph. You'll help design and scale the data model underneath that platform alongside a small, senior engineering team, and set the standards the rest of the organization builds on as our database needs continue to grow.</p><h4>What You'll Do</h4><h5>Database Design &amp; Standards</h5><p>Establish schema design standards, migration conventions, and a review process for database changes across MySQL and PostgreSQL services work currently done ad hoc by the engineers building each feature. Review and advise on schema changes proposed by application engineers (procure, core-api, job-workers), with a focus on indexing strategy, normalization tradeoffs, and query performance. Document data modeling conventions and migration practices so the standards outlive any one person's institutional knowledge.</p><h5>Performance, Reliability &amp; Operations</h5><p>Own query performance tuning and capacity planning across production databases, monitoring for slow queries, lock contention, and connection saturation before they become incidents. Partner with DevSecOps to define and test backup, restore, and disaster-recovery procedures verifying, not just configuring, Multi-AZ failover and the existing 30-day backup retention. Build database health monitoring and alerting so degradation is caught proactively rather than discovered during troubleshooting.</p><h5>Lifecycle, Governance &amp; Security</h5><p>Own database version lifecycle management: planning and executing engine upgrades ahead of end-of-support, and decommissioning legacy or duplicate instances once migrations are confirmed complete. Partner with DevSecOps to bring database versions under Infrastructure-as-Code management and to close network exposure and access-control findings as they're identified. Manage database access control and credential hygiene least-privilege roles, credential rotation, and audit logging of privileged access.</p><h5>Data Platform &amp; Analytics</h5><p>Provide database and data-modeling expertise for our Snowflake/dbt analytics environment, helping extend the same version and access governance there. Support engineering and product teams with data modeling guidance for features with analytics or reporting requirements. Act as the team's go-to resource for database questions, mentoring engineers on schema design and query performance as part of code review.</p><h5>Catalog &amp; Search Platform Initiative</h5><p>Serve as the database lead for a new procurement and catalog platform a canonical product/supplier-offering data model with master data governance, versioned catalog history, and multi-tenant customer-specific views extending our existing PostgreSQL environment rather than standing up new database infrastructure. Design and tune the PostgreSQL schema underneath the catalog domain, including catalog versioning and audit history, an ID crosswalk to legacy transactional records, and relationship tables supporting a knowledge graph. Support the platform's pgvector-based semantic search and its event-driven architecture schema-versioned events, idempotent processing, and the replay strategy that lets catalog and search state be rebuilt from history. Advise on performance and isolation for multi-tenant customer catalogs, including row-level tenant isolation and materialized views for high-volume accounts. Extend our Snowflake/dbt warehouse to support the platform's analytics and data-quality KPIs, such as match confidence, pricing/inventory freshness, and catalog completeness.</p><h4>What We're Looking For</h4><h5>Required</h5><ul><li>7+ years of hands-on database administration experience in production environments, including at least one relational engine at meaningful scale (MySQL and/or PostgreSQL).</li><li>Demonstrated ownership of query performance tuning, indexing strategy, and query optimization in a live production system.</li><li>Experience planning and executing major database engine upgrades and migrations (e.g., blue/green or similar cutover strategies) with minimal downtime.</li><li>Strong understanding of backup/restore, high-availability, and disaster-recovery patterns (Multi-AZ, automated backups, failover testing) in a cloud environment (AWS RDS or equivalent).</li><li>Comfort working with event-driven, eventually-consistent data architectures schema versioning, idempotent processing, and rebuild-from-event-history patterns not just traditional transactional systems.</li><li>Experience establishing schema design standards, review processes, or data modeling conventions for an engineering team without a dedicated DBA function.</li><li>Comfort partnering with application engineers and DevSecOps rather than working in isolation this role is as much about building a practice as running one.</li><li>Practical database security fundamentals: least-privilege access, credential rotation, and encryption at rest and in transit.</li><li>Proficiency in SQL and at least one scripting/automation language (Python or Bash) for tooling and monitoring.</li></ul><h5>Nice to Have</h5><ul><li>Experience with cloud data warehouses and transformation tooling (e.g., Snowflake, dbt).</li><li>Experience with Infrastructure-as-Code (Terraform) for managing database resources.</li><li>Experience with PostgreSQL extensions such as pgvector, or modeling graph-like relationships in a relational database.</li><li>Experience supporting master data management, entity resolution, or record-matching systems.</li><li>Experience operating in a SOC 2 or similarly compliance-driven environment.</li><li>Experience</li></ul><p><strong>Desired Candidate Profile</strong></p><ul><li>7+ years of hands-on database administration experience in production environments, including at least one relational engine at meaningful scale (MySQL and/or PostgreSQL).</li><li>Demonstrated ownership of query performance tuning, indexing strategy, and query optimization in a live production system.</li><li>Experience planning and executing major database engine upgrades and migrations (e.g., blue/green or similar cutover strategies) with minimal downtime.</li><li>Strong understanding of backup/restore, high-availability, and disaster-recovery patterns (Multi-AZ, automated backups, failover testing) in a cloud environment (AWS RDS or equivalent).</li><li>Comfort working with event-driven, eventually-consistent data architectures schema versioning, idempotent processing, and rebuild-from-event-history patterns not just traditional transactional systems.</li><li>Experience establishing schema design standards, review processes, or data modeling conventions for an engineering team without a dedicated DBA function.</li><li>Comfort partnering with application engineers and DevSecOps rather than working in isolation this role is as much about building a practice as running one.</li><li>Practical database security fundamentals: least-privilege access, credential rotation, and encryption at rest and in transit.</li><li>Proficiency in SQL and at least one scripting/automation language (Python or Bash) for tooling and monitoring.</li></ul>

<h2 class="h5">Job description</h2> <div class="t-break" data-jb-field="description"> <span>Advansys is a technology solutions provider in the computer software industry, helping enterprises modernize operations through business automation, cloud services, industrial digitization, low-code development, warehouse automation, and strategic outsourcing.<br> The team works on practical technology solutions that improve efficiency, connectivity, and operational performance across complex environments.<br> In this role, you will contribute to automation and connectivity initiatives that support customer-premises equipment and related systems.<br> You will work across system integration, API-related use cases, operational support, and service visibility, partnering with internal teams to help maintain reliable platforms and address technical issues that affect service continuity.<br> Responsibilities Develop responsive fixed and FWA use cases related to CPE managed by HDM.<br> Define new APIs for use cases, including input calls and output results.<br> Maintain the HDM system.<br> Track CPE connection issues.<br> Develop and design Splunk dashboards for fixed CPE statistics.<br> Support integration between HDM and third-party systems to make HDM functions available through them.<br> Troubleshoot missing or non-provisioned CPE issues with network fixed and security teams.<br> Hybrid working model Social and medical insurance Transportation 3-5 years of professional experience in systems administration, automation, or a closely related infrastructure role.<br> Strong experience in Windows Server Administration .<br> Strong experience in Linux Administration (Red Hat, CentOS, and Solaris).<br> Hands-on experience with Oracle WebLogic Administration .<br> Experience in Database Administration (SQL Server, Oracle Database, MySQL, or PostgreSQL), including basic database management, SQL queries, backup, and restore.<br> Proficiency in Python , Bash , and PowerShell scripting.<br> Good understanding of RESTful APIs , JSON , and XML .<br> Experience with API design and testing using Postman and Swagger .<br> Ability to build and integrate APIs based on technical documentation.<br> Experience troubleshooting network connectivity issues .<br> Knowledge of Fixed Network Connectivity , including Fixed Gateway, BNG, Edge Routers, Firewalls, and Gated Community networks.<br> Knowledge of Mobile Internet Connectivity , including GGSN, NAT/IP addressing, and Fixed Wireless Access (FWA).<br> Knowledge of Core Network Connectivity , including Firewall Policies, PE Routers, IP Networking, and Switching.<br> Vendor management.<br> Excellent English communication (spoken and written).<br> Eligible to work in Egypt.<br></span> </div>

<p>We are looking for an Application Support &amp; Integration Engineer to join our team and support telecom platforms, CPE management systems, and integrations with third-party applications. The role combines telecom application support, system integration, API development, Linux/WebLogic administration, scripting, and network troubleshooting .</p><p>Key Responsibilities</p><ul><li>Develop and support fixed broadband and FWA use cases related to CPEs managed through the HDM platform.</li><li>Design and develop RESTful APIs based on technical documentation, including defining API inputs, outputs, and required integrations.</li><li>Maintain and support the HDM (Home Device Management) system and ensure its availability and stability.</li><li>Monitor and troubleshoot CPE connectivity, provisioning, and communication issues .</li><li>Investigate and resolve missing or non-provisioned CPEs in coordination with Network and Security teams.</li><li>Design and develop Splunk dashboards to monitor fixed CPE statistics, connectivity, and system performance.</li><li>Develop and maintain integrations between the HDM platform and third-party systems to expose and consume HDM functionalities.</li><li>Troubleshoot connectivity issues across fixed, mobile, and core network environments.</li><li>Support application and middleware environments, including Oracle WebLogic .</li><li>Develop scripts using Python, Bash, and PowerShell to automate operational and troubleshooting activities.</li><li>Perform basic database administration and queries using Oracle, SQL Server, MySQL, or PostgreSQL .</li><li>Test and troubleshoot APIs using tools such as Postman and Swagger .</li><li>Work closely with Network, Security, Application, and other technical teams to resolve incidents and deliver new technical solutions.</li><li>Participate in on-call support and production troubleshooting when required.</li><li>Coordinate with vendors and third-party teams when required.</li></ul><p><strong>Desired Candidate Profile</strong></p><p>The ideal candidate should have hands-on experience in a telecom or ISP environment, with a strong understanding of fixed broadband, FWA, CPE connectivity, and network integration.</p><p>Bachelor's degree in Computer Science, Information Technology, Telecommunications, Engineering , or a related field.</p><p>2+ years of relevant experience in telecom, ISP, application support, system integration, or a similar environment.</p><p>Strong experience with Linux administration , preferably Red Hat/CentOS.</p><p>Good knowledge of Windows Server Administration .</p><p>Hands-on experience with Oracle WebLogic administration .</p><p>Good knowledge of RESTful APIs, JSON, and XML .</p><p>Experience with API design and testing using Postman and Swagger.</p><p>Ability to build and integrate APIs based on technical documentation .</p><p>Good scripting skills using Python, Bash, and PowerShell .</p><p>Knowledge of databases such as Oracle, SQL Server, MySQL, or PostgreSQL , including basic queries and backup/restore activities.</p><p>Good understanding of IP networking, routing, firewalls, and VPNs .</p><p>Experience troubleshooting network connectivity issues .</p><p>Experience with Splunk dashboards and monitoring is a plus.</p><p>Experience with HDM/CPE management platforms is highly preferred.</p>

<p> <strong> The Job Description <br> </strong>1. Design, develop, and maintain modern web applications and enterprise systems.<br> 2. Build responsive user interfaces using modern front-end frameworks.<br> 3. Develop scalable backend services, APIs, and integrations.<br> 4. Design and optimize database structures and application performance.<br> 5. Utilize AI development tools to accelerate software delivery and improve productivity.<br> 6. Design and develop AI agents and workflow automation solutions.<br> 7. Build integrations with LLMs and external tools.<br> 8. Implement RAG-based applications and knowledge assistants.<br> 9. Work effectively in a fully remote environment.<br> 10. Maintain clear documentation and communication across teams.<strong> </strong></p><strong> </strong><p><strong>Requirements:<br> </strong> </p> <ul> <li>Minimum 5 years of professional software development experience.</li> <li>Proven experience delivering full-stack web applications.</li> <li> Hands-on experience using AI-powered development tools in daily work.</li> <li>Experience building AI-powered applications, agents, or workflow automation solutions.<br> Proven ability to work independently in a remote setting.</li> </ul> <p> <strong>Technical Skills:<br> </strong> </p> <ul> <li>Front-End: React, Angular, Next.js, Vue.js, JavaScript, TypeScript, HTML5, CSS3.</li> <li>Back-End: .NET Core / ASP.NET Core, RESTful APIs, Microservices.</li> <li>Databases: SQL Server, PostgreSQL, MySQL, NoSQL.</li> <li>Cloud &amp; DevOps: Git, CI/CD, Docker, Azure, AWS, or GCP.</li> <li>AI &amp; Agentic Systems (Any of): OpenAI, Claude, Gemini, LangChain, LangGraph, Semantic Kernel, CrewAI, AutoGen, RAG, Vector Databases, Prompt Engineering.</li> <li>AI Development Tools (Any of): Cursor, Claude Code, GitHub Copilot, ChatGPT, Gemini, Windsurf</li> </ul> <p> <strong>Preferred Qualifications:</strong> </p> <ul> <li>Experience building enterprise AI solutions.</li> <li>Experience integrating AI systems with ERP, CRM, or business applications.</li> <li>Knowledge of software architecture and scalable system design.</li> <li>Experience mentoring junior developers.</li> <li>Experience with MCP and modern AI integration patterns.<strong> <br> </strong> <strong> <br> </strong> </li> </ul> <p>Tagged as: .net core , aitools. , angular , asp.net core , AWS , azure , css3 , GCP , html5 , javascript , microservices , next.js , postgresql , restful apis. , sql server , typescript , vue.js </p>

<h2 class="h5">Job description</h2> <div class="t-break" data-jb-field="description"> <span>We are looking for an Application Support &amp; Integration Engineer to join our team and support telecom platforms, CPE management systems, and integrations with third-party applications.<br> The role combines telecom application support, system integration, API development, Linux/WebLogic administration, scripting, and network troubleshooting .<br> The ideal candidate should have hands-on experience in a telecom or ISP environment, with a strong understanding of fixed broadband, FWA, CPE connectivity, and network integration.<br> Key Responsibilities Develop and support fixed broadband and FWA use cases related to CPEs managed through the HDM platform.<br> Design and develop RESTful APIs based on technical documentation, including defining API inputs, outputs, and required integrations.<br> Maintain and support the HDM (Home Device Management) system and ensure its availability and stability.<br> Monitor and troubleshoot CPE connectivity, provisioning, and communication issues .<br> Investigate and resolve missing or non-provisioned CPEs in coordination with Network and Security teams.<br> Design and develop Splunk dashboards to monitor fixed CPE statistics, connectivity, and system performance.<br> Develop and maintain integrations between the HDM platform and third-party systems to expose and consume HDM functionalities.<br> Troubleshoot connectivity issues across fixed, mobile, and core network environments.<br> Support application and middleware environments, including Oracle WebLogic .<br> Develop scripts using Python, Bash, and PowerShell to automate operational and troubleshooting activities.<br> Perform basic database administration and queries using Oracle, SQL Server, MySQL, or PostgreSQL .<br> Test and troubleshoot APIs using tools such as Postman and Swagger .<br> Work closely with Network, Security, Application, and other technical teams to resolve incidents and deliver new technical solutions.<br> Participate in on-call support and production troubleshooting when required.<br> Coordinate with vendors and third-party teams when required.<br> Hybrid working model Social and medical insurance Transportation Bus Bachelor's degree in Computer Science, Information Technology, Telecommunications, Engineering , or a related field.<br> 2+ years of relevant experience in telecom, ISP, application support, system integration, or a similar environment.<br> Strong experience with Linux administration , preferably Red Hat/CentOS.<br> Good knowledge of Windows Server Administration .<br> Hands-on experience with Oracle WebLogic administration .<br> Good knowledge of RESTful APIs, JSON, and XML .<br> Experience with API design and testing using Postman and Swagger.<br> Ability to build and integrate APIs based on technical documentation .<br> Good scripting skills using Python, Bash, and PowerShell .<br> Knowledge of databases such as Oracle, SQL Server, MySQL, or PostgreSQL , including basic queries and backup/restore activities.<br> Good understanding of IP networking, routing, firewalls, and VPNs .<br> Experience troubleshooting network connectivity issues .<br> Experience with Splunk dashboards and monitoring is a plus.<br> Experience with HDM/CPE management platforms is highly preferred.<br></span> </div>

<h3>What You'll Do</h3><h4>Automation &amp; CI/CD</h4><p>Build and maintain automated test suites integrated into the CI/CD pipeline so releases are gated on real test coverage.</p><p>Own the automated testing strategy across services expanding coverage over time and reducing reliance on manual regression passes.</p><p>Troubleshoot test failures in the pipeline and distinguish real regressions from flaky or environment-specific failures.</p><h4>Test Design &amp; Execution</h4><p>Design and execute test plans for new features and defect fixes across the Play/Scala and Spring Boot service tier and the React front end.</p><p>Write and maintain API-level test coverage for services (core-api, cxml-api, procure APIs) and validate behavior against MySQL and PostgreSQL-backed data.</p><p>Own acceptance criteria and verification for defects, and validate acceptance criteria written by Product for enhancements.</p><p>Perform regression testing ahead of releases, scaled to each ticket's assessed risk level (technical, operational, and compliance impact).</p><h4>Release &amp; Environment Support</h4><p>Participate in release-readiness review and sign off on testing scope before releases move to UAT and production.</p><p>Validate behavior consistently across environments (dev, staging, UAT, production) and flag environment drift that could affect test reliability.</p><p>Support UAT coordination with Business Operations, including reviewing release notes and risk scores ahead of each release.</p><p><strong>Desired Candidate Profile</strong></p><h3>What We're Looking For</h3><h4>Required</h4><ul><li>5+ years of experience in a QA, SDET, or software testing role, ideally on a production web application.</li><li>Strong, hands-on experience building and maintaining automated test suites integrated into a CI/CD pipeline (e.g., Selenium, Playwright, Cypress, or similar) this is a key part of the role, not a secondary skill.</li><li>Experience testing both backend services (REST APIs) and browser-based front ends.</li><li>Comfort writing and validating SQL against relational databases (MySQL and/or PostgreSQL) to verify data-level correctness.</li><li>Experience with defect tracking and test-case management tools (e.g., Jira or similar).</li><li>Ability to read enough application code (Java, Scala, or similar JVM languages) to understand what a fix actually changed.</li></ul><h4>Nice to Have</h4><ul><li>Experience testing services deployed on Kubernetes, or working across containerized environments.</li><li>Familiarity with Spring Boot and Play Framework applications specifically.</li><li>Experience in a regulated or compliance-driven environment (SOC 2, life sciences, or similar).</li><li>Exposure to performance or load testing.</li></ul>

<h3>What You'll Do</h3>Automation &amp; CI/CD<br><ul> <li>Build and maintain automated test suites integrated into the CI/CD pipeline so releases are gated on real test coverage.</li> <li>Own the automated testing strategy across services expanding coverage over time and reducing reliance on manual regression passes.</li> <li>Troubleshoot test failures in the pipeline and distinguish real regressions from flaky or environment-specific failures.</li> </ul> Test Design &amp; Execution<br><ul> <li>Design and execute test plans for new features and defect fixes across the Play/Scala and Spring Boot service tier and the React front end.</li> <li>Write and maintain API-level test coverage for services (core-api, cxml-api, procure APIs) and validate behavior against MySQL and PostgreSQL-backed data.</li> <li>Own acceptance criteria and verification for defects, and validate acceptance criteria written by Product for enhancements.</li> <li>Perform regression testing ahead of releases, scaled to each ticket's assessed risk level (technical, operational, and compliance impact).</li> </ul> Release &amp; Environment Support<br><ul> <li>Participate in release-readiness review and sign off on testing scope before releases move to UAT and production.</li> <li>Validate behavior consistently across environments (dev, staging, UAT, production) and flag environment drift that could affect test reliability.</li> <li>Support UAT coordination with Business Operations, including reviewing release notes and risk scores ahead of each release.</li> </ul><p><strong>Desired Candidate Profile</strong></p><h3>What We're Looking For</h3> Required<br><ul> <li>5+ years of experience in a QA, SDET, or software testing role, ideally on a production web application.</li> <li>Strong, hands-on experience building and maintaining automated test suites integrated into a CI/CD pipeline (e.g., Selenium, Playwright, Cypress, or similar) this is a key part of the role, not a secondary skill.</li> <li>Experience testing both backend services (REST APIs) and browser-based front ends.</li> <li>Comfort writing and validating SQL against relational databases (MySQL and/or PostgreSQL) to verify data-level correctness.</li> <li>Experience with defect tracking and test-case management tools (e.g., Jira or similar).</li> <li>Ability to read enough application code (Java, Scala, or similar JVM languages) to understand what a fix actually changed.</li> </ul> Nice to Have<br><ul> <li>Experience testing services deployed on Kubernetes, or working across containerized environments.</li> <li>Familiarity with Spring Boot and Play Framework applications specifically.</li> <li>Experience in a regulated or compliance-driven environment (SOC 2, life sciences, or similar).</li> <li>Exposure to performance or load testing.</li> </ul>

<h2 class="h5">Job description</h2> <div class="t-break" data-jb-field="description"> <p>Flairstech is looking for a Senior Database Administrator to join our engineering team, reporting to the CTO. You'll own how we design, operate, and govern data at the database layer — schema and migration standards, performance tuning and capacity planning, backup and disaster-recovery discipline, and access security — across our production MySQL and PostgreSQL databases, partnering closely with engineering and DevSecOps rather than working in isolation.</p><br><p>This role also plays an integral part in a major new initiative: a procurement and catalog platform built around a canonical product/supplier-offering data model, master data governance, and an event-driven architecture, much of it extending our existing PostgreSQL environment (including the pgvector extension for semantic search and relationship modeling for a knowledge graph). You'll help design and scale the data model underneath that platform alongside a small, senior engineering team, and set the standards the rest of the organization builds on as our database needs continue to grow.</p><br><p><span><strong>What You'll Do</strong></span></p><br><p><span><strong>Database Design &amp; Standards</strong></span></p><br><ul><li>Establish schema design standards, migration conventions, and a review process for database changes across MySQL and PostgreSQL services — work currently done ad hoc by the engineers building each feature.</li><li>Review and advise on schema changes proposed by application engineers (procure, core-api, job-workers), with a focus on indexing strategy, normalization tradeoffs, and query performance.</li><li>Document data modeling conventions and migration practices so the standards outlive any one person's institutional knowledge.</li></ul><p><span><strong>Performance, Reliability &amp; Operations</strong></span></p><br><ul><li>Own query performance tuning and capacity planning across production databases, monitoring for slow queries, lock contention, and connection saturation before they become incidents.</li><li>Partner with DevSecOps to define and test backup, restore, and disaster-recovery procedures — verifying, not just configuring, Multi-AZ failover and the existing 30-day backup retention.</li><li>Build database health monitoring and alerting so degradation is caught proactively rather than discovered during troubleshooting.</li></ul><p><span><strong>Lifecycle, Governance &amp; Security</strong></span></p><br><ul><li>Own database version lifecycle management: planning and executing engine upgrades ahead of end-of-support, and decommissioning legacy or duplicate instances once migrations are confirmed complete.</li><li>Partner with DevSecOps to bring database versions under Infrastructure-as-Code management and to close network exposure and access-control findings as they're identified.</li><li>Manage database access control and credential hygiene — least-privilege roles, credential rotation, and audit logging of privileged access.</li></ul><p><span><strong>Data Platform &amp; Analytics</strong></span></p><br><ul><li>Provide database and data-modeling expertise for our Snowflake/dbt analytics environment, helping extend the same version and access governance there.</li><li>Support engineering and product teams with data modeling guidance for features with analytics or reporting requirements.</li><li>Act as the team's go-to resource for database questions, mentoring engineers on schema design and query performance as part of code review.</li></ul><p><span><strong>Catalog &amp; Search Platform Initiative</strong></span></p><br><ul><li>Serve as the database lead for a new procurement and catalog platform — a canonical product/supplier-offering data model with master data governance, versioned catalog history, and multi-tenant customer-specific views — extending our existing PostgreSQL environment rather than standing up new database infrastructure.</li><li>Design and tune the PostgreSQL schema underneath the catalog domain, including catalog versioning and audit history, an ID crosswalk to legacy transactional records, and relationship tables supporting a knowledge graph.</li><li>Support the platform's pgvector-based semantic search and its event-driven architecture — schema-versioned events, idempotent processing, and the replay strategy that lets catalog and search state be rebuilt from history.</li><li>Advise on performance and isolation for multi-tenant customer catalogs, including row-level tenant isolation and materialized views for high-volume accounts.</li><li>Extend our Snowflake/dbt warehouse to support the platform's analytics and data-quality KPIs, such as match confidence, pricing/inventory freshness, and catalog completeness.</li></ul><p><span><strong>What We're Looking For</strong></span></p><br><p><span><strong>Required</strong></span></p><br><ul><li>7+ years of hands-on database administration experience in production environments, including at least one relational engine at meaningful scale (MySQL and/or PostgreSQL).</li><li>Demonstrated ownership of query performance tuning, indexing strategy, and query optimization in a live production system.</li><li>Experience planning and executing major database engine upgrades and migrations (e.g., blue/green or similar cutover strategies) with minimal downtime.</li><li>Strong understanding of backup/restore, high-availability, and disaster-recovery patterns (Multi-AZ, automated backups, failover testing) in a cloud environment (AWS RDS or equivalent).</li><li>Comfort working with event-driven, eventually-consistent data architectures — schema versioning, idempotent processing, and rebuild-from-event-history patterns — not just traditional transactional systems.</li><li>Experience establishing schema design standards, review processes, or data modeling conventions for an engineering team without a dedicated DBA function.</li><li>Comfort partnering with application engineers and DevSecOps rather than working in isolation — this role is as much about building a practice as running one.</li><li>Practical database security fundamentals: least-privilege access, credential rotation, and encryption at rest and in transit.</li><li>Proficiency in SQL and at least one scripting/automation language (Python or Bash) for tooling and monitoring.</li></ul><p><span><strong>Nice to Have</strong></span></p><br><ul><li>Experience with cloud data warehouses and transformation tooling (e.g., Snowflake, dbt).</li><li>Experience with Infrastructure-as-Code (Terraform) for managing database resources.</li><li>Experience with PostgreSQL extensions such as pgvector, or modeling graph-like relationships in a relational database.</li><li>Experience supporting master data management, entity resolution, or record-matching systems.</li><li>Experience operating in a SOC 2 or similarly compliance-driven environment.</li></ul><p>Experience&nbsp;</p><br> </div>

<h2 class="h5">Job description</h2> <div class="t-break" data-jb-field="description"> <span>Description Intetics, a leading global technology company providing custom software application development, distributed professional teams, software product quality assessment, and “all-things-digital” solutions, is looking for a Senior Golang Developer to enrich its team with a skilled professional who will help drive innovation and deliver cutting-edge solutions.<br> We specialize in high-performance backend development, cloud-native applications, distributed systems, and scalable microservices architectures .<br> Our projects span across various industries, including IoT, cloud computing, fintech, AI-driven solutions, and real-time data processing .<br> We are looking for a passionate and ambitious Golang engineer who can take ownership of backend development, selecting the right technologies and tools to build robust and scalable solutions.<br> If you thrive in an innovative environment and can transform ideas into working solutions, we invite you to join our team.<br> We are seeking Senior Golang Developers to contribute to our growing team and work on complex, high-load backend systems.<br> Primary Responsibilities: Develop, optimize, and maintain scalable, high-performance backend applications using Golang .<br> Design and implement microservices-based architectures and cloud-native solutions.<br> Ensure code quality, scalability, and maintainability through best development practices.<br> Participate in code reviews, design discussions, and architecture decisions .<br> Work closely with cross-functional teams to design and deliver high-impact solutions.<br> Troubleshoot and optimize existing systems for performance, security, and reliability .<br> Contribute to technical documentation and knowledge-sharing within the team.<br> Responsibilities: Requirements: 5+ years of experience in software development, with a strong focus on Golang .<br> Solid understanding of concurrent programming, distributed systems, and microservices .<br> Experience working with RESTful APIs and gRPC .<br> Familiarity with SQL and NoSQL databases (e.<br>g., PostgreSQL, MySQL, MongoDB).<br> Hands-on experience with Docker, Kubernetes, and cloud platforms (AWS, GCP, or Azure).<br> Knowledge of CI/CD pipelines, automated testing, and DevOps practices .<br> Strong problem-solving skills and the ability to work independently.<br> Excellent communication and teamwork skills.<br> Nice to Have: Experience with message brokers (Kafka, RabbitMQ, NATS).<br> Understanding of GraphQL, WebSockets, and streaming architectures .<br> Experience in AI/ML, IoT, or blockchain-related projects .<br> Familiarity with security best practices in backend development.<br> Prior experience working in Agile/Scrum development environments .<br></span> </div>

Key Responsibilities:<br><br>Develop, maintain, and enhance full-stack web applications using C#/. NET for backend services and Type Script/Java Script, HTML, and CSS for frontend development. Design and implement scalable, secure, and maintainable RESTful APIs following best practices for resource modeling, validation, versioning, and error handling. Build responsive and user-friendly interfaces while ensuring optimal performance and cross-browser compatibility. Design, develop, and optimize relational databases such as MySQL, Postgre SQL, or SQL Server, including complex queries, indexing, and performance tuning. Apply software engineering best practices including clean architecture, separation of concerns, dependency injection, and code reusability. Troubleshoot and resolve production issues across frontend, backend, and database layers using a structured root-cause analysis approach. Develop and maintain unit tests and integration tests to ensure application stability, reliability, and quality. Participate actively in code reviews, providing constructive feedback to improve code quality, security, maintainability, and performance. Collaborate closely with Product Managers, Designers, and stakeholders to clarify requirements and deliver effective technical solutions. Own features end-to-end, from UI development and API implementation to database design, deployment, and post-release support. Contribute to Agile development processes, continuously improving delivery practices, system performance, and overall engineering standards.<br><br><br>Minimum Requirements<br><br>Minimum 3 years of hands-on Full Stack Development experience. Strong English communication skills (written and verbal). Proven production experience with C#/. NET, Type Script/Java Script, HTML, CSS, and relational databases. Demonstrated experience building and supporting end-to-end applications in a professional environment.

<p>Database Design &amp; Standards Establish schema design standards, migration conventions, and a review process for database changes across MySQL and PostgreSQL services work currently done ad hoc by the engineers building each feature. Review and advise on schema changes proposed by application engineers (procure, core-api, job-workers), with a focus on indexing strategy, normalization tradeoffs, and query performance. Document data modeling conventions and migration practices so the standards outlive any one person's institutional knowledge. Performance, Reliability &amp; Operations Own query performance tuning and capacity planning across production databases, monitoring for slow queries, lock contention, and connection saturation before they become incidents. Partner with DevSecOps to define and test backup, restore, and disaster-recovery procedures verifying, not just configuring, Multi-AZ failover and the existing 30-day backup retention. Build database health monitoring and alerting so degradation is caught proactively rather than discovered during troubleshooting. Lifecycle, Governance &amp; Security Own database version lifecycle management: planning and executing engine upgrades ahead of end-of-support, and decommissioning legacy or duplicate instances once migrations are confirmed complete. Partner with DevSecOps to bring database versions under Infrastructure-as-Code management and to close network exposure and access-control findings as they're identified. Manage database access control and credential hygiene least-privilege roles, credential rotation, and audit logging of privileged access. Data Platform &amp; Analytics Provide database and data-modeling expertise for our Snowflake/dbt analytics environment, helping extend the same version and access governance there. Support engineering and product teams with data modeling guidance for features with analytics or reporting requirements. Act as the team's go-to resource for database questions, mentoring engineers on schema design and query performance as part of code review. Catalog &amp; Search Platform Initiative Serve as the database lead for a new procurement and catalog platform a canonical product/supplier-offering data model with master data governance, versioned catalog history, and multi-tenant customer-specific views extending our existing PostgreSQL environment rather than standing up new database infrastructure. Design and tune the PostgreSQL schema underneath the catalog domain, including catalog versioning and audit history, an ID crosswalk to legacy transactional records, and relationship tables supporting a knowledge graph. Support the platform's pgvector-based semantic search and its event-driven architecture schema-versioned events, idempotent processing, and the replay strategy that lets catalog and search state be rebuilt from history. Advise on performance and isolation for multi-tenant customer catalogs, including row-level tenant isolation and materialized views for high-volume accounts. Extend our Snowflake/dbt warehouse to support the platform's analytics and data-quality KPIs, such as match confidence, pricing/inventory freshness, and catalog completeness.</p><p><strong>Desired Candidate Profile</strong></p><p>Required 7+ years of hands-on database administration experience in production environments, including at least one relational engine at meaningful scale (MySQL and/or PostgreSQL). Demonstrated ownership of query performance tuning, indexing strategy, and query optimization in a live production system. Experience planning and executing major database engine upgrades and migrations (e.g., blue/green or similar cutover strategies) with minimal downtime. Strong understanding of backup/restore, high-availability, and disaster-recovery patterns (Multi-AZ, automated backups, failover testing) in a cloud environment (AWS RDS or equivalent). Comfort working with event-driven, eventually-consistent data architectures schema versioning, idempotent processing, and rebuild-from-event-history patterns not just traditional transactional systems. Experience establishing schema design standards, review processes, or data modeling conventions for an engineering team without a dedicated DBA function. Comfort partnering with application engineers and DevSecOps rather than working in isolation this role is as much about building a practice as running one. Practical database security fundamentals: least-privilege access, credential rotation, and encryption at rest and in transit. Proficiency in SQL and at least one scripting/automation language (Python or Bash) for tooling and monitoring.</p><p>Nice to Have Experience with cloud data warehouses and transformation tooling (e.g., Snowflake, dbt). Experience with Infrastructure-as-Code (Terraform) for managing database resources. Experience with PostgreSQL extensions such as pgvector, or modeling graph-like relationships in a relational database. Experience supporting master data management, entity resolution, or record-matching systems. Experience operating in a SOC 2 or similarly compliance-driven environment. Experience</p>

Responsibilities:-<br><br> Administer and support enterprise database environments, including monitoring, performance, availability, backup, restore, security, and operational continuity. Develop, review, and maintain SQL queries, functions, procedures, and database objects required to support application and data-processing operations. Manage users, roles, permissions, access controls, and database operational configurations in accordance with approved security requirements. Support data loading, cleansing, validation, integration, troubleshooting, and reconciliation activities within production database environments. Analyze and resolve database incidents, performance issues, data inconsistencies, and operational failures in coordination with technical teams. Support database design changes, schema updates, deployment activities, and production-readiness requirements while maintaining data integrity and service continuity.<br><br>Qualifications<br><br>Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.8+ years of experience in database administration, data operations, or related data engineering roles, with proven leadership experience. Strong hands-on experience with relational databases such as Oracle, SQL Server, Postgre SQL, or MySQL. Solid knowledge of database architecture, performance tuning, high availability, backup & recovery, and disaster recovery. Strong SQL skills and experience in database optimization, troubleshooting, and capacity planning. Experience managing production database environments and ensuring high availability, reliability, and performance. Good understanding of data operations, ETL/ELT processes, data integration, data quality, and data lifecycle management. Experience with cloud databases and data platforms such as Azure, AWS, or Google Cloud is a plus. Knowledge of database security, access control, encryption, auditing, and compliance requirements. Experience with monitoring and observability tools for databases and data platforms. Familiarity with automation and scripting using Python, Power Shell, Bash, or similar technologies. Experience with Dev Ops practices, CI/CD, Infrastructure as Code, and automation is an advantage. Strong understanding of ITIL, incident/problem management, change management, and operational SLAs. Proven experience leading technical teams, managing priorities, and coordinating with infrastructure, application, security, and business teams. Strong analytical, troubleshooting, and problem-solving skills. Excellent communication, stakeholder management, and technical documentation skills. Ability to work effectively in a 24/7 production environment and handle critical incidents when required.