Freelance Senior Applications Developer

Company Description ThreatXIntel is a startup cyber security company dedicated to protecting businesses and organizations from evolving cyber threats. We specialize in providing tailored, cost-effective solutions in areas such as cloud security, web and mobile security testing, DevSecOps, and more. With a mission to deliver high-quality services, ThreatXIntel empowers businesses of all sizes to safeguard their digital assets effectively. We are seeking an experienced Senior Applications Developer with deep expertise in data modeling , Alloy DB , and on-premises to GCP migration to help design and implement robust database solutions for enterprise applications. The role requires a hands-on engineer who can manage data migration strategies, optimize database performance, and ensure a smooth transition of on-prem databases to Google Cloud Platform (GCP) . The ideal candidate will also contribute to the architecture, design, and continuous improvement of cloud-native solutions. Key Responsibilities • Data Modeling and Design : Design and optimize Alloy DB and cloud-native data models for complex enterprise systems, ensuring scalability, reliability, and optimal performance. • On-prem to GCP Migration : Lead migration efforts for transitioning on-premises databases to Google Cloud services, specifically Alloy DB and related tools (BigQuery, Pub/Sub, Dataflow). • Performance Tuning and Optimization : Identify and resolve performance bottlenecks in Alloy DB and optimize queries, indexing, and storage utilization in cloud environments. • Database Integration : Integrate Alloy DB with GCP services like BigQuery , Pub/Sub , and Dataflow , ensuring smooth data flow and architecture alignment. • Data Migration Strategy : Develop strategies for data migration from on-prem databases to GCP , including data validation, integrity checks, and rollback strategies. • Create and maintain comprehensive documentation for data models, migration processes, database architecture, and performance tuning. • Stay up-to-date with industry trends, especially cloud-native solutions, and propose new technologies to improve data architecture and cloud services. Required Skills and Experience • 7+ years of experience in database engineering , with hands-on expertise in Alloy DB , PostgreSQL , and cloud-native data solutions • 3+ years of experience in data migration from on-premises to Google Cloud Platform (GCP) , particularly involving Alloy DB and BigQuery • Strong understanding of data modeling , relational databases , and cloud-based data architectures • Experience in performance tuning and optimizing database queries for cloud databases • Deep knowledge of GCP services , particularly BigQuery , Pub/Sub , and Dataflow , and their integration with Alloy DB • Hands-on experience with data migration strategies , data validation , and testing for cloud migrations • Familiarity with cloud security best practices for database management and data transfers • Excellent problem-solving skills and the ability to troubleshoot complex database and migration issues • Ability to create clear and concise technical documentation , including database designs and migration plans Nice to Have • Experience with cloud-native data pipelines and ETL workflows in GCP • Familiarity with disaster recovery strategies for cloud databases • Experience with containerization (e.g., Docker, Kubernetes) for cloud database management • Knowledge of multi-cloud or hybrid cloud architectures • Experience with automated testing and CI/CD pipelines for database applications