Our current job postings

Database Administrator (Remote)

  • Employer: iA American Warranty, L.P.
  • Office: 2400 Louisiana Blvd NE
  • Location: Albuquerque, New Mexico
  • Other Possible Location(s): Austin, Texas
  • Job category: Not Evaluated (Job Family)
  • Job ID: JR10015669
  • Job type: Permanent Job Full time
  • Apply before: 2023-02-23

Description

Join our IT team as a Database Administrator! You'll oversee and implement the processes to keep our systems operational. Come make a difference. Opportunity for contract to hire.
Who you are: 10 years of experience in database design and administration, SQL Server, and participating in the software development lifecycle. Bachelor's degree in Computer Science or related field required. Analytical, problem solver who's looking to make a business impact and join an evolving company. Results-oriented with a focus on client experience and corporate goals. Interested in the insurance or warranty industries.
Technical knowledge:
  • SQL Server high availability configurations and Integration Services Catalog.
  • Azure database environments.
  • Knowledge of SQL Server MSX/TSX environments and configuration.
  • Knowledge of PowerShell and its use in Database Administration and tasks.
Your impact
  • 70% Database Administration: you'll oversee 12-15 servers at a time, and eventually more. Manage multiple versions of SQL Server across various production, test, and development database servers in Azure. Design and implement database backup and recovery schemes across all environments (production, Development, QA (Quality Assurance), UAT (User Acceptance Testing), etc.). Maintain database security and integrity for Active Directory and SQL Server accounts and groups. Manage SSIS (SQL Server Integration Services) Integration Services Catalog. Oversee SQL Jobs on an MSX/TSX environment. Manage SQL Server Reporting Services installation, configuration, troubleshooting, and access. Monitor server performance, identification of problem queries/stored procedures, and coordinate with Development Team on corrections.
  • 20% Database Architecture: you'll determine database structural requirements and review schema changes. Collaborate on best practices for database code. Design database recovery solutions.
  • 10% Database Development: develop ETL (Extraction, Transforming, and Loading) processes using SQL Server SSIS. Create T-SQL code for implementing application business logic using stored procedures, the import, and export of data between the company and vendors, and application functionality that hasn't been built into our apps.
About us

iA American is a wholly-owned subsidiary of iA Financial Group, one of the largest insurance and wealth management groups in North America. In the last few years, iA American has been thoughtfully built by iA Financial Group through the acquisition of Innovative Aftermarket Systems (IAS), SouthwestRe, and Dealers Assurance Company (DAC). Our suite of products and services includes automotive protection packages, reinsurance options, dealer support, direct-to-consumer products, and in-house administration.
In 2022, our CEO, Denis Ricard, won #1 insurance CEO in Canada from Glassdoor! iA Financial Group is the fourth largest life and health insurance company in Canada and offers a wide range of products for all stages of life, and to meet the needs of clients across its vast sales network. Founded in 1892, iA Financial Group’s stability and solidity make it an employer of choice that invests in its employees and their development over the long term.
Our commitment to Diversity and Inclusion
At iA, we support and celebrate diversity. We strive to provide a workplace that is recognized as inclusive for all, regardless of ethnic origin, nationality, language, religious beliefs, gender, sexual orientation, age, marital status, family situation, or physical or mental disability.
Please note that if you need help or assistance to make the recruitment process more accessible for you, please contact us. Someone from our team will be happy to assist you.

At iA, we invest,
in you.

Our employees are our best investment and we have much to offer them.


Company Overview

About

iA Financial Group is the strength of a company with a human side, with its over 8,000 employees. Together, we have earned the trust of our more than four million clients and 50,000 advisors who have chosen us for their insurance, savings, and wealth management.

With over $200 billion in assets and half a billion invested in technological innovation, we’re a key player in the financial services industry in Canada and the United States. The secret to our success? Investing in you, one person at a time. Because, for over 125 years, we have believed that it’s by supporting our employees and surrounding ourselves with the most reputable leaders in the industry, we will continue to innovate.

At iA, we’re invested in you.

Our commitment to Diversity and Inclusion

At iA Financial Group, we support and celebrate diversity. We strive to provide a workplace that is recognized as inclusive for all, regardless of ethnic origin, nationality, language, religious beliefs, gender, sexual orientation, age, marital status, family situation, or physical or mental disability.

Please note that if you need help or assistance to make the recruitment process more accessible for you, please contact us here. Someone from our team will be happy to assist you.