Lead Systems Engineer, Spacecraft Bus
L3Harris Technologies
TypeScript
System Integration Analyst
Geographic Solutions, Inc.
full-time
Posted on:
Location Type: Hybrid
Location: Palm Harbor • Florida • 🇺🇸 United States
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
MS SQL ServerSQLSSIS
About the role
- Develops, administers, maintains, and supports policies and procedures for creating interfaces and converting data from clients' existing and legacy systems to Geographic Solutions systems
- Designs programming specifications through interaction with business owners and subject matter experts
- Ensures correct functionality and accuracy of interface or conversion scripts
- Fully participates in data conversion and data migration projects
- Designs advanced SQL queries, scripts, cursors, stored procedures, triggers and optimizes SQL code for performance
- Assists business analysts and end-users with reporting needs and collaborates with applications developers to ensure correct data and data structure
- Works closely with Team Lead and Analysts throughout change request process and processes change requests through OPC ticket system
- Estimates level of effort required for projects or change requests and prepares/updates technical documentation
Requirements
- Bachelor's degree in Computer Science, Information Systems or related field
- Minimum 5-7 years of database administration experience in appropriate technical environment
- Advanced knowledge of SQL 2012 or higher database design standards (including Indexes and triggers)
- Advanced Microsoft SQL Server knowledge (T-SQL, stored procedures, indexes, triggers, SSIS, import/export)
- Good understanding of SQL Server Integration Services (SSIS) programming
- Ability to code programs under ODBC and stored procedures
- Ability to resolve complex data problems and monitor/resolve database performance issues
- Ability to document database designs and conversion maps; familiarity with data corruption and database recoverability methods
- Strong analytical skills
- Excellent written and verbal communications skills
- Willingness to work onsite daily at GSI's headquarters in Palm Harbor, Florida; may be required to travel to client locations
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLT-SQLstored procedurestriggersSSISODBCdatabase administrationdata conversiondata migrationdatabase design
Soft skills
analytical skillswritten communicationverbal communicationcollaborationproblem-solving
