The SQL Developer serves within the development team for long-term projects. This is an entry-level position. This position will analyze and produce interfaces relative to the institutional needs for student information and faculty/staff administration within the SQL Server databases. This position shall provide consulting and technical assistance while interacting with other developers/programmers in IT Department and is a critical source for end-user analysis of programming needs. The position will conceive, plan, develop, implement and support database applications for WVSOM in general with concentrations in baseline and custom SQL database systems as applicable. The incumbent will serve as backup to primary IT staff responsible for institutional dashboard. This position reports to the Banner DBA/Development Manager.
General Duties and Responsibilities
Database and Web Application Development
SQL programming and database development/design including interactive web and mobile web design.
Analyze user needs before designing application.
Analyze existing database for possible conversion/inclusion in application.
Modify existing databases, applications, and interface api's for efficiency and expansion.
Test and document applications, including Standard Operating Procedures
Interface analysis/design/development for internal/external 3rd party applications
Packages, functions, procedures within SQL server databases and with exposure to the Oracle SQL Banner database relative to the institutional dashboard
Assist in query building for the dashboard as a lead for the Reporting and Data Administrator
Resource and support role for the Reporting and Data Administrator in producing reports to the various campus and external entities (Departmental directors, WVSOM statistician, WV Higher Education Policy Commission and the CTO for IT audit requests).
Assist the Reporting and Data Administrator maintain the appropriate web interface, security roles, and data queries for the institutional dashboard from various points (i.e. multiple databases and historical reports).
Utilization of various reporting tools for SQL and Oracle databases
The positon will install, configure and maintain database software (SQL Server), web server software (Apache, IIS) and application server software (Groovy/Grails, ColdFusion, Perl, ASP.NET)
Maintenance and Training of Database Systems
Modify existing web applications
Monitor database 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 (SQL Server)
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 as the basis for most development, with good design practice and program logic. The SQL Developer will design, create, debug, maintain, and implement programs that interact with multiple SQL Server databases operating on a Windows Server platform including procedures, packages, triggers within the database, operating system shell scripting and web based development tools.
Understanding of various sub-systems, and provide programming integration and maintenance across all systems. The SQL Developer will be part of the programming team that supports end users in the various departments across campus including Admissions, Financial Aid, Registrar, Statewide 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.
The SQL Developer will support programming in relation to the custom databases and their integration with Oracle in a Linux environment. This will require close collaboration with other SQL, Oracle and Web developers. A major portion of the position will require development of good end-user reporting, data integrity checking, and forms development for custom applications.
The SQL Developer will perform other related duties as assigned or directed.
This is a full-time, non-classified position; it is exempt from FLSA regulations concerning overtime; salary is commensurate with education and experience, plus a full state benefits package.
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.
Applications will be accepted until the position has been filled. Final candidates are subject to employment and credential verification, reference and background checks. All applications are confidential.
West Virginia School of Osteopathic Medicine is an equal opportunity employer and is committed to enhancing diversity among its faculty and staff.
Education: Bachelor’s degree in CS or related field, or Associate’s degree in CS with substituting years of programming experience.
Required Experience: Expertise in SQL programming; 2 years or equivalent combination of education and experience
Skills Required A combination of recent and relevant education and experience may also be considered for this position.
Knowledge of web and database development including internet protocols.
Excellent background in relational database design, including procedures, functions, views, keys, indexes and the ability to integrate disparate data sources.
SQL scripting and programming in various platforms
Ability to move to newer platforms such as Angular Java as web development environments evolve
Utilization of editing tools (Eclipse, Vi, Nano)
Strong analytical and problem solving skills.
Strong written and oral communication skills, and the ability to collaborate with all levels of the institution regarding projects and programming.
Self-motivated with the ability to prioritize, meet deadlines, and manage changing priorities
Ability to communicate orally and in writing with faculty, staff and students
Organization and management skills
Must be able to work independently as well as part of a team.
Additional Salary Information: Commensurate with education and experience
The West Virginia School of Osteopathic Medicine is a free-standing medical school nestled in the Allegheny Mountains. WVSOM is located in "America's Coolest Small Town" (Budget Magazine 2011) just minutes from the famed Greenbrier® Resort, a Five Diamond hotel and spa and host of the PGA’s annual Greenbrier Classic. WVSOM brings over 40 years of history serving the health and wellness needs of th...e Greenbrier Valley, the state of West Virginia and beyond. The school’s small-town, rural community cherishes its connection with the college and our students are actively engaged in service outreach and support for over 40 non-profit organizations in this area. Additionally, WVSOM faculty and staff enjoy a vibrant cultural community which features one of only four operating Carnegie Halls in the world, as well as the state professional theatre of West Virginia. Throughout the year, employees can enjoy live plays and musicals, a broad representation of visual artists, an annual chocolate festival, a flourishing literary series, and live music events within a historic preservation area featuring 19th century architecture, unique shops and dining, and limitless outdoor recreation. This one-of-a-kind environment brings together farmers and artists, lumbermen and world-renowned musicians, holistic physicians and thrill-seeking whitewater rafters in a diverse melting pot that is truly unique!