SUMMARY

Over 16 years of experience as an Oracle consultant supporting production, development and Hybrid Database (Oracle RAC/HA - Data guard) and Middleware /Security Technologies including (OID, OIM, J2EE, Web Cache, HTTP Server, WebLogic server, SOA suite BPEL),NETEEZA, release management, Identify Management expertise with cross platform integration, Advanced Identity solutions for enterprises with application and organizational hierarchies needs. Specialized in enterprise database performance with application level query optimization, advanced query support, Object storage optimizations for mission critical applications with large databases, including Operational data stores. Worked as SOA Lead Consultant. Worked on SOA Governance. Web Services Technologies like XML, SOAP, WSDL, UDDI, RESTful and BPEL. Expert in Scrum and Agile methodologies. Familiar with latest cutting edge tools like Docker, Puppet, Chef.Ext JS, Rails, jQuery, AngularJS, Clojure, .js, JIRA, Magento, Drupal, POJO, XAML, DOJO, Django, Ruby, GitHub, Grunt, GIT, AWS, Puppet, Cassandra. Hadoop, Big Data, Open stack, AWS, cloud & virtualization. Architecting, designing, and implementing enterprise-scale, high volume, and high availability systems. Worked with DevOps Environments Engineers. High Availability and Disaster Recovery planning and exercising. Established and documenting standards, guidelines, and best practices. Expert In modeling techniques (e.g., BPM, UML, ER). Worked with Enterprise Architecture frameworks, such as TOGAF, Zachman and Rational Unified Process

TECHNICAL SKILLS

Database Support: DBA Admin, Database Architecture-design, Data Modeling, Logical-Physical model design, RAC, Data-guard, Oracle Streams High Availability Solutions, ASM-OCFS-RAW storage environments, PL/SQL programming,For automation and enterprise solutions. OLTP and data warehouse

Middle Tier: Install, Configure Application server, Cluster/HA, Performance and Diag J2EE, OID, OIM and JAZN, SOA (BPEL, ESB), ODSEE 11.1.1.5.0

Migration: Sybase, DB2, Informix, MySQL, Access to Oracle.

System Support: Red Hat Linux OS support for ASM, kernel support, Sun OS, True 64,Windows

Data warehouse: DataMart, Data Model Consolidations, Business process support

Programming: PL/SQL, UNIX Shell scripting, SQL scripts, Dynamic SQL, PHP, C++, Perl

Program Space: Business Data consolidation, ad-hoc process, release management, bulk Data load, data patches, Business Process

11i ERP /CRM: AP, AR, GL, projects, CRM, Dev2000, forms61, reports 6i, PL/SQL

Data Modeling: Data modeling for existing Consolidation and single book of record for Corporate data, new data model For Business process, Business functional Model, version based document.

Application support: Jdeveloper, Java, XML, Perl, PHP, HTML

Storage Tools: NetApp, NetBackup, EMC, San, VERITAS, Sun storage, Netezza,Erwin, Rational rose, Oracle Migration workbench, OMWBAnalyzer,Oracle Jdeveloper Application Migration assistant.OEM, Grid, Dictionary,Consolidation between QA and test environments.

Software Engineering: Water Fall Models, Agile Modeling, Software analysis, requirementSpecs design, Flow diagram for existing codes in all languages, SoftwareTesting and RDBMS code and structure analysis.

Release Management: Critical periodic Data patches, Code patches with enterprise applicationIncluding databases were supported with custom code and tools.

Network programming: C, C++ socket programming, interface with any ANSI and POSIX standard Systems.

App server/OID Sun java/SOA: J2EE, Glassfish App Server, SOA, Net Beans, JDBC, EIS systems support,BEA WebLogic, WebSphere, XML, ODAC for .Net, OID, JAZN NeteZZAAnalysis and permissions, monitoring. Installation

Project Practices : MOF, ITIL

Hardware : Sun Systems, HP, Dec Alpha 1000A, Dec Alpha 3000, HP LD PRO, Glenayre 3000, Definity Lucent, CISCO Switch,

Operating System :    Sun Solaris, Red Hat Linux, Dec UNIX 4.0b, 4.0d, Dec OSF, SCO - UNIX 3.2, Windows NT, AIX, HP UNIX.

Applications :      Oracle Financials 11i / 10.7.

RDBMS :        Oracle 10gRAC/9i / 8i / 8.x / 7.x / 6.x, Sybase 10.x 11.0, 11.5, 11.9, 12.0, 12.5, MySQL.

Database Tools :   9i, RAC 10g, 11g, Data guard, RMAN, Developer 2000 (Forms 6i/ 6.0 / 5.0 / 4.5, Reports 6i / 6.0 / 3.0 / 2.5, Graphics 2.5), Power Center 8.1, 8.6,(Informatica) ETL, PL/SQL, SQL * Plus, SQL Navigator, Data-guard,Power soft Architect, Erwin.

Languages : PL/SQL, Assembly TASM, C / C++, VC++,

Version control : Clear Case.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Oracle Security Architect

Responsibilities:

• Create deployment strategies and diagnostics for web services.
• Plan and design enterprise diagnostic procedures for development team analysis and application integration lifecycles.
• LDAP repository management and WLS scripts, shell scripts for automation and management.
• Develop test cycles for application integration and data integrations.
• Build and test message infrastructure using required adapters. Web traffic analysis and diagnostics.
• Application on boarding, provisioning life cycles, batch jobs.
• Set-up initial Oracle SOA environment for the team to develop the interfaces.
• Design and architect SOA and EDA based integration solutions between different applications.
• Analyze, design, capacity plan, develop interfaces and implement new Integration platform using Oracle.
• SOA Suite Integration software between Enterprise Applications & its internal-external Agencies and others.
• Maintain and migrate existing See Beyond eGate interfaces to Oracle SOA Suite Integration tool.
• Develop interfaces between PeopleSoft and Oracle E-Business R12 Suite (EBS) using oracle SOA.
• Fusion middleware - OSB, SOA, B2B, MFT, ODI, Adapters, for real time, a/synchronous, batch, soap/rest interfaces.
• Design/develop interfaces using different design patters for SOA Composite, BPEL, Mediator, OSB, XSLT, and XPath - Requisition, Purchase Order, Invoices, Master data and others.
• SOA composite deployment using em and support.
• Test plans, documents and Visio diagrams for data work flow, integration work flows.
• Working with Network, system admins and development teams to coordinate on performance optimizations of services, enterprise java applications, and security access layers.
• Service cloud console configuration, messaging, right now web, social contact center
• Service cloud policy automation.
• OIM ps2 ps3 upgrade.

Environment: Linux, Oracle 11gr2, SOA, ESB, OIM, OAM, OID, OUD, WebLogic, Web center, PeopleSoft, ADFS, Oracle SAML federation, Web gate, Oracle Cloud, OAuth, Mobile SSO and SASVA, Service cloud.

Confidential

Oracle EUS Architect / OIM Security / Oracle DBA

Responsibilities:

• Study and create requirements from current enterprise platform user access profile.
• Create DB, configure HA, RAC databases.
• Performance tuning, diagnostics, AWR, ADDM reports.
• Design, develop Single sign on solutions using OUD proxy with PTA
• Federated solutions review.
• Test and release user proxy roles.
• DR architecture and development with site wide High availability solutions.
• Study current identify management within the enterprise and create the roadmap for SSO.
• Develop Identity Governance for the enterprise with seamless administration workflows.

Environment: Linux, Oracle 11gr2, OIM, EUS, OUD, WebLogic.

Confidential

Oracle SOA Mid-tier Admin /Enterprise Security Architect /Oracle DBA Oshkosh, WI

Responsibilities:

• Handled SOA services deployment planning/rollout cycles for Oshkosh Defense. Integration with various divisions with Manufacturing services, Product, stocks etc.
• Design and planning infrastructure layer for Enterprise SOA service including operation and integration technology. Enterprise Identity Lifecycle design and Management.  
• Supported Java developers and SOA developers to integrate the Data logic and performance.
• Handle WebLogic admin duties, setup, configuration and adding and managing services, performance tuning with watches and notifications for preemptive management. Thread lock mitigation.
• Mid-Tier Assets WebLogic server Management and Maintenance
• WebLogic Monitoring and performance tuning
• OAM security policy for web pages.
• Modifying/Creating Oracle SOA BPEL process, updating existing orchestration process.
• Creating/configuring adapters, WSDL, EBS profiles, OTM agents.
• Creating Technical integration document between EBS and OTM.
• Plan, setup databases, RAC, performance tuning.
• Test fail overs of mid-tier apps on RAC databases.
• Single sign on architecture and design.
• Architect enterprise security for user access and resource access topology
• OIM configuration for security policy and policy automation.
• Watches and notification setup for preemptive monitoring.
• Handle middle tier configuration and patches.
• Data Migration, Data archiving solution development

Environment: Red hat Linux 6.3, Oracle 11gR2, OAM, SSO, OIM, OID, SOA, Informatica, Business Objects, Oracle designer, Fusion Middleware WebLogic.

Confidential

Oracle OIM/OAM/OUD Architect/Oracle DBA Santa Clara, CA

Responsibilities:

• Architect, Design and Implementation of Native SSO and SAML based cross Domain SSO solutions. Impersonations, Salesforce (SAML based) SSO capability for 21 applications for Hitachi partners, customers, Employees. Impersonation, SAML based custom authentication using OUD and Sun LDAP Provisioning; SUN LDAP migration to OUD.
• Create Auth policy, Scheme, SSO agents, User stores
• Web gate 11g configuration, OHS  configuration with F5 Load balancer
• Cluster solutions design at WebLogic
• Setup test, QA databases on RAC cluster.
• Diagnostics of Databases, SQL query optimizations and plan migrations.
• Cluster and replication of OUD
• Diagnostics of access, errors, end to end User access through OAM.
• Creating BPEL process in Oracle BPEL for EBS integration.
• Developing an HTTP and AQ interfaces with OTM.
• Configuring Oracle BPEL processes, domain, containers
• Oracle SOA Installation and patch management
• Performance enhancement and system tuning to handle loads from Multiple Carriers.
• Writing design and implementation documentation for the various interfaces.
• Developing error handling framework and error notification.
• Build test scenarios and coordinate with applications owners to ties the apps with OAM
• Create resource list tie up with Auth policy, authorization policy.
• Create OUD memory configuration for performance.
• User provisioning life cycle management and data Loads from Sun to OUD.
• Enterprise Disaster Planning and testing for failover between 2 datacenters.

Environment: Red Hat Linux, Oracle 11gr2 OAM, OUD, OIM, JBOSS, Fusion Middleware. Web gate 11g, Salesforce, SUN IAM migration to OUD, Disaster recovery

Confidential

Oracle SOA/Oracle DBA/DA- Architect consultant

Responsibilities:

• Planned, designed the Data model.
• Created API for services using PL/SQL
• Created Delta scripts from Data model using Oracle designer. .
• Created reports and DW solutions including Models. .
• Oracle RAC cluster and data-guard with RMAN configurations.
• Presented solution framework from Business requirements and translate that to Technical solutions.
• Oracle data partitioning for performance.
• Designed reporting target and data acquisition flows physical and logical standby design.
• Oracle streams for data replication.
• Installed and configure oracle databases, WebLogic 10.3.6
• Handled middle tier configuration and patches.
• OID/OUD/OIM setup with OAM access policies.
• WebLogic admin and preemptive monitoring
• Data Migration, Data archiving solution development
• HIPPA compliance, Drug, pharmacy ref data creation using National Drug repository
• Worked with Relay health repository for data extraction and transformation
• DW solutions with ETL design using Informatica, SAP BO.

Environment: Red hat Linux 6.3, Oracle 11gR2, OIM, OID, SOA, Informatica, Business Objects, Oracle designer.

Confidential

Oracle DBA/SOA Suite/IAM Middle tier security architect consultant Tallahassee FL

Environment: Red hat Linux 6.3, Oracle 11gR2, OIM, OID, SOA, EBS, OBPM, Web gate, access gate, Neteeza

Responsibilities:

• Plan, design, install Oracle database, EM, OIM, OID, OAM, and OVD.
• Deploy plugin, adaptors, provisioning through web services( SOA Composite)
• Optimize Linux configuration for accommodating Oracle server
• Performance optimizations using query, i/o trace
• Disaster recovery plan and design,
• ODSEE suffixes, access control configuration, directory service replications.
• Install and configure ODSEE for replication.
• EBS-OIM deployment and security framework design.
• Targeted restores and recovery of tablespace and tables for developers.
• Helping developers in query optimizations, Java code optimizations.
• Install, deploy SOA suite, OIM, Access Manager Configuration, OVD, SSO.
• Build enterprise data archive solution to trim the large tables and indexes.
• Plan to accommodate Tablespace growth.
• RMAN, Data pump for data migration and backups.
• Advanced Lock, latch management using OS level trace dumps and PL/SQL
• Memory leak issues identification using PL/SQL probes.
• RAC clusters, Data guard, advanced HA solutions.

Confidential

Oracle Middle Tier Consultant /Architect Tallahassee, FL

Responsibilities:

• Install Oracle 10G, 11G, WebLogic Fusion 11g, OID, configure the mapping for AD sync
• Plan and design disaster recovery.
• Plan and design User credential aligned with the directory structure within OID.
• Generate UNIX shell script for automating Jobs.
• Automated backup of the OID.
• ODSEE V6.3.1.1.1 installation, custom plugin in C, C++ password policy setup.
• Configure web perimeter services using OAM including auditing, config sec store
• Oracle Identity Navigator deployment for centralized administration of al enterprise Identities
• ODSEE installation, configuration, backups.
• OIN migration from test to Prod, Role Based access.
• OIN dashboard News and Announcements setup.
• OIM (OPAM) for enterprise account management.
• Microsoft AD and OID synchronization
• WebLogic Start and stop automation scripts
• Fusion compensation implementation users, batch data loads, profiles.
• Oracle performance optimization and monitoring scripts.
• Patch and SSL certificate management
• Alerts and scheduled Lights off Management

Environment: Oracle 10g, ODSEE V6.3.1.1.1, SOA, OBPM, 11g, Oracle WebLogic 10.3.6, Red hat Linux 5, PL/SQL, Perl, J2ee, and Neteeza.

Confidential

Oracle consultant / architect Cupertino, CA

Responsibilities:

• Install Oracle 10g AS OID, OIM, and OAM SOA suite, BPEL, ESB and Configure OIM.
• Advanced virtualization implementation using Oracle Virtual box.
• Application failover enabling thru oracle database features.
• Design codes for procedure and package and triggers.
• OIM (OPAM), OAM for security and access audits.
• ODSEE V6.3.1.1.1 upgrade and migration, password policy, access control management
• ETL design roadmaps, extraction codes written with shell, SQL scripts.
• Auto scripts to extract and load to target database using transformation libraries.
• OID, OIM Installation with role based access and identity audit.
• Integration with MS active directory, LDAP based services.
• Request, policy based user provisioning.
• SSL certificate configuration using OIM ( wallets)
• Compensation implementation for user profiles, currencies, approval Management.
• Support, monitor, and deploy j2ee application modules on web logic.
• OPS, CSF for compliance management, crafting Compliance workflows.
• Enterprise Database Management with performance, disaster recovery, storage planning,
• Create java connection pool for oracle instance.
• Oracle Grid and fusion Middleware deployment.
• Install, configure OIM, user provisioning, Single sign on
• Authorization and authentication for management and application
• Identity audit and compliance.
• Release Management for applications and role based access.

Environment: Oracle 10g, 11g, ODSEE V6.3.1.1.1, SOA, OBPM, Oracle 10gAs, Oracle Infrastructure, Informatica, PL/SQL, UNIX, Perl, j2ee, WebLogic, Neteeza

Confidential

Oracle DBA - Fusion middleware Westboro, MA

Responsibilities:

• To Support General System design and development of interfaces, SOA Module operations.
• Optimize app interfaces reusability
• Install Oracle 10g AS OID, SOA suite, BPEL, ESB and Configure OIM.
• Oracle Performance diagnostics and optimization.
• Review ESB landscapes, infrastructure for Adaptors.
• Oracle HTTP server and OC4j Containers thru SSL.
• OIM, OIN, OID installation and configuration for Role based access, security perimeters.
• Data Conversations and release management.
• ETL module management using PL/SQL.
• Extract data for Informatica Data loads.
• PL/SQL libraries built for analyzing source data before load.
• Application to Database Flow Maps, charts, Models, Upgrade database.
• Deliverables with Script consolidations, practice documents, user guides.
• Data Governance, Risk analysis and reporting standards.
• OID, OIM Installation with role based access and identity audit.
• Integration with MS active directory, LDAP based services.
• Request, policy based user provisioning.

Environment: Oracle 10g,11g Oracle 10gAs, Portal, SOA, OBPM,OIM, ESB, BPEL, PAAS environment, OID, Cloud Architecture, Oracle Infrastructure, Neteeza.

Confidential

Oracle Enterprise DBA Tallahassee, FL

Responsibilities:

• To evaluate their architecture, deployment, reporting, security and offer best Practices
• To Support and optimize app interfaces with security credentials across OID, Oc4j Domains.
• Install Oracle 10g AS OID, SOA suite, BPEL, ESB and Configure OIM
• Oracle Performance diagnostics and optimization.
• Create aliases for site access for their domains.
• Review ESB landscapes, infrastructure for Adaptors.
• JAAS security implementation. Custom security strategy for their Java based applications.
• Application based LDAP programming using JNDI by configuring OID with certificates and Key store (SSL)
• Oracle HTTP server and OC4j Containers thru SSL.
• Application to Database Flow Maps, charts, Models, Upgrade database.
• Provide security framework for J2ee applications on Oracle Stack.
• Create a DIT on OID to map application stack across agencies and department for programmers support.
• Data Governance, Risk analysis and reporting standards.
• OID, MS Active directory integration with identity audits, authorization thru JNDI API.

Environment: Oracle 10g, 11g Oracle 10gAs, Portal, SOA, OBPM,OIM, ESB, BPEL, j2ee, PAAS environment, OID, Cloud Architecture, Oracle Infrastructure.

Confidential

SENIOR ORACLE DBA Pasadena, CA

Responsibilities:

• Deploying RAC nodes Oracle 10g, Configure Voting disk, Cluster registry.
• Microsoft SQL, MySQL database, migration to oracle, Dilator recovery, performance Monitoring
• Oracle SOA, OSB, OBPM, Portal deployment and maintenance, Grid Infrastructure.
• Power center 8.6 based ETL support Informatica, NeteZZA.
• JAZN and OID I,OIM integration for authentication with PL/SQL table stored pwd with oc4j
• Oracle performance benchmarks. Optimize performance.
• Manage roles in OIM, URL aliasing for proxy links, J2ee, .Net application dev support.
• Diagnosis of RAC clusters for failures and performance, Partitions, Streams.
• OEM based user defined metric settings using PL/SQL and default metrics.
• Performance benchmarking for top SQL, top I/O, CPU etc., scheduling through OEM.

Development/data model support:

• Developed solutions using dev 2000, forms6i, reports 6i, PL/SQL
• Data validation using dynamic SQL
• J2EE development support, OID and OIM deployments with JAZN
• Supported developers with SQL coding optimization, plan trees, cost trees.
• Release support for code propagation thru environment chain dev, QA, prod
• Advanced PL/SQL code development for Business Intelligence.
• Presenting SQL variant codes for functional and technical flow.
• Shell scripts for ETL, batch jobs for data warehouse

Environment: Linux, sun, Oracle 10g,11g RAC, 10G App server,11g J2EE, VB NET, Erwin, rational Rose, MOF,ITIL,OID, SOA, BPEL, ESB, OAM, OIM, OBPM,JAZN, ASM, 3PAR storage solutions, PL/SQL, MySQL Lyris support, dev2000,Migration workbench Power center 8.6, Informatica ETL management and support.

Confidential Cherry Hill, NJ

SENIOR ORACLE DBA

Responsibilities:

• Data Modeling /development support
• New database models and logical design and physical design.
• JAZN, OID, OIM deployment and integrations and testing.
• Roles management using OIM, URL aliasing for roles based access.
• Development team support for daily data loads thru custom shell scripts, SQL scripts.
• PL/SQL code for release management support
• OIM, OAM, OAPM configuration and management, policy based authorizations.
• Dynamic SQL programming for Data Patches and release level DDL porting to QA Test.
• Reports on data model for performance, Business process and security criteria’s.
• Data Model and Process model Optimizations for Data warehouse, ODS, Data Mart.
• Normalizations and reverse normalizations for Operational Data Stores/warehouse
• Develop new forms and reports using dev 2000

Environment: AIX, DELL servers, HP UNIX, Red Hat Linux, migration workbench, Erwin, Rational Rose, Sun Solaris Oracle 10g cluster, ASM, Sybase, OIM, OAPM, OAMSOA,BPEL, MOF, ITIL, MySQL,J2EE,OID, JAZN, Oracle AS 10g APP Server. 11g, Power center 8.6, Informatica, ETL Support.

Confidential Philadelphia, PA

Senior DBA PA

Responsibilities:

• Capacity Planning, RAC installation. RMAN backup and recovery.
• Install SOA, OSB, and Portal and configure.
• Data-guard solutions for HA (High availability) solutions
• Progress report and migration estimations worksheets.
• Linux rpm packages deployment for ASMLIB
• Performance optimization and database upgrades.
• OID, OIM, web cache management. Roles Management, Security, audit policy for database users.
• OS (UNIX, Linux, windows support)

Data Modeling/development

• Normalization's and demoralizations for optimized access and storage.
• New data models and explain plan for existing data structures.
• Model conversion and mapping templates for data structures.
• Reverse DDL scripts generated for review and modifications using dynamic SQL.
• Developer 2000 forms and reports development.
• Support SOA architecture development, java, EJB, J2ee environment.

Environment: HP UNIX, Red hat Linux, SOA OSB, J2EE, OID, OIM, Web Cache, 10 App Server, rational Rose, Erwin, Migration workbench, Sun Solaris, Oracle 10g RAC, PL/SQL, Power center 8.6, ETL Informatica, MOF, ITIL, Sybase, MySQL, dev 2000

Confidential

Consultant for improving performance enhancements / Deployments and Training

Responsibilities:

• Audit database and OS environments for performance glitches.
• Optimized latch and lock contentions Partitioned large tables and indexes
• Improved file I/O for by eliminating important waits on resources.
• Data-guard solution for High availability and logical standby for reporting.
• Configure the RMAN, RAC options.
• Inter instance locking optimizations.
• Improve concurrency for RAC based databases.
• Configure san disks for higher redundancy, performance.
• Configure the RMAN for incremental and non-incremental backups, integrate with storage systems.
• Document all changes and Version control for new releases.
• Data warehouse/development support
• Star schema supports and performance, technical support for star queries.
• Optimizations on snowflake schema materialize views for analysis.
• Development support on J2ee, OID, OC4J, web cache, Http Server.
• Monitor and manage OLAP service engines.
• Defining cubes, measures and dimensions.
• User management, privileges, objects privileges.
• Tablespaces and backup procedures for OLAP based services.

Environment: Oracle 8i, 9i RAC, 10g, PL/SQL, Informatica, Erwin 2.x/4.x, J2EE, OID, Erwin, OIM, Oc4J, Web cache, Designer 2000/6i, Developer 2000 (Form 6i & Reports 6i), ODBC, Visio 5/2000, RAC 9i, 10g, RMAN, UNIX, IPX, TCP/IP.

Confidential , MD

Principal ORACLE DBA MD

Responsibilities:

• Database design, RAC Management, RMAN backup, patches, Upgrades.
• Design, test and implement PL/SQL based procedures and packages.
• Data-guard configuration for maximum security, optimized log transport and applying for better performance.
• Perform statistics evaluations and review configurations.
• I/O subsystem config, Data and Index Partitions.
• Streams, Change management, role, privileges, Auditing.
• Configure Net services, Tracing and diagnostics for performance and error detection.

Data warehouse/development/Data Modeling

• Design framework for synthesizing data organization for Data warehouse.
• Storage and index design for throughput and response.
• OLAP service management.
• Streams and advanced replications for making transactions aware data warehouse periodically.
• Normalization's and demoralizations of the data Model for warehouse solutions.
• Metadata extraction, loads, optimizations of queries for star, snowflake etc.
• Analysis goals and metadata mapping rules for advanced queries including star queries.
• Deployment strategy for Data warehouse schema objects and refreshing cycles for distributed data.

Environment: Oracle 8i, 9i RAC, J2EE, OID, OIM, 10g, PL/SQL , Erwin 2.x/4.x, Designer 2000/6i, Developer 2000 (Form 6i & Reports 6i),RAC, RMAN, Data-guard, ODBC, Visio 5/2000, UNIX, IPX, TCP/IP.

Confidential . MA

Principal ORACLE DBA MA

Responsibilities:

• Manage tablespaces and space optimizations, I/O file distributions and partitioning.
• Prepare application SQL plan stability, Schema Optimizations.
• Network configurations, silent install, and Database server upgrades.
• Application DBA activities like creating new users, responsibilities, adding new module support.
• Creating free list groups as well as automated segment management option for Tablespaces performance.
• Stream solution for advanced data security
• Apply patches and consolidate versioning hierarchy.
• Project management
• Prepared write-ups for RFP/RFQ with federal and state projects.
• Technical write-ups for the RFP.

Data warehouse/data Modeling/development

• Design Data warehouse schemas and storage structures.
• Data warehouse custom application, forms, report creation guidelines
• Document all resource needs.
• OLAP service optimizations. Installations and configuration of OLAP service, java API support for developers.
• Cubes and dimensions with star query support.
• Advanced queries and star queries for Data warehouse analytical solutions.
• Decision support modules design and Implementation.
• Application support for data migration and data validation for use in DataMart solutions.

Environment: Oracle 8i, 9i,10g, PL/SQL , Erwin 2.x/4.x, Erwin, Designer 2000/6i, Developer 2000 (Form 6i & Reports 6i), ODBC, Visio 5/2000, UNIX, IPX, TCP/IP.

Confidential, FL

Principal ORACLE DBA

Responsibilities:

• Administer database instances and monitor sessions and gather statistics for performance benchmarks.
• I/O balance and memory resource usage optimizations.
• Manage disaster recovery and ad hoc rollback for code and data.
• Create automated services and auditing procedures for running application tasks.
• Table index management, de-fragmentations using export and imports.
• Apply patches for the databases. Performance and troubleshooting management
• Schema level mirroring and distribution using materialized indexes.
• Metadata support, Log file, control file, data file maintenance and transportations.
• Support development activities for web based data transfer and transformation.

Data warehouse/ Data Modeling/development

• DESIGN schemas and queries for large updates, analysis.
• Scripts for analysis on analytic functions associated with data warehouse structures.
• Star query, snow flake with analytical and statistical function support for applications.
• Fine-tune instances and storage, growth optimizations for Data warehouse usage.
• Create and manage data marts.
• Online updates using advanced replications and queues for enabling data warehouse
• Performance monitoring and business process metadata management for data mart solutions

Environment: Oracle 8i,9i,10g, PL/SQL , Erwin 2.x/4.x, Designer 2000/6i, Developer 2000 (Form 6i & Reports 6i), ODBC, Visio 5 / 2000, UNIX, IPX, TCP/IP.