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