Data Architect

Lead the modernization of legacy transactional database systems, including upgrade, migration, and decommissioning activities.

Design resilient, secure, and scalable database architectures to support high-volume transactional workloads.

Ensure compliance with organizational standards, governance policies, and data security regulations.

Plan and manage the full lifecycle of database systems, including upgrades, migrations, and retirements.

Align all database modernization efforts with data retention, archiving, and compliance requirements.

Create detailed documentation for database architecture, data models, and operational processes.

Define and promote best practices for database development, maintenance, and administration.

Design and oversee integration between transactional databases and enterprise systems or applications.

Define and implement real-time data ingestion and consumption patterns for consistent data flow.

Establish and enforce governance policies for data quality, retention, and lifecycle management.

Implement strong database security measures, including encryption, access controls, and auditing.

Identify and resolve performance bottlenecks and optimize database performance.

Develop strategies for database scalability using techniques such as sharding, clustering, and connection pooling.

Evaluate and recommend appropriate relational database technologies such as MySQL, Oracle, or PostgreSQL based on business needs.

Design high-availability architectures with disaster recovery, data replication, and failover capabilities.

Develop conceptual, logical, and physical data models ensuring normalization and referential integrity.

Optimize schema design through indexing strategies, data type selection, and selective denormalization.

Collaborate with application and infrastructure teams to ensure smooth database integration and performance.

Maintain data consistency and reliability across multiple systems and environments.

Ensure compliance with organizational and regulatory data governance standards.

Monitor database health and implement proactive measures to prevent downtime or performance degradation.

Automate database maintenance tasks and deployments using appropriate tools and scripts.

Provide technical guidance and mentorship to development and operations teams on database best practices.

Communicate complex technical concepts clearly to both technical and non-technical stakeholders.

Stay current with emerging database technologies and recommend improvements for continuous modernization.