"Alerted.org

Job Description

The Database Engineer III plays a critical role in database programming, application/operations support, issue resolution, documentation, and departmental support. This position ensures optimal database performance through query tuning, debugging, and data maintenance while collaborating closely with Business Systems Analysts and cross-functional teams. Responsibilities include designing and developing database solutions, supporting production data modifications, analyzing and optimizing database structures, and participating in software project meetings. Additionally, this role requires a deep understanding of functional requirements, software engineering best practices, and data mapping. The engineer will work across Oracle, SQL Server, and PostgreSQL environments, focusing on data provisioning, retention policies, and anonymization techniques. While not a data modeler, they will have strong experience in ETL processes and database interfacing. As a guiding force in database management, they will drive discussions, analyze data, and develop mapping documentation while engaging in operations such as user provisioning and production data management.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, 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 Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .

To 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

- Strong expertise in Oracle database and either SQL Server or PostgreSQL databases

- Proven experience in query performance tuning and debugging

- Ability to read, write, and optimize SQL procedures, functions, triggers, and stored logic

- Hands-on experience in data mapping, retention policies, and maintenance

- Strong ETL and database interfacing experience

- Thorough knowledge of indexing, triggers, packages, and query plan optimization - Experience with Python scripting or ETL pipelines

- Familiarity with partitioning and sharding database objects

- Exposure to data provisioning with masking and anonymization

- Understanding of PBM (Pharmacy Benefit Management) business models and pharmaceutical industry practices

- Strong ability to work in cross-functional global teams and participate in high-level technical discussions null

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 employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to 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 oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].