Sr. Database Administrator

Job Description

Job Description

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.

Database Operations & Reliability

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

Security, Risk, and Compliance

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

Performance & Optimization

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

Change, Incident, and Problem Management

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

Data Warehouse & BI Platform Support

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

Standards, Documentation & Continuous Improvement

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

Scope and Authority

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

Required Skills and Abilities

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

Working Conditions

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

What is needed to be successful in this role?

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.

Core Technical Competencies

• 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

What makes working at Canandaigua National Bank different?

Our Core Values guide how we serve, lead, and grow alongside our community. By working wholeheartedly , feeling empowered, acting with courage, being authentic, and serving with a noble spirit, WE CAN fortify healthy lives by doing what's right for our customers and the community.

Our culture nurtures passionate employees and offers great rewards including:

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

Our goal is to ensure that our bank, employees, and our community thrive and grow, now and for the next 135 years. We're in it for the long haul. What truly sets us apart from other financial institutions is the quality and commitment of our employees. We've assembled a diverse team of people who share a primary focus: to provide exceptional service for our customers.

As an organization, we are committed to hiring, training, developing, promoting, and celebrating employees from historically disadvantaged groups. At Canandaigua National Bank, we welcome the unique contributions that you can bring in terms of ethnicity, race, sex, gender identity and expression, nation of origin, age, languages spoken, veteran’s status, religion, disability, sexual orientation, education, and culture.

Canandaigua National Bank remains an independent, community bank. If you want to be a part of something special, join us today!

Compensation range - $95,000 – $117,500
The actual salary offered within the range is dependent on a variety of factors including, but not limited to, relevant experience, qualifications, skills, level offered, and performance expectations.

Canandaigua National Corporation and its subsidiaries encourage diversity in the workplace; we are an Equal Opportunity Employer. Minority/Female/Sexual Orientation/Gender Identity/Disability/Veteran.