We provide IT Staff Augmentation Services!

Performance Engineer/exadata Dba /technical Architect Resume

SUMMARY:

  • Over thirteen years of extensive knowledge and experience in Enterprise IT Systems, Engineering and Business, focusing on the RDBMSs as well as Middleware & other back - end technologies.
  • Excellent oral/written communication skills and a great team player with a fast learning curve, excellent diagnostic and problem solving skills who can work perfectly under very stressful conditions in which speed, accuracy and deadlines are of primordial importance.

SPECIALTY:

  • Enterprise Architecture Design/Configuration/Implementation
  • Oracle Database versions 8i/9i/10g/11g single instances, RAC, Exadata/Exalogic Configuration, Implementation, Deployment & Administration as well as complete Systems Analysis & Evaluation, Performance Engineering, Capacity Planning & Project Management.
  • Infrastructure/Application and Database Performance Engineering.

SOFTWARE/HARDWARE PROFICIENCY:

Platforms/Operating Systems: Oracle Exadata/ExaLogic, Windows XP, NT, 95, 98, 2000, 2003 Server, MSDOS, VMware Server versions 1.x & 2.0, Citrix gateway, Linux (Red Hat, CentOS) versions 4.x & 5.x and UNIX (AIX 5.2 & 5.3, HP-UX B.11.11& SunOS 5.x ).

Other Software: MS Office Suite, ChecksNet, Point, Lotus Notes 6.5

Databases: Oracle Versions 8i, 9i, 10g & 11g, MySQL Database, MS SQL Server 2005, MS Access

Development tools: BASIC, SQL, SQL*Plus, PL/SQL, Shell Scripting (Windows/UNIX), C#, J2EE, HTML, XML, Web Services

IDEs: Visual Studio.NET 2005/2008, Eclipse 3.4.1, NetBeans 6.5, Tomcat

Database Administration/Monitoring/Tuning Tools: SQL & PL/SQL, OEM Client 9i/10g, OEM Database Control 10g/11g, OEM Grid Control 10g/11g, TOAD version 9.5 dbXpert for Oracle versions 7 & 8, DBArtisan version 8.5.x

Database Backup/Recovery Tools: RMAN, BMC SqlBacktrack for Oracle versions 6.5 & 6.8

Hardware and Infrastructure: PC/IBM compatibles

OTHER SKILLS:

  • Fluent in written/spoken English, French and Pidgin English
  • Technical experience in Industrial Engineering
  • Strong oral/inter-personal communication skills
  • Excellent customer service/marketing skills
  • Strong leadership, problem solving, multi-tasking, planning and organizational skills.

EXPERIENCE:

Performance Engineer/Exadata DBA /Technical Architect

Confidential, Milwaukee, WI

Responsibilities:

  • Develop, update, and maintain testing standards and procedures.
  • Develop test scripts, test conditions, input test data, and expected results for performance, user acceptance, operational acceptance and technical architecture tests.
  • Refactoring Java code for Performance
  • Develop test scripts, test conditions/cases, input test data, and expected results for performance, user acceptance, operational acceptance and technical architecture tests.
  • Document defects using the project’s defect management tools.
  • Work with the application team to resolve any issues that arise out of the testing process.
  • Oracle Database Performance Optimization by analyzing Oracle AWR reports & providing clear cut recommendations.
  • Succinctly analyze various performance tests carried out to provide recommendations for performance improvement, both on the Database as well as the Application.
  • Validate product fixes.

Confidential

Senior Oracle DBA

Responsibilities:

  • Develop test scripts, test conditions, input test data, and expected results for performance, user acceptance, operational acceptance and technical architecture tests.
  • Develop, update, and maintain testing standards and procedures.
  • Record problems and issues in accordance with the project's problem and issue management plans.
  • Document defects using the project’s defect management tools.
  • Work with the application team to resolve any issues that arise out of the testing process.
  • Succinctly analyze various performance tests carried out to provide recommendations for performance improvement, both on the Database as well as the Application.
  • Oracle Database Performance Optimization by analyzing Oracle AWR reports & providing clear cut recommendations.
  • Participate in the release control process (when the application is transferred from the build team to the test team) to ensure that solutions meet business requirements.
  • Validate product fixes.
  • Inform the test lead of any issues that may affect the schedule, budget, or quality of the product or the testing process.

Confidential, Philadelphia, PA

Senior Oracle DBA

Responsibilities:

  • Design and validate the infrastructure necessary for the implementation of the PegaRules Process Commander (PRPC) Application from Development to Production.
  • Install and configure the following Pegasystem’s frameworks on enterprise platforms (RHEL6.2 with Oracle Database 11gR2 and Oracle WebLogic Server 11gR2) from Dev to Prod env’ts:
  • PegaRules Process Commander (PRPC) 6.2 SP2
  • Decision Strategy Manager (DSM) both 6.2 SP1 & 6.2 SP2
  • Next Best Action Advisor (NBAA) 6.2 SP1
  • Technical Lead responsible of the Integration Design (Technical Architecture)
  • Supports project lead in ensuring a consistent implementation of technical components across the three technical streams: core, data and logic
  • Participates in the definition of hardware and software architecture in terms of:
  • Validating environment sizing & capacity planning
  • Validating Database installation & Application Server installation to meet PRPC, DSM & NBAA requirements.
  • Basic and advanced configuration of the above application components
  • Executes performance analysis and application tuning
  • Manages software releases and deploys ensuring the consistency of all the available environments
  • Prepares installation guide
  • Monitors and supports the operations architecture of hardware and software platform
  • Applications: Pega PRPC, Oracle WebLogic 11gR2, Oracle database server
  • Programming languages: J2EE, Java, SQL, PL/SQL, Unix Script, XML
  • OS: RHEL6.2
  • Protocols: SOAP, SSL, HTTP, T3, FTP, SSH

Confidential, Reston, VA

Senior Oracle DBA/Technical Architect

Responsibilities:

  • Work closely with Application/Middleware administrators to manage/maintain a total of 140 CRM databases for NII holdings from Development to production, via end-to-end testing, UAT & Hotfix.
  • Redesigned backup & recovery for the Development & Test environments to resolve prior ever-present archiving issues.
  • Redesigned archiving strategy for all Dev & Test environments to mitigate downtime resulting from archiving issues.
  • Designed & implemented Advanced partitioning & purging strategies for the various CRM applications' data to handle automated data purging (markedly reducing downtime from DB bounces), as well as simultaneously improving DB performance.
  • Fully participated in an overall & holistic performance testing, tuning & engineering effort (using Oracle grid Control - running & interpreting AWR & ASH reports, adjusting DB initialization parameters as needed), in a bid to achieve optimal performance of CRM applications in test & hotfix env'ts prior to deployment to Prod.
  • Implemented tablespace re-org for better manageability & performance improvement.
  • Trouble-shot & resolved DB issues as required in a high-pressure time-sensitive env't.

Confidential, Los Angeles, CA

Senior Oracle DBA

Responsibilities:

  • Evaluate and Analyze the Clients' Application & Database Design.
  • Review business requirements, technical requirements, and existing architectures.
  • Assess architecture quality, technology choices, risks, and gaps.
  • Gauge current application design solution suitability and compare to industry practices.
  • Propose alternate design strategies/solutions to improve performance.
  • Enterprise Performance Engineering Technical Architect responsible for providing technical vision, resource direction and thought leadership for application and infrastructure projects through the software development lifecycle for projects initiated for Confidential at Confidential .
  • Direct technical leadership responsibility for ongoing application performance testing, turning, modeling and performance enhancement recommendation according to business need and defined operational level commitments for each functional project.
  • Technical direction and delivery of the annual Performance Engineering Technology roadmap, including patching, security vulnerability and new performance testing and performance commitments for each functional project.

Sr. Oracle DBA Contractor

Confidential, Washington, DC

Responsibilities:

  • Work closely with Linux System/Storage Administrators to Configure, Implement & Deploy Oracle Single Instance 11gR2 (11.2.0.1) on RHEL5.x using filesystem from development to QA via TEST environments
  • Implement UNIX shell scripts for monitoring/maintaining newly configured databases.
  • Administer already existing Oracle databases from DEV to PROD via TEST & QA (supporting five major IT projects for the Confidential, Washington, DC).
  • Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control, TOAD for Oracle, DBArtisan & SQL*Plus.
  • Work closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TEST & QA following requests/demands from the development team.
  • Backup/Recovery Configuration of Oracle 9i/10g/11g single instance/RAC databases using Oracle RMAN.
  • Setup daily datapump exports/imports via crontab in DEV & TEST environments.
  • Configure/Implement Oracle Streams with Oracle10gR2 as source & Oracle 11gR2 as target.
  • Migrated over ten of the World Bank’s Production databases from lower versions of Oracle (9.2.x to 10.2.0.2) to Oracle 10.2.0.4 on new high availability servers (AIX 5.3 & RHEL5.5, using VERITAS clustering) as a part of the Bank’s GSR (Global Strategic Re-alignment) project for the 2010 financial year.
  • Upgraded ALL Oracle databases from versions 10.2.0.x to 11.2.0.2, both single instances and RAC running on AIX 5.3 and RHEL5.x.
  • Configured Oracle Golden Gate replication for newly upgraded 11.2.0.2 databases for DR purposes.

Senior Oracle DBA

Confidential, Suitland, MD

Responsibilities:

  • Worked closely with Linux/UNIX System/Storage Administrators to Configure, Implement & Deploy Oracle RAC 10g (10.2.0.4) on RHEL4.7 using Automatic Storage Management (ASM) and Oracle Clusterware.
  • Configure. Implement & Deploy Oracle 9i (9.2.0.8) & Oracle 10g (10.2.0.4), single instances on SunOS 5.9 & IBM AIX 5.x using filesystems for storage & VERITAS Clustering for high availability using IBM’s HACMP
  • Create oracle databases (both single instance and RAC) on configured servers using both the DBCA & Database creation scripts.
  • Setup advanced database/application auditing, both by use of Oracle SQL & top notch UNIX shell scripts as well as Transparent Data Encryption & Strong Authentication using Oracle Advanced Security.
  • Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
  • Developed UNIX shell scripts for database reporting on daily database activities as well as for monitoring.
  • Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
  • Backup/Recovery of Oracle 9i/10g single instance/RAC databases using Oracle RMAN.

Senior Oracle DBA

Confidential, MD

Responsibilities:

  • Primary Oracle DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration, troubleshooting & tuning of 20 Oracle databases (all 10g, single instances as well as RAC) all running on IBM AIX 5.2 & 5.3. Database sizes range from 4GB to 2TB (in OLTP, ODS & Enterprise Data Warehouse - EDW environments).
  • Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (8i, 9i & 10g single instances & RAC) running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.
  • Configure and install Oracle 10g (10.2.0.1 and 10.2.0.3), both single instances and RAC on AIX 5.2/5.3 using Automatic Storage Management (ASM) and Oracle Clusterware.
  • Configure and install Oracle 9i (9.2.0.1 and 9.2.0.7), both single instances and RAC on AIX 5.2/5.3 using Raw devices and IBM’s HACMP.
  • Create oracle databases (both single instance and RAC) on configured servers using both the DBCA & Database creation scripts.
  • Configure/Implement Oracle DataGuard 10g (both Physical & Logical) for DR purposes.
  • Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).
  • Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
  • Data migration between databases using both Oracle 9i and 10g export/import utility and Oracle 10g exp/imp data pump.
  • Analyzing schema of databases created to collect statistics using the DBMS STATS package.
  • Use AWR/ADDM for 10g Statistics management & database tuning following creation of new databases and periodically thereafter.
  • Troubleshoot installation errors both independently and with Oracle support (via Metalink)
  • Application of Oracle software patches when/where necessary.
  • Backup/Recovery of Oracle 10g RAC databases (with ASM) using both BMC SqlBacktrack & Oracle RMAN.
  • Backup/Recovery monitoring and reporting using both BMC SqlBacktrack as & Oracle RMAN
  • Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.
  • BMC SqlBacktrack install/upgrade (from version 6.5 to 6.8) and backup/recovery testing of the upgraded tool.
  • IBM TSM (Tivoli Storage Manager) install/upgrade from version 3.1.00 to version 4.0.10.
  • Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
  • Create database Objects, Tablespaces, Schemas as needed.
  • Schema migrations from Development to Production via Tech Test environments.
  • Database refresh from Production to Tech Test as needed.

Oracle DBA (Consultant)

Confidential

Responsibilities:

  • Worked in a team of IT specialists to develop and manage over 40 databases (Oracle8i, 9i and 10g database instances on RHEL 4.x) and Windows 2003 server platforms), with sizes ranging from 2GB to 1/2TB with the following responsibilities:
  • Collaborate with the System Administrators to configure both software and hardware requirements necessary for the proper functioning of the Company’s Oracle databases.
  • Create and configure Oracle Databases using both the DBCA and manually using database creation scripts (CATALOG.SQL and CATPROC.SQL scripts included).
  • Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement.
  • Set up, configure and troubleshoot client-server connectivity using both the Net Manager and the Net Configuration Assistant.
  • Install and configure Oracle 9i Client Enterprise Manager (OEM) and 10g Database Control.
  • Create database Objects, Tablespaces, Users, Database schemas, profiles, granting privileges and roles.
  • Reorganizing and restructuring of existing Databases to meet the OFA standards and for performance optimization.
  • Resizing, relocating and duplexing redo logs to either reduce log switching or eliminate contention.
  • Analyzing Tables, Indexes and Clusters against chained and migrated rows and providing solutions.
  • Providing performance tuning activities to improve performance of the Oracle databases. Tune databases through initialization parameters, SQL statements (using EXPLAIN PLAN), and memory by performing routine checks on the SGA, CPU, logical and physical I/Os and contention.
  • Conducting disk load balancing procedures to reduce I/O response times and contention.
  • Upgrade existing databases by applying Patches.
  • Analyze data growth trends for capacity and resource planning.
  • Reorganize databases: Defragmenting, rebuilding and/or relocating indexes, and rollback segments, etc.
  • Designed, tested and implemented backup and recovery solutions including automated daily hot backups and cold backups depending on criticality of the Database. Established backup and recovery procedures and maintenance to support point-in-time recovery of the database which includes using RMAN and shell scripts.
  • Evaluated and recommended tools for database monitoring and remote administration of Oracle Databases.
  • Managing/modifying database security and database schema.
  • Responsible for overall strategic planning & redesign of databases: Requirements gathering and Analysis, Design, Test and Implementation through the various phases of the SDLC.
  • Help other team members and project managers set client expectations regarding the efforts necessary to achieve change.
  • Worked with application developers to address and clarify data requirements to resolve technical and functional issues.
  • Enforced corporate business rules through adequate user/resource/object management.
  • Security implementation through basic and advanced security techniques like applying recent patches and upgrades, appropriate user grants, permissions and profile management.
  • Reconcile functional and technical problems through interaction with the client by researching and identifying the defined issue and by fully testing and confirming possible solutions to the problem.
  • Provide expert functional and technical assistance in a timely and efficient manner.
  • Provide a 24/7 availability and coverage through the use of emails, cell phones, and PDAs for mission critical Databases.

Technical Business Analyst

Confidential

Responsibilities:

  • Identify average to complex business requirements
  • Evaluate alternative solutions and translate solutions into specifications suitable for the development or maintenance of applicable systems.
  • Translate end user computing requirements for use by the Corporate Technology Department, with emphasis on Application Development areas.
  • Develop, implement and review test plans.
  • Communicate with team, customers and brokers when changes occur.
  • Assist in development of project plans.
  • Execute tasks resulting in documentation of an existing or proposed business process in a prescribed format.
  • Execute programs using predefined business cases against a test environment for purpose of debugging code or system testing applications.
  • Activities in support of the completion of approved business initiatives. Activities include review and update of project deliverables, status reporting, issue tracking and coordination with other groups.
  • Execute tasks requiring meeting with functional system users to document business processes and define system functionality.
  • Execute tasks requiring creation of written documents in support of system code, design or testing.
  • Programming, debugging and testing of existing applications that run in production environments for purposes of remediation of system errors or to extend application life span.

Sr. Desktop Engineer

Confidential

Responsibilities:

  • Supported a varied user group on both hardware and software, as well as supporting desktop applications.
  • Provided both end-user and remote support on Windows 2000, XP and NT.
  • Troubleshot and resolved both hardware and software issues on desktop level, including upgrading or replacing hard drives, Motherboards and System Memory.
  • Responsible for maintaining hardware, software and peripheral devices on various platforms and environments.
  • Support both hardware and software in an active directory environment.

Technical Manager

Confidential

Responsibilities:

  • Worked with a team of experienced engineers in carrying out feasibility studies, develop and review designs, cost estimates and progress evaluation for an Industrial Complex designed for Agro-industrial processing.
  • Supervised a team of three engineers, twelve technicians and twenty laborers involved in the construction and installation of all the equipment necessary for the successful operation of the agro-industrial complex. Successfully cut down equipment installation costs by over 20% by proposing and implementing more feasible and cost-effective installation methods.
  • Responsible for the setup, organization and smooth running of the company’s Information Technology and Engineering divisions.
  • Responsible for the design and development of MS ACCESS database applications using MS application development tools.
  • Supervise a team of six IT specialists, responsible for developing forms and generating financial reports and helping management in several decision-making processes.

Project Manager/ Consultant

Confidential

Responsibilities:

  • Elaborated and Negotiated for Sustainable Development Projects
  • Planned and Monitored the execution of all infrastructure-based projects.
  • Initiated and Facilitated Workshops and Seminars, as well as researched and investigated new projects within marginalized communities.

Hire Now