Mainframe/Unix Database Administrator

1 month ago

Little Rock, United States Dillards 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

    4 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...

  • Mainframe/Unix Database Administrator

    4 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...

  • Mainframe/Unix Database Administrator

    1 week 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...

  • 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...

  • Mainframe/Unix Database Administrator

    1 week 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

    3 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

    4 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

    4 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

    4 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

    4 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

    1 week 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

    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 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

    16 hours 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 for...

  • Senior Sql Database Administrator

    1 month 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

    4 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

    1 week 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

    1 week 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

    1 month 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

    4 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) ....

  • Expert Level SQL Database Administrator

    1 week 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) ....