ninthwave

ninthwave

Data Architect/DBA

New York, New York · Full-time

Sponsorship not specifiedDetected 21 days ago
JavaSpringSQLAWSCI/CDProblem Solving

About the role

  • Seeking an experienced Data Architect / DBA to reverse engineer, optimize, and modernize complex database environments.
  • The role 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.

Responsibilities

  • Reconstruct logical and physical ER models and document current-state architectures.
  • Optimize SQL, execution plans, indexing, partitioning, and storage strategies.
  • Collaborate with engineering and infrastructure teams on database and application performance improvements.

Requirements

  • 5+ years of experience in database administration, data architecture, or related roles.
  • Proven experience reverse engineering undocumented databases and legacy systems.
  • Ability to infer business logic from schemas, data, and application behavior.
  • Read-level Java proficiency with the ability to understand:

Nice to have

  • Spring / Spring Boot
  • Service-layer database interactions
  • Experience with SQL Server, AWS RDS (Managed MS SQL Server) or similar DBMS platforms.
  • Familiarity with schema versioning, CI/CD, cloud database platforms, and monitoring tools preferred.
  • Strong analytical, investigative, and documentation skills.
  • Desired Attributes
  • Strong systems-thinking and problem-solving abilities.
  • Comfortable working independently with minimal documentation.

Skills

  • Database access patterns
  • ORM mappings
  • Transaction logic
  • Schema maintenance behavior

This listing is sourced directly from ninthwave's careers page and normalized into a canonical job model.