SQL Developer / SQL DBA / Software Support - remote

Posted 3 years ago
Stack Overflow

As a SQL Developer / DBA, you will report to the Chief Technology Officer. Your duties will include:

  • Develop, implement, and optimize stored procedures and functions using T-SQL:
    • Develop procedures and scripts for data migration. (Conversions)
    • Strong forensic data modeling analytical skills.
    • Journeyman experience using programmability tools of Microsoft SQL Server.
  • Analyze, document, and provide guidance on the design and maintain SQL Server databases for company’s commercial products and internally developed applications.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Provide technical support to users and employees. Share expertise, providing technical mentorship and cross-training to other peers and team members.
  • Assist company developers with complex query tuning and schema refinement.
  • Complete projects by coordinating resources and timetables with CTO and users.
  • Work with existing and new systems/programs as needed.
  • Analyze existing SQL queries and indexes for performance improvements;suggest new indexes.
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
  • Prepare written documentation and instructions for users and employees when needed.
  • Review and coordinate with CTO all systems changes and programs prior to their implementation.
  • Speak and present in front of a large group for training and presentation purposes.

Qualifications

  • Two or Four-Year degree in Information Systems or Computer Science is required.
  • Five years or more related experience with MS SQL Server T-SQL and Administration is required.
  • Experience with Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
  • Experience with backups, restores, and recovery models.
  • Experience with High Availability, SQL Mirroring, Azure, and other Disaster Recovery options with MS SQL Server.
  • Experience with Microsoft Windows Server, including Active Directory.
  • Experience using Git, Bitbucket, and Jira highly desirable.
  • Public Safety sector knowledge or experience is highly desirable.
  • Must be a US Citizen and be able to pass an FBI criminal background check, employment, and education history screening.

Knowledge and Other Abilities Required

  • Ability to analyze information.
  • Ability to work effectively both on a team and individually.
  • Ability to communicate effectively both orally and written.
  • Ability to relate business requirements into T-SQL programming and administration duties.
  • Ability to analyze current software and workflow and offer suggestions on improvements to both software and workflow.
  • Knowledge in testing, debugging and maintaining programs to ensure functionality.
  • MCTS, MCITP, and/or MVP certifications a plus.
  • Knowledge of Microsoft Desktop products (Word, Excel, etc.), FTP clients, and working with medium sized datasets in SQL.

Job Type

  • Full time.
  • Work from a home office position requiring fast internet. Home office must reside in one of the following states: California, Illinois, Nevada, Oregon, Utah, or Washington.
  • Some travel required.