Oh Snap!
This job is no longer active - but you can still view the details below.

Database Developer

| Austin

Database Developer (SQL Server)

Job Description
Compeat Inc. is looking for a smart, driven, mid-level Database Developer (SQL Server) to design, enhance, maintain, troubleshoot, performance tune and support our current database platform. This core developer will utilize Microsoft SQL Server 2016 to address performance, scalability and efficiency issues in a high traffic environment; 2300+ DBs and multi-TBs of data, all while assisting with the implementation of a cohesive vision for all database work. The ideal candidate will be able to work both independently and as part of a team. The job will be performed onsite at either our office in Spring, TX or Austin, TX.

Qualifications
• B.S. or higher in information systems, computer science or related field or equivalent database development experience.
• U.S. Citizen or Permanent Resident and legally entitled to work in the U.S.
• 4+ years database development experience with SQL Server 2008/2012/2014/2016.
• 2+ years SSRS report writing experience.
• Extensive hands on development experience in database design principals and architecture, building indexes, developing stored procedures, monitoring, performance tuning, and troubleshooting.
• Develop complex queries (ad-hoc SQL & stored procedures/views/etc) and ability to effectively analyze execution plans to identify and remediate bottlenecks and improve performance.
• Troubleshoot database related performance issues; must have the ability to find/define problem, collect data, establish facts, draw valid conclusions, test out possible solutions and implement fix.

Desired Skills & Experience
• Understanding and experience with AWS and a virtual environment on a SAN platform.
• Demonstrate excellent interpersonal and communication skills including the ability to effectively communicate with internal customers and capable of working with remote team members.
• Participate in the review of SQL code written by application developers to ensure compliance to coding standards and best practices as well as maximum performance. 
• Create deployment and rollback scripts for table and/or data changes. 
• Analyze data access patterns and propose the best combination of indexes, constraints, foreign keys, and queries. 
• Troubleshoot performance problems and propose short term fixes and long term solutions for very large data sets.
• Knowledge in all aspects of SQL Server 2012/2014/2016 T-SQL including the ability to write and deploy effective stored procedures, scripts and user defined functions.
• Basic understanding of SQL Server internals and use of dynamic management views.
• Knowledge of disaster recovery principals, practices and planning.
• Ability to mentor junior developers; helping them to expand their technical horizons and encourage them to think creatively to solve business needs in increasingly efficient ways.

Personality Characteristics
• Strong communication and interpersonal skills.
• Strong critical reasoning and problem-solving skills.
• Detail-oriented and methodical approach to solving problems.
• Enthusiasm for learning and result-oriented.
• Strong work ethic and high degree of integrity.
• Self-starter and ability to work with minimal supervision.
• Willingness to learn new skills and take on new challenges.

Bonus Points BUT not required if:
• You have experience with Analysis Services (SSAS), including but not limited to cube architecture and processing methodologies.
• You have in-depth knowledge and hands-on experience developing, deploying, and maintaining SSIS packages.
• You have work experience in the restaurant industry and/or experience with restaurant (Point of Sale) data.
• You have experience and a solid understanding of partitioning and/or data archiving/purging methodologies.
• You have any Microsoft Certifications for 2005/2008/2012/2014/2016.
• You have knowledge or experience with SSAE/SOC compliance.
• You have experience with JIRA, Github, SQL Sentry Plan Explorer, RedGate SQL Monitor.

Read Full Job Description
Apply now
loading ...
Emailed

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • JavascriptLanguages
    • SqlLanguages
    • AngularLanguages
    • HTML5/SASS/CSSLanguages
    • JS/ExpressLanguages
    • NPMLanguages
    • ReduxLibraries
    • RESTful API'sLibraries
    • Web/Windows ServicesLibraries
    • Service Oriented ArchitectureFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases

Location

Compeat is located in the Domain, close to Rock Rose in the Northside. We're surrounded by retail, hotels, and our passion, bars and restaurants!

What are Compeat Perks + Benefits

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Performance Bonus
Child Care & Parental Leave Benefits
Flexible Work Schedule
Family Medical Leave
Vacation & Time Off Benefits
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Parking
Pet Friendly
Compeat's pet policy is dog friendly daily. Hang out with the coolest pups you've ever met.
More Jobs at Compeat14 open jobs
All Jobs
Finance
Design + UX
Dev + Engineer
Operations
Product
Project Mgmt
Sales
Operations
new
Austin
Product
new
Austin
Operations
new
Austin
Developer
new
Austin
Developer
new
Austin
Design + UX
new
Austin
Operations
new
Austin
Operations
new
Austin
Finance
new
Austin
Developer
new
Austin
Sales
new
Austin