Cloud Data Architect

CLOUD DATA ARCHITECT

Req

Type of Requisition:
Regular

Clearance Level Must Be Able to Obtain:
None

Public Trust/Other

Required:

None

Job Family:
Data Science and Data Engineering

Skills:

Database Architecture, Database Environments, Database Technologies, Data Management, Data Storage

Experience:

10+ years of related experience

• Continuously analyze, monitor and optimize database and database query performance to improve responsiveness, scalability and cost efficiency across the full service to meet the functional and non-functional requirements.
• Implement automated performance tuning, query optimization, and indexing strategies. Provide regular performance assessments and recommendations for improvements.
• Lead the design and implementation of multi-tenant, cloud-based data architectures, supporting both cloud and hybrid/on-premises solutions using distributed architectures. Accommodate a range of database technologies, including SQL, No
  
  SQL, IaaS and PaaS, and emerging database paradigms (distributed SQL Multi-Modal SQL, Event-Driven or Streaming databases), based on workload requirements. Ensure logical and physical data isolation, tenant-level security, and resource allocation controls in multi-tenant environments. Design for portability and interoperability across cloud providers.
• Implement comprehensive data lifecycle management, including automated archival retention and purging strategies as well as robust backup/restore solutions tailored for cloud ecosystems.
• Ensure backup and archival processes are policy-driven, encrypted, and compliant with organizational and regulatory requirements. Provide data migration services from on-premises legacy databases to case management cloud databases where required.
• Minimize downtime and data loss through automated, repeatable and verifiable migration processes.
• Ensure data integrity, confidentiality, and security throughout all phases of the database lifecycle, including migration, storage, and access.
• Implement robust access controls, encryption (at rest and in transit), audit logging, and compliance reporting. Support data masking and anonymization.
• Employ comprehensive observability practices including real-time logging, monitoring, alerting, and automated incident response for all database environments.
• Integrate with enterprise monitoring and SIEM systems. Provide dashboards and regular reports on database health, performance, and incidents.
• Maintain detailed version-controlled documentation of data architectures, data models, performance metrics, operational runbooks, and progress reports.
• Implement explicit design and testing of DR and high availability strategies, including automated failover and regular DR drills.
• Implement ongoing analysis and recommendations for database cost optimization, including right-sizing, reserved capacity, and serverless options where appropriate.
• Ensure all database solutions comply with relevant data protection, privacy, and retention regulations.
• Implement use of IaC for database provisioning, configuration, and management to ensure consistency, repeatability, and auditability.
• Provide self-service, automated backup and restore mechanism, with policy-driven scheduling and retention.
• Provide capability to manage data in multiple formats (e.g., object, tabular, etc.), ensuring secure handling and compliance.
• Provide an automated and recurring (i.e., in regular intervals) backup of all images, code, and artifacts.
• Automate scaling of databases through policy-driven triggers and continuous monitoring.
• Automate intelligent data tiering policies for automatically migrating data based on access frequency, or age, for cost savings.
• Ensure continuous backup validation for a period as specified by the Government.

• 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 (No
  
  SQL) 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…