Experienced Full Stack SQL Database Administrator (DBA) – Data Warehouse Development and Management

Are you a highly skilled and motivated SQL Database Administrator (DBA) looking for a new challenge in the field of data warehouse development and management? Do you have a passion for working with complex data systems and a strong desire to drive business success through data-driven insights? If so, we have an exciting opportunity for you to join our team as an Experienced Full Stack SQL DBA.

About Our Company

At Lorven Technologies, Inc., we are a leading provider of innovative technology solutions that help businesses thrive in today's fast-paced digital landscape. Our team of experts is dedicated to delivering high-quality services that meet the evolving needs of our clients. We are committed to fostering a culture of innovation, collaboration, and continuous learning, and we are seeking like-minded individuals to join our team.

Job Summary

We are seeking an Experienced Full Stack SQL DBA to join our team in Mississippi (Remote). As a key member of our data warehousing team, you will be responsible for designing, developing, and managing complex data systems that drive business insights and decision-making. This is a unique opportunity to work on high-profile projects, collaborate with a talented team of professionals, and develop your skills in a fast-paced and dynamic environment.

Key Responsibilities

As an Experienced Full Stack SQL DBA, you will be responsible for the following key 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
• Collaborating with vendors and other agency staff to design, develop, and manage the creation of federally required reports using the Generate application
• Translating application storyboards and use cases into functional applications
• Working independently and cooperatively as part of a team to meet project deadlines and deliver high-quality results
• Analyzing complex data systems and identifying opportunities for improvement and optimization

Essential Qualifications

To be successful in this role, you will need to possess the following essential qualifications:

• Extensive experience (7+ years) with development of stored procedures and ETL processes using T-SQL
• Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas
• Experience with ALM tools for work item management, version control, code analysis, and testing
• Broad and extensive knowledge of the software development process and its technologies
• Familiarity with continuous integration
• Experience creating and scheduling elastic jobs

Preferred Qualifications

While not essential, the following qualifications are highly desirable:

• 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

Skills and Competencies

To succeed in this role, you will need to possess the following skills and competencies:

• Strong analytical and problem-solving skills
• Excellent communication and collaboration skills
• Ability to work independently and as part of a team
• Strong attention to detail and ability to meet deadlines
• Ability to adapt to changing project requirements and priorities
• Strong knowledge of SQL and data warehousing concepts
• Experience with data modeling and database design

Career Growth Opportunities and Learning Benefits

At Lorven Technologies, Inc., we are committed to helping our employees grow and develop their careers. As an Experienced Full Stack SQL DBA, you will have access to a range of learning and development opportunities, including:

• Training and development programs to enhance your skills and knowledge
• Mentorship and coaching from experienced professionals
• Opportunities to work on high-profile projects and collaborate with a talented team of professionals
• A dynamic and supportive work environment that encourages innovation and creativity

Work Environment and Company Culture

We are proud of our company culture, which is built on the values of innovation, collaboration, and continuous learning. As an Experienced Full Stack SQL DBA, you will be part of a team that is passionate about delivering high-quality services and making a positive impact on our clients' businesses. Our work environment is dynamic and supportive, with a focus on collaboration, open communication, and mutual respect.

Compensation, Perks, and Benefits

We offer a competitive salary and a range of benefits, including:

• Competitive salary and benefits package
• Opportunities for career growth and development
• Flexible working arrangements, including remote work options
• Access to a range of training and development programs
• A dynamic and supportive work environment

How to Apply

If you are a motivated and experienced SQL DBA looking for a new challenge, we encourage you to apply for this exciting opportunity. Please submit your resume and a cover letter outlining your qualifications and experience. We look forward to hearing from you! Apply To This Job Apply for this job