Senior Software Engineer – Database
Department: Engineering
Location: San Francisco, California
Position Summary
The Senior Software Engineer will be responsible for the design and development of the database subsystem and related data access layer of CaseCentral's SaaS platform for Electronic Discovery, Early Case Assessment, and Online Analysis, Review and Productions. This is a code development role within a dynamic, fast paced and highly focused team. The Senior Software Engineer will work closely with fellow development engineers, QA engineers, architects, and product managers to understand product requirements, specifications and designs to design and code components and features to meet product requirements. Agility to operate within short release cycles is essential.
Responsibilities
• Detailed design and implementation of the data access layer and database subsystem of CaseCentral's multi-tenant, multi-party and multi-matter SaaS platform for Electronic Discovery, Early Case Assessment, and Online Analysis, Review and Productions
• Improvement of the usability, interactivity, performance and scalability of the client facing features and workflows and security validations through data modeling improvements, security interceptors, data caching techniques, and data tier and data access tier optimizations
• Design and development of highly scalable and high performance database subsystem with schema design, data modeling, data warehouse modeling, and PL/SQL on Oracle database
• Design and implementation of schema migrations and data migrations/upgrades that preserve data integrity and minimize system downtime
• Design and implementation of the data access layer, data persistence and data warehousing layers
• Database SQL query performance tuning, execution plan analysis and query optimizations
• End to end integration of application features through all layers, including the database and search engine layers in the backend
• End to end quality with effective automation of unit, component, and system level tests
• Automates routine maintenance tasks as appropriate
• Assist in the development of and implements standards for database maintenance and configuration
• Detailed documentation of designs and code to facilitate maintenance and further development
Education, Experience and Key Competencies
• Bachelor of Science in Computer Science or equivalent degree required
• 6+ years of experience developing multi-tier and data intensive enterprise and/or SaaS applications with Java, J2EE, Web Services, EJB, JBOSS Application Server, JMS or JBOSS Messaging, PL/SQL, Oracle, SQL tuning, Red Hat Enterprise Linux
• Middle-tier and backend development experience with Java/J2EE, JSP, Struts, EJB, MBeans, JMS and PL/SQL required
• Nice to have JPA with Hibernate experience
• Nice to have SQL Server and T-SQL experience
• Must be able to work in an agile development methodology, continuous integration and test approach, and frequent releases
• Must be able to code and debug end to end aspects of a multi-tier application
• Must be able to understanding existing application and code from available user level documentation, existing code, and high level overview of product functionality and code organization
• Must be able to formulate detailed designs and implement solutions from high level requirements
• Must be an effective communicator with good written and verbal English skills
• Must be an effective team player with ability to help others achieve common team goals
• Must have attention to details and passion for quality and continuous improvement
How to apply
• To apply for this position, send your resume to katharina.saghi@casecentral.com
