- Strong SQL Server development experience required. Analyze, Design and Mentor team on designing OLAP database schema.
- Design tables, stored procedures, views, indexes, user defined functions, and other DB objects to support delivery on multiple Tier 1 and Tier 2 applications.
- Analyze and performance tune SQL queries to reduce the response time without impacting the application.
- Implement and document better practices for DB object creation , maintenance , performance tuning and optimization for future development.
- Develop and document data quality, data discovery and data lineage measures. Experience in CI-CD (Jenkins/DACPAC) deployments.
location: Jersey City, New Jersey
job type: Contract
salary: $57.27 - 67.27 per hour
work hours: 9am to 5pm
education: Bachelors
responsibilities:
- Strong SQL Server development experience required. Analyze, Design and Mentor team on designing OLAP database schema.
- Design tables, stored procedures, views, indexes, user defined functions, and other DB objects to support delivery on multiple Tier 1 and Tier 2 applications.
- Analyze and performance tune SQL queries to reduce the response time without impacting the application.
- Implement and document better practices for DB object creation , maintenance , performance tuning and optimization for future development.
- Develop and document data quality, data discovery and data lineage measures. Experience in CI-CD (Jenkins/DACPAC) deployments.
qualifications:
- Good to have Informatica or SSIS development experience.
- 10+ years SQL Server development experience.Informatica PowerCenter 10.x, Oracle 11g/12c SQL/PLSQL, AutoSys
skills:
- Familiar with any version control tool
- Unix Concepts
- Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins)
- Agile best practices
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.
