Cloud Data Architect

Role Overview

• Architecting and developing cloud database infrastructure and support the migration of legacy systems to the cloud
• Translating high-level requirements into data storage solutions
• Creating PoCs and/or prototypes to evaluate various cloud database technologies
• Architecting and implementing cloud-based database solutions on various platforms
• Developing and supporting a migration plan from legacy on-premises database to multi-cloud/hybrid cloud platforms
• Leading the design and implementation of secure, scalable, and high-performing database architectures across cloud-native, hybrid, and multi-cloud environments
• Providing expert-level guidance for migrating legacy workloads to commercial cloud platforms
• Developing Architecture Design Documents that reflect best practices aligned with the Government’s selected Cloud Service Providers
• Working closely with enterprise teams to shape database standards, assess return on investment, and recommend cost-effective, performance-optimized solutions
• Supporting both strategic and operational activities, including configuring cloud databases, enabling diagnostics, optimizing performance, and implementing threat-driven security settings
• Monitoring database usage, addressing replication strategies, and advising on anticipated growth to inform resource planning
• Provisioning relational databases, managing server-level operations such as scaling, restoring, or deleting instances, and configuring geo-replication and monitoring metrics
• Ensuring robust data management and supports CMSO’s efforts to build resilient, secure, and future-ready database infrastructure

Requirements

• 10 + years of related experience
• US Citizenship Required: No
• Experience designing and implementing a high-availability mission critical system with zero down time
• Experience architecting Azure, AWS, GCP, OCI cloud platform
• Experience data modeling a large multi-tenant database system
• Experience with relational (SQL) and non-relational (NoSQL) database technologies
• Knowledge of Data Bricks, Snowflake and other cloud offering
• Hands on experience with scaling databases to the needs of the customer while maintaining data boundaries
• Data migration experience from distributed to single database
• Installing and maintaining the performance of database servers
• Developing processes for optimizing database security
• Setting and maintaining database standards
• Managing database access
• Managing performance tuning of database systems
• Installing, upgrading, and managing database applications
• Performing installation and maintenance of data into primary and third-party applications
• Provide technical support and training for team members
• Performing feasibility studies, cost/benefit analysis, and user training in response to user requests
• Performing team leader functions for projects involving multiple parties: managing deadlines; providing status reports; facilitating final testing and project sign-off as needed
• Backing up local databases and file directories applications
• Diagnosing and troubleshooting database errors
• Recommending and implementing emerging database technologies
• Creating and managing database reports, visualizations, and dashboards
• Creating automation for repeating database tasks
• Assisting with SSL cert installation & troubleshooting
• Perform complete database environment installation, configuration, on-going administration support (IBM Informix, DB2, Microsoft SQL Server, MySQL, Oracle)
• Non-relational DB experience Cloud DB solutions like (DynamoDB, CosmosDB, GraphDB, DocumentDB etc.)

Tech Stack

• AWS
• Azure
• Cloud
• DynamoDB
• Google Cloud Platform
• MS SQL Server
• MySQL
• NoSQL
• Oracle
• SQL

Benefits

• variety of medical plan options, some with Health Savings Accounts
• dental plan options
• vision plan
• 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match
• full flex work weeks where possible
• variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave
• provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year
• Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees
• short and long-term disability benefits
• life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance