Sr Developer/DBA
Resume:
Alpaslan Manti
*********@***.***
* ***** ******, *********, **** Island, New York 11717
OBJECTIVE
To find a position in Web Design and Web Management in New York City and Long Island.
SUMMARY
Web Design with Database SQL Server 2005.
Implementing on a production Web Hosting Server,
LfcHosting.com. .NET Framework 2.0 with
Visual Studio 2005-2010 professional,Microsoft Expression Web3 ASP.NET 2.0 and Visual Studio 2005.
Adobe CS4(Flash,Photoshop,Dreamwaver,Fireworks)
Oracle 10g DBA I-II
Successful and Experienced IT Professional seeking challenging position in Oracle Administration.
JOB SUMMARY
* More than 6 years of Oracle Application and Database Administration experience on variety of Database versions 7,8i,9i,10g on unix (Solaris, HP-UX, AIX), Linux, Windows NT 4.0/2000 with HRMS, (HR, Payroll), Financials(AP,AR,GL,FA), Order Management, Compensation, modules using Apps (11.5.8, 11.5.9, 11.5.10), Oracle Application Server 9iAS, Developer 2000 6i (Forms 6i and Reports 6i, Net8, Sql*Plus, PL/SQL, Stored Procedures, DB Triggers etc.
* Experience in Oracle Applications 11i Installations, configuration, Cloning, Security, Patching, Upgrades, Maintenance using AD and other utilities.
* Extensive use of 10G Oracle Enterprise Manager (OEM) and Oracle Applications Manager (OAM) for Performance, Administration and Maintenance of Databases and e-Business Components.
* Experience in setting up SOX controls on the ERP system from technical perspective.
* Managed DSS (Decision Support System) and OLTP (On Line Transaction Processing system) full life cycle projects with about 10 databases at one time, biggest database around 800 GBytes (800GB) supporting both production developments on Unix and Windows NT/Windows 2000.
* Oracle Server Installations/Upgrades, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Security Administration, Data Architecting, normalization/de-normalization, Data Warehousing, Multithread Servers, Distributed Databases for Oracle 8i/9i Databases, table partitioning and Oracle Standby Server.
* Expert in packages Oracle Enterprise Manager, TOAD, SQL Navigator, RMAN, Apache, HTML, RMAN, Schema Manager. Working in environments constituting iAS, Oracle Self Service Web Applications, XML, Discoverer (3.x, 4i).
* Specialization in Administration of Oracle Database, Data Warehouse, Reporting tools, Data Modeling and Data Architecture.
* Representing the DBA group on Projects from planning Stage to the Go-Live stage, meeting expectations and deadlines.
* Highly efficient and experienced working in huge environments across multiple team (Development, Functional and Business) and at the same time, maintaining a satisfactory relationship.
* Working pro-actively with Unix Support, Web Group and Migrations Team to make sure all operating system and migrations issue are addressed in a timely passion.
* Proactively engaged in research and investigation of new features for database and the application level.
SKILLS
RDBMS: Oracle 10g, 9i, 8i, MS Access
RDBMS Tools: Oracle Enterprise Manager (OEM), SQL*Loader, Oracle Schema Manager, RMAN, Space Manager, Net 8, SQL Trace, TKPROF, Stats Pack, TOAD, SQL Navigator
Applications: Oracle 10.7, 11.0.3, 11.5.8, 11.5.9, 11.5.10, 11.5.10.2 9iAS, Forms6i, Oracle Application Manager, Oracle Webserver
Operating System: Sun Solaris, HP-UX, Windows NT4.0/2000, Citrix, Veritas Clusters
Hardware: Sun Sparc E6500, HP9000, Compaq, EMC
Languages: SQL*Plus, PL/SQL, C, Pro*C, Cron Processes, Unix Shell Scripting, csh, ksh, HTML, XML
Software Tools: Apache, IAS, 9iAS, Oracle Portal, Oracle Internet Directory, Developer 2000 (Forms6i, Report6i), TOAD
PROJECT EXPERIENCE
Oracle Applications DBA/Oracle DBA August 2006 - Present
Xerox, Wilsonville OR
Project: Installation, Setup, Implementation and maintenance of Oracle Application 11.5.10 including 9iAs 1.0.2.2, Oracle 9i, 8.0.6, Oracle Enterprise Manager, RMAN, Code migration & management, Cloning Oracle Applications. Production Support of Financial System, Migration of Oracle Application production from Single node to multinode architecture
Software: Oracle Application 11i (11.5.10), Oracle (8.0.6/9i, 10g), Unix Shell Scripting, Form 6i, CRON jobs, TOAD, Quest Spotlight, ADI (Application Desktop Interface)
Hardware: Sun 4800, Sun 3960 (T3 drives)
OS Sun Solaris 2.9
Environment: Sun Solaris 2.9, 10 oracle Financial Instances including development, test, patch and production.
DB Size: 700+ GB, Users: 450
? Managing 100+ databases.
? Providing Production support (24*7) and troubleshooting user (remedy) tickets in Production, Test and Development instances.
? Upgraded Oracle Applications from 11.5.8 to 11.5.10
? More than 6+ Database migrations from Oracle 8i to 9i and 10g.
? Experienced with Shared Appl Top
? Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data.
? Expertise in Concurrent managers and monitoring of the concurrent manager operations.
? Highly experienced in Investigating performance issues for Oracle Applications(Concurrent Program/Reports)
? Troubleshooting Apps components like Forms, Apache and Concurrent Managers.
? Recompiling and maintenance of forms, report with Adadmin and from command line.
? Exposure to Oracle Application tools and ad ulitlities like adpatch, adadmin, adconfig, adctrl etc. for the management and maintenance of Applications.
? Application user creation / responsibilities assignment, applying minipacks, maintenance pack, family pack and one-off patches.
? Managing Workflow and its components through OAM.
? Highly experience in Clone of Oracle application environment using Rapid clone and adconfig.
? Copy/clone of RDBMS oracle home
? Database Refresh/clone doing complete/incomplete recovery using cold and hot backups.
? Scheduling and studying Statspack/AWR report and taking corrective action.
? Implemented Dataguard for production system incase of a disaster recovery.
? Managing and maintening hot, cold and RMAN backups for disaster recovery and making sure the mean-time to recover is as low as possible.
? Installation and maintenance of the intelligent agent on multiple servers for leveraging the monitoring ability of Oracle Enterprise Manager.
? Knowledge of Dataguard/Standby database.
? Upgraded the OMS from 10.2.0.* to 10.2.0.3.
? Upgraded the Agent from 10.2.0.* to 10.2.0.3.
? Configuring OEM to monitor targets.
? Handling data mirror and its services/components
? Applied RDBMS, CPU/Quarterly patches using Opatch.
? Experience in Oracle RDBMS software installations.
? Solve Locking issues at Database/ Apps level.
? Set up auditing and study the audit trail tables.
? Monitoring and troubleshooting top cpu/memory consuming processes
? Performance Tuning, Memory (SGA) Tuning, etc
? Maintaining Hit ratios of Oracle Database for optimal performance
? Identifying top sqls/sessions and tunning.
? Monitor alert logs, OEM and system alerts, acting on the results.
? Tracing Concurrent requests, forms, database session.
? Managing Tablespaces and Datafiles
? Gather stats using DBMS stats and FND stats to improve performance.
? Setting up profiles for users.
? Configuring listeners with password.
? Created a number of database instances for development, testing and production.
? Created and managed the Database objects and schemas
? Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
? Configure new Printers at Apps level.
? Configuring Java on a 8.1.7 database.
EXPERIENCE
Oracle Applications DBA/Oracle DBA August 2003 - July 2006
Dell Financial Services, Austin TX
Project: Installation, Setup, Implementation and maintenance of Oracle Application 11.0.3, 11.5.9, 11.5.8 including 9iAs 1.0.2.2.x, Oracle 9i, 8i, 8.0.6 Oracle Enterprise Manager, RMAN, enabling Multilanguage support, autoconfig, Cloning Oracle Applications. Production support, single node to multimode migration, installation and configuration of Oracle Discoverer 4.1.48, Installation and maintainance of datawarehouse databases running on oracle 9i.
Software: Oracle Application 11i (11.5.9, 11, 5, 8), Oracle (8.0.6/8i, 9i), Unix Shell Scripting, Perl, SQL Scripting, Form 6i, CRON jobs, TOAD
Hardware: Sun 4800, Sun 3960 (T3 drives)
OS Sun Solaris 2.8, Windows NT/2000
Environment: Windows NT/2000, Sun Solaris 2.8, 8 Oracle Financial Instances including development, test, patch and production, datawarehouse instances running on 9i databases using Informatica (ETL).
DB Size: 500+ GB , Users: 700
Responsibilities:
? Complete cycle of implementing, setup and support of Oracle application 11i.
? Patching Oracle application. Including applying maintenance patch for AR modules.
? Creating users, assigning responsibilities, Managing Concurrent processing, data auditing.
? Using AD utilities viz. adadmin, adpatch, adctrl etc to manage Oracle Application.
? Installation of Oracle Application 11i (11.5.9, 11.5.8).
? Managing Workflow and its components.
? Configuring Oracle Application Manager.
? Configured AUTOCONFIG for handling customizations.
? Implementing customized AUTOCONFIG for custom variables and custom folders.
? Configuring ORACLE Process, Parameters & Multithreading.
? Moving development and testing codes to various instances and testing them.
? Optimising resource utilization in the existing servers.
? Cloning Oracle Applications with rapid clone for development and testing and incorporating customizations. Using autoconfig to configure Oracle Applications.
? Setting up user to login to apps. Jinitiator Install and configurations.
? Tuning Oracle server along with Operating System to obtain optimal performance.
? Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
? Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
? Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process.
? Tuning performance monitoring and tuning, Optimization, Parameters, Tuning Issues, Bitmap indexes, Hash Joins.
? Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
? Cloning databases.
? Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security
? Taking Hot and Cold Backups, Exports, FTP etc.
? Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
? Applying minipacks
? Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
? Writing Unix shell scripts for backup and recovery, Import and export procedure.
? Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
? Defragmentation of database using export import.
? Removing row chaining, row migratation for better performance.
Oracle DBA
Alpa Consultancy
Istanbul, Turkey March 2002 - June 2003
Project: Installation, Setup, Maintenance and Upgrade of Oracle Server 9i, Oracle Enterprise Manager, Space Manager, RMAN, CITRIX
Hardware: HP9000
Operating System: HP-UX 11.0
Environment: Windows NT/2000, HP-UX 11.0, Veritas, Quick IO
Software: Oracle 8i, Pro*C, C, Unix Shell Scripting, Perl, SQL Scripting, Forms 4.5, UNIX CRON jobs, Oracle Application Object Library (AOL), TOAD
Database Size: Up to Size # 250 GB, Users- 175
Responsibilities
? Software Development and Testing.
? Installation, Upgrade and Configuration of Oracle 8i.
? Installing and configuring Recovery Manager (RMAN).
? Extensive Performance Tuning, Memory (SGA) Tuning, Tuning Concurrent Managers, etc.
? Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
? Applying patches both Server side and Client side.
? Setting up new environments (Development, Production etc)
? Designed standby database model for disaster recovery.
? Taking Hot and Cold Backups, Exports etc.
? Setting up and Installing Oracle Web Application Server
? Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
? Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
? Data Modelling, Database Design and Creation of Data Warehouse.
? Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.
? Monitor disk usage and expand and/or move datafiles as needed.
? Disaster Recovery drills.
? Identify run away sessions occupying more cpu.
? Create/Refresh and upgrade databases.
? Kill processes due to locks.
? Compile invalid objects and create database links.
? Gather Statstics at database/schema level.
? Apply Databases CPU patches.
? Monitor backups.
Web Designer: Survey Design, Photo Album, Web Shop
I designed websites for an Exterminating
Services Company, Real Estate Agency, Online Retail Company.
http://www.jgcleaning.com
http://www.jgvhome.com
http://www.oracledbasupport.net
http://www.fumexpro.com
http://www.eyupsultanusa.org
http://www.ayzitemlak.com
http://www.toraktarim.biz
http://www.demirhisarkoyu.com
http://www.sebelek.com
EDUCATION
Karadeniz Technical University, Trabzon, Turkey, Forest Engineering, 1990-1994
Computer Career Center, Garden City, NY, October 2001-February 2003
LAN Operating System, Networking, Windows 2000 Server, Microsoft Exchange 5.5
Micropower Computer Institute, Hauppauge, NY, January 2007 - October 2007
Web Power Course
Web Design: HTML, Javascript, Cascaded Style Sheets,Jquery
Database: SQL Server 2005
Web Hosting Server: LfcHosting.com, Control Panel
.NET Framework 2.0: Visual Basic 2005, ASP.NET 2.0:
Membership and Identity, Themes, Events, ADO.NET 2.0, Roles
and Profiles, Web Services, Database Design,
Gridview, User Control, E-commerce, Wizard Control, Validation, SqlDatasource
Design Software: Visual Studio 200*-****-**** pfoffesional, Adobe Photoshop,
Selteco (Alligator Flash Designer 7, Banner Shop GIF
Animation 5, Button Maker, Flash Screen
Builder, Image Mapper, Menu Maker 4, Photo Lab 2),
Contact this candidate