Cloud SQL Engineer - AWS Migrations & Data Security

Fts Inc; Arlington (VA); On-site; USD 120,000 - 150,000; Full time

Job summary

Fts Inc. is seeking an experienced Database Engineer/DBA to manage and optimize production SQL Server environments in Arlington, VA. You will drive performance improvements, ensure high availability, and lead cloud migration efforts to AWS services such as RDS and Aurora PostgreSQL.

The role requires 4+ years in database engineering or DBA work, strong SQL/T-SQL/PL/pgSQL knowledge, and comfort with scripting and data security practices. On-call rotations and compliance support are included.

Qualifications

• 4+ years of database engineering or DBA experience.
• Strong experience with Microsoft SQL Server in a production environment.
• Experience with SQL Server performance tuning, Always On or similar HA/DR, backups, recovery, and security.
• Strong knowledge of SQL, T-SQL, and PL/pgSQL.
• Experience moving databases between platforms or into the cloud.
• Experience with PowerShell, Python, or Bash scripting.

Responsibilities

• Manage and monitor production Microsoft SQL Server databases.
• Improve database performance by working with indexes, queries, statistics, and connections.
• Manage backups, restores, replication, and high availability.
• Test backup and recovery processes to ensure databases can be restored.
• Move databases to AWS, including Amazon RDS for SQL Server and/or Aurora PostgreSQL.
• Migrate data and support production cutovers.
• Convert T-SQL, stored procedures, and triggers to PostgreSQL when needed.
• Work with PostgreSQL databases, including tuning, replication, and extensions.
• Protect sensitive data through encryption, access controls, key management, and auditing.
• Review database changes and SQL queries from engineering teams.
• Help engineers build databases that are reliable and perform well.
• Create scripts and automation for database setup, migrations, maintenance, and monitoring.
• Support PCI-DSS and SOC 2 compliance.
• Participate in on-call support and help resolve database issues.

Skills

SQL Server

T-SQL

PL/pgSQL

Performance tuning

HA/DR Always On

Cloud migration

Scripting: PowerShell

Security & auditing

Communication

Documentation

Education

Four-year technical degree, or equivalent

Tools

Amazon RDS

Aurora PostgreSQL

AWS DMS

Babelfish

Terraform

CloudFormation

Job description

Fts Inc. is seeking an experienced Database Engineer/DBA to manage and optimize production SQL Server environments in Arlington, VA. You will drive performance improvements, ensure high availability, and lead cloud migration efforts to AWS services such as RDS and Aurora PostgreSQL.

The role requires 4+ years in database engineering or DBA work, strong SQL/T-SQL/PL/pgSQL knowledge, and comfort with scripting and data security practices. On-call rotations and compliance support are included.