Dofactory.com
Dofactory.com

Database Developer – MS SQL Server

Company
Purple Communications
Location
United States
--
Remote
Pay
$85,000 / Year 
--
Fulltime
Level
Senior level
Skills

Job Description

Database Developer – MS SQL Server

Purple Communications is one of the nation's most extensive communication services for the deaf and hard-of-hearing communities. As a leading provider of onsite interpreting services, video relay service, and video remote interpreting, the Company delivers a wide array of options designed to meet the unique communication needs of its customers. Please view our website: www.purplevrs.com.

Purple Communications' vision is to provide high-quality services with innovative products that break down communication barriers for its customers. We strive to change the game because we believe communication access is a right worthy of utmost respect and because every conversation matters.

We are experiencing tremendous growth and are looking to add strong expertise to our world-class teams!

Database Developer – MS SQL Server Job Responsibilities:

The Database Developer- MS SQL Server is responsible for developing and maintaining ETL, and TSQL queries and stored procedures to support the Applications development and Business Intelligence teams primarily using Microsoft SQL Server and some mySQL Server databases.

  • Develop and Maintain TSQL Queries and Store Procedures
  • Gather requirements, create technical design, document and implement solutions to satisfy business and development needs
  • Develop and maintain solutions using SSIS, specifically ETL operations
  • Maintain and support Data Warehousing and Data Cubes for use by the Data Analysts
  • Trigger and View development
  • Supporting the Production IT team when application-related issues arise

Database Developer – MS SQL Server Qualifications / Skills:

  • Working in a Software Development Lifecycle (SDLC) environment and using related tools
  • Use of version control (SVN or other tools / methodologies)
  • Defining and utilizing data warehouses and dynamic reporting (including but not limited to data modeling, ETL architectures, OLAP, drillable reports, star/snowflake schemas, etc)
  • Dealing with database performance and scaling issues
  • Familiarity with NoSQL databases like MongoDB, Cassandra, and/or CouchDb
  • Using of SCRUM and Agile methodologies for iterative software development
  • Advanced problem-solving and analytical skills
  • Ability to quickly understand business requirements and transform user requirements into queried reports / stored procedures
  • Excellent written and verbal communication skills, with the ability to clearly explain technical issues to a non-technical audience
  • Exceptionally detail-orientated and able to cross-check work to user specifications
  • Proficient in working independently—with little direction—and as a supportive team member
  • Accustomed to fast-paced environments with simultaneous, high-priority tasks
  • Must be capable of performing in a dynamic environment, handling multiple tasks simultaneously with the ability to work on multiple projects at any time
  • Handle after-hour production deployments

Education and Experience Requirements:

  • Bachelor’s Degree in Computer Science, Information Technology or equivalent Industry experience required
  • 8+ years of TSQL work (very strong knowledge of stored procedures, queries, joins and user-defined functions)
  • Experience with database design best practices, including normalization, query optimization, referential integrity and logical database architecture
  • Willingness to learn ASL and deaf community
  • Regulated industries work such as telecommunications, finance or related businesses

Work environment:

Employees may experience the following physical demands for extended periods of time:

  • Sitting, standing and walking (95-100%)
  • Keyboarding (40-60%)
  • Viewing computer monitor, videophone, and cell phone (40-60%)
  • Lifting computers and other equipment.
  • Position may require some travel.

Disclaimer:

The above information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to this job. Employees are expected to follow their supervisor's instructions and to perform the tasks requested by their supervisors.

Note: This job description is not intended to be all-inclusive. Employee may perform other related duties as assigned to meet the ongoing needs of the organization.

Purple Communications is an Equal Opportunity Employer. Principals Only

Job Type: Full-time

Pay: From $85,000.00 per year

Benefits:

  • 401(k)
  • 401(k) matching
  • Dental insurance
  • Employee assistance program
  • Health insurance
  • Life insurance
  • Paid time off
  • Professional development assistance
  • Referral program
  • Tuition reimbursement
  • Vision insurance

Experience level:

  • 8 years

Schedule:

  • Monday to Friday

People with a criminal record are encouraged to apply

Application Question(s):

  • What is your skill level with gathering requirements from non-technical resources on a scale of 1 - 5, 5 being the highest level?
  • What is your skill level with MicroSoft SQL Server Integration Services(SSIS) on a scale of 1 -5, 5 being the highest.
  • Are you willing to be part of an on-call team? Yes or No?
  • Are you able to participate in overnight deployments? Yes or No?

Experience:

  • MySQL: 6 years (Preferred)
  • Creating Complex CRUD for MS SQL: 3 years (Preferred)

Ability to Relocate:

  • Remote: Relocate before starting work (Required)

Work Location: Remote

Benefits

  • 401(k)
  • 401(k) matching
  • Dental insurance
  • Employee assistance program
  • Health insurance
  • Life insurance
  • Paid time off
  • Professional development assistance
  • Referral program
  • Tuition reimbursement
  • Vision insurance
  • 8 years
  • Monday to Friday
  • What is your skill level with gathering requirements from non-technical resources on a scale of 1 - 5
  • 5 being the highest level?
  • What is your skill level with MicroSoft SQL Server Integration Services(SSIS) on a scale of 1 -5
  • 5 being the highest.
  • Are you willing to be part of an on-call team? Yes or No?
  • Are you able to participate in overnight deployments? Yes or No?
  • MySQL: 6 years (Preferred)
  • Creating Complex CRUD for MS SQL: 3 years (Preferred)
  • Remote: Relocate before starting work (Required)
 
Ref #
2758028
Posted
30+ days ago
  •  
Last updated 30+ days ago


Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.