Job Description:
10+ years with SQL Server Administration required. Participates in design, development and implementation of complex databases, often using new technologies. Viewed as the subject matter expert for the team. Manages multiple, complex projects and direct activities of a team related to special initiatives or operations. Routine accountability is for technical knowledge and capabilities of a team or as an individual contributor. Provides guidance to less seasoned consultants. Works on complex problems where analysis of situations or data requires an in-depth evaluation of various factors. Exercises judgment within broadly defined practices and policies in selecting methods, techniques, and evaluation criterion for obtaining results. Work leadership requires assigning tasks and resolving problems.
Experience with/knowledge of Microsoft Azure and/or operating system experience required. Computer Science degree preferred and financial services experience desired.
Primary Skill

• MS SQL Server

Secondary Skill

• Microsoft Azure

Required Skills

• Experience with/knowledge of SQL Server High Availability solutions including Windows Server Failover Clustering and Always on Availability Groups
• Minimum of 10 years.
• Experience with/knowledge of managing Azure Stack using WAC (Windows Admin Center)
• Experience with/knowledge of Microsoft Azure
• Knowledge of core Windows services, administration and Hyper-V management
• Experience managing team efforts
• Configure database mirroring, log shipping, always on and SQL replication as part of Disaster Recovery and high availability Strategy
• Perform database backup/recovery management and capacity planning. Backup and recovery of SQL databases
• Implement monitoring procedures to maximize availability and performance of the database/instances
• Troubleshooting and performing root cause analysis of problems and recommend solutions to resolve the problems.
• Expert in Performance Tuning and Query Optimization, Partitioning, Compression, indexing
• Participate in design and code reviews to promote system reliability and efficiency by implementing standards and best-practices.
• Perform code migrations and updates through lower level environment and ultimately into production.
• Experience to lead projects and work with people in different time zones & teams across the enterprise.
• Assist application developers in refining complex queues and performance tuning.
• Ability to work well under pressure and independently

Desired Skills

• Previous task/process automation skills utilizing scripting or tools like foglight recovery actions, autosys

Shift:
1st shift (United States of America)
Hours Per Week:
40
Pay and benefits information
Jersey City pay range:
$85,000 - $125,000 annualized salary, offers to be determined based on experience, education and skill set.
Discretionary incentive eligible
This role is eligible to participate in the annual discretionary plan. Employees are eligible for an annual discretionary award based on their overall individual performance results and behaviors, the performance and contributions of their line of business and/or group; and the overall success of the Company.
Benefits
This role is currently benefits eligible . We provide industry-leading benefits, resources and support to our employees so they can make a genuine impact and contribute to the sustainable growth of our business and the communities we serve.