SQL Database Administrator

Title: Database Administrator III
Location: Pasadena, CA 91109
Duration: 7 months (possible extension/conversion!)
Shift: 1st
9/80 Work Schedule
Pay Rate: $45-77HR(depending on experience and outcome of the interview)
 

Job Details:

• Administrates organization's database, using database management system to organize and store data.
• Typical Functions 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 database.
• Excludes paraprofessional positions.
• 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 amount of computer memory to be used by 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 user.
• Tests and corrects errors, and refines changes to database.
• Enters codes to create production database.
• Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory.
• Directs programmers and analysts to make changes to data base 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.

Required Skills: 

• Hands-on experience with Oracle, MySQL, MS-SQL and PostgreSQL in enterprise environments.
• 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.
• Nice to have Secret Security Clearance already

Desired Skills:

• Working knowledge of NetApp Snap Center for database storage management.
• Experience supporting Oracle E-Business Suite environments.
• Experience with EM24ai and eBS plug-in configuration.
• Exposure to cloud database services (AWS RDS, Azure SQL, OCI).
• Scripting or automation experience using shell, Python, or similar tools.