• Sr. Software Developer- Sr. Data Mgt & Admin.

    Job Locations US-OH-Columbus
    Requisition ID 2018-2149
    Category (Portal Searching)
    Information Technology
  • Overview

    A Brand That's What's Now

    Express is the sexy, sophisticated lifestyle fashion brand for every occasion: work, weekends, or nights on the town.  Our brand is what's new and what's now for young fashion-forward men and women.  We have more than 600 retail and outlet stores throughout the United States and Puerto Rico, as well as franchise stores in Latin America.  We also have a best-in-class online/mobile shopping experience at www.express.com that allows our customers to shop whenever and wherever they like.  

     

    A Workplace To Match

    We think you'll like it here. 

    We offer a competitive compensation and benefits package, generous associate discount, and casual work environment. Working at Express is much more than the 9 to 5. It is an opportunity to connect and engage with some of the smartest individuals in the fashion business doing work they are passionate about.  This is the Express Life and we’re always looking for talented leaders at all levels to join our team; if this sounds like you, we'd love to chat!

    Responsibilities

    The "Enterprise Data Warehouse and Business Intelligence" team is the technology team responsible for defining, storing, managing and provisioning the data structures required to support the enterprise with consumption through various Business Intelligence platforms in a fast-paced and fluid environment. Individuals on this team:

    • Lead Technology design, development, implementation, and support efforts to establish solutions for providing the business with consumption capabilities of structured Enterprise Information across all Functional Areas of the business
    • Monitor and manage performance of the associated technology implementation
    • Provide stable, scalable, and recoverable solutions
    • Discover and Analyze opportunities for continuous improvement
    • Communicate insights to business leaders
    • Work cross-functionally with all other areas of IT and the business

     

    Job Requirements

     

    Responsibilities

    • Manage and maintain all production and non-production Teradata and other Data Warehouse MPPdatabase systems
    • Perform production implementations. Work with application developers for SQL tuning, standard coding practices and DDL generation. Create DBA policies, procedures and standards
    • Optimize database resources for optimum configuration, database performance and cost.
    • Work with EDW team to define and modify workload management standards (workload groups, roles, priorities etc.) based on the need of the day in production
    • Responsible for architecting, delivering, and supporting availability, stability, recoverability, scalability of production and non-production Data Warehouse environments
    • Establish standards for database design, data storage, maintenance, access and security administration. Establish and implement standards for monitoring to ensure that DB and ETL environments are running smooth and effectively, including backups.
    • Take ownership of performance tuning opportunities, deploy range optimization methods to mitigate risks to performance and communicate them to the team
    • Responsible for backup and recovery of PROD and non-prod database and ETL environments.
    • Perform database and security audits, which includes designing and implementing roles, profiles and accounts. Ensure compliance in related tasks with company and regulatory policies and procedures
    • Provide Tier 1 on-call support
    • Perform capacity planning and forecasting. Perform short and long term system/database planning, analysis and implementation of DB related features and enhancements
    • Support strategic project needs by creating, supporting and optimizing physical database designs
    • Work collaboratively with database team and with vendors to resolve incidents and mitigate risks
    • Gathering performance, CPU, capacity and other resource requirements for new applications and extensions to existing systems
    • Participate in 24/7 on-call support activities

     

    Qualification Requirements:

    • Bachelor’s degree Information Systems, Computer Science, Computer Engineering or a related degree, or equivalent experience
    • 5+ years of experience Database Administrator/Engineer, preferably w/ Teradata experience
    • Strong experience with Workload Management Features
    • Data Modeling Techniques
    • Experience with implementing major Data Warehouse version upgrades
    • Experience in performance optimization techniques and SQL tuning. Extensive experience in System Performance tuning, troubleshooting, database and application issues
    • Experience in BAR using NetBackup
    • Well experienced in data warehousing techniques, data migration and data conversions. Strong knowledge pertaining to ETL and BI tools (Microstrategy, Tableau etc)
    • Experience with one or more Redshift, Aster, QueryGrid, Unity products, Hadoop and Big Data Technologies preferred
    • Able to plan, co-ordinate and implement database initiatives, with solid interpersonal organizational and people communication skills, as well as solid writing and oral communication skills
    • Able to clearly articulate business and technical issues with senior management, peers, and vendors.
    • Understanding of ETL architectures, data movement technologies and business information systems
    • Must have working knowledge of disaster recovery capabilities

     

    Preferred

    • UNIX shell scripting
    • Teradata tools and utilities (TPT, Fastload, Fastexport, and MLoad etc.)
    • Teradata certifications
    • TARA GUI (BAR solution)
    • Knowledge of retail industry a plus
    • Conceptual working knowledge of Oracle ODI and SSIS

     

    #LI-DS2

     

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

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you!