|Location:|| Draper, UT|
|Salary Range:||Depends on experience & education|
|Benefits:||Competitive Medical, Dental, Vision, Flex Spending, Tuition Reimbursement|
|Employment Type:||Full Time|
Corporate Headquarters in Draper, UT
1-800 CONTACTS is the largest ($600 million-plus) direct-Marketer of replacement contact lenses in the United States. Through its toll-free telephone number, 1 800 CONTACTS, and through its multiple Internet addresseswhich include 1800contacts.com, contacts.com and contactlenses.com, the Company offers essentially all of the soft and hard contact lenses produced by major contact lens manufacturers, including Johnson & Johnson, CIBA Vision, Bausch & Lomb, Ocular Sciences and Cooper Vision. The Company stocks the largest inventory of contact lenses in the world (20 million) from which it can ship approximately 95% of its orders within one business day of receipt.
|Duties:||The Database Administrator is responsible for the development and production databases of 1-800 CONTACTS.|
Perform database tuning and performance monitoring.
Advise Software Engineers on issues such as database design, indexing, SQL tuning, stored procedures, and triggers.
Work with project teams to assist with data requirements, data interface designs and data conversion efforts.
Assist development staff with the debugging and optimization of SQL queries and stored procedures.
Provide ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database patches and service packs.
Work as part of a team and provide 24/7 support when required.
Work with other DBAs and the software development team to design, code, test and implement database solutions as part of application systems development projects.
Anticipate problems and take decisive action.
Data modeling, database optimization, understanding and implementation of schemas, interpret and write complex SQL queries.
Troubleshoot operational data issues and perform ad-hoc reporting as needed.
Support the database needs of development teams as needed.
Interface with Architecture group on new database design, functionality and implementation.
|Qualifications:|| Bachelors degree highly preferred, ideally in Computer Science or applicable area.|
Must have a solid understanding of database connectivity with a secure mindset.
2 + years SQL Server work experience (or equivalent education) in DBA or Database Development role preferred.
Knowledge of C#/.NET is a plus.
Understanding of SOA and Service-driven development is a plus
Familiarity with Agile methodology is a plus.
Data driven, demonstrating superior analytical skills.
Have in-depth understanding of best analytical practices.
Ability to spot errors and inconsistencies in data and analysis.
Excellent communication skills, project management and decision making skills.
Must have the ability to learn quickly in a dynamic environment and deliver on commitments in a timely manner.
Must have the ability to work independently as well as in a group dynamic.
Competitive Medical, Dental, and Vision benefits
Free yearly eye exam for employee & immediate family
Full time associates accrue up to 19 days Paid Time off annually
401K with company match
8 paid Holidays
Huge discounts on contact lenses and glasses for employee, friends and family
Free on-site fitness center with access to certified trainers
On-site restaurant with highly discounted meals
Company paid Life, AD&D
Supplemental Life available
Long Term Disability
Free 24 hour Nurse Line
Extensive Wellness program
Free soda, coffee, and drinks all day every day
Free breakfast, fruit and bread all day every day
Much, much more
Apply by emailing a resume to: firstname.lastname@example.org Please list the position title in the subject line and specify how you learned of the opportunity.
SQL Server jobs in draper utah, SQL Developer jobs, DBA jobs in utah, Database administrator jobs in draper utah, SQL DBA jobs in draper utah, SQL Server 2008, SQL server 2012, T-SQL, transact SQL, agile methodolody, C#/.NET development, SOA, service oriented architecture, database development jobs in Utah
This job is no longer active. Please click here to see current job listings.