CAI Contact

Insert name and contact information for the CAI Account Manager listed on the Peoplefluent requirement. For ease of reference, the Account Managers' contact information appears below.

Skills

Please use this table to list the skills noted in the Required/Desired section of the Peoplefluent requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

Database Administrator / Technical Lead

Confidential . C Spire Wireless, headquartered in Ridgeland, Mississippi, is the eighth

Largest wireless provider in the United States is a provider of broadband internet and phone services.

Responsibilites:

• Created, Configured, Upgraded And Administered 10.2.0.4/11.2.03 versions Oracle databases on Linux SUSE / Solaris 10/ AIX 6.1
• Supported SQL Server 2005/2008/2012 Database Instances of TEST/PROD environments hosting applications to support more than thousands of users
• Installed And Configured OEM 12c on Linux platform - Installed Agents on Solaris/AIX platforms, Configured Email Notifications, Alert log filters, Administration Groups, Administration Jobs, RMAN Backup Jobs
• Ensured optimal database performance through exhaustive pre-service testing and ongoing real-time monitoring using OEM 11g/12c, TOAD 11.6.0, Automated Scripts, SQL Developer 3.2.20
• Participated in meetings for Project Updates/Project Enhancements/Trouble shooting periodically

Achievements:

• Provided Plan Stability for critical processes across different versions of databases
• Configured OEM 12c on Solaris 5.10 / AIX 6.1

Environment: ERP: R12.1.3 Oracle DB: 10.2.0.4/11.2.0.1/11.2.0.3

• SQL Server: 2005/2008/2012 OS: WINDOWS 7.0/LINUX-SUSE 11/SOLARIS 10/AIX 6.1
• DB Admin: Putty, Win SCP, VNC Viewer, OEM 11g/12c, RMAN TOAD 11.6.0, SQL Developer 3.2.20, RMAN Performance Tools : AWR, SQLT, EXPLAIN PLAN, TRCANLYZR
• Replication: Data Guard, IDR Informatica Data Replication , MVs

Confidential

Database Administrator / Technical Lead

Confidential provides customers and businesses worldwide with a broad portfolio of transportation, e-commerce and business services. The current CMDM system managing the Legal customer definition is planned to extend to provide a more robust set of relationship management capabilities to simplify and improve the existing CMDM EDW extract and web services and also toallow for hosting of the Pricing and Sales customer definitions. The ultimate goal of the resulting system is to provide a platform for managing existing customer definitions and reduce the cost and complexity of incorporating new definitions going forward.

Responsibilities:

• Supported production oracle DB 10.2.0.4 on Linux platforms
• Supported development team of size 20 in enhancing project of the existing prod system
• Used Sybase power designer for data modeling, applying db changes reverse engineering
• Defined project requirements, analysis for best practices.
• Existing systems for documentation
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance New Features
• Worked on Oracle Non-Oracle Database Management products for administration/backup-recovery/performance tuning
• Tuned resource consuming queries on prod and dev systems using performance tuning tools - SQLT, AWR, EXPLAIN PLAN, ASH ADDM
• Monitored changes using DB ADMIN tools - EMBARCARDERO DB Artisan DB Change
• Manager, SQL Server DB Admin
• Responsible for Database Administrator to support database and data warehouse production/development environment.
• Responsible for designing, database Installing, conversion, enhancement, maintenance, monitoring, performance tuning, configuring, object databases, tables, triggers, indexes, procedures and functions creation and backing up of databases.
• Manages and maintains the data dictionaries.
• Participated in Partitions decision making, capacity planning development analysis meetings
• Raised SRs to Oracle Support as-and-when required for analyzing prod issues
• Support monthly maintenance tasks and resolved/supported critical issues on PROD

Environment : Databases : Oracle 10.2.0.4/11.2.03 on Linux 5.0, Data Modelling : Sybase Power Designer 15.2.0, OS Tools : Putty, WinSCP, TELSA, Tight VNC2.0.4, Performance : SQLT, TRCA, EXPLAIN PLAN, SQL Profiling, Development : SQL developer 3.1.07, SQL, PL/SQL,

DB Admin : OEM Grid Control, EMBARCADERO-DB Artisan, DB Change Manager

Confidential

Production DBA

Confidential is the world's largest independent public relations firm, with offices in 60 cities and more than 4,000 employees worldwide, as well as affiliates in more than 30 cities. Edelman owns specialty firms Blue advertising , Strategy One research , Ruth integrated marketing , DJE Science medical education/publishing and science communications , and MATTER sports, sponsorship, and entertainment

Responsibilities:

• Checking status of daily backup jobs for purging archive logs hourly , refreshing SUPP, DEV, TRAIN, TEST with PROD periodically
• Coordinating with onshore analysts and offshore development team
• Clearing tickets raised by HITACHI offshore team on PROD and SUPPORT instances
• Defined project requirements, analysis for best practices.

Troubleshooting failed backups, slow-running queries, setting up new users and add/remove privileges on PROD for key development team

• Documented and complied with company policies and standard operating procedures.
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance New Features
• Responsible for designing, database Installing, conversion, enhancement, maintenance, monitoring, performance tuning, configuring, object databases, tables, triggers, indexes, procedures and functions creation and backing up of databases.
• Worked on Oracle Non-Oracle Database Management products for administration/backup-recovery/performance tuning
• Manages and maintains the data dictionaries.
• Coordinated with Oracle Support to resolve issues on 24 7 basis
• Setup link between oracle and SQLServer instances using DG4MSQL and tested successfully on TEST environments

Environment: Dba team of size 4 2 onsite and 2 offshore, 16 Oracle Instances 10.2.0.4, 11.2.0.3 , 40 Sql Server Instances 2005, 2007 , Frontend applications are In house .net applications PeopleSoft Financials on Oracle HR running on SQL Server

Confidential

Oracle Production DBA

Confidential is a cooperative effort in the Office of the Comptroller of the Treasury to integrate data and functions from today's independent property-based systems into a single comprehensive systems solution. Entities participating in this effort include the Division of Property Assessments, State Board of Equalization, Office of State Assessed Properties and Office of Management Services / Information Technology Section. IMPACT is a key component in the collaborative Business and Technology Vision for continuous improvement in the Office of the Comptroller of the Treasury.

Responsibilities:

• Worked on Oracle Non-Oracle Database Management products for administration/backup-recovery/performance tuning
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance New Features
• Performed Extraction, Conversion Loading of data from Main Frames to Oracle databases 10.2.0.4 / 11.2.0.3 versions
• Monitoring and resolving slow running query issues on PROD and recommend dev team
• Refreshed TRAIN site for training county users as when request comes from DPA
• Checked backup jobs using RMAN, Exp dump check db health of PROD and TRAIN
• Designed OLTP DSS systems from the beginning and provided documentation for development and analysis teams
• Defined project requirements, analysis for best practices.
• Responsible for designing, database Installing, conversion, enhancement, maintenance, monitoring, performance tuning, configuring, object databases, tables, triggers, indexes, procedures and functions creation and backing up of databases.
• Achievements
• Coordinating with Oracle Support for troubleshooting issues on 24 7 basis
• Applied Patches for Oracle Server and database tools as when new patches are released
• Documented and complied with company policies and standard operating procedures.
• Installed GIS environment ArcGIS tools on TEST and PROD to access data from oracle and SQL server and publish on website
• Moved environment from Non-RAC to 2 node RAC environment running on ASM
• Migrated environment from single-server to multi-server environment
• Manages and maintains the data dictionaries.
• Played major role in integrating individual modules to IAS World Website accessed by more than 97 counties in the STATE
• Setup data guard on DR site to replicate data from PROD on regular basis

Environment : DBA Team of size 2, Development Team of size 12 Applications running on .NET, JAVA, MS ACCESS Oracle Forms Reports , Oracle 10.2.0.x/11gR2 OS : Windows 2003/2008 Tools : TOAD8.6.0, SQL Developer Application Server : 10g AS OS : Windows Vista/2003R2/2008R2 RAC : 4-Node 4 processors, 32.0 GB RAM 64-bit Application Server : Web Logic Server 11gR1 10.3.5.0 , Jdeveloper - 11g 11.1.1.5.0

Confidential

Oracle Database Administrator

Confidential acts as an agency between the homeless and needy participants to the HUD Agency and maintains records of all the eligible participants in the database. Responsible for the selection of eligible participants for Housing Choice Voucher Program HVCP and in allocating funds for the eligible participants. Oracle EBS 11.5.9.0 is implemented for the business flow and many custom applications are integrated with Financials, HR Property Mgmt Modules of EBS.

Responsibilities:

• Installed and migrated databases from 10g to 11g using DBUA, Export/Import
• Discussed with QA Team before generating crystal reports as requested by end users.
• Creation of Application users and assigning the tablespaces, quotas, roles and profiles.
• Defined project requirements, analysis for best practices.
• Imported, created and edited the table definitions using Informatica Designer. Used repository manager to create folders and managed the user's privileges.
• Written Shell scripts for day-to-day database activities for transfer files from dev server to PROD
• Responsible for designing, enhancement, maintenance, monitoring, performance tuning, configuring, object creation and backing up of databases.
• Designed OLTP DSS systems from the beginning and provided documentation for development and analysis teams
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance New Features
• Worked on Oracle Non-Oracle Database Management products for administration/backup-recovery/performance tuning.
• Database Planning, Designing and Setting up of storage parameters for segments.
• Setting up logical/physical backups for these databases. Depending on the nature of database, set up of either Full export, partial export, or export of just the structure of schema objects Using RMAN as well.
• Trained developers, management and end users regarding functionality of new products before implementation setting up Oracle disaster recovery sites using Data Guard
• Manages and maintains the data dictionaries.
• Experience in writing, modifying and executing shell scripts for database mgmt tasks
• Configured and supported databases running on remote servers using OEM Grid Control
• Experience in escalating the critical issues by rising TAR/SR to ORACLE CORP.

Environment: EBS : 11.5.9.0, 11.5.10.2 Languages : PL/SQL, Java Front End : Forms 6i/10g, Reports 6i/10g, JDeveloper Tools :TOAD8.6.0,SQL Developer Application Server : 10g AS OS : Windows XP, AIX 5.2, WRQ Reflection FTP Client Version Control : WinCVS 2.0.2.4

Confidential Oracle DBA

Confidential maintains data for whole Bahrain regarding their site plans, documents in the oracle database. The users will connect to the websites from various locations and also from around the world through website.

Responsibilities:

• Experience in installing and configuring 10g RAC on Linux
• Migrated Oracle databases from 8i, 9i to 10g databases using DBUA, Export/Import
• Experience in implementing and supporting Oracle Streams for Replication
• Defined project requirements, analysis for best practices.
• Responsible for designing, enhancement, maintenance, monitoring, performance tuning, configuring, object creation and backing up of databases.
• Worked on Oracle Non-Oracle Database Management products for administration/backup-recovery/performance tuning
• Performed Business System Analysis on existing production systems and provided recommendations for improving Performance New Features
• Responsible for database installation, database upgrades and software maintenance
• Used 10g New Features like ADM, ADDM for producing database performance reports
• Manages and maintains the data dictionaries.
• Documented and complied with company policies and standard operating procedures.
• Creation of Application users and assigning the tablespaces, quotas, roles and profiles as per requirements.
• Experience in using RMAN utility for Hot Backups Cold backups with various scenarios

Environment: Oracle Reports Builder 6i, Oracle Forms Builder 6i, XML publisher, Oracle 10g, SQL Loader, PL/SQL Developer, TOAD, UNIX

Confidential

Database Administrator

Confidential administers from four locations in Bahrain. It takes care of Registration, Transfers, buying and selling of Land. It also deals with Hydro Surveying, Selling maps, Topographic Survey Site Survey. ISS Information System Section handles major systems like Cadastral Information System CIS , Database Management Tool DATAMAN and Surveyor 4 to provide services for its customers.

Responsibilities:

• Creating databases, Refreshing Testing/development databases from production.
• Implemented 10g New Features ASM, OCFS, ADM, ADDM for prod database performance
• Defined project requirements, analysis for best practices.
• Database Planning, Designing and Setting up of storage parameters for different segments.

Performed Business System Analysis on existing production systems and provided recommendations for improving Performance New Features

Worked on Oracle Non-Oracle Database Management products for administration/backup-recovery/performance tuning

• Tuning of rollback segments by estimating the transaction volume and transaction rates in 8i and later creating undo tablespaces in 9i and setting up undo retention parameter.
• Documented and complied with company policies and standard operating procedures.
• Responsible for database installation, database upgrades and software maintenance
• Setting up logical/physical backups for these databases. Depending on the nature of database, set up of either full export, partial export, or export of just the structure of schema objects Using RMAN as well.
• Manages and maintains the data dictionaries.
• Tuned the application for better performance by using explain plan and running the tkprof utility and Statspack.

Environment: Oracle Apps 11.5.10, GL, PO, AP, AR, Oracle 9i, Pl/SQL, SQL Plus, SQL Loader, Reports 6i, TOAD, Discoverer 10g, Windows XP, UNIX, XML Publisher

Confidential

Oracle DBA

Confidential , wholly owned by the Government of Bahrain, is engaged in the oil industry including exploration and prospecting for oil, drilling, production, refining, distribution of petroleum products and natural gas, sales and exports of crude oil and refined products.

Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products
• Establish and maintain sound backup and recovery policies and procedures
• Defined project requirements, analysis for best practices.
• Implemented and maintained database security create and maintain users and roles, assign privileges
• Responsible for designing, enhancement, maintenance, monitoring, performance tuning, configuring, object creation and backing up of databases.

Performed Business System Analysis on existing production systems and provided recommendations for improving Performance New Features

Worked on Oracle Non-Oracle Database Management products for administration/backup-recovery/performance tuning

• Directing leading a backend team for ensuring seamless operations services to clients. Heading database administration functions and complying with all rules regulations pertaining to the same.
• Responsible for database installation, database upgrades and software maintenance.
• Documented and complied with company policies and standard operating procedures.
• Manages and maintains the data dictionaries.
• Handled DB Operations and involved in creating / upgrading/ configuring Oracle DB
• Involved in code migration, database change management and data management through the various stages of the development life cycle

Environment: ORACLE 8i, 9i, SQL Server 2000/2005, Oracle Forms, Reports, SQL, PL/SQL, VB 6.0, Crystal Reports, Windows XP, Linux

Confidential

Database Analyst

Fortuna provides Business solutions and helps its clients to focus on strategic issues that they must deal with before technology investments deliver value.

Responsibilities:

• Directing leading a backend team for ensuring seamless operations services to clients.
• Handling Database Operations and creating / upgrading/ configuring databases 8.0 8.1.6 Oracle Software.
• Perform application tuning and performance monitoring
• Involved in code migration, database change management and data management through the various stages of the development life cycle
• Setup and maintained documentation and standards

Environment: Oracle 8i, 7.3, Forms 6i Reports 6i, SQL/PLSQL, Linux Windows 2000, RS6000, AIX

Confidential

Sr. Analyst Programmer

Environment: Oracle 8.0 7.3, Forms 4.5, 5.0 Reports 2.5, 3.0, SQL/PLSQL, Windows 2000, RS6000, SQL Loader, Visual Basic 4.0, MS Access