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)
