Dieses Stellenangebot ist nicht mehr verfügbar
Über
Database Administrator
Locations: Fairfax, VA (Hybrid 3 days on-site 2 days Remote)
Client: DOI
Long Term Contractual Role 3 to 5 years
Performs a variety of tasks that require both practical experience and theoretical, state-of-the-art, technical knowledge.
Roles and Responsibilities
Collaboration Work closely with ES FWS DDI (Ecological Services - Fish and Wildlife Service - Data division) management in developing and executing a strategic plan for our EDW (Enterprise Datawarehouse) to align with current platform cloud migration objectives and goals Work with DDI staff to ensure integration of data for various sources into the EDW, ensuring data quality, and consistency. Coordinate with multiple teams, including interfacing with engineering and project teams Work with US FWS staff, contractors, and vendors to build, manage, and maintain a solid EDW (Enterprise Datawarehouse), Extract, Transform, and Load (ETL) processes, and automations Collaborate with USFWS stakeholders to understand their reporting and analytical needs and to provide solutions that enable them to access and analyze data effectively Database Management:
Manage database maintenance and modification activities for the current legacy on-prem platform and support cloud migration efforts Work with DDI staff to ensure integration of data for various sources into the ES EDW, ensuring data quality, and consistency Manage the ETL processes to extract data from various source systems, transform it into the required format, and load its data into the ES EDW Design and enforce database standards, policies, and quality control measures Ensure data integrity, reliability, and overall database health Backup and Recovery
Develop and implement database backup, recovery and archiving, and storage strategies Design and execute data collection, staging, moving, and reporting strategies Administer database objects for optimal utilization, including performance tuning and indexing Security and compliance
Ensure proper implementation of DDI data governance and security measures to protect our data and to ensure compliance with DOI/USFWS/ES/ DDI security regulations Identify and address database security issues, manage audit trials Assist in the remediation of security findings and collaborate with systems engineers as needed Coordination & Reporting
Troubleshoot database-related issues, collaborating with engineering teams for resolution Design and maintain service-level alarms and monitor service-related KPIs Professional Experience
Proven experience managing and leading database activities and maintaining database standards Experience managing cloud database resources Experience in SQL, T-SQL, Stored Procedures, Functions (SQL Server and PostgreSQL) Experience on use and implementation of data integration and automation tools Experience with the following Databases: PostgreSQL, MySQL Experience with Elasticsearch Experience with FME software and automation processes. Experience with the following for version controls:
Git (GitHub, Bitbucket, GitLab).
Experience with the following Operating systems:
Windows, Linux.
Experience with any of these following Cloud technologies:
CI/CD Pipeline, Containers (Docker/Pod man) Public cloud (AWS) Kubernetes Microservices S3 Buckets.
Technical Skills:
Hands-on experience with database standards and end-user applications Excellent knowledge of database backup, recovery, security, integrity, and SQL Familiarity with database design, documentation, and coding best practices Experience with DBA case tools and programming languages API Experience designing, building, and maintaining complex, mission-critical EDWs by striving for build and test automation, "keeping it simple ", following industry best-practices, and embracing an agile, test-driven development environment. long with the technical experience listed above, the ideal candidate should have:
Bachelor's degree in computer science, Information systems and or related experience strong desire to work collaboratively as part of a dynamic and creative team Strong analytical and problem-solving skills Exceptional written and oral communication skills Proven effectiveness working on dispersed teams Proven ability to offer creative software solutions to complicated and complex challenges. Be a nimble, active, and communicative member of the ES DDI (Ecological services - Data integration) team.
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot wurde von einem unserer Partner veröffentlicht. Sie können das Originalangebot einsehen hier.