• Create and modify database structures, ensuring optimal design for both transactional integrity and analytical reporting • Perform advanced database maintenance tasks, including backups/restores, statistics updates, index optimization, and performance tuning • Proactively monitor and optimize database performance across AWS MySQL, Azure TSQL, and Databricks AnsiSQL environments • Design, implement, and manage Master Data Management (MDM) solutions that ensure data consistency across systems • Collaborate with data engineers to map production data to data warehouse solutions with MDM standards • Develop and maintain comprehensive Entity Relationship Diagrams (ERDs), system flow documents, and technical specifications for leadership and cross-functional teams • Maintain system security and data integrity across all data environments • Partner with systems engineers to optimize hardware and storage subsystems for AWS • Develop, manage, and maintain robust disaster recovery and high availability plans • Collaborate with Infosec and Security teams on data compliance, security, and retention • Participate in data architectural design reviews with both Technology and Data teams • Mentor and coach team members on database best practices

Role Description This position supports programming, automation, and technical project work within the Database Support department by assisting with the design, development, testing, and maintenance of software and data solutions. Interns in this role contribute to supervised programming tasks that may involve scripting and automation technologies as project needs evolve. The position is project-based and collaborative, focused on improving data workflows, reporting, system integrations, and internal processes while providing hands-on technical experience; the role does not include ownership of production systems or independent decision-making authority. Essential Duties and Responsibilities - Assist with programming, automation, and technical projects supporting Database Support and Development department operations and reporting needs. - Develop, test, and maintain scripts, queries, reports, data transformations, and spreadsheet-based solutions under the direction of the Database Manager and organization leadership. - Support data analysis and reporting initiatives, including building and updating dashboards, reports, Excel workbooks, and supporting datasets. - Assist with process automation and workflow improvements to reduce manual effort, improve efficiency, and enhance data accuracy. - Perform data validation, quality control, and integrity checks on spreadsheets, files, reports, and automated outputs, including work with large datasets. - Support data security and access control practices, including proper handling of sensitive information, adherence to security protocols, and use of least-privilege access. - Assist with monitoring and troubleshooting technical issues related to scripts, Excel models, reports, data workflows, automation, or security controls. - Help prepare, format, and review data files and extracts for internal use or third-party platforms in accordance with security and privacy requirements. - Document code, spreadsheet logic, workflows, security considerations, and technical procedures to support maintainability and compliance. - Collaborate with Development and data staff to translate requirements into secure, well-documented technical solutions. - Participate in daily check-ins and weekly project meetings using a Scrum-style workflow to provide status updates, identify blockers, and support assigned programming tasks. Qualifications - Currently enrolled in a college or university program in Computer Science, Software Engineering, Information Systems, Data Science, Information Technology, or a related technical discipline. - Completed coursework or training in programming, scripting, data analysis, databases, or related technical subjects. - Some practical experience with programming, scripting, spreadsheet analysis, or technical projects, which may include class assignments, academic projects, personal projects, or coding bootcamps. - Experience working with spreadsheets and large datasets, including Microsoft Excel or similar tools, and an understanding of data organization, validation, and analysis concepts. - Demonstrated interest in programming languages and technologies such as Power BI, Power Query (M), PowerShell, Python, SQL, JavaScript, or similar tools used for data analysis and automation. Knowledge, Skills and Abilities - Foundational knowledge of programming and scripting concepts, gained through coursework or hands-on projects. - Familiarity with one or more programming, scripting, data analysis, or automation tools (e.g., Power BI, Power Query (M), PowerShell, Python, SQL, JavaScript, or similar technologies). - Interest in data analysis, reporting, automation, and working with large datasets, and understanding how technical solutions support organizational goals. - Willingness to learn fundraising/marketing operations, nonprofit data practices, and development systems, and interest in applying technical skills in a mission-driven environment. - Ability to work with spreadsheets and data files, including Microsoft Excel or similar tools, and understanding of data transformation, validation, and quality control concepts. - Understanding of basic information security principles, including proper handling of sensitive or confidential data and adherence to security protocols. - Strong analytical and problem-solving skills, with the ability to troubleshoot technical issues under guidance. - High attention to detail and commitment to accuracy and data integrity. - Ability to document code, processes, and technical work clearly and consistently. - Effective written and verbal communication skills, particularly in a remote work setting. - Strong organizational and time-management skills, with the ability to manage assigned tasks and meet deadlines. - Professional judgment, reliability, and willingness to follow established procedures, standards, and best practices. - Must be a person of good moral character, honest and trustworthy. Employment Requirements The successful candidate will be required to submit to a background check and social security trace. St. Labre reserves the right to rescind any employment or internship position offer based on the background check and social security trace findings. The candidate must also successfully complete the Safe Environment training, as required by the Diocese of Great Falls-Billings and St. Labre Indian School Educational Association. The execution of a non-disclosure agreement will also be required. The candidate may not intern or work for another organization or entity during St. Labre paid by hours. Physical Demands The physical demands described here are representative of those that must be met by an employee/intern to successfully perform the essential functions of this job. While performing the duties of this job, the intern is frequently required to sit or stand in front of a computer screen; use hands to finger, handle, or feel; and talk or hear. Vision abilities are required by this job. Work Environment This position is fully remote and requires access to a reliable computer or laptop, a stable internet connection, appropriate video and audio equipment for virtual meetings, and the ability to securely connect to a virtual or remote work environment. The role operates primarily within a Google Workspace environment and uses organization-approved collaboration, documentation, and data tools. The work is primarily computer-based and involves extended periods of screen time while performing programming, analysis, and documentation tasks. Location This is a fully remote position. The employee must be able to work effectively in a private (no public spaces, like cafes, libraries, etc.) remote environment and communicate regularly with supervisors and team members using approved collaboration tools.

• Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. • Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. • Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. • Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. • Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services.

Role Description We are seeking a highly skilled and motivated Database Administrator with an active Secret security clearance to join our dynamic team. In this role, you will be responsible for managing, maintaining, and optimizing complex database systems to ensure high availability, security, and performance. Your expertise will support critical operations by implementing robust database solutions, performing performance tuning, and ensuring data integrity across multiple platforms. This position offers an exciting opportunity to work on mission-critical projects that require precision, innovation, and a proactive approach to database management. Qualifications - Active Secret Security Clearance - 4 Year Degree in Information Technology or related field or equivalent experience - Minimum 3 years experience Requirements - Database experience of working in different OS platforms like Linux, RHEL and Windows - Experience in Oracle/Postgres database administration, support, implementation, configuration and upgrade - Solid understanding of SQL (writing, optimizing queries, normalization and indexing) - Experience with backup & recovery (pg_dump, pg_basebackup, PITR) - Experience in Oracle/Postgres database performance tuning using explain plans and monitoring tools - Working experience of AWS Cloud Services (Cloud Watch, Cloud Trail, EC2) and Databases (Oracle, Aurora & Postgres RDS) - Strong understanding of postgres schema, user roles, access control and security model - Postgres script writing (PL/pgSQL) with loops, conditions and variables - Performance tuning, hardware replacement, firmware upgrades, and patching to all COTS software products, including operating systems - Experience in shell scripting to enhance and update daily monitoring tasks Benefits - 401(k) - 401(k) matching - Dental insurance - Flexible spending account - Health insurance - Life insurance - Paid time off - Professional development assistance - Retirement plan - Vision insurance Company Description Stratagen is a HUBZone Certified, General Services Administration (GSA) Schedule holder, small business located in West Virginia. As a U.S. Federal Government contractor, Stratagen provides Information Technology, Analytical, and Program Management Support. Stratagen Consulting specializes in custom IT solutions, IT Operations, System Engineering, Infrastructure Management, Program Budgeting, Master Scheduling, IT Security, System Integration, and Database Administration. Stratagen’s leadership team has over 60 years of combined experience and business knowledge in the Federal space. Using industry best practices and best value solutions, the company’s mission is to provide the U.S. Government with quality personnel and support to enhance the Nation’s efforts for national security and public safety. Location: Remote with occasional travel to government site in Clarksburg, West Virginia.