Senior Database Developer (Project Management)
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.
- 5-8 years of related experience, including:
- SQL Server database development and management.
- Experience in the data warehousing domain with ETL processes.
- Proficiency with tools like SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services).
- Advanced SQL development with a strong T-SQL background for developing views, functions, and stored procedures.
- Deep understanding of database concepts, such as normalization, data modeling, and distributed databases.
- Familiarity with data security practices and encryption methods.
- Experience working with onshore and offshore models.
- Experience in Agile methodologies.
- Experience collaborating with multiple teams.
- Strong verbal and written communication skills, with the ability to explain complex information clearly.
- Experience in teaching and mentoring developers and/or users.
- Strong problem-resolution and prevention skills, including the ability to define problems, collect data, establish facts, draw conclusions, and implement solutions.
- Strong analytical skills, with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy, and interpret trends or patterns in complex data sets.
- This is an onsite position where you will work in our administrative office in Irvine, CA daily.
Preferred Qualifications:
- Working knowledge with Microsoft Azure Cloud related to Data.
- Experience with DevOps.
- Experience with RedGate.
- Experience with SQL Source control products.
Compensation:
- $123,478.46 - $179,098.46
- Great Benefits Package
#LI-CM1
#HEJ
