12 Aug
|
Cambridge Technology
|
Hyderabad
12 Aug
Cambridge Technology
Hyderabad
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
Solid 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)
📌 Senior Database Engineer (Hyderabad)
🏢 Cambridge Technology
📍 Hyderabad