Description

You will reverse engineer, optimize, and maintain enterprise database architectures and application data layers.

This role is on-site.

Responsibilities

• Reverse engineer legacy database schemas, including tables, indexes, constraints, views, stored procedures, and triggers.
• Analyze production data to identify entities, relationships, cardinality, and usage patterns for logical and physical ER modeling.
• Read and analyze Java application code to understand database access patterns, ORM mappings, and transaction logic.
• Redesign schemas for efficient joins, query optimization, scalability, and data integrity.
• Administer enterprise databases, handling backup/recovery, replication, HA/DR, security, and migrations.

Required Skills

• 5+ years of experience in database administration, data architecture, or related roles.
• Strong expertise in relational database design, SQL optimization, and performance tuning.
• Proven experience reverse engineering undocumented databases and legacy systems.
• Deep understanding of ER modeling, normalization, indexing, and join optimization.
• Read-level Java proficiency with Spring/Spring Boot, Hibernate/JPA, and JDBC.
• Experience with SQL Server, AWS RDS, or similar DBMS platforms.

Preferred Skills

• Familiarity with schema versioning, CI/CD, cloud database platforms, and monitoring tools.

Key Skills

Education

Bachelor's degree