Database Developer

Oracle 11g, 12c, SQL, PL/SQL, SQL Loader, Informatica, Teradata, Tableau, Gitlab, SQLDeveloper/SQL Navigator/TOAD, AWS, Eureka, OAuth2, Hystrix, Swagger, XML/HTTP, JSON/HTTP, JMS/MQ
Contract W2, Contract Independent, Contract Corp-To-Corp, 30 Months
Depends on Experience

Job Description

Job Title: Database Developer

Location: Piscataway, NJ

Duration: Long Term Contract

 

 

Description: Candidate should have extensive experience in integrating multiple applications using web services and message-based systems and have hands-on experience using the following technologies: • Extensive programming experience as an oracle PLSQL Developer in Analysis, Design and implementation of Business Applications using the Oracle Relational Database Management Systems (RDBMS). . Hands-on development experience with Java/J2EE, Core Java, Multi-Threading • Hands-on experience with Spring Framework, Spring Boot, and Application runtime configuration (Webserver/App server, load balancing) • Hands-on experience with AWS, Eureka, OAuth2, Hystrix & Swagger • Excellent knowledge of SQL tuning • RESTful web services • XML over HTTPS, JSON over HTTPS • Hands-on experience with Redis, Elastic Search, Rabit MQ

  • Extensive development experience with SQL and PL/SQL.
  • Extensive experience with database performance turning, Looker, reporting tools
  • Experience with Unix/Linux shall scripts.
  • Hands on experience with Web Application
  • Hands on experience with Java J2EE, Spring Framework and Spring Boot.
  • RESTful web services, micro service
  • Experience with AWS database and caching solutions - Aurora,RDS, Postgres, Redis
  • Experience with Big Data - cassandra, Elastic

 

  • Oracle 11g, 12c
  • Looker, Reporting tools
  • NoSQL database systems, such as MongoDB or CouchDB
  • SQL, PL/SQL
  • SQL Loader
  • Informatica
  • Teradata
  • Tableau
  • Gitlab
  • SQLDeveloper/SQL Navigator/TOAD

 

Design, develop and support SQL, PL/SQL to include but not limited to advance and efficient stored procedures and SQL functions.
Design and develop databases, tables, views, stored procedures, user-defined functions, packages, and other database objects using Oracle 11g.
Database monitoring and optimized query tuning experience
Design and develop database and ETL (Extract, Transform, and Load) processes and scripts to support web application development and data processing.
Experience converting relational data to other formats like JSON, XML, Flat files, etc., and vice versa.
Experience in data warehousing and data modeling concepts and Data Architecture.
Work closely with the Database Administrators, enterprise architects, and lead developers to make sure application design is done according to the established standards.
Design and develop Database triggers and automation.
Experience with analysis, visualization, and reporting software and capabilities.
Experience interfacing with source control repositories preferably Gitlab.
Batch Processing Integration Tools Experience.
Reporting and business intelligence experience.
Experience with AWS infrastructure is a plus.
Programming experience preferably Java.

5 years of relevant experience including AWS, Eureka, OAuth2, Hystrix, Swagger, and related technologies 8 to 10 years of relevant experience with inter-system communication using RESTful services, SOAP services, XML/HTTP, JSON/HTTP, JMS/MQ 8 to 12 years of relevant experience with these open-source frameworks: Spring Framework, Spring Security, Spring Data, Hibernate, JUnit, Maven 8 to 12 years of experience in OOA(Object Oriented Analysis), OAD, UML(Unified Modeling Language); Hands-on experience with static analysis tools such as Sonar Cube, Fortify Hands-on experience with a source control system such as Maven, Git
Candidate should be able to apply commonly used integration patterns in solution design and implementations, and should be self-sufficient to develop a solution given the business requirements and high-level design.

Candidate should be able to apply commonly used integration patterns in solution design and implementations, and should be self-sufficient to develop a solution given the business requirements and high-level design.

End-to-End Systems Analysis and Design

  • Analyze architecture, relationship between systems, and systems flow of end-to-end designs
  • Identify potential performance constraints with inter-system designs
  • Evaluate solution’s alignment with the end user experience
  • Define clean yet flexible service interfaces

 

Software/ Application Development & Architecture

  • Develop systems and applications using complex algorithms to deliver business functions or architectural components
  • Integrate with a multiple backend systems using various transport and data protocols while being performance-conscious
  • Apply appropriate integration patterns based on technical requirements and high-level design

 

Database Analysis & Design

  • Design simple to intermediate complexity database designs
  • Troubleshoot and correct performance bottlenecks associated with SQL and database design
  • Support efforts related to the proper protection from corruption & encryption of sensitive information
  • Validate that programs are operating on clean, correct and useful data

Testing

  • Unit and integration test code using happy and exception paths
  • Test business processes/products across applications with an end-to-end process flow

 

System & Network Security

  • Reduce security threats with dependable & reliable security tools & software applications
  • Have and apply knowledge of secure programming techniques to reduce vulnerability to business application

Technical Communication

  • Communicate technical details to various audience types
  • Select appropriate communication medium

    S. or equivalent work experience
  • Experience with all phases of the Software Development Lifecycle, including system analysis, design, coding, testing, debugging and documentation
  • Teamwork & collaboration skills to work across organizations and lead cross-functional teams
  • Problem-solving skills to develop quick yet sound solutions to resolve complex issues
  • Designing, developing, implementing, testing and publishing Android applications on Play Store
  • 5 years of relevant experience including Angular JS, CSS, Android application development and related technologies
  • 3 years of relevant experience with inter-system communicate using RESTful services, SOAP services, XML/HTTP, JSON/HTTP, JMS/MQ
  • 5 years of relevant experience with these open source frameworks: Spring Framework, Spring Security, Spring Data, Hibernate, JUnit, Maven
  • 5 years of experience in OOA(Object Oriented Analysis), OAD, UML(Unified Modeling Language);
  • Hands-on experience with static analysis tools such as Sonar Cube, Fortify
  • Hands-on experience with source control system such as Accurev, Maven, Git

 

 

 

Thank you, 

Dileep | Techno-Comp Inc,  

P  x 112

Dice Id : technonj
Position Id : Dileep_DB
Originally Posted : 5 months ago
Have a Job? Post it

Similar Positions

SQL Database Developer(Backend)
  • Laksan Technologies
  • Trenton, NJ, USA
Senior SQL Database Developer in Trenton, NJ (Onsite)
  • Super Technology Solutions, Inc.
  • Trenton, NJ, USA
SQL Database Developer ONSITE
  • Brandon Consulting
  • Trenton, NJ, USA
Database Developer & Engineer
  • PRESAT
  • New York, NY, USA
Senior Database Developer
  • American Cybersystems, Inc.
  • Jersey City, NJ, USA
Database Developer/Azure
  • Case Interactive
  • New York, NY, USA
Database Developer (SQL Server) IV
  • pureIntegration
  • Philadelphia, PA, USA
Database Developer
  • Convergenz