SoundThinking is a growing leading edge technology company offering best in class cloud native SAS solutions for law enforcement. In addition to standard Operational tasks such as backup, replication, query optimization and troubleshooting you, as our sole DBA, will be responsible for mentoring and assisting developers as we continue the transition and refactoring of future solutions away from Microsoft MSQL to our standard AWS Postgess/Aurora and NoSQL databases underpinning our SAS offerings in the cloud. As such experience with AWS, Postgress and Microsoft SQL will be essential.

Essential Duties/Responsibilities

 

Database Maintenance:

  • Perform regular database maintenance tasks for both SQL and PostgreSQL, such as backups, updates, and patch installations.
  • Monitor the performance of SQL and PostgreSQL databases and optimize queries for efficiency.
  • Ensure data integrity and security for both SQL and PostgreSQL databases through user access management and encryption.
  • Establish and maintain robust backup and recovery procedures for SQL and PostgreSQL databases to minimize data loss in case of failures.
  • Create and maintain documentation related to database configurations, procedures, and best practices.
  • Database Design, Development, and performance optimization:
  • Collaborate with application developers to design and implement new databases or enhancements to existing SQL and PostgreSQL databases.
  • Optimize database schema and structure for efficient data storage and retrieval.
  • Identify and resolve performance bottlenecks in SQL and PostgreSQL databases.
  • Implement performance-tuning strategies to ensure optimal database performance.

 

Security and Compliance:

  • Implement and enforce security best practices for SQL and PostgreSQL databases, including access control and encryption.
  • Ensure compliance with industry-specific regulations and standards related to data security.

 

Minimum Qualifications

 

  • Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent work experience).
  • Proven experience in database administration and optimization for both SQL and PostgreSQL databases.
  • Full proficiency in SQL queries and tools such as SQL Server Management Studio (SSMS), SQL Profilers, SQL Server Data Tools, SQL Server Reporting Services, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).
  • Experience with AWS and Azure.
  • Experience with NoSQL (Solr, Mongo, Cassandra, Influx) and Redshift a plus.
  • Familiarity with database security best practices and compliance standards.
  • Excellent problem-solving and troubleshooting skills.
  • Familiarity with Prometheus and Grafana is preferred.
  • Knowledge of containerization and orchestration tools like Docker and Kubernetes
  • Effective communication and collaboration skills.
  • Must be able to pass FBI’s CJIS background check.

 

SoundThinking provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, SoundThinking complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

 

SoundThinking expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of SoundThinking’s employees to perform their job duties may result in discipline up to and including discharge. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact SoundThinking at +1.510.794.3183 or careers@soundthinking.com for assistance.

 

The above salary range is based on a good faith estimate made at the time of publication and may be modified in the future. The pay offered to a candidate may vary within this range depending on factors such as education, experience, and geographic location.

 
Note:  The Company reserves exclusive right in its sole discretion to modify, adjust, delete, add or otherwise change the above at any time.

This position has been filled.