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. Aperia’s 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
Aperia offers a competitive salary package and a great work environment. We have an immediate need for a Senior SQL Developer to join our team. The SQL team is responsible for not only database applications and procedures but also analysis and application development.
Core Responsibilities
- Designs, builds and implements relational databases
- Tests databases for performance, fine-tuning when necessary
- Completes documentation on all assigned systems and databases, including business rules, logic,and processes
- Tests documents and implements developed programs
- Works closely with other members of the BA, DBA and IS teams, sharing knowledge and makingrecommendations as needed
Required Skills and Experience
- At least 5 years’ experience with Extraction, Transformation and Loading (ETL) process using DTS/SSIS application tools
- Good Transact-SQL (advanced queries, complex joins and indexes)
- Advanced knowledge of DTS/SSIS and Data Extraction and Transformations
- Ability to write, debug and test stored procedures, functions, triggers
- Ability to optimize stored procedures written by others
- Ability to troubleshoot database performance issues
Things that separate you from the rest
- Experience in Azure Data Factory
- Experience applying CI/CD practices for SQL database
Education or Certifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
Job Type
- Full-Time
Schedule
- Monday to Friday
Work Location
- Ho Chi Minh City: The Six8 Building - 24-26 Phan Dinh Giot, Tan Son Hoa Ward.
- Da Nang City: VDB Tower - 74 Quang Trung, Hai Chau District.
Benefits
- Competitive Salary Package – Enjoy a rewarding income from day one.
- Security from the Start – Full salary during probation plus complete social insurance coverage.
- Premium Health Insurance – Comprehensive protection for you and your loved one (spouse/children).
- Family-Friendly Benefits – Monthly childcare support to make parenting easier.
- Generous Leave Policies – 15 days annual leave, 6 weeks paternity leave, and 10 days bereavement leave.
- Active Lifestyle – Join our vibrant clubs: Football, Billiards, Badminton, and E-sports...
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 don't contact this job poster. DO NOT contact us with unsolicited services or offers.
Skills Required
- At least 5 years' experience with ETL using DTS/SSIS
- Advanced Transact-SQL (advanced queries, complex joins and indexes)
- Advanced knowledge of DTS/SSIS and data extraction and transformations
- Ability to write, debug and test stored procedures, functions, triggers
- Ability to optimize stored procedures written by others
- Ability to troubleshoot database performance issues
- Experience in Azure Data Factory
- Bachelor's degree in Computer Science, Information Technology, or related field
What We Do
Your success is our objective. We have more than a decade of service providing business intelligence solutions and applying extensive experience and knowledge to your business requirements. From its roots in the finance, banking, and the payments industry, Aperia expanded to become the preeminent provider of ETL, BI, and hosted solutions in a variety of industries. Aperia platforms scale with industry, processing massive volumes on time. The Software as a Service (SaaS) platforms support millions of end users creating billions of transactions per day, all with the speed and reliability required for business. The company’s management combines more than a century in finance, business consulting, rapid growth, and governance, as well as business intelligence, the company’s core function. Aperia knows that data holds power and providing the precision tools to release that power from data in any format is our passion, skill, and talent.
