Job Description :
Job Title: Database and ETL Administrator (496056
Primary Skills: SQL Server, database backend, disaster recovery, ETL tools.
Location: Washington, DC
Duration: 9/30/17 + possible extensions.
Interviews: In Person only.
Interviews scheduled on the following dates: Tue. 4/18, Wed. 4/19. and Thur. 4/20.
Years of experience: 8 years’ experience.
JOB DESCRIPTION:
The Client with IT Enterprise Application & Data Systems (EADS) Group requires the services of an experienced database and ETL administrator to support our Application Development and Systems Operation activities.
IT Enterprise Application & Data Systems (EADS) Group requires the services of an experienced database and ETL administrator to support our Application Development and Systems Operation activities. The incumbent will have the primary responsibility of developing and maintaining internal databases and ETL scripts. Other duties may involve writing complex queries for reporting using raw SQL queries and scripting languages such as Perl, Python, etc. In addition to designing to fill a particular set of requirements, they will also balance immediate needs with future direction and ensure that work for one project can be leveraged for other purposes as much as possible.
Specific Duties:
1. Collaborate with project and operation teams by conducting the database administration task such as installation, configuration, upgrade, migration, and others as assigned by manager.
2. Conduct backup and recovery, database security, storage and capacity planning, performance monitoring and tuning tasks as assigned by manager
3. Conduct trouble shooting and data restores as needed and as assigned by manager
4. Conduct Extract, translate, and Load tasks as assigned by manager
5. Collaborate with other DBAs to establish and enhance best practices in the area of back-up, data-recovery, database security, ETL, and storage.
6. Conduct the following tasks as assigned:
7. Write SQL code to implement complex queries for reporting
8. Investigate new technologies and suggests new solutions to business problems
9. Performs other related duties as assigned.
Minimum Education/Certification Requirements:
Bachelor’s degree in Information Technology or related field or equivalent experience.
Required Skills
- Overall IT Exp. ( 8-16+ yrs
- Experience with MS SQL Server. Required. 8 Years.
- Experience with database backend and disaster recovery. Required. 5 Years.
- Progressive experience in database maintenance and ETL development. Required. 5 Years.
- Progressive experience in a Virtual Server environment. Required. 3 Years.
- Experience with SQL Server High Availability Solutions. Required. 3 Years.
- Experience with ETL tools (SSIS preferred, but other ETL tools acceptableRequired.5 Years.
- Experience with standard scripting languages (Shell, Perl, Python, etc. Required. 5 Years.
- Experience of standard database concepts (query optimization, database tuning, data modeling, etc Required. 5 Years.
- Experience with data warehousing. Nice to have.
- Experience with NoSQL. Nice to have.
- Experience tuning SQL queries to optimize performance relative to application needs. Nice to have.
- Experience with application development languages and tools a plus (Java, JSP, etc. Nice to have.
- Experience with application development languages and tools a plus (Java, JSP, etc. Nice to have.
- 16+ yrs. designing, creating and maintaining databases in a client/server environment. Nice to have.
- 16+ yrs. SQL experience. Nice to have.
- Bachelor’s degree in IT or related field. Required.