Database Administrator/Developer

SmartCop is seeking a Database Administrator to join their team!  As a Database Administrator, you will be responsible for managing and maintaining our database systems to ensure optimal performance, security, and reliability.

You will work closely with our customers and internal teams to solve complex technical issues and provide exceptional support. This role involves partnering with public safety agencies and first responders to ensure their data needs are met efficiently and securely.

What You’ll Do:

• Manage and maintain database systems, including replication, triggers, jobs, and more.
• Troubleshoot and resolve technical problems related to database performance, security, and availability.
• Develop and implement database solutions to meet customer needs and business requirements.
• Create and maintain interfaces between disparate databases to ensure seamless data integration.
• Data analysis: Knowledge of data analysis techniques to extract insights from data.
• Perform data migrations and ensure data integrity during the process.
• Monitor database performance and optimize queries for efficiency.
• Partner with development teams to design and implement database schemas, stored procedures (SPS), and other database objects.
• Ensure database security and compliance with industry standards and regulations.
• Provide technical support and training to customers and internal teams.
• Work with public safety agencies and first responders to know and address their unique data requirements.

What We’re Looking For:

• Proven experience as a Database Administrator or similar role.
• Excellent knowledge of database management systems (DBMS) and SQL.
• Experience with database replication, triggers, jobs, and data migrations.
• Proficient in troubleshooting and resolving technical database issues.
• Familiarity with stored procedures (SPS) packages and creating/maintaining database interfaces.
• Excellent problem-solving skills and attention to detail.
• Effective communication and customer service skills.
• Ability to work autonomously and as part of a team.
• Bachelor's degree in Computer Science, Information Technology, or a related field (preferred).

Technical Skills:

• Proficiency in T-SQL with the ability to develop complex SQL queries to retrieve, manipulate, and analyze data from databases.
• Experience with database performance tuning and optimization.
• Knowledge of database backup and recovery procedures.
• Familiarity with cloud database services (e.g., AWS RDS, Azure SQL Database).
• Experience with NoSQL databases (e.g., MongoDB, Cassandra) is a plus.
• Expertise of data warehousing and ETL processes.
• Knowledge of database security best practices.
• Experience with database monitoring tools (e.g., Nagios, SolarWinds).
• Familiarity with scripting languages (e.g., Python, Bash) for automation tasks.
• Knowledge of Agile methodologies and DevOps practices.

What We Offer:

• Comprehensive Medical, Dental, and Vision benefits starting from your first day of employment
• Employee stock ownership and RRSP/401k matching programs.
• Lifestyle rewards
• Paid time off
• Remote work opportunities and more!

Who We Are:

SmartCOP has provided public safety software solutions to municipal, county, and state agencies for over 25 years. With 185+ customers across the country, we are 100% focused on Public Safety. SmartCOP is a financially sound division of N. Harris Computer Corporation.