SUMMARY:

• 20+ years experience as Oracle Certified Professional (OCP) DBA
• 20+ years experience as Sr. SQL Server Database DBA
• 13+ years experience as Project Manager on mission - critical projects
• 14+ years experience as Oracle Applications EBS DBA 11i E-Business and R12 (12.0, 12.2.4, 12.2.5)
• Excellent communication skills, leadership, dependable, detail oriented, adaptable and calm under pressure.

TECHNICAL SKILLS:

Oracle DBMS: Oracle 7.3, 8i, 9i, 10g, and 11g (covering both OLTP and OLAP)

Oracle Apps Admin: Oracle E - Business Suites R12 (12.0, 12.2.4, 12.2.5) & Oracle 11i E-Business Suite

Oracle Admin tools: Oracle Enterprise Manager (OEM) Control, OMS Grid Control, ADDM, AWR, ASH, RMAN, DGMGRL, ASMCMD, RAC commands, SQL, Data Pump, OBIEE, PL/SQL

Data Modeling and Warehouse: ErWin, Visio, ER Studio, and Informatica ETL, OBIEE

MS SQL Server: versions SQL Server 6.5, 7, 2000, and 2005, 2008, 2012 and 2014

Platforms: Linux, Solaris, Windows, HP, AIX

Microsoft Project & Office: Project Server 2000 - 2016; Project Professional; Web Access; Sharepoint Services; Analysis Services, MS Office 95, 2000 - 2016; PDS and Office Macro scripting

Java, C/C++ and Visual Basic (VB): J2EE, EJB, JNDI, Struts, SOAP, OC4J, RMI, JSP, ASP, XML, HTML, JavaScript, LDAP, C/C++, VB version 3.0 6.0, MTS, GoldenGate, Clonedb, dNFS, ASO, Agile, Oil & Gas Data Replication

Web and Application Servers: Oracle App Server 9i & 10g, SAP AS Java & ABAP, Weblogic 7 & 8, Websphere, Apache, IIS, Tomcat, JBOS 4.03, Fusion Middleware, Hibernate 3.1, SVN, VNC, Eclipse Platform, Perl, Azure, AWS

PROFESSIONAL EXPERIENCE:

Confidential, VA

Project Manager & Sr. SQL DBA

I provided the services of Project Manager on GeoBISL v3 Architecture Cloud Implementation Project for the GIS group of the Veterans Affairs (VA). It involved conducting interviews and meetings with stakeholders to define the requirements, working with the architects to architect suitable system that would meet the requirements, managing the development team in design and development of the application, working with the test team and the UAT team in ensuring that all the requirements were met and that the system performed at optimal speed. I coordinated with all the teams involved in resolving all the issues identified at all stages of the project and that involved coordinated with SA team, Microsoft support team, Esri team and the development team. I ensured that the project remained within budget, within scope and very much within timeline. Played critical role in hiring and retaining qualified resources and using my leadership skills in ensuring deliverables are met. Key technologies used include: MS Project Professional 2016, MS Office 2016, Windows Server 2012 R2 Standard (64 Bit), SQL Server 2012 & 2014, Tableau Analytics, PowerShell, ArcGIS Server, ArcGIS Web Adaptor, ArcGIS GeoAnalytics, Azure, Virtualization Technology (MS Hyper-V UEFI Release v1.0).

Confidential, Houston, TX

DBA Manager

I was a hands-on DBA Manager that provided leadership and operational support in a very dynamic, high-tech manufacturing environment that relies heavily on Oracle EBS R12. The EBS system includes Manufacturing and Financial modules (AR, AP, GL, Fixed Asset, etc) and operated 24x7. I also played the role of Project Manager on several projects and they include SoCal (Southern California) project, which was upgrade of EBS system from 11i to R12 (12.2.4) and Solution implementation and upgrade of EBS system from 11i to 12.2.5 at 2 PCC locations in PA state. I also replaced HP Data Protector backup and recovery system with cloning automation that I developed. Some other projects include integrating EBS and Hyperion systems of newly acquired corporations to those of Wyman, automating the EBS instances cloning, upgrading of PDM and Weblogic Fusion Middleware, etc. I worked on developing the project plans, communicating the direction of the team and reporting activities progress to stakeholders and also carried out administration support tasks associated with OBIEE and Hyperion (forecasting, planning, reporting) that run on SQL Server. I strived in identifying risks, developing strategies, setting goals, assessing and providing performance feedback and ensuring that projects remain within scope, timeline and cost. We completely automated much of our support tasks that enabled us to focus on more critical tasks and issues. Key technologies used include: Oracle 11gR2 & 12c, MS Project Professional 2016, EBS Financial (11i, R12.2.4, R12.2.5), Hyperion v11.1.2, SQL Server 2008 & 2012, ODI, SOA, OBIEE, ADOP Patching R12, RAC, Tableau Analytics, Oracle Fusion Middleware 11.1.1.7, BI Publisher, Shell, Perl, PowerShell, KornShell, Bash, Accelatis v3.4 and v4.0, RMAN, Clonetab, OEM Cloud, Linux 6.5 & 7.0.

Confidential, Round Rock, TX

Sr. Oracle EBS APPS DBA

I provided the services of Sr. Oracle Apps DBA on a mission-critical project at Dell. I played critical role in setting up and configuring 16 instances of EBS 12.2.4 each running on 4-node RAC 11.2.0.4 DB in high secure environment. I worked on determining types of machines and specifications for the DBs and EBS apps, validating the provisioned machines; carrying out pre-install prep; installing the base EBS Apps (12.2.0); upgrading the Apps to version 12.2.4; applying post-upgrade patches; performing all necessary installations and configurations of SOA, BI Publisher (with Fusion Middleware 11.1.1.7), Sabrix Tax system, ODI, STAT, and Oracle Transportation Management (OTM). Provided admin and SME support during the conversion and integration phase of the project, carried out extracting, transforming and loading (ETL) data to the new system and performing other regular admin tasks including taking backups, cloning environments, applying patches, managing user accounts and responsibilities, carrying out Performance Tuning of both the Apps and DB, implementing encryption on the DBs, debugging forms and app scripts and ensuring maximum performance, security and scalability of the entire systems. Played vital role in architecting and strategizing the entire project in Agile environment and also participating in some application coding. Key technologies used include: Oracle 11gR2 & 12c, EBS R12.2.4, AIA, ODI, SOA, OBIEE, ADOP Patching R12, RAC, Oracle Fusion Middleware 11.1.1.7, BI Publisher, Sabrix Tax System V5.6, Workflow Builder, .NET, EBS Financial, Weblogic, Siebel CRM, RAC, RMAN, OTM, GTM, OEM Cloud, ASM, Oracle, Agile, Shell, PowerShell, KornShell, Bash, Scrum, TFS, Linux 6.5 & 7.0.

Confidential, Portland, OR

Sr. Oracle Database

I provided the services of Sr. Oracle DBA remotely to several Oracle DBA teams that manage hundreds of Oracle DBs at Cambia. I upgraded 88 Oracle databases from various versions to 11gR2. The upgrade process included installation of binary on the machines (Linux, Solaris or AIX), upgrade preps at OS level (Packages, OS patch, etc), intermediate upgrades of the DBs (7.3.3 or lower --> 7.3.4 --> 9.2.0.8 -->11.2.0.3), upgrade of the DBs and verification of the upgraded system. I worked on patching 95 DBs to PSU patch 11.2.0.3.9 and applied patch p to 55 DBs running on AIX. I also performed decommission of DBs and binaries, migration of DBs and carried out Performance Tuning of DBs I worked on. Key technologies used include: Oracle 7, 8i, 9i, 10g & 11gR2, RMAN, Data Guard, AIX, Red Hat Linux, Solaris 10 & 11, Oracle Upgrade and Patch, data pump, Streams, Toad for Oracle, Remedy.

Confidential, Houston, TX

Sr. Oracle DBA

I provided the services of Sr. Oracle and SQL Server DBA to Application and Data Integration (ADI) team and also to DBAM team in handling numerous projects. The projects included development of Rapid Database Provisioning and cloning automation that was capable of cloning Oracle (10g, 11g and 12c) and SQL Server (2005, 2008, 2012 and 2014) databases using latest technologies. It clones 10TB Oracle DB (11g/12c) in 2 min. I developed and implemented web interface for the automation in C#. I also worked on development of Oil Sands ETL system that involved data modeling, extracting, transforming and loading (ETL) data from various SQL Server databases to Oracle Data Warehouse using MS SSIS and developing numerous reports in Tableau; collaborated with Geologists in configuration and maintenance of Stream replication (Internal, External and Bidirectional) of GIS geospatial data; configured GoldenGate 12c on Oracle and SQL Server databases; and implemented data encryption and advanced OLTP compression. I also provided subject matter expert (SME) support to ADI team in terms of role and user admin, creating of packages, procedures, triggers and resolving connectivity issues on hundreds of databases in Agile environment. I played vital role in strategizing and carrying out upgrade of hundreds of Oracle 10g DBs to 12c and from various SQL Server database version to 2014. I played critical role in maintaining the SSO and ensuring SOX compliance. Key technologies used include: Oracle 10g, 11g, 12c, CloneDB, dNFS, ASO TDE Encryption, Data Redaction, Shell, PowerShell, KornShell, Bash, Tableau, Informatica, Oracle Golden Gate, ASO, OID, RMAN, RH Linux, Streams, Oracle Fusion Middleware, GIS, geospatial, ER Studio, Agile, Scrum, Cloud OEM, RMAN, SQL Server 2005, 2008 & 2014, MS TFS, Azure, C#, .NET, Visual Studio, SSIS.

Confidential, Houston, TX

Project Manager and Sr. Oracle DBA

I provided the services of Project Manager and Sr. Oracle DBA on a global transformation and migration of Oracle databases (74 in Houston, TX and 75 in Amsterdam, Europe) to AWS Cloud through T-Systems. The project involved migrating and upgrading the databases from Legacy (in-house supported) running on Solaris v10 to T-Systems cloud running Red Hat Enterprise Linux Server release 5.7 OS. My work included planning and scheduling the migration; carrying out the migration; carrying out performance tuning of the migrated databases; and converting streams replications to GoldenGate. I also designed and developed (solo) 2 automations (Auto Generated Request Forms and Auto Configuration & Verification System) used in Shell globally for customizing new machines. Key technologies used include: Oracle 10gR2 & 11gR2, Golden Gate 11g, OEM Grid Control 11g, AWS Cloud hosting, RMAN, Data Guard, Standby, Red Hat Linux v5.7, Solaris 10, data pump, Streams, Spatial, XML and MS Project Server 2010 Professional.

Confidential, Houston, TX

Sr. Database DBA (Oracle & SQL Server)

I provided the services of Sr. Oracle DBA on merging Oracle and SQL Server databases of Continental Airlines with those of Confidential following the merger of the 2 airlines. I was the key resource on this project. The project involved consolidating their various databases and applications, carrying out various tests, extracting, transforming and loading (ETL) data from various Continental Airlines sources to those of Confidential . I also provided production support of promoting codes and data from lower to higher environments. The process involved taking backup of databases; restoring them; carrying out data cleansing and loading to other higher environments; scripting codes in Oracle and shell; scheduling jobs; monitoring the activities; resolving coding issues and carrying out Performance Tuning. I also created many databases, configured the Oracle Application Servers, and the OEM Grid Control. Key technologies used include: Oracle 10gR2, OEM Grid Control 11g, RMAN, Linux, Data Pump, Data Guard, Standby DB, Toad for Oracle, Fast Track, SSMS, and SSRS, SQL Server DBA.

Confidential, Houston, TX

Sr. Database DBA (Oracle, SQL Server & Sybase)

I provided the services of Sr. Oracle DBA on the testing and implementation of Endur enterprise application systems developed for use at all Shell Trading locations worldwide. I played critical role of working closely with all other DBAs in the team in ensuring best practices in effort to improve security, availability importantly, overall performance of the system. I redesigned automation system that was used by most DBAs at Shell for cloning DBs and slashed the execution time from 7.5 hours down to 3.5 hours within my first week on the job, which drew the attention of the management. I identified 20 of the longest running jobs and slashed their execution time tremendously by redesigned them and in some cases by reviewing the indexes and triggers. I developed an automation that routinely reclaimed (Redefinition) unused spaces left in large XML tables. I also played important role in performing backup & restore, development of Oracle and shell scripts that automated many of the activities in the project; supported SAP system, Sybase and SQL Server databases; carried out performance tuning of the databases; provided assistance to the development team in tuning their queries, scheduling and monitoring jobs; and importantly, documenting various activities for the director. I worked very closely with both the Project Managers and the Global IT Director in ensuring that the deadlines were met. Key technologies used include: Oracle 11gR2 RAC, ASM, OEM Grid Control, RMAN, Linux, Data Pump, Toad for Oracle, Stream, Lotus, Clear Quest, SQL Server DBA, Spatial, XML, and Sybase Anywhere.

Confidential, Plano, TX

Sr. Oracle DBA & Sr. Oracle Developer

I provided services of Sr. Oracle DBA on the design and development of Enterprise Information Systems (EIS) system. The system was developed in compliance with Asset Management interface to handle hardware and software inventory of some of HP’s very important clients. I set up and configured RAC 11g database running on Linux platform. I also played key role in the development of various PL/SQL scripts, loading of data to the staging data mart and ODS data marts. I redesigned the Java application that was responsible for fetching and loading normalized data into the appropriate tables to ensure maximum performance and scalability. I carried out series of Performance Tuning sessions on both UAT and Prod databases, which resulted in drastic performance improvement of over 60%. Key technologies used include: Oracle 11gR2 RAC, Clusterware, ASM, Physical Standby databases, OEM Grid Control, RMAN, Data Pump, Linux, impdp, expdp, Java JDK1.6, Asset Manager, Asset Designer, ODS, Data Mart, Toad for Oracle.

Confidential, Dallas, TX

Sr. Oracle DBA & Sr. SQL Server DBA

I provided the services of Sr. Oracle and SQL Server DBA in a Data Forensic project involving large financial organizations. I was the only technical resource on the project and the tasks I performed included importing 900 dump files totaling over 10TB of data to 4 Oracle databases; redefining tables; migrating the imported data from Oracle to SQL Server databases; and parsing the XML fields containing hundreds of millions of emails subjected to forensic analysis. Key technologies used include: Windows 2003 & 2008, Linux, Oracle 8i, 9i, & Oracle 10gR2, SQL Server Management Studio, SQL Server 2005 & 2008, SSMA, OEM 10g, RMAN, Data Pump, DBCA and DBUA.

Confidential, Irving, TX

Lead Oracle DBA

I provided the services of Lead Oracle DBA in a mission-critical 24x7 Oracle RAC database farm on Redhat Linux Platform. I led the corporation in migrating three key production databases from one hosting company in Virginia to T-Systems in San Antonio, TX. The databases were upgraded from non-RAC to RAC using ASM. I created new schemas and objects (sequences, procedures, triggers, MVs, jobs, etc) on the new databases, carried out initial Performance Tuning and scheduled regular automated tuning of the databases on weekly basis. Two of the production databases were OLTP and one Data Warehouse (DW) database used for both ad hoc and canned reporting. My team supported over 300 Oracle 10gR2 databases hosted at client sites (Price Chopper, Home Depot, etc) scattered all over the country. Each site accesses the central RME database. I reviewed and modified the data model and also tuned and created several new packages, procedures and triggers for enforcing business rules and streamlining business processes. Worked with QA and the Dev teams in optimizing the RM and RME Java applications and in creating new packages and Unix scripts. Also attended design review meetings with developers and played important roles in application testing and deployment. Key technologies used include: Oracle 10gR2 RAC, Clusterware, ASM, Physical Standby databases, OEM Database Control, RMAN, Data pump, Flashback, Linux, Toad for Oracle, Websphere.

Confidential, Austin, TX

Lead Oracle DBA

I provided the services of Project Manager and Senior Oracle DBA on a mission-critical migration and transformation of 10TB non-RAC databases to RAC. The 10g databases used ASM as data storage system on a Redhat Linux while the DB ran on Solaris 10 platform. I led the corporation transition from single-instance Oracle 10g databases to RAC environments suited for their rapid growing 24x7 business environment. We configured the system and performed data migration to the RAC environment on Solaris 10 for their main OLTP production database. The production database feeds data through Data Guard to a Logical Standby database used primarily for Reporting and also to a Physical Standby database used primarily for disaster recovery (DR). We did migration of OLAP database from Solaris 9 to Redhat Linux. I managed the project, reported to stakeholders and played key role in testing the environment; ensuring that PCI and SOX audit requirements were met and providing training to the support DBAs and developers. Installed 3 new instances of Oracle 11i E-Business Apps with 10g DBs. Provided support in terms of applying patches, supporting the users, providing admin support on Oracle 11i E-Business Suite, taking RMAN backup and proactively ensuring maximum Performance and Availability of the databases and E-Business Suite. I received OBIEE, RAT testing and OEM admin training from Confidential in Austin. I also installed OEM Grid Control OMS and Agents and trained the DBAs on how to monitor and administer multiple databases using Grid Control. Key technologies used include: Oracle 10gR2 RAC, Clusterware, ASM, Data Guard, Logical and Physical Standby databases, OEM Grid Control, RAT testing, RMAN, Flashback, Oracle 11i E-Business Suite, ER Studio, SVN, VNC, Linux, Solaris 10, sqlloader, Bulk data loading & OBIEE.

Confidential, Harrisburg, PA

Sr. Oracle DBA and Sr. Database Architect

I provided the services of Senior Oracle DBA in developing a new Oracle 10gR2 database environment. Created 12 databases (6 OLTP and 6 matching OLAP) for use in the department for their daily activities, which included vehicle registration, drivers license registration and maintenance, etc. We migrated data from mainframe system to Oracle using Informatica ETL tool and Oracle scripting. Developed scripts that moved data from the OLTP databases to their corresponding OLAP database based on pre-defined ageing rule. We Interfaced the SAP to the Oracle databases and developed packages and procedures, created indexes, table partitioning and some function indexes for better performance and report generation. We developed and tested a robust backup/recovery strategy for the environment, integrated SAP backup library with the RMAN and documented the system. Provided knowledge transfer to the DBA support team and trained both the Reporting team and Java developers on Best Practices. Key technologies used include: Oracle 10gR2, WebSphere, OEM Grid Control, Clear Quest, SAP, Lotus, Informatica, OBIEE, Toad for Oracle 9.1, and ErWin.

Confidential, Ann Arbor, MI

Sr. Oracle DBA and Sr. Database Architect

I provided the services of Senior Oracle Database Administrator in migrating Oracle 8i real-time database system to Oracle RAC 10gR2 and redesigning the entire system, which had 2TB of data running on Data Guard environment. I carried out series of interviews with the management and business experts, analyzed the information gathered and used it to develop the Data Model for the new system using ER Studio. The old database was reverse engineered and the new model integrated with the reverse engineered model to meet the required business need of the organization. With the integrated model, designed and developed the new database and series of Perl and Oracle scripts to automate much of the dataload and report generating activities. The Production was implemented on MS Windows 2003 64-bit Enterprise Server Edition environment. Implemented a robust backup and recovery strategy, carried out initial Performance Tuning and applied patch sets to the system. Trained their DBA team and instilled Best Practices to the development and support teams. Key technologies used include: Oracle 10gR2 RAC & Oracle 8i, Data Guard, Standby DB, ASM, OEM Grid Control, EMS, TMS, Toad for Oracle 9.1, OBIEE, and ER Studio

Confidential, East Lansing, MI

Team Lead, Sr. Oracle DBA, and Sr. Java Developer

I provided the services of senior level Java developer and Oracle DBA in an Oracle 9i environment that housed data used by Confidential for various applications such as the Sex Offender Registry. Some of the major tasks I carried out at Confidential include: migrating the Sex Offender Registry (SOR) application and data from Mainframe system to Java web application and Oracle Database system; data migration of Report Management System (RMS) from SQL Server database to Mainframe system; carried out Performance Tuning on Oracle 9i system, which reduced the data load time for SOR application from 21 hours to 17 min; provided training to the DBA team in the areas of performance monitoring, performance tuning, and SQL code development; and also provided performance tuning on SQL Server database 2005. Key technologies used include: Oracle 9i, SQL Server 2005, Solaris, Win 2003, Unisys Mainframe system, Eclipse Platform, Hibernate 3.1, Jasper ExtenXLS 5, JBOS 4.03, SVN 2.1, Struts, EJB 3.0

Confidential, Pontiac, Michigan

Project Manager & Sr. Oracle DBA and Sr. SQL Server DBA

I provided the services of Project Manager and Sr. Oracle DBA on Oracle 10g RAC database managing a very large Java based, custom-built application that generates project plans with minimal user intervention and pushes the data in MS Project format in MS SQL Server database. The data is immediately replicated to the corresponding Oracle database. There were 40 Oracle and 35 SQL Server databases in all serving all the Confidential Engine Engineering location all over the US. I managed the project resources, planned and maintained the project ensuring that the project remained within budget, timeline and scope, reported to the management and stakeholders and also maintained the Oracle and SQL Server databases. The DBA activities included setting up the Oracle 10g RAC environment; migrating data from various other versions of Oracle to 10g; carrying out proactive performance tuning; developing backup and recovery strategy; providing support to the Java development team in testing and enhancing their codes; automated synchronization of data between various SQL Server databases and their corresponding Oracle databases (one-to-one match); developing Oracle, SQL Server and Unix scripts to automate routine tasks; applying patches; and all other regular DBA tasks. The platform was Windows Server 2003 and MS SQL Server 2000 and 2005 Enterprise Editions that worked hand-in-hand with MS Project Server 2003 environment comprising of MS SharePoint Services, MS Reporting Services, MS Analysis Services, SQL Server Management Studio, SSMA, LDAP, SSO, ASO, MS Web Access, OID, OIM, and Weblogic 7 & 8, SOAP, OEM Grid Control.

Confidential, Detroit, MI

Sr. Oracle DBA and Sr. Unix Admin

I provided 24x7 Oracle DBA services on 28 Oracle Enterprise Edition database systems running various versions (including 8.1.7, 9.2.0 and 10g). The services provided included creation of new databases, performing backup and recovery, replication of production database to dev, test, QA and training databases on regular basis, providing support to both development and production users, carried out major performance tuning on most of the databases which resulted in more than 50% performance gain, completely eliminated locking issue on the databases which was major pain when I joined the company, held regular meetings with the development team, provided the top management with regular reports and expert recommendations on various areas. I also installed, configured, and administered Oracle Applications 11i E-Business Suite and Oracle Application Server 10g (ias9.0.4.1) that operated against Oracle 10g database. I configured Single Sign-On (SSO) using Oracle Identity Management of Oracle Advanced Security (ASO). I supported users, applied patches and performed backup and restores. Provided Linux & Unix administration on two Linux machines and eight HP-UX machines (including installation of new operating system, development of scripts, administration and performance monitoring). Provided support to both the QA and the development teams in application development in JSP, J2EE using OC4J, Oracle Forms, Designer and Discoverer. The support included testing, application roll-out to production, handling of production issues and adoption of industry best practices. Key technologies used include HP-UX, Linux, J2EE, 11i E-Business Suite, OC4J, SSO, OIM, ASO, Oracle Forms, Designer, RMAN, Oracle 8i, 9i, 10g, Oracle App server ias9.0.4.1 and OEM.

Confidential, Dearborn, MI

Team Lead, Sr. Developer

I played key role in the planning and development of Revenue Management web site used by the marketing team for sales forecast. Provided expert solution (debugging, code fixes, mentoring, application configuration and system optimization) to development and production teams on VB, C++, Perl, Rogue Wave Application Server, Oracle and various Unix applications. I played key role in the upgrading of three Oracle databases (Dev, UAT and Prod) from older versions to 8.1.7. I also performed adaptability and perfective maintenance on several applications. I played critical role in implementing the Sarbanes Oxley (SOX) requirements on all our applications. The environment was Solaris/ Win 2000 with WebSphere.

Confidential

Artificial Intelligence Admin

Played vital role (while pursing my degree at Confidential ) in development of an Embodied Conversational Agent (Chatbot, chatterbot, chat robot) based on Artificial Intelligence Neural Network developed in Java. I worked very closely with Bob Heller, PhD as Java developer and AIML (Artificial Intelligence Markup Language) developer in the development of Freudbot chatbot that posed as Sigmund Freud. The Chatbot was developed to hold intelligent conversations on topics relating to Sigmund Freud (the father of psychology) and on general topics such as politics, and major events in the country and the world. Key technologies used include: Artificial Intelligence Markup Language (AIML), Java, HTML, Chatbot, MS Office.

Confidential

Project Manager and Oracle DBA

I migrated data from Oracle Standard Edition 8.0.5 on HP-UX Unix to Oracle Enterprise Edition 8.1.7 on Solaris SunFire 880 (SMP 4 CPUs 8GB of RAM). Tasks performed include, Installation and configuration of Oracle Server with Oracle Advanced Security, Partitioning, Spatial, HTTP Server and InterMedia options and also ensuring Oracle OFA compliance and making structural review and recommendation on the database, Collaborated with client’s System Architect in setting up the new Sun Unix box, Developed various Oracle and Unix scripts, prepared daily reports, carried out performance tuning and developed backup and recovery strategy. Carried out testing and documentation of the entire system (both Oracle and Unix). Oracle Enterprise Manager (DBA Studio and Oracle Expert) was used for the administration of the database systems. I tuned the new database and dramatically reduced average load time from 10 min to 1.49 min and also reduced the load time of the longest running job from 16 min down to 4 min.

Confidential

Team Lead - Business Intelligence (Data Warehousing)

I provided both Oracle Database administration (DBA) to Nissan Data Warehouse (DW) development project team and the Nissan Parts Pricing project team at Nissan Canada. The Data Warehouse (Very Large Database) ran on Oracle Enterprise Edition 8.1.6 and AIX 4.3.3 platform equipped with Tivoli Storage Management (TSM). Services provided include conducting meetings and interviews with the management and various business experts; development of data model (Logical and then physical models) based on the information gathered using ErWin; setting up of the Data Warehouse (DW) environment (staging, ETL and datamarts); setting up and carrying out performance tuning on the DW environment (the 8 databases); and mapping and migrating of data from mainframe and Oracle 7.3.4 databases to the DW using Informatica ETL tool; Development of various PL/SQL and UNIX scripts used in the environment. Oracle Enterprise Manager (DBA Studio and Oracle Expert) was used for the administration of the database systems. Key technologies used include ErWin, Oracle 8i & 7.3.4, Oracle Designer 2000, Informatica, Tivoli Storage Management (TSM), Oracle Application Server, Lotus Notes, and Java.

Confidential

Professional Service Consultant

I provided Oracle DBA services to Confidential NY and Confidential Chicago dev teams (Professional Services, Client Support and QA departments) running Oracle8i Enterprise Edition database servers. The projects were designed to handle several million contacts. Services provided included installation of Oracle server and Client (on each users’ machines); creation of user accounts; administration of security, privileges and roles; creation of all database objects (tables, views, stored procedures, packages, etc.); performing backup, dataload and development of backup/recovery strategy; carrying out performance tuning; conducting stress tests and ensuring maximum availability of the databases; and performing of data modeling of the database using Erwin. Much of my work included administering SQL Server and Access DBs. Oracle Enterprise Manager was used for the administration of the database systems.

Java Dev, VB and Visual InterDev Developer

Confidential, NY

I played key role as Java and ASP (using Visual InterDev) web developer in development and implementation of web content applications for Confidential NY to handle their campaign management. The application integrated seamlessly with Janna Web Client (eCRM). Database was implemented on Sybase database system. While transportation between the ASP and the business objects was based on DCOM, the Lead reader and loader were implemented on MSMQ. Technologies used include ADO, ActiveX objects & OCX, COM, DCOM, MSMQ, SMTP, MAPI, CTI, IIS, XML, HTML and (CSS).

Confidential

Oracle DBA, SQL Server DBA, Unix Admin, VB and C/C++ Developer

I provided 24x7 Oracle DBA support on Oracle Enterprise Edition 7.3.4 for the entire Testing and Finishing departments. The services provided include creation of new database instances; setting up and configuring Oracle tools; carrying out performance tuning on the databases; administering user, roles and privileges; setting up backup and recovery strategy and carrying out regular data backup. I also provided training to new engineers. Provided services of Unix administration on Sun Solaris and HP-UX to the Testing and Finishing departments. The services include installation of various applications, and service packs; administration of user accounts and ensuring maximum uptime of the entire Unix system and all the applications running on it which include Oracle databases and various automated testing applications. Also developed and maintained full life cycle of a real-time inventory control system for handling of finished products as well as all spare parts used in the industry.