Java Database Developer
When submitting a resume for review, please also provide a response to the question at the bottom of this posting.
NOTE: Resumes submitted without responses will not be reviewed.
Job Description
Selerity is seeking a Java Database Developer with strong general Java and Web development experiences.
The Java Database Developer will be responsible for the implementation of multiple data repositories used by both internal and external clients/systems. External clients must be able to access the archives and associated reports via the web.
The ideal candidate should demonstrate successful past deliveries of web-enabled database reporting applications.
The role requires the ability to work in a fast-paced environment, communicate effectively, and produce high quality, error free work.
Employment Type: Full-time (preferred) or Contract.
Location: Jersey City, NJ.
Required Skills:
+Experience designing and implementing database schemas for capture and efficient processing of large data volumes. (using any of the following RDBMS: MySQL, Oracle, Sybase, and/or DB2).
+Proficient with SQL query and view construction for report generation.
+Good understanding of SQL tuning techniques for creation of efficient queries.
+Solid understanding of Agile web frameworks/platforms that can quickly. expose the underlying database reports via the web.
+Ability to work directly with users to gather requirements for report generation.
+Effective communicator and ability to work on teams with business users and other technologists.
+Extremely reliable and conscious of schedules.
Desired Experiences and Skills:
+4-5+ years of experience building web-enabled database applications.
+Understanding of JDBC ( mastery of Hibernate may also desirable).
+Experience building Agile web applications with Grails.
+Familiar with Subversion and Maven.
+Experience with Unix/Linux environments.
+Security and JavaScript experiences a plus.
Please submit a brief (300 words or less) answer to the following pre-interview screening questions:
Assume you have a process which writes out to a text log file in the following format:
2009-11-04 13:31:40.123894 - START TRANSACTION #9348204
2009-11-04 13:31:40.127205 - END TRANSACTION #9348204
2009-11-04 13:31:42.445600 - START TRANSACTION #9348205
2009-11-04 13:31:42.445635 - START TRANSACTION #9348206
2009-11-04 13:31:42.451483 - END TRANSACTION #9348206
2009-11-04 13:31:42.578831 - END TRANSACTION #9348205
Each transaction has a unique ID and should have a START and END (with timestamps to the microsecond).
Management wants to know the following two things:
1) In the past day, how many transactions took more than 10 milliseconds? For example, the above log shows that #9348205 took too long.
2) In the past day have there been any transactions which did not complete?
Question 1: Please describe how you would meet these requirements. How well would your solution scale if the log file were large(millions of rows per day) or there were many applications (100's) generating these log files?
- Location: Jersey City, NJ
- Principals only. Recruiters, please don't contact this job poster.
- Please, no phone calls about this job!
- Please do not contact job poster about other services, products or commercial interests.