Database Developer - Oakland, CA

Georgia Tek Systems
  • Oakland, CA
    Today

    Job Description

    Job Title - Database Developer
    Location - Oakland, CA
    Duration - 12 Plus Months
    Rate - DOE
    U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

    Job Description

    Responsibilities
    • Design, develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.
    • Working cohesively with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
    • Working closely with application developers and business teams at all levels to assist with data-related technical issues and help ensure the successful designing and delivering data driven solutions.
    • Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment
    • Provide solutions to promote data integrity in enterprise systems.
    • Participate in code reviews to validate effectiveness and quality of code.
    • Liaise with Developers to improve applications and establish best practices
    • Publish documentation and collaborative information using internal tools.
    Requirements:
    • Expertise in Database Architecture in an environment that handles large volume of data, excess of 500 million of new data records every day.
    • Strong analytical and organizational skills. This job involves analyzing existing databases and the client's needs to develop effective data driven solutions.
    • Demonstrate expertise in performance tuning including both query and server optimization utilizing SQL tools and/or 3rd party solutions.
    • Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, stored procedures.
    • Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
    • Hands-on development experience in SQL Server 2016 or above using SSIS and SSRS.
    • Experience in troubleshooting and resolving data related issues.
    • Excellent oral and written communication skills.
    • Expertise in performance tuning especially tuning complex queries, procedure, and indexing strategies.
    • Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.
    • Performance tuning experience using 3rd party tools.
    • Audit/compliance experience in highly regulated environment.
    • Experience using JIRA and Confluence as part of development life cycle.
    • Experience with Business Intelligence tools such as Tableau, SSRS, Power BI.
    • Familiar with Continual Improvement processes.
    • Familiar with Git.
    Experience:
    • 8 years + relational database and SQL experience
    • Creativity, curiosity, initiative, and self-management are key attributes candidate embodies.
    • Solid experience (4 years +) in coding complex SQL queries and stored procedures. The ability to explain the details of performance tuning internals of the database.
    • Strong understanding of database development methodologies (Source Control, Continual improvement, Release Management, Agile and Scrum)
    • Experience with Continuous Integration Tools (Jenkins, TeamCity, Bamboo) and Test-Driven Development (TDD) a big plus Experience with Red Gate Tools a plus (SQL Source Control, SQL Compare, SQL Data Compare, DLM).
    • Healthcare domain knowledge a big plus.

    Numbers & Facts

    LocationOakland, CA

    Skills

    • Agile Programming Methodologiesunmatched
    • Analysis Skillsunmatched
    • Atlassian JIRAunmatched
    • Best Practicesunmatched
    • Business Intelligence Softwareunmatched
    • Code Reviewsunmatched
    • Communication Skillsunmatched
    • Continuous Improvementunmatched
    • Continuous Integrationunmatched
    • Data Modelingunmatched
    • Database Analysisunmatched
    • Database Architectureunmatched
    • Database Designunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Programmingunmatched
    • Database Technologyunmatched
    • Documentationunmatched
    • Enterprise Data Integrationunmatched
    • Gitunmatched
    • Healthcareunmatched
    • Identify Issuesunmatched
    • Jenkinsunmatched
    • Metadataunmatched
    • Microsoft SQL Serverunmatched
    • Needs Assessmentunmatched
    • Organizational Skillsunmatched
    • Performance Tuning/Optimizationunmatched
    • Power BIunmatched
    • Presentation/Verbal Skillsunmatched
    • Problem Solving Skillsunmatched
    • Procedure Developmentunmatched
    • Procedure Implementationunmatched
    • Product Designunmatched
    • Product Developmentunmatched
    • Product Lifecycleunmatched
    • Query Optimizationunmatched
    • Relational Databases (RDBMS)unmatched
    • Release Management/Engineeringunmatched
    • SQL (Structured Query Language)unmatched
    • SQL Server Integration Services (SSIS)unmatched
    • SQL Server Reporting Services (SSRS)unmatched
    • Scripting (Scripting Languages)unmatched
    • Scrum Project Management and Software Developmentunmatched
    • Software Developmentunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • Stored Proceduresunmatched
    • Tableauunmatched
    • Team Playerunmatched
    • TeamCityunmatched
    • Test Driven Development (TDD)unmatched
    • Writing Skillsunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder