The role involves reverse engineering and optimizing complex database environments, analyzing database schemas, designing data models for efficiency, and administering enterprise databases.
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. 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.
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
- 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.
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.
- RDS experience
- 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
- 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.
- Detail-oriented with a focus on performance and scalability.
- Effective communicator capable of translating technical findings into actionable architecture improvements.
Ninth Wave New York, New York, USA Office
115 Broadway, New York, NY, United States, 10006
Similar Jobs
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Own global mobility and immigration programs, including case management, policy administration, compliance, vendor coordination, employee support, and process optimization. Partner with HR, Recruiting, Legal, and external providers to improve workflows using AI and automation. The role also supports benefits and leave-of-absence coordination while developing broader expertise in Total Rewards.
Top Skills:
AIAutomation
Financial Services
Manage counterparty credit risk across derivatives, securities financing, prime services, and related products. Perform margin investigations, collateral liquidity analysis, regulatory reviews, and ISDA CSA negotiations. Develop Python-based automation and analytical tools using SQL, Tableau, Alteryx, ThoughtSpot, and AI/LLM techniques. Drive transformation initiatives, strengthen controls, improve data quality, support governance and audit requirements, and collaborate with Quantitative Research, Technology, Product, and Credit Officers.
Top Skills:
Ai/LlmAlteryxExcelPythonSQLTableauThoughtspot
AdTech • Big Data • Cloud • Marketing Tech • Software • Analytics
Leads B2B demand generation, field marketing, event execution, HubSpot campaign automation, lead nurturing, segmentation, reporting, social media, and copywriting. Manages vendors, event logistics, lead capture, and cross-functional marketing workflows while using generative AI tools to automate processes, improve productivity, and analyze campaign data.
Top Skills:
AsanaCanvaChatgptClaudeFigmaGeminiHubspotLinkedInSalesforceSlackX
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
