Reporting Platform:
Responsibilities:
- Implement complex queries and stored procedures to support REST APIs and batch rollups of reports data for customer organizations.
- Writing, designing, testing, implementing, and maintaining database applications/procedures using SQL or other database programming languages.
- Resolve performance issues, performance tuning of database systems, queries, indexing.
- Manage and create data import and export processes (ETL) into the databases and create and manage data integration scripts using file transfers, API calls, and/or other methods.
- Provide support for systems architecture for Reporting Platform.
- Setting up Monitor Dashboards and Alerts using DataDog to proactively catch issues.
- Diagnose and troubleshoot database errors.
- Create automation for repeating database tasks.
Skills & Experience
- Successful Candidates must demonstrate an appropriate combination of:
- 6+ years of experience as a DB Developer, preferably with Postgres, creating and supporting commercial data warehouses and data marts.
- Strong command of SQL. SQL server tools, ETL jobs including stored procedures.
- Database technologies such as SQL, Aurora, Redshift, Liquibase or Flyway
- Advanced knowledge of database security and performance monitoring standards.
- Understanding of relational and dimensional data modeling.
- Shell scripting skills.
- Knowledge of DataDog for setting up monitoring and alerting dashboards.
- Ability to work independently and in a group to provide sound design and technology leadership.
- Self-starter attitude with initiative & creativity.
- Ability to pay attention to details, dealing with interruptions and changing timelines and priorities.
- Ability to communicate and work effectively with all levels of company.
Required Education: A BS/MS in Computer Science, Computer Engineering, or a STEM field.
