Chase Paymentech Work Values

Daily Duties at Chase Paymentech:

Responsibilities: • Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g. • Extensive experience in RMAN recovery testing, and stand alone database • Refreshed the Testing environment from production environment for testing purposes • Creating Cloned Database using RMAN on remote Server • Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes • Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification • Wrote shell scripts for purging trace files , alert log and network log files in Linux boxes which is used as standard script across all the databases • Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler) • Installed the Oracle software using silent feature and also created databases • Supported & maintained the Production/Development databases on various servers • Extensively worked on setting up auditing in many databases we supported • Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints. • Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins • Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities • Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication • Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration • Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK • Index creation and management for optimization of DB Processes • Extensive use of tools like TKPROF, Statspack, SQL advisor fortuning application and instances • Used ASH for session monitoring and performed memory management • Involved in I/O tuning by moving data files and redo log files to faster disks

What they like about Chase Paymentech:

Working for a company with an emphasis on social values and helping society is a clear and important priority for you - a critical factor in who you choose to work for. In contrast to other factors, you place an organization's reputation for fairness and concern for the community above most other aspects of the company. As you search for a new job opportunity, it is usually possible to find out if the company is involved in the community and/or if it is addressing problems and issues in society. Pay special attention to non-profit organizations and those specifically involved in social action. Moreover, speaking with current and former employees should enlighten you to perceptions of the fairness of the company's leaders and the treatment of employees.

Tags

MYSQL, JAVA, LINUX, SQLPLUS, STARTPACK, BACK UP AND RECOVERY, GRID CONTROL, TOAD, DISASTER RECOVERY PLANNING, UPGRADE, MIGRATIONS

Skills

Worked extensively on Oracle 11g and 10g involving database administration, support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security

These are some of the questions we asked our climbers about their experiences with Chase Paymentech: