Under the direction of the Director of Information Systems, the Senior Programmer Analyst leads/assists with the design and development of production applications, works with the user community and/or reviews existing specs and assists with providing appropriate Information Technology solutions to business needs, and perform programming and systems analysis tasks in support of the University-wide information system: Responsible for the administration and programming needs for Great Plains, PowerCampus, PowerCampus Self-Service, PowerFAIDS and SSRS; plans, conducts, and coordinates specialized programming application activities and supports vendor supplied and in-house systems; writes business applications computer software that contains logical and mathematical solutions to business problems or questions in specialized processing/programming environments; writes programs in the specialized MS SQL Server environment for a solution; modifies and tests programs in the development environment for release to production; coordinates with Quality Control in final resolution of issues and production release of programs; install and test any necessary upgrades and/or patches for those applications; monitor each application for stability and availability maintain documentation related to any programming processes related to each; responsible for the administration and maintenance needs across multiple SQL Servers instances; create and maintain SQL Server databases along with all associated tables, views, stored procedures along with the assigning of the appropriate permissions; create and maintain packages utilizing SQL Server Integration Services (SSIS); create VB scripts or PowerShell scripts for task automation.
Regionally accredited Bachelor’s degree in computer science required, and/or equivalent of combined education and experience. 4-6 years of direct programming experience and expertise in programming language or operating system concepts. Experience with Windows XP, Windows 7, Windows Server 2003 required; knowledge of Transact-SQL (T-SQL) for procedural programming; knowledge of SQL Server Management Studio – version 2005 forward, SQL Server Reporting Services (2005, 2008 R2), SQL Server Integrations Services and Transact-SQ; knowledge of Microsoft Visual Studio integrated development environment - version 2005 forward; working knowledge with Microsoft Office Suite; excellent analytical, technical and planning skills; knowledge of Microsoft Office – Access, Excel, Word and VBA; and ability to communicate to users with all levels of experience.
Open unitl filled
Commensurate with experience
Send Resumes to:
Charles R. Drew University of Medicine and Science
Department of Human Resources
1731 E. 120th Street
Los Angeles, CA 90059
Fax: (323) 563-5946
Charles R. Drew University of Medicine and Science - 16 months ago