**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? Do you have a passion for data warehousing and a strong background in T-SQL development? We are seeking an experienced Full Stack SQL DBA to join our team in Mississippi, working remotely. As a key member of our team, you will play a critical role in the development and management of our data warehouse system, working closely with our database and system administrators to design, develop, and implement stored procedures and ETL processes.
**About Us**
At Lorven Technologies, Inc., we are a leading provider of innovative technology solutions, dedicated to helping our clients achieve their goals through cutting-edge data management and analytics. Our team is passionate about delivering high-quality solutions that meet the evolving needs of our clients. As a Full Stack SQL DBA, you will be part of a dynamic team that is committed to excellence, innovation, and customer satisfaction.
**Job Summary**
We are seeking an experienced Full Stack SQL DBA to join our team in Mississippi, working remotely. As a key member of our team, you will be responsible for the development and management of our data warehouse system, working closely with our database and system administrators to design, develop, and implement stored procedures and ETL processes. You will also be responsible for translating application storyboards and use cases into functional applications, working independently and cooperatively as part of a team, and working under severe time constraints.
**Key Responsibilities**
* Rationalize and map data between transactional and dimensional database models/systems
* Work closely with the database and system administrators to develop stored procedures and ETL processes related to the data warehouse system
* Collaborate 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
* Work independently and cooperatively as part of a team
* Work under severe time constraints
* Analyze and solve complex problems
**Essential Qualifications**
* Extensive experience with development of stored procedures and ETL processes using T-SQL
* Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas
* Use of 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**
* 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**
* 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 organizational skills
* Ability to work under severe time constraints
* Familiarity with data warehousing and business intelligence tools and technologies
**Career Growth Opportunities and Learning Benefits**
At Lorven Technologies, Inc., we are committed to the growth and development of our employees. As a Full Stack SQL DBA, you will have opportunities to:
* Develop your skills and expertise in data warehousing and business intelligence
* Collaborate with a dynamic team of professionals who are passionate about delivering high-quality solutions
* Work on a variety of projects and initiatives that will challenge and engage you
* Participate in training and development programs that will help you achieve your career goals
* Enjoy a competitive salary and benefits package
**Work Environment and Company Culture**
At Lorven Technologies, Inc., we value a positive and inclusive work environment that promotes collaboration, innovation, and customer satisfaction. As a Full Stack SQL DBA, you will be part of a dynamic team that is committed to excellence and customer satisfaction. You will have the opportunity to work on a variety of projects and initiatives that will challenge and engage you, and you will be supported by a team of professionals who are passionate about delivering high-quality solutions.
**Compensation, Perks, and Benefits**
We offer a competitive salary and benefits package, including:
* Competitive salary
* Comprehensive health insurance
* 401(k) retirement plan
* Paid time off and holidays
* Opportunities for professional development and growth
**How to Apply**
If you are a highly skilled and motivated SQL Database Administrator (DBA) looking for a new challenge, please submit your application, including your resume and three professional references. We look forward to hearing from you!
**Submit Your Application**
Seize this opportunity to make a significant impact. Apply now and take the first step towards a rewarding new role.
Apply To This Job
Apply for this job