Sr Database Administrator

Overview

Express is a modern, versatile, dual-gender apparel and accessories brand that helps people get dressed for every day and any occasion. Launched in 1980 with the idea that style, quality and value should all be found in one place, Express has always been a brand of the now, offering some of the most important and enduring fashion trends. Express aims to create confidence and inspire self-expression through a design and merchandising view that brings forward the best of now for real-life versatility.

In 2020, we launched a bold new strategy called the EXPRESSway Forward and our transformation is well underway. If you’re interested in the world of fashion retail and are ready to make your mark and cultivate your career, reach out and let’s talk. www.express.com

Responsibilities

The Sr Database Administrator is responsible for designing, implementing, administering and maintaining database technology solutions and the solutions that rely upon them. It’s critical that candidates 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.

The person that accepts this position must have the ability to provide after hours (on-call) support, and maintain a flexible work schedule to accommodate planned and unplanned maintenance activities

Note:  This is a Hybrid (on-site/remote) role in Columbus, Ohio at the Express corporate office.

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.
  • 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 24×7 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.
  • Provide status reports for related project activity.
  • Define standards for physical data storage, maintenance, access and security administration.

Required Experience & Qualifications:

  • Education: Bachelor’s Degree in Information Systems, Computer Science, Computer Engineering, related degree or equivalent work experience.
  • Years of Experience: 5 – 7 experience installing, configuring, administering, tuning, and troubleshooting database products and features for various application suites.
  • Strong 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 automating processes utilizing scripting tools (bash, perl, python, etc.).
  • Solid SQL and PL/SQL development skills – able to assist and direct application teams when needed.
  • 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.

Crictical Skills & Attributes:

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

Closing

As an equal opportunity employer, Express does not discriminate in hiring or terms and conditions of employment on the basis of any federal, state, or locally protected class. Express only hires individuals authorized for employment in the United States.

Notification to Agencies: Please note that Express does not accept unsolicited resumes or calls from third-party recruiters or employment agencies. In the absence of a signed Master Service Agreement and approval from HR to submit resumes for a specific requisition, Express will not consider or approve payment to any third-parties for hires made.

Job ID : 2022-15786

More Information

Apply for this job

Leave your thoughts

Share this job