Oracle DBA III: Optimize, Secure & Scale Databases

Amtec Staffing; Pasadena (CA); On-site; USD 62,000 - 106,000; Full time

Job summary

Amtec Staffing in Pasadena, CA is seeking an Oracle Database Administrator III for a 6+ month contract. The role supports Oracle, MySQL, MS-SQL and PostgreSQL in an enterprise setting, ensuring data integrity and performance.

The candidate will optimize queries, manage backups, implement security and coordinates changes with developers and end-users. Strong shell scripting and documentation are required.

Qualifications

• Bachelor's degree with minimum 4 years IT experience in DB admin
• Hands-on with Oracle, MySQL, MS-SQL and PostgreSQL
• Strong knowledge of database architecture, indexing, query optimization, and execution plans
• Backup and recovery methods including snapshot-based solutions
• Proficient in SQL/PL-SQL and shell scripting
• Experience with application hosting middleware (WebLogic, Apache, Tomcat)
• Ability to troubleshoot complex database and application stack issues
• Strong communication and documentation skills

Responsibilities

• Administrates database, using a database management system to organize and store data.
• Ascertains user requirements, creates computer databases, and tests and coordinates changes
• Interacts with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases.
• Coordinates physical changes to computer databases; and codes, tests, and implements physical database, applying knowledge of database management system.
• Calculates optimum values for database parameters, such as the amount of computer memory to be used by the database, following manuals
• Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data.
• Tests and corrects errors, and refines changes to the database. Enters codes to create production database.
• Selects and enters code for utility programs to monitor database performance, such as distribution of records and amount of available memory.

Skills

Database administration

SQL

Shell scripting

Communication

Education

Bachelor's degree in IT/CS

Tools

Oracle

MySQL

MS-SQL

PostgreSQL

WebLogic

Apache

Tomcat

Job description

Amtec Staffing in Pasadena, CA is seeking an Oracle Database Administrator III for a 6+ month contract. The role supports Oracle, MySQL, MS-SQL and PostgreSQL in an enterprise setting, ensuring data integrity and performance.

The candidate will optimize queries, manage backups, implement security and coordinates changes with developers and end-users. Strong shell scripting and documentation are required.