Systems Architect
Apply NowCompany: Dime Community Bank
Location: Hauppauge, NY 11788
Description:
Summary: Dime Community Bank ("Dime") is currently hiring for a Systems Architect position based at its Headquarters in Hauppauge, Long Island. Working collaboratively with the Integration & Innovation team, the Systems Architect will be responsible for database administration (DBA), and API management. This role involves designing, optimizing, and maintaining databases, managing, and integrating APIs, and building efficient backend solutions. The role requires a strong understanding of data management, and API management, ensuring seamless communication between applications and databases.
Salary commensurate with experience, ranging from $80,000 to $110,000 annually. The exact compensation may vary based on relevant experience, skills, education, training, licensure and certifications, and location. Dime does not provide relocation assistance or visa sponsorship (now or in the future).
All applicants must attach a recent resume. This is a hybrid role.
Responsibilities:
Qualifications:
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
Salary commensurate with experience, ranging from $80,000 to $110,000 annually. The exact compensation may vary based on relevant experience, skills, education, training, licensure and certifications, and location. Dime does not provide relocation assistance or visa sponsorship (now or in the future).
All applicants must attach a recent resume. This is a hybrid role.
Responsibilities:
- Manage, maintain, and optimize SQL databases to ensure high performance and reliability.
- Monitor database health, troubleshoot issues, and improve efficiency.
- Write and optimize SQL queries, stored procedures, and database scripts.
- Design and Integrate APIs to connect different software systems.
- Work with SharePoint, including managing data, workflows, and Integration.
- Optimize system performance by troubleshooting and fixing technical issues.
- Ensure data security and backup processes are in place.
- Collaborate with teams to improve software and database solutions.
Qualifications:
- Bachelor's degree in an IT-related discipline (Computer Science, MIS, Software Engineering). Master's degree preferred.
- Minimum five years' experience in database development and administration with aptitude to maintain and administrate a SAS platform. Experience working for a bank or other financial institution a plus.
- Strong working knowledge of and certification in SQL Server 2012, 2014, 2016 required, including Integration Services.
- Experience in TSQL, VBScript, JScript, PowerShell, Batch programming required.
- Software development experience in one or more languages (e.g., Python, C/C++, Java, HTML, SAS) required.
- Experience developing database environments using various platforms such as Oracle, SQL Server, and Hadoop required.
- Strong background in designing reports in various reporting solutions such as Tableau, SAS Visual Analytics, IBM Cognos a plus.
- Strong working knowledge of IIS and Apache a plus.
- Strong written and verbal communication skills including technical writing skills.
- Must possess strong critical thinking and complex technical problem-solving skills.
- Experience in both Linux and Windows environments, preferably as an administrator.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)