Senior Database Modeler /Developer

Job Title: Senior Database Modeler /Developer

Job Location: Pennington, NJ / Plano, TX / Charlotte, NC (3 Days onsite, 2 Days Remote)

Job Type: 18+ Months contract

Job Details:

• We are seeking a highly skilled Senior Database Modeler /Developer to support enterprise application development, data integration, modernization, and cloud transformation initiatives. This role will be responsible for designing and maintaining logical and physical data models, developing high-performance database solutions, and ensuring data integrity, scalability, and security across mission-critical applications.
• The ideal candidate will possess strong expertise in Oracle and PostgreSQL database technologies, advanced SQL and PL/SQL development, data modeling best practices, and database performance optimization. The resource will work closely with business analysts, application developers, architects, and infrastructure teams to translate business requirements into efficient, scalable, and maintainable database solutions.
• This position requires hands-on experience with database design, data migration, ETL/integration processes, and cloud-based database platforms. The successful candidate will contribute to enterprise data architecture initiatives, support application modernization efforts, and provide technical leadership in database-related design and development activities.
• The role demands strong analytical and problem-solving skills, the ability to work in an Agile environment, and a commitment to delivering high-quality, well-documented solutions that align with enterprise standards and best practices.Data ModelingDesign and maintain conceptual, logical, and physical data models.
• Define entities, relationships, keys, constraints, and data standards.
• Create and maintain ER diagrams and data dictionaries.
• Support data governance and metadata management initiatives.
• Review application requirements and translate them into data models.
• Database Development Design and develop database schemas, tables, views, indexes, stored procedures, functions, packages, and triggers.
• Develop complex SQL queries and performance-optimized database solutions.
• Perform data validation, reconciliation, and data quality assessments.
• Support application development teams with database design and implementation.
• 8+ years of database development experience.
• 5+ years of data modeling experience.
• Experience supporting large enterprise applications.
• Experience working in Agile delivery environments.

Technical Skills

• • Database Technologies
  • Oracle 12c/19c or higher
  • PostgreSQL
  • SQL Server (preferred)
  • Data Modeling Tools Erwin
  • ER/Studio
  • SQL Developer Data Modeler
  • Other enterprise modeling tools
  • Development Skills
  • Advanced SQL
  • PL/SQL
  • Stored Procedures
  • Functions
  • Triggers
  • Packages
  • Banking or Financial Services experience.

Experience with:

• MongoDB
• Kafka
• REST APIs
• Data Warehousing
• Data Lakes
• Understanding of KYC, AML, Client Onboarding, or regulatory applications.
• Experience supporting cloud migration programs.