Database Administrator; In Person and US - GC​/Citizenship

Database Administrator (In Person and US - GC /Citizenship Required )

⭐ - Featured Role | Apply direct with Data Freelance Hub

This role is for a Database Administrator with a contract length of over 6 months, offering $90.00 - $95.00 per hour. Required skills include Postgre

SQL, Greenplum, IBM DB2, SQL, and Python. U.S. citizenship is mandatory, along with 10+ years of database administration experience.

United States

• Administer, configure, monitor, and maintain Postgre
  
  SQL Community Edition, Greenplum, and IBM DB2 databases across development, QA, staging, and production environments.
• Design, implement, and manage database architecture solutions, including schema design, data modeling, clustering, replication, and partitioning strategies across all supported platforms.
• Perform performance tuning and query optimization for Postgre
  
  SQL, Greenplum (MPP query optimization, distribution keys, resource queues), and DB2 workloads.
• Develop and maintain backup, recovery, and disaster recovery procedures for all database platforms; conduct periodic DR testing to validate recoverability.
• Configure and manage high availability (HA) and failover solutions (e.g., Patroni/streaming replication for Postgre
  
  SQL, Greenplum segment mirroring, DB2 HADR).
• Troubleshoot and resolve database issues including integrity problems, performance bottlenecks, blocking/deadlocking, replication failures, connectivity issues, and security vulnerabilities.
• Create, test, and deploy automation scripts (Python, Bash, or Shell) to streamline database operations, patching, monitoring, and routine maintenance tasks.
• Establish and manage database user accounts, roles, and permissions; enforce least‑privilege security controls in compliance with SSA and federal security standards (FISMA, NIST 800‑53).
• Set up alerting and monitoring frameworks (e.g., Nagios, Prometheus, Grafana, native DB monitoring) to ensure system health, availability, and proactive incident response.
• Conduct capacity monitoring and short‑ and long‑term capacity planning in collaboration with application developers, system architects, and infrastructure teams.
• Develop and maintain technical documentation for database build, configuration, patching, upgrade, and operational procedures.
• Collaborate with application development, architecture, and Dev Ops/release management teams to provide DBA guidance for new deployments, migrations, and schema changes.
• Participate in technical reviews and walkthroughs of system design documentation; provide architectural recommendations aligned with SSA standards.
• Support database migrations and platform upgrades, including Postgre
  
  SQL version upgrades, Greenplum cluster expansions, and DB2 maintenance releases.
• Provide on‑call support and off‑hours maintenance windows as scheduled; apply production packages during non‑peak hours.
• Adhere to SSA’s change management, incident management, and SDLC processes and procedures.

• Bachelor’s degree in Computer Science, Information Technology, or a related field; equivalent work experience accepted in lieu of degree.
• 10+ years of enterprise database administration experience spanning Postgre
  
  SQL, Greenplum, and IBM DB2.
• Minimum 5 years of hands‑on Postgre
  
  SQL DBA experience, including installation, configuration, tuning, replication, and administration of Postgre
  
  SQL Community Edition.
• Minimum 3 years of Greenplum DBA experience, including MPP architecture administration, segment configuration, resource queue management, and Greenplum‑specific performance tuning.
• Minimum 3 years of IBM DB2 z/OS administration experience, including instance management, catalog management, HADR configuration, and DB2 utilities; DB2 LUW experience also considered.
• Strong proficiency in SQL across all supported platforms; ability to write and optimize complex queries, stored procedures, and functions.
• Solid knowledge of database security principles: role‑based access control, encryption at rest and in transit, auditing, and compliance with federal security frameworks.
• Experience with backup and recovery tools native to each platform (/ for Postgre
  
  SQL, gpbackup/gprestore for Greenplum, DB2 BACKUP/RESTORE…