Database Administrator

Job Duration: 12-month contract, possible extensions and full time convert

Job Location:
Dallas, TX (Hybrid onsite role)

We have a requirement for a Strong Cloud DBA with 5+ years’ experience working as a Postgres/MySQL/Cassandra Database Administrator, including experience at the design, operational, and system levels.

• Performance tuning.
• Design and implementation of Disaster Recovery to meet defined business objectives.
• Implementation and support of high availability features including Clustering and Replication.
• Experience tuning complex database systems for production systems at the application, database, and system levels.

This person will be responsible for ensuring the performance, availability, and security of these diverse database environments. This involves the full lifecycle of database management, from installation and configuration to backup, recovery, and performance tuning.

• Installation & Configuration: Install, configure, patch, and upgrade database software and related tools across production, development, and test environments.
• Performance Tuning & Optimization: Monitor database performance, identify bottlenecks, and perform proactive tuning, including optimizing complex SQL statements and indexing strategies, to ensure maximum efficiency and availability.
• High Availability & Disaster Recovery: Design, implement, and test high-availability solutions (e.g., clustering, replication, multi-AZ deployments) and robust backup/recovery strategies to minimize downtime and ensure data is protected and recoverable.
• Security & Access Control: Develop and maintain processes for optimizing database security, managing user access, permissions, encryption, and compliance controls.
• Troubleshooting & Support: Diagnose and resolve production issues quickly, performing root cause analysis (RCA) and participating in a 24x7 on-call rotation for critical system issues.

• Postgre
  
  SQL: Known for its robust feature set, strong SQL compliance, and extensibility, it's often used for complex queries and transactional systems. Cloud DBAs manage specific features like advanced indexing and the autovacuum process. Cloud providers offer fully managed services for Postgre
  
  SQL on Google Cloud and AWS RDS, which automate routine tasks like backups and patching.
• MySQL: A popular, open-source RDBMS optimized for speed in read-heavy operations, often used in small to medium web-based solutions. Management involves maintaining efficient replication solutions and performance optimization for OLAP/OLTP systems.
• Cassandra: A highly scalable, distributed No
  
  SQL database designed for handling massive amounts of data across multiple servers with high availability and rapid read/write operations. The DBA's role is critical in managing its unique data distribution model (consistent hashing), cluster configuration, and ensuring fault tolerance.