Expert Technology Consultant (Modernization Database Architect)
At Ensono, our Purpose is to be a relentless ally, disrupting the status quo and unleashing our clients to Do Great Things! We enable our clients to achieve key business outcomes that reshape how our world runs. As an expert technology adviser and managed service provider with cross-platform certifications, Ensono empowers our clients to keep up with continuous change and embrace innovation. We can Do Great Things because we have great Associates. The Ensono Core Values unify our diverse talents and are woven into how we do business. These five traits are the key to achieving our purpose.
HONESTY, RELIABILITY, COLLABORATION, CURIOSITY, PASSION
Role Summary:
Want more jobs like this?
Get Software Engineering jobs that are Remote delivered to your inbox every week.
As the Modernization Database Architect, (Mainframe to cloud Data Architect) you will be responsible for designing and overseeing the migration of data from legacy mainframe systems to modern cloud-based platforms. This role involves working as part of a Project Architecture team, Center of Excellence, and collaborating with client DBAs to understand their current data structures. Additionally, you will create new data models and develop the necessary extract, transform, and load (ETL) processes to ensure a seamless transition.
What You Will Do:
- 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).
What You Will Need:
- 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.
Preferred Skills:
- 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.
Experience That Will Set You Apart:
- Master's degree in computer science or information science/technology
- Experience with Legacy Mainframe databases such as IMS, IDMS, Datacom or Adabas
Why Ensono?
Ensono is a place where we unleash Associates to Do Great Things - for our clients and for your career. This could mean achieving a professional goal, collaborating with your team on an innovative idea, learning a new skill, reaching a wellness milestone, or engaging in your community through volunteer programs. Whatever it means to you, we want Ensono to be the place where you can do remarkable things.
We value flexibility and work-life balance. Positions that are not required to be onsite to support a client may offer the ability to work remotely or hybrid at an Ensono office location.
- Unlimited Paid Day Off (PDO) Plan
- Two robust health plan options through Blue Cross Blue Shield
- 401(k) with a generous 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
Ensono is an Equal Opportunity/Affirmative Action employer. We are committed to providing equal employment to our Associates and building a diverse and inclusive workforce. All qualified applicants will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or other legally protected basis, in accordance with applicable law.
Pay transparency nondiscrimination statement/posting OFCCP's pay transparency policy can be found on OFCCP's website.
If you need accommodation at any point during the application or interview process, please let your recruiter know or email [email protected].
JR010036