By becoming part of our team, you will join a group of professionals who take pride in our ability to deliver timely and potent solutions, directly respond to the challenges of our customers, adapt to changes in technology, and provide insightful programmatic analysis.
This position requires a minimum of an FAA Suitability Clearance.
Responsibilities:
- Provide support to the development of new application releases in the following areas
- Database loading
- Query Tuning
- Data mart schema design and refinement
- SQL Server Administration
- Support data processing development
- Additional responsibilities as needed
- Provide SQL Administration in the production environment
- Automation of, monitoring of production databases
- Support the deployment of new application releases )may require database changes)
- Diagnosing query performance problems
- Backups and restores
- Additional responsibilities as needed
Qualifications:
- Team player interested in success of the team
- Experience in database application development
- Experience Visual Studio
- Understanding of Enterprise Data warehouse data models and dimensional modeling concepts, source to target mapping and Data integration architecture
- 5+ years MS SQL Server Administration experience required
- Experience with analyst interfaces to SQL Server (e.g. SSRS and SSAS)
- Experience programming SQL, T-SQL/stored procedures, database load scripts
- Experience providing production/operation support
- Experience with backups, restores and recovery models
- Ability to multi-task and context-switch effectively between different activities and teams
Desired Qualifications:
- Experience with data processing tools SSIS
- Experience with BIMLFlex
-Experience with data processing and data quality metrics
- Experience Performance Tuning of ETL processes in large scale data warehouse environment
- Experience working in Microsoft Azure cloud
- MCTS, MCITP, and/or MVP certifications a plus
- Large scale data migration experience