Expert Technology Consultant

Ensono - Raleigh, NC

Full-time - Mid Level

Remote - Raleigh, NC

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

The Expert Technology Consultant at Ensono plays a crucial role in guiding clients through the modernization of their mainframe databases to cloud-based solutions. This position involves developing data models, designing database structures, and collaborating with application architects to ensure successful data migration and implementation of best practices in database design.

Responsibilities

• Develop conceptual, logical, and physical data models for mainframe database migration and modernization process.
• Design and implement database structures and mainframe unload and load programs for cloud databases, including tables, indexes, constraints, and relationships.
• Learn and apply the technical architecture of Ensono's mainframe modernization tools (Universal Data Converter) using ability in various source and target databases.
• Convert mainframe databases and data models to modern database architectures.
• Collaborate with application architects and other database architects to customize and change data models, databases, and code, focusing on database migration.
• Build conceptual, logical, and physical data models for databases modernization.
• Document data requirements and relationships (data modeling) and create efficient database structures (database design).

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience in data modeling and database design, particularly with IBM Mainframe DB2 and Azure SQL.
• Strong understanding of data modeling principles and database design best practices.
• Excellent critical thinking skills and attention to detail plus strong communication skills.

Nice-to-haves

• Experience with mainframe to cloud data migration projects.
• Knowledge of Azure cloud services and tools.
• 9-12 years of combined related experience with:
• 3-4 years of Mainframe database experience - VSAM, DB2 etc.
• 3-4 years of full stack development. Linux, Windows
• 3-4 years of programming in a combination of COBOL, Java and C#
• Ability to self-learn new languages and legacy database management systems.

Benefits

• Unlimited Paid Days Off
• Two health plan options through Blue Cross Blue Shield
• 401k with company match
• Eligibility for dental, vision, short and long-term disability, life and AD&D coverage, and flexible spending accounts
• Depending on location, ability to take advantage of fitness centers
• Wellness program
• Flexible work schedule