Role : Oracle DBA Location : Boston, MA Work Location : After initial 2 - 3 months in Boston area, would be moved to Raleigh (NC). Duration : 6 months Job Description: - Performance tuning
- Backup & Restoration Strategies(Tools knowledge with large data backup in the order of TB’s daily)
- Test Data management
- Oracle Internals
- Capacity management
- Stats and Monitoring
- Database query reviews and optimization
- Installing and upgrading the Oracle server and application tools.
- Managing Multiple Instances like Development, Test, UAT and Production including RAC, Stand by Instances, Application Servers etc.
- Allocating system storage and planning future storage requirements for the database system.
- Creating primary database storage structures (table spaces) after application developers have designed an application.
- Creating primary objects (tables, views, indexes) once application developers have designed an application.
- Modifying the database structure mainly in customized programs, as necessary from information given by application developers.
- Enrolling users and maintaining system security.
- Controlling and monitoring user access to the database.
- Monitoring and optimizing the performance of the database.
- Planning growth and changes (Capacity Planning).
- Schedule jobs management and monitoring. (cron jobs etc.).
- Planning for backup (Hot, Cold and Logical) and recovery of database information.
- Backing up and restoring the database.
- Identifying the long running queries, high disk read queries and guides the application developer to tune the queries accordingly.
- Implementing Best Practices like Index Rebuilding, Analyzing tables etc for better performance.
Looking forward to hearing from you. ...(More..) |
