Kapili Services, LLC
Database Administration (SQL)
Kapili Services, LLC, Honolulu, Hawaii, United States, 96814
The Alaka`ina Foundation Family of Companies (FOCs) is looking for a qualified Structured Query Language (SQL) Database Administrator
to support our government customer located in at
Fort Shafter, Hawai'i.***Sign-on bonus offered on a case-by-case basis.***The SQL Database Administrator will be part of a dynamic team of IT Enterprise Managers, with expert experience in Windows, MECM, Enterprise Patching, PKI/Certificates, Cloud, and scripting experience. In this role you will work at the enterprise level across endpoint management and server operations teams to ensure adherence to customer SLAs while also driving automation through scripting and testing of new/emerging technologies to deliver faster deployments and decreased workload.DESCRIPTION OF RESPONSIBILITIES:Demonstrated hands on experience with upgrading SQL Servers from lower versions to the latest version (version 2019 and up).Familiar with full backup and recovery capabilities of the Microsoft SQL Server 2019and 2022 platform.Familiar with creating reports using Microsoft SQL Server Reporting Services (SSRS).Demonstrated experience in setting up a Reporting server. Responsibility for all DBA functions and report development and familiarity with Software Systems development Architecture and DesignCommunicate effectively (in oral and written form) and work well within small and large team environments.Participate in meetings to ensure client needs are met. Participate in special projects as required.System administration knowledge of IT networks and Enterprise mail servers.System administration knowledge of Microsoft Windows (MECM/SCCM) and/or Linux.Knowledge of virtualization (VMware) concepts.System administration knowledge of virtualized environments.Experience using Microsoft Office software suite.Understanding of file systems and hard disk drive structures.Demonstrated ability utilizing good communication skills.Experience planning and implementing assigned tasks.Familiar with best practices for optimizing databases.Demonstrated experience with creating and maintaining databases in a Clustered Server environment.Knowledge of the design, development and maintenance of various data models and their components.Demonstrated experience and working knowledge of data lakes, data warehouse and data mart architectures.Familiar with metadata and data modeling, data flow, entity relationship diagram, schema architectures and query languages.Demonstrated experience with mirroring database servers, log shipping, latest techniques for Database redundancy and high Availability.
REQUIRED DEGREE/EDUCATION/CERTIFICATION:Bachelor's Degree in a related field, preferred.Must meet at least one baseline certification under the IAT III position category per DoD 8140.01-M upon date of hire. (FITSP-O, GFACT, CASP+, CCNP Security, or CCSP.ITIL v4 certificationMust meet designated Computing Environment (CE) certifications (Microsoft 365 Certified: Modern Desktop Administrator Associate) within 6 months of hire date.
REQUIRED SKILLS AND EXPERIENCE:Familiar with best practices for optimizing SQL databases.Demonstrated experience with creating and maintaining databases in a Clustered Server environment.Knowledge of the design, development and maintenance of various data models and their components.Demonstrated experience and working knowledge of data lakes, data warehouse and data mart architectures.Familiar with metadata and data modeling, data flow, entity relationship diagram, schema architectures and query languages.Demonstrated experience with mirroring database servers, log shipping, latest techniques for Database redundancy and high Availability.Demonstrated experience with full backup and recovery capabilities of the Microsoft SQL Server 2019and 2022 platform.Demonstrated hands on experience with upgrading SQL Servers from lower versions to the latest version (version 2019 and up).Must be familiar with creating reports using Microsoft SQL Server Reporting Services (SSRS).Demonstrated experience in setting up a Reporting server. Responsibility for all DBA functions and report development and familiarity with Software Systems development Architecture and DesignFour plus (4+ years) MECM(SCCM) experience, supporting software packaging and patching.Expert knowledge of MECM and Intune device enrollment, policy management, application deployment, compliance enforcement, and conditional access.Functional understanding of VMWare, Microsoft SQL Server, and Active Directory.Expertise in capturing images (.WIM), creating packages, advertisements, task sequences, operating system deployment (OSD) and queries in MECM.Ability to use Powershell scripting to automate tasking and customize configurations.Expertise with IAVA process, testing, approval and deployment processesAbility to implement strong Windows troubleshooting skills. Strong understanding of networking concepts including VPN and certificate-based authentication.
DESIRED SKILLS AND EXPERIENCE:Minimum of five plus (5+) years of previous experience in architecture and design of complex high-available systems.Strong IT architecture analysis capability.Minimum of five (5) or more years' experience needed for Microsoft SQL Server, Data Lakes, Clusters.Active Secret Clearance with ability to obtain SCI clearance.
REQUIRED CITIZENSHIP AND CLEARANCE:Must be a U.S. CitizenMinimum Secret clearance; must be TS eligible based on investigation type (T5).
The Alaka`ina Foundation Family of Companies (FOCs) is a fast-growing government service provider. Employees enjoy competitive salaries; a 401K plan with company match; medical, dental, disability, and life insurance coverage; tuition reimbursement; paid time off; and 11 paid holidays.We are an Equal Opportunity/Affirmative Action Employer. We are proud to state that we do not discriminate in employment decisions on the basis of race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. If you are a person with a disability and you need an accommodation during the application process, please click here to request accommodation. We E-Verify all employees.The Alaka`ina Foundation Family of Companies (FOCs) is comprised of industry-recognized government service firms designated as Native Hawaiian Organization (NHO)-owned and 8(a) certified businesses. The Family of Companies (FOCs) includes Ke`aki Technologies, Laulima Government Solutions, Kpono Government Services, and Kapili Services, Po`okela Solutions, Kkaha Solutions, LLC, and Pololei Solutions, LLC. Alaka`ina Foundation activities under the 501(c)3 principally benefit the youth of Hawaii through charitable efforts which includes providing innovative educational programs that combine leadership, science & technology, and environmental stewardship.For additional information, please visit www.alakainafoundation.com#LI-JS1#ClearanceJobs
to support our government customer located in at
Fort Shafter, Hawai'i.***Sign-on bonus offered on a case-by-case basis.***The SQL Database Administrator will be part of a dynamic team of IT Enterprise Managers, with expert experience in Windows, MECM, Enterprise Patching, PKI/Certificates, Cloud, and scripting experience. In this role you will work at the enterprise level across endpoint management and server operations teams to ensure adherence to customer SLAs while also driving automation through scripting and testing of new/emerging technologies to deliver faster deployments and decreased workload.DESCRIPTION OF RESPONSIBILITIES:Demonstrated hands on experience with upgrading SQL Servers from lower versions to the latest version (version 2019 and up).Familiar with full backup and recovery capabilities of the Microsoft SQL Server 2019and 2022 platform.Familiar with creating reports using Microsoft SQL Server Reporting Services (SSRS).Demonstrated experience in setting up a Reporting server. Responsibility for all DBA functions and report development and familiarity with Software Systems development Architecture and DesignCommunicate effectively (in oral and written form) and work well within small and large team environments.Participate in meetings to ensure client needs are met. Participate in special projects as required.System administration knowledge of IT networks and Enterprise mail servers.System administration knowledge of Microsoft Windows (MECM/SCCM) and/or Linux.Knowledge of virtualization (VMware) concepts.System administration knowledge of virtualized environments.Experience using Microsoft Office software suite.Understanding of file systems and hard disk drive structures.Demonstrated ability utilizing good communication skills.Experience planning and implementing assigned tasks.Familiar with best practices for optimizing databases.Demonstrated experience with creating and maintaining databases in a Clustered Server environment.Knowledge of the design, development and maintenance of various data models and their components.Demonstrated experience and working knowledge of data lakes, data warehouse and data mart architectures.Familiar with metadata and data modeling, data flow, entity relationship diagram, schema architectures and query languages.Demonstrated experience with mirroring database servers, log shipping, latest techniques for Database redundancy and high Availability.
REQUIRED DEGREE/EDUCATION/CERTIFICATION:Bachelor's Degree in a related field, preferred.Must meet at least one baseline certification under the IAT III position category per DoD 8140.01-M upon date of hire. (FITSP-O, GFACT, CASP+, CCNP Security, or CCSP.ITIL v4 certificationMust meet designated Computing Environment (CE) certifications (Microsoft 365 Certified: Modern Desktop Administrator Associate) within 6 months of hire date.
REQUIRED SKILLS AND EXPERIENCE:Familiar with best practices for optimizing SQL databases.Demonstrated experience with creating and maintaining databases in a Clustered Server environment.Knowledge of the design, development and maintenance of various data models and their components.Demonstrated experience and working knowledge of data lakes, data warehouse and data mart architectures.Familiar with metadata and data modeling, data flow, entity relationship diagram, schema architectures and query languages.Demonstrated experience with mirroring database servers, log shipping, latest techniques for Database redundancy and high Availability.Demonstrated experience with full backup and recovery capabilities of the Microsoft SQL Server 2019and 2022 platform.Demonstrated hands on experience with upgrading SQL Servers from lower versions to the latest version (version 2019 and up).Must be familiar with creating reports using Microsoft SQL Server Reporting Services (SSRS).Demonstrated experience in setting up a Reporting server. Responsibility for all DBA functions and report development and familiarity with Software Systems development Architecture and DesignFour plus (4+ years) MECM(SCCM) experience, supporting software packaging and patching.Expert knowledge of MECM and Intune device enrollment, policy management, application deployment, compliance enforcement, and conditional access.Functional understanding of VMWare, Microsoft SQL Server, and Active Directory.Expertise in capturing images (.WIM), creating packages, advertisements, task sequences, operating system deployment (OSD) and queries in MECM.Ability to use Powershell scripting to automate tasking and customize configurations.Expertise with IAVA process, testing, approval and deployment processesAbility to implement strong Windows troubleshooting skills. Strong understanding of networking concepts including VPN and certificate-based authentication.
DESIRED SKILLS AND EXPERIENCE:Minimum of five plus (5+) years of previous experience in architecture and design of complex high-available systems.Strong IT architecture analysis capability.Minimum of five (5) or more years' experience needed for Microsoft SQL Server, Data Lakes, Clusters.Active Secret Clearance with ability to obtain SCI clearance.
REQUIRED CITIZENSHIP AND CLEARANCE:Must be a U.S. CitizenMinimum Secret clearance; must be TS eligible based on investigation type (T5).
The Alaka`ina Foundation Family of Companies (FOCs) is a fast-growing government service provider. Employees enjoy competitive salaries; a 401K plan with company match; medical, dental, disability, and life insurance coverage; tuition reimbursement; paid time off; and 11 paid holidays.We are an Equal Opportunity/Affirmative Action Employer. We are proud to state that we do not discriminate in employment decisions on the basis of race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. If you are a person with a disability and you need an accommodation during the application process, please click here to request accommodation. We E-Verify all employees.The Alaka`ina Foundation Family of Companies (FOCs) is comprised of industry-recognized government service firms designated as Native Hawaiian Organization (NHO)-owned and 8(a) certified businesses. The Family of Companies (FOCs) includes Ke`aki Technologies, Laulima Government Solutions, Kpono Government Services, and Kapili Services, Po`okela Solutions, Kkaha Solutions, LLC, and Pololei Solutions, LLC. Alaka`ina Foundation activities under the 501(c)3 principally benefit the youth of Hawaii through charitable efforts which includes providing innovative educational programs that combine leadership, science & technology, and environmental stewardship.For additional information, please visit www.alakainafoundation.com#LI-JS1#ClearanceJobs