Jr. Database Engineer(W2 Only)

Database Design and Development • Assist with database schema design and data modeling • Develop stored procedures, functions, triggers, and database objects • Build data integration solutions including ETL processes and data pipelines • Implement database automation tools and CI/CD processes for database and data pipeline deployments • Create and optimize database APIs and data access layers • Create and maintain technical documentation for database solutions Performance and Optimization • Monitor integration performance • Assist DBA with query optimization • Implement indexing strategies and partitioning under supervision • Support performance testing and analysis efforts • Help develop monitoring dashboards and reporting solutions Data Management • Support database migration and upgrade projects • Assist with data quality validation and testing processes • Help implement data archiving and retention procedures • Support backup and recovery testing activities • Support data cataloging and metadata documentation efforts • Participate in database testing and validation activities for new features or changes • Support data relevant documentation and knowledge management activities. Security and Compliance Support • Implement database security controls following established policies • Assist with FISMA compliance documentation and audit preparation • Support data masking and encryption implementation • Help maintain security monitoring processes Platform and Collaboration • Work with cloud database platforms, primarily RedShift, SQL Server and PostgreSQL on RDS but may include others, and SQL Server and PostgreSQL on EC2 instances • Support database automation and CI/CD implementation • Collaborate with development teams on database best practices • Participate in technical reviews and learning opportunities • Support business users with data requirements gathering