SUMMARY:

• Over 19 years of IT experience with special emphasis on Oracle development and administration, specifically more than 13 years experience as an Oracle Professional with proficiency in Oracle 11g/10g/9i/8.x/7.x under diversified environments HP UX, LINUX, AIX and SUN SOLARIS.
• Over 7 years of successful experience designing and implementing multi - tier applications and system integration solutions as application/database architect, system integrator, project /technical lead.
• Over 7 years of IT expertise in Database Modeling and Warehouse technology. Extensive knowledge of Data Modeling / Architecture, Data Conversions, Database Administration with specialization in Oracle Data Warehouse technology.
• Experience with the STAR SCHEMA data modeling with Dimensional and Fact table design for large enterprise Data warehouses.
• Experienced in Oracle databases that use Operational Data Store (ODS) to provide high performance, sustainable levels of service for real-time business needs.
• Experienced in suppor ting a mixed workload of database transactions including high-speed inserts, On-Line Transaction Processing (OLTP) operations, and Decision Support System (DSS) queries.
• Extensive experience in creating the Logical & Physical data model using Oracle Designer and ERwin.
• Involved in designing the logical and physical model of the databases and has thorough understanding of the Oracle data dictionary.
• Extensive experience in Conceptual Data Modeling, Enterprise Data Modeling, Logical Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design, Operational Data store Design, Data mart Design, Metadata Management
• Experience in data modeling. / OLAP reporting tools. Proficient in multiple, large RDBMS Administration, Server Installation & Performance Tuning, Security Management, Backup & Recovery, Data/Code Migration & Data Integration of Oracle 10g/9i/8i/8.x/7.x.
• Involved in the development of Enterprise reporting using Oracle OBIEE business intelligence tool.
• Very good understanding of application analysis and design concepts.
• Installed and configured Oracle Weblogic Server 11g and created SOA Schemas with the Repository Creation Utility and installed Oracle SOA Suite 11g in the Weblogic Server domain
• Configured BPM, BPEL Business process layer for workflow, business rules, transformation
• Installed and configured Oracle Service Bus (OSB) 11.1.1.6.
• Configured Service layer for business logic service, data services and infrastructure services
• Configured infrastructure layer for components/libraries and frameworks
• Monitored, troubleshooted and tuned SOA suite components with respect to timeout connections and database connectivity issues
• Tuned and configured Oracle SOA suite in High availability environment in eight nodes RAC environment.
• Experience in performance tuning techniques, backup and recovery processes, database design and management, client interaction and support.
• Experience working in production (24x7), staging, development & test databases. Experience in supporting very large databases (150TB+). Experience in designing, developing and supporting ETL activities.
• Proficient in SQL and PL/SQL. Efficient in intelligent deployment of database features available in specific versions like 9i, 10g, and 11g.
• Efficient in standardizing best database practices, processes and auditing databases for security. Expert in development of Unix Shell Scripts (K, Bourne, C Shells) for database operations.
• Experience with Third Party tools TOAD, ETL Tools, Excel, Access, MS Project, Visio and Power Point.
• Experience with cloud technologies, Amazon AWS.
• Experience with NoSQL databases, Cassandra.

TECHNICAL SKILLS:

Operating Systems: UNIX (SOLARIS 2.6/2.7/2.8),LINUX, AIX, WINDOWS NT, WINDOWS (95, 98, 2000, MILLENNIUM, XP and Ultimate)

Languages: JAVA, HTML, DHTML, C/ C++, SQL, PL/SQL, VISUAL BASIC,JAVASCRIPT, SQL*PLUS, ASP, PL/SQL, COLD FUSION etc.

Development Environments: VISUAL AGE FOR JAVA, WEB SPHERE STUDIO, SUN FORT,ECLIPSE, JBOSS, VISUAL C++, VISUAL BASIC.

Relational Databases: ORACLE 7.X, ORACLE 8.X, ORACLE 9.X, 10G,MICROSOFT, SQL SERVER 2000, MICROSOFT ACCESS, IBM DB2

Data Modeling: Oracle Warehouse Builder 10G R2, Informatica, Ab Initio, DataStage, Oracle Designer, Erwin/ModelManager.

Data warehousing: ERWin, AbInitio

Platform & Architecture: Oracle Fusion Middleware (Oracle Application Server), Oracle Web Cache Oracle HTTP Server (OHS),Oracle Components For Java (OC4J),Oracle Internet Directory (OID),Oracle Single Sign On (SSO),Oracle 9i/10g Database, High Availability, Architectures, Performance Architecture, Performance Tuning

Java Technology: J2SE. J2EE, other Java development Tools (Eclipse,Jboss etc),IBM Web Sphere, BAE Weblogic.

Software Tools: DEVELOPER 2000 (Forms 4.5, Reports 2.5, Graphs 2.5),adobe Photoshop, Corel draw, Corel photo paint, photo suit, Macromedia Flash, Macromedia Freehand, Dreamweaver, Page maker, Crystal Reports, Microsoft Office, Microsoft FrontPage, Adobe Photoshop., Illustrator, Flash, photo paint, photo suit, widows applications and MS FrontPage.

Reporting Tools: Crystal Reports5, Reports6i, Cognos, OBIEE

Internet Technologies: Active Server Pages 2.0 / 3.0, IIS 4.0 / 5.0, Personal Web Server 4.0, MS Transaction Server, CDONTS, CDO for Exchange Server, HHTP, FTP, SMTP Protocols, HTML & DHTML, VB Script, Java Script, Java Servlets & JSP, Uploading & Downloading web pages & files using HTTP & FTP

Networking Knowledge: TCP/IP, Networking concepts, Subnets, Gateway, basics of Hub, Switch & Router, Networking Communication Medias, Topologies, Windows 2000 Server Administration, Distributed File System, Terminal Services, Domain Security Policy, Local Security Policy, VPN etc., and detailed hardware knowledge.

Web Technologies: VBSCRIPT, JAVASCRIPT, HTML, DHTML, XML, JAVA, ASP, COLD FUSION and PHP.

NoSQL Databases: Cassandra

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA Consultant

Confidential, Washington, DC / College Board, Reston

• Performed Database upgrade from 11.2.0.1 to 11.2.0.3 in Production, Development and Test environments.
• Configured Kerbores single sign-on authentication in Production and Development servers.
• Performance monitoring and tuning using Oracle Enterprise Manager of Production database.
• Review and document database backup and recovery using RMAN and Datapump Export/Import
• Installing CPU patches in Development and Production databases.
• Configured Oracle Dataguard Physical standby database at Texas location with Primary production database at Washington, DC.
• Review existing data model and provide recommendation to identify and eliminate redundant database columns.
• Established RMAN backup and recovery strategy for production databases.
• Contributed to the development of technical design decisions involving the database.
• Working collaboratively with Application Architects, Project Managers, and Business Owners to develop the database model and design
• Contributing to system development and deployment activities to ensure that data base systems management concerns are addressed
• Adheres to departmental and organizational standards and processes
• Provides input to strategic IT goals, objectives, tools, methodologies, and infrastructure
• Maintains accurate and up-to-date knowledge of requirements for maximizing database potential (performance)
• Working independently and proactively in a rapidly changing team environment
• Evaluates and solicits feedback on processes and procedures to identify potential areas for improvement
• Coordinates activities with technical director and other DBA’s
• Assisting the Architects and Project Managers in the development of full life cycle documentation and documents all activities
• Taking ownership of assigned responsibilities and follows through to effective solution
• Working closely with the Infrastructure, Operations, and SW Engineering staffs as needed to help troubleshoot and maintain production databases and to resolve production outages.
• Supporting reporting and java based applications using Amazon AWS and NoSQL database Cassandra

Sr. Oracle RAC DBA

Confidential, Washington, DC

• Administering two node RAC cluster database in production, development and test environment related to Oracle Warehouse builder, PeopleSoft, Cognos database applications.
• Supporting Development and Test teams with code deployments in Production environment through release management procedures
• Performing Database and Schema refresh in Development and Test environments with Production databases using Oracle Datapump exports and Imports.
• Performing Database cloning into pre-production test environments with RMAN DUPLICATE DATABASE.
• Monitoring Production Database performance through Oracle11g Grid Control.
• Implementing database enhancements, and maintain adequate quality management standards and procedures to ensure the system is maintained in a compliant state, with optimal system uptime and performance. Oracle RACCHECK configuration tool report is being used in this process.
• Developing and updating procedures for database maintenance and administration, including system changes and system management. Ensure security and integrity of the database and its data.
• Collaborate with IT team members, other groups and departments in the assessment of system changes and resolution of system related issues.
• Interface with both senior management and external personnel on significant technical matters requiring coordination between different groups.
• Participating in the design and implementation of IT projects with a significant level of complexity.

Sr. Oracle Consultant

Confidential, McLean, VA

• Administering data warehouse database in production, development and test environment.
• Maintaining existing OAS environments in development, testing and production environments.
• Supporting development teams in architecting Oracle Fusion Middleware solutions using Service Bus, BPEL, business rules Engine, Registry, repository, etc.
• Performing schema exports and imports using DATA PUMP.
• Installed and configured Oracle WebLogic 11g Servers.
• Involved in the design of Normalized Operational Data Store (ODS) schema for decision support systems.
• Involved in designing enterprise reporting development using OBIEE BI Publisher tool for generating reports from ODS schema.
• Installed and configured OBIEE 11g software including BI Publisher for reporting.
• Installed and configured Oracle SOA Suite 11g in Linux environment.
• Installed and configured Oracle Service Bus 11g(OSB) to support Oracle SOA environment.
• Installed Oracle JDeveloper11g in Development environment for developing SOA components.
• Implemented standards and templates for Technical Specifications
• Supporting quarterly ETL processes to ensure the data loads to Oracle Databases.
• Providing performance improvements by tuning Hierarchical queries.
• Performing database tuning and performance monitoring using AWR, ADDM reports and Oracle Enterprise Manager.
• Applying Oracle CPU patches and Performing regular backup and recovery procedures using RMAN
• Producing technical documentations on processes, operations etc.
• Debugging and trouble shooting in Oracle database internals and in PL/SQL
• Supporting Development and Test teams in the development and testing of Web applications.

Sr. Principal Oracle DBA Consultant

Confidential, Rosslyn, VA

• Build 11gR1 RAC clusters with ASM and Active Data Guard with Real Time Apply and Flashback Database at alternate Data center. The environment was AIX 5.3 and Linux.
• Build necessary indexes in ODS schema to improve performance of DSS reports.
• Established Oracle Goldengate replication from Primary site to the physical stand by location for set of ODS tables
• Performed 11gR1 RAC CRS, ASM and Database upgrades to 11gR2 Grid Infrastructure.
• Build 11gR2 Grid Infrastructure RAC clusters on Linux RHEL 5.5. .
• Provided support in maintaining highly critical database of 140+Tera Byte size.
• Performed initial load using Export/Import. Started Extract and Replicate process for reporting database.
• Provided support in setting up Test Data Generation from Production. Implemented masking sensitive data with Oracle Data Masking feature from Oracle Grid Control 11g.
• Provided support in setting up REAL APPLICATION TESTING (RAT) environment at Data Guard site
• Involved in setting up Data guard switchover activities with Primary Production database.
• Written scripts (database and UNIX shell/ Perl) for database administration, monitoring, maintenance of standby databases etc.
• Provided leadership support in database technologies for DBA team as well as client facing support.
• Lead, mentor and/or provide guidance to less experienced database administrators where applicable including guidance for troubleshooting escalated issues.
• Provided collaborative problem solving of issues with development teams.
• Hands on day-to-day maintenance of production and development databases.
• Participated in implementing Oracle 11g upgrade activities.
• Apply regular maintenance and critical patch updates in a timely manner; Proactively research potential issues that may be encountered as a result of infrastructure upgrades and share that information with the affected groups
• Resolve alerts initiated by Grid Control automated monitoring processes (backups, log files, etc)
• Install and configure Oracle 11g instances in both dedicated and consolidated environments
• Analyze Key Performance Metrics using OEM management packs
• Optimize Oracle resource utilization by tuning queries, recommending indexes, and configuring database instance parameters.
• Provide input on the selection and implementation of all database administration tools
• Maintain the integrity of data within the production environment including the execution of proper backup and restoration policies and procedures, which provide point-in-time restore capabilities.
• Perform database capacity planning and trend analysis
• Monitors Databases for optimal performance acting quickly to mitigate performance issues.
• Strong working knowledge of Solaris, AIX and Linux operating systems

Sr. Oracle DBA

Confidential, Suitland, MD

• Performed complex database administration assignments essential to the production and development of database management systems (DBMS) applications. Assignments, which are in direct support of software development and maintenance teams, include database analysis, security support, design, software use, and performance monitoring and tuning.
• Created physical models of all databases and logical models of strategic customer and product databases. Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location.
• Developed data architecture for the agency with technical recommendations for an entire IT architecture with servers to implement the Data Warehouse / KPI’s and metadata solution. Solution included a BI infrastructure to with OLAP and Business Performance Measurement using the Oracle 10g Dashboards and Scorecards.
• Worked with Data Architecture and Development teams in resolving performance related issues in the application code.
• Metadata Integration Strategy for the Enterprise Data Standards Initiative including software evaluation and information integration and management method development. Organization all existing data models, data flows and data dictionaries into a Metadata Repository.
• Provided an evaluation and Proof of Concept (built a Star Schema using Oracle Warehouse Builder 10G R1) for the Oracle Business Intelligence products.
• Provided support in the logical and physical data model design using Oracle Designer tool.
• Trained new data-modeler to work with DBA's to assure correct implementation of physical data model.
• Managed and used case tools to create and maintain ERD and Data Diagrams and Data definitions.
• Performed Architecting, designing and building distributed software services
• Created solutions to satisfy our businesses needs
• Supported the designing reusable SOA components, frameworks and libraries
• Using/Building Java-based frameworks for mission critical software solutions
• Integrated software components to ensure proper cross application interoperability
• Integrating reusable SOA components, frameworks and libraries with new and existing applications
• Interfacing with Oracle 10g through JDBC adapters
• Collaborating with other team members on evolution of developed SOA components
• Involved and supported the STAR SCHEMA development with Dimensional and Fact table modeling for the FDCA data warehouse project.
• Provided extensive support for the handheld databases (Sybase) that are being used for data sync operations with Oracle databases.
• Established, configured, installed and managed Real Application Clusters (RAC).
• Installed and configured Oracle SOA suite in Linux environment.
• Provided support in maintaining SOA related instances in the middle-tier environments including OID.
• Established, Configured and Managed Oracle Streams as a replication process between two databases for real time and non-real time report generation.
• Reviewed and ensures integrity via standardized support tools. Designed and implement an Enterprise support environment for multiple oracle servers utilizing Oracle Grid Control and Enterprise manager.
• Creating PL/SQL packages, procedures, and functions to implement business logic.
• Involved in writing shell scripts for daily database maintenance.
• Cloning production database for testing, development, QA environment using export/import, cold backup, hot backup and RMAN.
• Involved in managing distributed database environment, replicating data, standby databases using Oracle Streams.
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, using HINTS, EXPLAIN PLAN and STATSPACK etc.
• Involved in installing, configuring, managing and patching Oracle 10g / 9i / 8i on Sun Solaris, Linux.
• Involved in writing shell scripts and using OEM for daily database maintenance.
• Cloning production database for testing and development environment using export/import, cold backup and RMAN and mentoring other DBAs.

Environment: Oracle 10g / 9i / 8i, SQL, PL/SQL,Oracle Designer,ETL TOOLS Shell Script, Exceed, Sun Solaris 8, Windows 2000, TOAD, Terminal Services, Putty etc

Oracle DBA

Confidential, Herndon, VA

• Strong Oracle performance tuning and trouble-shooting skills with large database. Has experience with Oracle 10g and 9i RAC.
• Migrating schemas from production to development and test environments using Oracle Datapump.
• Participating in production support and implementation of databases, designing and tuning critical high volume Data warehouse databases, and contributing to database infrastructure enhancements.
• Performance tuning, backup and recovery processes, database design and management, client interaction and support.
• Providing DB admin support to number of databases for different departments
• Designing, developing and supporting ETL activities by using Abnitio.
• Managed and used case tools to create and maintain ERD and Data Diagrams and Data definitions.
• Managed the database change cycles to existing models and coordinate
• Managed Data modeling project from Logical design and implementation of Physical Database. Facilitated and leaded data modeling sessions.
• Worked with Business Analysts and project team to assist in the designing of business entities and rules.
• Experience in data modeling. / OLAP reporting tools.
• Providing Strong troubleshooting & problem analysis skills proven under high-pressure environments.
• Identifying and fixing performance issues related to client applications
• Developing complex PL/SQL procedures, packages and triggers to handle business logic for databases
• Developing Shell scripts to pro-actively assist in various database administration functions like alerts, execution of scripts during off hours, monitoring of archive space, etc.
• Providing on-call support to resolve production database problems and issues.
• Implementing databases according to production standards mostly in high availability environments. Providing support to solve production database problems and engineer production database changes.
• Installation of Oracle 10g,9i, 8i, and 8.x databases on Windows, SUN, HP and Linux
• Supporting test and development environments to ensure smooth transition of applications into production.
• Analyzing the SQL queries through SQL Analyzer and observing top sessions.
• Reorganization of database using export/import used this feature in OEM and as well Shell scripts.
• Creating/moving/migrating databases, restoring database from a disk corruption, configuring for distributed databases, scheduling jobs, automating the routine tasks using Shell/Sql * Plus/OEM event scheduler.
• Tuning of database performance. Finding Performance bottlenecks using StatsPack, ANALYSE, EXPLAIN PLAN, SQL TRACE and TK PROF.

Environment: Oracle 10g / 9i / 8i, SQL, PL/SQL, Abnitio, Sun Solaris 8, Red Hat Linux, Windows 2000, TOAD, DTS, RMAN, Clearcase, Clearquest, Terminal Services, Putty etc

Confidential, Suitland, MD

Sr. Oracle Database Admin/Architect

• Designed and created VLDB databases like DSF database (Delivery Sequence File) for nationwide addresses database. This DSF is one of the sources to update the MAF/TIGER database.
• Implemented Oracle partitioning strategy for large databases to improve performance of web-based applications.
• Performed extensive data loads using Oracle Import/Export and Datapump utilities.
• Developed Web applications using Java and JSP for viewing various statistical reports.
• Plan and develop efficient databases designs based on analysis of user requirements.
• Architecting a design for publishing database performance reports on Intranet.
• Seamless migration of DEC Alpha enterprise databases and applications as follows:
• From proprietary databases to Oracle 9i/10g.
• From Windows NT/Pentium to Solaris/SUN
• Design of database architecture to support a web-based site that uses Oracle replication and Java.
• Identifying and fixing performance issues related to client applications and resolving.
• Coordinated with developers in reviewing code for optimizing database performance during development and before going into production.
• Developed complex PL/SQL database procedures, packages and triggers to handle complicated business logic for Warehouse Product Database.
• Developed Shell/PERL scripts to proactively assist in various database administration functions like alerts, execution of scripts during off hours, monitoring of archive space, etc.
• Designed and created a database development environment, testing and QA databases.
• Developed korn shell scripts for daily database maintenance. Cloned production database for testing and development environment using export/import, cold backup and RMAN.
• Application tuning using SQL Trace, TKPROF, Explain Plan, STATSPACK and OEM
• Developed & reviewed database structures, standards, and procedures for adherence to business standards.

Environment: HP Unix, Win-NT 4.0 server, Oracle 8.1.7.4, Oracle 9i, PL/SQL, DB2 7.2, Exp/Imp, RMAN, Server Manager, Cold fusion, DB Artisan 8.0, Data guard, Microstrategy, OEM10g, TKPROF.

Confidential, Atlanta, GA

Application DBA/Developer

• Provide technical support for production database DBA team of 8
• Create/manage Database Standards, guidelines for DBA team
• Evaluate and execute backup and recovery policies, configured RMAN backup
• Educate RMAN backup/recovery procedure to the DBA team
• Extensive database tuning done in various aspects like Shared Pool,
• Buffer Cache, Redo log Buffer, Database configuration, and Sort operations
• Rollback segments, Lock Management and I/O contention issues.
• Assistance to application tuning and identifying inefficient SQL statements.
• Analyzed/resolved complex problems, performed maintenance and tuning of
• Oracle Database that increased performance by more than 50%
• Performed Oracle database creation, upgrade, patches in Dev, Test & Production
• Identify Oracle security alerts and co-ordinate to roll out to all the databases
• Research and identify required high availability method and implemented them
• (Standby server, SRDF and Data guard)
• Involved in Disaster recovery activities and created procedures.
• Involved in Unix migration (HP-UX 9.04 to HP-UX 10.01 & HP-UX 10.01 to HP-UX 11.11)
• People soft-HR Support & Involved in people tools 8.19 upgrade
• Creation and Maintenance of ‘Startup and Shutdown’ UNIX scripts for Oracle databases.
• Identifying any security alerts and applying required patches.
• Capacity planning for production database growth before hand and make sure required disk space is available
• Approve the production database implementation tasks, Production install reviews
• Identify and create Production database health check alerts using 'Patrol' (also by shell scripts)
• Development/Test databases were refreshed with Production database using RMAN backup
• Provide 24 X 7 on call production database support

Environment: Oracle 9i / 8i, Shareplex, SQL, PL/SQL, Shell Script, Exceed, Sun Solaris 8, Windows 2000, TOAD, Terminal Services, Putty etc

Oracle DBA

Confidential, WestPoint, GA

Responsibilities:

• Administration procedures were automated using ‘cron’ job scheduler and UNIX ksh, bash and PERL languages. All alerts and errors were monitored and reported automatically during normal and batch runs and interfaced with pagers and email system.
• To provide database administration support and tune performance of databases to give optimum throughput.
• Develop procedures and utilities in KSH and PERL for managing database space, archive and online log files, users, errors, etc.
• Developed PL/SQL database procedures, packages and triggers to handle complicated business logic.
• Installation of Oracle 8i databases on Windows, SUN Solaris.
• Performed database upgrades to bring databases to the latest Oracle release levels.
• Implemented shell scripts to run the job schedules on crontab and experience in to setup job-scheduler using with pl/sql job scheduler.
• Supported test and development environments to ensure smooth transition of applications into production.
• Also efficiently working using OEM to do most of the tasks like monitoring sessions, checking sql’s, database links, table space storage usage and also used oracle expert for SQL history, session tuning and Query optimizing techniques on databases.
• Created Data model Diagrams (Physical & Logical), Entity relationship, constraints using ERwin.
• Pulled out the DDL script to create the tables in database using ERwin.
• Analyzed the database objects using OEM and assigning and altering the profiles of the Database schemas for security purpose.
• Analyzing the SQL queries through SQL Analyzer and observing top sessions.
• Reorganization of database using export/import used this feature in OEM and as well Shell scripts.
• Also scheduled jobs using the cron like taking full database backup, password aging check.

Environment: Solaris 8, Win-NT 4.0, Oracle 8i, pl/sql, Exp/Imp, Server Manager, TKPROF, Data guard, OEM, TOAD8.0, Visio 2003, Java, HTML.