Freelance Senior Applications Developer – Data Modeling, On-Prem To Gcp Migration, Alloy Db

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. Our proactive approach ensures continuous monitoring and testing to identify vulnerabilities before they can be exploited. With a mission to deliver high-quality services, ThreatXIntel empowers businesses of all sizes to safeguard their digital assets effectively. Our team fosters peace of mind, allowing clients to focus on achieving their growth goals. Role Description 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. - Technical Documentation : Create and maintain comprehensive documentation for data models, migration processes, database architecture, and performance tuning. - Collaboration : Work with cross-functional teams to ensure smooth communication between infrastructure, security, and application teams during the migration process. - Emerging Technologies : 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