Oracle DBA
Resume:
PARTHA
Highly skilled in Information Technology Professional seeks a challenging Position as Software Developer in the field of Oracle (DBA) based products anywhere.
Summary
11+ Years of experience as Information Technology Professional.
Exposure to legacy Technology
Strong database administrating & problem solving skills.
Work effectively independently or as part of a team and manage team technically.
Function well in fast-paced environment.
Quick study, enjoy new challenges.
DBA Activity
Install & Upgrade Oracle including RAC
Apply Security Patch/PSU
Create New Databases
Clone Databases
Database version migration
Datagurd Configuration using DGB and manual option
Export/Import Database
Backup & Recovery
RMAN/Legato Backup
SQL*Loader
SGA Tuning
Database/Query Tuning
Writing CRON job
PL/SQL programming
SRM implementation for Oracle databases
Installing Oracle in Solaris, Linux and Windows
Oracle VERITAS Cluster environment
Oracle Streams, Multi Master Snapshot replication
Data-center consolidation
RAC implementation
COMPUTER SKILL
Operating System: Solaris, HP-Unix, Linux, AIX, Windows 98/2000/NT/XP
Languages: PL/SQL, T-SQL, Shell Script, VB, ASP, VB Script, Jscript, XML, C#, VB.NET, Basic Java
Database: Oracle 8/8i/9i/10g, Ms-Access, MSSQL-Server 7/2000
GUI Tools: Oracle 11i Apps (short time exposure), VB5/6.0, Visual Interdev, Crystal Report, VBA
Tools: TOAD, Microsoft Project Plan, Visual Studio, Data Protector, Legato, DBSPI, WIH, Putty
Others : SQL*Loader, RMAN, Export/Import, Solaris Resource Manager, Oracle in VCS (VERITAS Cluster), RAC, Legato, BMC, WIH Gold
Web Technologies HTML, DHTML, VBScript, JavaScript, XML, ASP, OAS (Oracle Application Server)
CERTIFICATIONS :OCP 9i (DBA)
TRAINING: Master in Oracle technology from Boston’s Bangalore concentrating mainly on Oracle8i, VB apart from extensive training in java for Oracle, HTML.
PROJECTS
Department of Human Services, Office of IT, USA Jan 2012 – till Date, Team - 40
DHS OIT manages various applications for Stage of Georgia. Various applications are
on different platform using Oracle 10g and 11g (RAC 2 Node).
Description
As Oracle DBA in OIT I am working on various application databases, like Department of Human Services Child Support System (a data warehouse solution), Document Imaging database, Shines application (application for senior citizen), AIMS application etc. Various applications have databases starting from 10g to 11g R2. Data warehouse has RAC (2 node) implementation.
• Involved in production database support, 24X7 on-call support
• Maintain backup/Recovery of various databases.
• Scheduled Quarterly Oracle CPU Patches.
• Provide expert support to application team for application enhancement related to database
• Coordinate with infrastructure support team to create new environments.
• Extensively worked on performance improving of several application, by database tuning and query tuning
• Planning and implementation on Oracle quarterly security patching
• Working on Datacenter migration to Winward Datacenter
Responsibilities:
• Production database support (on-call).
• migration/DB version upgrade
• Interact customer to understand new requirements
• Preparing and reviewing all documents deliverables to customer
• Create/Manage Unix Cron jobs
• Database install/upgrade/patches/migrate
• Critical tickets handling for all databases
• Oracle quarterly Security patch
• Datacenter migration
Technologies Used : Oracle 10g/11g, RAC, RMAN, DataGuard, Oracle Streams, Unix Shell Script
UPS, USA, Atlanta Jan 2009 – Jan 2012, Team 12
UPS SCS Billing Maintenance Oracle Databases Support
Onsite Oracle DBA Team Lead for UPS SCS Databases
Description
UPS Billing maintenance have several databases located mainly in New Jersey and Georgia data center. All these databases are used for UPS internal business critical applications. UPS has databases starting from Oracle 8i to Oracle 11g.
As part of DBA lead manged extensive offshore DBA team of 10 members.
• Involved in production database support, 24X7 on-call support
• Coordinate and mange entire offshore team and few other onsite locations.
• Scheduled Quarterly Oracle CPU Patches.
• Provide expert support to application team for application enhancement related to database
• Migrated more than 30 databases from Oracle 8i to Oracle 10.2.0.4 from HU-UX to Linux
• Performed several quarterly security patch/PSU for many databases.
Responsibilities:
• Successful migration of database for 40 databases
• Production database support for over 2 years (on-call).
• Manage Offshore team of 12 DBAs
• Manage most critical projects includes data-center migration/DB version upgrade
• Interact customer to understand new requirements
• Preparing and reviewing all documents deliverables to customer
• Create/Manage Unix Cron jobs
• Database install/upgrade/patches/migrate
• Critical tickets handling for all databases
• Migration of database from 8i to 10g/11g
• Oracle quarterly Security patch
• Install OEM and configure Grid Control, manage databases through grid control
Technologies Used : Oracle 8i/9i/10g/11g, Legato, HDFS, ShareFlex, Oracle Streaming, Unix Shell Script
Ericsson, Sweden, Stockholm August 2008 – Jan 2009, Team 22
AO (Application Operation) T&T:MKT Project, Oracle and MSSQL DBA, Ericsson
Started as SME and migration lead during migration phase and then moved into the role of senior DBA in Oracle and MSSQL
Description
T&T:MKT stands for Transition and Transformation Migration and Knowledge Transfer and AO stands for Application Operation. This project is the extended contracts from Ericsson to IBM. IBM gained new contract for maintaining database and other software administration task. As part of transition, entire team received knowledge from HP (prior vendor). After GCD (Global Commencement Day) Dec 1 2008, entire Oracle DBA, MSSQL DBA and other team moved to support. I am part of Oracle, MSSQL DBA team. There are more than 100 servers for Oracle ruining in Solaris, HP-Unix an VMS. Current team strength is 14 for Oracle DBA, 5 for MSSQL DBA. All these different databases are used for entire Ericsson business application. Some database are used for SAP application and some used for non SAP applications.
• Was involved in migration project from Q2 2007, when migration project started in IBM. I visited customers in Sweden for migration planning. I have successfully served as SME, in Sweden. I represented IBM as SME for Oracle, MSSQL and Sybase. I chaired several technical discussions with HP and Ericsson SMEs to plan and analyze transition plan. I alone created ASMP( Application Specific Migration Plan) for Oracle, MSSQL and Sybase. I have also created template for AOD (Application Operation Document), this document is purely technical document which describes complete responsibilities for DBA team. As SME I finalized KT plan for migration and I have also estimated migration project duration.
• When T&T: MKT project started, I was solely responsible for building DBA pools for Oracle and MSSQL. I have interviewed all members in Oracle and MSSQL DBA team. I have cleared more than 20 resources for this team.
• Facilitated entire new members for Ericsson processes and tools.
• Managed on-call support 24X7 for over a long period.
• Managed several database version and platform migration
• Worked on many quarterly security patches
• Contributed significantly to several database security configuration, like SOX complaint.
• Managed databases through GC, installed OEM client and update OEM client.
• When entire DBA team moved to delivery from T&T:MKT , was the first contact person for any help or understanding issues. Project manager has recognized my contribution for T&T:MKT project and management was happy with my performance.
• After GCD , Started solving ticket along with other members.
• Managed DCC (Data Center Consolidation) project, as part of this project Ericsson databases from different Europe country were migrated to Atlanta DC.
• Worked to RAC and VERITAS Cluster. Can maintain databases in RAC or database in VCS(VERITAS Cluster Server)
Responsibilities:
• Served successfully as migration lead in T&T:MKT project for Oracle, MSSQL and Sybase.
• Served as technical expert to recruit entire new team of more than 20
• SME for Oracle, MSSQL and Sybase to finalize migration plan
• Preparing all documents for migration like ASMP, AOD
• Supporting databases after migration
• Several management activities like preparation Risk assessment documents , KT status report,
• attending different KT phase like GP(Guided Performance phase), AP (Assisted Performance
• phase), PP (Parallel Performance phase) review meeting, to analyze schedule and issues
• Managing new team and monitor support activities (like ticket handling and solving critical issues)
• Create/Manage Unix Cron jobs
• Critical tickets handling for all databases
Technologies USed: Oracle 8i/9i/10g, Data Protector, Legato, DBSPI, Perl, Unix Shell Script
Ericsson, Sweden/India Oct 2006 – Oct 2007
EPIS, Ericsson
EPIS DBA (Oracle)
Description
Under the umbrella of EPIS application there 4 different applications running. These are CONTRACT, FBT, CDB & READ. These applications are mainly used by Ericsson sourcing users, where they can make an agreement with the supplier, once these agreements are approved by the agreement owner, then these information flown to SAP system for PO generation.
Recently I have completed Database migration for EPIS application from Oracle 8i to Oracle 10g.
• As EPIS DBA I am involved in maintaining all database schemas for all these application, control access to different environment. There is need to some development mainly for CONTRACT application for some modules, where functionality of these modules is database driven. Developing and maintaining existing interface is part of my responsibility. These EPIS applications have several interfaces like, Product information subscription from PRIM, ELIZA, and GASC applications. Ericsson user information from x500 system etc. Maintaining these interfaces are part of my regular activity. Maintaining various cron job running for different application is part of my responsibility.
• Maintaining and updating application related documents
• Create/update/clone databases
• Refresh databases between several environments
• Review application script and help in production roll-over
• Quarterly security patches.
• Upgrade oracle 8i to 10g.
• Export/Import of database
• Maintain Database space statistics
Responsibilities:
• Getting knowledge from existing team
• Preparing all documents for migration
• Supporting databases/applications after migration.
• Access control between different database environments
• Create/Manage Unix Cron jobs. Maintain inter application interfaces
• SPOC for EPIS DBA in IBM and on-demand help SPOC for other Oracle, MSSQL Databases in Ericsson account
• Writing Shell scripts for cron jobs
• Database upgrade from 8i to 10g
• New database creation
• Database cloning
• Performance Tuning
• Advance support to development team
• Installing Oracle in Solaris and Linux environment
Technologies Used: Oracle 8i/10g DBA, PL/SQL, Pro*C, Perl, Unix Shell Script, TOAD, MQ, Putty, SQL Loader, RMAN
Ericsson, Sweden/India Dec 2004 – Oct 2006
US and EU Local Applications
Oracle and MSSQL DBA, Team Lead
Description
In this project I had responsibility of Oracle and SQL Server DBA for US based local application for Ericsson, where I have to manage 20 Database servers. I have managed all database jobs, all process, data refreshing between different environment using export/import etc.
I managed more than 20 Oracle databases for Ericsson Local application. Where I had opportunities to create new database and manage existing databases including tuning, job monitoring etc.
One Oracle 11i Application was maintained by me, with some minor problem solving and regular data loading into this application was part of my responsibility.
Apart from this project I am presently having responsibility of SQL Server DBA for US based local
application for Ericsson, where I have to manage 10 Database servers, in those there are 4
production servers and 6 development and integration server, as a responsibility I have look after
all database jobs are running successfully, all process are working correct no hung process.
Some time move development server to production server and vise versa
Responsibilities:
• Database administrator for Oracle and MSSQL
• PL/SQL and T-SQL code development
• Requirement analysis with customer and other stakeholders.
• SPOC for quality activities within the team, represented team for several audits
• Team Lead
• Preparation of several RFS and proposal
• Writing Shell scripts for cron jobs
• Database upgrade from 8i to 10g
• New database creation
• Database cloning
• Performance Tuning
• Advance support to development team
• Installing Oracle in Solaris and Linux environment
Technologies Used: Oracle 8i/9i DBA, Shell script, PL/SQL, SQL Server DBA, Oracle 11i Financial
Ericsson, Sweden Jul 2004 – Feb 2005
ESG Applications
Application Migration lead, Application maintenance support, application team lead, MSSQL DBA
Description
ESG Ericsson Shared Global is a group of applications, where 8 applications are there; I was especially for 1 FTE application ESAD (Ericsson Shared Authorization Directory). This application was working for all Ericsson employee authorization control. All different companies in Ericsson were having few employees who have there own authorization level. In this application company admin can control authorization for different users. This application receives data from different SAP based application daily. Where this application was receiving data in text flat file and VB import job imports those data into ESAD database. Same way this application sends data in text file for other application that deals with the authorization level for different users. So this application has several incoming and outgoing interfaces.
Responsibilities:
• Migration lead during migration planning phase
• Getting knowledge from existing team
• Application support lead after migration.
• Ticket handling using WIH
• Proposal of several small enhancements and implementation of these
Technologies Used: VB 6.0, ASP 3.0, HTML, SQL Server, Crystal Report (Web based application)
SAGE, UK Mar 2004 to Jul 2004
SAGE BOM (Bill of materials)
, Team 9
.NET Developer and MSSQL DBA
Description
The Bill of materials (BOM) provides facilities to specify the structure of finished items in terms of Sub-assemblies, Components & Process cost (expense Item.). Once assemblies are defined. User will be able allocate & build /make the finished item though the Backflush functions of this module. Comprehensive reports & enquires will also be available to keep track of BOM structure of finished item. “Where Used” details for components, and Audit log for all BOM operations like create/Amend/delete and for comparing the structure of 2 BOM. This BOM module is intended that this will be integrated with Line 100 accounting & stock controls system.
I took extra responsibility to manage development database and helped other members in database issue. It was shortest stay with any employer in my career and I have performed one of the best in the team for all my assignment.
Tools : Visual Studio .NET, SQL Server
Responsibilities:
• Developed 2 different modules
• Code review for other modules developed by other team member.
• Debugging and Testing various other module.
• T-SQL Procedure and functions creations
• Test case creation
• Development database management and help other members in database related issue
Technologies USed: SAGE Framework on .NET Framework, C#, SQL Server 2000
Abrige, USA Nov 2003 to Mar 2004
C-Secure System
.NET Developer and MSSQL DBA
Description
The C-Secure® SCORECARD Balanced Performance Management System (or simply “Scorecard”) provides just-in-time performance feedback about the key performance indicators (“KPIs”) or “Perspectives” which have been determined to be central to the work for which each C-Secure® SCORECARD user is responsible
I played the role of technical team lead in this project first time in my career. I managed a team of 5 members. I have virtually worked in all aspect of this project, starting for requirement gathering to identify software/tools to be used to making a team. I had customer facing role and an interface between customer and development team.
I collect requirement, work on defining functional requirement document to test cases. As I aspired to be a DBA in long term, I always perused by DBA career by taking extra responsibility in managing databases. I was core member in database design for this system.
I have saved almost 400 man hours of effort by making sure project completes much before the planned end date, which was highly appreciated by management.
:
Responsibilities:
• Technical Team lead
• Developed various module
• Manage team members, meet SLA and quality deliverables
• Interaction with Client for requirement analysis and status updates
• Several enhancements estimations
• Creation of test cases
• Coordinating Production roll-out activity
• Creating and maintaining development databases
• Database administration
Technologies used: ASP.NET, C#, VB.NET Oracle 9i, XML, Visual Studio .NET, Oracle 9i
Vanguard Health Systems, Tennessee USA Jan 2003 to Dec 2003
Capital Expenditure Request (CER)
Developer and MSSQL DBA
Description
Capital Expenditure Request (CER) is a web-based application for managing lifecycles of forms or requests generated in an organization. The CER application is built on Cognitio’s existing Document Management System that contains workflow and document management modules. This system is used for managing lifecycles of various forms or requests such as expenditure request, contracts, policies and procedures for any organization by defining workflows through which each form or request will flow before it is approved. CER accomplishes this by permitting the users to route a form or request through various users and monitor its progress. CER has a modular structure, which allows it to comprehensively meet the lifecycle needs of a document
• Developed very critical modules of this project namely workflow system. Used SGML to built functionally correct/efficient and visually excellent module of this project.
• With my previous DBA exposure I was identified to DBA to manage databases in various environments. I contributed significantly in database design for this project. This is the stage of my career where I got first exposure in database design. As designer I have designed entire database objects, took part of defining standards of database object naming. I have extensively used ER Diagram for database design.
• I was first times put into situation to recover development database, due to system crash development database lost and I restored development database from test database. I was appreciated by management for this effort. It took more 12 hours of continuous work to restore the database.
Responsibilities:
• Developed various module
• Mentored team members
• Interaction with Client for requirement analysis and status updates
• Several enhancements estimations
• Creation of test cases
• Coordinating Production roll-out activity
• Creating and maintaining development databases
• Database administration
• Database Design
Technologies Used : ASP, VB, SQL Server 2000, XML, IIS5.0. HTML, Visual Studio .NET
Satya Sai Book Store, Bangalore, INDIA Mar 2002 to Dec 2002
Online Satya Sai Book Store
Developer and MSSQL DBA
Description
• Started as developer in this project, by end of this project I was their lone DBA
• Performed developer/tester/code reviewer for modules, namely Books Inventory, Supplier Inventory, Sales record etc.
• Used ASP/HTML for webpage design and functional code and write TSQL for procedures/functions.
• I also served as peer reviewer for other modules where I was able to contribute for good.
• Worked as a DBA /production support /Testing , had to control DB changes, like changes to code/DB objects etc. and provide backup strategy.
• Refreshed development database with testing database, managed DB access and controlled security.
Responsibilities:
• Developer
• Test case creation
• Testing/Peer Review
• Creation of T-SQL scripts for procedure and functions
• Several module development in ASP
• Database Design
• Database Administration
Technologies Used : ASP, VB, SQL Server 2000, XML, IIS5.0. HTML, DHTML, SQL Server, TSQL
Software Solution Integration, Bangalore, INDIA Feb 2001 to Dec 2002
Technical Trainer for SSI Institute
• Trains students in various technical skills, assist student practicing in Laboratory.
• Train students on HTML, DHTML,ASP, VB, SQL Server 2000, Oracle DBA
• Classes on part time basis only for Oracle DBA skills.
• Was a corporate trainer for several government organizations, namely LIC (Life Insurance Corporate), Corporation Bank etc.
EDUCATION :Diploma in Computer Science & Engineering May-1999
(Bangalore Technical University)
Contact this candidate