Note: The job is a remote job and is open to candidates in USA. Dexian is a talent and technology solutions company that connects professionals and technology with organizations. The company is seeking a Database Engineer to develop, maintain, modernize, and optimize enterprise database applications using dynamic SQL, stored procedures, and related data technologies. The role also involves API integration, application development, version control, and collaboration on enterprise data projects.
Responsibilities
- Develop and maintain various database applications on the platform, utilizing dynamic SQL
- Convert RPG code to SQL stored procedures and perform performance tuning
- Implement logging and exception handling to ensure robust application operation
- Read and interpret RPGIV, RPGLE, RPGFree programs, along with embedded SQL
- Modernize existing RPG applications by converting them to SQL stored procedures within the database
- Collaborate using internal tools and frameworks for version control and deployment
- Interact with front-end systems through REST APIs and JSON data formats
- Contribute to application development projects, including exposure to Python, microservices, and development in the Visual Studio Code IDE
- Use version control systems to manage code changes and enable team collaboration
Skills
- Proven experience developing and maintaining database applications, particularly on the platform with dynamic SQL
- Strong expertise in SQL stored procedures, with significant development experience in the specified database environment
- Ability to read and understand RPGIV, RPGLE, RPGFree programs, and embedded SQL
- Experience in converting and modernizing RPG applications into SQL stored procedures
- Familiarity with enterprise tools such as source control and deployment frameworks
- Demonstrated application development interaction with front-end systems using REST APIs and JSON
- Exposure to Python programming, microservice architecture, and IDE development in Visual Studio Code
- Proficiency in using source control systems like Git
- Experience with enterprise tools such as Aldon, RDI, or ACS
- Background in performance tuning and exception handling for database applications
- Knowledge of internal version control and deployment methodologies
- Prior experience working in a collaborative team environment on enterprise data projects
Company Overview
Company H1B Sponsorship