Title:
Sr. Oracle Database Administrator
Skills:
RMAN, OEM Grid Control, and Data Guard, ANSI SQL, Oracle PL/SQL, Data Modeling, Oracle RDBMS
Date:
6-30-2009
Description:
Job Relationships
Reports to: Senior Manager, Infrastructure
Direct reports: None
Job Summary
The Oracle database group administers the Oracle databases for multiple business units. This position will provide timely and quality database services and problem resolution for internal and external customers, manage release database efforts in direct coordination with SCM, development and QA. Provide tier 3 on-call support to our production and development teams. Perform Oracle installations, upgrades, migrations, file organizations and back-ups/restores. Install and integrate data access tools such as Oracle client and SQL net. Review and recommend database capacity and performance improvements.
Essential Duties and Responsibilities
* Ensuring the quality, consistency and security of company data and database systems
* Performing database upgrades, installing RDBMS patches and troubleshooting Oracle database issues.
* Backup and recovery, performance tuning, monitoring, and security for production and development Oracle databases.
* Sharing a 24/7 on-call rotation with other team members.
* Provide Oracle Tier 3 support to the production team.
* Working on a variety of development and maintenance projects in coordination with application groups.
* Evaluating and recommending upgrades and new database tools and technologies as appropriate for the enterprise.
* Tuning queries
* Logical to physical data model implementation
Qualifications
* 6+ years experience managing Oracle RDBMS 8, 9i and 10g in a UNIX environment (Solaris 10 preferred). Strong emphasis on 10g.
* Bachelor*s degree from an accredited college in Computer Science or related discipline, or equivalent experience
* Great communication skills
* Must be able to administer multi-tier databases and spot performance bottlenecks.
* Strong troubleshooting skills: crashes due to devices failures, corruption, lock handling, recovery, etc.
* Experience with RMAN, OEM Grid Control, and Data Guard
* Very strong ANSI SQL and Oracle PL/SQL skills
* Data Modeling experience
Optional
* Previous development experience using C/C++, object oriented, java/jsp knowledge, and UNIX/Solaris is a plus
* Experience with Oracle Administrative tools such as OEM, Toad, Embarcadero DBArtisan is a plus
* Usage of AWR, TKprof, etc is a plus
* OCP is a plus
----------------------------------------------------------
Title:
Sr. Java Web Software Engineer
Skills:
Java 5, JDBC to connect to SQL Server 2000/2005 and/or Oracle 9.x servers, Java, SQL, HTML, JSP/JSTL, Javascript, leadership
Date:
7-1-2009
Description:
GHX is committed to advancing the business of healthcare, leading to improved patient care worldwide. Owned by an industry collaboration of medical providers and suppliers, GHX provides a business hub to drive better performance in healthcare. GHX helps any organization that buys, sells, uses and tracks healthcare products realize costs savings, gain efficiencies, and make better business decisions. Currently, organizations representing more than 80 percent of the hospital beds and medical products sold in the United States participate in GHX, as do a considerable number of healthcare providers and suppliers in Canada and Europe. As the business hub evolves and participation grows, the opportunities to improve healthcare expand beyond supply chain automation to initiatives that can improve patient safety.
Mobile Solutions is responsible for producing an industry leading solution that allows Medical Device sales representatives to perform all of their job functions electronically. This includes performing audits of Hospital consignment inventory, creating the billing care information from providers for company products used in surgeries, and obtaining the latest pricing and product information wirelessly using Windows Mobile devices.
The Mobile Solutions Web Software Engineer will be responsible for but not limited to the following:
* analysis, design, and implementation of the GHX Mobile Solutions web software
* user interface design/development
* database access development and network communication development
The primary focus will be enhancing and maintaining GHX*s SalesAccelerator web application. This is the industry-leading sales operation management application for the medical device industry with an install base of over 4000 users. The programming languages used for development of SalesAccelerator*s web application are Java, SQL, HTML, JSP/JSTL, and Javascript. The client browsers supported by the SalesAccelerator web application include Internet Explorer 6.0 and higher as well as Mozilla Firefox.
Required:
* B.S. in Computer Science or related degree
* 3+ years experience and proficiency translating customer requirements into technical design, implementation tasks, and accurate estimates
* 3+ years experience designing, implementing, and supporting complex deployed enterprise web applications
* 5+ years of professional Java development experience including experience with Java 5
* 3+ years in design of SQL to support application requirements. Proficient with using JDBC to connect to SQL Server 2000/2005 and/or Oracle 9.x servers
* 3+ years of experience with web standards and web design using HTML, Javascript/AJAX, CSS, XML
* 3+ years experience working with version control systems (Subversion) including code merging, conflict resolution.
* Strong understanding of Struts 1.x, JSP/Taglib and JSTL
* 1+ Team Leader or supervisory experience.
* Ability to work early morning hours with the Mobile Solutions team in Indianapolis, including attendance at daily stand-up meeting at 7:00a Mountain
* Ability to travel to Indianapolis to work with Mobile Solutions team on a regular basis (1-2 times per month expected)
Preferred but not required:
* Understanding of and desire to work with Windows Mobile/PDA devices
* Experience working as an individual contributor on an Agile team using SCRUM daily standup meetings, burndown charts, sprint planning/retrospectives
We are not accepting applications from applicants that require visa sponsorship at this time.
