Senior Database Engineer

<p>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.</p><p><br></p><p>Essential Qualifications & Experience</p><p>Experience</p><ul><li>Minimum 8+ years of experience in database development, administration, and management of large-scale operational and analytical databases.</li><li>Proven expertise in database design, data modeling, SQL query optimization, indexing strategies, and performance tuning.</li><li>Hands-on experience in designing and managing production-grade databases including:<ul><li>PostgreSQL/PostGIS</li><li>MySQL</li><li>Oracle Database</li><li>MongoDB</li><li>Cassandra</li></ul></li><li>Strong experience working with ETL/ELT processes, data integration frameworks, and workflow automation.</li><li>Experience with cloud database platforms such as:<ul><li>AWS RDS</li><li>Amazon Aurora</li><li>Azure SQL Database</li><li>Google Cloud SQL</li></ul></li><li>Exposure to Python or R for data processing, automation, and analytics workflows.</li><li>Experience managing large-volume datasets, preferably within geospatial, remote sensing, satellite imagery, or IoT environments.</li><li>Prior experience working on Government, Public Sector, Smart City, GIS, or large enterprise projects is highly preferred.</li><li>Working knowledge of containerized environments and DevOps practices using technologies such as Docker, Kubernetes, and CI/CD pipelines.</li></ul><p>Domain Knowledge</p><ul><li>Understanding of geospatial data structures, coordinate reference systems (CRS), projections, and spatial indexing techniques.</li><li>Familiarity with OGC, ISO metadata standards, and spatial database best practices.</li><li>Knowledge of database security, high availability, disaster recovery, and compliance frameworks.</li></ul><p>Certifications (Mandatory/Preferred)</p><p>Relevant certifications in one or more of the following areas are preferred:</p><ul><li>PostgreSQL Certified Professional</li><li>Oracle Database Administration Certification</li><li>Microsoft Azure Database Certifications</li><li>AWS Database Specialty Certification</li><li>MongoDB Certified Developer/DBA</li><li>Cloud or DevOps-related certifications</li></ul><p><br></p><p>Key Responsibilities</p><p>Database Design & Development</p><ul><li>Design, develop, and maintain scalable relational and non-relational database architectures for enterprise and analytical systems.</li><li>Develop optimized data models, database schemas, entity-relationship diagrams (ERDs), and normalization strategies.</li><li>Implement and manage PostgreSQL/PostGIS, Oracle, MySQL, MongoDB, and other database technologies based on business requirements.</li><li>Define and implement effective indexing, partitioning, and storage strategies for high-performance data access.</li></ul><p>Data Integration & ETL</p><ul><li>Design and support robust data ingestion pipelines from:<ul><li>Remote sensing platforms</li><li>Satellite data sources</li><li>IoT systems</li><li>Enterprise applications</li><li>External APIs</li></ul></li><li>Develop ETL/ELT workflows for data transformation, validation, and integration.</li><li>Create stored procedures, triggers, functions, views, and automation scripts to improve operational efficiency and data consistency.</li></ul><p>Performance Optimization</p><ul><li>Monitor database health and conduct proactive performance tuning.</li><li>Analyze query execution plans and optimize SQL workloads for performance and scalability.</li><li>Implement partitioning, replication, caching, and indexing mechanisms for large datasets.</li><li>Optimize spatial queries, geometry processing, and location-based analytics.</li></ul><p>Geospatial Data Management</p><ul><li>Manage spatial and non-spatial datasets within enterprise GIS environments.</li><li>Maintain metadata repositories and data catalogs adhering to OGC and ISO standards.</li><li>Support geospatial interoperability through APIs, web services, and GIS platforms.</li><li>Enable efficient integration with web, mobile, and enterprise GIS applications.</li></ul><p>Security, Availability & Governance</p><ul><li>Implement role-based access control (RBAC), authentication, authorization, and data security policies.</li><li>Design and maintain backup, recovery, replication, and high-availability solutions.</li><li>Support disaster recovery planning and business continuity requirements.</li><li>Apply security patches, upgrades, and vulnerability remediation activities.</li><li>Conduct database audits and ensure compliance with organizational and regulatory requirements.</li></ul><p>DevOps & Cloud Operations</p><ul><li>Support cloud-native database deployments and hybrid infrastructure environments.</li><li>Collaborate with DevOps teams on CI/CD-enabled database deployment processes.</li><li>Implement database monitoring, logging, and alerting solutions.</li><li>Participate in infrastructure automation and containerized database deployments.</li></ul><p>Support & Collaboration</p><ul><li>Provide Level 2/Level 3 technical support for database-related incidents and performance issues.</li><li>Collaborate with application developers, data engineers, GIS specialists, and solution architects to implement robust data solutions.</li><li>Prepare technical documentation, standards, and operating procedures.</li><li>Mentor junior team members and contribute to database best practices across the organization.</li></ul><div><hr></div><p>Required Technical Skills</p><p>Database Technologies</p><ul><li>PostgreSQL/PostGIS</li><li>Oracle Database</li><li>MySQL</li><li>MongoDB</li><li>Cassandra</li></ul><p>Programming & Scripting</p><ul><li>SQL/PL-SQL</li><li>Python</li><li>R</li><li>Shell Scripting</li></ul><p>Cloud Platforms</p><ul><li>AWS RDS/Aurora</li><li>Azure SQL Database</li><li>Google Cloud SQL</li></ul><p>Data Engineering</p><ul><li>ETL/ELT Frameworks</li><li>Data Warehousing</li><li>API Integration</li><li>Workflow Automation</li></ul><p>DevOps & Infrastructure</p><ul><li>Docker</li><li>Kubernetes</li><li>CI/CD Pipelines</li><li>Git</li></ul><p>GIS & Spatial Technologies</p><ul><li>PostGIS</li><li>Geospatial Data Management</li><li>OGC Standards</li><li>Spatial Indexing</li><li>Coordinate Reference Systems (CRS)</li></ul><div><br></div><div><br></div>