Jr. Database Engineer

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