Senior Database Engineer

• 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.

• 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.

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

• Design, develop, and maintain scalable relational and non-relational database architectures for enterprise and analytical systems.

• 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.

• 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.

• 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.

• Monitor database health and conduct proactive performance tuning.

• 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.

• Manage spatial and non-spatial datasets within enterprise GIS environments.

• 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.

• Implement role-based access control (RBAC), authentication, authorization, and data security policies.

• 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.

• Support cloud-native database deployments and hybrid infrastructure environments.

• 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.

• 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.

• PostgreSQL/PostGIS

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

• SQL/PL-SQL

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

• AWS RDS/Aurora

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

• ETL/ELT Frameworks

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

• Docker

• Docker
• Kubernetes
• CI/CD Pipelines
• Git

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