Emprise Corporation is a fast-growing company that has been serving government and commercial clients for over 38 years. Emprise is the industry leader in Predictive Maintenance and Condition Monitoring by offering a wide set of capabilities that allow us to provide premier products and services that help our clients operate more effectively and efficiently. We are looking for a talented and highly skilled Database Developer to join our team on a full-time, permanent basis. The successful candidate will be responsible for designing, writing, and optimizing database views, stored procedures, and functions to support and extend our existing database schema. This role requires advanced proficiency in ANSI SQL, strong knowledge of transaction control, and the ability to contribute to the stability and performance of mission-critical systems.

Key Responsibilities:
- Design, develop, and maintain database views, stored procedures, and functions using advanced ANSI SQL.
- Support and enhance the existing database schema to meet evolving business needs.
- Implement and manage transactional control to ensure data consistency and integrity.
- Collaborate with software engineers, analysts, and business stakeholders to gather requirements and deliver SQL solutions.
- Perform query tuning and optimization for scalability and performance.
- Ensure proper documentation of database objects, procedures, and standards.
- Provide input into database design improvements and schema evolution strategies.
- Support operational stability by participating in database reviews, testing, and monitoring.

Requirements:
- Advanced expertise in ANSI SQL with demonstrated ability to write complex procedures, functions, and queries.
- Solid understanding of transaction control (BEGIN, COMMIT, ROLLBACK) and concurrency management.
- Strong knowledge of database development best practices including normalization, indexing, and data consistency.
- Experience with one or more enterprise RDBMS platforms (e.g., SQL Anywhere, IBM DB2, MariaDB, SQL Server, MySQL).
- Excellent problem-solving and debugging skills with attention to detail.
- Strong communication and collaboration abilities in a team environment.
- Bachelor’s degree in Computer Science, Information Systems, or equivalent professional experience.

Preferred Qualifications:
- Experience with database performance optimization and diagnostic tools.
- Familiarity with replication technologies and high-availability database environments.
- Exposure to database design, data modeling, and ETL processes.
- Knowledge of DevOps practices for database deployment and version control.
- SQLite experience is a plus.