Database Administrator

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

This position is primarily responsible for database design, performance monitoring and optimization, administration, and support. Specific responsibilities include working with software developers to assist in meeting their client requirements in efficient methods and working with client’s system administrators to ensure proper server configuration.

Responsibilities

• Design and document database architecture
• Analyze and predict capacity and performance requirements
• Automation of DBA functions via scripting
• Evaluate and recommend new database technologies
• Analyze and tune SQL scripts, indices and databases for optimal efficiency
• Support upgrades and patches
• Work with developers to ensure efficient database usage
• Monitor systems and platforms for maximum availability
• Oversee backup, replication, and failover
• Ensure data integrity and privacy
• Knowledge and experience with replication and ETL technologies
• Work with customer DBAs to review and obtain approvals
• Support performance test cycles and troubleshooting to fix any issues

Skills / Experience Required

• 3+ years of experience with data modeling tools including experience with relational, star schema, and big data models
• 3+ years of experience performing database administration and development using various database technologies such as Oracle, MySQL, PostgreSQL (Teradata, Hadoop would be a plus)
• Experience with data warehousing, and business intelligence
• Solid programming skills, using scripting languages and SQL
• Experience supporting enterprise level complex applications in various architectures, e.g. AWS cloud, etc.
• Experience with database management utilities, reading and interpreting the results of routine database issues and the means to research and determine the causes of more advanced problems
• Ability to assist development teams in troubleshooting cause of SQL and/or application failures
• Experience modeling and working with both transactional 3rd normal form databases and data warehouse star schema databases
• Experience performance tuning transactional and data warehouse system