Database Administrator

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 management in developing and executing a strategic plan for our EDW 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, 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.

Along with the technical experience listed above, the ideal candidate should have:

• Bachelor's degree in computer science, Information systems and or related experience
• A 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.