Mainframe/Unix Database Administrator

3 weeks ago

Little Rock, United States Dillard's Full time
THE OPPORTUNITY

Dillard's is looking for a motivated, detail-oriented Database Administrator with a positive attitude and a drive to learn and collaborate. As a DBA, you will play a critical role in managing and maintaining the installation, configuration, uptime, performance, and backup & recovery of all support databases within the company. You will have the opportunity to grow professionally and be challenged daily while learning several database platforms and supporting Dillard's eCommerce site. You'll also get the opportunity to work alongside a great group of DBAs, as well as regularly interact and collaborate with the other IT teams on assignments, making a difference for our business.

THE TEAM

This role is on our Mainframe and Unix Database Administration team, which supports hundreds of databases for applications utilized by all areas of our retail business (Store personnel, Apparel buyers, Fulfillment staff, HR, Accounting, Executives, and much more). As a new member of our team, you will have a mentor who will help you become acclimated to Dillard's business strategy as it relates to your role.

WHAT YOU WILL DO
  • Ensure required database resources are available to business users and application programming staff
  • SQL Tuning
  • Provide technical direction to the application programming staff
  • Backup and Recovery
  • Logical and Physical modeling and design
  • Work with system programming staff to plan and implement maintenance, upgrades, and migrations
  • Research and planning related to new technologies, application rewrites, and implementation of new applications
  • Data Governance
  • Automate redundant and repetitive practices
  • Keep abreast of current industry best practices
  • Participate in on-call rotation
THE "MUST-HAVES"
  • Advanced knowledge of one or more programming/scripting languages
  • Strong SQL language programming and tuning skills
  • Familiarity with z/OS OR Unix/Linux environment navigation and basic commands
  • Proven research skills and ability to take the initiative to research an issue when one arises
  • Ability to solve problems independently but also collaborate and communicate well with others
  • Authorization to work in the United States without sponsorship
  • Ability to work onsite at Corporate Headquarters in Little Rock, AR
THE "NICE-T0-HAVES"
  • 2+ years of IT experience
  • Familiarity with MongoDB
  • Familiarity with Korn Shell scripting
  • Db2 for z/OS administrator experience
  • Db2 for LUW on Unix/Linux administrator experience
WITHIN 1 MONTH, YOU'LL
  • Know the different database objects used in the shop
  • Know the naming convention used in the shop
  • Develop a basic knowledge and understanding of the tools used in the team (DBAS, StarTools, ISPF, QMF, ServiceNow, Google Mail, Calendar, Chat, Duo)
  • Create and alter database objects in the test environment (tablespaces, tables, columns, indexes, grant rights)
  • Run simple utilities in the test environment (image copy, reorg, runstats)
  • Write simple SQL statements (select, insert, update, delete)
WITHIN 2 MONTHS, YOU'LL
  • Feel comfortable running database commands in Db2 for z/OS
  • Feel comfortable using all the tools
  • Backup and recover tables
  • Create other database objects and run advanced utilities on the test environment (check data, load, unload, recover, triggers, sequences)
  • Be able to bind and rebind packages
  • Be able to create triggers
WITHIN 3 MONTHS, YOU'LL
  • Write SPUFI and utility jobs
  • Schedule overnight jobs (Zeke, ChangeMan)
  • Tune a simple SQL query for performance
  • Create database objects and generate and run utilities on the production environment

  • Mainframe/Unix Database Administrator

    2 months ago

    Little Rock, United States Dillards Full time

    Job DescriptionJob DescriptionTHE OPPORTUNITYDillard's is looking for a motivated, detail-oriented Database Administrator with a positive attitude and a drive to learn and collaborate. As a DBA, you will play a critical role in managing and maintaining the installation, configuration, uptime, performance, and backup & recovery of all support databases...

  • Database Administrator

    2 weeks ago

    Little Rock, United States Insight Global Full time

    The ideal candidate will be responsible for creating, installing and managing our databases. You will ensure optimal database performance by analyzing database issues and monitoring database performance. ResponsibilitiesManage database changes and re-designsAnalyze database issues and troubleshoot or configure the database accordinglyDrive automation of...

  • Database Administrator

    2 weeks ago

    Little Rock, United States Insight Global Full time

    The ideal candidate will be responsible for creating, installing and managing our databases. You will ensure optimal database performance by analyzing database issues and monitoring database performance. ResponsibilitiesManage database changes and re-designsAnalyze database issues and troubleshoot or configure the database accordinglyDrive automation of...

  • Database Administrator

    2 weeks ago

    Little Rock, United States Insight Global Full time

    The ideal candidate will be responsible for creating, installing and managing our databases. You will ensure optimal database performance by analyzing database issues and monitoring database performance. ResponsibilitiesManage database changes and re-designsAnalyze database issues and troubleshoot or configure the database accordinglyDrive automation of...

  • SQL Database Administrator

    2 weeks ago

    Little Rock, United States JobRialto Full time

    Description MINIMUM: 7 Years Experience SQL Server 2016 (or later versions) database administration: Installing and upgrading SQL Servers, including applying service packs Performing routine database maintenance Creating and scheduling SQL Server jobs to perform database maintenance activity Rebuilding indexes Updating statistics Consistency checks...

  • SQL Database Administrator

    2 weeks ago

    Little Rock, United States JobRialto Full time

    Description MINIMUM: 7 Years Experience SQL Server 2016 (or later versions) database administration: Installing and upgrading SQL Servers, including applying service packs Performing routine database maintenance Creating and scheduling SQL Server jobs to perform database maintenance activity Rebuilding indexes Updating statistics Consistency checks...

  • Senior Sql Database Administrator

    3 days ago

    Little Rock, United States Cloud Resources LLC Full time

    Contract Opportunity: MS SQL Server DBA, Little Rock, Arkansas, 3 months onsite, then remote Onsite Day 1 in Little Rock, AR for 3 months. Then remote if approved. Maybe higher for perfect match. This is a senior-level experience role. State government experience is a plus. Visas OK Short Description: The SENIOR SQL Database Administrator will be...

  • Senior Sql Database Administrator

    3 weeks ago

    Little Rock, United States Cloud Resources LLC Full time

    Contract Opportunity: MS SQL Server DBA, Little Rock, Arkansas, 3 months onsite, then remoteOnsite Day 1 in Little Rock, AR for 3 months. Then remote if approved. Maybe higher for perfect match. This is a senior-level experience role. State government experience is a plus. Visas OKShort Description:The SENIOR SQL Database Administrator will be responsible...

  • Senior Sql Database Administrator

    3 weeks ago

    Little Rock, United States Cloud Resources LLC Full time

    Contract Opportunity: MS SQL Server DBA, Little Rock, Arkansas, 3 months onsite, then remoteOnsite Day 1 in Little Rock, AR for 3 months. Then remote if approved. Maybe higher for perfect match. This is a senior-level experience role. State government experience is a plus. Visas OKShort Description:The SENIOR SQL Database Administrator will be responsible...

  • Senior Sql Database Administrator

    2 weeks ago

    Little Rock, United States Cloud Resources LLC Full time

    Contract Opportunity: MS SQL Server DBA, Little Rock, Arkansas, 3 months onsite, then remoteOnsite Day 1 in Little Rock, AR for 3 months. Then remote if approved. Maybe higher for perfect match. This is a senior-level experience role. State government experience is a plus. Visas OKShort Description:The SENIOR SQL Database Administrator will be responsible...

  • Expert Level SQL Database Administrator

    3 weeks ago

    Little Rock, United States HexaQuEST Global, Inc. Full time

    ON-SITE WORK for at least the first 3 months, remote allowed after that. Position is available for extensions. The SENIOR SQL Database Administrator will be responsible for providing reliable, cost-effective, & secure enterprise-wide support for business critical production & non-production databases for the Arkansas Integrated Revenue System (AIRS) ....

  • Database Administrator Senior

    5 days ago

    Rock Island, United States KaiHonua Full time

    Position: Database Administrator - Senior Location: Rock Island Arsenal, Rock Island, IL Job Summary KaiHonua, LLC is seeking a highly motivated, self-directed Database Administrator to join our growing team. The candidate will work within a cohesive engineering team to design, develop and implement database solutions that store, organize, and manage...

  • LU 516 - Senior SQL Database Administrator

    19 hours ago

    Little Rock, United States Focused HR Solutions Remote Work Freelance Full time

    100% on site. Our direct client has an opening for a   SENIOR SQL Database Administrator (736169)    This position is for 13 months with the option of extension and is in Little Rock, Arkansas  W2 and Corps are allowed.  If you are interested, please submit the following:YOUR CURRENT RESUME.YOUR HOURLY RATE.   Job Details: SENIOR SQL Database...

  • MO-5-9-Senior SQL Database Administrator

    3 weeks ago

    Little Rock, United States Focused HR Solutions Remote Work Freelance Full time

    100% on site. Our direct client has an opening for a   SENIOR SQL Database Administrator (736169)     This position is for 13 months with the option of extension and is in Little Rock, Arkansas   W2 and Corps are allowed.  If you are interested, please submit the following:YOUR CURRENT RESUME.YOUR HOURLY RATE.   Job Details: SENIOR SQL Database...

  • MO-5-9-SENIOR SQL Database Administrator Rock, Arkansa

    3 weeks ago

    Little Rock, United States Focused HR Solutions LLC Full time

    100% on site. Our direct client has an opening for a SENIOR SQL Database Administrator (736169) This position is for 13 months with the option of extension and is in Little Rock, Arkansas W2 and Corps are allowed. If you are interested, please submit the following: YOUR CURRENT RESUME YOUR HOURLY RATE SENIOR SQL Database Administrator Skills and...

  • MO-5-9-SENIOR SQL Database Administrator Rock, Arkansa

    3 weeks ago

    Little Rock, United States Focused HR Solutions LLC Full time

    100% on site. Our direct client has an opening for a SENIOR SQL Database Administrator (736169) This position is for 13 months with the option of extension and is in Little Rock, Arkansas W2 and Corps are allowed. If you are interested, please submit the following: YOUR CURRENT RESUME YOUR HOURLY RATE SENIOR SQL Database Administrator Skills and...

  • MO-5-9-SENIOR SQL Database Administrator Rock, Arkansa

    2 weeks ago

    Little Rock, United States Focused HR Solutions LLC Full time

    100% on site. Our direct client has an opening for a SENIOR SQL Database Administrator (736169) This position is for 13 months with the option of extension and is in Little Rock, Arkansas W2 and Corps are allowed. If you are interested, please submit the following: YOUR CURRENT RESUME YOUR HOURLY RATE SENIOR SQL Database Administrator Skills and...

  • MO-5-9-SENIOR SQL Database Administrator Rock, Arkansa

    2 weeks ago

    Little Rock, United States Focused HR Solutions LLC Full time

    100% on site. Our direct client has an opening for a SENIOR SQL Database Administrator (736169) This position is for 13 months with the option of extension and is in Little Rock, Arkansas W2 and Corps are allowed. If you are interested, please submit the following: YOUR CURRENT RESUME YOUR HOURLY RATE SENIOR SQL Database Administrator Skills and...

  • Systems Administrator

    2 weeks ago

    Little Rock, United States Catholic Health Initiatives Full time

    Overview CHI St. Vincent, a regional health network serving Arkansas is part of CommonSpirit Health. We have served Arkansas since 1888 with a history of many firsts. Together with more than 4500 coworkers, 1000 medical staff and 500 volunteers we consistently receive praise for care advancements. CommonSpirit Health was formed by the alignment of Catholic...

  • Systems Administrator

    2 weeks ago

    Little Rock, United States Chi Full time

    Overview CHI St. Vincent, a regional health network serving Arkansas is part of CommonSpirit Health. We have served Arkansas since 1888 with a history of many firsts. Together with more than 4500 coworkers, 1000 medical staff and 500 volunteers we consistently receive praise for care advancements. CommonSpirit Health was formed by the alignment of Catholic...