SmartCop is seeking a Database Administrator to manage and maintain their database systems for optimal performance, security, and reliability.
Requirements
- 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.
- 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.
- Familiarity with cloud database services (e.g., AWS RDS, Azure SQL Database)
Responsibilities
- 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.
- 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.
Other
- 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.
- Bachelor's degree in Computer Science, Information Technology, or a related field (preferred)
- Effective communication and customer service skills.
- Ability to work autonomously and as part of a team.
