Data Architect & DBA: Modernize & Optimize Large-Scale DBs

Ninth Wave, Inc.; New York (NY); On-site; USD 130,000 - 180,000; Full time

Job summary

Ninth Wave, Inc. is seeking an experienced Data Architect / DBA in New York State to reverse engineer complex database environments and modernize them for performance and scalability.

You will analyze undocumented schemas, infer business logic, reconstruct ER models, and design robust architectures. Fluency with Java services and ORM mappings will help you align data with application behavior. This on-site role emphasizes in-depth data optimization and reliability.

Qualifications

• 5+ years of experience in database administration, data architecture, or related roles.
• Strong expertise in relational database design, SQL optimization, and performance tuning.
• RDS experience with MS SQL Server or similar DBMS platforms.
• Proven experience reverse engineering undocumented databases and legacy systems.
• Deep understanding of ER modeling, normalization, indexing, and join optimization.
• Ability to infer business logic from schemas, data, and application behavior.
• Read-level Java proficiency with the ability to understand: Spring / Spring Boot, Hibernate / JPA, JDBC, Service-layer database interactions.

Responsibilities

• 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, migration plans, and architecture recommendations.
• Collaborate with engineering and infrastructure teams on database and application performance improvements.

Skills

Relational DB design

SQL optimization

Performance tuning

Reverse engineering

ER modeling

Java proficiency

Spring / Spring Boot

Hibernate / JPA

JDBC

Service-layer DB interactions

RDS experience

Tools

SQL Server

AWS RDS

CI/CD

Monitoring tools

Job description

Ninth Wave, Inc. is seeking an experienced Data Architect / DBA in New York State to reverse engineer complex database environments and modernize them for performance and scalability.

You will analyze undocumented schemas, infer business logic, reconstruct ER models, and design robust architectures. Fluency with Java services and ORM mappings will help you align data with application behavior. This on-site role emphasizes in-depth data optimization and reliability.