Sr. Database Administrator

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process. Exempt Full-Time Professional Pittsford, NY, US 3 days ago Requisition ID: 3345 Salary Range: $95,000.00 To $117,000.00 Annually 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. 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 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). Tuition assistance. Community focused volunteer opportunities. Award winning wellness program that promotes a solid work/life balance. Banking perks and discount programs. 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. #J-18808-Ljbffr