Description

Who We Are
Newport helps companies offer their associates a more secure financial future through retirement plans, insurance and consulting services. Newport offers comprehensive plan solutions and consulting expertise to plan sponsors and the advisors who serve them. As a provider and partner, Newport is independent, experienced and responsive.

Job Summary:

Responsible for the design, development, upgrade, maintenance and overall performance planning of the database environments from project inception to ongoing support and decommissioning of the databases.
Essential Functions Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
• Manages DBA support queue in issue tracking system
• Proactively monitors SQL servers for performance, security, stability, and recovery
• Identifies opportunities and implements solutions for users to self-serve repeated requests
• Implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company databases
• Enhances existing database architecture to support new features, performance improvements, upgrades, and ongoing sustainment
• Participates in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment
• Learns relevant business processes and understands & manages the data flow, criticality and dependencies
• Assists scrum teams with SQL development and writing complex stories/procedures
• Participates in 24x7 on call rotation
• Demonstrates high ethical standards regarding the company's treatment of confidential information
• Works under pressure in a fast paced environment
• Regular, reliable and punctual attendance
Required Education, Experience and Certificates, Licenses, Registrations
• Bachelor's degree in Computer Science, Information Technology or similar field of study.
• - 10 years of experience in designing, deploying, and maintaining SQL Server infrastructures.
• Writing T-SQL and stored procedures and code tuning on high transaction systems.
• Logic and performance issues in T-SQL stored procedures.
• Loading and extracting data using SQL Server Integration Services (SSIS).
• Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
Preferred (but not required) education or skills for this role
• MCSA SQL certification preferred.
Competencies
• Analytical Thinker
• Independent
• Detail Oriented
• Problem Solver
• Resourceful
• Team Player
• Written and Verbal Communication
• Personal Credibility

TRAVEL:
Up to 5%

OTHER DUTIES

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job.
Duties, responsibilities and activities may change at any time with or without notice.

EQUAL OPPORTUNITY EMPLOYER
Newport offers for employment are conditioned upon satisfactory completion of our employment screening process (including, but not limited to, a review of past employment and education records, background investigation, and/or credit check and fingerprints.)

Newport unequivocally rejects racism and discrimination of any kind and fosters an environment of belonging to provide access and opportunity for all.

As an Equal Opportunity Employer we do not discriminate on the basis of race, religion, color, sex, sexual orientation, gender identify, gender expression, national origin, age, non-disqualifying physical or mental disability, veteran status, or any other basis covered by applicable law.
All employment is decided on the basis of qualifications, merit, and business need.

Responsibilities

• Responsible for the design, development, upgrade, maintenance and overall performance planning of the database environments from project inception to ongoing support and decommissioning of the databases
• Essential Functions Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions
• Manages DBA support queue in issue tracking system
• Proactively monitors SQL servers for performance, security, stability, and recovery
• Identifies opportunities and implements solutions for users to self-serve repeated requests
• Implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company databases
• Enhances existing database architecture to support new features, performance improvements, upgrades, and ongoing sustainment
• Participates in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment
• Learns relevant business processes and understands & manages the data flow, criticality and dependencies
• Assists scrum teams with SQL development and writing complex stories/procedures
• Participates in 24x7 on call rotation
• Demonstrates high ethical standards regarding the company's treatment of confidential information

Qualifications

• Works under pressure in a fast paced environment
• Regular, reliable and punctual attendance
• Required Education, Experience and Certificates, Licenses, Registrations
• Bachelor's degree in Computer Science, Information Technology or similar field of study
• - 10 years of experience in designing, deploying, and maintaining SQL Server infrastructures
• Writing T-SQL and stored procedures and code tuning on high transaction systems
• Logic and performance issues in T-SQL stored procedures
• Loading and extracting data using SQL Server Integration Services (SSIS)
• Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance
• Analytical Thinker
• Independent
• Detail Oriented
• Problem Solver
• Resourceful
• Team Player
• Written and Verbal Communication
• Personal Credibility