Data Architect/DBA

Data Architect / DBA Full Time Opportunity- 5 days in the office Position Summary Seeking an experienced Data Architect / DBA to reverse engineer, optimize, and modernize complex database environments.

requires the ability to analyze undocumented database instances, infer business logic from schema structures and production-representative data, reconstruct ER models, and redesign architectures for maximum query efficiency, scalability, and maintainability. Candidate must also be able to read and understand Java services that interact with and maintain the database schema, including ORM mappings and transactional behavior. Key

Reverse engineer database schemas, including tables, indexes, constraints, views, stored procedures, functions, and triggers. Analyze representative production data to identify entities, relationships, cardinality, workflows, and usage patterns. Reconstruct logical and physical ER models and document current-state architectures.

Read and analyze Java application/services code to understand: Database access patterns ORM mappings Transaction logic Schema maintenance behavior Redesign schemas and data models for: Efficient joins Query optimization Scalability Data integrity Maintainability Optimize SQL, execution plans, indexing, partitioning, and storage strategies. Administer enterprise databases including backup/recovery, replication, HA/DR, security, monitoring, upgrades, and migrations. Produce technical documentation, ERDs, m