This job has expired

SQL Developer

Employer
West Virginia School of Osteopathic Medicine
Location
Lewisburg, WV

View more

Administrative Jobs
Technology, Database Administration
Employment Type
Full Time
Institution Type
Four-Year Institution
You need to sign in or create an account to save a job.

Job Details

Position Title:

SQL Developer

Scheduled Hours Per Week:

37.5

FLSA Status:

Exempt

Job Description Summary:

The West Virginia School of Osteopathic Medicine seeks qualified applicants for a SQL Developer.

The SQL Developer is responsible for designing and implementing database applications across a variety of web platforms and technologies. The position must also write documentation for new and existing software and design application architecture for future expansion and data/business rule centralization. The incumbent is expected to integrate new applications with existing infrastructure and translate requirements into actionable programming projects and finished applications. This position reports to the DBA/Development Manager.

This is a full-time non-classified position with full state benefits and is exempt from FLSA provisions regarding overtime. Base salary for this position is negotiable based on experience and education. Not all activities of this position occur within the confines of an 8:00-4:30 schedule and may require evening and weekend scheduling as needed. The weekly schedule for this position will be established between the supervisor and the employee and approved given the needs of the department and the institution.

This position has been designated as Essential. This means that when WVSOM is faced with an institutional emergency, employees in such positions may be required to remain at their work location or to report to work to protect, recover and continue operations at WVSOM.

West Virginia School of Osteopathic Medicine is an equal opportunity employer and is committed to enhancing diversity among its faculty and staff.

Minimum Education:

Associates

Required Licenses/Certification:

Bachelor’s degree in Computer Science or related field, or Associate’s degree in Computer Science with substituting years of programming experience. A combination of recent and relevant education and experience may also be considered for this position.

Skills Required:

 

  • Knowledge of web and database development including internet protocols.
  • Familiarity with ColdFusion Markup Language and AJAX.
  • SQL scripting and programming in various platforms, detailed analysis and design (Oracle and SQL)
  • Operating system scripting (Windows and Linux environments)
  • Familiarity with web development using html and web scripting languages (i.e. ColdFusion, Java, Bootstrap)
  • Ability to move to newer platforms such as Angular Java as web development environments evolve
  • Background in relational database design, including procedures, functions, views, keys and indexes and the ability to integrate disparate data sources.
  • Programming for mobile applications is a plus
  • Strong analytical and problem-solving skills
  • Self-motivated with the ability to prioritize, meet deadlines, and manage changing priorities
  • Ability to meet deadlines under specific project time constraints
  • Ability to communicate orally and in writing with faculty, staff and students
  • Organization and management skills
  • One to two years of recent and relevant experience in database administration and application development strongly preferred. Preference will be given to those candidates who have experience in an academic environment supporting customized applications.

 

Duties and Responsibilities:

Database and Web Application Development

 

  • Analyze user needs before designing application.
  • Analyze existing database for possible conversion/inclusion in application.
  • Design new databases, including descriptions and diagrams.
  • Modify existing databases, applications, and interface api’s for efficiency and expansion.
  • Design, build web applications including descriptions, diagrams and mock-ups.
  • Test applications and document applications.


Maintenance and Training of Database Systems

  • Modify existing web applications
  • Monitor performance, identifying and resolving issues
  • Troubleshoot problems including procedure, access and security issues
  • Train users (Students and Employees) on operations, function and limitations of applications


Security of Database Systems

  • Ensuring data is clean and handled properly
  • Ensuring permissions on the website, database and within applications are proper for each user
  • Responding to and understanding new vulnerabilities in 3rd party software.


Installation, Configuration, and Maintenance of Support Servers

  • Configure and maintain database software
  • Create and maintain appropriate backup and recovery procedures for databases and SQL servers
  • Install, configure and maintain web server software (Apache 2, IIS, and various Java EE containers) Install, configure and maintain application server software (ColdFusion, Perl, PHP, .NET)
  • Install, configure and maintain 3rd party application software (Track-It!, Jasig CAS)
  • SQL scripting will be the basis for most development, although a thorough understanding of programming logic and good design practice will be expected. The SQL Developer will design, create, debug, maintain, and implement programs that interact with multiple SQL Server databases operating on a Windows Server platform. The SQL Developer will maintain skills essential to programming for procedures, packages, triggers within the database and including operating system shell scripting and web based development tools.
  • It will be necessary for the SQL Developer to learn and gain an understanding of various sub-systems, and provide programming integration and maintenance across all systems. The SQL Developer will be part of the programming team which supports end users in the various departments across campus including Admissions, Financial Aid, Registrar, State-Wide campus, Clinical Evaluation Center and the Business Office. This requires the ability to troubleshoot a variety of complex issues relating to the differing business processes across campus.
  • A major portion of the position will require development of good end-user reporting, data integrity checking, and forms development for custom applications.
  • It is expected that the SQL Developer will perform other related duties as assigned or directed.

 

Open Until Filled:

Yes

Special Instructions:

WVSOM requires official transcripts of your highest degree earned and/or the degree in which qualifies you for the position. WVSOM requires these transcripts prior to an offer of employment, and we do recommend you send those to WVSOM once you have been selected for an interview. A transcript is official if it bears the authorizing signature and the official seal of the issuing institution and is sent directly by the school or college to the Office of Human Resources. Should your college or university provide this information electronically, we would ask that you submit that to Tiffany Burns at [email protected]

Quick Link to Posting:

https://careers.wvsom.edu/postings/2941

Organization

The mission of the West Virginia School of Osteopathic Medicine (WVSOM) is to educate students from diverse backgrounds as lifelong learners in osteopathic medicine and complementary health related programs; to advance scientific knowledge through academic, clinical and basic science research; and to promote patient-centered, evidence based medicine.

WVSOM is dedicated to serve, first and foremost, the state of West Virginia and the special health care needs of its residents, emphasizing primary care in rural areas.

10 REASONS TO CHOOSE WEST VIRGINIA SCHOOL OF OSTEOPATHIC MEDICINE
Because of our outstanding medical education programs. Because of our latest high-tech learning tools. Because WVSOM has a sense of community togetherness and family feeling.

Reason #1: The feel of a small school with a national reputation
Our legacy of excellence has earned WVSOM national recognition for many years as a leader in the nation for family medicine, primary care and rural medicine by the highly regarded U.S. News & World Report. With a passion for providing the best osteopathic medical education, WVSOM fosters the development of caring and compassionate physicians.  WVSOM has also been named by The Chronicle of Higher Education in “Great Colleges to Work For.”

Reason #2: Education is our top priority
At WVSOM, our faculty is dedicated to our principal mission: educating osteopathic students in all areas of medicine. Because we are a free standing program—not part of a larger university—our faculty of nationally and internationally recognized PhDs, DOs and MDs are free to focus on the education of our students. Their passion for teaching and commitment to lifelong learning are the hallmarks of a WVSOM medical education.

Reason #3: Preparing students for primary care and all other specialties
WVSOM is leading the charge to elevate community-based services to a more prominent position in our nation’s health care system. With the firm medical education that we provide, students are well prepared to succeed in any field of medicine they choose to pursue.

Reason #4: Curriculum to maximize learning style
WVSOM presents a 21st century, clinically integrated approach to medical education. In the first two years, students are exposed to a variety of learning modes, including small group case presentations, lectures and laboratory experiences, and interaction with standardized patients and robots. Students learn a variety of clinical skills, and have early clinical encounters with real patients. All of these curricular activities integrate the basic sciences and their application to the patient. During years three and four, through the Statewide Campus System, students spend time in physician offices and hospitals, honing their skills with actual patients.

Reason #5: Our professors
Students at WVSOM have unprecedented access to consult with professors on an individual basis beyond the classroom setting. Open office hours, combined with the fact that most faculty members live in close proximity to campus, ensure that instructors are not just available, but eager to address questions or concerns one-on-one. Teaching is our primary objective, and we understand that learning often happens outside of classroom time.

Reason #6: A holistic approach to healing and emphasis on preventive medicine
The osteopathic philosophy of medicine provides everything students need to become a fully competent, practicing physician with a more holistic approach to the patient. While osteopathic physicians practice traditional medicine and surgery, they also focus on preventive medicine and ways to attain and maintain wellness. An osteopathic medical education provides training in OMM (Osteopathic Manipulative Medicine), a practice where physicians use their hands as another tool to diagnose and treat injury and illness.

Reason #7: Leading edge technology
WVSOM is on the forefront of innovation, providing a cutting-edge medical education. For first and second year students, wireless Internet service envelops the entire campus, ensuring 24/7 access to research sources, classroom materials and a global communications network. Each first year student receives a new, fully programmed laptop computer to utilize during their four years of study. During third and fourth year off-site rotations, students can gain access to testing, grading and evaluation forms, required reading lists and other instructional materials via WVSOM’s secure student portal.

More traditional research needs can be fulfilled in WVSOM’s modern library facility. Consisting of over 33,000 items, the library features current books, literature, scientific journals and access to over 8,000 full-text e-journals. Of special note is the osteopathic history collection and a unique index of over 23,000 osteopathic articles. The library also provides comfortable space for individual and group study with computer workstations, AV study rooms and individual cubicles.

Reason #8: Human patient simulators (robots) put real-life scenarios in students' hands
Students at WVSOM utilize human patient simulators to confront and treat real-world patient situations in a safe, controlled clinical training environment. These full-size, interactive, computerized mannequins can provide real-life simulations of more than 80 medical conditions, allowing for many different kinds of training scenarios.

With their life-like exterior and hi-tech internal components, WVSOM’s  patient simulators provide an incredibly realistic training experience for students.

With the robots, failure does not mean a bad grade; failure means a patient dies. This visceral experience enhances the learning experience and makes a lasting impression.

Reason #9: World-class anatomy lab offers hands-on learning environment
The study of human anatomy is a core component of the nationally recognized osteopathic medical education program at WVSOM. Our advanced anatomy lab features state-of-the-art equipment and ventilation systems, along with a multipurpose anatomy demonstration room to enhance the learning experience. This tactile learning environment offers a level of hands-on exposure to the human anatomy in a sterile and controlled environment that no simulator or model can provide.

Reason #10: Standardized patients training
In the medical field, effectively communicating with the patient is critical to acquiring complete medical histories, performing thorough physical exams and accurately diagnosing and treating the whole patient. In a simulated and controlled environment, actors portray patients with a specific set of medical issues and symptoms. Students must complete a comprehensive physical examination on the patient. This experience provides an invaluable opportunity to practice interview skills and develop a compassionate bedside manner.

Find Us
Website
Telephone
8003567836
Location
400 Lee Street North
Lewisburg
WV
24901
US
You need to sign in or create an account to save a job.

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert