Database Developer
Share
Job Location:
Monthly Salary:
Posted on:
21 hours ago
Vacancies:
1 Vacancy
Job Summary
Summary
Join Aperia Solutions a leader in SaaS solutions for the Payments and Compliance industries. Aperia is a Texas-based fintech and managed consultancy firm that creates custom SaaS applications and other software-based solutions for the payments banking and processing industry. Founded in 1999 Aperia offers business intelligence risk management compliance and customer intelligence platforms. With offices in Dallas Washington DC and Vietnam Aperia is a fast-paced global organization that strives to improve efficiency in compliance risk and customer service operations. Aperias clients include banks processors payment facilitators merchant service providers independent sales organizations and government entities. A career at Aperia promises a great challenge culture and opportunities to forge your own path.
Job Description
At Aperia we rely on a dynamic team of software developers. Were seeking a Database Developer who is ready to work with new technologies and architectures in a forward-thinking organization thats always pushing boundaries. This person will have SQL development background and SSIS/ETL development experience. The ideal candidate has experience in SQL development SSRS SSIS ETL Power BI and Azure Data Factory.
Core Responsibilities
- Designs builds and implements relational databases.
- Reviews T-SQL code and performances optimization.
- Works closely with other members of the business analyst database administrator and software development and database development teams sharing knowledge and making recommendations as needed.
- Works with offshore development teams and reports.
- Completes documentation on all assigned systems and databases including business rules logic and processes.
Functional Responsibilities
- Implement a viable system that can survive and adapt changes demonstrated through delivered projects.
- Ability to use critical thinking to solve issues that arise.
- Ability to troubleshoot database performance issues.
- Ability to deliver successfully tasks and projects independently and be a consultant for others.
- Ability to do performance tuning: query optimization (avoid coding loop and correlated subqueries) applying indexes and partition functions.
- Ability to write debug and test stored procedures functions triggers.
Technical Skills
- 3 years experience with Extraction Transformation and Loading (ETL) process using DTS/SSIS application tools.
- 3 years experience with MS SQL Server 2008/2012/2017 including SQL Server Management Integration Services Analysis Services and Reporting Services.
- Hands on experienced in data modeling in all phases (conceptual logical and physical).
- Hands on experienced in Transact-SQL (advanced queries complex joins indexes pagination in SQL Server TRY-CATCH blocks CASE & PIVOT etc.).
- Hands on experienced in MS SQL Server database design and coding techniques work with NoSQL datatype (JSON).
- Advanced knowledge of SSIS and Data Extraction and Transformations.
- Hands on experienced in performing database unit tests to ensure code quality using SSDT.
Things that will separate you from the rest
- Practical knowledge of API and Web development.
- Well grasp of how to connect different applications and systems together demonstrated through delivered projects.
- Hands on experience with Power BI.
- Knowledge of Azure Data Factory.
Education or Certifications
- Bachelors degree in Computer Science Computer Information Systems or equivalent degree.
Eligibility Requirements
- Must be willing to submit to a background investigation and drug test as part of the selection process.
Job Type
- Full-Time
Schedule
- Monday to Friday
Work Location
- Omaha Nebraska preferred.
Benefits
- Health insurance
- Health savings account
- Dental insurance
- Vision insurance
- 401(k) matching
- Life insurance
- Paid time off
- Parental leave
- Disability insurance
- Childcare assistance
- Education reimbursement
- Fitness membership
- Volunteer time off
This job description is not intended to be all-inclusive. An employee may also perform other reasonable related business duties as assigned by their immediate supervisor or management. Principals only.
Recruiters please dont contact this job poster. DO NOT contact us with unsolicited services or offers.
Required Experience:
IC
Key Skills
- Databases
- SQL
- Database Development
- PL/SQL
- Microsoft SQL Server
- ssrs
- Database Design
- SSIS
- T Sql
- Sybase
- Data Warehouse
- Oracle
About Company
We focus on high-impact areas requiring flexibility and customization, bringing FinTech industry expertise to complex challenges.
