Senior Database Developer

Summary:  

Reporting to the Director, Applications Development, the Senior Database Developer is responsible for designing, implementing, and maintaining complex database systems, including data modeling, performance optimization, security management, data integrity checks, and developing strategies for data backup and recovery, while also mentoring junior developers and collaborating with other teams to ensure efficient data management across an organization.

Responsibilities:


* Participate in a team-based, Scrum development environment.


* Create and refine database models, including tables, relationships, indexes, and constraints to optimize data access and query performance.


* Analyze query performance, identify bottlenecks, and implement optimization techniques to improve database responsiveness.


* Establish data validation rules, implement data cleansing processes, and monitor data quality to ensure accuracy.


* Perform analysis, design, and implementation of data migration as needed.


* Implement security measures such as user access controls, data encryption, and auditing to protect sensitive data.


* Design and implement data extraction, transformation, and loading (ETL) pipelines to integrate data from various sources.


* Proactively assess future data storage needs and scale database infrastructure accordingly.


* Perform SQL Server database administration in the development environment.


* Establish change control and deployment processes, including documentation, rollback strategies, source control strategies, and impact evaluation.


* Provide guidance and mentorship to junior database developers, share best practices, and stay updated on emerging database technologies.


* Work closely with application developers, business analysts, and other teams to understand data requirements and translate them into effective database designs.


* Adhere to organizational policies, procedures, and ethical standards.


* Maintain regular and timely attendance, report to work as scheduled, and ensure time worked and/or time-off is recorded properly.


* Exercise care, proper use, and maintenance of department equipment and supplies, identify unsafe conditions, and make appropriate adjustments.


* Collaborate effectively with cross-functional teams and communicate clearly with stakeholders.


* Demonstrate strong analytical and problem-solving skills to address complex database issues.


* Foster a mindset of continuous improvement and innovation in database design and management.


* Create and maintain comprehensive technical documentation for database systems and processes.


* Monitor database performance and implement proactive measures to ensure optimal operation.


* Adhere to industry standards and regulatory requirements related to data management and security.

Required Qualifications:


* Bachelor's degree in a related field or equivalent experience.
...