Database Administrator (DBA) - W2 (No C2C or 1099) - Remote (Posted SAM)

Global Force USA; United States; Remote; USD 110,000 - 170,000; Full time

Job summary

Global Force USA is seeking an experienced PostgreSQL DBA to lead database installation, configuration, upgrades, patching, and performance tuning. You will monitor and troubleshoot PostgreSQL environments, manage RDS/Aurora deployments, and optimize queries and indexes for both OLTP and analytics workloads.

The role requires strong SQL skills, experience with data lake technologies (Lake Formation), and familiarity with Redshift and DMS.

Qualifications

• Bachelor's degree in a computer-related field or equivalent experience.
• 5+ years of related experience or equivalent combination of education and training.
• Hands-on PostgreSQL administration including install, config, upgrades and patching.
• PostgreSQL performance tuning: queries, indexes, vacuum/analyze, config.
• Experience monitoring/troubleshooting PostgreSQL performance and availability.
• Experience with Amazon RDS and Amazon Aurora for PostgreSQL.
• Strong SQL development across OLTP and analytics platforms.
• Effective English communication, written and spoken.
• Ability to organize work for timely completion and teamwork.
• Experience with AWS Lake Formation and data lake deployment/administration.
• Knowledge of Amazon Redshift architecture and security model.
• Experience with AWS Glue and AWS DMS.
• PostgreSQL or Oracle certification preferred.

Skills

PostgreSQL DBA

SQL development

AWS services (RDS/Aurora)

Data lake concepts (Lake Formation)

Data warehouse (Redshift)

Performance tuning

Monitoring & troubleshooting

English communication

Project coordination

Education

Bachelor's degree in computer-related field

Tools

PostgreSQL

Amazon RDS/Aurora

AWS Lake Formation

AWS Glue

AWS DMS

Amazon Redshift

Job description

REQUIRED SKILLS

• Bachelor's degree in a computer-related field from an accredited college or university and five or more years of related experience, or an equivalent combination of education, certification, training, and experience.
• Hands-on experience with PostgreSQL database administration, including installation, configuration, upgrades, and patching.
• Strong expertise in PostgreSQL performance tuning, including query optimization, index strategy, vacuum and analyze tuning, and parameter configuration.
• Experience monitoring and troubleshooting PostgreSQL database performance, resource utilization, and availability.
• Experience administering Amazon RDS and Amazon Aurora for PostgreSQL.
• Strong SQL development skills across online transaction processing and analytical data platforms.
• Ability to communicate effectively in English, both orally and in writing, and to follow complex oral and written instructions.
• Ability to organize work for timely completion and maintain effective, cooperative working relationships.
• Experience with AWS Lake Formation and data lake deployment and administration.
• General understanding of Amazon Redshift architecture and service model, including role-based access control, user and group management, and security permissions.
• Experience with AWS Glue and AWS Database Migration Service.
• Database certification in PostgreSQL or Oracle preferred.