Database Engineering Intern

Analyze data requirements for business applications and build conceptual model

Develop physical data model and data migration/conversion strategies for internally hosted applications.

Reference data maintenance

Work with business analyst to keep the reference data as per industry standard.

Troubleshoot production data issues

Identify and Cleanup of junk data.

Program and write SQL code

• Support the creation of tables, views, stored procedures, functions, reports and triggers.
• Develop and maintain complex stored procedures, views and functions on MariaDB, MySQL, DB2 AS400 and DB2 LUW databases.

Utilize software development principles and experience

• To support the full lifecycle of software products.
• Work with application teams to identify ways to optimize the database tier and work to implement improvements for future releases.

Desirable Skills

• Ability to be flexible and work well with changing priorities.
• Time management skills with ability to participate in multiple projects/work streams.
• Strong analytical/problem solving skills.
• A self-starter who thrives with minimal supervision.
• Ability to express yourself well, verbally and on email.
• Ability to work with all levels of staff, management and external vendors.
• Strong knowledge of Python Object Oriented Programming, design patterns, algorithms, and data structures.
• Knowledge on frameworks such as Flask / Django along with NumPy / pandas.
• Solid understanding of HTML and JavaScript.
• Designing, implementing and using REST APIs to orchestrate services in support of business requirements.
• Familiar with Git tool for source code control and continuous integration.
• Solid understanding of SQL.
• Fluent in Linux/UNIX shell and common commands.

Required Experience

• BS, BA in Computer Science, Computer Information Systems, MIS, or relevant technology degree.