Database Operations
Pyxis Engineering is an Oracle Partner boasting Oracle Certified Professionals with over 12 years experience architecting Database Solutions for datasets ranging from 100 MB to 6 TB. The latest versions of both Oracle and Sybase are used and our expertise spans Solaris, HP/UX, AIX, Linux, and Windows NT, 2000, and XP platforms.
Information Assurance
Pyxis Engineering is a leader in adhering to security guidelines set forth by the major database corporations as well as the intelligence community. Pyxis Engineering professionals have several solutions that can lock down any client site and are currently operational for government intelligence customers with the strictest security standards. The techniques use customized scripts in addition to the latest security protocols such as Virtual Private Databases (VPD), Fine Grained Auditing (FGA), Row Level Security (RLS), Secure Socket Layer (SSL), Oracle Advanced Security Option (ASO), Oracle Database Vault and Oracle Label Security (OLS). Each security solution is individually tailored to the domain of the customer and meets all of their goals.
High Performance
Striving for high performance, Pyxis Engineering utilizes Oracle Real Application Clusters (RAC) to load balance each customer application across the processing power of a grid making it better, faster, and cheaper. Pyxis Engineering professionals currently monitor more than 300 databases using Oracle Grid Control and use this information to tune for faster query response time, better memory management, distributed CPU usage, and better storage allocation.
High Availability
In an effort to ensure the high availability of every system, Pyxis Engineering also implements High Availability Clusters and Replication. If any of the nodes fail, customer applications will continue to operate with a seamless transition to the remaining nodes. Pyxis Engineering implements technologies such as Oracle Streams, Oracle Data Guard, Oracle Flashback capabilities, Oracle Recovery Manager (RMAN), and Sybase Replication Server to maintain this high standard of excellence and the consistent availability of the customer’s data.
Database Technologies
Besides Oracle, Pyxis Engineering also has tremendous experience with the following technologies:
- Database Administration
- Sybase
- Microsoft SQL Server
- IBM DB2
- Database Design and Development
- Standard SQL and Oracle PL/SQL Development
- JDBC Programming and Performance Tuning
- Experience with Object/Relational Mapping and Persistence Technologies (i.e. JPA, JDO, Hibernate, and EJB3.0)
- Disaster Recovery