Business Intelligence Specialist (Oracle BI) - Melville, L.I., NY

Will design and implement BI software and systems, including integration with databases, data warehouses and applications. This includes selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users. The Business Intelligence Specialist is also responsible for ensuring high levels of BI availability through support functions and in-depth testing.

Oracle Business Intelligence experience is an absolute must have.

Required Skills:
Strategy & Planning:
• Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
Acquisition & Deployment:
• Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
Operational Management:
• Direct, organize, and lead projects in the implementation and use of new BI software tools and systems.
• Lead the integration efforts for merging BI platforms with enterprise systems and applications.
• Design, code, test, and document all new or modified BI systems, applications, and programs.
• Develop the semantic layer, metadata, reports, and report definitions.
• Develop graphs and portal interfaces.
• Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Analyze user requirements and, based on findings, design functional specifications for BI front-end applications.
• Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Work with project managers to ensure the data entry, retrieval, change, and delete functions meet business requirements for project completion.
• Ensures the integration of BI platforms and controls with applications is designed, development and implementation in a timely manner consistent with the firm’s standards.
• Conduct job duties and responsibilities according to the firm’s business system development methodology and/or its Systems Development Life Cycle (SDLC) methodology.
• Design and deliver end-user training and training materials: provide technical support as necessary.
• Troubleshoot BI tools, systems, and software : performance-tune these applications as necessary
• Act as evangelist for BI benefits across the organization: promote BI usage to relevant departments.

This is a permanent, full time position. Please do not apply (or refer) unless authorized to work in the US.
All candidates must be either US Citizens or US Permanent Residents

All candidates MUST be local to Melville, L.I., NY.
Please do not apply if you are not local, even if you would pay your own relocation.
Relocation is NOT offered.

SQL DBA / Windows Sys Admin (Bellmore, L.I., NY)

This is a Hybrid Role of SQL Database Administration and Windows Systems Administration (80/20)

Experience Needed:
• At least five years of solid, production-level experience with SQL Server (2008 ideal) is a must.
• Must have experience with SQL Server Clustering.
• Must have a strong Windows background (this is Not a UNIX shop). Windows Server 2003 / 2008 R2 Administration experience is also a must have.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options is needed.
• Will have experience troubleshooting and resolving database and server issues
• Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Experience with backups, restores and recovery models (RedGate SQL Backup Pro is ideal)
• Experience in implementing operational automation using scripts
• Knowledge of indexes, index management, and statistics
• Experience with SQL Server Reporting Services (SSRS administration and report design)
• Some experience with SQL Server Integration Services
• Some experience with load-balanced Web Servers running IIS7 is a plus.
• Experience performing daily system monitoring
• Ability to verify the availability and integrity of all hardware, server resources, systems and key processes and to verify completion of scheduled jobs such as virus scans and backups
• Ideally, will have experience with server farms: web servers, terminal servers, and others.

About You:
• Being an “Expert” is a bonus. BUT, “Curious” is also a requirement.
• Not being an expert at something is *NOT* a disqualifier.
• Not having the desire to learn what you don’t know *IS* a disqualifier. If you are the right person for this job, we’re happy to provide additional training as required.
• You must be team-oriented, yet self-motivated and directed.
• This role requires good communication and documentation skills. Be prepared to show us an example of something you have written previously, or better yet, if you happen to have a blog, please share the URL with us.
• During your interview, be prepared to share a previous project or particular piece of technology that excites you. We plan to discuss that project or piece of technology with you in order to get a more detailed picture of your technical skills and knowledge.

This is a permanent, full time position.
All candidates MUST be local to Bellmore, L.I., NY
Please do not apply if you are not local, even if you would pay your own relocation.
Relocation is NOT offered.

(All candidates must be legally eligible to work in the United States without sponsorship and must reside locally. Sorry, no Visa sponsorships or Transfers at this time. No 3rd Party Recruiters unless you represent a local candidate with these qualifications)