Job Title: Database Administrator
Location: Salt Lake City, UT
Duration: 6 Months
JOB DUTIES:
- Perform Database Administration Operational Support activities as part of the Firm's Technology Services Operations Team.
- 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.
- Support the following hardware: Sun v240/440/4800/420r, Dell r610/710, HP 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.
- Involves 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's and hardware's.
- 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 5/6 multipath utilities.
MINIMUM YEARS EXPERIENCE REQUIRED:
3+ years of experience in the job offered or a related Database Administration role SPECIAL SKILLS AND/OR LICENSES REQUIRED TO PERFORM THE JOB:
Must have 3+ years of experience with:
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 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 Solid understanding of Banking, Retail, healthcare and Insurance domains and its 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, good communication and interpersonal skills.
- Results oriented and highly flexible.
Education:
- High School Diploma
- Bachelors Degree preferred
About Us: Established in 2004, SPECTRAFORCE ® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of human connection, defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at:
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@ if you require reasonable accommodation.
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act ( CPRA ) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE , your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer.