Database Administrator

Express; Columbus (OH); On-site; USD 85,000 - 120,000; Full time

Job summary

Express is seeking a Database Administrator at its Columbus Corporate Headquarters to design, implement, administer and maintain database solutions in a multi-platform environment. You will work with partners to define requirements and provide sustainable support, including after-hours on-call rotations.

The role requires 3–5 years in database administration, expertise in MS-SQL and Oracle, experience with RAC/AlwaysOn, backups, performance tuning and scripting in PowerShell and Bash.

Qualifications

• Education: Bachelor's Degree in Information Systems, Computer Science, Computer Engineering, related degree or equivalent work experience.
• 3-5 years experience installing, configuring, administering, tuning, and troubleshooting database products.
• Experience with MS-SQL and Oracle in virtualized Windows and Linux environments.
• Backups, recovery, and cloning experience.
• Performance troubleshooting and resource contention experience.
• Experience with RAC, AlwaysOn and other high availability technologies.
• Experience with query tuning, SQL Profiler / Extended Events.
• Experience with SQL Replication, Log Shipping, Oracle Data Guard.
• Experience in T-SQL and PowerShell; PL-SQL and Linux shell scripting.
• Linux server administration for Oracle needs; scripting in bash, python, etc.
• Able to perform root cause analysis and document IT processes.
• Willing to work beyond normal hours for critical maintenance and emergencies.
• Strong written and verbal communication; self-motivated and organized.

Responsibilities

• Administer Oracle and MS-SQL databases, including upgrades, maintenance, layout, and security.
• Manage multiple databases across development, test, training, and production environments.
• Participate in SDLC with design, development, testing and implementation.
• Refresh and test environments; provide enterprise architecture input.
• Review specifications, design and code with peers; perform data validation.
• Optimize configuration to maximize performance and availability.
• Collaborate with QA and Operations for smooth deployments.
• Plan integration and implementation strategies with project teams.
• Provide 24x7 on-call technical support.

Skills

Oracle

MS-SQL

T-SQL

PowerShell

Linux

Shell scripting

AlwaysOn

RAC

Performance tuning

Backup & restore

Education

Bachelor's Degree in Information Systems / CS / Engineering

Tools

Teradata

MongoDB

Cloud (GCP, AWS, Azure)

Job description

Overview

PHOENIX Retail, LLC is a retail platform operating the Express and Bonobos brands worldwide.

About Express

Express is a multichannel apparel brand dedicated to a design philosophy rooted in modern, confident and effortless style whether dressing for work, everyday or special occasions. Since its launch in 1980, the brand has embraced a design philosophy rooted in modern, confident and effortless style. Express ensures you look and feel your best, wherever life takes you. The Company operates over 400 retail and outlet stores in the United States and Puerto Rico, the express.com online store and the Express mobile app.

About Bonobos

Our Bonobos menswear brand is known for being a style instigator and offering perfect-fit risks through our innovative retail model and personalized experience. Launched online in 2007 with its signature line of chinos, Bonobos now offers a variety of styles available to order online and to try on at any one of our 50 Guideshop locations and at www.bonobos.com. Our Guideshops are in-real-life stores that deliver one-on-one service and expert fit advice. Don't think traditional retail, Bonobos is something you haven't seen before.

Location Name

Columbus Corporate Headquarters

Responsibilities

Responsible for designing, implementing, administering and maintaining database technology solutions and the solutions that rely upon them. The Database Administrator must have experience working with application partners to define and satisfy requirements for solutions leveraging database technology. This position will be responsible for creating and maintaining related documentation to enable sustainable support. Must be able to provide after hours (on-call) support, and maintain a flexible work schedule to accommodate planned and unplanned maintenance activities.

KEY RESPONSIBILITIES

• Administer Oracle and MS-SQL Databases (plan and perform database upgrades, apply database maintenance, design and maintain physical database layout, perform database reorganizations, design and implement backup and restore strategy, archiving strategy, maintain database security, administer database performance, manage database storage, database problem determination and resolution, etc.)
• Implement and maintain the multiple databases that comprise the overall database technology environment (development, test, training and production)
• Actively participant in complete full Software Development Lifecycle (SDLC) processes from design, flowcharting, development, testing, modifying and implementation. This includes ensuring proper integration with other systems
• Refresh and test environments
• Provide recommendations for enterprise architecture
• Participate in peer reviews on specifications, design and code
• Perform database data validation; develop and test related routines
• Provide technical input and assistance in optimal database configuration to maximize system performance and availability
• Work closely with Quality Assurance and Operations to ensure smooth deployment of high-quality applications
• Design and implement approaches to improve database performance, capacity, and scalability
• Work with project teams to plan integration and implementation strategies
• Provide 24x7 on-call technical support
• Participate in business requirement gathering meetings to understand all aspects of the business (functionality, processes, technologies): determine feasibility of requests; identify best approaches to provide technology solutions to meet business needs; provide detailed estimates (time, cost, resources); define technical specifications

REQUIRED EXPERIENCE & QUALIFICATIONS

• Education: Bachelor's Degree in Information Systems, Computer Science, Computer Engineering, related degree or equivalent work experience
• Years of Experience: 3 - 5 experience installing, configuring, administering, tuning, and troubleshooting database products and features for various application suites
• Experience as a Database Administrator, with recent/current versions of MS-SQL and Oracle database technologies running in virtualized server environments including Windows and Linux
• Experience with database backups, recovery and cloning
• Experience with performance troubleshooting, including hardware resource contention issues
• Experience with RAC, AlwaysOn Availability Groups and/or other high availability technologies
• Experience with application query tuning, including execution plan interpretation and SQL Profiler and/or Extended Events
• Experience with database server software and patch installations
• Experience with configuration and support of SQL Replication, Log Shipping, or other data movement technologies. Experience with Oracle Data Guard configuration and administration
• Experience in T-SQL and PowerShell programming
• Experience in PL-SQL and Linux Shell scripting
• Experience in Linux Server administration and performance review related to Oracle database needs
• Experience automating processes utilizing scripting tools (bash, perl, python, etc.)
• Able to perform root cause analysis and recommend appropriate remedial actions.
• Demonstrably solid written and verbal communication skills to drive projects to successful conclusion
• Self-motivated with excellent time management and organization skills. Able to acquire new skills autonomously
• Demonstrated ability to document IT processes and provide knowledge transfer to team members
• Must be willing and able to work beyond than normal work hours to resolve critical system problems and/or perform production system maintenance during emergency situations
• Proven skills as a team member

CRITICAL SKILLS & ATTRIBUTES

• Experience with administration of Teradata or Mongo DB solutions
• Experience with cloud infrastructure (GCP, AWS, Azure)
• Previous retail industry experience

Closing

If you would like to know more about the California Consumer Privacy Act click here.

Applicants must be currently authorized to work full-time in the United States. PHOENIX does not sponsor applicants for work visas (e.g., H-1B or TN status) for this position.

An equal opportunity employer, PHOENIX does not discriminate in recruiting, hiring or any other terms and conditions of employment hiring on the basis of any federal, state, or locally protected characteristic. PHOENIX only hires individuals authorized for employment in the United States. PHOENIX is committed to providing reasonable accommodation to individuals with disabilities. If you need an accommodation to search and apply for a job position due to a disability, please call 1-800-964-9793 and say 'Associate Relations' or send an e-mail to [e-mail] and let us know the nature of your request and your contact information.