Job details
Salary $55,000 - $65,000 a year job type full-time
Qualifications
Sql: 1 year (preferred)
Data warehouse: 1 year (preferred)
Us work authorization (preferred)
Benefits pulled from the full job description
401(k) dental insurance health insurance paid time off vision insurance
Full job description
Retail-based software development firm seeking a sql server developerRetail backbone (www.retailbackbone.com) is a web application designed to integrate ecommerce and brick/mortar operations for online retailers such as moosejaw mountaineering (www.moosejaw.com)We are looking for a reliable, experienced sql server developer to help with existing project work as well as develop new features and architecture for our evolving frameworkResponsibilities will include traditional t-sql coding of stored procedures, sql reporting, ssis and clr integration.
Work from anywhere: our existing team of developers are spread out throughout the country, and all development meetings are conducted via web conference, so location is not an issue - you can work from home, a coffee shop, or on the beachIf you have a laptop, reliable internet connection and the talent - we are interested.
In this position, you will be responsible for full life-cycle development in a fast-paced environment, implementing solutions in microsoft sql server 2014, enterprise editionWorking under the general supervision of a senior sql dba/developer will provide enterprise-level database support for all client databasesDba will be responsible for installing, configuring, and maintaining database environments, evaluating and installing patches and monitoring scheduled database backups and recoveryThe dba will also work closely with the development team as well as directly with the clients to address all issues related to database design and code implementation.
Technical skills:
Classroom or on-the-job experience in database administration, development and support in enterprise database environments (sql server).
Experience in troubleshooting and resolving data integrity issues, performance issues, blocking and deadlocking issues, connectivity issues and security issues.
Experience in performance tuning, query optimization, using performance monitor, sql profiler and other related monitoring and troubleshooting tools.
Knowledge of sql server tools (profiler, dta, ssms, sac, sscm, perfmon, dmvs, system procedures).
Knowledge of database backups/restores, recovery models, database shrink operations, clustering, disaster recovery.
Knowledge of indexes, index management, integrity checks, configuration, and patchingKnowledge of how statistics work, how indexes are stored, and how indexes can be created and managed effectively.
Documentation skills for processes and procedures (creating knowledge base articles, data maps, etc ).
Ability to provide system administration support in a windows 2012 environment.
Capable of managing responsibilities independently.
Excellent time management and organizational skills.
Must be accountable, organized, innovative and motivated; job requires detailed logging of all project work for billing and knowledge base.
Excellent oral and written communication and interpersonal skills.
Job skills:
Design and document database architecture including tables, views, triggers, indexes, constraints, users, permissions, etc…
Write and troubleshoot complex t-sql code including optimized stored procedures and user-defined functions.
Development and implementation of reports and extended stored procedures using sql server reports and clr
Analyze, consolidate and tune databases for optimal efficiency.
Work with development team to tune sql queries.
Provide solutions to development teams when proposed solutions do not comply with architectural, configuration, performance, or security guidelines.
Implement and enforce database security based upon best practice, sox regulations, and company policies.
Proactively monitor database performance and identify potential issues prior to actual performance degradation.
Occasional evening and weekend work to perform maintenance and upgrades, and emergency troubleshooting.
Provide after-hours support as required in critical situations.
Salary range: $55k-$65kIn addition to our generous starting salary, we also offer flexible scheduling, telecommunication reimbursement, and paid time-off.
Job type: full-time
Pay: $55,000.00 - $65,000.00 per year
Benefits:
401(k)
Dental insurance
Health insurance
Paid time off
Vision insurance
Schedule:
8 hour shift
Monday to friday
Experience:
Sql: 1 year (preferred)
Data warehouse: 1 year (preferred)
Work location: remote
Hiring insights
Hiring 1 candidate for this role
Job activity
Employer reviewed job 3 days ago
Posted 21 days ago
