Database Administrator

Job Title
Database Administrator
Job ID
27558932
Work From Home
Yes
Location
Foothill Ranch,  CA
Other Location
Description

JOB TITLE:                Database Administrator (SaaS Operations)

 

DEPARTMENT:         Technical Services /Systems Integration

REPORTS TO:          Senior Director, Customer Success  

 
 
 

 

Position Summary:

 

 ​​​​​​iBASEt is searching for a Database Administrator to join our SaaS Operations team. We need someone with solid experience with both Oracle and SQL, is comfortable in Linux, can read Java code, and can communicate concepts around all these technologies with both internal and external customers. The ideal candidate has preferably done all of this in AWS or Azure cloud environments.

 

Essential Duties and Responsibilities:

 

·       Proficient in database/application design, development, and performance tuning. Conduct data modeling (Logical and Physical) including entity relationship diagrams.

·       Have the capacity for planning and high availability systems for transactional (OLTP) or reporting (DSS) databases as centralized or distributed. Technical leadership in database technologies and the use of advanced Programming tools

·       Experience installing, configuring, and tuning Oracle 12c 19c, and Multitenant in 3-Tier database architecture on various platforms, performance optimization and tuning techniques including metrics and bench marking backup strategies and disaster recovery.

·       Expert in writing PL/SQL, T-SQL & Unix scripts.

·       Experience installing, configuring, and tuning MS SQL Server in 3-Tier architecture, performance optimization and tuning techniques including metrics and bench marking backup strategies and disaster recovery.

·       Able to review code, help other developers, manage, and maintain multiple databases. Provide policies and standards for current and future applications.

·       Performance Troubleshooting/Tuning such as: index management, debugging/analysis, query optimization, metrics and bench marking. Conduct performance testing, load planning and testing.

·       Expert level knowledge of creating and maintaining Tables, Partitioning, indexes, Global Temporary Tables, Triggers, stored procedures

·       Experience in Object Oriented Design and Development as it relates to the application database interface

·       Design & build to resolve performance bottlenecks. Produce technical documentation. This can include requirements specifications, design specifications, and performance analysis reports

·       Willing to work alternate shifts as necessary in support of mission critical

  • Advanced knowledge of Oracle Statpack reports, TRC files, TKPROF output and TRC Analyzer.

·       Experience with AWS and Azure Cloud is a plus

·       Experience with backup/restore functionality using RMAN

 

Pre-Requisites:

Must be able to perform in a dynamic and fast-paced environment.

  • Must be able to quickly articulate and convey issues, trade-offs, and/or design technical approaches.
  • Must be able to direct other technical team members without having direct line authority.
  • Having manufacturing background or significant manufacturing exposure (ERP, MRP, MES) systems is a plus
  • Experience with XML, XSLT, UML, SOA, Java and JEE.
  • Knowledge of SQL Server replication and clustering methodologies

·       Knowledge of Real Application Clusters (RAC), distributed databases (Oracle replication), and Oracle Grid

  • Advanced performance tuning abilities in both Oracle and SQL Server.
  • Strong people and communication skills a must. Must be a native or fluent English speaker.
  • Must have a minimum of 8 years combined experience as a DBA and Programmer.
  • Bachelor’s degree in Computer Science required. Graduate degree or equivalent experience a plus.

 

Physical Requirements / Work Environment:

·       May experience various travel schedule and different time zones

·       Travel times may include Sunday evenings and Friday afternoons.

·       Must be US citizen

·       Security clearance a plus

 

 

Position Summary:

 

iBASEt is searching for a Database Administrator to join our SaaS Operations team. We need someone with solid experience with both Oracle and SQL, is comfortable in Linux, can read Java code, and can communicate concepts around all these technologies with both internal and external customers. The ideal candidate has preferably done all of this in AWS or Azure cloud environments.

 

Essential Duties and Responsibilities:

 

·       Proficient in database/application design, development, and performance tuning. Conduct data modeling (Logical and Physical) including entity relationship diagrams.

·       Have the capacity for planning and high availability systems for transactional (OLTP) or reporting (DSS) databases as centralized or distributed. Technical leadership in database technologies and the use of advanced Programming tools

·       Experience installing, configuring, and tuning Oracle 12c 19c, and Multitenant in 3-Tier database architecture on various platforms, performance optimization and tuning techniques including metrics and bench marking backup strategies and disaster recovery.

·       Expert in writing PL/SQL, T-SQL & Unix scripts.

·       Experience installing, configuring, and tuning MS SQL Server in 3-Tier architecture, performance optimization and tuning techniques including metrics and bench marking backup strategies and disaster recovery.

·       Able to review code, help other developers, manage, and maintain multiple databases. Provide policies and standards for current and future applications.

·       Performance Troubleshooting/Tuning such as: index management, debugging/analysis, query optimization, metrics and bench marking. Conduct performance testing, load planning and testing.

·       Expert level knowledge of creating and maintaining Tables, Partitioning, indexes, Global Temporary Tables, Triggers, stored procedures

·       Experience in Object Oriented Design and Development as it relates to the application database interface

·       Design & build to resolve performance bottlenecks. Produce technical documentation. This can include requirements specifications, design specifications, and performance analysis reports

·       Willing to work alternate shifts as necessary in support of mission critical

  • Advanced knowledge of Oracle Statpack reports, TRC files, TKPROF output and TRC Analyzer.

·       Experience with AWS and Azure Cloud is a plus

·       Experience with backup/restore functionality using RMAN

 

Pre-Requisites:

Must be able to perform in a dynamic and fast-paced environment.

  • Must be able to quickly articulate and convey issues, trade-offs, and/or design technical approaches.
  • Must be able to direct other technical team members without having direct line authority.
  • Having manufacturing background or significant manufacturing exposure (ERP, MRP, MES) systems is a plus
  • Experience with XML, XSLT, UML, SOA, Java and JEE.
  • Knowledge of SQL Server replication and clustering methodologies

·       Knowledge of Real Application Clusters (RAC), distributed databases (Oracle replication), and Oracle Grid

  • Advanced performance tuning abilities in both Oracle and SQL Server.
  • Strong people and communication skills a must. Must be a native or fluent English speaker.
  • Must have a minimum of 8 years combined experience as a DBA and Programmer.
  • Bachelor’s degree in Computer Science required. Graduate degree or equivalent experience a plus.

 

Physical Requirements / Work Environment:

·       May experience various travel schedule and different time zones

·       Travel times may include Sunday evenings and Friday afternoons.

·       Must be US citizen

·       Security clearance a plus

Option 1: Create a New Profile