We provide IT Staff Augmentation Services!

Oracle Database Manager Resume Profile

4.00/5 (Submit Your Rating)

Summary

  • Over 15 plus years of IT experience focusing on Oracle Database Management and Administration with experience in the Financials Federal Reserve bank , Fannie Mae ,Health Care MMIS for states of WA, MI,TX,SD , and Telecommunication Worldcom industry as Oralce Database Sr.DBA/ Lead.
  • Experience in Agile Technology and ITIL technical solutions and certified in Customer Training.
  • Involved in vital planning for infrastructure setup for the Health care system from across the nation and Globaly.
  • Management and Administration of Oracle RAC real application cluster system from design architecture to Replication implementation.
  • High Availability: Implemented Data Guard logical physical for maximum protection, performance and availability and Golden Gate for Oracle data migration from Sol to AIX.
  • Defined the Cost saving structured Shared-Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests.
  • Involved actively in technical solutions in bidding proposal for future Business development.
  • Implemented Ticketing standards based on severity of Tiers and SLA.
  • Customized and Administered Oracle Database for COTS products CRM Siebel, Cognos and Business objects to suite the Medicaid Medical information systems MMIS .
  • Administered and Engineered for the upgrade of Deltek products Costpoint and Timesheet and Sage payroll supporting Oracle DB for HRMS.
  • Managed Oracle database for Micro Focus Cobol application for MMIS Drug Rebate and Pharmaceutical applications.
  • Implemented Geo Spatial GIS using the ArcGIS, ArcIMS and ArcSDE ESRI applications for mapping the Database information onto the geographical maps
  • Managed Configuration Management oracle Database for IBM's Rational products Clear Quest Clear Case for Defects and Ticketing system.
  • Managed the Oracle E-business suite Balance scorecard for the high level management to forecast the budgets.
  • Administered Production Databases in ASM / VCS / QFS for platforms in Solaris , AIX, Linux and Windows. Used Storage from Vendors Veritas , Hitachi , SAN , EMC , HP , Oracle. HUR and SRDF were implemented for OS Cloning.
  • Managed team of DBA's on site and off site spread across the globe. Managed DBA teams of Administration, Application , Production, Change Management, NOC, On-call support and performance optimization. Hiring , Performance evaluation and Goal setting of DBAs to meet the project demands on daily/weekly/Annual basis. Defined cost saving Shared Services and Outsourcing programs. Involved in Technical solutions for Proposals for future business development.
  • Managed team of DBA's on site and off site spread across the globe. Managed DBA teams of Administration, Application , Production, Change Management, NOC, On-call support and performance optimization. Hiring , Performance evaluation and Goal setting of DBAs to meet the project demands on daily/weekly/Annual basis. Defined cost saving Shared Services and Outsourcing programs. Involved in Technical solutions for Proposals for future business development.
  • Experience in Oracle versions from Oracle 12c 11G 10g 9i 8i.
  • Security and Privacy of database: - HIPAA, FIPS, PHI, DITSCAP, DES3, Obfuscation, MHIS, Audit.
  • Administered and Deployed Web application products Oracle iAS , IBM Websphere , BAE Web logic, Tomcat , Jboss for RDBMS ODBC setup and installation.
  • Extensive experience in the architecture of Data warehouse, VLDB over 20 TB , OLTP, DSS and OLAP. Implemented ETL tools informatics and Ascential.
  • Migration from legacy servers to oracle using Oracle utilities workbench .
  • Involved in the planning design for Exadata in Data warehouse.
  • Administered full phase cycle of the database. Administered Development, QA , Integration , UAT , Pre Prod and Production environments including the legacy conversion and interface environment.
  • RMAN for Cold and Hot backups and Recovery including Point in time recovery. FRA and Flashback Technology were implemented. Implemented RMAN and Data Guard for backups. Backup to tapes using veritos, Netbackup , Tivoli and EMC.
  • TCP/IP data networks performance analysis, Capacity planning, Customer billing and Cost modeling for VOIP voice over internet protocol . Supported NetIQ , Foreview and Cascade views.

TECHNICAL SKILLS

  • RDBMS
  • Oracle 11g/10g/9i/8i/ with RAC, Rac1 , Data Guard, OLAP, OLTP, DW , ASM , SQL server .
  • Application Admin
  • Siebel, Cognos , HRMS Deltek , Sage FLS, Balance Score Card, E-business suite, 11i Financials ,Geo Spatial , Mercury , Ascential, Seebeyond , IBM Rational Clear Clear Quest , Emprix., Microfocus Cobol
  • Web application
  • Oracle iAS, Websphere, web logic, Tomcat , Jboss ,portal
  • Hardware
  • Solaris Sparc , IBM RS/6000, Intel Pentium IIx, HP C160, Sun Enterprise 450, Dell 6650
  • O/S
  • Sun Solaris 5.10 sparc, IBM AIX 4.3.2, Red Hat 3.0 AS, HP UNIX 11.0, SCO UNIX, Novell 3.12, SAMBA, Windows 2003/AS
  • Data warehouse
  • Kaildo, Exadata, Ascential ,Abinitio, Seebeyond, Informatics, Retek, Xenobridge , Data guard, Partitions, Crystal reports, Business objects , Microstrategy
  • Database Tools
  • OEM, RMAN, Data Guard, DATAPUMP, TOAD, ERWIN, Designer 2000, JAD, ESRI, GRID, RAC, Mercury, DbArtisian, Embarcadero Studio , Spotlite
  • Backup Applications
  • RMAN, Data guard, Netbackup, EMC, veritos , Tivoli Flashback , FRA , Datapump. Online and offline backups , coldbackups, logical backups
  • Performance
  • ADDM, AWR , Explain , Trace , Stats pack , OEM , DBMS STATS, CBO, Mercury , SQL Tuning Advisor
  • Languages
  • DB wizard, SQL, SQl Worksheet, PL/SQL, Perl scripts, Pro C , COBOL,C , C, JAVA, XML , UML , HTML ,TSQL

TEAM SKILLS

Team Themes

  • Service Delivery , Service of Excellence and People
  • Administration, Production, Operation,Application, Change Management, On-Call support, optimization, Infrastructure

CONFIDENTIAL

Professional Experience

CONFIDENTIAL

Oracle Database Manager

  • Administered and Managed Rac1 / RAC enterprise-level Oracle 11g database systems for Production environment
  • Implemented Dataguard setup in physical mode for Rac 1 and RAC databases.
  • Migrated from Enterprise standalone databases to RAC 1 database environments using Golden Gate for Oracle from Sun Solaris to IBm AIX.
  • Implemented Rman setup for backups including Tivoli backups and Control M for auto jobs scheduling .
  • Supported IBM Xenobridge tool Data pump for migration and data loading for historical databases involving partitions .
  • Involved aggressively in technical solutions in bidding proposal for future business development.
  • Participated in vital planning for infrastructure setup of the EOD End of Day total transcations which involved geographically dispersed sites across the nation
  • Involved in developing Metadata Compare Application for Database multiple schemas across environment and E/R Studio models
  • Managed and administrated database and database applications 24x7 that include Oracle 10g/11g/12c Databases, Siebel and Cognos application databases, Micro focus Cobol , RAC real application cluster clustering server, OEM Grid , High Availability, Data Guard , Web service applications WebSphere and WebLogic and IBM Rational products.
  • Upgraded Oracle RDBMS and Cluster CRS cluster resource services from Oracle 10g to 12c.
  • Implemented 11g feature Flashback Data archive on History archive tables and Partitions for Data warehouse VLDB . Big data technology was implemented on Secuirty / Fixed sub systems .
  • Installed patches including Oracle Security periodic patches , Upgrade for oracle databases and clusterware.
  • Optimize / Tuning the database based on the expectation of the SLA and process . AWR and SPA tool were implemented .
  • Managed team of DBA's on site and off site spread across the globe. Managed DBA teams of Administration, Application , Production, Change Management, NOC, On-call support and performance optimization
  • .Implemented Oracle RAC Replication from scratch for clustering the database server to support the increased number of daily claim transaction volumes and high availability of the database system by enabling Load balance and Instance failover features
  • Administered Production Databases in ASM / VCS / QFS for platforms in Solaris , AIX, and Windows. Used Storage from Vendors Veritas and Hitachi . HUR and SRDF were implemented for OS Cloning.
  • Implemented ITIL Remedy Ticketing standards based on severity of Tiers and SLA.

Technologies, languages, tools and environment: RAC, Data Guard, RAC , RAC1, Oracle 12c/11g, OLTP, Data warehouse, WebLogic, WebSphere, ,sql developer , Tivoli, VERITAS, Xenobridge , Control M , RMAN,

CONFIDENTIAL

System and Database Manager

  • Managed 100 enterprise-level Oracle 11g/10g database systems, achieving the goal of 99.99 availability at acceptable level of performance.
  • Participated in vital planning for infrastructure setup of the MMIS which involved geographically dispersed sites across the nation and Global Germany, India
  • Managed team of DBA's on site and off site spread across the globe. Managed DBA teams of Administration, Application , Production, Change Management, NOC, On-call support and performance optimization. Hiring , Performance evaluation and Goal setting of DBAs to meet the project demands on daily/weekly/Annual basis. Defined cost saving Shared Services and Outsourcing programs. Involved in Technical solutions for Proposals for future business development.
  • Implemented Ticketing standards based on severity of Tiers and SLA.
  • Defined the Cost Saving structured Shared-Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests.
  • Involved aggressively in technical solutions in bidding proposal for future business development.
  • Managed and administrated database and database applications 24x7 that include Oracle 10g/11g/9i Databases, Siebel and Cognos application databases, Micro focus Cobol , RAC real application cluster clustering server, OEM Grid , High Availability, Data Guard , Web service applications WebSphere and WebLogic and IBM Rational products.
  • Designed and managed the MMIS database system for processing claims from the base HIPAA-defined electronic papers to process the Pharmaceutical claims and the Drug rebate program.
  • Implemented ITIL model of ticketing system to track the support service for the application, adhoc requirement and 24/7 support.
  • Defined Policy/Standards and process for the database changes migration model flow drafted for the production.
  • Implemented Oracle RAC Replication from scratch for clustering the database server to support the increased number of daily claim transaction volumes and high availability of the database system by enabling Load balance and Instance failover features
  • Managed the MMIS OLTP Database system to support 200 users 24x7, handling database-related issues and also supporting the MMIS applications
  • Implemented Oracle Data Guard physical and logical for MMIS Database systems in maximum availability and maximum performance mode primary and standby sites were setup in different coasts for disaster recovery solution
  • Upgrading of Oracle RDBMS and Cluster CRS cluster resource services home with the oracle recommended patches and security alert patches
  • Administered the business intelligence and analytical application Seibel 7.0 Oracle database for customer relationship management CRM work flow process and the contact center interactive voice response CCIVR
  • Managed the data warehouse database 10Tb and the Cognos database to support report generation for 40 users and implemented FACT and Dimension Framework
  • Managed the configuration management Oracle database for IBM Rational products, including ClearQuest and ClearCase for Version Control and Defects Ticketing system
  • Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems.
  • Implemented RMAN and Flashback technology FRA for Backup and Recovery solutions. Used RMAN for Hot//Cold /Logical backups and Database Recovery including Point in time recovery. Backup to tapes using OBS Oracle backup solution recommended VERITAS and Tivoli. Implemented Quest LiteSpeed for compression of data backups.
  • Served as the architect for the physical design and modeling of the MMIS product using Erwin 7.0.
  • Configured Oracle Enterprise Manager Grid control for monitoring to manage and automate the alerts based on thresholds.
  • Performed performance tuning of the database for the accepted level using Broad brush approach tuning of Design, Operating system, Database, Instance, Disk I/O and Application . Implemented database performance monitoring tools
  • Implementation of Oracle Partitions Range and List for very large objects storage and performance enhancements. Partitioned claims-associated and managed care subsystems objects based on the adjudication purpose. Implemented purging partition archival mechanism for claims history
  • Responsible for securing database based on the acceptance levels of HIPAA standards implemented role-based security and audits implemented the Obfuscation and DES3 utility for encryption and decryption of secured PHI columns implemented RLS and FGAC at low level for data security implemented Net8 Oracle Advance Security option single sign on net services
  • Benchmarked and configured Websphere and Weblogic connection pooling mapping to Oracle Database parallel access for increase in claim adjudication throughput used Mercury tool for collecting statistics for the operating system, database, Websphere, and Weblogic
  • Managed MMIS database systems in multi operating system platforms, including Unix Solaris 5.10, AIX 6.1 and Windows platforms
  • Implemented Sun control point system ticketing system for change management and incident management for production database system
  • Managed the full database deployment life cycle including development, testing including UAT , and pre and post-production environments including the legacy and conversion and interface environments according to quality standards
  • Used state-of-art technology and tools for performance tuning and enhancement of the database

Technologies, languages, tools and environment: RAC, Rac1, Data Guard, Seibel, OEM, Micro focus Cobol, Grid ,Cognos, , Rational Rose , Quest spotlite, ClearCase and ClearQuest, RDBMS, Oracle 11g/10g/8i/9i, Erwin, data warehousing, OLTP, WebLogic, WebSphere, , Toad, Sun control point, Tivoli, VERITAS, LiteSpeed, SAN, OCFS, UDP

CONFIDENTIAL

Database Consultant Manager

  • Managed 30 enterprise-level Oracle 11g/10g database systems, achieving the goal of 99.99 availability at acceptable level of performance
  • Implemented High availability RAC systems for Loans and Security subsystems.
  • Participated in vital planning for infrastructure setup of the Financial Data Warehouse setup which involved geographically dispersed sites across the nation
  • Involved in developing Metadata Compare Application for Database multiple schemas across environment and E/R Studio models
  • Setup Database system for the tool Kalido and ETL Abinitio for the Project CAPRI Cost Allocation Profitability and Return Investment .
  • Upgraded Oracle RDBMS and Cluster CRS cluster resource services from version 10.2.0.4 to 10.2.0.5.
  • Configured Oracle Enterprise Manager Grid control for monitoring to manage and automate the alerts based on thresholds. Utilized Autosys for automate tasks.
  • Involved in database design for a huge data mart Account and Financials DW built for consolidating accounts in Fannie Mae and participated in future state architecture discussions/implementations.
  • Involved in planning discussion for Exadata setup for EBS Event Bus Service DW that used TIBCO software application.
  • Utilized Remedy ticketing system and Rational products Clearcase and clearquest for tracking data changes.
  • Implemented 11g feature Flashback Data archive on History archive tables.

Technologies, languages, tools and environment: RAC, OEM, Grid ,Rational Rose , ClearCase and ClearQuest, RDBMS, Oracle 11g/10g Erwin, data warehousing DW, OLTP, ETL Abnitio, Toad, Embarcadero DB Artisan, Remedy, Exadata, Autosys .

CONFIDENTIAL

Database Manager

  • Managed 120 enterprise-level Oracle 11g/10g/9i database systems, achieving the goal of 99.99 availability at acceptable level of performance.
  • Managed team of on-site DBAs and off-site DBAs across global locations.
  • Managed and administrated database and database applications 24x7 that include Oracle 10g/11g/9i Databases, Siebel and Cognos application databases, Deltek , e-business integration suite, RAC real application cluster clustering server, OEM Grid , High Availability, Data Guard , ETL Ascential , Web service applications WebSphere and WebLogic , IBM Rational products, and SeeBeyond
  • Designed and managed the MMIS database system for processing claims from the base HIPAA-defined electronic papers to process the claims till the payment generation to the provider which includes sub system for members, reference, prior authorization PA , third party liability TPL , provider, RA Managed care and common components subsystems
  • Implemented Oracle RAC Replication Load balancing for performance bench marking for scalability of processing n claims in the Sun Lab in California. Mercury tool was utilized for system level monitoring.
  • Managed the MMIS OLTP Database system to support 400 users 24x7, handling database-related issues and also supporting the MMIS applications.
  • Implemented Oracle Data Guard physical and logical for MMIS Database systems in maximum availability and maximum performance mode primary and standby sites were setup in different coasts for disaster recovery solution.
  • Administered and engineered the upgrade of Deltek products Costpoint and Timesheet and Sage FLS payroll supporting Oracle DB
  • Administered the business intelligence and analytical application Seibel 7.0 Oracle database for customer relationship management CRM work flow process and the contact center interactive voice response CCIVR
  • Managed the data warehouse database 20Tb and the Cognos database to support report generation for 20 users and implemented FACT and Dimension Framework
  • Managed the configuration management Oracle database for IBM Rational products, including ClearQuest and ClearCase for Version Control and Defects Ticketing system
  • Implemented RMAN and Flashback technology FRA for Backup and Recovery solutions. Used RMAN for Hot//Cold /Logical backups and Database Recovery including Point in time recovery. Backup to tapes using OBS Oracle backup solution recommended VERITAS and Tivoli. Implemented Quest LiteSpeed for compression of data backups
  • Implemented the Oracle Geospatial System Multi dimensional ESRI application ArcIMS and Geospatial ArcSDE Oracle DB
  • Managed the extraction, transformation, and load ETL process from the legacy to the Oracle databases for conversion and interface environments using Ascential and Informatica ETL tools and formulated the methodology for storing data.
  • Configured Oracle Enterprise Manager Grid control for monitoring to manage and automate the alerts based on thresholds. Utilized OEM components Diagnostics Pack, Tuning Packs, and Change Management Pack for analyzing the database activities and improving the performance
  • Performed performance tuning of the database for the accepted level using Broad brush approach tuning of Design, Operating system, Database, Instance, Disk I/O and Application . Implemented database performance monitoring tools
  • Implementation of Oracle Partitions Range and List for very large objects storage and performance enhancements. Partitioned claims-associated and managed care subsystems objects based on the adjudication purpose. Implemented purging partition archival mechanism for claims history
  • Responsible for securing database based on the acceptance levels of HIPAA standards implemented role-based security and audits implemented the Obfuscation and DES3 utility for encryption and decryption of secured PHI columns implemented RLS and FGAC at low level for data security implemented Net8 Oracle Advance Security option single sign on net services
  • Benchmarked and configured Websphere and Weblogic connection pooling mapping to Oracle Database parallel access for increase in claim adjudication throughput used Mercury for collecting statistics for the operating system, database, Websphere, and Weblogic
  • Implemented Oracle Golden Gate direct load for replication of data from the legacy oracle database system in Red hat Linux to oracle database system in AIX.
  • Managed MMIS database systems in multi operating system platforms, including Unix Solaris 5.10, AIX 6.1 and Windows platforms
  • Administered and configured the Oracle e-business suite balance score card.
  • Implemented Sun control point system ticketing system for change management and incident management for production database system
  • Managed the full database deployment life cycle including development, testing including UAT , and pre and post-production environments including the legacy and conversion and interface environments according to quality standards
  • Used state-of-art technology and tools for performance tuning and enhancement of the database
  • Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery , Service of Excellence and People for Managing and Maintaining Database systems.
  • Defined the Cost Saving structured Shared-Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests.

Technologies, languages, tools and environment: RAC, Data Guard, Seibel, OEM, Grid ,Cognos, Deltek Balance score card, Geospatial, ArcIMS, ArcSDE, Rational Rose , ClearCase and ClearQuest, RDBMS, Oracle 11g/10g/8i/9i, Erwin, data warehousing, OLTP, ETL Ascential, WebLogic, WebSphere, Sage FLS, Toad, Sun control point, Tivoli, VERITAS, LiteSpeed, SAN, OCFS, UDP

CONFIDENTIAL

Database Administrator Lead

  • Managed the replication global Oracle databases across North America, Asia, Europe, and South America
  • Administered 44 enterprise-level Oracle 10g/9i Database Systems, achieving goal of 99.99 availability at acceptable level of performance
  • Managed technical team of DBA's on site and off site spread across the globe. Managed DBA teams of Administration, Application , Production, Change Management, NOC, On-call support and performance optimization. Hiring , Performance evaluation and Goal setting of DBAs to meet the project demands on daily/weekly/Annual basis. Defined cost saving Shared Services and Outsourcing programs. Involved in Technical solutions for Proposals for future business development.
  • Managed and administered the database and database applications 24x7 including Oracle 10g/11g/9i databases Siebel and Cognos application databases e-business integration suite, RAC clustering server OEM Grid High Availability, Data Guard, and Ascential ETL, Web service applications WebSphere and Oracle iAS , and VSS
  • Implemented Oracle RAC real application cluster from scratch for clustering the database server to replicate the military personnel health information data in the distributed environment
  • Implemented High Availability of data using Data Guard in physical mode for synchronizing data between all the Air Force bases used maximum performance and maximum availability mode Used Data Guard broker for Data Guard Maintainace
  • Served as the architect for the physical design and model of the Inter-Clinical database ICDB , COHORT Composite Occupational Health and Operational Risk Tracking System , and Naval Research Laboratory NRL using Erwin, JAD, and Rational Rose
  • Implemented Oracle Geospatial System Multi dimensional ESRI application ArcIMS and Geospatial ArcSDE Oracle DB
  • Administered Oracle Database for the Business Intelligence and Analytical Application Seibel for Customer relationship management for work flow process
  • Managed and supported the e-business application product NRL Agent that collects data from all military sites across the globe and stores the data in the centralized database 6 terabytes administered the central database 24x7 formulated methodology for storing the data and executed extraction, transfer, and load ETL from Oracle API using Informatica and Ascential ETL tools
  • Migrated the data conversion legacy servers SQL server, Sybase, DB2, flat files, Oracle 8i/9i into Oracle 9i/10g environment implemented the Ascential and Informatica extraction, transformation, and load ETL tools for data mapping into the database customized and administered the Ascential repository managed OLTP and DSS warehouse 6TB of data
  • Upgraded the Oracle RDBMS and Cluster CRS home with the Oracle-recommended patches and security alert patches
  • Responsible for securing database based on the acceptance levels of HIPAA,FIPS, PHI and DITSCAP implemented role-based security and Audits implemented the Hash5, Obfuscation, and DES3 utility for encryption and decryption of secured columns implemented RLS and VPD at low level for data security
  • Administered and configured the Oracle E-business suite Balance Score Card used by senior management to make financial budget decisions
  • Administered and configured the web application servers Weblogic and WebSphere
  • Administered full phase cycle of the database, including from development through testing including UAT to production environments deployed and tested application in a complete database cycle before deployed in production
  • Configured Oracle Enterprise Manager Grid control for monitoring, managing, scheduling jobs, and automating the alerts based on thresholds utilized OEM components Diagnostics Pack, Tuning Packs, and Change Management Pack for analyzing the database activities and improving performance
  • Implemented RMAN and Flashback technology FRA for Backup and Recovery solutions. Used RMAN for Hot//Cold /Logical backups and Database Recovery including Point in time recovery and crash recovery. Backup to tapes using OBS Oracle backup solution recommended Veritas and EMC. Implemented RMAN, Perl script and cronjob for backup automation in lower end environments.
  • Implementation of Oracle Partitions Range, Hash, and List for very large objects storage and performance enhancements. Implemented Purging partition archival mechanism for history data.
  • Managed Oracle database for Cognos and Seagate Crystal Reports for report generation in the data warehouse environments
  • Performance tuning of the Database for the Accepted level using Broad brush approach tuning of Design, Operating system, Database, Instance, Disk I/O and Application implemented database performance monitoring tools.
  • Used the Toad Batch Optimizer and SQL Tuning Lab to tune batch jobs used Quest spotlight to monitor the health of the database
  • Managed Heather Care ICDB database systems in multi operating system platforms Linux, Unix Solaris, AIX , and Windows platforms

Technologies, languages, tools and environment: E-business Suite, Geospatial, Balance score card, ArcIMS, ArcSDE, Rational Rose, Informatica, RDBMS, Oracle, Data Guard, Oracle 10g/8i/9i, Perl, Data warehousing , data modeling Erwin tool , ETL, OLTP and OLAP, SQL,TSQL,SQL server, HIPAA, Ascential, WebLogic, Seibel, WebSphere, Crystal Reports, DB2, cluster, RAC, Erwin, Putty, Linux

CONFIDENTIAL

Senior Database Administrator,

  • Performed lab testing for Voice over Internet Protocol VoIP in Cisco beds in Oracle environment for the Planning Division
  • Administered eighteen enterprise-level Oracle database systems, achieving goal of 99.99 availability at acceptable level of performance
  • Developed physical design of global UUNet Backbone network architecture based on hubs, routers, switches, circuits and customers mapped into the data warehouse
  • Supported oracle Database for ForeView and OpenView for network traffic monitoring, where the data was collected based on 95th percentile
  • Managed and administered database and database application servers including Oracle database, application, and financials servers WebSphere legacy data conversion E-business integration suite and HRMS server, RAC Replication clustering server, Seibel Application server, OEM Grid server, High Availability Data Guard Server, and Web service servers
  • Managed and customized Oracle Financials applications, including general ledger GL , accounts payable AP , accounts receivable AR , fixed assets FA ,and cash management CA to meet business requirement needs
  • Migrated of data conversion legacy servers SQL server, Sybase, DB2, oracle earlier version into Oracle later version environment
  • Configured Oracle Enterprise Manager for monitoring, managing, scheduling jobs and automating the alerts based on thresholds, utilized OEM components for maintaining the database activities and improving performance
  • Administered and configured the web application servers Oracle iAS, Tomcat, and JBoss
  • Implemented RMAN for Backup and Recovery solutions. Used RMAN for Hot//Cold /Logical backups and Database Recovery including Point in time recovery and crash recovery. Backup to tapes using OBS Oracle backup solution recommended VERITAS and SAN and implemented RMAN, Perl script and cronjob for backup automation of Databases.
  • Managed the complete software development lifecycle cycle SDLC phases for the database from development through testing to implementation and production
  • Executed performance tuning of the database for the accepted level using Broad brush approach tuning of design, operating system, database, instance, Disk I/O and Application used Explain plan, Trace, and Tkprof for SQL application tuning
  • Implemented control version system CVS VSS for storing java applications and used Samba to store data in Linux server
  • Maintained automated alert notification program for alerts based on defined thresholds for the network operation center NOC group
  • Performed capacity planning analysis on data traffic flow on network based on the setup of Back bone architecture
  • Responsible for securing database implemented role-based security and audits implemented the Hash5, Obfuscation encryption and decryption of secured columns and implemented views at low level for data security
  • Managed oracle database for Microstrategy 7.0 and Cognos to generate reports to plan critical business information
  • Designed and published the Sales Analysis Report growth trend, sales forecast Network Utilization Report global BB of UUnet from the data loaded to the Oracle Data warehouse using Informatica ETL and designed and published weekly report of UUNET backbone using multiple SQL queries
  • Administered Oracle databases using Solaris, Linux, and AIX operating system environment
  • Supported users and developers developed queries and optimized their stored procedures

Technologies, languages, tools, and environment:

Cisco, VoIP, GL,AP, Data Guard, stream, Oracle 8i/9i, C, C , Perl, XML, developer 2000 data warehousing , data modeling, OLTP,ETL and OLAP, SQL,TSQL,SQL server, , Oracle Designer, Cognos, iAS, WebLogic, Visual SourceSafe, WebSphere, DSS, Crystal Reports, DB2,Putty, COBOL, XML, PL/SQL, Unix, Windows

CONFIDENTIAL

Oracle Database Administrator/Developer

  • Supported the health care information database system for hospital environment
  • Developed and administered database system used in billing, inventory control, order processing, and cloning and vendor billing for retail chain stores, including replication of database to remote sites
  • Performed evaluation and qualification of Voice over Internet Protocol VoIP in Cisco beds for the Employee Information Online Project
  • Technologies, languages, tools, and environment used and included in above projects:
  • Developer 2000, RDBMS, Oracle 8/7i, C , Perl, XML, data warehousing and data modeling ,SQL,TSQL,SQL, WebLogic r, Visual Basic, Visual SourceSafe, WebSphere, MS Access, DB2, Putty, COBOL, OOPS, XML, PL/SQL

We'd love your feedback!