SQL Developer Senior
SQL Developer Senior
Reports to: DBA/Development Manager
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.