• Manage and maintain all databases, ensuring high availability and reliability. • Perform regular database backups and recovery procedures. • Monitor database performance, tuning for optimization and efficiency. • Participate in the design, development, and maintenance of scalable and efficient data pipelines and databases. • Collaborate with stakeholders to understand data requirements and translate them into technical specifications and data models. • Recommend appropriate data storage and processing technologies based on project requirements. • Develop and implement Extract, Transform, Load (ETL) processes to acquire, clean, and transform data from various sources into usable formats. • Ensure data integrity, consistency, and quality throughout the ETL processes. • Monitor and troubleshoot data integration workflows, identifying and resolving data-related issues and performance bottlenecks. • Participate in the design, build, and maintenance of data warehouses and data lakes to support reporting, analytics, and business intelligence initiatives. • Implement data partitioning, indexing, and optimization strategies to improve query performance and efficiency. • Work with data consumers to understand their reporting and analysis requirements and provide appropriate data structures and schemas. • Adhere to and enforce data governance policies, standards, and regulations. • Implement data security measures, including access controls, encryption, and data masking techniques. • Monitor data usage and access patterns, identifying and mitigating potential data security risks. • Optimize data processes and infrastructure to improve performance, scalability, and reliability. • Conduct performance tuning, query optimization, and indexing to enhance data retrieval and processing speed. • Proactively identify and address system bottlenecks to ensure efficient data operations. • Design, construct, implement, and maintain automated jobs and reports. • Collaborate with cross-functional teams, business analysts, and IT systems analysts to understand their business requirements and provide data and custom application solutions. • Communicate technical concepts and solutions effectively to both technical and non-technical stakeholders. • Stay updated with the latest industry trends, technologies, and best practices related to database administration. • Manage the installation, configuration, and maintenance of database management systems (DBMS). • Coordinate and oversee OS-level patching and updates for database servers. • Perform routine and advanced system maintenance and monitoring tasks.

Role Description Koniag IT Systems, LLC, a Koniag Government Services company, is seeking a Database Developer to support KITS and our government customer. The position is remote and requires the candidate to be able to obtain a Public Trust. The Database Developer will play a critical role in designing, building, and maintaining data systems to support business needs. The ideal candidate will have a strong background in: - Data architecture - Data modeling - Data warehousing - Data manipulation and transformation This role will focus on: - Data modeling - Building and optimizing data engineering pipelines - Implementing CI/CD practices - Developing serverless functions across AWS and Azure environments Qualifications - Bachelor’s degree in computer science, Data Development, Information Technology, or a related field - 7+ years of experience in data engineering, data architecture, or similar technical roles - Demonstrated expertise in database systems, data warehousing, and ETL processes - 6+ years as a Python programming language expert Requirements - ETL/ELT Processes: Building data pipelines using a mix of stored procedures, views, and Python scripts. Knowledge of tools like dbt or simple orchestration (e.g., Airflow basics) is a plus. - Data Quality & Testing: Implementing checks, validation, and monitoring for pipelines. - Version Control & Collaboration: Git for code (Python + SQL scripts), plus experience with CI/CD basics. - Performance & Scalability: Tuning for large volumes, understanding indexing/partitioning impacts, and basic cloud database concepts. - Soft Skills: Problem-solving for debugging complex queries/pipelines, clear documentation of models and procedures, and ability to collaborate with team members. - Data Modeling: Strong experience in designing relational schemas, Entity-Relationship (ER) modeling, dimensional modeling, and understanding trade-offs between normalization vs. denormalization. - Advanced SQL & Database Querying: Mastery of complex queries, query optimization, and performance tuning. - Database Administration & Objects: Creating and managing stored procedures, optimizing views, and other DBA tasks. - Python Programming for Data Engineering: Solid proficiency in Python for scripting, automation, and data manipulation. - Relational Database Experience: Hands-on work with at least one major RDBMS (e.g., SQL Server, PostgreSQL, MySQL). - Other Key Skills: Excellent problem-solving and analytical abilities with attention to detail, strong communication and collaboration skills. Benefits - Competitive compensation - Extraordinary benefits package including health, dental, and vision insurance - 401K with company matching - Flexible spending accounts - Paid holidays - Three weeks paid time off - And more Security Requirement - Ability to obtain Public Trust

• Maintain high availability and reliability of the SQL Server infrastructure. • Participate in the follow-the-sun support model. • Build and implement new database infrastructure. • Apply updates and patches to maintain a secure and compliant environment. • Ensure adherence to backup and recovery policies. • Document legacy processes for improved clarity and efficiency. • Coach junior DBAs to enhance their technical skills.

Role Description The Linux and Database Administrator is responsible for managing, maintaining, and optimizing Linux‑based systems and enterprise databases across production and non‑production environments. This role includes: - Monitoring server performance and ensuring system availability. - Performing database tuning and maintaining secure, reliable infrastructure operations. - Installing, configuring, and updating Linux systems and database applications. - Troubleshooting issues and analyzing system logs. - Implementing cybersecurity measures such as access control, backup procedures, and recovery strategies. - Configuring servers and databases, designing and maintaining database structures across multiple platforms. - Preserving data integrity and optimizing database access and resource allocation for performance. - Developing and implementing database backup and recovery strategies. - Collaborating with developers, technical managers, and analysts to support new systems and services. - Developing solutions that improve system efficiency. Qualifications - Bachelor’s degree in computer science, information technology, or engineering plus 4+ years of related experience. - Relevant database administration certifications such as Oracle Certified Professional or Microsoft Certified: Azure Database Administrator Associate. - Minimum 3 years as Linux and database administrator. - Strong Linux/Unix skills; Microsoft OS knowledge is a plus. - SQL proficiency including MS SQL, Oracle Database, Hadoop, or PostgreSQL. - T-SQL and PL/SQL knowledge is a plus. - Linux command-line proficiency. - Shell scripting and automation tools such as Python, Perl, and Bash. - Strong problem-solving skills and attention to detail. Requirements - Experience with Linux and Unix‑based systems. - Experience with SQL and major database platforms. - Experience with shell scripting and automation tools. - Background in database administration, system performance tuning, and secure infrastructure management. Benefits - Competitive compensation - Health, dental, and vision insurance - Flexible paid time off - Remote‑friendly work environment - Professional development and training opportunities - Collaborative, supportive technical team culture - Opportunity to manage and optimize critical enterprise systems and databases