Expert Technology Consultant

Ensono - Augusta, ME

Full-time - Mid Level

Remote - Augusta, ME

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

About the position

The Expert Technology Consultant at Ensono is responsible for leading the modernization and migration of mainframe databases to cloud environments. This role involves developing data models, designing database structures, and collaborating with application architects to ensure successful data migration. The consultant will leverage their expertise in data modeling and database design to support clients in achieving their business outcomes through innovative technology solutions.

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