04 Nov
|
CAMBRIDGE TECHNOLOGY ENTERPRISES (CTE)
|
Hyderabad
04 Nov
CAMBRIDGE TECHNOLOGY ENTERPRISES (CTE)
Hyderabad
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 Qualified - 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 - 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. 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. - 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. - 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 - Coord
📌 Senior Database Engineer (Hyderabad)
🏢 CAMBRIDGE TECHNOLOGY ENTERPRISES (CTE)
📍 Hyderabad