Manager Oracle

| KASI VISWANATH |

|l5juji@r.postjobfree.com |

|[pic][pic] | |

| |+91-828******* |

|OBJECTIVE |To focus and provide excellent quality as a Senior |

| |Database Administrator working with database technologies |

| | |

|PROFILE |Have more than 7 years of experience in Handling Databases|

|SUMMARY |for various commercial applications and proficient in |

| |Database administration. |

| | |

| |Flexibility of working on different platforms and |

| |environments well, versed with quality standards. |

| |Teradata advanced Certified professional having hands on |

| |experience in Teradata RDBMS Database Administration |

| |(Teradata V2R5, TD 12, TD 13). |

| |Hands on experience of Teradata database Backup Archive |

| |and Restore activities. |

| |Expertise in using Netvault and Arcmain named PIPES for |

| |data refresh across different Teradata environments. |

| |Good knowledge in Teradata performance management. |

| |Established and wrote the company's standards and best |

| |practices document for all Oracle and teradata database |

| |environments based on Oracle's Optimal Flexible |

| |Architecture (OFA) and Teradata best practices. This |

| |document outlined all standards for the DBA Operations |

| |Group including installing/upgrading Oracle, creating |

| |databases, DBA tools, administration and monitoring, |

| |naming standards, configuring, managing Dataguard, |

| |policies, practices and procedures. |

| |Expertise in Backup and restore using Netvault. |

| |Built effective backup strategy and numerous reports for |

| |automating manual tasks. |

| |Hands-on experience of data movement/migration across |

| |Oracle environment to Teradata RDBMS using FASTREADER |

| |utility. |

| |Teradata Security access management. |

| |Profound in using Teradata Manager, Viewpoint, Teradata |

| |Administrator for Database administration. Also using |

| |other Teradata Tools and Ferret Utilities to monitor and |

| |manage Teradata databases. |

| |Implemented Oracle data guard for Max database |

| |availability. |

| |Designed and installed Oracle databases on windows and |

| |Linux family as per Oracle Flexible Architecture. |

| |Performed application, SQL, and database instance tuning |

| |using a wide range of technologies including Teradata |

| |visual explain plan, Teradata system emulation tool, ADDM,|

| |AWR, Statspack, OEM Performance Manager, and custom |

| |scripts. |

| |Applying latest releases of the RDBMS patches from Oracle |

| | |

|EXPERIENCE |Teradata India Pvt. LTD |

| |Technical Consultant |Oct 2009 - Present |

| | |

| |Working as a Teradata Production DBA for one of the |

| |largest environment APPLE spanning over +300 TB of |

| |production environment. |

| |Working on 24*7 Support Environment managed by strict |

| |Service Level Agreements with time limits for ticket |

| |acknowledging, ticket resolution/Escalation. |

| |Monitoring the system for resource intensive queries, |

| |blocking and coordinating with different teams across the |

| |client for corrective actions. |

| |Creating Teradata objects like Databases, Users, Profiles,|

| |Roles, Tables, etc. as per application requirement. |

| |Handling Planned and Unplanned Outage communication and |

| |co-ordination with different teams across client for the |

| |duration of downtime and following up with Teradata GSC |

| |for rot cause analysis. |

| |Build up backup strategy for daily, weekly, yearly backup |

| |jobs in a way that application downtime will be minimal |

| |and do restores as per requirement and to verify the |

| |backup tapes |

| |Generating reports using PMCP/PDCR for capacity planning |

| |and for reactive actions for any performance impact. |

| |Working towards continuous improvement based on the |

| |feedbacks obtained from the Ticket owners. |

| |Defining and scheduling statistics collection and |

| |monitoring the stats collection process. |

| |Data refreshed across different Teradata production and |

| |non-production environment by using NetVault and UNIX |

| |named pipes. |

| |Data migration from Oracle RDMBS to Teradata database |

| |using FASTREADER utility. |

| |Handling Planned and Unplanned Outage communication and |

| |co-ordination with different teams across client for the |

| |duration of downtime and following up with Teradata GSC |

| |for rot cause analysis. |

| |Generating reports using PMCP/PDCR for capacity planning |

| |and for reactive actions for any performance impact. |

| |Dropping Databases / Users with proper approvals verifying|

| |the dependency before dropping. |

| |Granting & Revoking of Object Rights, System Rights on |

| |Databases / Users / Roles. |

| |Working towards continuous improvement based on the |

| |feedbacks obtained from the Ticket owners. |

| |Monitoring Resource usage of Development, Test, and |

| |Production environments using Teradata Manager, Viewpoint |

| |and PMON. |

| |Using locking logger to analyze on job locking & deadlocks|

| |and working on resolving the same. |

| |Proactive resolution and Analysis of job blockings/Long |

| |running jobs in Development, Test, and Production |

| |environments and advising support team about long term |

| |fix. |

| |Carrying out Space Management so that there are no |

| |failures in ETL batch run or BO reporting failure due to |

| |Perm Space issues or Spool Space Issues. |

| |Performing the restore operations whenever requested. |

| |Work closely with Teradata GSC team for issue resolution |

| |and Incident Management. |

| |Coordination of activities during System upgrades. Resolve|

| |technical tickets and implementing SRs and CRs using |

| |Espresso |

| |Proficient in using Viewpoint, Teradata Manager & Teradata|

| |Administer tool. |

| |Troubleshooting & administering the Teradata Databases. |

| |Creating & Managing Databases/Users, Roles/Profiles. |

| |Perm/Spool Space Management |

| |Access rights/Roles/Profile maintenance. |

| |Maintenance of database admin shell scripts. |

| |Monitoring resource, CPU usage and users activity using |

| |DBQL data. |

| |Monitoring of databases/sessions using Performance |

| |Monitor. |

| |Monitoring and resolving session blocking. |

| |Migration of data from Oracle to Teradata using fast |

| |reader (Tool from external company) |

| |Active team member at the time of up gradation from v2R6 |

| |to TD12 |

| |Active team member at the time of up gradation from TD12 |

| |to TD13 |

| |Active team member at the time of hardware up gradation |

| |from 5500H to 5650H series |

| |Hands on experience with Viewpoint. |

| |Creation of databases, determining logical and physical |

| |Databases as per business requirement reviewing for any |

| |performance impact. |

| |Creation of users and mapping appropriate roles as per |

| |application requirements following standard firm policies |

| |Coordinating changes to databases environment and oversee |

| |that upgrades have been carried out and being in part of |

| |different Teradata software upgrades and hardware node |

| |level expansions. |

| |Good exposure on Netvault Backup and restore. |

| |Completed various web trainings in Teradata University. |

| |Completed 3 days intensive workshop on Teradata Mixed |

| |workload management. |

| | |

| | |

| | |

| | |

| | |

| | |

| | |

| |Adventity Global Services Pvt LTD |

| |Senior Database Administrator |Dec 2008 - October |

| | |2009 |

| | |

| |Implemented various high availability solutions for a |

| |diverse group of clients running Oracle9i, Oracle10g using|

| |Data Guard and RMAN. |

| |Hands on Experience with switch over and fail over. |

| |Performed application, SQL, and database instance tuning |

| |using a wide range of technologies including ADDM, AWR, |

| |Statspack, OEM Performance Manager, and custom scripts. |

| |Worked on automated, enterprise wide monitoring |

| |infrastructure using several key technologies including |

| |Linux shell scripts, Windows shell scripts (WSH), and SQL.|

| |This allowed us to efficiently gather database metadata, |

| |exceptions. |

| |Established and wrote the company's standards and best |

| |practices document for all Oracle database environments |

| |based on Oracle's Optimal Flexible Architecture (OFA). |

| |This document outlined all standards for the DBA |

| |Operations Group including installing/upgrading Oracle, |

| |creating databases, DBA tools, administration and |

| |monitoring, naming standards, configuring, managing |

| |Dataguard, policies, practices and procedures. |

| |Migrated Oracle Databases from windows to Linux using |

| |Exp/Imp |

| |Upgraded database from 10.2.0.3 to 10.2.0.4. |

| |Applying interim patches to resolve critical errors. |

| |Coordinating with Mercator for Application bugs and |

| |applying interim patches for application for the same. |

| |Involved from Design level to Deployment, coordinating |

| |with Development team. |

| |Crucial role in physical Database designing by |

| |understanding the business requirement and in turn |

| |creating objects with appropriate structure, constraints |

| |and business logic |

| |Implemented strong backup strategy for high data base |

| |availability |

| |Involved in server level and Database hardening as per |

| |security audit, coordinating with server team. |

| |Generating Statspack for peak hours when wait I/O is high |

| |and diagnosing the statistics, also analyzing trace files |

| |for troubleshooting. |

| |Investigating fragmentation, Row chaining, etc and |

| |removing the same for logical refresh. |

| |Migrated Oracle Databases from windows to Linux using |

| |Exp/Imp |

| |Upgraded database from 10.2.0.3 to 10.2.0.4. |

| |Applying interim patches to resolve critical errors. |

| |Worked with Oracle support to resolve critical errors like|

| |ORA-07445 and ORA-0600. |

| |Installing and Managing Oracle Application server 10g. |

| |Builded effective backup strategy for Oracle Databases. |

| |Good Command on Oracle OEM and TOAD. |

| | |

| |Rolta India Ltd. |

| |Sr.Executive L-1 | |

| |June 2008 - Dec 2008 | |

| |Completed 3 months training at Rolta India Ltd on DBA, |

| |Intergraph Smart Plant Foundation & Intergraph Tools |

| |Completed Health Checks. |

| |Installation of Smart Plant Foundation on Windows 2003 |

| |Installation of Intergraph tools |

| |Completed Health Checks |

| |Checking the alert logs regularly |

| |Scheduling and Configuration maintenance plans. |

| |Installed and Managing Oracle Application server 10g. |

| |Worked with Oracle support to resolve critical errors like|

| |ORA-07445 and ORA-0600. |

| | |

| | |

| |Nalin Soft |

| |Oracle DBA |

| |Oct 2005 - June 2008 |

| | |

| |Created a number of databases for development, testing |

| |and production. |

| |Performed Installations of Oracle versions 9i & 10g |

| |Regular database activities, backups monitoring, issues|

| |resolving. |

| |Managing database security. |

| |Creating and assigning appropriate roles and Privileges|

| |to users depending on the user activity, disabling |

| |users. |

| |Implemented database refresh with the hot backup using |

| |full export. |

| |Used EXP/IMP to perform table level and full database |

| |de-fragmentation. |

| |Worked with Oracle Support for solving critical errors |

| |like ORA-0600 & ORA-07445 |

| |Analyzing tables on a regular basis for the Oracle |

| |optimizer. |

| |Applying latest releases of the RDBMS patches from |

| |Oracle to the instance to resolve few technical and |

| |security issues. |

| |Administration of Oracle 9i & 10g database including |

| |installation, creation and planning Backup strategy. |

| |Coordinate with L3 support for tuning queries. |

| |Coordinate with Admin team for periodic backups and at |

| |the time of refreshes |

| |Completed 3 months internal workshop on Oracle Database|

| |administrator. |

| | | |

|EDUCATION | | |

| |Bachelor of Engineering |May 2005 |

| | | |

| |M.K.C.E, Anna University | |

| |Major: Electronics & Communication | |

| | | |

|CERTIFICATION |Oracle Database Administration 10g |March 2008 |

| |Oracle Corporation | |

| | | |

| |Teradata Basics V2R6 |Oct 2009 |

| |Teradata Certified SQL Specialist V2R6 |Nov 2009 |

| |Advanced Teradata Certified |Dec 2009 |

| |Professional V2R6 |Jan 2010 |

| |Teradata Certified Administrator V2R6 | |

| |Teradata University | |

| |TERADATA - Tools & Utilities |

| |BTEQ, SQL Assistant, Teradata Administrator, Teradata Manager, |

| |TSET, Viewpoint, FastLoad, MultiLoad, TPump, FastExport, Priority |

| |Scheduler, PMCP/PDCR, Teradata Dynamic Workload Management, TASM, |

| |Database Console, Teradata Workload Analyzer |

| | |

|SKILLS |RDBMS |

| |Teradata V2R6, TD 12, TD 13, Oracle 9i, Oracle 10g |

| | |

| |Ticketing System |

| |Remedy, Espresso |

| | |

| |Backup Tools |

| |NetVault, Arcmain, RMAN |

| | |

| |Operating Systems |

| |Windows 95/98/NT/2000, UNIX MP-RAS, UNIX AIX, Linux |

| | |

| | |

| | | |

| |Databases: |

| |Oracle RDBMS (9i-10g) |

| |Teradata TD13,TD12,V2R6 |

| | |

| | |

| | |

| | |

| | |

| | | |

| |Application Server Environments: |

| |Oracle 9i AS, 10g AS |

| | |

| | | |

| |Operating Systems: |

| |Linux-Redhat AS 4.0 |

| | |

| |Windows NT/2000/XP/2003 |

| | |

| | |

| | |

| | | |

|REFERENCES |References are available on request. |

Contact this candidate