Data Intelligence LLC
Senior Database Engineer
Data Intelligence LLC, Port Hueneme, California, United States, 93041
Data Intelligence, LLC (DI) is searching for a full time Senior Database Administrator in Port Hueneme, CA. This is an on-site position at NSWC PHD.
Responsibilities
Support in the development, deployment, and maintenance of backend applications, relational databases, such as MSSQL, Azure SQL Database or Azure SQL Managed Instances, and associated business intelligence systems to improve database performance, scalability, and reliability while delivering foundational database solutions that meet best practices
Design and run reports, establish and maintain backup and recovery processes, and maintain associated non-referential data
Support cloud-based server, platform and database infrastructure required to maintain operational availability and full compliance with Navy cybersecurity requirements
Conduct requirements gathering, analysis, design, development, documentation, testing, integration, implementation and support of reports and dashboards in accordance with stakeholder specifications and best practices. Reports and dashboards include advanced out-of-the-box visualizations, custom visualizations, queries, interactive connections, paginated reports, and data refreshes (e.g. Power Query, DAX, SQL)
Ensure database server environments meet security requirements in accordance with DISA Security Technical Implementation Guidelines (STIGs)
Ensure that the cloud computing environment is monitored and maintained and will report any deviations to the Government
Required Skills/Experienc
BS Degree
Minimum of five years in the development and deployment of distributed relational databases and associated BI systems
Minimum of five years of experience with the Microsoft SQL server stack, Microsoft SQL, Azure SQL Database or Azure SQL Managed Instances
Minimum of five years securing a SQL environment in accordance with DISA STIGs
Minimum of five years SQL Server configuration management, optimization, administration, development in client/server architecture, business object modeling and relational database design using MS SQL Server
Minimum of five years writing complex Transact SQL queries, stored-procedures and designing relational databases
Minimum of five years implementing reports and dashboards including advanced out-of-the-box visualizations, custom visualizations, queries, interactive connections, paginated reports, and data refreshes using tools such as Power Query, DAX, SQL
Current U.S. Governent Secret Security Clearance
Desire Skills/Experiences
Experience with IBM Cognos and other On-Line Analytical Processing (OLAP) tools
Understanding of Navy Working Capital Fund (WCF) accounting principles and generation of reports / OLAP analysis from WCF funding and cost information
Experience leading and designing Service Oriented Architecture (SOA) based application
Experience in Navy Security requirements implementation and their impacts to overall software architecture
Experience with Microsoft PowerBI Stack
Certifications
IAT 3
Data Intelligence, DI is an established small business that has supported the critical missions of our government clients since 2005. We provide full life cycle system development, systems engineering, cybersecurity, and supporting analytical and logistics support to C4ISR and other complex systems. We are an equal opportunity employer that offers competitive salaries, comprehensive benefits, a team-oriented environment, and opportunities for advancement. Our excellent employee retention record reflects our employee focus. We work with Veteran’s organization to proactively hire those who have served our country. We offer medical, dental and vision insurance, 401k, PTO and 11paid holidays.
Data Intelligence is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, age, color, religion, creed, sex, sexual orientation, gender identity, national origin, disability, or protected Veteran status.#J-18808-Ljbffr
Responsibilities
Support in the development, deployment, and maintenance of backend applications, relational databases, such as MSSQL, Azure SQL Database or Azure SQL Managed Instances, and associated business intelligence systems to improve database performance, scalability, and reliability while delivering foundational database solutions that meet best practices
Design and run reports, establish and maintain backup and recovery processes, and maintain associated non-referential data
Support cloud-based server, platform and database infrastructure required to maintain operational availability and full compliance with Navy cybersecurity requirements
Conduct requirements gathering, analysis, design, development, documentation, testing, integration, implementation and support of reports and dashboards in accordance with stakeholder specifications and best practices. Reports and dashboards include advanced out-of-the-box visualizations, custom visualizations, queries, interactive connections, paginated reports, and data refreshes (e.g. Power Query, DAX, SQL)
Ensure database server environments meet security requirements in accordance with DISA Security Technical Implementation Guidelines (STIGs)
Ensure that the cloud computing environment is monitored and maintained and will report any deviations to the Government
Required Skills/Experienc
BS Degree
Minimum of five years in the development and deployment of distributed relational databases and associated BI systems
Minimum of five years of experience with the Microsoft SQL server stack, Microsoft SQL, Azure SQL Database or Azure SQL Managed Instances
Minimum of five years securing a SQL environment in accordance with DISA STIGs
Minimum of five years SQL Server configuration management, optimization, administration, development in client/server architecture, business object modeling and relational database design using MS SQL Server
Minimum of five years writing complex Transact SQL queries, stored-procedures and designing relational databases
Minimum of five years implementing reports and dashboards including advanced out-of-the-box visualizations, custom visualizations, queries, interactive connections, paginated reports, and data refreshes using tools such as Power Query, DAX, SQL
Current U.S. Governent Secret Security Clearance
Desire Skills/Experiences
Experience with IBM Cognos and other On-Line Analytical Processing (OLAP) tools
Understanding of Navy Working Capital Fund (WCF) accounting principles and generation of reports / OLAP analysis from WCF funding and cost information
Experience leading and designing Service Oriented Architecture (SOA) based application
Experience in Navy Security requirements implementation and their impacts to overall software architecture
Experience with Microsoft PowerBI Stack
Certifications
IAT 3
Data Intelligence, DI is an established small business that has supported the critical missions of our government clients since 2005. We provide full life cycle system development, systems engineering, cybersecurity, and supporting analytical and logistics support to C4ISR and other complex systems. We are an equal opportunity employer that offers competitive salaries, comprehensive benefits, a team-oriented environment, and opportunities for advancement. Our excellent employee retention record reflects our employee focus. We work with Veteran’s organization to proactively hire those who have served our country. We offer medical, dental and vision insurance, 401k, PTO and 11paid holidays.
Data Intelligence is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, age, color, religion, creed, sex, sexual orientation, gender identity, national origin, disability, or protected Veteran status.#J-18808-Ljbffr