100% Remote, must be in NY, NJ, CT
Must Have Needs:
Nice to have:
DUTIES & RESPONSIBILITIES
- Support database objects residing in Postgres & MySql databases.
- Design, create, modify and remove database objects (tables, views, indexes, keys, stored procedures, functions, DB links, etc.) to support development projects.
- Design, build, and maintain extract-transformation-load (ETL) processes.
- Implement and test database objects in non-production environments.
- Move supporting data between non-production environments.
- Work with Application Development Teams, Project, Testing and Release Managers, Architects and IT Management to support fixes, enhancements and projects.
- Assist other developers with SQL questions as needed.
- Performance review and tuning on pending, new and production database objects.
- Maintain database objects in a software version control system.
- Support Testing efforts from a database perspective.
- Data expert for migrating data from existing applications and database environments to new architecture.
- Work with IT resources to effectively integrate with database(s).
- May assist the Database Architect with:
- Design of enterprise data model and integration with business strategic & tactical goals.
- Design & implementation of Database policies and guidelines
- Security design.
- Periodic metric reports on the database environments.
- Performs other duties or special projects as required or assigned.
QUALIFICATIONS
- Bachelor's degree in computer science or other appropriate discipline plus 1 - 4 years of experience in database design, development or administration or Associate degree in related field and 5+ years of relevant data processing, systems analysis/design, and 2-3 years of experience developing/maintaining database objects in one of the database systems or a combination of education and experience from which comparable knowledge and skills are acquired.
- Hands-on database tuning and troubleshooting experience.
- Ability to communicate effectively, both verbally and in writing.
- Excellent math, research skills and analytical/problem solving skills.
- Excellent planning, organizational, and time management skills. Ability to multi-task and work on multiple project assignments while under pressure.
- Self-starter, able to work independently and in a team environment.
- Ability to deal effectively with a wide variety of other company personnel, including technical personnel from other disciplines, IT Management, business users, outside vendors and consultants.
- Ability to train and/or mentor as well as oversee specific project work of others.
- Exposure to ETL tools like Pentaho is desired.
- Ability to write/tweak scripts on unix platform.
- Exposure to version control tools like git.
- Good understanding of RDBMS concepts.
PHYSICAL DEMANDS/WORKING CONDITIONS
- Predominantly sedentary office position with high frequency of keyboarding/computer work required.
- On-call periodically to support scheduled implementations, predominantly done on a weekend.
- The physical demands are minimal and typical of similar jobs in comparable organizations.
- The work environment is representative and typical of similar jobs in comparable organizations.