Description

Key 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, and schema maintenance behavior.
• Redesign schemas and data models for efficient joins, query optimization, scalability, data integrity, and 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.

Required Qualifications:

• 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.
• 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, and 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

Key Skills

Education

Bachelor's degree