Hi Greetings!! Position: SQL DBA Location: Mississippi (Remote) Project Type: Contract*Local Candidates Only JOB DESCRIPTIONThis position will require a qualified SQL DBA to take the lead in the following tasks:
- Rationalizing and mapping data between transactional and dimensional database models/systems
- Working closely with the database and system administrators to develop stored procedures and ETL processes related to the data warehouse system
- Working in collaboration with vendors and other agency staff to design, develop and manage the creation of federally required reports using the Generate application
- Translate application storyboards and use cases into functional applications
- Ability to work independently and cooperatively as part of a team.
- Ability to work under severe time constraints.
Must possess analytical and complex problem-solving skills.
REQUIRED SKILLS/EXPERIENCE # YEARS Extensive experience with development of stored procedures and ETL processes using T-SQL 7 Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas 7 Use of ALM tools for work item management, version control, code analysis, and testing 7 Broad and extensive knowledge of the software development process and its technologies 7 Familiarity with continuous integration 7 Experience creating and scheduling elastic jobs 5
REQUIRED SKILLS/EXPERIENCE # YEARS Three (3) references of submitted candidates required. Please provide the following information.
Must submit with resume. - First/last name of reference
- Title
- Company Name
- Job title of contractor while reporting to this supervisor/manager
- Telephone number
- Email Address (if available)
No min.
Preference given to candidates with the below skills/experience. Must also meet minimum requirements. Experience with student information management systems and K-12 data and reporting Experience with Common Education Data Standards (CEDS) Experience with EDFacts Federal Reporting Experience with designing and modeling database structures based on business use cases .Net/Angular experience Azure Synapse pipeline experience
SCORE CRITERIA SCORE % Cost Score 30% Required Skills/Experience 25% Preferred Skills/Experience 10% Candidate Interview 35%
Thanks & Regards Roopesh Ballolu Senior US IT Recruiter Lorven Technologies, Inc. 101 Morgan Lane | Suite 209 | Plainsboro | NJ 08536 Work: 609 ### #### Extn : 223| Fax: 609-###-#### Email:
[email protected] | Web: www.lorventech.com