Эта вакансия уже завершена
Database Administrator (Oracle)
Dear Candidates!
We are looking for Oracle Database Administrator with high knowledge of English.
Salary amount is discussed and depends on the experience
Our support needs to be perfect. Our customers such as Procter and Gamble depend on us for their global operations. This means that the support team has to be disciplined and work on ways to reduce future incidents. That is when something goes wrong they must look for ways to improve monitoring and how to ensure it doesn't happen again.
Our current problem is stability and problem resolution time. When one of our customers has slow performance their business can stop. This has a very large financial impact our customers (potentially in the millions of USD). We have several large (Over 70 TB) source database systems running global multi-national companies, performance and support are a must. We want to develop 24x7 support. The engineers need to have strong database knowledge along with understanding of Red Hat Linux, AIX, SUSE Linux, Windows Server etc. In addition foundational knowledge of networking (firewalls, network segmentation, TCP/IP basics ), General network security.
Please, find below some technical notes:
- We replicate data in real time from Oracle, DB2, SQL server and SAP HANA into Microsoft SQL Server
- For all systems other than SQL Server we use HVR log reader on the Source Database Server
- Our software receives the replicated data and performs several actions to make the data consumable our tools --
- Generate Fact Tables
- Generate Standard Dimensions
- Instantiate Full Row Level Security on the target data
- Handle Collation Issues
- Generate the DDL for target table creation
- Identify All Keys
- Decompress and decrypt SAP data
- Create easy to read views of the data including metadata
- Great Communicators
- Understand the OS / Database Internals
- Database Skills
- Disk Performance
- Memory Issues
- Virtual Machine configuration
- Microsoft Azure
- Excellent DML
- Technical Level
- Infrastructure
- Be able to build up test VM in our environment
- Networking
- Security
- Azure / Hyper-V
- Storage Area Networks
- SSD, NVME etc.
- Remote work - you can work from any place in the world
- Stable salary payment in USD.
- Standard work schedule - 8 hours per day (40 h per week)
- Healthy team environment
The ideal people are -
i. T-SQL preferred
ii. Common Table Expressions
iii. Complex SQL
iv. Stored Procedures
i. Insert Performance in SQL Server
ii. Partitioning
iii. Supplemental Logging on the Source
We propose remote position & competitive salary in friendly environment.
Please, do not hesitate to contact me for additional details.
Татьяна Важинская