venkateswararao's Profile
venkateswararao | |
ORACLE DBA, Tata Consultancy Services (TCS) | |
 | Tata Consultancy Services (TCS)  |
Professional summary
-
Current Experience:
ORACLE DBA, Tata Consultancy Services (TCS)
Current Experience: ORACLE DBA, Tata Consultancy Services (TCS)
Previous: Organization TCS Client HD Vest Financial Services
HD Vest Financial Services
HD Vest Financial Services
Organization DELOITTE Client PRUDENTIAL INSURANCES Duration
-
4.0 Years
-
working in tsmng, rman,dataguard,datapump,asm,awr.....
-
Contribution score:(72 points)
- Contacts: 11 connections, 12 following, 2 followers
venkateswararao's Experience
| Current : |
ORACLE DBA, Tata Consultancy Services (TCS) |
|
| IT Services | ||
| Current : |
ORACLE DBA, Tata Consultancy Services (TCS) |
|
| IT Services | ||
| Previous : |
Organization TCS Client HD Vest Financial Services |
|
Worked from 2008 to 2011 | ||
Brief summary :
As a Oracle DBA #PROJECT 1: Organization TCS Client HD Vest Financial Services Duration JAN 2008 to till date. Role DBA Environment Oracle 9i,10g O S Unix, Sun O.S Application TOES,FAST,OLS,Registration 6jn,EMI-45N Description: HD Vest Billing System was designed to send the Monthly reports of customers with their portfolio status. Found Manager can access the system and they can enter or modify customer information. Application Analysis the transactions and generate reports. Roles and Responsibilities: Supporting large scale of online production databases on 247 including 20 Production and 25 Test and BFix Databases. Monitoring backups, file systems and data guard. Creating and analyzing tables and indexes for managing the good performance. Working on QA and BFix refreshes at Database level and schema level. Responsibilities: Installation and up gradation of Operation Systems and Oracle Creation and maintenance of Database Objects Database, Table spaces, Tables, Indexes, Views, Snapshots, Links etc. Creating Stored Packages, Procedures, Functions, Database Triggers and Creating DBMS jobs to run at specific times. Creating Users, Roles, Profiles and Granting and revoking the privileges to the Users. Monitoring and optimizing the performance of the database. Upgrading database by using export and import utilities. Developed, tested and documented sound database Backup/Recovery strategy. | ||
| Previous : |
HD Vest Financial Services |
|
Worked from 2008 to 2011 | ||
Brief summary :
As a Oracle DBA #PROJECT 1: Organization TCS Client HD Vest Financial Services Duration JAN 2008 to till date. Role DBA Environment Oracle 9i,10g O S Unix, Sun O.S Application TOES,FAST,OLS,Registration 6jn,EMI-45N Description: HD Vest Billing System was designed to send the Monthly reports of customers with their portfolio status. Found Manager can access the system and they can enter or modify customer information. Application Analysis the transactions and generate reports. Roles and Responsibilities: Supporting large scale of online production databases on 247 including 20 Production and 25 Test and BFix Databases. Monitoring backups, file systems and data guard. Creating and analyzing tables and indexes for managing the good performance. Working on QA and BFix refreshes at Database level and schema level. Responsibilities: Installation and up gradation of Operation Systems and Oracle Creation and maintenance of Database Objects Database, Table spaces, Tables, Indexes, Views, Snapshots, Links etc. Creating Stored Packages, Procedures, Functions, Database Triggers and Creating DBMS jobs to run at specific times. Creating Users, Roles, Profiles and Granting and revoking the privileges to the Users. Monitoring and optimizing the performance of the database. Upgrading database by using export and import utilities. Developed, tested and documented sound database Backup/Recovery strategy. #PROJECT 2 : Organization DELOITTE Client PRUDENTIAL INSURANCES Duration MAY 2006 TO DEC 2008 Role DBA Environment Oracle 9i,UNIX O S Unix, Sun O.S Application TOES,FAST,OLS,Registration 6jn,EMI-45N Description: Prudential maintains its agent details, their licensing and registration details in Oracle database. The system is build to provide the proper Consultants to a client in a responsive manner. The system deals with creating a database of available agents from the company as well as its partners. System also provides query facility to search agent for the clients need. Responsibilities: Creating table spaces and altering table spaces by adding data files. Creating Users, Roles, Profiles and Granting and Revoking the privileges to the Users. Taking Backup and Recovery of Database Using Logical (Export and Import) and Physical (Online and offline) Backup. Involving Application performance and Tuning using Tkprof, SQL Trace and Explain Plan. Modifying the database structure, as necessary, from information given by application developers. Space management and setting the storage parameters Pctfree, Pctuses, Initial extents, Minextents, inittrans, free lists, pctincrease. RMAN Backup scripts for backup the database and Schedule the backup. Monitoring and optimizing the performance of the database. Additional Skills: Ability to quickly identify issues, determine solutions. Committed, hardworking with a never say die attitude and ability of excel in a team. High level of self-motivation and dedication. Desire and ability to participate in a global team environment. Ability to work weekends and /or off hours may be required as necessary the client needs. Good verbal and written communication skills. | ||
| Previous : |
HD Vest Financial Services |
|
Worked from 2008 to 2011 | ||
Brief summary :
As a Oracle DBA #PROJECT 1: Organization TCS Client HD Vest Financial Services Duration JAN 2008 to till date. Role DBA Environment Oracle 9i,10g O S Unix, Sun O.S Application TOES,FAST,OLS,Registration 6jn,EMI-45N Description: HD Vest Billing System was designed to send the Monthly reports of customers with their portfolio status. Found Manager can access the system and they can enter or modify customer information. Application Analysis the transactions and generate reports. Roles and Responsibilities: Supporting large scale of online production databases on 247 including 20 Production and 25 Test and BFix Databases. Monitoring backups, file systems and data guard. Creating and analyzing tables and indexes for managing the good performance. Working on QA and BFix refreshes at Database level and schema level. Responsibilities: Installation and up gradation of Operation Systems and Oracle Creation and maintenance of Database Objects Database, Table spaces, Tables, Indexes, Views, Snapshots, Links etc. Creating Stored Packages, Procedures, Functions, Database Triggers and Creating DBMS jobs to run at specific times. Creating Users, Roles, Profiles and Granting and revoking the privileges to the Users. Monitoring and optimizing the performance of the database. Upgrading database by using export and import utilities. Developed, tested and documented sound database Backup/Recovery strategy. #PROJECT 2 : Organization DELOITTE Client PRUDENTIAL INSURANCES Duration MAY 2006 TO DEC 2008 Role DBA Environment Oracle 9i,UNIX O S Unix, Sun O.S Application TOES,FAST,OLS,Registration 6jn,EMI-45N Description: Prudential maintains its agent details, their licensing and registration details in Oracle database. The system is build to provide the proper Consultants to a client in a responsive manner. The system deals with creating a database of available agents from the company as well as its partners. System also provides query facility to search agent for the clients need. Responsibilities: Creating table spaces and altering table spaces by adding data files. Creating Users, Roles, Profiles and Granting and Revoking the privileges to the Users. Taking Backup and Recovery of Database Using Logical (Export and Import) and Physical (Online and offline) Backup. Involving Application performance and Tuning using Tkprof, SQL Trace and Explain Plan. Modifying the database structure, as necessary, from information given by application developers. Space management and setting the storage parameters Pctfree, Pctuses, Initial extents, Minextents, inittrans, free lists, pctincrease. RMAN Backup scripts for backup the database and Schedule the backup. Monitoring and optimizing the performance of the database. Additional Skills: Ability to quickly identify issues, determine solutions. Committed, hardworking with a never say die attitude and ability of excel in a team. High level of self-motivation and dedication. Desire and ability to participate in a global team environment. Ability to work weekends and /or off hours may be required as necessary the client needs. Good verbal and written communication skills. | ||
| Previous : |
Organization DELOITTE Client PRUDENTIAL INSURANCES Duration |
|
Worked from 2006 to 2007 | ||
Brief summary :
#PROJECT 2 : Organization DELOITTE Client PRUDENTIAL INSURANCES Duration MAY 2006 TO DEC 2007 Role DBA Environment Oracle 9i,UNIX O S Unix, Sun O.S Application TOES,FAST,OLS,Registration 6jn,EMI-45N Description: Prudential maintains its agent details, their licensing and registration details in Oracle database. The system is build to provide the proper Consultants to a client in a responsive manner. The system deals with creating a database of available agents from the company as well as its partners. System also provides query facility to search agent for the clients need. Responsibilities: Creating table spaces and altering table spaces by adding data files. Creating Users, Roles, Profiles and Granting and Revoking the privileges to the Users. Taking Backup and Recovery of Database Using Logical (Export and Import) and Physical (Online and offline) Backup. Involving Application performance and Tuning using Tkprof, SQL Trace and Explain Plan. Modifying the database structure, as necessary, from information given by application developers. Space management and setting the storage parameters Pctfree, Pctuses, Initial extents, Minextents, inittrans, free lists, pctincrease. RMAN Backup scripts for backup the database and Schedule the backup. Monitoring and optimizing the performance of the database. Additional Skills: Ability to quickly identify issues, determine solutions. Committed, hardworking with a never say die attitude and ability of excel in a team. High level of self-motivation and dedication. Desire and ability to participate in a global team environment. Ability to work weekends and /or off hours may be required as necessary the client needs. Good verbal and written communication skills. | ||
Sponsored Jobs
Featured Career Adviser
venkateswararao's
connections (11)
|
|
|
(35 Points)
1 Contacts
|
|
|
|
|
(83 Points)
6 Contacts
|
|
|
|
|
(441 Points)
11 Postings,
309 Referrals,
176 Contacts
|
|
venkateswararao's communities
|
|
|
1353 members, 64 jobs, 149 articles, 42 questions, 23 debates, 12 idea contests.
|
venkateswararao's
contributions
Invention is the mother of all development.i agree with sonam kapoor's argument |
i agree with jyoti kapoor and her valuble points. its need atleast 3years of exps in that |
Related Topics
People in the same room often communicate via instant messaging? How do we...
2 trends
, 1 insight
, 1 question
Share your thoughts on how Small Companies should implement technology...
1 insight
, 9 debates
, 1 idea contests
, 2 question
Discuss on how Organization should create its IT disaster recovery plan and...
1 trends
, 6 insight
, 2 debates
Viewers also viewed
|
1
(629 Points)
|
|
(461 Points)
|
|
8
(5,352 Points)
|
