Mainframe/Unix Database Administrator
Company: Dillard's
Location: Little Rock
Posted on: April 15, 2024
Job 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
Keywords: Dillard's, North Little Rock , Mainframe/Unix Database Administrator, IT / Software / Systems , Little Rock, Arkansas
Didn't find what you're looking for? Search again!
Loading more jobs...