Software Guidance & Assistance, Inc., (SGA), is searching for a Database Developer for a contract assignment with one of our premier financial services clients in Irving, TX.

Responsibilities :

• Acts as a senior member of the Technology Capabilities Group within IT Application Services and is responsible for the overall design, development, test, release, maintenance, and technical support of data and reporting applications to ensure effective data services delivery and support enterprise strategies.
• Responsible for working with Information Technology (IT) Infrastructure Services to ensure server platform and security needs of data and reporting systems are met.
• ETR to support our application eco system. ETR is a shared service for firm's internal business for Project management/Resource management. To provide SME Support on ETR applications and work on backend development activities for the User Stories assigned during each Sprint.
• Participates in a team-based, scrum development environment.
• Support database objects residing in MS SQLSERVER/RDBMS databases or Big Data platform.
• Design, create, modify and remove database objects (tables, views, indexes, keys, stored procedures, functions, DB links, etc.) to support development projects.
• Design, build, and maintain extract-transformation-load (ETL) processes.
• Implement and test database objects in non-production environments.
• Work with Application Development Team, Project, Testing/QA, Architects, and IT Management to support fixes, enhancements, and projects.
• Performance review and tuning on pending, new and production database objects.
• Maintain database objects in a software version control system.
• Support Testing efforts from a database perspective.
• Data expert for migrating data from existing applications and database environments to new architecture.

Required Skills:

• 10 years of experience in the solution development life cycle for developing and maintaining data processing and reporting application including coding standards, code reviews, source control management, build processes, testing, and operations.
• Proficient in developing solutions using SQL Server, T-SQL, Stored procedures, Functions, SSIS, SSAS.
• Experience developing ETL processes loading Data Warehouses/Data Marts required.
• Must have strong knowledge on Data Warehouse design concepts - Star, Snowflake, etc.
• Well versed in developing data models and reports with industry standard reporting tools.
• Proficient in performing system and/or integration testing.
• Skilled in performing system analysis and design.
• Proficient in applying critical thinking skills in problem solving.
• Skilled in communicating with functional teams of different technical experience.
• Working knowledge of agile methodologies.
• Knowledgeable in data integration and/or data migration design and implementation, data management principles and best practices, and the architecture and design of Business Intelligence solutions.
• Familiar with the design and application of software design pattern.
• Familiar with ITIL for IT Service Management.
• Knowledge of new and emerging technologies related to data management.
• Good customer service, communication, and interpersonal skills.
• Good knowledge of the business and its technology strategy.
• Consistently demonstrates clear and concise written and verbal communication skills

Preferred Skills:

• Bachelor's degree in Computer Science is preferrable.

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy