Date Posted: 06/07/2024

Hiring Organization: Rose International

Position Number: 465508

Job Title: Senior Database Lead

Job Location: Irving, TX, USA, 75039

Work Model: Hybrid

Employment Type: Temporary

Estimated Duration (In months): 13

Min Hourly Rate($): 50.00

Max Hourly Rate($): 55.00

Must Have Skills/Attributes: Banking/Financial, Data Migration, Database, ETL, ITIL, Snowflake, SQL Server, SSAS, SSIS, Stored Procedures, T-SQL

Job Description

• **Only those lawfully authorized to work in the designated country associated with the position will be considered.**

• **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**

***Only qualified Senior Database Lead candidates located in the Irving, TX area will be considered due to the position requiring an onsite presence***

Education:

• Bachelor’s degree in Computer Science is preferrable.

Qualifications:

• 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.

• Data expert for migrating data from existing applications and database environments to new architecture.

• 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

Senior Database Lead Responsibilities:

• 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.

Benefits:

For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity:

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).