Tuesday, August 19, 2008

GHX - SR. SQL DBA, SR ORACLE DBA

[rmiug-jobs] Digest Number 4699

SR. SQL DBA - LOUISVILLE, CO
Posted by: "Jennifer" jhagaman@ghx.com
Date: Tue Aug 19, 2008 3:16 pm ((PDT))

PLEASE APPLY TO http://jobs-ghx.icims.com

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.

Job Summary
The essential responsibilities of the SR SQL Server Database
Administrator are:

• Providing assistance in the development and performance
tuning of GHX applications,
• Monitoring, maintaining and deploying production databases
• Troubleshooting system issues in production.

This cross-functional role requires working with GHX staff,
including developers, system administrators, QA engineers, customer
service representatives, and product managers. This position will
ensure GHX applications utilizing SQL Server run smoothly and
perform as required, and strive to achieve 99.9% uptime. This
position is also expected to provide guidance and assistance to
junior database administrators.

Essential Duties and Responsibilities
• Design, develop and implement core SQL Server administration
activities, including: backups, performance monitoring and tuning,
patching, upgrading, etc.
• Support SDLC release process by reviewing, approving, and
deploying production system releases during normal system
maintenance windows
• Troubleshoot SQL Server system level issues such as crashes
due to device failures, corruption, lock handling, backup /
recovery, etc. and make recommendations to Product Management and IT
Management for resolving the issues
• Assist development teams in the logical and physical
database design, including table and index design, query analysis,
and physical file layout (file groups, fill factors, etc).
• Provide rotating on call 24/7 operation support.
• Other duties as assigned.

Qualifications
• Bachelor's degree preferred or 6 years active experience in
SQL Server Administration
• Good verbal and written communication skills required
• MCDBA / MCST Certification preferred
• Demonstrated ability to administer and support SQL Server
installations (2000 and 2005)
• Demonstrated ability to install and maintain SQL Server on
clustered servers
• Strong SQL query and stored procedure (TSQL) development
skills required
• DTS – Data Transformation Service package knowledge
• Experience using third-party SQL Server administration
tools, such as RedGate
• Experience in troubleshooting SQL Server system level issues
such as: crashes due to device failures, corruption, lock handling,
recovery, etc.
• Understanding of SAN and Networking principals.

--------------------------------------------------------------

________________________________________________________________________
13. SR ORACLE DBA - LOUISVILLE, CO
Posted by: "Jennifer" jhagaman@ghx.com
Date: Tue Aug 19, 2008 3:48 pm ((PDT))

PLEASE APPLY AT http://jobs-ghx.icims.com

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.

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