What are the responsibilities and job description for the Oracle Database Administrator position at Hirextra -World's First Staffing Aggregator?
Hi,
Hope you are doing well,
Position: Database Admin
Location-Albany, NY – OnsiteLong term Contract-W2Only
Qualifications
- Database Administrator- Uses specialized software to store and organize data, which may include capacity planning, installation, configuration, database design, migration, performance monitoring, security and troubleshooting, as well as backup and data recovery.
- Expert- 84 months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
- 84 months of experience troubleshooting Oracle 10g or higher database performance and other related issues; specifically by working with other teams to identify if the issue is at the storage, network, database, or application tier.
- 84 months of experience working with developers to suggest modifications which could improve the performance of their SQL (e.g., avoiding cartesian products, suggesting indexes, etc.).
- 84 months of experience installing, upgrading and patching Oracle 10g or higher Database software in a Unix-like environment (e.g. AIX, Linux, Exadata). Experience must include installing, configuring, upgrading and patching an entire RAC cluster with Data Guard.
- 84 months of experience with Oracle Real Application Clusters (Oracle RAC), Oracle Automatic Storage Management (Oracle ASM) and Oracle Automatic Storage Management Cluster File System, Oracle Data Guard and Oracle Database Security.
- 84 months of experience using Oracle Recovery Manager (RMAN) for backup and recovery of Oracle 10g or higher databases. Experience must include using RMAN for Backup &Recovery, Repository Configuration & Maintenance as well as Implementation of RMAN Backup & Recovery using Commvault. And other third party tool.
- 48 months of experience installing, upgrading, patching and using Oracle Enterprise Manager (OEM) 13c or higher to monitor and analyze database issues and find solutions to correct the problems.
- Oracle 10g or higher Oracle Professional Certification.
- Bachelor’s degree in computer science or a related discipline.
Day-to-Day tasks
- Installing, upgrading, and patching Oracle Database software in an Oracle Exadata and IBM AIX environment with RAC, ASM, Data Guard, Enterprise Manager
- Creating Oracle databases.
- Developing and testing a backup and recovery strategy, backing up Oracle databases regularly, and recovering them in case of failures.
- Configuring the network environment to enable clients to connect to databases.
- Starting up and shutting down the database.
- Managing storage for the database.
- Managing database users and security.
- Monitor performance and availability of Oracle database environment
- Creating and maintaining documentation related to all tasks and provide mentoring/knowledge transfer to other staff as necessary
