Sr. Database Administrator

Canandaigua National Bank & Trust Co • Pittsford, NY

6d • $95,000 - $117,000 • Hybrid

About The Position

The Senior Database Administrator (Senior DBA) is a senior-level technical role responsible for the availability, security, performance, resilience, and integrity of the Bank’s database platforms supporting business-critical systems, analytics, and regulatory reporting. This position serves as the technical authority for database administration, ensuring that database environments meet financial services regulatory requirements, internal risk standards, and service-level objectives while supporting data warehouse and business intelligence workloads. Senior DBA partners closely with Application Development, Information Security, Infrastructure, and Business Intelligence teams, while maintaining clear accountability for core DBA functions.

Requirements

• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to communicate technical topics effectively to non-technical stakeholders.
• Strong attention to detail and documentation discipline.
• Ability to prioritize work in a high-availability, regulated environment.
• Ability to participate in scheduled and after-hours on-call support.
• Bachelor’s degree in computer science, Information Technology, MIS, or related field; or equivalent combination of education and experience.
• 8+ years of progressive experience in database administration roles.
• 5+ years of experience supporting production database environments for mission-critical systems.
• Demonstrated experience administering Microsoft SQL Server in enterprise environments.
• Experience supporting Data Warehouse and BI platforms (e.g., SSIS, SSAS, SSRS).
• SQL Server administration (installation, configuration, upgrades, patching)
• Advanced SQL performance tuning and query optimization
• Database security and access controls
• Backup, recovery, and disaster-recovery engineering
• High-availability and resiliency design
• Change management and release controls
• Capacity planning and performance monitoring
• Data warehouse operational support
• Incident and problem management

Nice To Haves

• Financial services experience is strongly preferred, including exposure to regulated environments.
• Experience with cloud-based or hybrid database platforms preferred.

Responsibilities

• Administer and maintain production, non-production, and disaster-recovery database environments.
• Manage database ecosystems across cloud and on-premises environments, including operational support, platform engineering, and cost and performance monitoring.
• Ensure high availability, performance, and reliability of database systems.
• Design, implement, and maintain backup, recovery, and disaster-recovery strategies.
• Perform and document periodic restore and failover testing.
• Monitor database performance, capacity, and growth trends; recommend scaling strategies.
• Implement and maintain database security controls, including role-based access, encryption (at rest and in transit), privileged access management support, and audit logging.
• Support internal and external audits by providing evidence related to access controls, change management, backup and recovery, and regulatory compliance (e.g., GLBA, SOX, NYDFS).
• Ensure database environments adhere to data privacy and retention requirements.
• Identify underperforming queries, indexes, and workloads.
• Design and implement performance improvements using indexing, query refactoring, and configuration tuning.
• Partner with database engineers and analysts to improve database-related application performance.
• Manage database changes through formal change management processes.
• Review database-related code changes for performance, security, and operational risk.
• Participate in on-call and after-hours incidents affecting database services.
• Perform root-cause analysis for database-related incidents and document corrective actions.
• Provide operational DBA support for the Data Warehouse and BI platforms.
• Assist BI and ETL teams with database design, indexing strategies, and performance considerations.
• Designs, develops, and populates data objects such as relational dimensional databases and SSAS tabular models.
• Designs and builds data models to support self-service BI.
• Support SSIS, SSAS, and reporting platforms from a database reliability and performance standpoint.
• Maintain documentation related to schemas, configurations, and operational procedures.
• Creates and maintains database standards, procedures, and runbooks.
• Participates in platform evaluations, upgrades, and roadmap planning.
• Remains current with database technologies, security practices, and industry standards.
• Functions as technical owner of database platforms.
• Acts as a senior-level escalation point for database incidents and risks.
• Provides technical guidance and mentorship to database developers and analysts.

Benefits

• Medical, dental, vision, FSA, HSA options for both part-time and full-time employees. Medical coverage is also offered for domestic partners.
• Paid holidays, vacation, and sick time.
• Retirement benefits that include a 401(k), Profit Sharing, and Employee Stock Ownership Plan (ESOP).
• Training & development opportunities.
• Tuition assistance.
• Community focused volunteer opportunities.
• Award winning wellness program that promotes a solid work/life balance.
• Banking perks and discount programs.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior