iNerc

applicants

EDUCATION

• Must be U.S. Customs and Border Patrol Clearable or already cleared

• Must be U.S. Customs and Border Patrol Clearable or already cleared.
• BS or MS in Comp Science or Engineering preferred.
• 7+ years of experience in development of software products, preferably 3+ years in Internet related technologies.
• 5-7 years of experience as a database administrator and/or developer.
• Minimum 3-5 years of experience in: database design, setup, and maintenance; product database deployment and operations
• Proven strong innovative and analytical ability with extensive implementation skills.
• Expert on DBMS kernels with distinguished achievements on database query optimization
• Proven success in performance optimization for such OLTP and OLAP applications like SAP, Peoplesoft, Siebel, or others.
• Proven track record in building and operating highly scalable/performing/24×7 web*enabled database applications
• Strong technical leadership skills with extensive hands on experience.
• Must be a team player, and have excellent communication skills
• Attention to detail, and a commitment to quality work
• Extensive knowledge of Oracle (PL/SQL)
• Experience working in both OLTP and Data Warehouse environments
• Enthusiastic interest in mastering monitoring and management software (Quest, Hotsos and other database related tools.).
• Experience with two or more versions of Oracle (8i/9i/10g) on UNIX and/or Windows platforms for an enterprise application
• Experience working with a Product Development team in an agile software development environment
• Demonstrated proficiency of troubleshooting techniques and detail*oriented problem diagnosis
• Demonstrated proficiency in Oracle JDeveloper, Oracle SQL Developer, TOAD, or equivalent tools
• Qualified candidate must have in-depth Oracle experience with installation, configuration, performance tuning, high availability, backup/restore and application development for enterprise class systems

RESPONSIBILITIES

• Assess and design data architectures to increase the robustness, performance, and scalability of the entire systems.
• Contribute substantially to the system architecture, design, and development of the DB layer
• Establish coding standards for stored procedures, triggers, and logical and physical schema design, document and enforce them within the development staff
• Work with system architects to improve existing OLTP model, transaction cost reduction, and increase the overall data throughput
• Tune SQL queries and database performance for OLTP and DSS applications within the development environment
• Participate in design and code reviews, documentation of design, implementation of methodologies to ensure high quality software
• Diagnose and troubleshoot performance problems using Method*R performance analysis methodology.
• Implement key database instrumentation tool sets
• Assist in the data modeling process for Engineering
• Document a set of database administration and performance best practices.
• Execute benchmark simulations for critical use cases.
• Perform database system and SQL profiling activities based on poorly performing use cases. Refactor poorly performing SQL when necessary.
• Review and tune initialization parameters, memory structures and physical data layout for optimal performance.
• Participate in the technology road map process. This includes evaluating new technologies and practices that related to performance and scalability.
• Interface with key technology partners to address specific initiatives around database performance and scalability.
• Database design, table design, data modeling & performance tuning
• Developing stored procedures and triggers, etc.
• Create and maintain tools that simplify Database Support tasks
• Responsible for trouble shooting the performance issues on the application backend & databases
• Design, code, and test new features and functionality based on requirements provided
• Perform software maintenance and bug fixes as needed
• Participate in design and code reviews, documentation of design, and implementation of software development lifecycle methodologies to ensure high quality software