Oracle Manager
Resume:
Rajeev Krishnan
Senior Oracle DBA
Email: **.********@*****.*** Mob: +1-972-***-****
Experience Summary
• 10 Years of experience as an Oracle DBA.Experience in SYSDBA and APPDBA roles.
• Experience in managing Oracle 12c, 11g, Oracle 10g, Oracle 9i, Oracle 8i and SQL server 7.0/2000 databases in
Production, Test, and Development environment.
• Expertise in production support,on call support and support for several application releases
• Strong knowledge in Database concepts and Oracle internals.
• Worked on many RDBMS (Oracle, SQL server, MySQL and MS Access)
• worked on setting up Oracle Restart and Oracle RAC databases with ASM
• Experience in backup and recovery using RMAN
• Experience in setting up and managing Oracle data guard and done many quarterly DR tests
• Worked on several database migrations from Unix to Linux (OEL)
• Work experience in Oracle streams, Golden gate and materialized views.
• Worked on many streams to golden gate migrations
• Experience in database and SQL performance tuning.
• Worked on many data move and migrations using exp/imp and data pump utilities
• Experience in security administration and access controls(ACL)
• Very good hands on experience in Oracle enterprise manager setup and agent rollouts.
• Experience in Database upgrades, migrations and database patching
• Experience in setting up and managing Oracle gateway for SQL server
• Experience with Oracle flashback and heavily used flashback feature for database upgrades.
• Very good in OS concepts and work experience in UNIX and Linux flavors.
• Experience in setting up Linux and database setups.
• Experience with Oracle APEX installation and configuration
• Work experience on Oracle Exadata machines
• Work on ACFS and DBFS replication
• Experience in setting data archive purge by making use of table partitioning technology and process automation using
PLSQL blocks.
• Experience in several DBA tools like SQL developer,Toad,DBArtisan,VCS,DBC and OEM
• Experience in setting up Web servers and services in Linux platform.
• Experience in PLSQL and Shell scripting
• Work experience in programming languages (PHP,Ksh scripts,HTML,Javascripts and SQL PLSQL)
• Worked on several DBA automation tasks .Eg : Routine database refreshes .
• Experience in working with Oracle support to resolve bugs and troubleshoot issues.
• Experience in the role of Onsite coordinator for many production rollouts.
• Very good troubleshooting skills.
• Experience in Capacity planning, Installation, Configurations of new DBs and migration of existing ones
• Very good experience in working closely with customers to understand application and the schema dependencies.
• Experience in setting up ADRCI and purge policies
• Experience in taking technical trainings, Documentation and mentoring juniors in the team.
• Excellent customer handling skills and very good analytical and communication skills
Education and Certification
Bachelors in Computer science and Engineering from Madurai Kamaraj University, India (Year 2003)
Microsoft Certified Database Administrator (MCDBA), SQL Server 2000 (Year 2004)
Award
Multiple ‘on the spot award’ from the management for the good performance (Fidelity Investments)
Technical summary
• Database versions Oracle 12c/11g/10g/9i/8i, SQLServer7/2000
• RDBMS Oracle, MS SQL, MS Access, MySQL
• High Availability 11g Oracle RAC,Data guard
• DB Management OEM 11g, 12C,DBC,VCS
• Replication Oracle Golden Gate, Oracle Streams,Materialized views
• Storage Oracle ASM
• Tools Oracle SQL Developer, TOAD,DBArtisan
• Platforms UNIX,Linux,Oracle Exadata
• Internet firewalls, proxies, IIS, TomCat,e mail(Sendmail,Exchange),
• Languages SQL,PL/SQL,UNIX shell script(ksh),HTML,PhP,JavaScript
WORK EXPERIENCE:
EMPLOYER: Fidelity Investments June 2008 – August 2014
Project 1 : OEM 12c implementation for 1000+ databases for monitoring and alerting
Role : Senior Database administrator /Onsite coordinator
Technology : OEM 12c, SunOS,AIX and OEL
Location : Dallas, Texas
The scope of the project includes OEM implementation for all oracle databases across various BUs in fidelity.
Responsibilities
Educate the customers on the need for OEM implementation
Prepare documentation on the implementation part
OEM agent installations and configuration
Various automations to speed up the rollout
Work with oracle support on various issues and bug fixes
Planning and coordination with customers and offshore OEM team
Coordinate development and production rollouts
Troubleshooting issues and on call support for OEM related issues.
Additional responsibilities handled include
• Primary SYS DBA for FPRS application
• On call support/additional help for the core SYS DBA team
• Documentation and mentoring juniors in the team
Project 2 : Application DBA support to internal applications
Location : Bangalore India
Role : Senior ORACLE DBA /Offshore lead
Technology :
Database Oracle 11g ASM,Oracle 10g,Oracle 9i Databases
Vendor applications Service Manager (HP)
PPM Central(HP)
Alarm Point
xMatters
ERC
Axway
Interwoven
Spacewalk
Avada
11g RAC,Oracle Restart,RMAN,Dataguard,OEM 11g,12C,
Oracle GoldenGate,Oracle streams, Oracle Gateway
Operating System Unix(Oracle Solaris,AIX), Oracle Enterprise Linux,RedHat
Scripting Unix Ksh Scripting
Major Database projects handled:
• PPM Central version migration.
• PPM Central Streams to Golden gate migration
• PPM Central PROD Linux migration
• Application/DB migration to linux and streams implementation.
• Unix to Linux migrations (Oracle restart) for all non linux environments.
• RAC Implementation for axway application
• Alarm point upgrade and migration to new version.
• xMatters POC setup,Capacity planning, migration
• Service Center to Service Manager Upgrade and migration.
• Service Manager Golden gate implementation
• Interwoven linux /VM migration
• Axway archive process implementation and table partitioning
• new database setup and configuration for avada application
• Post migration Performance tuning of Service Manager Database.
• Part of OEM 12C test team.
Responsibilities:
• Primary DBA for critical applications(Service Center,PPM Central, Alarm Point,xMatters,ERC,Axway,
Interwoven,Spacewalk and Avada)
• SYS DBA support, Application DBA support & Performance Tuning.
• Capacity planning, Installation, Configurations of new DBs and migration of existing ones
• Manage replication in multi location infrastructure – Using Oracle RAC, One way and Two way Oracle Streams,
Materialized Views and Golden gate.
• Migrations from Oracle streams to Oracle golden gate.
• Oracle golden gate version upgrade
• Database upgrades, Quarterly PSUs,Linux Server Migrations
• Troubleshoot INCIDENTS and resolve issues.
• Work closely with MOS on Sev1,Sev2 issues.
• Build and maintain RAC using Oracle grid infrastructure.
• Automation and monitoring through shell scripts
• Maintain daily RMAN backup
• Schema level backup using data pump .Initiative to move from exp to DP .
• Work closely with onshore counterpart and mentor offshore team in day to day Support.
• Average of 5 production requests a week
• Many off hour and weekend support requirements
• On call support for production issues
• Table Partition management for Alarm point and Axway ARCH tables.
• Setting up Application Archive purge .
• 11g ASM Linux Oracle restart install and maintenance.
• Quarterly DR tests.
• Work on Mass amount of PPM requests to cover our needy developers.
• Supported Major database and application upgrades of PPMC, ERC, Service Manager, and Alarm point databases
• Query& database performance tuning using ADDM,AWR,SPA,tkprof and Advisories.
• User audits using LOGON trigger and audit_trail
• Storage management using SRMCLIENT.
• Manage oracle dbms and scheduler jobs for MV refreshes
• Install, Configure and Manage Oracle gateway for SQL server.
• ADRCI configurations to set Purge policies
• Create Documentation and checklists to follow standards.
EMPLOYER: Wipro Technologies
Location : Bangalore, India November 2007 June 2008
Project 1 : Cardinal health database support project
Role : Oracle DBA
The scope of assignment includes support for Oracle databases in 24*7 environments. It includes production, development
and Stage databases.
Technology:
Database server – Oracle 8i, 9i
Others Clarify tool, Rman, Toad
Operating system Windows 2000, Windows 2003 Server, UNIX (H.P)
Responsibilities:
• Support to application team for various activities.
• Attend SRT during critical activities.
• Give on call support on weekends for production issues.
• Analyze problems and develop solutions to meet customer needs
• Database Space Monitoring and management
• Performance tuning and security Management
• Databases refresh using export/Import utility
• Version upgrade and patch apply
• Database backup management using RMAN
• Rebuild indexes as required
• Manage data load through SQLLoader
• Create SR/work with Oracle support for critical issues.
• Manage cron jobs set for different database activities.
• Generate SOX report on weekly/monthly basis
• Manage table partitions for data ware houses
• Stats collection on databases as required.
•Object creation/Package compilation for development team
Do standby sync during when it is out of sync.
EMPLOYER: Wipro Technologies
Location : Reading, UK Aug 2007 October 2007
Project 2: TWUL(Thames Water Utility Limited) Transition project
Role : Oracle DBA transition team member
The scope of the assignment includes complete transition of Oracle DBA activities of production/test databases (HRMS,
Peoplesoft, and SAP backend) to Wipro technologies from the current support team (ATOS)
Technology:
Database server – Oracle 8i, 9i, 10g
Others Clarify tool
Operating system Windows 2003 Server, UNIX (H.P, SUN)
Responsibilities:
Prepare KAP (knowledge acquisition program) plan
Prepare questionnaire from KAP plan
Q&A sessions, discussions/Meetings with the current support team
Gather details about scope of work and SLA (Service level agreements)
Prepare the final checklist
Handover documents and project transition to the Wipro team
EMPLOYER : Wipro Technologies
Location : Bangalore & Kornberg, Germany May 2004 July 2007
Project 3 : GILLETTE (P&G) Oracle SAP support project
Role: Oracle/SQL DBA
The scope of the project includes production support and maintenance for large size SAP/Non SAP Oracle and SQL server
databases
Technology:
Database server – Oracle 8i, 9i, 10g AND SQL server 7.0/2000
Others EMC SQLBacktrack, Autosys, Patrol, and Oracle express
Operating system Windows NT, 2000, 2003, UNIX (Sun, H.P, AIX)
Responsibilities:
Oracle:
• Troubleshooting of all kinds of Oracle production/dev/test issues.
• Oracle backup job management through Crontab and Autosys
• Installation/configuration of oracle server
• Creation/configuration of new databases and schema design
• Technical support to Development teams(Object maintenance and loading of data)
• Configuration of Instance connectivity setup
• Database Space estimation and management
• Performance tuning: tuning of SQL and PLSQL Scripts and statistics collection
• Handling oracle security issues
• SAP cross recovery from offline backups
• Databases/Table refresh using export/Import utility
• Database cloning
• Version upgrade, Migration and patch apply on production
• Physical standby setup
• Rebuild of standby databases during out of sync
• Yearly DR tests
SQL server:
• Installation and configuration of MS SQL Server.
• Creation and management of backup and maintenance jobs.
• Process management
• SQL server rebuild
• System administration, gathering database requirements, functional specification
• Backing up and restoring system and user databases
• Database migration from version 7.0 to 2000
• Handling space issues (Database level and disk level)
• Database movement using attach detach method
• Monitoring and tuning SQL Server performance with multiple tools including
Performance Monitor, SQL Profiler to achieve better performance,
Accessibility and efficiency
EMPLOYER: IWebTune
Location : Bangalore, India February 2004 – May2004
Project : Web based application development for different customers
Technology : ASP, PhP, Mysql, SQL Server, IIS
Role : Web developer
Website development and maintenance in ASP/PHP with MYSQL/SQL server as backend.
Experience in configuring/Managing Web servers (IIS)
References available on request
Contact this candidate