It took few month to get Trust security clearance. I utilized this time in training.
Architected Data Ware House design for storing and retrieving large amount of data
Implemented 11gR2 feature (interval partitioning)
Implemented data redaction so HIPAA Privacy & Security rules may be adhered and PHI and PII data is appropriately hidden from public
Created many policies catering to different type of users. Implemented all type of redactions Full, partial, random, expression, none.
Used 12c OEM Cloud control to monitor the database performance
Provided DBA supported to application team
User complained about database being slow, found blocking lock, killed the blocking session to improve the database performance.
Made performance improvements to databases
Used SQL Developer to Tuned SQL queries and implemented the indexes and profile
Analyzed AWR and ADDM reports for tuning the database and high-cost SQL.
Used 12c OEM Cloud control to monitor databases.
While security clearance was in progress, I utilized time in training
Completed 12c DBA training from skillsoft.
Completed training in HIPAA Privacy & Security Certificate
Completed training in healthnet Fusion Middleware 11g: WebLogic & BI Server Architecture & Installation by Sideris Courseware Corporation
Completed training in Diagnosing healthnet Clusterware and Node
Completed training in healthnet Database 11g: High Availablity in RAC
Completed training in healthnet Database 11g: Configure, Manage, and use services in RAC
Completed training in healthnet Database 11g: RAC Database and healthnet Clusterware Administration
Completed training in healthnet Database 11g: RAC Performance Tuning
Completed training in healthnet Database 12c: Managing Security
Completed training in Networking and UNIX Name Resolution
Trained colleague on Unix shell scripting and Unix commands
Received training from colleague on WebLogic administration
Environment: healthnet Exadata clients healthnet 11g, 12c, Linux, GoldenGate, DataGuard, Weblogic