Database Administrator

Database Administrator Columbus, OH Job Details Full-time 10 hours ago Benefits Flexible schedule Qualifications Performance tuning Computer science Data replication Data storage Azure Computer Science Requirements specification Automation Database clustering Software deployment Database backup and recovery High availability architecture Software implementation System design Information Systems Google Cloud Platform MongoDB Mid-level Scalable systems Windows Software installation Database security management Bash System maintenance Data Architecture Design (Architecture design skills) AWS SQL Server Profiler Patch management Bachelor's degree Requirements analysis Virtualization Perl Computer Engineering Software documentation Organizational skills Scalability IT Teradata Systems & applications support Linux Data validation Root cause analysis PL/SQL Bachelor's degree in computer science Communication skills Linux administration Python PowerShell Database installation High availability Time management

T-SQL SDLC

Full Job Description Overview:

About

PHOENIX PHOENIX

Retail, LLC is a retail platform operating the Express and Bonobos brands worldwide. 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. Bonobos is a menswear brand known for being pioneers of exceptional fit and a personalized, innovative retail model. Customers can experience our brands in over 400 Express retail and Express Factory Outlet stores, 50 Bonobos Guideshops, and online at www.express.com and www.bonobos.com. About Express Express is a multichannel apparel brand dedicated to creating confidence and inspiring self-expression. Since its launch in 1980, the brand has embraced a design philosophy rooted in modern, confident and effortless style. Whether dressing for work, everyday or special occasions, 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.

Location Name:

Columbus Corporate Headquarters Responsibilities:

This position is 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. 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

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. 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 and let us know the nature of your request and your contact information. Notification to

Agencies :

Please note that PHOENIX 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, PHOENIX will not consider or approve payment to any third-parties for hires made.