Apply on Employer Site

Nakupuna Companies · 19 hours ago

Database Engineer/Team Lead

Honolulu, HI

Full-time

Hybrid

Mid, Senior Level

$120K/yr - $150K/yr

5+ years exp

Nakupuna Consulting is seeking a Database Engineer Team Lead with supervisory and leadership experience. The candidate will lead a team of Database Administrators and Engineers to maintain and enhance mission-critical datasets for Department of Defense customers, ensuring database requirements are met while implementing best practices and improving processes.

Environmental ConsultingInformation TechnologyManagement Consulting

Comp. & Benefits

No H1B

Security Clearance Required

U.S. Citizen Only

Responsibilities

Work closely with the customer and database team to establish team tasks and priorities

Serve as technical lead for a team of 3-4 database administrators and engineers to fulfill customer priorities

Enforce project best-practices, including ensuring all work is documented, approved, and properly reported

Collaborate with the customer and other IT functional teams to ensure database requirements are being communicated and fulfilled

Advise stakeholders on suggested COAs, roadmaps, and compliance improvements as required

Create white-papers, PowerPoint presentations, and workflow diagrams to facilitate communication and documentation needs

Supervise 3-4 database administrators / engineers. Supervisor duties include annual goal setting, frequent professional development conversations, coaching / mentorship, performance assessments

Proactively seek opportunities to improve inefficient processes, and train IT administrators on database related activities

Design and develop data pipelines, ETL processes, and data integration workflows to support business intelligence and analytics platforms

Create and maintain logical and physical data models, ensuring alignment with business and system requirements

Build, maintain, and optimize Microsoft SQL Server databases to ensure high availability, scalability, and reliability

Implement data quality controls, auditing, and governance policies to ensure accuracy, consistency, and security of data assets

Implement best practices for query tuning, indexing strategies, and storage optimization to achieve optimal database performance

Develop automation scripts using T-SQL, PowerShell, or other scripting languages to streamline data processes and database management tasks

Leverage cloud-based solutions to support data architectures within the Amazon Web Services (AWS) GovCloud environment

Develop and maintain documentation including Standard Operating Procedures (SOPs), diagrams and presentations

Help define data strategy and contribute to technology selection and adoption to improve the data ecosystem

Develop comprehensive test suites and detailed test plans for unit testing, regression testing, and user acceptance testing (UAT)

Qualification

Database designTransact-SQL (T-SQL)Data warehousingETL processesCloud-based data platformsData modeling techniquesData governanceDevSecOps implementationMicrosoft SQL ServerAgile methodologiesAnalytical skillsEffective communicationLeadership skillsOrganizational skills

Required

Supervisory and leadership experience

Familiarity with Agile project methodologies

Ability to work with a geographically dispersed workforce

Comfortable communicating with a variety of IT professionals including technicians, end-users, and executive level stakeholders

Knowledge of Microsoft SQL Server administration and development

Ability to quickly learn and implement new technologies as the customer migrates into managed database services

Excellent technical, organizational, decision-making, analytical, and planning skills

Effective communicator who takes initiative and the ability to adapt to dynamic environments

Expertise in database design, data warehousing, and ETL processes

Proficiency in Transact-SQL (T-SQL) for complex queries, stored procedures, and performance tuning

Experience with data pipeline tools and technologies, such as SQL Server Integration Services (SSIS)

Solid understanding of data modeling techniques, including star schema and snowflake schema designs

Familiarity with cloud-based data platforms, particularly in Amazon Web Services (AWS)

Experience with SaaS database solutions such as AWS RDS and or Aurora hosted databases

Knowledge of data governance, security, and compliance best practices

Demonstrated proficiency with source control systems, including the ability to manage code repositories, track changes, and collaborate effectively with team members to ensure version control and maintain code integrity throughout the development lifecycle

Be able to support DevSecOps implementation including automated testing, release pipelines, and automated deployment

Demonstrated proficiency with Microsoft Visual Studio, including experience in using its integrated development environment (IDE) for coding, debugging, testing, and deploying database software applications efficiently across various platforms

Proficiency with Microsoft 365 applications that includes Word, Excel, Visio, and SharePoint

Experience with DoD standard tools and technologies

Bachelor's degree in a technical major from an accredited institution

Minimum of (5) five years of Database Engineering professional experience

Minimum of (2) years of team-lead / customer-facing experience

Active IAT II Certification which may include CompTIA Advanced Security Practitioner (CASP+), CompTIA Cybersecurity Analyst (CySA+), Certified Information Systems Security Professional (CISSP), or CompTIA Security+

Must currently have at least a Secret level security clearance

Must be a U.S. citizen

Ability to perform repetitive motions with the hands, wrists, and fingers

Ability to engage in and follow audible communications in emergency situations

Ability to sit for prolonged periods at a desk and working on a computer

Preferred

Experience using Agile methodologies and ticketing systems such as JIRA is desirable

Microsoft SQL Server, Microsoft Certified Solutions Associate (MCSA), Microsoft Certified Solutions Developer (MCSD), Microsoft Certified Solutions Expert (MCSE) or Azure database role-based certifications

Amazon Web Services (AWS) certifications

AWS Certified Engineer

Scrum Master or other Agile Methodology related certifications