Oracle Database Administrator III

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

Job Title: Oracle Database Administrator III

Contract 6+ Months with possibility of going long-term

Pay: $45.00 - $77.00 hourly

No C2C or Staffing Partnership.

Job 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. Ensures performance of the database.
• Coordinates physical changes to computer databases; and codes, tests, and implements physical database, applying knowledge of database management system. Designs logical and physical databases or reviews description of changes to database design to understand how changes to be made affect physical database; i. e. , how data is stored in terms of physical characteristics, such as location, amount of space, and access method. Establishes physical database parameters. Codes database descriptions and specifies identifiers of database to database management system or directs others in coding database descriptions.
• 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. Specifies which users can access databases and what data can be accessed by users
• 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. Directs programmers and analysts to make changes to the database management system. Reviews and corrects programs. Answers user questions. Confers with co-workers to determine impact of database changes on other systems and staff cost for making changes to database. Modifies database programs to increase processing performance, referred to as performance tuning. Workers typically specialize in one or more types of database management systems. May train users

Requirement

• Bachelor's degree with a minimum of 4 years of IT experience, particularly with database administration expertise
• Hands-on experience with Oracle, MySQL, MS-SQL, and PostgreSQL in an enterprise environment
• Strong knowledge of database architecture, indexing strategies, query optimization, and execution plan analysis
• Experience with backup and recovery methods, including snapshot-based solutions
• Proficiency in SQL, PL/SQL, and shell scripting
• Familiarity with application hosting middleware (WebLogic, Apache, Tomcat
• Understanding of database security, hardening practices, and compliance requirements
• Ability to troubleshoot complex database and application stack issues
• Strong communication and documentation skills