Previous Job
Previous
Senior Data Analyst - 18-01037
Ref No.: 18-01037
Location: Brooklyn, New York
Position Type:Contract
Start Date / End Date: 07/01/2018 to 07/02/2021
Summary:
  • The Senior Data Analyst will be responsible for all data related activities.
Essential Duties and Responsibilities: (Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position)
  • Create and maintains all databases required for development, QA, Staging and production usage.
  • Involved in implementing all the Data model changes.
  • Perform the capacity planning required to create and maintain the databases.
  • Work closely with system administration staff because Computers often have applications or tools on them in addition to the Oracle /SQL Databases.
  • Perform ongoing tuning of the database instances. Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
Non-Essential Duties:
  • Other duties as assigned
Supervisory Responsibilities:
  • May be assigned as team leader.
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 5 years of related experience.
  • Minimum 5 Years Experience in SQL 2008/2008R2/2012/2014 database management and related products from Microsoft including PowerShell, Windows 2008R2/2012R2 Server operating systems.
  • Minimum 5 Years Experience with advanced SQL queries and reading query execution plan, developing and            performance tuning complex, SSRS and SSIS-2012 packages.
  • Minimum 5 Years Experience with SQL 2012 on High Availability configuration, support, and troubleshooting.
  • Minimum 5 Years Experience with Performance tuning, Performance monitoring, Replication, Log shipping, Database Mirroring, Database capacity planning, Users and Role creation and monitoring
Knowledge, Skills and Abilities:
  • Ability to communicate clearly and effectively
  • Strong organizational skills
  • Must be detail oriented
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:
  • 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.
  • Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Work Environment:
  • The employee will normally work in a temperature-controlled office environment, with frequent exposure to electronic office equipment.
We are an EOE. Equal Opportunity Employer Minorities/Women/Veterans/Disabled/Sexual Orientation/Gender Identity