Key skills
SQLETL
About this role
Job Description: Computer Consultant Level 10
CBP- Custom Border Protection
Knowledge, skills, education and/or experience:
Bachelor s degree or equivalent practical experience.
3 years experience in a data integration space, understanding ETL operations, steps and scope of work.
3 years experience writing SQL queries (intermediate to advanced) with no affinity to any particular brand of database.
4 to 5 years using Excel.
3 years experience in an Enterprise development organization, understanding general procedures and scheduling of code migrations.
3 years experience understanding various aspects of an RDBMS and how applications interact with database functions.
3 years experience interpreting other people s code in any language to understand what a routine is doing.
Duties/Responsibilities:
Analyze, design, implement, maintain and support monitoring solutions for enterprise systems and platforms.
Develops and maintains standards and guidelines for implementing IT automation and monitoring.
Determine the minimum requirements of various infrastructure software for proper maintenance and upkeep for a small team that wear multiple hats per person.
Oversees infrastructure architecture, including the analysis, selection and deployment of emerging technologies.
Oversees major tool implementations and/or upgrades.
Provides SWOT analysis regarding hardware, software and server requirements for implementation.
Provides training to provide backup coverage for this position to junior members of the team.
Computer software to be used:
PL/SQL
T/SQL
SSIS
Vertica