Career Objective:
Having around 6 years of Oracle Database experience and Data Warehousing, which includes Real Application Cluster Database experience seeking a challenging position as Oracle Database Administrator, OLAP Analyst and Developer where i can utilize my technical expertise in a progressively challenging Oracle environment.
Installed, Upgraded and configured various Oracle software packages, troubleshooting and development tasks on various platforms (Unix/NT) at client site.
Installed Solaris on Sun SPARC server. Customized System startup & shutdown procedures.
Configured DNS, DHCP, NFS, NIS+, Print Server, SAMBA, APACHE web server.
Created and maintained all databases required for development, testing, education and production usage.
Managed and supported 24X7 Oracle 9i production databases as well as development databases to ensure maximum availability of database for various applications.
Well versed with SQL and Functions, Procedures, and Packages of PL/SQL.
Automation of daily routine tasks like including user management, daily hot backup & weekly cold backup (using CRON & AT), storage management, develop data feed and standby database management, and administration by writing UNIX shell scripts.
Involved in application development teams for app. development, testing, system acceptance, implementation and migration to production.
Experienced in logical and physical database design, modeling.
Customized the database for data movement and expertise in data migration. Designed the structure of the database to reduce the contention and fragmentation. Ensure the safety of the database by creating multiplexed redo log files and control files.
Having hands on experience in Performance and Instance Tuning of the database.
Implemented firewalls and security system by using UNIX operating system.
Expertise in Troubleshooting the Problems regarding database, application and development tools.
Roles as per organization setup to organize the access to the database. Developed and implemented the strategy for managing security roles and privileges. Created profiles to control and optimize the system resources such as connect time, idle time, CPU time etc.
Experienced in database Analysis, design, creation, maintenance and upgradation.
Designed backup strategy in view of business requirement, activity level on the database. Complemented physical backup procedures with logical backup schedules. Restored the database after database crash, corruption and system crash on client site.
Involved in Configuration and Maintained Storage devices like NAS, SAN devices, replication and physically removable devices.
Did trouble shooting at 1) application level using tkprof/explain plan
2) OS level using SAR, VMSTAT, IOSTAT and TOP commands
Created Data Warehouse solutions and Reporting solutions using OLAP Techniques like 'Drill Down', 'Slice and Dice', Drill Through.
Technical Skills:
Web Technologies: FrontPage, HTML, XML, ASP.NET.
Tools: Oracle 9i JDeveloper, Oracle Forms, Oracle Reports, T-SQL, SQL*Plus, TOAD, Iwatch, Explain Plan, Visual Basic, Erwin, Photoshop, MS Office XP,
Data Warehousing INFORMATICA, BUSINESS OBJECTS, COGNOS, COGNOS
Tools REPORT NET, DATASTAGE, MICRO STRATEGY.
Database Administration Oracle DBA 7x/8x/9x
Systems Administration UNIX Administration (Solaris 2.7)
WebServices: Discovery (UDDI, DISCO), Description (WSDL, XML Schema), Message Format (SOAP), Encoding (XML) and Transport (HTML, SMTP
etc).
Operating Systems: HPUX 11.x, Sun-Solaris 2.x, UNIX, MS-DOS, Linux, MS Windows.
Web/Application Oracle Application Server (OAS, 9iAS), OC4J (J2EE Containers for 9i) Server: IIS 5.1, Apache Web Server, Webmin.
Hardware: Sunsparc E10K, HP9000, IBM PC Compatible, IBM Sunsparc E10K,
HP9000, IBM PC Compatible, IBM ES9000, EMC Timefinder, Veritas
Netbackup, Legato storage Manager.
RDBMS: Oracle 7x/8x/9x RAC, MS Access, IBM DB2 Universal, DB2 Everyplace, MS-SQL Server 7.0, SYBASE.
Languages: FORTRAN, C, C++, C#, JAVA, SQL, and PL/SQL, Perl, Phython.
Shell (KORN, BOURN, AWK, SED)
Utilities: RMAN, SQL*Loader, Export/Import, Svrmgr, Sql*Net, SAMBA, EMC SAN and NAS Devices.
Applications: Oracle APS, Oracle Mission/Business Critical Applications.
Networks: IEEE 802.1x Wireless LAN, Novell, Ad-hoc, Infrastructure, Synchronization between Pocket PC (Compaq iPAQ PPC) and PC.
Industry Experience
Oracle DBA, OLAP Analyst & Developer Mar 2005 till date
Client: MasterCard International (Global Technology & Operations), MO.
Responsibilities:
Installation of Oracle 10g and Upgrading Oracle 9i (9.2.0.1) RAC database and its related tools to new work stations and a server.
Involved in system study, analysis, design and maintenance of database.
Installed and Configured INFORMATICA.
INFORMATICA is used for constructing the Data Warehouse.
Performed data cleansing and transformation using INFORMATICA.
Created aggregate tables for efficiency using INFORMATICA.
Used INFORMATICA to populate the Data mart from large flat files and databases.
Created complex mappings using Aggregator, Expression, Joiner, Update strategy transformations
etc.
Was responsible for Error handling of INFORMATICA mappings.
Created and Monitored Batches and Sessions using INFORMATICA.
Installed COGNOS Power Play Enterprise Server, Transformer, Scheduler.
Applied the security to cubes and reports through COGNOS Access Manager.
Created Multi-Dimensional Power Play Cubes and Reports as per the User Requirements.
Customized data by adding calculations, summaries and functions.
Created different Prompts as per User Requirements.
Deployed the Power Cubes on COGNOS Power Play Enterprise Server.
Created standard and Ad hoc reports using COGNOS Impromptu tool.
Developed Power play cubes and published on Power Play Transformer.
Applied Drill through, Drill down capabilities to reports.
RAC Database has been implemented over Storage Area Network (SAN), with EMC Clarion FC 4700 storage, Fiber Channel Host Bus Adapter (FCHBA) I/O controller, 8 port FC switch and fiber channel media.
Installed Red Hat Linux Advanced Server 2.1 on both the nodes after creating necessary partitions and configured different parameters for setting up private network, public network, rlogin...etc on 2 Nodes.
Installed Oracle 9.2.0.1 RAC software and patched it to upgrade to 9.2.0.4
Created various RAW Partitions for the database and symbolic links to access these Raw Partitions from the Oracle Database
Defined various init.ora parameters and put the database level parameters in the SPFile on the common Shared Disk Subsystem (SDS)
Involved in Creating the Database on Shared Disk Subsystem on RAW partitions and put the Database in Archive Log Mode
Created undo tablespaces, Redo log file groups and thread 2 for adding second instance to the RAC System
Configured Recovery Manager (RMAN) for RAC Database backup, restore and recovery operations
Configured the listeners and aliases to set up Transparent Application Failover (TAF)
Tuned the RAC database by observing the views like gv$sysstat, gv$session_wait etc.
Managed Accounts, Disk quotas. Customized System startup & shutdown procedures.
Helped development team in writing, executing and Tuning PL/SQL Functions, Procedures, Packages.
Expertise in Backup, recovery, export/import of database.
Working with Unix Shell Scripts (export/import script for 8i/9i 0racle Database at Full Database, User, Table Level modes. Invoking .pls script for correcting the Sequences after importing the data from the main Shell script).
Tuning the Oracle instance for optimal performance.
Creating new users, groups and granting appropriate privileges.
Designing, creation, maintenance and troubleshooting of database.
Having working knowledge of Oracle 10g new features.
Cloning the test and development environments from production.
Maintaining of Hot Standby Database.
Environment: Sun Fire 4800, Sun Solaris 2.8, Oracle 10g, Oracle 9i RAC, IBM DB2,
BMC PATROL, SQL Server, INFORMATICA, COGNOS, TOAD,
SQL, PL/SQL, EMC SAN device, Oracle 11iFinancials, Oracle Forms, Reports.
Oracle DBA, OLAP Analyst & Developer May 2004 Feb 2005
Client: Fidelity Investments, NH.
Responsibilities:
Installation and Upgrading Oracle 9i (9.2.0.2) RAC database and its related tools to new work stations and a server.
Involved in system study, analysis, design and maintenance of database.
Managed Accounts, Disk quotas. Customized System startup & shutdown procedures.
Architect and implemented Oracle database related enterprise solutions with optimized performance for underlying hardware and OS environment.
Analyzed, designed, developed and implemented jobs using DataStage Enterprise Edition.
Experience installing and setting up DataStage Enterprise Edition.
Work with management to establish, document and enforce procedures related to load balancing and prioritization of issues.
Developed SQL scripts and stored procedures to augment the ETL process.
Developed Unix scripts to support the ETL processes.
Worked closely with the business systems analyst to develop the source to target data mappings.
Installed and configured BUSINESS OBJECTS.
Extensive analysis is done to design the BUSINESS OBJECTS Universes and assign them to respective domains.
Created BUSINESS OBJECTS repository and security domain with user groups and security implementation.
Created aliases, contexts to overcome loops.
Involved in full life cycle of BUSINESS OBJECTS reporting Application.
Managed 24X7 Oracle 9i Production and Application database.
Configured and implemented Data Storage Devices like SAN, NAS and implemented replication for existing system.
Helped development team in writing, executing and Tuning Stored Procedures, (SQL/PLSQL) Functions and Packages.
Managing Backup, recovery, export/import of database.
Applied patches to Oracle Databases.
Responsible for performance tuning of databases, SQL query tuning, and working with development team to tune applications.
Migrated the Sybase database to Oracle database.
Implementation of Security of database down to cells by creating users, groups, profiles.
Implemented Web services which use Oracle database using Oracle 9i JDeveloper.
Writing UNIX Shell Scripts for day-to-day tasks.
Database Monitoring. Tuning the Oracle instance for optimal performance.
Designing, creation, maintenance and troubleshooting of database.
Performed database health assessment and review for clients in Oracle.
Managed subset databases for Data Warehousing running on
MS-SQL Server.
Environment: Sun Fire V880, Sun Solaris 2.8, Oracle 9i RAC, SQL- Explorer, DBXray, Sybase,
SQL Server, DATASTAGE, BUSINESS OBJECTS, EMC SAN device,
Oracle 11iFinancials, Forms, Reports.
Oracle DBA, OLAP Analyst & Developer (Oct 2003 - Apr 2004)
Client: Aetna Insurance, CT
Responsibilities:
Involved in Analysis, Design and Implementation and maintain of the database
Logical Backups by Exports & Imports.
Using RMAN utility to perform backup and recovery functions.
Responsible for performance tuning of databases, SQL query tuning, and working with development team to tune applications.
Involved with the development team and developed functions, procedures and packages using PL/SQL.
Erwin is used for Data modeling and for designing entity relationships.
Managed Basic, Advanced, Multi-master Replication. Monitoring Replication.
Installed and Configured INFORMATICA.
INFORMATICA is used for constructing the Data Warehouse.
Performed data cleansing and transformation using INFORMATICA.
Created aggregate tables for efficiency using INFORMATICA.
Used INFORMATICA to populate the Data mart from large flat files and databases.
Created complex mappings using Aggregator, Expression, Joiner, Update strategy transformations
etc.
Was responsible for Error handling of INFORMATICA mappings.
Created and Monitored Batches and Sessions using INFORMATICA.
Developed SQL scripts and stored procedures to augment the ETL process.
Developed Unix scripts to support the ETL processes.
Worked closely with the business systems analyst to develop the source to target data mappings.
Installed and configured BUSINESS OBJECTS.
Extensive analysis is done to design the BUSINESS OBJECTS Universes and assign them to respective domains.
Created BUSINESS OBJECTS repository and security domain with user groups and security implementation.
Created aliases, contexts to overcome loops.
Involved in full life cycle of BUSINESS OBJECTS reporting Application.
Applied patches to Oracle Server.
Expert in using Oracle Enterprise Manager (OEM), Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA).
Performance and kernel tuning to get optimal performance tuning of the database.
Implementation of firewalls and security levels at Sun Solaris level.
Implementing database constraints to ensure integrity of the database.
Updating the test and development environments from production (cloning).
Maintaining of Hot Standby Database.
Tuning the oracle instance for optimal performance.
Re-org the table for tuning issues
Environment: Sun Fire 480, Windows NT, Sun Solaris 2.7, Sybase, OEM, Oracle 9i, INFORMATICA, BUSINESS OBJECTS, EMC - Replication Manager, TOAD, SQL, PL/SQL.
Oracle DBA, OLAP Analyst & Developer
Client: Boehringer Ingelheim Pharmaceuticals, Inc, CT (Jan 2003 Sep 2003)
Responsibilities:
Designed Database considering Server configuration, disk/space configuration, # of processes, size of the database and its objects, frequent bulk data loads from a remote database and database availability.
Develop/Maintain Backup and Recovery strategies for a 24x7 operation. Strategies include cold backups, hot backups and incremental Exports using Veritas Legato storage manager.
Installed and Configured INFORMATICA.
INFORMATICA is used for constructing the Data Warehouse.
Performed data cleansing and transformation using INFORMATICA.
Created aggregate tables for efficiency using INFORMATICA.
Used INFORMATICA to populate the Data mart from large flat files and databases.
Created complex mappings using Aggregator, Expression, Joiner, Update strategy transformations
etc.
Was responsible for Error handling of INFORMATICA mappings.
Created and Monitored Batches and Sessions using INFORMATICA.
Installed COGNOS Power Play Enterprise Server, Transformer, Scheduler.
Applied the security to cubes and reports through COGNOS Access Manager.
Created Multi-Dimensional Power Play Cubes and Reports as per the User Requirements.
Customized data by adding calculations, summaries and functions.
Created different Prompts as per User Requirements.
Deployed the Power Cubes on COGNOS Power Play Enterprise Server.
Created standard and Ad hoc reports using COGNOS Impromptu tool.
Developed Power play cubes and published on Power Play Transformer.
Applied Drill through, Drill down capabilities to reports.
Security Management with Roles/Privileges/Quotas/Profiles, Access management.
Applied patches to Oracle Server.
Configuring SQL*Net connectivity between Clients and Servers.
Involved in Performance Tuning and Instance Tuning.
Wrote programs in PL/SQL to update Oracle 9i, 8i tables.
Involved in data Migration using SQL* Loader from files to system Database.
Using Explain plan, analyze, TK Prof.
Oracle replication (Snap shot) implemented for Availability and Performance.
Updating the test and development environments from production (cloning).
Setting size of SGA constituents like buffer cache, dictionary cache, and library cache.
Manage storage parameters for objects like Tablespaces, Tables, Datafiles, Indexes.
Involved in SQL tuning within PL/SQL stored procedures for optimal performance.
Environment: HP-UX 11, Oracle 8i, 9i, SQL server 2000/7.0, SQL, PL/SQL, SQL *plus, SQL Navigator, TOAD, INFORMATICA, COGNOS, Enterprise Manager, Veritas Volume Manager, Developer 2000.
Oracle Programmer / DBA (Nov 2001 Dec 2002)
Client: Bank of America, FL
Responsibilities:
Normalized the database.
Erwin is used for Data modeling and for designing entity relationships.
Creation of Databases for Testing and Development.
Coding of backend triggers involved in SQL, PL/SQL.
Planning & Implementation of Backup and Recovery Strategies.
Taking Logical Backups by Exports & Imports.
Performed database re-organizations to improve database performance.
Wrote shell scripts for archiving the log files and database monitoring.
Helped the application development team in tuning and testing developer created queries.
Working with oracle utilities like RMAN, SQL* Loader, Lsnrctl.
Maintained a lag time on the standby for disaster recovery purposes
Maintained standards in place to ensure that all application design and code is produced with proper integrity.
Configured Managed Recovery Standby database.
Monitoring fragmentation at tablespace level for Optimal Utilization
Tuned parallel queries.
Environment: Sun Sparc Ultra-3000, Sun Solaris 2.7, Oracle 8.1.5, Autosys, Sql-Backtrack,
BMC Patrol, EMC, Designer/2000, Oracle Applications, Replication
Manager, High Availability Standby database (SRDF Configuration)
Oracle programmer / DBA (Jul 2000 Aug 2001)
Client: SB Infopark, India.
Responsibilities:
Created primary objects like tables, views and indexes.
Wrote stored procedures, functions, Packages, Handling Exceptions, creating database triggers using SQL and PL/SQL in Oracle.
Developed e-commerce web application using Oracle Forms.
Allocated system storage and planned future storage requirements for test and production databases. Making sure that availability of database is 24x7 hrs.
Erwin is used for Data modeling and for designing entity relationships.
Planning & Implementation of Backup and Recovery Strategies.
Taking Logical Backups by Exports & Imports.
Identified Hot Blocks thereby eliminating I/O issues
Performed space management by eliminating fragmentation, row-chaining/migration
Used DB Verify (dbv) to deal with block corruptions.
Monitoring fragmentation at tablespace level for Optimal Utilization
Re-org the table for tuning issues
Maintaining Hot Standby database.
Environment: Sun Solaris 2.6, Oracle 7x/8x, Oracle Forms & Reports, Applications.
Conferences:
Oracle Open World 2002 San Francisco, CA.
Education:
B.S Computer Science.
|
