Job Title : Database Lead
About this job
Our client Wipro is an IT Company and is seeking to recruit result driven and motivated individuals for the Vacancy above;
Duties and Responsibilities
* Implementing SOX compliance for databases
* Enabling audits
* Installation of Oracle databases and client on Unix/Windows servers.
* Implementing CPU and PSU patches
* Managing users with profile management.
* Generating AWR reports per requirement and to optimize performance.
* Auditing and tracing session for performance review
* Cloning database for development users
* Troubleshoot and create dblinks as and when required
* Tuning various application sql statements using various hints or indexes in the environment.
* Rebuilding and recompiling Invalid database objects whenever necessary.
* Exporting database using datapump and normal exp when required.
* Using flat file loader utility sqlldr to load large text data in database tables.
* Creating automated scripts using shell script and PL/SQL procedures to automate server and application checks.
* Performing end to end application trace to identify any performance issue.
* Managing tablespaces for users with quota
* Upgrading Oracle databases to new release
* Managing Real Application Clusters 10G and 11G R1 and R2
* Installing RAC clusters on ASM and raw devices
* Schema reorganization using 10G new features
* Database optimization using stats updation etc
* Writing shell scripts to automate routine jobs
* Changing character set per requirement of client.
* Interacting with Oracle support for severity issues and technical support
* Performance tuning of instance and sql queries
* Installation of Oracle 11G R1 and R2 RAC databases on AIX
* Cross platform migrations from HP-Unix to AIX.
* Installing, Managing and Monitor Oracle Real Application Cluster nodes over Oracle 10G.
* Installation oracle software in non-interactive mode through putty in Solaris and AIX servers.
* Patching to new version of oracle software and creation of database manually.
* Identifying performance issues using ADDM, AWR and Grid control utilities.
* Implementing Transparent Application Failover (TAF) functionality for application in RAC.
* Monitor and automate database growth projection as part of Capacity Management.
* Up gradation and patching of database in QA and production environment.
* Tuning server parameters to maintain optimized performance of database.
* Partition real tables in database to use table data efficiently maintaining database performance.
* Tuning various application sql statements using various hints or indexes in the environment.
* Rebuilding and recompiling Invalid database objects whenever necessary.
* Exporting database using datapump and normal exp when required.
* Implementing Backup strategies like RMAN, Hot Backup, Cold Backup & Logical Backup and automating them using shell scripts which are later transferred to DLT
* Handle and Optimize Export/Import of Data and load data using SQL* loader
* Manage Users, Roles and User Profiles, change the Database User Schema
* Debugging and troubleshooting the oracle errors using Sql text, Sql Monitor and Toad.
* Creating and managing tablespaces for availability of databases
* Performing daily administrative and performance tuning tasks like monitoring the Diagnostic files, Background Trace files and Users Trace files.
How to Apply:
Please follow the instructions as stated below as failure to do so could lead to disqualification.
1. Send an Application letter and CV/Resume.
2. Merge these two documents into one document in either word or pdf format.
3. Do not attach or send any scanned documents, these are sometimes too large for our inbox.
4. Include the job title and/or reference number in the subject line of the email address and send your application by email to wiprojobs@nftconsult.com
5. Only successful candidates will be contacted. For all other inquiries please contact our offices directly.
Deadline: 10th January 2012