Senior Database Engineer

Cambridge Technology Solutions Ltd; Hyderabad; On-site; INR 900,000 - 1,200,000; Full time

Job summary

Cambridge Technology Solutions Ltd seeks an experienced Database Engineer to design, develop, optimize, and manage enterprise-grade relational and non-relational database systems. You will work with geospatial data, cloud platforms, and modern DevOps practices to ensure data security, availability, and scalable integration across data ecosystems.

The role emphasizes performance tuning, ETL/ELT workflows, and governance for mission-critical applications in GIS, Smart City, and large enterprise

Qualifications

• Minimum 8+ years of experience in database development, administration, and management of large-scale databases.
• Proven expertise in database design, data modeling, SQL query optimization, indexing, and performance tuning.
• Hands-on experience with PostgreSQL/PostGIS, MySQL, Oracle, MongoDB, Cassandra.

Responsibilities

• Design, develop, and maintain scalable relational and non-relational databases for enterprise and analytical systems.
• Develop optimized data models, schemas, ERDs, and normalization strategies.
• Implement and manage PostgreSQL/PostGIS, Oracle, MySQL, MongoDB in production environments.

Skills

PostgreSQL/PostGIS

MySQL

Oracle Database

MongoDB

Cassandra

SQL

Python

R

Shell Scripting

Docker

Kubernetes

CI/CD

Git

GIS & Spatial Tech

ETL/ELT

Tools

Docker

Kubernetes

CI/CD Pipelines

Git

Job description

We are seeking an experienced Database Engineer to design, develop, optimize, and manage enterprise-grade relational and non-relational database systems. The ideal candidate will have strong expertise in database architecture, performance tuning, ETL processes, and large-scale data management, with exposure to geospatial datasets, cloud platforms, and modern DevOps practices. The role involves supporting mission-critical applications, ensuring data security, availability, scalability, and enabling seamless integration across diverse data ecosystems.

Essential Qualifications & Experience

Experience

• Minimum 8+ years of experience in database development, administration, and management of large-scale operational and analytical databases.
• Proven expertise in database design, data modeling, SQL query optimization, indexing strategies, and performance tuning.
• Hands-on experience in designing and managing production-grade databases including:
  • PostgreSQL/PostGIS
  • MySQL
  • Oracle Database
  • MongoDB
  • Cassandra
• Strong experience working with ETL/ELT processes, data integration frameworks, and workflow automation.
• Experience with cloud database platforms such as:
  • AWS RDS
  • Amazon Aurora
  • Azure SQL Database
  • Google Cloud SQL
• Exposure to Python or R for data processing, automation, and analytics workflows.
• Experience managing large-volume datasets, preferably within geospatial, remote sensing, satellite imagery, or IoT environments.
• Prior experience working on Government, Public Sector, Smart City, GIS, or large enterprise projects is highly preferred.
• Working knowledge of containerized environments and DevOps practices using technologies such as Docker, Kubernetes, and CI/CD pipelines.

Domain Knowledge

• Understanding of geospatial data structures, coordinate reference systems (CRS), projections, and spatial indexing techniques.
• Familiarity with OGC, ISO metadata standards, and spatial database best practices.
• Knowledge of database security, high availability, disaster recovery, and compliance frameworks.

Certifications (Mandatory/Preferred)

Relevant certifications in one or more of the following areas are preferred:

• PostgreSQL Certified Professional
• Oracle Database Administration Certification
• Microsoft Azure Database Certifications
• AWS Database Specialty Certification
• MongoDB Certified Developer/DBA
• Cloud or DevOps-related certifications

Key Responsibilities

Database Design & Development

• Design, develop, and maintain scalable relational and non-relational database architectures for enterprise and analytical systems.
• Develop optimized data models, database schemas, entity-relationship diagrams (ERDs), and normalization strategies.
• Implement and manage PostgreSQL/PostGIS, Oracle, MySQL, MongoDB, and other database technologies based on business requirements.
• Define and implement effective indexing, partitioning, and storage strategies for high-performance data access.

Data Integration & ETL

• Design and support robust data ingestion pipelines from:
  • Remote sensing platforms
  • Satellite data sources
  • IoT systems
  • Enterprise applications
  • External APIs
• Develop ETL/ELT workflows for data transformation, validation, and integration.
• Create stored procedures, triggers, functions, views, and automation scripts to improve operational efficiency and data consistency.

Performance Optimization

• Monitor database health and conduct proactive performance tuning.
• Analyze query execution plans and optimize SQL workloads for performance and scalability.
• Implement partitioning, replication, caching, and indexing mechanisms for large datasets.
• Optimize spatial queries, geometry processing, and location-based analytics.

Geospatial Data Management

• Manage spatial and non-spatial datasets within enterprise GIS environments.
• Maintain metadata repositories and data catalogs adhering to OGC and ISO standards.
• Support geospatial interoperability through APIs, web services, and GIS platforms.
• Enable efficient integration with web, mobile, and enterprise GIS applications.

Security, Availability & Governance

• Implement role-based access control (RBAC), authentication, authorization, and data security policies.
• Design and maintain backup, recovery, replication, and high-availability solutions.
• Support disaster recovery planning and business continuity requirements.
• Apply security patches, upgrades, and vulnerability remediation activities.
• Conduct database audits and ensure compliance with organizational and regulatory requirements.

DevOps & Cloud Operations

• Support cloud-native database deployments and hybrid infrastructure environments.
• Collaborate with DevOps teams on CI/CD-enabled database deployment processes.
• Implement database monitoring, logging, and alerting solutions.
• Participate in infrastructure automation and containerized database deployments.

Support & Collaboration

• Provide Level 2/Level 3 technical support for database-related incidents and performance issues.
• Collaborate with application developers, data engineers, GIS specialists, and solution architects to implement robust data solutions.
• Prepare technical documentation, standards, and operating procedures.
• Mentor junior team members and contribute to database best practices across the organization.

Required Technical Skills

Database Technologies

• PostgreSQL/PostGIS
• Oracle Database
• MySQL
• MongoDB
• Cassandra

Programming & Scripting

• SQL/PL-SQL
• Python
• R
• Shell Scripting

Cloud Platforms

• AWS RDS/Aurora
• Azure SQL Database
• Google Cloud SQL

Data Engineering

• ETL/ELT Frameworks
• Data Warehousing
• API Integration
• Workflow Automation

DevOps & Infrastructure

• Docker
• Kubernetes
• CI/CD Pipelines
• Git

GIS & Spatial Technologies

• PostGIS
• Geospatial Data Management
• OGC Standards
• Spatial Indexing
• Coordinate Reference Systems (CRS)