OnHand Schools Home

Data Base/Programming Position

Description:

  • Monitor automated processes and troubleshoot any issues.
  • Perform database programming for new and existing systems.
  • Create or modify ETL stored procedures for client data manipulation.
  • Troubleshoot data issues with client data.
  • Retrieve and integrate information from various data sources.
  • Make and receive phone calls from clients regarding support issues.
  • Write and respond to emails to and from clients regarding support issues.
  • Work in a project based environment using SQL and C# HTML, JavaScript and ASP.NET to complete various tasks

Skills/Qualifications:

  • Strong experience in Database Administration in SQL Server (2005 and 2008).
  • SQL skills – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints )
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands.
  • Strong knowledge of how indexes and index management work. How statistics work, how indexes are stored, how they can be created and managed effectively.
  • Solid acquaintance with windows server OS and network basics.
  • Documentation skills for processes and procedures.
  • SQL Database Operational support to tech users.
  • Customer service skills for direct client contact.
  • Familiar with coding in C#.
  • Familiar with web programming in HTML, JavaScript and ASP.NET.
  • Understanding of basic industry accepted Security Policies.

If you have any questions or would like to submit your resume for consideration, please contact us via email to careers@onhandschools.com.