Database Administrator (Sybase/Db2) - LanceSoft Inc

Join our dynamic team in beautiful Salt Lake City! We are seeking a motivated and experienced professional to perform Database Administration Operational Support activities as part of our Firm's Technology Services Operations Team. This role requires full weekend availability and offers an exciting opportunity to work with a variety of database technologies in a global environment.

Job Duties

• Perform Database Administration Operational Support activities.
• Provide production support for Sybase Adaptive Server Enterprise, Sybase IQ, UDB DB2, Sybase Replication, UDB DB2 SQL Rep and Q Replication, Paraccel, Postgres, Hadoop, MSSQL, MongoDB, Oracle database infrastructure globally.
• Support the following hardware: Sun v420r, Dell r610/710, Client 385/585/480 Blades.
• Administer and maintain an existing local/global Database infrastructure including implementation, operational support, and periodic upgrades of all infrastructure Database servers.
• Continually evaluate the operations of the environment and assist in the optimization and delivery of server infrastructure.
• Schedule maintenance jobs using Autosys.
• Perform root cause analysis on system failures and incidents and provide remediation solutions.
• Communicate and coordinate with application support and other IT support teams to provide timely responses for critical requests.
• Perform daily monitoring of Database infrastructure for Healthcheck, Application, and Replication Alerts.
• Responsible for Provisioning activities, User requests, and Resolution alerts.
• Involve in Business Continuity plan tests across all regions related to Database infrastructure.
• Adhere to company change management requirements and procedures.
• Create policies and procedures for regular operational activities.
• Manage small project initiatives within the Database team across large portions of the enterprise including datacenter migrations and End Of Life Database software and hardware.
• Organize Database Trainings locally and globally for the Database Team.
• Perform basic file system administration tasks including expansion and device carving using native Red Hat Enterprise Linux 5/6 multipath utilities.

Skills

Minimum Years Experience Required:

• 3 years of experience in the job offered or a related Database Administration role.

Special Skills and/or Licenses Required

For DB2 candidate:

• Supporting the following platforms: Red Hat Enterprise Linux v3/4/5/6 and Sun Solaris 5.8/10.
• Strong experience in UDB/DB2 database administration, maintenance, and implementation in a complex system environment.
• Extensive exposure to DB2 Replication including SQL Rep and Q replication.
• Strong knowledge of DB2 HADR (High Availability Disaster Recovery).
• Strong knowledge of DB2 Version upgrades and DB2 Builds.
• Strong knowledge of DB2 Transportable Tablespaces.
• DB2 Database design, development, and maintenance.

For Sybase candidate:

• Supporting the following platforms: Red Hat Enterprise Linux v3/4/5/6 and Sun Solaris 5.8/10.
• Database Platform: Sybase ASE, Sybase IQ, Sybase Replication.
• Extensive exposure to Sybase ASE 16.x, 15.x, ASE 12.x database administration under Linux platform.
• Strong experience in Sybase database administration, maintenance, and implementation in a complex system environment.
• Strong Sybase Replication experience (Replication Server 15.x, 12.x) and knowledge on Distributed Database Management System.
• Strong Knowledge in Performance Tuning for Databases.

And for both:

• Strong working knowledge on DBA tasks, troubleshooting, and analytical skills.
• IT Experience with a solid understanding of Banking, Retail, Healthcare, and Insurance domains and their processes.
• Flexible to work in weekend shifts.
• Good interpersonal skills to interact with global teams.
• Knowledge in job scheduler bash; Autosys, cron jobs, etc.
• Ability to work and effectively prioritize in a highly dynamic work environment that includes a global focus.
• Strong team player with good communication and interpersonal skills.
• Results-oriented and highly flexible.