Database Administrator

Database AdministratorLocations: Fairfax, VA (Hybrid 3 days on-site 2 days Remote)Client: DOILong Term Contractual Role 3 to 5 yearsPerforms a variety of tasks that require both practical experience and theoretical, state-of-the-art, technical knowledge.Roles and ResponsibilitiesCollaborationWork closely with ES FWS DDI management in developing and executing a strategic plan for our EDW to align with current platform cloud migration objectives and goalsWork 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 teamsWork with US FWS staff, contractors, and vendors to build, manage, and maintain a solid EDW, Extract, Transform, and Load (ETL) processes, and automationsCollaborate with USFWS stakeholders to understand their reporting and analytical needs and to provide solutions that enable them to access and analyze data effectivelyDatabase Management:Manage database maintenance and modification activities for the current legacy on-prem platform and support cloud migration effortsWork with DDI staff to ensure integration of data for various sources into the ES EDW, ensuring data quality, and consistencyManage the ETL processes to extract data from various source systems, transform it into the required format, and load its data into the ES EDWDesign and enforce database standards, policies, and quality control measuresEnsure data integrity, reliability, and overall database healthBackup and RecoveryDevelop and implement database backup, recovery and archiving, and storage strategiesDesign and execute data collection, staging, moving, and reporting strategiesAdminister database objects for optimal utilization, including performance tuning and indexingSecurity and complianceEnsure proper implementation of DDI data governance and security measures to protect our data and to ensure compliance with DOI/USFWS/ES/ DDI security regulationsIdentify and address database security issues, manage audit trialsAssist in the remediation of security findings and collaborate with systems engineers as neededCoordination & ReportingTroubleshoot database-related issues, collaborating with engineering teams for resolutionDesign and maintain service-level alarms and monitor service-related KPIsProfessional ExperienceProven experience managing and leading database activities and maintaining database standardsExperience managing cloud database resourcesExperience in SQL, T-SQL, Stored Procedures, Functions (SQL Server and PostgreSQL)Experience on use and implementation of data integration and automation toolsExperience with the following Databases: PostgreSQL, MySQLExperience with ElasticsearchExperience 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 applicationsExcellent knowledge of database backup, recovery, security, integrity, and SQLFamiliarity with database design, documentation, and coding best practicesExperience with DBA case tools and programming languages APIExperience 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.Along with the technical experience listed above, the ideal candidate should have:Bachelor's degree in computer science, Information systems and or related experienceA strong desire to work collaboratively as part of a dynamic and creative teamStrong analytical and problem-solving skillsExceptional written and oral communication skillsProven effectiveness working on dispersed teamsProven 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.