Mainframe/Unix Database Administrator

2 weeks ago


Little Rock, United States Dillards Full time
Job DescriptionJob Description

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





  • Little Rock, United States CareerBuilder 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) ....


  • Little Rock, United States EDB Full time

    A Little About UsInnovative, collaborative minds wanted. The world loves Postgres. We envision a world where organizations thrive by harnessing the full power of Postgres, the worlds fastest growing and most loved and used open source database. Our mission is to enable data teams everywhere to harness the full power of Postgres, whether on premises or in the...

  • Database Administrator

    Found in: beBee jobs US - 7 days ago


    Round Rock, Arizona, United States Kinross Gold Corporation Full time

    Round Mountain is an open-pit mine located in Nevada, one of the best mining jurisdictions in the world. The mine uses conventional open-pit mining methods and processes ore by mill and heap leach. Kinross began operating the mine in 2003, and it has since become a continuous improvement leader in the Company's portfolio. Round Mountain poured its 15...

  • Database Administrator II with Security Clearance

    Found in: Dice One Red US C2 - 7 days ago


    Rock Island, United States BEAT LLC Full time

    Job Title:Database Administrator II Locations:Multiple Locations (Rock Island IL; Fort Huachuca, AZ; Fort Detrick, MD; Fort Stewart, GA; Carlisle Barracks, PA; Fort Dix, NJ) Clearance:Secret Certifications:CompTIA Security+CE Education:Bachelor’s degree in Engineering, Computer Science, Telecommunications or a related field Roles and Responsibilities: *...

  • Database Administrator I with Security Clearance

    Found in: Dice One Red US C2 - 7 days ago


    Rock Island, United States BEAT LLC Full time

    Job Title:Database Administrator I Locations:Multiple Locations (Rock Island IL ; Fort Huachuca, AZ ; Fort Detrick, MD ; Fort Stewart, GA ; Carlisle Barracks, PA ; Fort Dix, NJ; Ft Rucker, AL; Ft. Eisenhower, GA (Ft. Gordon)) Clearance:Secret Certifications:CompTIA Security+CE Education:Bachelor’s degree in Engineering, Computer Science, Telecommunications...


  • Little Rock, United States ARHS Group Full time

    You want to combine passion and IT expertise? You are talented , motivated and ambitious ? Then, we will be more than happy to meet you ! Arηs Developments is actively looking for a SAP BO Administrator ( m/f ) . Ideally you have such expertise and knowledge: At least 3 years using SAP BI platform on administration & development Knowledge of IBM DataStage...

  • Database Administrator III with Security Clearance

    Found in: Dice One Red US C2 - 7 days ago


    Rock Island, United States BEAT LLC Full time

    Job Title:Database Administrator III Locations:Multiple Locations (Rock Island IL ; Fort Huachuca, AZ ; Fort Detrick, MD ; Fort Stewart, GA ; Carlisle Barracks, PA ; Fort Dix, NJ; Ft Rucker, AL; Ft. Eisenhower, GA (Ft. Gordon)) Clearance:Secret Certifications:CompTIA Security+CE Education:Bachelor’s degree in Engineering, Computer Science,...


  • Little Rock, United States 1st Employment Full time

    Our client, a reputable company in Little Rock, AR, is seeking a detail-oriented and organized Administrative Assistant to join their team and have the opportunity to work in a professional and supportive environment.Responsibilities:Answer phones and greet customers in a professional and friendly manner.Maintain and update spreadsheets and databases as...

  • Administrative Assistant

    Found in: Appcast Linkedin GBL C2 - 1 week ago


    Little Rock, United States 1st Employment Full time

    Our client, a reputable company in Little Rock, AR, is seeking a detail-oriented and organized Administrative Assistant to join their team and have the opportunity to work in a professional and supportive environment.Responsibilities:Answer phones and greet customers in a professional and friendly manner.Maintain and update spreadsheets and databases as...

  • Administrative Assistant

    Found in: Appcast US C2 - 1 week ago


    Little Rock, United States 1st Employment Full time

    Our client, a reputable company in Little Rock, AR, is seeking a detail-oriented and organized Administrative Assistant to join their team and have the opportunity to work in a professional and supportive environment.Responsibilities:Answer phones and greet customers in a professional and friendly manner.Maintain and update spreadsheets and databases as...


  • Little Rock, United States CareerBuilder Full time

    You want to combine passion and IT expertise? You are talented , motivated and ambitious ? Then, we will be more than happy to meet you ! Ar?s Developments is actively looking for a SAP BO Administrator ( m/f ) . Ideally you have such expertise and knowledge: At least 3 years using SAP BI platform on administration & development Knowledge of IBM DataStage...

  • Department Business Administrator

    Found in: Talent US C2 - 6 days ago


    Little Rock, United States University of Arkansas for Medical Sciences Full time

    Summary of Job Duties :The Department Business Administrator is responsible for performing business management activities for Information Technology Services with a focus on purchasing, contract processing, audit and control. Qualifications: Minimum Qualification: Bachelor's Degree in Business Administration, Accounting or related field of study...


  • Little Rock, United States Dillard's Full time

    THE OPPORTUNITYThe Endpoint Services Team is looking for a hard-working, self-motivated individual to support our area customers. To be successful in this role, you must be an excellent communicator and very organized. We are looking for someone who can lead by example and inspire their fellow co-workers. The Endpoint Services Systems Administrator is...


  • Little Rock, United States Fiserv Full time

    Calling all innovators - find your future at Fiserv. We're Fiserv, a global leader in Fintech and payments, and we move money and information in a way that moves the world. We connect financial institutions, corporations, merchants, and consumers to one another millions of times a day - quickly, reliably, and securely. Any time you swipe your credit card,...


  • Little Rock, United States Dillard's Full time

    THE OPPORTUNITY The Endpoint Services Team is looking for a hard-working, self-motivated individual to support our area customers. To be successful in this role, you must be an excellent communicator and very organized. We are looking for someone who can lead by example and inspire their fellow co-workers. The Endpoint Services Systems Administrator is...


  • Little Rock, United States Dillards Full time

    Job DescriptionJob DescriptionTHE OPPORTUNITYThe Endpoint Services Team is looking for a hard-working, self-motivated individual to support our area customers. To be successful in this role, you must be an excellent communicator and very organized. We are looking for someone who can lead by example and inspire their fellow co-workers. The Endpoint Services...

  • Database Administrator II with Security Clearance

    Found in: Careerbuilder One Red US C2 - 3 days ago


    Rock Island, IL, United States BEAT LLC Full time

    Job Title:Database Administrator II Locations:Multiple Locations (Rock Island IL; Fort Huachuca, AZ; Fort Detrick, MD; Fort Stewart, GA; Carlisle Barracks, PA; Fort Dix, NJ) Clearance:Secret Certifications:CompTIA Security+CE Education:Bachelor’s degree in Engineering, Computer Science, Telecommunications or a related field Roles and Responsibilities:•...

  • Database Administrator I with Security Clearance

    Found in: Careerbuilder One Red US C2 - 3 days ago


    Rock Island, IL, United States BEAT LLC Full time

    Job Title:Database Administrator I Locations:Multiple Locations (Rock Island IL ; Fort Huachuca, AZ ; Fort Detrick, MD ; Fort Stewart, GA ; Carlisle Barracks, PA ; Fort Dix, NJ; Ft Rucker, AL; FtEisenhower, GA (FtGordon)) Clearance:Secret Certifications:CompTIA Security+CE Education:Bachelor’s degree in Engineering, Computer Science, Telecommunications or...


  • Little Rock, United States Focused HR Solutions Remote Work Freelance Full time $55 - $85

    100% on-site in Little Rock, Arkansas. Remote work is not available.    Our direct client has an opening for a Senior Network Administrator (717324) This position is for 10 months with the option of extension and is in Little Rock, Arkansas This job is w2  only no corps are allowed.     If you are interested, please submit the following:YOUR...


  • Little Rock, United States Focused HR Solutions LLC Full time

    100% on-site in Little Rock, Arkansas. Remote work is not available. Our direct client has an opening for a Senior Network Administrator (717324) This position is for 10 months with the option of extension and is in Little Rock, Arkansas This job is w2 only no corps are allowed. If you are interested, please submit the following: YOUR CURRENT RESUME YOUR...