Canoe Ventures, LLC is a new, well funded company based in NYC that has developed a national platform for new media advertising, services and products. Our mission is to advance the evolution of television and make it more relevant, engaging and valuable to both consumers and marketers.
The Senior Engineer * Database Developer will design, develop, maintain and integrate application software, related project management activity and production support. Application development will be in all phases of software development lifecycle. Position will create new software, migrate legacy applications to modern Java/Oracle based technology and implements package software. This role will interface with multiple other organizations, including but not limited to the MSO community, the data aggregator, programmers and application vendors. This interaction will occur over a range of levels and the Database Administration Lead should be capable of communicating to the VP level.
Key Responsibilities:
This position will be reporting to the Director of Implementation. The ideal candidate will have a strong knowledge in creating stored procedures, functions, triggers, and other objects. The ideal candidate will have a solid understanding of hints, joins, and indexing. Ideally, this position will be able to provide some backup support to the DBA, i.e.., doing backup and maintenance plans and some production support. A strong understanding of relational theory is essential.
Requirements
* Bachelor*s Degree in Computer Science or related field
* Development experience (multiple major releases) in the primary areas of an n-tier enterprise system, e.g. interface, domain logic and database layers
* Relevant work experience in several of the following: Java Server Faces (JSF), Facelets, JSP/Servlet,s Java Web Services, CSS, AJAX, (JAX-WS, JAXB). ColdFusion
* Experience using application servers such as WebSphere, Apache, servlet containers (resin/tomcat/etc), JBoss, WebLogic , ColdFusion
* Experience developing Web services
* Experience with Microsoft windows tools
* Experience with build and source control tools and processes (such as Subversion)
* Knowledge of software life-cycles and software process management and improvement techniques
* Knowledge of software life-cycles
* Knowledge of open source software development, integration and release methodologies
* Working knowledge of Microsoft windows tools
* Knowledge of Java standards used for implementation of enterprise software such as J2E; Java Persistence API, (JPA)/Hibernate and Enterprise Java Beans (EJB) and frameworks (i.e. MVC architecture, Struts, Spring)
* Knowledge of Java IDE ' Oracle J Developer, Eclipse, or other open source Working knowledge in several of the following: Java Server Faces (JSF), Facelets, JSP/Servlet,s Java Web Services, CSS, AJAX, (JAX-WS, JAXB). ColdFusion
* Knowledge of Web development technologies such as XML, XSLT, JMX, JMS, HTML, DHTML
* Working knowledge of SQL and Oracle PL/SQL
______________________________________________________________________
Canoe Ventures, LLC is a new, well funded company based in NYC that has developed a national platform for new media advertising, services and products. Our mission is to advance the evolution of television and make it more relevant, engaging and valuable to both consumers and marketers.
The Database Administration Lead will be responsible to install, monitor, maintain and performance-tune database components for Canoe Ventures in the Denver Tech Ops Lab and CDC. This will include both Oracle and Teradata responsibilities. The Database Administration Lead will ensure than maintenance and support procedures are developed and followed, and will assist in maintaining the integrity of the Canoe production systems. This role will interface with multiple other organizations, including but not limited to the MSO community, the data aggregator, programmers and application vendors. This interaction will occur over a range of levels and the Database Administration Lead should be capable of communicating to the VP level.
Key Responsibilities:
* Database support of Canoe Ventures components housed in the Denver Canoe Tech Ops Lab and Denver CDC
* Support of multiple Oracle 11g database instances
* Support of a small number of Teradata instances
* Troubleshooting of issues related to associated applications, generally Java based, in order to isolate issues and escalate to development if necessary
* Represent the Technical Operations team in conversations regarding support issues and technical components
* Upgrade Oracle instances to new versions as needed
* Upgrade Teradata instances to new versions as needed
* Implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets
* Respond to and resolve database access and performance issues
* Create, or support creation of, required reports in response to business user needs
* Establish appropriate end user database access control levels and develop routines for end users to facilitate best practices database use
* Development of support methods and procedures
* Analysis of root cause of issues to determine irreversible corrective actions
Requirements
* At least 5 years combined experience with database administration of Oracle and Teradata in a corporate IT environment
* Strong understanding of database structures, theories, principles and practices
* Working technical experience with designing, building, installing ,configuring and supporting databases
* Hands-on database tuning and troubleshooting experience
* Exposure to highly transactional based systems or data processing systems
* Experience writing support methods and procedures
* Experience as a technical team leader, knowledgeable on how to coordinate work across team members
* Strong conceptual, analytical and judgment skills
* Strong verbal, written and listening skills
* Strong sense of initiative and problem ownership
* Linux system administration exposure a plus
* Windows system administration exposure a plus
* Java development exposure a plus
* Cable or advertising exposure a plus
* BS in Computer Science, Computer Engineering, Engineering or equivalent work
