Summary: The SQL Developer Senior 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.
Duties & 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 (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 will be the basis for most development, although a thorough understanding of programming logic and good design practice will be expected. The SQL Developer Senior will design, create, debug, maintain, and implement programs that interact with multiple SQL Server databases operating on a Windows Server platform. The SQL Developer Senior 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 Senior to learn and gain an understanding of various sub-systems, and provide programming integration and maintenance across all systems. The SQL Developer Senior 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.
The SQL Developer Senior will support programming in relation to the custom Clinical Education databases and their integration with Oracle. 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.
It is expected that the SQL Developer Senior will perform other related duties as assigned or directed.
A combination of recent and relevant education and experience may also be considered for this position.
Extensive knowledge of web and database development including internet protocols.
Expertise in ColdFusion Markup Language and AJAX.
SQL scripting and programming in various platforms, detailed analysis and design
Operating system scripting (Windows and Linux environments)
Familiarity with web development using html and web scripting languages (i.e. ColdFusion)
Ability to move to newer platforms such as Angular Java as web development environments evolve
Excellent 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
Education: Bachelor’s degree in CS or related field, or Associate’s degree in CS with substituting years of programming experience.
Experience: Two to four 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.
Position: 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.
About West Virginia School of Osteopathic Medicine
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 the 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!