Posted December 7, 2022

The National Consumer Panel has an exciting opportunity available for a Junior Solutions Architect. Our office is in Syosset, New York, however remote employment is an option.

Do you have experience with performance optimization and data modeling?

Interested in putting your skills to work for a company that has been celebrated as one of the “Best Companies to Work for in New York” for 7 years in a row?

The Junior Solutions Architect will work closely with the Architect Leader managing Server upgrades, troubleshooting issues, database querying and creating and maintaining T-SQL stored procedures.

Qualified candidates are self-motivated and have 3-5 years demonstrable experience developing in T-SQL in Sybase ASE or SQL Server. The candidate will have experience in Data Modeling, OLTP and OLAP databases. Experience reading source code in Objective –C, Java, Python is also required.

The ideal candidate produces results, takes initiative, has strong analytical, communications, problem-solving skills, and can work effectively as a team member. The candidate must be comfortable interfacing with internal clients and have the ability to convey technical terminology to nontechnical audiences.

In the Junior Solutions Architect role, you will:

• Gain an understanding of NCP’s infrastructure components and then assist in managing the Server Upgrade and replacement process by partnering with Hosting team members to execute on new server installation and setup and other maintenance tasks.

• Assist in troubleshooting efforts for issues with Database, Java web services, CRM, AWS, and other technologies and platforms used by NCP.

• Perform advanced database querying to analyze and troubleshoot data issues and business issues related to the databases.

• Create Analysis and Design documents and associated project documentation.

• Create and maintain T-SQL stored procedures and advise other developers on creating complex and efficient SQL queries.

Required knowledge/skills:

• BA/BS degree or equivalent work experience

• Experience with performance optimizations such as improving scalability, availability, throughput, failover, etc. in databases.

• Experience in Data Modeling, OLTP and OLAP databases.

• 3+ years’ experience developing in T-SQL in Sybase ASE or SQL Server.

• Must be able to read source code in languages other than SQL (e.g., Objective-C, Java, Python) and understand & interpret the code.

• Experience with writing high quality, testable, maintainable, and well documented code.

• Experience in writing Unix shell scripts.

• Experience with Cloud based database technologies (Redshift, Aurora, Azure Data, Postgres).

• Familiarity with database/ETL tools (e.g., Linux, RedShift, SQL, Talend) a plus

Additional knowledge/skills preferred:

• Knowledge of web service integration technologies (REST, SOAP, JSON, XML).

• Experience of using JDBC and other database connection technologies with Java

• Familiar with defect tracking software, networking troubleshooting

• Familiar with Windows and Linux server administration.

• Familiar with version control (Git/Subversion) and branching strategies

• Experience conducting design and code reviews with the Development teams.

• Familiar with ETL tools, e.g. Talend

Tools/Certifications Preferred:

• SQL Certification

Competencies:

• Ability to work with both business users and development teams.

• Self-starter with excellent analytical, communication, and problem solving skills

• Ability to facilitate a highly collaborative and productive work environment

• Ability to multi-task in a fast-paced environment

• Independent worker

Contact

Jane Slater
Director, Human Resources
[email protected]
(516) 682-6086