Job Description

As an engineer in this team, the individual will be involved in the plan, build and run activities related to Microsoft SQL Server Database technology and infrastructure. The role will contribute to the design/architect, solution engineering, and support; will be responsible for delivering database projects, maintaining the running systems, able to perform problem analysis and troubleshooting. The individual should be well versed in database administration and engineering practices and principles.  The individual will share the responsibility of overall database build, deployment and support. He or she will provide technical influence and subject matter expertise for the database team, responsible for solving complex problems and taking a broad perspective to identify innovative solutions. The role serves as a technical/functional specialist and works independently with guidance only in the most complex situations.

Primarily the architecture, engineering, deployment and support of MSSQL database technology. Support Database Administration and Engineering in the architecture, design, development and deployment, and management of Microsoft SQL database environments. This includes the advanced to expert engineering and implementation of the following: 

ESSENTIAL FUNCTIONS

• Collaborate with developers and QA leads to improve testability, automation, and tools
• Design and develop QA load / automation tools and test frameworks
• Work with the team to increase the test coverage
• Take ownership of test deliverables with minimal oversight
• Lead and execute testing during all stages of development and release cycle
• Work with QA leads to develop and improve effectiveness of automation
• Design and execute test plans, scenarios and scripts
• Provide oversight and guidance to other test team members
• Identify process deficiences and suggest improvements
• Conduct test plan reviews with stakeholders
• Document software defects, using a bug tracking system, and report defects
• Determine risks to test deliverables and create mitigation plans
• Monitor bug resolution efforts and track successes
• Define test parameters, design tests, interpret test results and analyze test trends
• Assist in managing the test platforms

Qualifications

BASIC QUALIFICATIONS

• 4 years of work experience with a Bachelor’s Degree or at least 2 years of work experience with an Advanced degree (e.g. Masters, MBA, JD, MD) or 0 years of work experience with a PhD degree

PREFERRED QUALIFICATIONS

• 7-10 years of work experience and a Bachelor’s Degree or 6 years of work experience with an Advanced Degree (e.g. Masters, MBA, JD, MD) or 3 years of experience with a PhD

• Strong knowledge and extensive experience with Microsoft SQL server technologies (all core areas: SSMS, SQL clustering, Data Synchronization, Encryption, Partitioning, Performance, Security, SSAS, SSIS and SSRS configuration) is mandatory.Sound knowledge of all windows and SQL utilities; strong PowerShell knowledge and experience is a plus.

• Solid understanding of network, storage, tiered application environments and security.

• Solid knowledge in database replication technologies including Always-on, GoldenGate, etc. and strong architectural/engineering skills to design systems that meet various applications High Availability and Disaster Recovery requirements.

• Have good experience in engineering processes supporting repetitive or frequent tasks in database administration or deployment.

• Solid understanding and experience in maintain MSSQL technology lifecycle, and automation of MSSQL deployment.

• Good engineering skills in developing enterprise solutions to support MSSQL in areas like backup, monitoring/alerting, security compliance, patching, etc.

• Good interpersonal skills along with effective communication (both written and verbal) skills.

• Demonstrate ability to solve complex systems and database environment issues.

• Demonstrate ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs.

• A good team player, leader, flexible, share knowledge, help others, collaborate well within and outside the team.

• Work experience in a Financial Institute will be preferred.

Additional Information

WORK HOURS: 

• Incumbent must make themselves available during core business hours.
• May require some after business hours coverage.

TRAVEL REQUIREMENTS:

• This position requires the incumbent to travel for work 5% of the time.

PHYSICAL REQUIREMENTS

This position will be performed in an office setting.  The position will require the incumbent to sit and stand at a desk, communicate in person and by telephone, frequently operate standard office equipment, such as telephones and computers, reach with hands and arms, and bend or lift up to 25 pounds. 

Visa will consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law.