Visionary Innovative Technology Solutions LLC · 1 day ago
Remote: Senior Database Architect - Migration Specialist
United States
Contract
Remote
Senior Level
7+ years exp
Maximize your interview chancesConsultingStaffing Agency
Hiring Manager
Anuj Chaudhary
Insider Connection @Visionary Innovative Technology Solutions LLC
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Lead the design, planning, and execution of database migrations from on-premises or other cloud environments to GCP.
Assess current database environments and create comprehensive migration strategies, including analysis of application dependencies, downtime requirements, and risk mitigation.
Utilize tools such as Google Database Migration Service, Cloud Data Fusion, and third-party solutions to facilitate seamless migrations while ensuring data integrity and minimal disruption.
Design and implement scalable database architectures using GCP’s managed database services, such as Cloud SQL, BigQuery, Cloud Spanner, Firestore, and Cloud Datastore.
Optimize database performance through schema design, indexing, partitioning, sharding, and query optimization techniques tailored for cloud environments.
Architect database solutions that ensure high availability, disaster recovery, and data replication across GCP regions.
Manage and administer databases deployed on GCP services, monitoring performance using tools like Cloud Monitoring, Cloud Logging, and third-party solutions.
Implement and maintain automated backups, disaster recovery plans, and security protocols to safeguard database environments.
Collaborate with cloud engineers and DevOps teams to automate database deployments and configuration management using tools like Terraform and Google Cloud Deployment Manager.
Work closely with application development, data engineering, and IT operations teams to align database solutions with business requirements.
Communicate complex technical concepts to both technical and non-technical stakeholders, providing guidance on best practices for database architecture and migration.
Collaborate with external vendors, consultants, and partners to ensure successful project delivery and integration of advanced database solutions.
Implement data security best practices, including encryption, identity access management (IAM), and network security configurations to protect sensitive data.
Ensure compliance with industry regulations (e.g., GDPR, HIPAA) and organizational policies throughout the migration and implementation processes.
Establish data governance policies and manage access controls to secure database environments and maintain data integrity.
Document database architecture, migration processes, and best practices to create reusable playbooks for future projects.
Stay up-to-date with GCP database services, new features, and best practices to continually enhance the database architecture and migration processes.
Identify opportunities for automation and improvement in existing processes to increase efficiency and reduce manual efforts.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor’s degree in Computer Science, Information Technology, Data Engineering, or a related field.
7+ years of experience in database architecture and management, with 3+ years of hands-on experience specifically with database migration projects to GCP.
Strong expertise in GCP database services such as Cloud SQL (MySQL, PostgreSQL, SQL Server), BigQuery, Cloud Spanner, Firestore, and Cloud Datastore.
Proven experience in using migration tools like Google Database Migration Service, Cloud Data Fusion, or third-party solutions such as Striim or Datastream.
In-depth knowledge of database management systems (DBMS) like Oracle, MySQL, PostgreSQL, SQL Server, and NoSQL databases.
Demonstrated skills in designing and optimizing cloud-native database architectures, ensuring performance, scalability, and security.
Familiarity with Infrastructure as Code (IaC) tools such as Terraform and Google Cloud Deployment Manager for automating database deployments and configurations.
Experience with database performance tuning, backup and restore procedures, disaster recovery, and security best practices in cloud environments.
Preferred
GCP certifications such as Professional Data Engineer or Professional Cloud Architect.
Experience with multi-cloud and hybrid cloud database migration strategies and implementations.
Familiarity with Kubernetes and containerized database management (e.g., deploying databases within GKE clusters).
Experience in data governance, compliance frameworks, and implementing database policies to ensure adherence to regulatory standards.
Knowledge of big data and real-time processing technologies, such as Apache Beam, Cloud Dataflow, or Apache Kafka.
Company
Visionary Innovative Technology Solutions LLC
Visionary Innovative Technology Solutions LLC (VITS) has been founded on the principle of partnering with our clients - to provide a smarter way of working.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase
