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

performance tuning

and

optimizing database queries

for

cloud databases

GCP services , particularly

BigQuery ,

Pub / Sub , and

Dataflow , and their integration with

Alloy DB

data migration strategies ,

data validation , and

testing for cloud migrations

cloud security best practices

for database management and data transfers

problem-solving skills

and the ability to troubleshoot complex database and migration issues

technical documentation , including database designs and migration plans

Nice to Have

cloud-native data pipelines

and

ETL workflows

in GCP

disaster recovery

strategies for cloud databases

containerization

(e.g., Docker, Kubernetes) for cloud database management

multi-cloud

or

hybrid cloud architectures

automated testing

and

CI / CD pipelines

for database applications