SQL Server Database Administrator
The SQL Server Database Administrator is the subject matter expert for database management technologies and platforms, providing technical leadership and direction for key strategic initiatives. This position will lead data planning design and support of an architecture that will support the information needs of the enterprise in a flexible but secure environment.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
Administer and control activities related to data planning and repository requirements, data dictionaries, and warehousing requirements to develop and design database strategies and information systems monitoring.
Build database schemas, tables, and dictionaries conforming to industry standards
Create functions, scripts stored procedures, and triggers to support application development
ETL (extract, transform, load) workflow management
Responsible for developing PowerBI dashboards and reports using PowerBI Report Builder to meet the needs of stakeholders ranging from production staff to executives
Responsible for writing complex SQL Server queries using SSMS
Work with SQL and other database access tools and methods to address business requirements while maintaining control, integrity, and accessibility of data
Capacity for developing PowerBI dashboards and reports using PowerBI Report Builder to meet the needs of stakeholders ranging from production staff to executives
Provides support to other internal teams on database functions including maintenance, development, and performance enhancement
Possess working knowledge of Relational Database Management Systems (RDBMS) and data warehouse front-end tools
Continuously increase data coverage by working closely with subject matter experts to automate and streamline reporting across the organization
Lead on technical projects including analysis, planning, and development requirements and standards
Communicate complex information to technical and non-technical audiences
Oversee troubleshooting of system issues
Assist in developing and maintaining data standards, data flows, new data requirement specifications, and test cases for QA
Collaborate with leadership to create and promote a data-driven culture
Support audits and data quality reviews
Researches and evaluates software, system upgrades, and enhancements, and provides technical recommendations. Rely on experience and judgment to plan and accomplish goals.
Provide leadership, coaching, and/or mentoring to the MIS reporting team.
Subject matter expert in the development of the information systems roadmap as means to ensure the organization has the proper reporting software and infrastructure
Not to harm consumers with any act that could be misleading, unfair, deceptive, or abusive in act or practice
Maintain current knowledge of all federal and state laws and regulations, along with the Bank’s policies and procedures
Must adhere to the company’s core values of Challenge Convention, Do What’s Right, Take Ownership, Empower People, Exceed Expectations, and Cultivate Awesome all while keeping our “Why?” front of mind. Our Why? Silvergate is the banking platform for innovators, and we believe in the power of entrepreneurs to create prosperity for our communities
8+ years of Database Admin experience working in a SQL Server environment
Experience with both hosted and cloud-based services including Azure and AWS
Microsoft SQL Server 2016+ and Azure SQL
Strong SQL and C# experience
PowerBI experience is a plus
Experience working with high availability and server tuning including parameters, resources, contention, etc.
Effective written and oral communication
The ability to establish and maintain cooperatives and effective working relationships with others
Ability to adapt quickly and to balance between attention to detail and strategic vision
Familiar with a variety of the field’s concepts, practices, and procedures
BANK SECRECY ACT REQUIREMENTS:
Responsible for adhering to the reporting and recordkeeping requirements of the Bank Secrecy Act and Anti-Money Laundering rules and regulations, observing economic sanctions by prohibiting transactions as specified by the Office of Foreign Asset Control (OFAC), following the Company’s customer identification program (CIP) rules, observing all Company policies and procedures relating to BSA, OFAC, CIP, and related acts, and participation in ongoing related training.
While performing the duties of this job, the employee is:
Regularly required to talk or hear
Required to communicate with customers and coworkers verbally and in writing
Occasionally required to stand; walk
Occasionally required to lift up to 10 pounds
Required to sit for long periods and reach with hands and arms
Able to read documents, computer screens, reports, and other communications and have the ability to adjust focus and close vision.