Senior Database Developer (SQL) || Hybrid- Pleasanton, CA || local Only
About The Position
The Senior Database Developer designs, develops, and optimizes large, complex database schemas, SQL scripts, and database objects to meet application functionality and performance requirements. The role works with data, design, product, executive, application development, and business stakeholders to address data-related technical issues and deliver data-driven solutions. The developer establishes processes and procedures that support high-quality, rapid product and project releases; promotes data integrity across enterprise systems; participates in code reviews; collaborates with developers on application improvements and best practices; and publishes documentation and collaborative information using internal tools.
Requirements
- At least 8 years of relational database and SQL experience.
- At least 4 years of experience coding complex SQL queries and stored procedures.
- Expertise in database architecture in environments handling more than 500 million new data records per day.
- Strong analytical and organizational skills, including the ability to analyze existing databases and client needs to develop data-driven solutions.
- Expertise in performance tuning, including query and server optimization using SQL tools and/or third-party solutions.
- Strong knowledge and experience in data modeling, database design, performance optimization, SQL, and stored procedures.
- Ability to understand complex business needs and analyze, design, and develop solutions.
- Hands-on development experience with SQL Server 2016 or later, SSIS, and SSRS.
- Experience troubleshooting and resolving data-related issues.
- Excellent oral and written communication skills.
- Expertise in tuning complex queries and procedures and developing indexing strategies.
- Ability to explain database performance-tuning internals.
- Strong understanding of database development methodologies, including source control, continual improvement, release management, Agile, and Scrum.
- Creativity, curiosity, initiative, and self-management.
Nice To Haves
- Performance-tuning experience using third-party tools.
- Audit or compliance experience in a highly regulated environment.
- Experience using JIRA and Confluence in the development life cycle.
- Experience with business intelligence tools such as Tableau, SSRS, or Power BI.
- Familiarity with continual improvement processes and Git.
- Experience with continuous integration tools such as Jenkins, TeamCity, or Bamboo.
- Test-Driven Development (TDD) experience.
- Experience with Red Gate tools such as SQL Source Control, SQL Compare, SQL Data Compare, or DLM.
- Healthcare domain knowledge.
- A master's degree.
Responsibilities
- Design, develop, and optimize large, complex database schemas, SQL scripts, and objects to meet application functionality and performance requirements.
- Work with data, design, product, and executive stakeholders and assist with data-related technical issues.
- Collaborate with application developers and business teams to resolve data-related technical issues and support the design and delivery of data-driven solutions.
- Implement processes and procedures for product and project development and release to facilitate high-quality, rapid deployment.
- Provide solutions that promote data integrity in enterprise systems.
- Participate in code reviews to validate code effectiveness and quality.
- Work with developers to improve applications and establish best practices.
- Publish documentation and collaborative information using internal tools.
- Monitor and tune complex ETL jobs using metadata, variables, and parameters.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
