Previous Job
Previous
Database Developer - 18-01038
Ref No.: 18-01038
Location: Brooklyn, New York
Position Type:Contract
Start Date / End Date: 07/01/2018 to 07/02/2021
Summary:
  • The Database Developer is responsible for analyzing, designing and developing data architecture; monitoring and maintaining Postgre SQL Databases; and conducting dimensional modeling of conceptual data models, logical data models, and physical data models.
Essential Duties and Responsibilities: (Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position)
  • Analysis, Design and Development of Data Architecture
  • Design the solution architecture and solution experience across multiple architecture domain, such as business, data, integration and application
  • Perform Database Design, Dimension Modeling, and Star & Snowflake schema
  • Conduct dimensional modeling of data like conceptual data model, logical data model, and physical data model using Erwin
  • Execution of the job flow using various activities like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities
  • Monitor and Maintain Postgre SQL Databases by defining physical structures and organization of databases and data sets
Non-Essential Duties:
  • Other duties as assigned
Supervisory Responsibilities:
  • NONE
Minimum Qualifications: (To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.)
  • BA/BS in a related field with 2 years of related experience.
  • Minimum 2 years' Experience with SQL databases, related utilities and tool
  • Minimum 2 years' Experience in Data Architecture, Analysis, Design, Development and Big data technologies
  • Minimum 2 years' Experience with solution architecture and solution experience across multiple architecture domain, such as business, data, integration and application
  • Minimum 2 years' Experience in Database Design, Dimension Modeling, and Star & Snowflake schema
  • Minimum 2 years' Experience with advanced SQL queries and reading query execution plan, developing and performance tuning complex, SSRS and SSIS-2012 packages
Knowledge, Skills and Abilities:
  • Strong communications skills (both written and oral), strong customer service and excellent interpersonal skills, ability to listen and understand what is being described by the end user as well as the ability to explain problem resolutions when necessary.
  • Ability to work independently without direct supervision or guidance.
  • Strong organizational skills, ability to prioritize and multi-task. 
Diversity:
  • Shows respect and sensitivity for cultural differences; Educates others on the value of diversity; Promotes a harassment-free environment; Builds a diverse workforce.
Ethics:
  • Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
Physical Demands:
  • The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • While performing the duties of this Job, the employee is regularly required to sit and talk or hear. The employee is frequently required to walk; use hands to finger, handle, or feel and reach with hands and arms. The employee is occasionally required to stand; climb or balance and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision.
Work Environment:
  • The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
  • The employee will normally work in a temperature-controlled office environment, with frequent exposure to electronic office equipment.
  • During visits to areas of operations, may be exposed to extreme cold or hot weather conditions.  Is occasionally exposed to fumes or airborne particles, toxic or caustic chemicals, and loud noise.
We are an EOE. Equal Opportunity Employer Minorities/Women/Veterans/Disabled/Sexual Orientation/Gender Identity