Database Administrator, Oracle and SQL

Chicago, IL, United States

Argo Group is a leader in specialty insurance with a vibrant culture built on respect, equality, wellness and opportunity. We’re an innovative organization that’s small enough to be agile and big enough to make a difference in our industry.

Our flexible workplace is continuously evolving to ensure all employees feel:

Comfortable bringing their whole selves to work.

Confident that they will be treated respectfully.

Recognized for their performance and provided with equal opportunities to succeed.

At Argo, skill meets opportunity. If you’re wired to raise your hand and ask, “Where can I help?”, you’ll thrive with us.

We have an exciting opening for a Database Administrator focused on Oracle for our office in Chicago, IL. This role is hybrid and will involve working in our Chicago office on Tuesdays, Wednesdays and Thursdays each week.

Essential Functions:

Supports and maintains Oracle primarily. Will also collaborate closely with our DBA who supports SQL, MySQL, No SQL databases.

Conducts system tuning, performance monitoring, and database maintenance.

Assists with application, developer, and user support.

Provide technical support and maintain database structure and architecture.

Perform tests and evaluations regularly to ensure data security, privacy, and integrity.

Monitory database performance, implement changes, and apply new patches and versions when required.

Implement and manage Connections with external data sources.

Plan and execute Database lifecycle management efforts.

Qualifications:

7+ years of relevant experience.

Must be well versed in Oracle.

A bachelor’s degree from an accredited university in computer science, information technology, or related field, or equivalent years of work experience.

Excellent knowledge of data backup, recovery, security, performance, maintenance, and integrity.

Writes complex SQL and PL/SQL functions, procedures, packages, and triggers.

Creates tables and views.

Experience tuning Oracle & SQL.

Demonstrated ability to work from complex requirement documents.

Experience managing database and code in a version-controlled environment.

Experience adhering to coding standards.

Experience creating and modifying database designs/models.

Experience creating partitioned tables.

Experience performing database administration tasks such as patching, creating users, granting privileges, etc.

Experience as an ETL developer automating the loading and transfer of large amounts of data from complex applications and data warehouses.

Experience working in a hybrid support model with onshore and offshore support teams.

Experience with Microsoft SQL and Oracle licensing.

Experience with Oracle applications.

Experience with Microsoft SQL and Oracle performance tuning and monitoring tools.

Experience:

Oracle: 5+ years preferred

MySQL, NoSQL 3+ years

Database Administration: minimum of 5 years preferred

Bitbucket or Git Product Environments a plus

Cloud RDS and Microsoft Azure SQL, Amazon RDS a plus

PLEASE NOTE: At this time, Argo Group will not sponsor an applicant for employment authorization for this position.

If you have a disability under the Americans with Disabilities Act or a similar law and you wish to discuss potential accommodations related to applying for employment at Argo Group, please contact our Benefits Department at 210-321-8400.

To all recruitment agencies : Unless you have been requested to work on this position, or other positions with Argo Group, please do not forward any resumes to Argo Group employees. Argo Group is not responsible for any fees related to unsolicited resumes.

PLEASE NOTE: At this time, Argo Group will not sponsor an applicant for employment authorization for this position.

If you have a disability under the Americans with Disabilities Act or a similar law and you wish to discuss potential accommodations related to applying for employment at Argo Group, please contact our Benefits Department at 210-321-8400.

To all recruitment agencies : Unless you have been requested to work on this position, or other positions with Argo Group, please do not forward any resumes to Argo Group employees. Argo Group is not responsible for any fees related to unsolicited resumes.

Argo Group International Holdings, Ltd. is an underwriter of specialty insurance products in the property and casualty market. Argo offers a full line of products and services designed to meet the unique coverage and claims-handling needs of businesses. The company is a wholly owned subsidiary of Brookfield Reinsurance Ltd. Argo and its insurance subsidiaries are rated ‛A-’ by Standard and Poor’s. Argo’s insurance subsidiaries are rated ‛A-’ by A.M. Best. More information about Argo is available at www.argogroup.com .

We are an Equal Opportunity Employer. We do not discriminate on the basis of age, ancestry, color, gender, gender expression, gender identity, genetic information, marital status, national origin or citizenship (including language use restrictions), denial of family and medical care leave, disability (mental and physical) , including HIV and AIDS, medical condition (including cancer and genetic characteristics), race, religious creed (including religious dress and grooming practices), sex (including pregnancy, child birth, breastfeeding, and medical conditions related to pregnancy, child birth or breastfeeding), sexual orientation, military or veteran status, or other status protected by laws or regulations in the locations where we operate. We do not tolerate discrimination or harassment based on any of these characteristics.

Developing our employees professionally and personally strengthens our organization.

Argo Group offers an attractive Total Rewards package that includes:

A culture that recognizes performance and empowers employees to excel, offering competitive compensation and merit driven profit sharing.

Flexible workplace policies that support employee well-being include compressed hours, flex-time, job-sharing, remote work, sabbatical leave, holiday and summer hours.

Comprehensive health, wellness, and financial planning options that employees can tailor to meet their personal and family needs. In addition to traditional health and wellness plans, benefits include dental, disability, life insurance, medical, and vision insurance, matching 401(k) retirement savings, generous paid time off (21 days of PTO, 11 paid company holidays, 3 floating holidays and a paid voluntary day), paid caregiver and parental leave, paid bereavement, jury duty/court appearances, and military (up to 14 days) leave, employee assistance program (EAP), and an array of voluntary benefits.

Argo Academy, a digital and instructor-led platform that offers continuous learning and professional development – Training magazine lists Argo among the Training "Top 125" Companies. Argo encourages career mobility and continuing education to pursue and maintain professional and industry designations, in addition to traditional university and higher education programs.

An inclusive culture that develops and sponsors diverse teams, encourages cross-functional engagement and collaboration, builds community through employee resource groups (ERGs), and provides an environment that welcomes ongoing dialogue, creative innovation, professional and personal development.

Active community outreach and volunteer programs in addition to matching charitable gifts by 100%.

A generous Employee Referral program that results in approximately 25% of all new hires annually.

For the position to which you are applying, will you now or in the future require employment-based sponsorship from Argo Group and its subsidiaries or any other form of immigration approval where applicable?  *

-- If permissable in your country, are you willing to submit to a formal background check or other pre-employment screening? (If applying in Brazil, please select 'Not Applicable')  *

--

Have you been previously employed by Argo Group or one of its subsidiaries? Or, are you currently working with Argo on a contract or agency-placement basis?  *

--

Are you subject to a non-compete agreement, contract restriction, audit independence requirement, or any other restriction imposed by a current or former employer or regulator that may impact your employment with Argo Group?  *

--

If applying to a position in the United States, are you at least 18 years of age?  *

--

Can you please specify your citizenship or immigration status?  *

Do you have 5+ years of Oracle experience and have the capability to drive all Oracle related activities?  *

What are your desired base salary expectations for this role?  *

Please confirm that you currently reside within a reasonable daily commute to downtown Chicago and willing to work a hybrid work schedule (3 days in office).  *

--

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Argo Group’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Voluntary Self-Identification of Disability Form CC-305

Page 1 of 1

OMB Control Number 1250-0005

Expires 04/30/2026

Voluntary Self-Identification For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Argo Group’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

Gender Please select Gender Are you Hispanic/Latino? Please select Are you Hispanic/Latino? Race & Ethnicity Definitions If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Veteran Status Please select Veteran Status Voluntary Self-Identification of Disability Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04/30/2026

Why are you being asked to complete this form? We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp .

How do you know if you have a disability? A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

Alcohol or other substance use disorder (not currently using drugs illegally)

Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS

Blind or low vision

Cancer (past or present)

Cardiovascular or heart disease

Celiac disease

Cerebral palsy

Deaf or serious difficulty hearing

Diabetes

Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders

Epilepsy or other seizure disorder

Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome

Intellectual or developmental disability

Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD

Missing limbs or partially missing limbs

Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports

Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)

Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities

Partial or complete paralysis (any cause)

Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema

Short stature (dwarfism)

Traumatic brain injury

Disability Status Please select Disability Status PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

#J-18808-Ljbffr