Job Title: Database Administrator - SeniorTask ID: HBITS-06-13768Position Duration: 30 MonthsClient: State of NYAgency: Justice Center for the Protection of People with Special NeedsPlease call (703) ###-#### | (571) ###-#### | (703) ###-#### or email at ...@ilinksolutions.comDescription
- Database Administration
- Configure database, including schema creation, schema management, table creation, user management, and security.
- Develop and maintain documentation surrounding the governance standards of the database.
- Data Engineering
- o Design, develop, and maintain data pipelines using ETL tools and best practices.
- o Configure and maintain ETL tools to automate data flows.
- Identify, troubleshoot, and solution any technical issues related to the data pipeline.
- o Build and maintain data warehouses and data marts specific to analytics needs.
- o Ensure data quality and consistency throughout the data pipeline.
- Data Mapping and Documentation
- Create detailed data maps and lineage diagrams.
- Support the creation and maintenance of a data catalogue.
- Maintain up-to-date data documentation. Mandatory Qualifications
1. 60 months experience in database administration, including schema creation, schema management, table creation, user management, and security. 2. 60 months experience in designing, developing, and maintaining data pipeline using ETL/ELT tools. 3. 60 months experience related to the creation and maintenance of data warehouses and/or datamarts specific to supporting data analytics. 4. 36 months of experience creating and maintaining data mapping and documentation. Specifically creating detailed data maps and/or data lineage diagrams. 5. 36 months experience creating and maintaining technical data dictionary or data catalogue. 6. 36 months of experience in ensuring data quality and consistency throughout the data pipeline. 7. 24 months experience with data integration and API development. 8. Bachelor's Degree in Computer Science, Computer Engineering, or a related field. 9. 24 months of experience working with Tableau Prep. 10. 24 months of experience working with Oracle SQL Developer. Required Documentation •Resume •Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable) •Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability