SQL Developer, Data Analyst

02 May 2024

Vacancy expired!

No Consulting firms.No sponsorship available.Must live within a commutable distance of Long Island, NY to be considered.

Job DescriptionThis position will be responsible for supporting users by developing MS-SQL queries, views, store procedures and ETLs from Oracle DB to convey information into Microsoft BI reports. Bridging data between Oracle Fusion and SQL environments.
  • Completes work requests as directed by Sr. Director of IT Programming and Development regarding application support and administration of all systems and coordinating work with users and independent software vendors (ISV)
  • Development of high-quality database solutions
  • Develop, implement, and optimize stored procedures and functions using SSMS, SSIS, SSRS, SSAS and Oracle PaaS.
  • Review and interpret ongoing business report requirements by researching required data.
  • Build appropriate and useful reporting deliverables.
  • Analyze existing SQL queries, store procedures and views for performance improvements. Suggest new queries.
  • Develop procedures and scripts for data migration.
  • Provide timely scheduled management reporting.
  • Expertise at taking a big-picture view of a company's data situation providing streamline solutions.
  • Provides exceptional customer service to all patrons and communicates in a pleasant, friendly, and professional manner always. Maintains a professional work environment with supervisors and staff.
  • Meets the attendance guidelines of the job and adheres to regulatory, departmental, and company policies.
  • Attends all necessary training meetings.
  • Assists with other projects, as directed.
  • Duties, responsibilities, requirements, and expectations pertaining to this job are subject to change as needed.
  • During Implementation - Provisioning the PaaS environments as per the architecture diagram (DEV, CRP2, Production etc.)
  • During Implementation - Provisioning compute nodes in OIC for OCI, OCI agents, ORDS, BI Publisher, Tomcat etc.
  • Performing PaaS environment administrative tasks (security, roles, users etc.)
  • Planning and scheduling all the critical security patching both on Linux Operating system side and PaaS environment on going monthly basis and quarterly basis.
  • Addressing all the vulnerabilities and preparing patching schedule
  • Performing tasks related to code migration and patch application for CRP, Test and PROD Pods
  • Performing instance clones for each testing cycle and completing pre and post clone tasks
  • Assisting in performance testing, running AWR reports etc., to help development team.
  • Engaging the customer and discussing on all critical infrastructure activities throughout the project

Qualifications
  • Oracle Fusion a plus
  • Bachelor’s Degree in computer science or Computer Engineering related degree, Master’s Degree is a plus
  • Proven experience as a BI Developer or Data Scientist
  • Background in data warehouse design (e.g., dimensional modeling) and data mining
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
  • Familiarity with BI technologies (e.g., Microsoft Power BI, Oracle BI)
  • Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
  • Proven abilities to take initiative and be innovative.
  • Analytical mind with a problem-solving aptitude
  • BS/BA in Computer Science, Engineering, or relevant field
  • Oracle Cloud Applications DBA 10 years of production DBA experience, OCP preferred -Should have knowledge in multi-tenant architecture, RAC, HA always on and at least one cloud technology certification preferred.
  • Performing PaaS environment administrative tasks (security, roles, users etc.)

Benefits:
  • 401(k)
  • 401(k) matching
  • Dental insurance
  • Health insurance
  • Life insurance
  • Paid time off
  • Vision insurance

Education:
  • Bachelor's (Preferred)

  • ID: #40056130
  • State: New York Southfarmingdale 11735 Southfarmingdale USA
  • City: Southfarmingdale
  • Salary: Up to $120,000
  • Job type: Permanent
  • Showed: 2022-05-02
  • Deadline: 2022-06-28
  • Category: Et cetera