What are the responsibilities and job description for the SQL Developer position at HunaTek?
HunaTek is seeking a SQL Developerwho will be responsible for design, development and management of high quality, efficient and effective solutions in an Azure SQL Managed Instance environment to support a number of applications as well as several data pipelines/import & export tasks. This includes the ability to write and maintain stored procedures, views, functions or other database objects to support the applications. Experience with Python, Azure DevOps and Azure Data Factory is highly desired. This position requires a government background check and the candidate must be a green card holder or be a US-citizen.
Essential Job Functions
About Us
At HunaTek, we build teams of people from all backgrounds with varying levels of experience, knowing firsthand that diversity of thought will strengthen our ability to deliver for our customers. We work hand in hand with Federal civilian and military staff, pulling together to further the interests of our nation and home and abroad.
Whenever possible, we provide opportunities for our employees to learn new skills, obtain certifications, attend industry events, and have some fun together.
Our Benefits
We offer a comprehensive benefits package designed to make sure our employees and their families have access to good health care, are insured against catastrophic health events, can put money aside for retirement and are able to maintain a healthy work-life balance. These benefits include:
Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities.
Essential Job Functions
- Provide database performance-tuning expertise for Azure SQL Managed Instance databases. Identify and solve performance bottlenecks in Azure SQL Managed Instance database platforms supporting numerous applications including transactional databases and Data Warehouses.
- Manage Azure SQL Managed Instance database environments that support transactional data as the backend for numerous applications.
- Write Python code to manipulate data using DataFrame libraries such as Pandas/Polars & connecting to an Azure SQL Managed Instance using an Object Relational Mapper (ORM) such as SQL Alchemy.
- Ingest data from Application Programming Interfaces (APIs) and work with JSON data ranging from being simple in structure to deeply nested/complex.
- Create flat files with varying delimiter/line-termination requirements and automate the import/export of those files using Secure File Transfer Protocol (SFTP).
- Deploy database definition updates utilizing DacPac tasks in Azure DevOps Continuous Integration/Continuous Deployment (CI/CD) release pipelines.
- Automating the delivery of reports with varying frequencies (daily, weekly, monthly, quarterly, etc.) and manually delivering reports as needed.
- Demonstrate a strong background in data modelling, data management and data manipulation, code management and version control.
- Demonstrate a logical and structured approach to time management and task prioritization. Work within project timelines and budgets. Be able to organize own time, schedule tasks for completion and deliver work to that schedule.
- Self-motivated and willing to "do what it takes" to get the job done
- A strong level of attention to detail in order to spot and address data anomalies/discrepancies when they arise.
- Capable of reasoning and thinking through problems and developing desired solutions, independently or with others as required
- Experience creating and maintaining Azure Data Factory pipelines
- Excellent written and verbal communication and presentation skills
About Us
At HunaTek, we build teams of people from all backgrounds with varying levels of experience, knowing firsthand that diversity of thought will strengthen our ability to deliver for our customers. We work hand in hand with Federal civilian and military staff, pulling together to further the interests of our nation and home and abroad.
Whenever possible, we provide opportunities for our employees to learn new skills, obtain certifications, attend industry events, and have some fun together.
Our Benefits
We offer a comprehensive benefits package designed to make sure our employees and their families have access to good health care, are insured against catastrophic health events, can put money aside for retirement and are able to maintain a healthy work-life balance. These benefits include:
- Comprehensive medical, dental and vision
- Long-term and short-term disability insurance and term life insurance
- 401(K) with safe harbor contribution
- Paid time off and 11 paid holidays
- Tuition and career development assistance
- A selection of voluntary benefits
Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities.