#140315 - Database Administrator
At a glance
Mid-level Data Architecture & Governance role at Lifted, an Upwork Company™. Remote, Colombia · contract.
Pay not stated Data Architecture & Governance salary
remoteroles summary, based on the employer's posting.
What you'll do
- Keep production databases available and responsive, and investigate complex performance problems
- Prepare and test recovery procedures designed to avoid losing data
- Protect databases by managing access permissions and following security controls
- Work with engineers on requirements, system design reviews, performance tuning and production support
- Run operational data systems and deliver reliably through urgent incidents and tight deadlines
What you bring
- Around three to four years of practical database administration experience
- Hands-on work with SQL Server and Aurora PostgreSQL, with stronger depth in either platform accepted
- AWS experience with RDS and Aurora, plus PowerShell or Python and Terraform or comparable infrastructure-as-code tools
- Experience operating Confluent Kafka and high-availability production systems, including database tuning and recovery planning
- You can troubleshoot difficult database performance issues and apply database access and security controls
Who this fits
This remote, full-time contract suits a hands-on administrator comfortable supporting production systems and partnering with engineers. Applicants must be located in an approved country in Latin America or in India; Central Time hours are preferred. The engagement is expected to run through March 31, 2027, and requires an Amazon WorkSpaces connectivity test with a screenshot before client submission. It is not currently a path to permanent employment.
From the employer
We are seeking a hands-on Database Administrator for a remote contract engagement supporting high-availability operational database systems behind a large, high-traffic website. The role focuses on database reliability, security, disaster recovery, performance analysis, and close partnership with engineering teams.
Enterprise experience strongly preferred.
Key Responsibilities
- Maintain high availability and strong performance across production database systems.
- Plan, test, and carry out disaster recovery procedures with a zero-data-loss objective.
- Maintain database security, access controls, and adherence to security protocols.
- Analyze and tune database performance and diagnose difficult production performance issues.
- Work closely with engineers on requirements gathering, system design, design reviews, performance tuning, and technical support.
- Administer operational data systems in a highly technical production environment.
- Deliver reliable work under tight deadlines and remain composed during high-pressure incidents.
Must-Have Skills
- Approximately 3 to 4 years of hands-on database administration experience.
- Experience with both Microsoft SQL Server and Aurora PostgreSQL; deeper expertise in either platform is acceptable.
- Hands-on AWS experience, particularly Amazon RDS and Amazon Aurora.
- Programming experience with PowerShell or Python.
- Experience with Infrastructure as Code tools such as Terraform.
- Experience administering and troubleshooting Confluent Kafka.
- Extensive experience with database performance analysis and tuning.
- Experience administering high-function, high-availability production systems.
- Experience planning or performing disaster recovery.
- Strong ability to diagnose difficult database performance issues.
- Experience working closely with engineering teams through requirements gathering, design reviews, technical support, and deadline-driven delivery.
- Experience with database access control and security practices.
Nice-to-Have Skills
- Experience building Kafka connectors and topics.
- Experience with NoSQL databases such as MongoDB.
- Experience with Snowflake.
- Experience with other relational databases such as MySQL.
- Advanced Kafka experience, including KSQL and Flink.
Required Tools & Platforms
- Microsoft SQL Server and Aurora PostgreSQL.
- AWS, Amazon RDS, and Amazon Aurora.
- PowerShell or Python.
- Terraform or comparable Infrastructure as Code tooling.
- Confluent Kafka.
Location, Time & Engagement
- Candidates must be based in an eligible Latin American country or India.
- Central Time working hours are preferred.
- Remote contract engagement, 40 hours per week.
- Expected engagement through March 31, 2027; start date to be agreed.
- One opening is available.
- This is not currently a contract-to-hire opportunity.
- Before client submission, viable candidates must complete the Amazon WorkSpaces Health connectivity test and provide a screenshot showing good connectivity to an AWS WorkSpace region.