Systems Analyst and Database Administrator

City National Bank (CNB); Coral Gables (FL); On-site; USD 90,000 - 130,000; Full time

Job summary

City National Bank of Florida is seeking a Systems Analyst & Database Administrator to manage on-premises and cloud database environments, ensuring reliability, performance, security, and availability. The role also supports Power BI environments and gateway infrastructure, enabling successful data delivery across enterprise platforms.

The incumbent collaborates with Data Operations, Data Engineering, Data Architecture, Cybersecurity, and stakeholders to troubleshoot, automate, and modernize

Qualifications

• 5-7 years of progressive experience in systems analysis and database administration.
• 5-7 years administering Microsoft SQL Server environments in production.
• 3-5 years experience support database performance tuning, backup and recovery, disaster recovery, patch management, and production support.
• Experience troubleshooting database, application, and connectivity issues in complex enterprise environments.
• Experience supporting production incidents, service requests, operational monitoring, and service restoration activities.
• Experience with data analysis, data modeling, data warehouse concepts, and reporting environments.

Responsibilities

• Applies systems analysis techniques to determine hardware, software, database, and system requirements.
• Administers and maintains enterprise database platforms across on-premises and cloud environments, ensuring reliability, performance, security, and availability.
• Monitors database health, performance, capacity, storage utilization, and operational processing activities to identify and resolve issues.
• Investigates and resolves database-related incidents, service requests, production issues, and operational exceptions.
• Performs database performance analysis and tuning, including optimization of queries, indexes, stored procedures, and configurations.
• Plans, coordinates, tests, and implements database maintenance activities, including upgrades and patches.
• Maintains and tests backup, recovery, disaster recovery, and service restoration procedures.

Skills

Systems analysis

Database administration

SQL Server

Power BI

Data modeling

Data integration

Incident management

On-call support

Security compliance

Education

Bachelor's Degree in CS/IS

Equivalent experience accepted

Tools

SSIS

Azure Data Factory

SSRS / Reporting Services

Job description

Overview

The Systems Analyst & Database Administrator is responsible for administering, monitoring, supporting, and continuously improving the Bank’s on-premises and cloud database environments. The position serves as a primary technical resource for database availability, performance, capacity, security, patching, backup, recovery, production support, and service restoration across business-critical data platforms.

The role also administers and supports the Power BI environment and Gateway infrastructure, including data source connections, credentials, configuration changes, refresh connectivity, platform monitoring, and technical support required for successful report deployments. The position works closely with Data Operations, Data Engineering, Data Architecture, Information Infrastructure, Cybersecurity, application support teams, vendors, and business stakeholders to resolve operational issues, implement changes, improve early-warning capabilities, and ensure reliable delivery of enterprise data services.

The incumbent applies systems-analysis techniques to evaluate operational requirements, troubleshoot complex technical issues, document solutions, and identify opportunities to automate repetitive activities, modernize legacy components, and improve operational resiliency.

What You’ll Do:

• Applies systems analysis techniques and procedures to determine hardware, software, database, and system requirements that support business and operational needs.
• Administers and maintains enterprise database platforms across on-premises and cloud environments, ensuring reliability, performance, security, and availability.
• Monitors database health, performance, capacity, storage utilization, and operational processing activities to identify and resolve issues that could affect service delivery.
• Independently investigates and resolves database-related incidents, service requests, production issues, and operational exceptions within established service levels.
• Performs database performance analysis and tuning, including optimization of queries, indexes, stored procedures, database objects, and configurations.
• Plans, coordinates, tests, and implements database maintenance activities, including software upgrades, patches, configuration changes, and platform enhancements.
• Maintains and tests database backup, recovery, disaster recovery, and service restoration procedures to support business continuity and operational resiliency.
• Administers and supports Power BI environment components, including Gateway infrastructure, data source configurations, credentials, connectivity, and deployment dependencies.
• Provides operational support for Power BI solutions by troubleshooting environment, connectivity, refresh, Gateway, and platform-related issues and coordinating resolution with the appropriate teams.
• Supports database, reporting, integration, and data platform initiatives by translating business and technical requirements into operational solutions.
• Participates in database migrations, system implementations, data conversions, infrastructure changes, and technology modernization efforts.
• Collaborates with Data Operations, Data Engineering, Data Architecture, Infrastructure, Cybersecurity, vendors, and business stakeholders to support enterprise data services.
• Supports operational monitoring, process integrity validation, and early detection of failures affecting databases, integrations, reporting environments, and other data services.
• Participates in automation and continuous improvement initiatives that improve monitoring, reliability, operational efficiency, early-warning capabilities, and service delivery.
• Implements production changes in accordance with established change management, testing, approval, documentation, evidence retention, and rollback requirements.
• Maintains technical procedures, operational runbooks, knowledge articles, recovery plans, implementation records, system inventories, and supporting documentation.
• Provides technical support for audits, regulatory reviews, risk assessments, control testing, evidence requests, and remediation efforts.
• Supports database security, access management, data protection controls, and compliance with applicable security, privacy, and regulatory requirements.
• Evaluates database technologies, administration tools, monitoring platforms, vendor solutions, and automation opportunities that improve operational effectiveness and reliability.
• Participates in integration and orchestration improvements intended to reduce repetitive work, modernize legacy processing, and improve detection and recovery when processes fail.
• Participates in on-call, after-hours, weekend, holiday, maintenance, and recovery activities as required to support critical enterprise data services.
• Performs other related duties as assigned in support of Enterprise Data Management objectives and operational service delivery.

Qualifications

• 5-7 years of progressive experience in systems analysis and database administration.
• 5-7 years experience administering and supporting Microsoft SQL Server environments in production.
• 3-5 years experience support database performance tuning, backup and recovery, disaster recovery, patch management, and production support.
• Experience troubleshooting database, application, and connectivity issues in complex enterprise environments.
• Experience supporting production incidents, service requests, operational monitoring, and service restoration activities.
• Experience with T‑SQL development, query optimization, stored procedures, functions, views, indexes, and database maintenance activities.
• Experience supporting Power BI, SQL Reporting Services, SSIS, Azure Data Factory, or similar reporting and data integration technologies.
• Experience with data analysis, data modeling, data warehouse concepts, and reporting environments .
• Experience in banking, financial services, or other regulated industries.

Education

• Bachelor's Degree in Computer Science, Information Systems, or a related field.
• An equivalent combination of education and/or relevant professional experience may be considered in lieu of a degree.

Special Instructions to Candidates

Equal Opportunity

City National Bank of Florida is an Equal Opportunity Employer. We do not discriminate based on race, color, religion, sex, national origin, age, disability, genetic information, protected veteran status, or any status protected by federal, state, or Florida law. We comply with the ADA and applicable Florida laws.

Interview Guidelines

To ensure a fair and consistent interview process, applicants are not permitted to use AI-enabled devices during interviews, including AI glasses or similar wearable technology that can record, transmit, or generate real-time information.

Applicants who require a reasonable accommodation to participate in the interview process should contact [e-mail] in advance of the interview to submit an accommodation request. City National Bank of Florida will engage in the interactive process and provide reasonable accommodations in accordance with applicable law.