SQL Developer

4 weeks ago

Trenton, United States Sunrise Systems Full time

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

  • SQL Developer

    4 weeks ago

    Trenton, United States Core Software Technologies Inc. Remote Work Freelance Full time $50 - $65

    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 that accurately represent business logic and data requirements. SQL Expertise:  Write...

  • Informatica PC Developer

    7 days ago

    Trenton, United States eTeam Full time

    1. Informatica Powercenter and SAP BODS hands-on experience, along with knowledge of pl/Sql 2. Design, develop, test and implement data pipelines based existing Informatica PowerCenter and SAP BODS and SQL Server technologies. 3. Review existing pipelines for opportunities to tune, optimize and harden Creates ETL Dataflows, Jobs, Mappings, Mapplets,...

  • Senior Snowflake Developer

    3 weeks ago

    Trenton, United States Core Software Technologies Inc. Remote Work Freelance Full time $65 - $70

    A Senior Snowflake Developer is a highly skilled professional responsible for designing, implementing, and optimizing data solutions using the Snowflake cloud data platform. This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for the...

  • WebFocus Developer

    13 hours ago

    Trenton, United States Strategic Resources International Full time

    This is a professional level non-supervisory position which will require coordination of programming activities being conducted by the Team Lead in association within the existing structure, rules and guidelines of the current AOC Web Reporting environment. This person will confer with other business and technical personnel who own data in various other...

  • Web Developer II

    13 hours ago

    Trenton, United States LikeMinds Consulting Full time

    The candidate should have at least four years experience coding in Java and a strong working knowledge of HTML, XML, JSON, relational databases, REST Web Service, and responsive web design.Candidate must be responsible for designing and developing web-based application systems for the agency s web site, B2B functionality, and internal systems...

  • Developer Tooling Engineer

    20 hours ago

    Trenton, United States Barclays Full time

    Software Tools Engineer Whippany, NJ As a Barclays Software Tools Engineer, you will be developing a number of applications in the Developer Tooling product within the Chief Technology Office product set. This will involve playing a part in architecture, design, implementation, deployment, maintenance, observation, and support of Developer Tooling...

  • Biztalk Developer

    2 days ago

    Trenton, United States The Edgewater Group Full time

    Global shipping firm is seeking a senior BizTalk developer to join their EDI Team. You will support a wide range of integration projects. You will work in a team environment and you must be able to multi-task and effectively prioritize. Required skills: Demonstrated proficiency in analysis, design and development of BizTalk applications(schemas, maps,...

  • Tableau Developer

    1 month ago

    Trenton, United States Datawize Technologies LLC Full time

    **Program Support Specialist (Tableau Developer)** **Work Hours : Monday-Friday,9am-5pm (35 hours per week)** **Lunch Period : 1hour (Unpaid)** **Work from office or remote: Hybrid** **Assignment location: 50East State Street, Trenton NJ 08625** **Job Type: Contract** **Job Duration: 12 Month** **Job Description: - ** **Equipment to be used by staffing...

  • Tableau Developer

    4 weeks ago

    Trenton, United States Core Software Technologies Inc. Remote Work Freelance Full time $50 - $65

    Responsibilities:Data Visualization:Develop interactive and visually appealing dashboards using Tableau.Design and implement charts, graphs, maps, and other visualization elements to effectively communicate data insights.Data Connection and Integration:Connect Tableau to various data sources, including databases, spreadsheets, and cloud-based...

  • Mainframe + Datacom DB Developer

    6 days ago

    Trenton, United States Omni Inclusive Full time

    Datacom DB is mandatory skill understanding of functionality using MF Technology and interface Consultant with Tech and BU, More BU centric - Online and Batch, Cobol, CICS, MVS- Data store: CA-Datacom, SQL enabled Table, DB2 MQ, CA-Librarian, VSAM, TSO, ROSCOE, DQuery

  • Python Developer at Sira Consulting

    4 weeks ago

    Trenton, United States CareerBuilder Full time

    You are viewing a preview of this job. Log in or register to view more details about this job. 0-3+ years of experience in Python Programming. Background with object oriented programming / scripting, Python preferred Able to create in-house applications / framework leveraging 3rd party APIs Ability to write and troubleshoot SQL a plus Knowledge of code...

  • Web Focus Developer

    1 day ago

    Trenton, United States Sterling 5, Inc. Full time

    Web Focus DeveloperLocation: Trenton, NJDuration: 1+ Years (Multiple Year Contract)Mode of Interview: SkypeNote: remote positionJob DescriptionThe Client is seeking a skilled, experienced and energetic consultant who is well-versed in Web FOCUS 8 to write and develop reports (in both GUI and source code) and create HTML User Interfaces within the Web Focus...

  • Web Focus Developer

    15 hours ago

    Trenton, United States Sterling 5, Inc. Full time

    Web Focus DeveloperLocation: Trenton, NJDuration: 1+ Years (Multiple Year Contract)Mode of Interview: SkypeNote: remote positionJob DescriptionThe Client is seeking a skilled, experienced and energetic consultant who is well-versed in Web FOCUS 8 to write and develop reports (in both GUI and source code) and create HTML User Interfaces within the Web Focus...

  • Statistical Programmer

    22 hours ago

    Trenton, United States System One Full time

    Job Title: Statistical Programmer, RWE Location: Parsippany, NJ Hours/Schedule: 8am-4pm, or 9am-5pm M-F Type: 12 month contract Overview Our partner, a Domestic Pharmaceutical company in New Jersey, is currently seeking to hire a Statistical Programmer(RWE). The perfect candidate for this role will have SME-level experience with SAS & SQL programming and...

  • Senior Microsoft Power BI Developer

    4 weeks ago

    Trenton, United States Feeding America Full time

    As the Senior Microsoft Power Bi Developer, you will work to transform raw data into relevant insights via interactive and simple-to-understand dashboards and reports. You will work closely with members of the CFBNJ team to streamline and improve the existing reports and dashboards while helping to create the next generation of tools meet future needs. End...

  • Project Lead

    4 weeks ago

    Trenton, United States Barnes & Noble Full time

    Barnes & Noble is the world’s largest retail bookseller and the leading retailer of content, digital media and educational products. We operate over 600 Barnes & Noble bookstores in 50 states and one of the web’s premier e-commerce sites, bn.com. Our Nook Digital business offers a lineup of popular NOOK® tablets and eReaders and an expansive collection...

  • Senior Business Systems/Data Analyst

    6 days ago

    Trenton, United States New York Technology Partners Full time

    Work under the direct supervision of the VP for Business Operations and Development and assist him with IT-related business development and management, proposal writing, financial analysis including: (a) identify, interview and work with IT subject matter experts to understand and gather Clients' business requirements and technical specifications,...

  • Computer Systems Analyst

    4 weeks ago

    Trenton, United States New York Technology Partners Full time

    Work under the direct supervision of the VP for Business Operations and Development and assist him with IT-related business development and management, proposal writing, financial analysis including: (a) identify, interview and work with IT subject matter experts to understand and gather Clients' business requirements and technical specifications,...

  • Software Engineer

    1 day ago

    Trenton, United States Carvechi Technology Full time

    Carvechi Technology is hiring a software engineer based in Union, New Jersey. Position is contract to hire. Software Engineer As an Analyst Programmer/Senior Software Engineer you will possess a combination of application development and implementation skills as well as strong analysis and design skills. You will utilize these skills as part of a team...

  • Health Data Specialist II

    2 weeks ago

    Trenton, United States Biogensys Full time

    Job DescriptionJob DescriptionWe are hiring a Health Data Specialist II for one of our clients in Trenton, NJ.Job Description:Assist managing NJ Hospital Uniform Billing (UB) database in AWS environment, including checking data consistencies and data quality. Fulfill internal and external UB data requests.Quality check of UB daily extract data.Fulfill...