Database Administrator - Postgresql

REVIEW CRITERIA:

MANDATORY:

• Strong Senior/Lead DevOps Engineer Profile
• Must have 8+ years of hands-on experience in DevOps engineering, with a strong focus on AWS cloud infrastructure and services (EC2, VPC, EKS, RDS, Lambda, CloudFront, etc.).
• Must have strong system administration expertise (installation, tuning, troubleshooting, security hardening)
• Must have solid experience in CI/CD pipeline setup and automation using tools such as Jenkins, GitHub Actions, or similar
• Must have hands-on experience with Infrastructure as Code (IaC) tools such as Terraform, CloudFormation, or Ansible
• Must have strong database expertise across MongoDB and Snowflake (administration, performance optimization, integrations)
• Must have experience with monitoring and observability tools such as Prometheus, Grafana, ELK, CloudWatch, or Datadog
• Must have good exposure to containerization and orchestration using Docker and Kubernetes (EKS)
• Must be currently working in an AWS-based environment (AWS experience must be in the current organization)
• Its an IC role

PREFERRED:

• Must be proficient in scripting languages (Bash, Python) for automation and operational tasks.
• Must have strong understanding of security best practices, IAM, WAF, and GuardDuty configurations.
• Exposure to DevSecOps and end-to-end automation of deployments, provisioning, and monitoring.
• Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.
• Candidates from NCR region only (No outstation candidates).

ROLES AND RESPONSIBILITIES:

We are seeking a highly skilled Senior DevOps Engineer with 8+ years of hands-on experience in designing, automating, and optimizing cloud-native solutions on AWS. AWS and Linux expertise are mandatory. The ideal candidate will have strong experience across databases, automation, CI/CD, containers, and observability, with the ability to build and scale secure, reliable cloud environments.

KEY RESPONSIBILITIES:

Cloud & Infrastructure as Code (IaC)-

• Architect and manage AWS environments ensuring scalability, security, and high availability.
• Implement infrastructure automation using Terraform, CloudFormation, and Ansible.
• Configure VPC Peering, Transit Gateway, and PrivateLink/Connect for advanced networking.

CI/CD & Automation:

• Build and maintain CI/CD pipelines (Jenkins, GitHub, SonarQube, automated testing).
• Automate deployments, provisioning, and monitoring across environments.

Containers & Orchestration:

• Deploy and operate workloads on Docker and Kubernetes (EKS).
• Implement IAM Roles for Service Accounts (IRSA) for secure pod-level access.
• Optimize performance of containerized and microservices applications.

Monitoring & Reliability:

• Implement observability with Prometheus, Grafana, ELK, CloudWatch, M/Monit, and Datadog.
• Establish logging, alerting, and proactive monitoring for high availability.

Security & Compliance:

• Apply AWS security best practices including IAM, IRSA, SSO, and role-based access control.
• Manage WAF, Guard Duty, Inspector, and other AWS-native security tools.
• Configure VPNs, firewalls, and secure access policies and AWS organizations.

Databases & Analytics:

• Must have expertise in MongoDB, Snowflake, Aerospike, RDS, PostgreSQL, MySQL/MariaDB, and other RDBMS.
• Manage data reliability, performance tuning, and cloud-native integrations.
• Experience with Apache Airflow and Spark.

IDEAL CANDIDATE:

• 8+ years in DevOps engineering, with strong AWS Cloud expertise (EC2, VPC, TG, RDS, S3, IAM, EKS, EMR, SCP, MWAA, Lambda, CloudFront, SNS, SES etc.).
• Linux expertise is mandatory (system administration, tuning, troubleshooting, CIS hardening etc).
• Strong knowledge of databases: MongoDB, Snowflake, Aerospike, RDS, PostgreSQL, MySQL/MariaDB, and other RDBMS.
• Hands-on with Docker, Kubernetes (EKS), Terraform, CloudFormation, Ansible.
• Proven ability with CI/CD pipeline automation and DevSecOps practices.
• Practical experience with VPC Peering, Transit Gateway, WAF, Guard Duty, Inspector and advanced AWS networking and security tools.
• Expertise in observability tools: Prometheus, Grafana, ELK, CloudWatch, M/Monit, and Datadog.
• Strong scripting skills (Shell/bash, Python, or similar) for automation.
• Bachelor / Master’s degree
• Effective communication skills

PERKS, BENEFITS AND WORK CULTURE:

• Competitive Salary Package
• Generous Leave Policy
• Flexible Working Hours
• Performance-Based Bonuses
• Health Care Benefits

We are looking for a highly skilled Full Stack Developer to design and scale our real-time vehicle tracking platform. You will be responsible for building high-performance web applications that process live GPS data and visualize it through interactive map interfaces.

Key Responsibilities

Real-Time Data Processing: Develop robust back-end services to ingest and process high-frequency GPS data from IoT devices.

Map Integration: Design and implement interactive map interfaces using tools like Google Maps API or Mapbox for real-time asset visualization.

Geofencing & Alerts: Build server-side logic for complex geospatial features, including geofencing, route optimization, and automated speed/entry alerts.

API Development: Create and maintain scalable RESTful or GraphQL APIs to bridge communication between vehicle hardware, the database, and the user dashboard.

Database Management: Architect and optimize databases (e.g., PostgreSQL with PostGIS) for efficient storage and querying of spatial-temporal data.

Performance Optimization: Ensure high availability and low-latency response times for tracking thousands of simultaneous vehicle connections.

Required Technical Skills

Front-End: Proficiency in React.js, Angular, or Vue.js, with experience in state management (Redux/MobX).

Back-End: Strong experience in Node.js (Express/NestJS), Python (Django/Flask), or Java (Spring Boot).

Mapping: Hands-on experience with Google Maps SDK, Leaflet, or OpenLayers.

Real-time Communication: Expertise in WebSockets or Socket.IO for live data streaming.

Databases: Proficiency in SQL (PostgreSQL/MySQL) and NoSQL (MongoDB/Redis) for caching.

Cloud & DevOps: Familiarity with AWS (EC2, Lambda), Docker, and Kubernetes for scalable deployment.

Qualifications

Education: Bachelor’s or Master’s degree in Computer Science or a related field.

Experience: 3–6+ years of professional full-stack development experience.

Niche Knowledge: Prior experience with telematics, IoT protocols (MQTT, HTTP), or GPS-based applications is highly preferred.

Golang Developer

Experience: Minimum 4 years

Job Location: Delhi/Pune/Bangalore-Hybrid

Job Description

• Must: Minimum 2.+ years of experience in Golang programming language, paradigms, constructs, and idioms.
• Knowledge of common Goroutine and channel patterns.
• Experience with the full site of Go frameworks and tools.
• Preferred: Minimum 2+ years of experience in aws.
• Must: Cloud environment (e.g. AWS, VMware, etc.).
• Must: Working Knowledge in Mysql.
• Popular Go web frameworks.
• Familiarity with code versioning tools such as Github / Gitlab.

Key Skills

• Golang, , Javascript, MySQL, Postgresql.
• Responsibilities : The job requries Golang experience with MySQL database.
• Ability to work on a small on minimal supervision Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality.

Job Description:

We are looking for a highly skilled Software Developer with 3-5 years of hands-on experience in LAMP Stack development. The ideal candidate will be responsible for developing and maintaining web applications, ensuring high performance, and collaborating with cross-functional teams to define and ship new features.

Key Responsibilities:

• Develop, maintain, and optimize web applications using LAMP Stack (Linux, Apache, MySQL, PHP)

• Design efficient, scalable, and secure backend systems.

• Collaborate with frontend developers and project stakeholders to deliver high-quality products.

• Write well-structured and testable code, following best practices in PHP.

• Troubleshoot, debug, and upgrade existing applications.

• Develop APIs and integrate third-party services.

• Manage and maintain databases using MySQL.

• Perform system and server maintenance on Linux/Unix environments.

• Use Shell scripting to automate routine tasks and deployments.

• Work with the ELK stack (Elasticsearch, Logstash, Kibana) for logging and monitoring.

Qualifications:

• BE/B.Tech in Computer Science/Information Technology/Electronics and Communications

• 3-5 years of proven experience as a Software Developer working with LAMP Stack

• Proficient in PHP, and MySQL.

• Solid experience with Linux/Unix environments, including command-line proficiency.

• Knowledge of Shell Scripting and basic system automation.

• Familiarity with ELK Stack for application monitoring and logging.

• Strong understanding of web protocols, API integration, and database optimization.

• Experience with version control systems like Git.

• Ability to work in an Agile environment and manage multiple tasks efficiently.

Nice to Have:

• Experience with other Python frameworks besides Flask.

• Knowledge of cloud platforms (AWS, Google Cloud) for deploying and scaling applications.

• Familiarity with containerisation technologies like Docker.

Benefits:

• Competitive salary and performance bonuses.

• Medical and insurance coverage.

• Opportunities for professional development and growth.

• Flexible working hours and remote working options.

Job ID: RP100

Work Location: Remote

Required Experience: 4 to 7 years

Job Description

• Must have Google Cloud Big Query experience
• Strong experience with data analysis, data modeling and governance, with excellent analytical and problem-solving abilities
• Good knowledge of Data Warehouses, data flow ETL pipelines
• Design, configuration/administration of database software in Cloud platform.
• Monitoring, Troubleshooting, and Performance tuning the DB objects.
• Experience on Table Partition, Clustered Table, Materialized View, External Tables etc.

Anyone RDBMS technologies

• Good experience in DB design with knowledge of ER Diagram, PK/FK, Stored procedure, Function, Triggers, and Indexes.
• Understanding the requirement of the App team and creating the necessary DB objects by following the best practices.
• Managing logins and database users, as well as database roles, application roles, and other security principles within the database.
• Deep knowledge about Indexes, Performance tuning, and Complex SQL Query patterns.
• Monitoring, Tuning, and Troubleshooting the database-related issues.

About Us:

Mobile programming LLC is a US-based digital transformation company. We help enterprises transform ideas into innovative and intelligent solutions, governing the Internet of Things, Digital Commerce, Business Intelligence Analytics, and Cloud Programming. Bring your challenges to us, we will give you the smartest solutions. From conceptualizing and engineering to advanced manufacturing, we help customers build and scale products fit for the global marketplace.

Mobile programming LLC has offices located in Los Angeles, San Jose, Glendale, San Diego, Phoenix, Plano, New York, Fort Lauderdale, and Boston. Mobile programming is SAP Preferred Vendor, Apple Adjunct Partner, Google Empaneled Mobile Vendor, and Microsoft Gold Certified Partner.