Company Description
At i360technologies, we help our employees succeed. Competitive pay, robust benefits for full-time employees, and professional development opportunities are a few reasons that i360 is a great place to build your career. Founded in 1999, i360 is a growing GOVCON professional services company looking for motivated individuals excited to embrace a fast-paced environment while applying strategic problem-solving skills, excellent work ethic, and positive energy to an already first-class team. You have a home with us if you enjoy solving complex business problems through business consulting and technology implementation. At i360, we offer unlimited professional growth and career possibilities.
Job Description
We are seeking an experienced COBOL to PostgreSQL Migration Specialist to lead and execute the transition of a COBOL-based application to a PostgreSQL environment. This role requires expertise in COBOL programming, database migration, and SQL transformation, ensuring a smooth transition while maintaining data integrity and system performance.
Responsibilities
- Analyze COBOL Code. Review and understand existing COBOL programs, including embedded SQL statements and data structures.
- Develop an equivalent PostgreSQL schema that accurately represents the COBOL data structures.
- Map COBOL data types (e.g., PIC 9(5)) to appropriate PostgreSQL types (e.g., INTEGER, NUMERIC) while considering precision and scale.
- Rewrite COBOL-embedded SQL statements to conform with PostgreSQL syntax for SELECT, INSERT, UPDATE, and DELETE operations.
- Convert intricate COBOL data structures like REDEFINES and nested records into PostgreSQL tables or use JSON types where appropriate.
- Implement best practices for query optimization and indexing in PostgreSQL.
- Conduct thorough testing to ensure data accuracy and system functionality after conversion.
- Leverage COBOL modernization tools and database migration utilities to streamline the transition process.
- Work closely with stakeholders to gather requirements, provide updates, and document the entire migration process.
Qualifications
Required Qualifications:
- Bachelor’s degree in computer science, Information Technology, or a related field.
- 5+ years of experience in COBOL development and database migrations.
- Hands-on experience with PostgreSQL database architecture, SQL scripting, and performance tuning.
- Strong understanding of COBOL data structures, REDEFINES, and file handling mechanisms.
- Proficiency in SQL conversion from COBOL-embedded SQL to PostgreSQL.
- Experience using database migration tools and COBOL modernization frameworks.
- Knowledge of data integrity principles and relational database normalization.
- Strong problem-solving and analytical skills.
- Excellent communication and documentation skills.
- Demonstrated excellent customer service skills.
- Strong communication, presentation, analytical, and technical skills.
- Proficient in Microsoft Word, Power Point, and Excel.
- Demonstrated ability to work independently with minimal supervision.
- Must be able to clear a federal background investigation - Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information.
- Must be a US Citizen or have a Green Card.
- Workdays: Monday-Friday.
Preferred Qualifications:
- Experience working in government or federal healthcare projects.
- Familiarity with PostgreSQL JSON data types for handling complex structures.
- Knowledge of middleware tools for facilitating COBOL to PostgreSQL integration.
- Prior experience in performance optimization of legacy application migrations.
Additional Information
i360 is an Equal Opportunity Employer - Minority/Female/Veteran/Disability
All qualified applicants will receive consideration for employment regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or status within any other protected group.
Benefits
- Referral Bonus
- (401k) Matching
- Holidays – Eleven
- Adoption Assistance
- Tuition Reimbursement
- Technology Reimbursement
- Short-Term & Long-Term Disability
- Life Insurance (Basic, Voluntary & AD&D)
- Health Care Plan (Medical, Dental & Vision)
- Paid Time Off (0-3 years - 15 Days PTO | 3+ years 20 Days)
- Perks at Work – Employee perks program that helps you live a better and healthier life.
Only Direct Hires - No recruiting or staffing firms’ submissions will be considered.
Similar Jobs
What We Do
Headquartered in Leesburg, VA, i360 has been providing Oracle Application and Technology implementation, integration and support services to the federal government since 2001. We perform Oracle Enterprise Solution implementations, upgrades, project management, and on-going application enhancements and support. Our senior level functional, technical, strategy, change management, and PMO consultants work in a collaborative environment with our customers and their contractors to deliver results on time and on budget. Because we focus on Oracle applications and technologies, we have a depth of Oracle resources and experience that would typically be found at much larger companies. i360 is a certified small business. Our key customers receive the full attention of our top management. We respond rapidly and flexibly to meet our customers’ needs and address any issues as they arise.
