Through Tuning Knife, I offer expert Oracle DBA services in:
- Performance tuning: Oracle performance tuning is an evidence-driven science. I use 10046 and 10053 tracing, the wait-event interface (including ASH), as well as Statspack and AWR reports, among other techniques, to diagnose database performance problems and zero in on their solutions.
- Database automation: Deep perl and shell scripting skills, as well as extensive PL/SQL development experience, allow me to automate a wide variety of tedious DBA tasks.
- Backup and recovery: Oracle's RMAN utility is the key to success when recovery scenarios arise. I offer my RMAN expertise to make sure clients are prepared for eventual hardware failures.
- Data warehouse
architecture: I provide back-end data warehouse architecture
services, and have designed high-performance star schemas and DSS
environments from the ground up.
- Database
migration/replication: Database
duplication through RMAN is an easy way to clone development or QA
environments. I also configure standby databases, Streams, as well as
master and materialized view sites for data replication.
- Oracle installation/patches: Database upgrades and patches are a fact of life for DBAs. I have extensive experience upgrading and patching Oracle software and databases.
- And more....