Senior Database Developer with Appian experience needed for Astor & Sanders Corporation. Responsibilities include database optimization, migration, and design for various applications.
Responsibilities
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
Senior .Net Developer building scalable solutions for InnoWave with Agile methodologies. Responsibilities include technical design participation, solution documentation, and development testing.
Java Developer in Software Development team at Qualysoft delivering IT consulting services. Engaging with agile practices to build robust applications and ensure quality assurance.
Backend Software Engineer implementing backend systems that support Flex's rent payment platform. Collaborating with teams to enhance user and partner experiences in a dynamic environment.
Full - stack Engineer developing client solutions using React, Next.js and Node.js at Accellor. Join a fast - paced, customer - centric Experience Development Team affecting industries like Financial, Retail, and Healthcare.
Backend Engineer building scalable backend services for CloudShare's B2B SaaS solutions. Collaborating with cross - functional teams to deliver high - performance, impactful features.
Full - stack Engineer developing cloud technology solutions with React, Node.js, and Java. Joining customer - centric Experience Development Team at Accellor with various industry focus.
Lead Python Engineer at IT Labs developing solutions for a leading digital consulting services company. Collaborate with stakeholders and mentor engineers in Azure cloud environments.
Senior Backend Developer responsible for implementing digital projects and collaborating with teams at Significa. Creating high - value applications and meeting advanced requirements.
Mid - level Fullstack Engineer developing backend infrastructure for iLottery gaming products at Avenga. Collaborating with global teams and maintaining high code quality standards.