Database Administrator - Microsoft SQL

Argonaut Management Services, Inc
life insurance, vision insurance, parental leave, paid time off, 401(k), profit sharing, remote work
United States, New York, New York
Nov 15, 2024
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. Argo Group is seeking a Database Administrator - Microsoft SQL to be an integral part of our database and applications integration efforts in New York City. This role will be responsible for planning, coordinating, and administering databases, including base definition, structure, documentation. This role will liaise with application support teams and developers to ensure databases are architected and tuned for optimal performance and availability. Essential Functions: Supports and maintains Microsoft SQL, MySQL, No SQL databases. Conducts system tuning, performance monitoring, Data Base Security administration, Encryption, Data Masking, 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: 5+ years of relevant experience A bachelor's degree from an accredited university or equivalent 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 SQL, My SQL, No SQL, AWS RDS, Azure SQL Experience with enterprise SQL database clustering Experience with complex SQL performance tuning 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 performance tuning and monitoring tools. Experience: Microsoft SQL, - minimum of 5 years preferred MySQL, NoSQL, Database Administration: minimum of 5 years preferred Bitbucket or Git Product Environments a plus Microsoft Azure SQL, Amazon RDS a plus The base salary range provided below is for hires in those geographic areas only and will be commensurate with candidate experience. Pay ranges for candidates in other locations may differ based on the cost of labor in that location. In addition to base salary, all employees are eligible for an annual bonus based on company and individual performance as well as a generous benefits package. New York City Pay Range: $133,600 - $159,000 USD *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. The collection of your personal information is subject to our HR Privacy Notice Our Benefits 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, and holiday 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. A generous Employee Referral program that results in approximately 25% of all new hires annually.