SQL Developer / SQL DBA / Software Support
Posted on StackOverFlow on Mar 23, 2021

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.

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Jack Henry and Associates
Featured
6 d ago
RYAN Consulting Group (RCG)
23 d ago

More jobs by this company