Pacific Systems, Inc. Work Values

Daily Duties at Pacific Systems, Inc.:

• Managed data migration and Web (Web 2.0) based development projects supporting e-commerce, e-stores, electronic transactions, data mapping, and EDI technology. • Led the efforts of installing and maintaining database management software and Provide 7x24 DBA production support, worked with DBA team for production on call support rotation. • Supported the data loads into the databases. And ensured that the application, and any enhancements, interacted efficiently with the database. • Developed and implemented database performance monitoring process and analyzed monitoring data for performance optimization opportunities. Created/Implemented database maintenance plan to ensure data integrity. • Managed the on-site backup and recovery process and supported the off-site backup and recovery teams. Planned for and executed any required database upgrades and migration. • Solid skills in database performance factors, monitoring tools and tuning procedures. • Strong Database Management skills, including backup and recovery procedures. • Knowledge of fault detection and resolution processes. • Closely monitored database performance; identified problems and implemented solutions; ensured the database is running at optimum speed and with efficiency. • Involved in the designing, implementing and maintaining an Oracle database. • Applied Knowledge of database design standards (OFA) and database management systems (DBMS) to the resolution of daily database issues. • Facilitated issue resolution for all production issues in the databases. This included being on-call, made critical decisions and worked closely with DBA and tech managers on how issues are resolved. • Backup and recovery of databases: automated backups on Windows NT and UNIX servers. • Periodically collected and evaluated database performance statistics and tuned the database using Stats packs, diagnosing problems using ADDM, etc. • Created database users, both system and object level roles and privileges for these users. Created, modified and assigned profiles. • Administered OS file system utilization, monitoring, swap usage, CPU utilization, file I/O, and network tracing for Oracle and recovered corrupted data blocks. • Killed various users’ sessions due to locking issues and abnormal resource consumption. • Worked with application developers to effect database changes to meet business requirements. • Performed daily and regular checks on alert logs, trace files and resolved issues, Also did check to ensure data consistency and integrity. • Managed various database structures: Table spaces, data files, control files, redo-logs files and Rollback segments using SQL*PLUS and OEM GUI tools. • Wrote SQL scripts to monitor table space and extent growth. • Ensured efficient management of Oracle database storage (extents, segments, rollback segments, temporary segments etc.) for optimal database performance. • Performed object level, session, logon and system wide database audits of users to ensure user compliance with corporate security and controls standard, and SOX Act. • Developed, deployed and maintained database backup/recovery environment (Cold and Hot) using RMAN and scripts. Responded quickly to refresh data; verified correct backup strategy; developed recovery procedures; supported recovery from loss of data caused by user or system error. Refreshed data from one environment to another at the request of the application development staff; provided application development staff optimal development environment with current data. • Provided database support to developers, QA teams, and production users. • Created and managed stored procedures, functions, packages, triggers, views, tables, indexes, table partitions, partitioned indexes, synonyms and dblinks.

What they like about Pacific Systems, Inc.:

A hiring company that offers alternative approaches to pay, performance bonuses, and/or equity in the firm is very attractive to you. You're generally less interested in working for an organization offering only traditional, salary-based compensation, one with limited opportunity to acquire equity in the firm, or one that does not actively promote skill development. In addition, you are more likely to choose a company that offers a variety of internal career options, with defined career paths. You view the learning of new skills and development of your expertise as key to your career advancement. These aspects of an organization may become even more important to you as you progress in your field, and are especially critical if you change career or occupation.

Tags

SQL, Oracle DBA, Linux, Unix Systems Admin, ERP-CRM-OEM, Solaris, Materials Science, Magnetic Materials, X-ray diffraction, Neutron diffraction, Mossbauer spectral studies, Mechanical properties of materials, Basic engineering, Statistics, Data analysis, Data modeling, Computational mathematics

Skills

Presentation, Unix OS Admin, Oracle DBA, SQL, MS Access, Peoplesoft, Visual Basic, HTML, C++ (basic), Basic Engineering, Data Analysis, Computational Mathematics, Statistics, Network Protocols: TCP/IP, FTP, SFTP, SCP, SSh, Telnet, RDBMS: Oracle 10g, 11g; MS Access, SQL*PLUS, UNIX SHELL SCRIPT, BATCH SCRIPT, Windows Power Shell Script, FORTRAN, SQL*PLUS, PLSQL, Experimental Materials Science research, Linux, Solaris, Materials Science research, X-ray diffraction, Neutron diffraction, Mossbauer spectral studies of magnetic materials, Thermo-magnetic analysis, Software engineering, Windows 2000, NT, XP, Vista, Windows 7

These are some of the questions we asked our climbers about their experiences with Pacific Systems, Inc.: