Database Administrator

- Mid Level

Salt Lake City, UT

Professional, Scientific, and Technical Services

About the position

Stefanini Group is hiring! Stefanini is looking for Database Administrator (Sybase/DB2) for Salt Lake City, UT location (100% Onsite). The position is a contract role with a duration of 6+ months. The working hours are Spring/Summer 10:20 AM to 6:40 PM MST and Fall/Winter 9:20 AM - 5:40 PM MST. Work on both weekends is required - with any 2 consecutive. The role involves performing Database Administration Operational Support activities as part of the Firm's Technology Services Operations Team, providing production support for various database systems, and managing the existing local/global Database infrastructure.

Responsibilities

• 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, Mongo DB, Oracle database infrastructure globally.
• Administer and maintain an existing local/global Database infrastructure including implementation, operational support, and periodic upgrades.
• 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.
• 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.
• Organize Database Trainings locally and globally for Database Team.
• Perform basic file system administration tasks including expansion and device carving using native Red Hat Enterprise Linux.

Requirements

• 3+ years of experience in Database Administration or a related role.
• High School Diploma required; Bachelor's Degree preferred.
• For DB2 candidates: Strong experience in UDB/DB2 database administration, maintenance, and implementation.
• Extensive exposure to DB2 Replication including SQL Rep and Q replication.
• Strong knowledge of DB2 HADR, Version upgrades, and Transportable Tablespaces.
• For Sybase candidates: Strong experience in Sybase ASE, Sybase IQ, and Sybase Replication.
• Extensive exposure to Sybase ASE 16.x, 15.x, 12.x database administration under Linux platform.
• Strong knowledge in Performance Tuning for Databases.
• Strong working knowledge on DBA tasks, troubleshooting and analytical skills.
• IT Experience with a solid understanding of Banking, Retail, healthcare, and Insurance domains.
• 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.

Nice-to-haves

• Results oriented and highly flexible.
• Strong team player with good communication and interpersonal skills.

Benefits

• Competitive salary range of $42.00 - $47.00 per hour.
• Potential bonuses or other incentives.