Database Architect & Performance Optimizer

Exist Software Labs Test; Enterprise (NV); On-site; USD 110,000 - 150,000; Full time

Job summary

Exist Software Labs Test is seeking a database-focused professional to design, tune, and support complex data architectures across transactional and data warehouse environments. You will collaborate with developers and system administrators to ensure scalable, secure, and highly available databases.

Responsibilities include capacity planning, automation of DBA tasks, evaluating new technologies, and ensuring data integrity with backups and replication. 3+ years of relevant experience is required.

Qualifications

• Requires 3+ years in data modeling and DBA work.
• Experience with relational, star schema, and big data models.
• Proficient in SQL and scripting; BI/ETL exposure.
• Experience with Oracle, MySQL, PostgreSQL is preferred.
• Familiarity with AWS cloud and enterprise apps.
• Strong problem-solving and troubleshooting abilities.

Responsibilities

• Design and document database architecture.
• Analyze capacity and performance requirements.
• Automate DBA tasks via scripting.
• Evaluate new database technologies.
• Tune SQL scripts, indices, and databases for efficiency.
• Support upgrades and patches.
• Collaborate with developers for efficient DB usage.
• Monitor systems for maximum availability.
• Oversee backups, replication, and failover.
• Ensure data integrity and privacy.
• Work with client DBAs to obtain approvals.
• Support performance testing and issue Troubleshooting.

Skills

Data modeling

DBA experience

SQL scripting

BI/Data warehousing

Troubleshooting

AWS cloud

Tools

Oracle

MySQL

PostgreSQL

Teradata

Hadoop

Job description

Exist Software Labs Test is seeking a database-focused professional to design, tune, and support complex data architectures across transactional and data warehouse environments. You will collaborate with developers and system administrators to ensure scalable, secure, and highly available databases.

Responsibilities include capacity planning, automation of DBA tasks, evaluating new technologies, and ensuring data integrity with backups and replication. 3+ years of relevant experience is required.