Database Administrator

Description

Database Administrator

In this position, you will be designing, coding, testing and supporting SQL Server enterprise environment. You will be committed to ensuring/applying quality database organizational and security practices. You will be proficient in an assortment of technologies, including; SQL Server management tools, monitoring utilities, Configuration, Deployment, Optimization, Geo-Clustering, Encryption, Backups.

Primary responsibilities include:

• Management of a multi-tiered virtual (VMWare) SQL Server environment including SQL server configuration, SQL installation cloning, managing MSWFC and data encryption at the instance, network and internet levels over multiple local and remote networks


• Ensuring the security and integrity of all corporate data and relative metadata in accordance with bank polices, while observing CIS benchmark and Microsoft SQL Server practices as well as banking industry standards


• Implementation, tuning and automation of maintenance and optimization plans across various SQL Server platforms, including the ability to diagnose and optimize performance at the database level, including diagnose and troubleshoot database issues


• Create TSQL based processing solutions for interdepartmental BI projects and work closely with internal teams to determine specific needs and requirements for database development.


• Periodically review and refactor code as needed and recommend solutions to enhance performance and maintainability


• Implement and deploy backup and disaster recovery solutions for a high availability and/or geoclustered environments


• Create and maintain extensive documentation of: SQL Server environment specification, SQL deployment, SQL Server maintenance plans, optimization plans, security policy and change management

Qualifications:

• Minimum of 3 years experience with MS SQL Server and prior experience as a server database administrator or developer, with experience in a MS windows server environment required


• High school diploma or general education degree (GED) required


• Strong baseline of Microsoft SQL. Extensive knowledge of developing, deploying an optimal SQL Server environment


• Efficient with data backup and disaster recovery topology and deployment, MSWF clusters, SQL, security, encryption, auditing, optimization, troubleshooting, version upgrades/controls, installations


• TSQL, DDL, DML, DMV, Sys Objects, ETLs, PowerShell, including the ability to read and write complex procedures, triggers and functions


• Excellent Troubleshooting skills, Erwin EStudio, Solar Winds and Tableau


• Effective knowledge of Microsoft SQL Server applications: SSMS, SSIS (including Catalogs), Visual studios (DTSX, RDLs extensive ETL processes), SSRS, SSAS, DTA, Profiler, Traces, P, R and monitors, Resource governor, Policy management.

Employee Benefits:

• CompetitiveBONUS program


• Excellent health benefits with award winning wellness program


• Tuition and gym reimbursement


• 401K with company match


• Pet Insurance

Join a winning team!Signature Bank has appeared on Forbes'Best Banks in America list for the tenth consecutive year in 2020.

Signature Bank, member FDIC, is a New York-based full-service commercial bank with private client offices throughout the New York metropolitan area. In 2018, the Bank expanded its footprint on the West Coast with the opening of its first full-service private client banking office in San Francisco. The Bank's growing network of private client banking teams serves the needs of privately owned businesses, their owners and senior managers. Signature Bank offers a wide variety of business and personal banking products and services.

View available Careers with Signature atwww.signatureny.com/careers

We are an Equal Opportunity Employer.

We donotsponsor work visas.

#LI-MF1

First Time Applicants

If interested, please submit your resume online. This is the fastest and most reliable way to be considered for any of our positions. Incomplete applications or those missing required information will not be considered.

*Signature Employees - Do NOTuse this site. Please applyvia the Workday login pageor contact Human Resources - Staffingif you have questions.