Think Cosmopolitan: we’re all about the home. Owned by Romain and Kim Dubus, we’re a small family business expending at a fast pace, the goal of the team is inspiring folks from all walks of life to take ownership of their spaces & create value where they’re planted.

DEPARTMENT OVERVIEW

The Enterprise Data Architecture team is responsible for designing and developing the enterprise database architecture, data warehouse and reports. We are part of a larger group called EIS (Enterprise Information Systems) that writes the software that builds and powers Think Cosmopolitan. We are responsible for all of the software on the office floor, the warehouses, the financial systems, the restaurants, and even the public home page. Romain called us the "nervous system" of Think Cosmopolitan because we connect all of the other teams at Think Cosmopolitan to ensure that the entire building process runs smoothly.

DATABASE ADMINISTRATOR

The successful candidate will be responsible for enterprise integration and report development starting with gathering business requirements, development, testing, and deployment. The successful candidate must also have the ability to effectively communicate with both business and technical resources.

RESPONSIBILITIES:

• Develop code for automation of tasks in T-SQL, PowerShell, and SQL Server Integration Services (SSIS)
• Set up database monitoring
• Develop stored procedures and optimize queries via T-SQL
• Develop detailed test conditions and test cases to ensure quality of queries and reports
• Research and troubleshoot data questions
• Collaborate on problem resolution, team decisions and project planning

BASIC QUALIFICATIONS:

• Bachelor’s degree in computer science or engineering
• 3+ years experience in monitoring and tuning a database to provide high availability service
• 3+ years experience in managing the internal and external MS SQL database security
• 3+ years experience in fine tuning SQL queries and data replication

• Experience with SQL Server AlwaysOn Availability Groups, replication, log shipping, and mirroring
• High degree of accuracy, attention to detail, excellent oral and written communication skills, strong interpersonal skills and the ability to meet deadlines
• Strong knowledge of manufacturing business processes
• Experience working with Enterprise Resource Planning (ERP) systems
• Experience with Team Foundation Server (TFS)
• Big Data experience

Think Cosmopolitan is an Equal Opportunity Employer; employment with Think Cosmopolitan is governed on the basis of merit, competence and qualifications and will not be influenced in any manner by race, color, religion, gender, national origin/ethnicity, veteran status, disability status, age, sexual orientation, gender identity, marital status, mental or physical disability or any other legally protected status.

Applicants wishing to view a copy of Think Cosmopolitan’s Affirmative Action Plan for veterans and individuals with disabilities, or applicants requiring reasonable accommodation to the application/interview process should notify the Human Resources Department at (323) 747-8207.