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)