Sr. SQL Developer (Remote)

Published date Posted on Indeed on Jan 10, 2022 (13 d ago)
Developer
Nashville, TN - Remote opening, full-time, no corp-to-corp
  • Market based rate, competitive salary, good benefits

Candidate Attributes:
  • Prior experience working directly with executive-level and customer-facing.
  • Has developed documentation including: diagramming for process flow/logic and data relationships, engineering notes, user guides.
  • Prior experience required with at least some of the following languages:
    • Python, MySQL or Aurora, Oracle PL/SQL, T-SQL, CCL (Cerner Command Language), C / C++, Git
  • Prior experience required with:
    • Object-oriented programming concepts, including SOLID concept.
    • Class-based variables / objects, and object naming conventions.
    • Development of subroutines / subordinate program objects to carry out atomic functions.
    • Software architecture design and documentation.
    • Testing methodologies (positive and negative conditions), and testing phases (unit, regression, system, and integrated testing).
    • Development and management of server-based software (e.g. no user interface, running on Linux platform interacting directly with RDBMS and in-memory data processing).
    • Strong data analysis and relational data concepts including: string comparisons and manipulation, numeric operations (arithmetic, rounding, overflow and divide by zero errors), foreign key / primary key / composite and polymorphic keys, handling null values, sorting, iterative and hierarchical processing, grouping / aggregation, subqueries, data validation and discovery via query, data analysis tools like Excel (including functions, filtering, pivots, PowerQuery).
    • Linux commands and shell scripting including common Linux utilities for file inspections (e.g. head, tr, grep, awk, etc).
    • Data encryption / decryption using SSL in Linux.
    • Regular expressions.
    • Basic Oracle db manipulation skills (e.g. creating tables, keys, constraints, indexes, views, inserts/updates).
  • Has practical experience with setting up and managing code repositories, performing code diffs, code reviews, alignment with feature requests, writing documentation.
  • Has and can manage work tasks using project management concepts and AGILE methodology.
  • Pref prior experience or willingness to learn on:
    • PHP, JavaScript, Wordpress framework.
    • Healthcare data concepts and nomenclatures, particularly around patient accounting and billing, quality measures, common clinical terms.
    • Cerner Millennium back-end platform or similar (e.g. Soarian, Epic, Meditech, Allscripts).

About the Job
  • Job will report to the CEO / owner of business (since he is also the chief developer), however the position will be largely self-managing and self-supervising and coordinate with the client-facing staff (project manager, implementation specialist, and support specialist) and with existing web development team (php/JS/MySQL/WP developer).
    • Candidate should demonstrate their ability to self-motivate, and an eagerness to expand their knowledge base and capabilities in an open work environment with direct access to clients and executives.
    • Traits we’d look for:
      • if a term is mentioned you don’t know, you look it up on google or Wikipedia.
      • You already have a list of online references for coding concepts and technical references (e..g ASCII chart, linux and oracle syntax, etc).
      • You already subscribe to continual skill development like LinkedIn Learning (formerly Lynda.com), Wondrium (formerly The Great Courses), Brilliant, or similar online self-development courses.
      • You seek to understand the business requirements (not just the logical requirements) for the projects you code.
  • Role will be coding primarily in CCL (a proprietary middleware language for Cerner Millennium platform) and CEO can provide all necessary training. However, the bulk of code is already written so plenty to read and learn from already. Immediate ability to code in CCL not required, but to immediately organize and prioritize code diffs, detect differences, design a new overall software architecture and process, and begin aligning and testing code accordingly.
  • Tools we use: Dropbox, Slack, Zoom, LucidChart, Trello, Office 365, BeyondCompare, Navicat, Citrix, HelpScout, HubSpot, WordPress.
  • You can use Windows or Mac; we work on both platforms.
  • Position is “work-from-home” however periodic in person meetings (~every 2 weeks) will be required in Nashville area.
  • Travel is not anticipated except for work sessions in Nashville.
  • Position may work any time of day/night/weekend, however must be available for meetings as needed with team members during normal working days/hours. Occasional off-hours work may be required to fulfill mission-critical issues or code deployments / issues arising outside normal work hours (rare).
  • Ordinary work commitment is anticipated ~40-44 hours / week.
  • Initial commitment is 6 months, with 6 month renewals thereafter (2 months in advance). Expect minimum 2 years run time for this position, dependent on candidate’s ability to excel.
  • Position can lead to leadership position within company with future growth, and/or profit-sharing / equity.
  • Pay structure: 1099 contract role. Medical coverage available. Unlimited time off.

Project Goals
  • Current Goal: free up the CEO from being chief developer so he can further develop sales and products to grow the company.
  • Specific projects:
    • Code Overhaul
      • Alignment across clients, deprecation of old functionality, introduce new functionality where required, performance improvement, coding standards (hygiene), standardized logging. Overall: reduce dependence on chief developer, improve run time and efficiency, more agile for future interfaces, decrease cost to maintain.
    • Develop purge process for data and files
  • Future Goals:
    • New feature and product development
    • Custom work per client

Next Steps
  • Expect 2 interviews: 1 for initial questions, discussion. 2 for discussion of hypotheticals:
    • We ask each other questions: you about the job, company, product, opportunity, etc; us about your background, interests, skills, experience.
    • You show examples of your prior coding and documentation so we can see your organization skills and how you outline complex projects, commenting, repositories, documentation.
    • We show you our code environment, example code, current documentation, demo of software, our customer’s user experience.
    • You provide outline of how you’d spend first 30 and 90 days of job. What you’d want to learn about first, how you’d organize your work, how you’d communicate with us, how you’d report deliverables completed.
    • You tell us your concerns / risks, benefits / upsides, and what additional things you’d want to be successful in the role.
  • Ultimately, this process should indicate for us both that we both are interested in the opportunities each presents to the other.
  • Position will begin as soon as we’ve identified a mutual match.
  • Due to the nature of the confidential material from both sides, we may ask for you to sign a mutual NDA that protects our respective IP.

Questions
  • Have you ever worked from home full time (pre-COVID)?
  • Have you ever worked directly for a C-level or CEO?
  • Have you ever worked for a small company (< 20 employees)?
  • Describe your home office. Looking for appropriate investment and conscientiousness toward productivity and effectiveness.
  • Describe how the onboarding process would work. TBD
  • What are the major milestones of the project? In what sequence? (e.g. logging, performance, subroutines, purging, code diffs, customizations / prefs / deprecations, CCL training)
    • Seek their priority and timeline of these items.
  • How will I know if they’re successful or not working out (at 1 / 2 / 4 / 8 weeks)? What will success look like to me?

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

There can be a lot of pressure that comes with a new year. New workout routine, new goals, and if you’re here reading this, perhaps a new job. Oh, and apparently a new variant. Take a second away from your gym selfie-filled Instagram feed and hear us out: Being in the beaut

General Dynamics Information Technology General Dynamics Information... |
|
2 d ago

Travel Required: NonePublic Trust: BI Full 6C (T4)Requisition Type: RegularGDIT, a Federal marketplace leader in next-generation IT solutions and services, is seeking highly qualified and motivated IT professionals like you who are eager to contribute to our critical Homeland Sec

Nelnet is a student loan servicer that's grown into a fiber internet pioneer, real estate investor, and software provider. But that's just the beginning. With 6,500 associates and growing, we take our business wherever superior customer experiences and ingenuity are needed.The pe

Aspect Software Aspect Software |
|
3 d ago

Alvaria employs a team of passionate individuals who are changing the face of customer engagement. Over our 40-year history we have empowered employees by creating an inspired community that values Urgency, Accountability and Results. Our ability to think big has enabled us to co

Piper Companies Piper Companies |
|
5 d ago

Piper Companies is seeking a Manager of Data Engineering for a growing technology driven organization. The Manager of Data Engineering role is a 100% remote role that can reside anywhere in the United States. The Manager of Data Engineering will be working with a team primarily b

More jobs by this company

Python Integration EngineerDirect Hire, 100% Remote60-75K / yearREQUIREMENTS:Two or more years of API development and Python experience are requiredPREFERRED:Two (2) or more years of software development experience, IBM B2Bi preferred.Two (2) or more years of database development

Integration Engineer IIDirect Hire, 100% Remote60-65K / yearREQUIREMENTS:Two or more years of API development and Python experience are requiredPREFERRED:Two (2) or more years of software development experience, IBM B2Bi preferred.Two (2) or more years of database development exp

Sr. SQL Developer (Remote)Remote opening, full-time, no corp-to-corpMarket based rate, competitive salary, good benefitsCandidate Attributes:Prior experience working directly with executive-level and customer-facing.Has developed documentation including: diagramming for process f

Integration Engineer IIDirect Hire, 100% Remote70-80K / yearREQUIREMENTS:Two or more years of API development and Python experience are requiredPREFERRED:Two (2) or more years of software development experience, IBM B2Bi preferred.Two (2) or more years of database development exp

Integration Engineer IIDirect Hire, 100% Remote70-80K / yearREQUIREMENTS:Two or more years of API development and Python experience are requiredPREFERRED:Two (2) or more years of software development experience, IBM B2Bi preferred.Two (2) or more years of database development exp