Database Administrator

1 week ago


Fairfax, United States E-talentnetwork Full time
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:
    • 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.


  • Fairfax, United States ECS Full time

    ECS is seeking an Oracle DBA (Int) to work in our Pittsburgh, PA office. Please Note: This position is contingent upon contract award. ECS is seeking a qualified Oracle DBA (Int) to support transformative science and technology solutions for the Department of Energy. Job Description: In this role, you'll perform Oracle Database Administrator functions,...


  • Fairfax, United States ECS Full time

    ECS is seeking an Oracle DBA (Int) to work in our Pittsburgh, PA office. Please Note: This position is contingent upon contract award. ECS is seeking a qualified Oracle DBA (Int) to support transformative science and technology solutions for the Department of Energy. Job Description: In this role, you'll perform Oracle Database Administrator functions,...


  • Fairfax, United States Praescient Analytics Full time

    Praescient Analytics is looking for a Database Administrator, Seniorto join our team supporting the Return Review Program (RRP) for an IRS contract. RRP is a mission-critical, automated system that is part of the IRS's tax processing pipeline component which detects and selects potentially fraudulent returns to prevent/stop the issuance of invalid refunds....


  • Fairfax, United States Human Capital Solutions Full time

    About the job Database Management Support Database Management Support (2-4 years experience) Long term contract No remote Must reside near Fairfax, VA We are seeking a Database Management Support professional to provide expert services for enterprise-level database implementation, maintenance, and tuning across UNIX and Windows environments. You will play...


  • Fairfax, United States ECS Full time

    ECS is seeking a System Administrator (Intermediate) to work in our Morgantown, WV office. Please Note: This position is contingent upon contract award. ECS is seeking a qualified System Administrator (Intermediate) to support transformative science and technology solutions for the Department of Energy. Working alongside a dynamic operations team that...


  • Fairfax, United States Inova Health System Full time

    Inova Fairfax - Patient Experience - The Administrative Coordinator coordinates and performs a wide variety of administrative activities to support department functions. Provides secretarial support to directors and managers to facilitate completion of department work. Full-Time Days - Monday - Friday Job ResponsibilitiesSchedules and coordinates...


  • Fairfax, United States Fairfax County Government Full time

    Job Announcement Join a dynamic, team-based environment supporting the values and human service mission of the Department of Family Services (DFS). Under the general supervision of an Administrative Associate, the employee procures equipment, supplies, materials, and services...


  • Fairfax, United States Inova Full time

    Job Description Inova Fairfax - Patient Experience - The Administrative Coordinator coordinates and performs a wide variety of administrative activities to support department functions. Provides secretarial support to directors and managers to facilitate completion of department work. Full-Time Days - Monday - Friday Job Responsibilities Schedules and...


  • Fairfax, United States Inova Full time

    Job DescriptionInova Fairfax - Patient Experience - The Administrative Coordinator coordinates and performs a wide variety of administrative activities to support department functions. Provides secretarial support to directors and managers to facilitate completion of department work.Full-Time Days - Monday - FridayJob Responsibilities Schedules and...


  • Fairfax, United States Fairfax County Government Full time

    Job Announcement This job opportunity is being re-announced. Applicants previously certified for this job do not need to re-apply. Serves as an administrative assistant to the Commander of Administrative Support Bureau which includes the Personnel Resources Division, the...


  • Fairfax, United States RWD Consulting, LLC Full time

    SECRET SECURITY CLEARANCE REQUIRED General Description: The Office Administrator provides a broad range of analytical and advisory services in the administrative management of the Resource Management Unit (RMU), Office of Antiterrorism Assistance (ATA), Bureau of Diplomatic Security, U.S. Department of State. The Office Administrator will provide...


  • Fairfax, United States RWD Consulting, LLC Full time

    SECRET SECURITY CLEARANCE REQUIRED General Description: The Office Administrator provides a broad range of analytical and advisory services in the administrative management of the Resource Management Unit (RMU), Office of Antiterrorism Assistance (ATA), Bureau of Diplomatic Security, U.S. Department of State. The Office Administrator will provide...


  • Fairfax, United States LHH Full time

    Job Summary:We are seeking a detail-oriented and proactive Administrative Assistant to support our team in Fairfax, VA on a contract basis. The ideal candidate will provide essential administrative support, manage office operations, and assist with various tasks to ensure the smooth functioning of the office. This role requires strong organizational skills,...


  • Fairfax, Virginia, United States Fairfax County (VA) Full time

    Job Overview">We are seeking an experienced Administrative Support Manager to join our team at Fairfax County, VA. The successful candidate will be responsible for providing high-level administrative support in record management and operations.">About the Role">This is a supervisory position that requires strong leadership and organizational skills. The...


  • Fairfax, United States Commonwealth of Virginia Full time

    Department:  Risk, Safety, & Resilience Classification: Gen Admin Supv 1/Coord 1 Job Category:  Classified Staff Job Type:  Full-Time Work Schedule: Full-time (1.0 FTE, 40 hrs/wk) Location: Fairfax, VA Workplace Type: On Site Required Pay Band: 04 Salary:  Salary commensurate with education and experience Criminal Background...


  • Fairfax, Virginia, United States Fairfax County (VA) Full time

    Job DescriptionWe are seeking a highly skilled and experienced Senior Administrative Assistant IV to join our team in Fairfax County, VA. As a key member of our procurement team, you will be responsible for providing administrative support in the assigned functional areas, including accounts payable, accounts receivable, financial reconciliation, purchasing,...

  • Grants Administrator

    6 months ago


    Fairfax, United States Commonwealth of Virginia Full time

    Department: College of Education and Human Development Classification: Financial Svcs Specialist 1 Job Category:  Classified Staff Job Type:  Full-Time Work Schedule:  Full-time (1.0 FTE, 40 hrs/wk) Location:  Fairfax, VA Workplace Type:  Hybrid Eligible Pay Band:  04 Salary:  Salary commensurate with education and experience ...


  • Fairfax, United States Commonwealth of Virginia Full time

    Department: Col of Engineering and Computing Classification: Admin Office Specialist 3 Job Category:  Classified Staff Job Type:  Full-Time Work Schedule:  Full-time (1.0 FTE, 40 hrs/wk) Location: Fairfax, VA Workplace Type:  Hybrid Eligible Pay Band:  03 Salary:  Salary commensurate with education and experience Criminal...


  • Fairfax, United States Ignitec Inc Full time

    Ignitec infuses industry standards and leading technology capabilities to solve complex problems and deliver value with increased quality and lower performance risks. Our solutions combine top technology personnel, the latest cutting-edge technology, and Agile approaches to bring innovative ideas to life. We do not seek to meet expectation, we continuously...


  • Fairfax, United States Metronome LLC Full time

    Job Title: Windows and AWS System Adminstrator Location: St. Louis, MO; Chantilly, VA; Alexandria, VA Status: Onsite Employment Type: Full-Time Clearance Level: TS/SCI Eligible Education: Typically requires a BS in Information Systems, Information Technology, Computer Science or closely related discipline and 8+ years of prior relevant experience or Master's...