The Senior Cloud Engineer will be responsible for but not limited to:
- Perform SQL and PL/SQL development, including design and maintenance of back-end ETL processes utilizing Informatica workflow, custom PL/SQL and SQL scripts.
- Build and maintain database schemas.
- Install, configure, maintain and upgrade ETL software, repositories, and pipelines.
- Develop and maintain Python code and shell Scripts in on-premises and cloud environments.
- Maintain, optimize, and tune Oracle and DB2 database scripts.
- Perform data mining and performance tuning for large-scale datasets.
- Use ETL tools, BI tools, IBM MQ, SQL Loader.
- Perform data extracts, data purges, or data fixes in accordance with internal procedures and policies.
- Complete problem tickets, documenting bug fixes, design modifications, and changes based on customer requirements.
**This role is required to provide onsite support Mon-Fri**
QUALIFICATIONS
Required Qualifications
- Active/Current Top-Secret Clearance
- Bachelor’s degree with eight (8+) years of relevant experience; master’s degree with six (6+) years of experience PhD with three (3+) years of experience.
- At least six (6+) years' experience with PL/SQL, SQL, Oracle DBMS, XML, XSLT, Python, web services, SVN, RCS, Git, OLS Security, JIRA, Oracle 11g/12c, Sun Solaris OS, Linux (CentOS, Red Hat), and Windows.
- At least three (3+) years of experience with PL/SQL, SQL, Oracle 11g and 12c, XML, XSLT, Linux (CentOS, Red Hat), shell scripting, and Windows.
- At least two (2+) years of experience using ETL tools to perform data cleansing, data profiling, transforming, queuing, migrating, and scheduling various workflows.
- Demonstrate a proficiency in the Python programming language.
- Experience with Data application development and version control systems such as Git.
- Hands on experience with AWS cloud technologies like EC2, VPC, CloudWatch, CloudFormation, IAM, S3, RDS, ElasticCache, SNS, SQS and SWF.
Desired Qualifications
- MQ experience.
Job Type: Full-time
Pay: $147,600.00 - $178,100.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Employee assistance program
- Employee discount
- Flexible schedule
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Parental leave
- Professional development assistance
- Referral program
- Relocation assistance
- Retirement plan
- Tuition reimbursement
- Vision insurance
Experience level:
- 10 years
- 11+ years
- 6 years
- 7 years
- 8 years
- 9 years
Schedule:
- 8 hour shift
Experience:
- AWS: 3 years (Required)
- Python: 1 year (Required)
- SQL: 2 years (Required)
Security clearance:
- Top Secret (Required)
Ability to Commute:
- Chantilly, VA 20151 (Required)
Ability to Relocate:
- Chantilly, VA 20151: Relocate before starting work (Required)
Work Location: In person