Database Developer

Techno-Comp, Inc.,
Piscataway, NJ
18 hours ago

Reported
Report a poor listing

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