Sr. Database Administrator

Sr. Database Administrator

Canandaigua National Bank

Location:

Pittsford, NY (Hybrid, 3 days onsite/2 work from home)

What does a Sr. Database Administrator do?

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.

• 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; 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; audit logging.
• Support internal and external audits by providing evidence related to: access controls; change management; backup and recovery; 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.

• 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.

• Hybrid office environment (3 days per week onsite).
• Occasional after-hours and on-call work required.

Note: The following are examples of required education, training and experience.

• 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).
• Financial services experience is strongly preferred, including exposure to regulated environments.
• Experience with cloud-based or hybrid database platforms preferred.

• SQL Server administration…