Oracle Database Developer Local )

1 month ago


Smithtown, United States Intelligence and National Security Alliance Full time

Job Title :

Oracle Database Developer Local ) Location : NYC - Hybrid Job Type : Hybrid Duration : 12 months Opening : 1 Opening

Assignment Details Senior database developer with strong data analytical skills and write complex queries to retrieve data for the business needs. Develop stored procedures, packages, and load large volumes of data using SPARK, Python, SQL Loader from .CSV files. Develop and publish the data on demand or scheduled and generate user reports using Power BI. Work independently and collaborate with teams, motivated and able to deliver end to end solutions.

Skills & Requirements 5+ years of experience in Oracle database developer with strong RDBMS skills - SQL querying, writing stored procedures, triggers, functions, views, user privileges, object privileges, etc. Strong data analysis and design skills. Has done performance tuning of stored procedures and queries. Knows ETL processes to load large volumes of data at speed, e.g. SQL Loader. 3+ years of experience In Power BI developing front end reports. Has experience in python and Linux environment and knows basic Unix commands. Experience working with team in Agile methodology. Cloud experience is a plus, Strong data analysis skills, design, and coding experience in AMI (Advanced Metering Infrastructure) / Utility industry is a plus. Work independently and collaborate with teams, motivated and able to deliver end to end solutions. Good communication skill to both technology folks and business partners. Quick learner, adaptable, has the right attitude to work across teams to find and deploy solutions. Committed to timely and quality deliverables. .Python, XML, SPARK, C#, Java Scripting, SPLUNK Database Development and SQL Skills: Please explain your experience with Oracle database development and RDBMS concepts?. What are the differences between user privileges and object privileges in Oracle? Have you worked with SQL Loader to load large volumes of data? Can you share your approach to handle data loading efficiently? Data Analysis and Design Skills: a. How do you approach data analysis and design tasks? Can you provide an example of a successful data analysis project you've worked on? Power BI and Front-End Reporting: a. Tell us about your experience with Power BI and developing front-end reports b. How do you ensure that the reports you create are intuitive and provide actionable insights for business users? c. Have you integrated data from different sources into Power BI reports? How do you handle data transformation and cleaning? Collaboration and Agile Methodology: a. How do you typically approach collaboration with other team members? b. Have you worked in an Agile development environment before? How do you adapt to changing requirements and priorities in Agile projects? Cloud Experience and Advanced Metering Infrastructure (AMI)/Utility Industry Knowledge: a. Do you have any experience or knowledge of the Advanced Metering Infrastructure (AMI) or the utility industry? How does this experience align with the role's responsibilities?

#J-18808-Ljbffr



  • Smithtown, United States Therapy Staff EDU Full time

    Therapy Staff EDU is seeking a local contract nurse RN School RN for a local contract nursing job in Smithtown, New York.Job Description & RequirementsSpecialty: School RNDiscipline: RNStart Date: 07/31/2024Duration: 13 weeks40 hours per weekShift: 8 hours, daysEmployment Type: Local ContractAequor, LLC is now hiring a full-time School Nurse RN for the...


  • Smithtown, United States Therapy Staff EDU Full time

    Therapy Staff EDU is seeking a School Services Speech Language Pathologist for a local contract job in Smithtown, New York.Job Description & RequirementsSpecialty: Speech Language PathologistDiscipline: School ServicesStart Date: 07/31/2024Duration: 13 weeks40 hours per weekShift: 8 hours, daysEmployment Type: Local ContractAequor is now hiring a full-time...


  • Smithtown, United States Therapy Staff EDU Full time

    Therapy Staff EDU is seeking a School Services Special Education Teacher for a local contract job in Smithtown, New York.Job Description & RequirementsSpecialty: Special Education TeacherDiscipline: School ServicesStart Date: 07/31/2024Duration: 13 weeks40 hours per weekShift: 8 hours, daysEmployment Type: Local ContractAequor is now hiring a full-time...


  • Smithtown, United States Therapy Staff EDU Full time

    Therapy Staff EDU is seeking a School Services Board Certified Behavioral Analyst (BCBA) for a local contract job in Smithtown, New York.Job Description & RequirementsSpecialty: Board Certified Behavioral Analyst (BCBA)Discipline: School ServicesStart Date: 07/31/2024Duration: 13 weeks40 hours per weekShift: 8 hours, daysEmployment Type: Local ContractAequor...

  • Major Gifts Officer

    1 week ago


    Smithtown, United States Guide Dog Foundation & America's VetDogs Full time

    The Guide Dog Foundation and Americas VetDogs have a unique employment opportunity for a Major Gifts Officer at our campus in Smithtown, NY. Our organizations are distinctive in the assistance dog industry providing both guide and multiple types of service dogs. Overall Summary: Under the supervision of the Director of Development, the Major Gifts Officer...

  • Major Gifts Officer

    2 weeks ago


    Smithtown, United States Guide Dog Foundation For The Blind, Inc. Full time

    **About the job** **Job Title: Major Gifts Officer** Generous PTO including 3 weeks vacation, 6 personal days, 10 sick days, and 11 paid holidays Hybrid schedule: 2 days remote and 3 days on-site Comprehensive benefits package available **The Guide Dog Foundation and America’s VetDogs have a unique employment opportunity for a Major Gifts Officer at...


  • Smithtown, United States LaVida Massage of Smithtown Full time

    **EXCITING TEAM POSITION AVAILABLE!** LaVida Massage of Smithtown is a fast-growing, locally owned Massage & Skincare center. We are now hiring a Spa Desk Coordinator (P/T or F/T) where you will be part of a team that delivers an exceptional customer experience in a professional, high-volume friendly atmosphere. **Responsibilities** - Provide excellent...


  • Smithtown, United States Catholic Health Service Full time

    Overview St. Catherine of Siena Hospital is a proud member of Catholic Health and has served the residents of the Smithtown area for more than 50 years. St. Catherine’s is located on the north shore of Long Island in Smithtown. The campus is comprised of 296-bed not-for-profit community hospital; a 240-bed nursing and rehabilitation care center; and a...


  • Smithtown, United States Brothers That Just Do Gutters - Smithtown Full time

    **Benefits**: - Bonus based on performance - Free uniforms - Opportunity for advancement - Paid time off - Training & development **Role: Gutter Installation Sales Representative**: - Take Everything You Ever Learned About Sales and Throw It in the Gutter!_ Our mission to "Reinvent Contractor Service" is best achieved by investing in our employees,...


  • Smithtown, United States Catholic Health Service Full time

    Overview: St. Catherine of Siena Hospital is a proud member of Catholic Health and has served the residents of the Smithtown area for more than 50 years. St. Catherines is located on the north shore of Long Island in Smithtown. The campus is comprised of 296-bed not-for-profit community hospital; a 240-bed nursing and rehabilitation care center; and a 60,000...


  • Smithtown, United States Catholic Health Service Full time

    Overview: St. Catherine of Siena Hospital is a proud member of Catholic Health and has served the residents of the Smithtown area for more than 50 years. St. Catherine’s is located on the north shore of Long Island in Smithtown. The campus is comprised of 296-bed not-for-profit community hospital; a 240-bed nursing and rehabilitation care center; and a...

  • Dietician

    16 hours ago


    Smithtown, United States Developmental Disabilities Institute Full time

    **Responsibilities**: - Develop and modify as necessary individual specific diet plans - Create menus for DDI personnel to follow - Participates as appropriate in training of DDI personnel on menus, diet plans, and modified diets. - Participates in IDT conferences as required - Complete monthly and annual nutrition summaries - Ensure compliance with OPWD...


  • Smithtown, United States Home Helpers Full time

     Home Helpers Home Care of Huntington, NY is hiring CNAs, HHAs, companions, and more! We are also hiring those who do not have a certification! WE ARE HIRING FOR MULTIPLE LOCATION ON LONG ISLAND. WE OFFER: - Affordable Telehealth Services   · Direct deposit · Competitive pay · Referral bonus · Performance incentive bonus · Flexible schedules...


  • Smithtown, United States Catholic Health Full time

    Hospitalist Program Director, MDCatholic Health is seeking a Director, Medical Hospitalists to ensure that the patients of St. Catherine of Siena Hospital receive the highest level of hospital care in the in-patient setting.Join our growing physician network of more than 2,900 physicians in Suffolk, Nassau and Queens County. Catholic Health is a fully...


  • Smithtown, United States Catholic Health Full time

    Hospitalist Program Director, MDCatholic Health is seeking a Director, Medical Hospitalists to ensure that the patients of St. Catherine of Siena Hospital receive the highest level of hospital care in the in-patient setting.Join our growing physician network of more than 2,900 physicians in Suffolk, Nassau and Queens County. Catholic Health is a fully...


  • Smithtown, United States Catholic Health Full time

    Hospitalist Program Director, MDCatholic Health is seeking a Director, Medical Hospitalists to ensure that the patients of St. Catherine of Siena Hospital receive the highest level of hospital care in the in-patient setting.Join our growing physician network of more than 2,900 physicians in Suffolk, Nassau and Queens County. Catholic Health is a fully...


  • Smithtown, United States Catholic Health Full time

    Hospitalist Program Director, MDCatholic Health is seeking a Director, Medical Hospitalists to ensure that the patients of St. Catherine of Siena Hospital receive the highest level of hospital care in the in-patient setting.Join our growing physician network of more than 2,900 physicians in Suffolk, Nassau and Queens County. Catholic Health is a fully...

  • Store Manager

    3 days ago


    Smithtown, United States Pet Supplies Plus Full time

    Overview: Does your cat wear sunglasses? Does your dog have more sweaters than you? If you’re the leader of the pack and enjoy providing products and services that enrich pets’ lives, then come work in our neighborhood! Responsibilities/Qualifications: As a **Store Team Leader** at Pet Supplies Plus, you’re pawsitively passionate about people and...


  • Smithtown, United States Catholic Health Full time

    Hospitalist Program Director, MDCatholic Health is seeking a Director, Medical Hospitalists to ensure that the patients of St. Catherine of Siena Hospital receive the highest level of hospital care in the in-patient setting.Join our growing physician network of more than 2,900 physicians in Suffolk, Nassau and Queens County. Catholic Health is a fully...


  • Smithtown, United States Catholic Health Services of Long Island, General Talent Acquisition Full time

    Catholic Health is seeking a Director, Medical Hospitalists to ensure that the patients of St. Catherine of Siena Hospital receive the highest level of hospital care in the in-patient setting. Join our growing physician network of more than 2,900 physicians in Suffolk, Nassau, and Queens County. Catholic Health is a fully integrated health system serving...