Job title: 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:
- 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.