Sql Dba
Company:

Travelers Insurance


Place:

Connecticut


Details of the offer

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.
Target Openings

1
Job Description Summary

The primary function of this position is to provide 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

Research, advise, and support usage of new database features and technologies, and may perform small POCs to demonstrate usage.
Recommend and coordinate database maintenance activities with the DBA team: index rebuilds, backup/recovery, data compression.
Database Software evaluations: DBMS upgrades, emerging technologies, productivity tools.
Expert in SQL Server such as TSQL coding Database Best Practices, Performance and Tuning Query Plan Analysis, lndexing, etc.
Recommending appropriate database platform based on system and data requirements (relational vs NOSQL).
Database deployment automation.
Recommend 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.

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 product/project management and/or Software Development Life Cycle preferred.
Job Specific Technical Skills & Competencies

Technical Knowledge
Foundational 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 (vb.net) coding skills helpful.
Experience in MongoDB, or at least one NoSQL technologies such as Cassandra, Couchbase, Neo4j, etc. would be ideal.
Exposure to Message Broker (such as Kafka), Hadoop and ElasticSearch is a plus.
Problem Solving & Decision Making
Demonstrates sound analytic and diagnostic skills dealing with issues that are loosely defined and/or where information is available but must be further manipulated.
Once decisions are made, is able to follow and direct action to implement intended results.
Breaks a problem down to manageable pieces and implements effective, timely solutions.
Openly and directly confronts conflict until resolved. Knows how to execute to get things done.
Able to perform credible analyses.
Uses sound judgment and reasoning to draw conclusions leading to the selection of the best solution from a review of the alternatives.
Effectively assesses short-term implications of decisions and understands the impact on the department and business unit(s) supported.
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 and individual responsibilities.
Exhibits objectivity and openness to others' views.
Gives and welcomes feedback.
Puts success of team above own interest.
Self-Management
Supports a distinct business unit or several smaller functions.
Responsibilities are assigned with some latitude for setting priorities and decision-making using established policies and procedures.
Results are reviewed with next level manager for clarification and direction before proceeding
Commitment to Quality Results
Creates an atmosphere where business partner's issues are dealt with professionally, and in a timely manner.
Suggests solutions that make sense and optimize the value of assigned projects.
Communicates openly and effectively in a manner consistent with the audience.
Recognizes the importance of superior quality in providing a competitive edge.
Ensures that reports are precise, timely and accurate.
Planning and Project Management
Works with the project manager/manager in identifying those project tasks that are most important, establishes clear priorities and understands the larger picture.
Anticipates and effectively responds to changes in workload and resources
Financial Awareness
Understands, has input to the budget process, and shares responsibility for cost-effective expense control of assigned projects.
Is responsible for important and confidential information.
Equal Employment Opportunity Statement

Travelers is an equal opportunity employer.
Travelers is an equal opportunity employer.


Source: Dice


Area:

Requirements


Knowledges:

  • Utilities
  • SQL

Executive sales officer : vp (equipment finance)

Signature Financial targets lease and loan transactions financing construction, transportation, industrial, manufacturing and medical equipment to middle market...


New York

Published a month ago

Plant mechanic :(local 127) point of rocks, wy : 52958

Responsibilities 13; A plant Mechanic is a Journeyman Mechanic who is responsible for installing and maintaining structural or mechanical equipment at the plant...


Wyoming

Published a month ago

Rn, tele health fulltime

Looking for your next opportunity? If so, choose Parkland and discover what a meaningful job feels like. Whether you work directly with patients or use your...


Texas

Published a month ago

Registered nurse (rn) : atrium health cabarrus endoscopy ft

Job Req ID: Position Number: Employment Type: Full Time Shift: Day Shift Details: Monday : Thurs (8:00am to 4:30 pm) Friday:Sun (12 hours Call) then off...


North Carolina

Published a month ago