USACares Jobs

Job Information

Travelers Associate DBA Architect in Hartford, Connecticut

Company Information

Solid reputation, passionate people and endless opportunities. That’s Travelers. Our superior financial strength and consistent record of strong operating returns mean security for our customers – and opportunities for our employees. You will find Travelers to be full of energy and a workplace in which you truly can make a difference.

Job Category


Target Openings


Job Description Summary

The primary function of this position is to assist in providing architectural guidance, technological recommendations and transition strategies that support the development and implementation of initiatives based on Common Delivery, Services Based Architecture, and Agility for moderately complex or single projects.

Primary Job Duties & Responsibilities

  • Assist in researching, advising, and supporting usage of new database features and technologies, and may perform small POCs to demonstrate usage.

  • Support the coordination of database maintenance activities with the DBA team: index rebuilds, backup/recovery, data compression.

  • Participate in Database Software evaluations: DBMS upgrades, emerging technologies, productivity tools.

  • Proficient in SQL Server such as TSQL coding Database Best Practices, Performance and Tuning Query Plan Analysis, lndexing, etc.

  • Participates in recommending appropriate database platform based on system and data requirements (relational vs NOSQL).

  • Develops database deployment automation.

  • Recommends usage of on-premises vs cloud environment.

  • Ability to work both individually and in a team environment with limited oversight.

  • Knowledge of Always On, High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.

  • Exposure to agile release processes and supporting tools and infrastructure.

  • Collaborate with onshore and offshore team.

  • Participates in creation of solutions and roadmaps, helping to driving architectural recommendations.

  • Ensure architectural adherence through blueprint and design reviews.

  • Assist in the remediation of application stability and performance.

  • Support the communicate new concepts, ideas, techniques, best practices and technology assistance.

  • Perform project level design, debug and performance analysis.

  • Responsible for the development and production support of enterprise application utilities and models.

  • Work with vendors and product management areas to establish required infrastructures and frameworks.

  • Assist in product evaluations, and Proof of Concepts'.

  • Assist in the remediation of application stability and performance.

Minimum Qualifications

  • High School diploma or equivalent required.

  • 1 year of technology related experience required.

Education, Work Experience, & Knowledge

  • Bachelor's degree in a related field preferred.

  • 2 years of technology related experience preferred.

Job Specific Technical Skills & Competencies

Technical Knowledge:

  • Exposure to Message Broker (such as Kafka), Hadoop and ElasticSearch is a plus

  • Solid understanding of lT Infrastructure Operating Systems Software Knowledge of process discipline and IDLC methodology

  • Working experience with SQL Server 2017

  • Skilled in SQL profiler, Extended Events

  • Exposure to new features such as: Columnstore lndexes, Query Store, Temporal Tables, JSON

  • Command line utilities like BCP, SeLCMD.

  • Re-factoring of database queries for performance

  • Database design and database code reviews

  • Strong scripting skills: Powershell

  • Good understanding of SSIS, and SSRS, application development ( coding skills helpful

  • Experience in MongoDB, or at least one NoSQL technologies such as Cassandra, Couchbase, Neo4j, etc. would be ideal

  • Has expert knowledge of at least one applications discipline, along with the ability to rapidly learn technical/business techniques and disciplines of special value to the systems supported

  • Possesses a working knowledge of the business and/or technical environments in which the system operates and a solid knowledge of the business function supported

  • Demonstrates the desire and aptitude to become the expert in one or more technical or project management disciplines and applies substantial effort to gaining more knowledge in that area\

Problem Solving & Decision Making

  • Devises technically feasible solutions for moderately complex problems

  • Uses innovative insights and creativity in evaluating alternatives

  • Demonstrates advanced ability to research and analyze business requirements and produce programming specifications for the system supported

  • Differentiates problem definition from symptoms

Team Orientation

  • Builds relationships with peers and other departments to achieve objectives, to work as one team and to secure necessary resources not under his/her personal control

  • Balances team/individual responsibilities

  • Exhibits objectivity and openness to others' views

  • Gives and welcomes feedback

  • Puts success of team above own interest

Self-Management: Maintains the operational integrity of a single system and the business function it supports.

  • Demonstrates maturity and discretion in handling confidential data related to the system

Commitment to Quality Result:

  • Works effectively with business unit to formulate specifications and present results of analysis

  • Works with management to establish schedules

  • Places high priority on services and consistently meets scheduled dates

  • Handles business contacts with clear, concise communication in business terms

  • Adjusts to changing priorities

  • Demonstrates attitude of willingness, cooperation, and concern for business issues

Planning and Project Management:

  • Sets appropriate goals and priorities

  • Completes multiple tasks in the time allocated to accomplish results

  • Accurately evaluates and estimates new tasks

  • Provides management with accurate and timely status information

Financial Awareness:

  • Assesses financial impact of recommended designs/solutions

  • Works with Financial Analysts to identify pertinent facts for systems/projects and cost/benefit analysis

Equal Employment Opportunity Statement

Travelers is an equal opportunity employer.