Jobs
>
Trenton

    SQL Developer - Trenton, United States - Sunrise Systems

    Sunrise Systems
    Sunrise Systems Trenton, United States

    2 weeks ago

    Default job background
    Description

    Title: Database Manager/Administrator

    Location: Hamilton, NJ

    Duration: 10 months contract with possible extensions.

    Provides technical leadership for architecture, design, documentation and maintenance of an internal database and related systems.

    Please note that this is a hybrid role that requires an in-person interview.

    This role is critical for the project success and will be responsible to design, manage and maintain the Relational/SQL databases, data warehouse, and reporting infrastructure for all applications within the client.

    General responsibilities include Design, develop, and maintain database solutions and data warehousing to support enterprise application services, reporting, and analytics, including architecture design, data modeling, documentation, policies and standards. Analyze system requirements and migration methods for existing data in legacy systems. Plan, architect and optimize the data infrastructure to integrate with future systems. Maintain legacy reporting as well as design and implement new reporting and data, availability models.

    Responsibilities:

    • Design, implement and support data models, databases, and DW solutions to meet the long-term goals for the Client office.
    • Develop and implement OLTP schemas, comprehensive testing plans for validating data transformation and integration, develop key metrics to ensure integrity on data architecture.
    • Responsible to take the ownership for their assigned tasks and work independently and deliver results in an iterative approach adhering to the sprint deadlines.
    • Must work collaboratively with the team of developers, Technical Lead, Architect, Business SME's, and Project Managers.
    • Recognizes problems and responds, systematically gathers information, sorts through complex issues, seeks input from others, addresses root cause of issues, makes timely decisions, can make difficult decisions, uses consensus, when possible, communicates decisions to others, and rapidly adapts to change.

    Required Skills:

    • Database modeling, architecture design, development, backup & recovery, and administration.
    • SQL Server scripting and programming in various platforms, detailed analysis and design. SQL Server is required (Oracle and PL/SQL is a plus).
    • Experience in rapidly building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes, and other database components to support the existing & new development features in an agile environment.
    • SQL development (SSMS), Microsoft BI Stack (SSIS, SSAS).
    • Prior experience using various reports including SSRS (required) for report development.
    • Familiarity with developing Restful APIs for database layer, and web application architecture.
    • Strong expertise in analyzing and converting hierarchical data into relational data, including descriptions and diagrams.

    Nice to Have:

    • Knowledge/Experience in developing, hosting & managing databases on AWS RDS.
    • Knowledge/Experience implementing database designs, transactions for microservice architecture.
    • Experience in application modernization and migrating legacy platform's data models (Mainframes or similar).
    • Experience with GitHub, JIRA, .Net Core, EF core, Dapper, DataLake, Redshift, Docker/Kubernetes container services.

    Minimum Requirements:

    • 7+ years of Database design, SQL/TSQL development, SSMS, SSIS, SSAS & SSRS experience.
    • 1-2+ years on AWS RDS.
    • Bachelor's degree in Computer science or in a related field.

    Skill Matrix:

    Skill

    Required / Desired

    Amount

    of Experience

    Database modeling, architecture design, development, backup & recovery, and administration. Required 5 Years

    SQL Server scripting and programming in various platforms, detailed analysis and design. Required 5 Years

    Experience in rapidly building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes. Required 5 Years

    SQL development (SSMS), Microsoft Power BI Stack (SSIS, SSAS, SSRS) Required 5 Years

    Fix any issues related to database performance and provide corrective measures. Required 5 Years

    Familiarity with developing Restful APIs for database layer, and web application architecture. Required 5 Years

    Create, modify, and optimize SQL Server Agent jobs and maintenance plans. Required 5 Years

    Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner. Required 5 Years

    Strong expertise in analyzing and converting hierarchical data into relational data, including descriptions and diagrams. Required 5 Years

    Scripting and programming under Oracle using PL/SQL Nice to have 1 Years

    Knowledge/Experience in developing, hosting & managing databases on AWS RDS. Nice to have 1 Years

    Knowledge/Experience implementing database designs, transactions for microservice architecture. Nice to have 1 Years

    Experience in application modernization and migrating legacy platform's data models (Mainframes or similar). Nice to have 1 Years

    Experience with GitHub, JIRA, .Net Core, EF core, Dapper, DataLake, Redshift, Docker/Kubernetes container services. Nice to have 1 Years

  • Core Software Technologies Inc.

    SQL Developer

    2 days ago

    Core Software Technologies Inc. Trenton, United States Freelance

    Strong SQL Developer with an understanding of Data Build Tool (DBT) · Responsibilities: · Data Transformation and Modeling:Design and implement data transformations and models using data to create structured, cleaned, and aggregated datasets. · Develop and maintain data models th ...

  • SysTechCorp Inc

    Senior SQL Developer

    2 weeks ago

    SysTechCorp Inc Trenton, United States

    We are looking for qualified Senior SQL Developer who has some SQL Administration experience. · Immediate Interview and offer for qualified resource. · This position is only for resources who can work on our company W2 payroll and can work on our client in Trenton, NJ (Onsite). · ...

  • SysTechCorp Inc

    SQL Developer DBA

    2 weeks ago

    SysTechCorp Inc Trenton, United States

    Systech Client is seeking a skilled Senior Database Architect to join the team. The ideal candidate will have extensive experience in designing, developing, and maintaining efficient, scalable, and secure database systems. They will play a crucial role in determining database arc ...

  • Diverse Lynx

    SQL Developer

    1 week ago

    Diverse Lynx Princeton, United States

    Hi , · Below is the job description kindly look at it and let me know if you would be interested. · Skill: SQL Developer · NY, New York · Full Time · Must Have: · Strong data analysis and data quality assessment skills. · SQL skills and through understanding of data base constr ...

  • CapB InfoteK

    SQL Developer

    3 days ago

    CapB InfoteK Horsham, United States

    We are looking for a SQL Developer for our multiyear project out of Horsham, PA. · Skills & Experiences: · Experience in Teradata or Google Big Query is an added advantage Expert level. · SQL Developer with 10 years of experience and strong understanding in ETL Datawarehouse C ...

  • Georgia IT Inc

    SQL Developer

    3 days ago

    Georgia IT Inc Whitehouse Station, United States

    MS SQL Developer · Location: Whitehouse station, NJ or Philadelphia - Hybrid 3 days in and 2 days out · Duration: 3 months Right to hire · Job description: · The Global Actuarial Systems team is a small, agile group of technology enthusiasts. We are tasked with solving the co ...

  • Synechron

    Oracle PL/SQL Developer

    4 days ago

    Synechron Pennington, United States

    Title: Oracle PL/SQL Developer · Location: Pennington, NJ · Full Time/ Permanent · Contact: Syed.Khaliq@ · The Role · Responsibilities: · The candidate for the Backend/ETL developer position will be responsible for designing and developing batch/ETL interfaces using the proprieta ...

  • Diverse Lynx

    SQL Developer

    2 weeks ago

    Diverse Lynx Holmdel, United States

    Job Title: SQL Developer · Experience: 6 to 10 yrs. · Must Have Skills: ANSI SQL ,Database and SQL ,PL/SQL · Job Summary: 6+ years of experience with Bachelors / masters degree in computer science, Engineering, Applied mathematics or related field. · Roles & Responsibilities: Ma ...

  • Compunnel Inc.

    Oracle PL/SQL Developer

    1 week ago

    Compunnel Inc. Philadelphia, United States

    Job Title:- Oracle PL/SQL Developer (Onsite - Philadelphia, PA) · Duration:- 6+ Months Contract · Location:- Onsite - Philadelphia, PA · Job Description:- · We are looking for Oracle PL/SQL developer to create back-end software. This developer will work on existing mission critic ...

  • Brilliant Infotech Inc.

    Oracle Pl/Sql Developer

    1 week ago

    Brilliant Infotech Inc. Philadelphia, United States

    Responsibilities · Participate in requirements analysis. · Take direction from senior developers. · Collaborate with internal teams to produce software. · Write clean, scalable code. · Unit test and prepare applications for deployment. · Revise, update, refactor and debug code. · ...

  • Matlen Silver

    Oracle PL/SQL Developer W2 Only

    4 weeks ago

    Matlen Silver Pennington, United States

    Job Title: Oracle PL / SQL Developer · Duration: 12-18 months · Location: Pennington, NJ · Required Pay Scale: 65-68 hr · ***Due to client requirements this role is only open to W2 candidates*** · Job Summary: · Project Details: · ● Summary: · Individual should be able to demonst ...

  • Skywire Networks

    Qlik Sense/SQL Developer

    3 days ago

    Skywire Networks Jamesburg, United States

    The Qlik Sense/SQL Developer is responsible for all aspects of our Qlik Sense implementation and report development. As Qlik Sense developer, you will own the data integrity and strength of the solutions recommended. You'll be acting as a trusted advisor to our teams and 3rd part ...

  • Wizcom Consulting

    PL/SQL Backend Developer

    5 days ago

    Wizcom Consulting Philadelphia, United States

    Job Description · Job DescriptionTitle: PL/SQL Backend DeveloperLocation: Philadelphia, PA · Looking for 10+ years experience · Only W2 (No C2C) · Responsibilities: · Participate in requirements analysis · Take direction from senior developers · Collaborate with internal teams to ...

  • Syntricate Technologies Inc

    Oracle PL/SQL Developer

    1 week ago

    Syntricate Technologies Inc Pennington, United States

    Hi, · We are looking for an Oracle PL/SQL Developer. Please let me know, if interested. · Oracle PL/SQL Developer · Pennington, NJ (Onsite-Hybrid) · Full-Time · Job description: · • Candidate with strong Data Analytical skills (for data stored in Oracle / SQL Server). · • Job req ...

  • Syntricate Technologies

    Oracle PL/SQL Developer

    2 weeks ago

    Syntricate Technologies Pennington, United States

    Hi, · We are looking for an Oracle PL/SQL Developer. Please let me know, if interested. · Oracle PL/SQL Developer · Pennington, NJ (Onsite-Hybrid) · Full-Time · Job description: · •Candidate with strong Data Analytical skills (for data stored in Oracle / SQL Server). · •Job ...

  • Conduent

    SQL, Crystal Developer

    1 week ago

    Conduent Somerset, United States

    About Conduent: · Through our dedicated associates, Conduent delivers mission-critical services and solutions on behalf of Fortune 100 companies and over 500 governments creating exceptional outcomes for our clients and the millions of people who count on them. You have an oppor ...

  • Syntricate Technologies Inc

    Oracle PL/SQL Developer

    1 week ago

    Syntricate Technologies Inc Pennington, United States

    Hi, · We are looking for an Oracle PL/SQL Developer. Please let me know, if interested. · Oracle PL/SQL Developer · Pennington, NJ (Onsite-Hybrid) · Full-Time · Job description: · • Candidate with strong Data Analytical skills (for data stored in Oracle / SQL Server). · • Job req ...

  • Saxon Global

    sql server developer

    3 weeks ago

    Saxon Global Philadelphia, United States

    Client: old national bank · Location: eden prairie, mn MUST be onsite · Duration: 1 year+ · We have another request from Old National Bank. Alok needs to bring in a SQL Server Developer for a project that was just prioritized to him. · We are looking for consultants that have ...

  • Diverse Lynx

    SQL server Database Developer

    3 weeks ago

    Diverse Lynx Princeton, United States

    Job Title SQL server Database Developer Relevant Experience · (in Yrs) 5+ years Technical/Functional Skills Must have: · Top-3 · Deep knowledge of Relational Databases, Microsoft SQL server and proficient in T-SQL, SSIS and SSRS. (10+ years of experience) · Design and De ...

  • Akkodis

    Oracle PL/SQL Backend Developer

    2 weeks ago

    Akkodis Philadelphia, United States

    Akkodis is seeking an expert level Oracle PL/SQL Backend Developer to support our client in Philadelphia, PA. In this role you will work on existing mission critical applications to create and maintain back-end software in Oracle PL/SQL. · Local candidates are required as there ...