**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 for this job