Avanade

Senior Database Developer

Avanade

full-time

Posted on:

Location Type: Hybrid

Location: McLean • Virginia • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AWSOracleSQL

About the role

  • Collaborate with internal business resources and technical teams/SMEs to understand data sources
  • Design, build, maintain, and optimize databases
  • Develop database objects including stored procedures, tables, views and table-valued functions.
  • Write complex queries involving common table expressions, window functions and subqueries for reporting.
  • Develop, test and execute the migration of data from an IBM DB2 to database to an Oracle database.
  • Translating business functions into conceptual, logical and physical data models.
  • Optimize database tables including the application of triggers, indices and constraints.
  • Enforce the successful application of any security standards necessary for the database, potentially including encryption at rest.
  • Performance tuning and query optimization
  • Data migration from legacy data base and perform transformations to the data to fit in the new data base
  • Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports
  • Support development teams in developing SQL queries

Requirements

  • Bachelor’s Degree in Computer Science or other related discipline
  • 5+ years’ experience as Database Developer/Programmer.
  • 5+ years’ experience integrating data from disparate sources
  • 5+ years’ experience in Agile development methodologies
  • Strong understanding of MDM policies including cleansing, normalization and standardization.
  • Demonstrated experience with Configuration Management tools
  • Ability to design and create effective data models
  • Proficient in developing stored procedures using PL/SQL and developing efficient views
  • Experience with performance tuning
  • Experience in Data Mapping and Data Migration
  • Experience with databases such as Oracle and AWS RDS
  • Understanding of data security and data access controls and design aspects
  • Strong verbal and written communication skills
  • Must demonstrate ability to work under high pressure in a complex multi-threaded environment
  • Demonstrated capability to learn, rapidly utilizing good problem solving skills
  • Desire to learn and document new tools
  • Prior experience architecting databases and warehouses for Appian BPMS solutions a plus
Benefits
  • Generous Paid Time Off (PTO) and all Federal Holidays off
  • Comprehensive Health and Dental Insurance Coverage
  • Retirement Savings Plan
  • Pre-Tax Benefit Programs
  • Wellness and Work-Life Support
  • Professional Development
  • Performance and Referral Bonuses
  • Life and Disability Insurance
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
database designstored proceduresSQLPL/SQLdata migrationperformance tuningdata modelingdata mappingquery optimizationdata transformation
Soft Skills
communication skillsproblem solvingability to work under pressurecollaborationadaptability
Certifications
Bachelor’s Degree in Computer Science