"Alerted.org

Job Description

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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and 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. - 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.