SUMMARY:

A challenging position within the field of information systems as an IT Technology Specialist using my diverse information technology skills that will offer an opportunity for rapid advancement.

TECHNICAL SKILLS:

ORACLE12c, ORACLE11g, ORACLE10g, EXADATA, GOLDEN GATE, DATA DOMAIN, DD BOOST, PEOPLESOFT7x - 8x, WINDOWS NT, WINDOWS95/98, WINDOWS 2000X, AIX, SUNS SOLARIS, HPUX, RED HAT LINUX

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle PeopleSoft DBA

Responsibilities:

• Performs highly complex data management functions at an enterprise level; installs, integrates, upgrades and manages PeopleSoft database environments and structures; monitors and evaluates PeopleSoft database environments to optimize performance; plans, organizes, tests and executes migration of databases from development and test to production environments; installs and tests new releases, bundles and fixes; ensures data security protocols are maintained and backup/recovery processes are completed as scheduled.
• Performs PeopleSoft database administration functions for enterprise databases, including setting up and running database management utilities to backup, reorganize and restore databases and resolve production and operational problems; monitors utilization and manages available database resources.
• Performs PeopleSoft data and systems architect duties; analyzes data resource and server capacity and forecasts growth requirements; recommends server, hardware and RDBMS upgrades and enhancements to meet long - term needs; provides enterprise-level short- and long-term planning advice on technical enterprise database and systems management and utilization issues; promotes the effective sharing and utilization of common data across applications and departments/business units; researches and recommends software, hardware and other tools for data warehousing and data mining solutions; develops and deploys software to support data extraction, manipulation and reporting.
• Administers PeopleSoft enterprise database security processes and procedures; develops, recommends and implements security permissions, privileges, standards and guidelines.
• Installs, configures and integrates PeopleSoft application software over data management systems and supporting components and services; installs, upgrades and implements application fixes and patches; administers enterprise application software to ensure security and performance optimization using PUM.
• Performs highly complex systems management functions at an enterprise level; installs, configures, integrates, tests, maintains and administers enterprise operating system software, including system monitoring and management software, for production, development and supplemental servers running enterprise applications and supporting components; installs and monitors system level security structures and protocols; ensures disaster response and recovery processes are followed.
• Provides advanced technical support to PeopleSoft and web team developers and users including advice and guidance on complex processes and system interdependencies; troubleshoots operational and systems issues ranging from difficult to highly complex, including problems with multiple solutions and potential significant consequences; works with other team members to develop and implement or recommend the implementation of appropriate solutions to complex problems.
• Oversees, reviews and responds to developers on PeopleSoft application customization and security requests, ensuring that development standards are followed, application changes are documented, change control procedures are strictly enforced and change projects are migrated across applications environments in an orderly manner.
• Applying image updates to Financials and HCM when the new images are released using PeopleSoft Upgrade Manager(PUM)
• Install and configure Secure Enterprise Search (SES), Cloning and refreshing databases, both as part of the initial environment builds and ongoing project support
• Develops and maintains schematics and other documentation of PeopleSoft database and systems architectures and administration processes.
• Administration of Oracle 12c/11g/10g/9i on HPUX and Windows 2000X RAC in Development, Test, Production and archive environments.
• Provide OS specs for RAC and Non-RAC environments to the OS and storage team for server builds.
• Upgrade RAC and Non-RAC databases from 11g/10g to 12c CRS and RDBMS.
• Work with Oracle 12c/11g/10g new features like Active Data Guard, AWR, ASH, SQLT, DATA PUMP, RMAN on WINDOWS and UNIX.
• Develop/improve Backup and recovery strategies using LAND FREE and Data Domain and DD Boost
• Ability to troubleshoot day-to-day problems encountered on production as well as development database environments.
• Apply quarterly PSU and CPU patches as well as One-Off patches as needed.
• Implement snapshot replication across multiple oracle versions and server platforms.
• Migrate and upgrade databases across multiple platforms (UNIX, NT) and Oracle versions.
• Review and alleviate nightly backup and data guard status and lag reports.
• Work with Network, OS and Storage teams for LPARS and IP upgrades and migration.
• Experience with Peoplesoft Release 8X database installation, support, and maintenance for Financials, HRMS, ELM and/or EPM product suites.
• Act as primary contact with Oracle Corporation for resolving mission-critical database issues through phone-service and SR.

Confidential

Sr. Oracle DBA

Responsibilities:

• Administration of Oracle 11/g10g/9i/8i on Sun Solaris 5.8/5.9,Linux and Windows 2000X RAC in Development, Test, Production and archive, environments.
• Work with Oracle 11g/10g/9i new features like Standby Databases/Data Guard, MTS/Shared Server, UNDO Tablespace, NET8/Sql*Net connectivity architecture, MTS, OEM, RMAN etc in a RAC cluster environment.
• Develop/improve Backup and recovery strategies, Disaster Recovery Planning, Storage Management, Capacity planning, Data Replication, Database migration, Performance Tuning, OLTP application implementation and maintenance.
• Ability to troubleshoot day-to-day problems encountered on production as well as development database environments.
• Installation and configuration of 10g OEM, Quest Central and monitoring of Oracle 8i/9i databases. Develop and document standard operating procedures for databases. Experience in high availability solutions - RAC Cluster, Performance monitoring and reporting.
• Implement snapshot replication across multiple oracle versions and server platforms using replication APIs, scripts, and DBA studio tools.
• Migrate and upgrade databases (over 15 production migrated to date) across multiple platforms (UNIX, NT and VMS) and Oracle versions (Oracle 7.3.4 - 11g). Upgrades to Oracle 9i,10g and 11g have so far been in test environments.
• Developed and deployed UNIX shell and NT scripts to perform regular night RMAN hot backups, periodically monitor database alert log error, tablespace size, server disk space, and also scripts to manage (scrubbing) old archived logs and RMAN backup sets. Monitoring jobs implemented using UNIX Cron subsystem, NT scheduler and BMC ENTERPRISE SCHEDULER and includes alerting of support personnel via email and/or paging for pro-active management.
• Designed, developed and implemented Backup and Recovery strategy, standards (primarily based on RMAN hot-backups) employed in SallieMae’s Environmental Technology business production databases. Ensuring that backups are accomplished and database recovery procedures are tested on a quarterly basis.
• Occasionally perform database/schema level refreshes (cloning) of development databases from production using export/import, database copy via OS scripts or RMAN cloning.
• Pro-actively tune and monitor database performance and growth using Oracle tools such as enterprise manager, STATSPACK, TOAD (SQL-tuner), and OS-based capacity planning scripts. Analyzing and forecasting data changes and planning for anticipated growth.
• Document work instruction detailing steps related to Oracle installations on UNIX/Win2K, including OFA-compliant databases on UNIX, NT and Win2K environments.
• Support over 20 production/development databases on UNIX, NT and Win2K environments in remote locations. Provide phone technical support to customers and application specialists to resolve database related issues.
• Responsible for enforcing BEST PRACTICES (e.g. OFA, basic monitoring implementation) and SECURITY across all production/development databases for which I am primary support DBA making sure these environments fully conform to corporate standards.
• Serve as the DBA team representative in weekly IT Service Delivery Meetings charged with organizing, planning & communicating upcoming production servers/database changes & outages to other IT teams (NETWORK, MIDRANGE, SERVER) and application support personnel. Also responsible to speak up to and describe the nature of all up-coming database work and outages and their impact to customer applications and service delivery levels.
• Act as primary contact with Oracle Corporation for resolving mission-critical database issues through phone-service and Confidential .

Confidential

Cert. Peoplesoft Application DBA /Oracle DBA

Responsibilities:

• Experience in performing Oracle database installation and support for PeopleSoft, including disk storage and space management, primary database objects (tables, indexes, and views), and overall relational design.
• Proven skills in providing technical leadership and support over PeopleSoft application installation, maintenance, and upgrade projects. This would include Financials, HRMS, ELM and/or EPM product suites.
• Proficient knowledge and skills of UNIX operating system environments (commands, utilities, scripts).
• Ability to support data and object migration processes through development, test, and production.
• Ability to provide database and SQL tuning support in development, test and production.
• Proficient skill and ability in troubleshooting the PeopleSoft/Oracle system, including use of system traces, debugging tools, monitoring tools, and the like.
• Experience with Peoplesoft Release 8 database installation, support, and maintenance for Financials, HRMS, ELM and/or EPM product suites. Experience with Oracle Release 8i or 9i database administration.
• Perform PeopleTools migrations including: PeopleTools Objects/Projects, stored statements, Datamover Scripts and custom SQL scripts.
• Track and apply product updates, fixes and tax updates using PeopleTools, including Change Assistant.
• Install, Configure, Monitor and troubleshoot PeopleTools 8.4X architectural components including: Process schedulers / Batch servers (Windows 2000 and Solaris), Web Servers (Weblogic), Application Servers (Tuxedo), Developer two-tier / workstation configurations, Connectivity with database servers (SQLNET / TCP/IP).
• Provide input into architectural decisions for all tiers of the PeopleSoft infrastructure.
• Maintain and administer cross-application integration infrastructure using PeopleSoft's Integration Broker / Application Messaging.
• Design and Admin Peoplesoft Application Security, including single signon and synchronization of user profiles between instances.
• Experience with multiple projects (full life cycle) effective application and technical application support working within integrated consulting and client teams.
• Deep knowledge of UNIX, SQL, PeopleTools 8.4X, PS security, application infrastructure, PeopleTools 8.4 configuration and troubleshooting all components in the PS four-tier environment in an Oracle 9i/UNIX environment for both HRMS and FIN.
• Working knowledge of Peoplesoft security and related areas (row-level security, role and permission list design, portal registry security, and auditing and password management.

Confidential

Cert. Oracle/peoplesoft Database Technical Leader

Responsibilities:

• Engineered and performed migration/upgrade of 7.x, 8.0.x and 8.1.x to 8.1.7, 9i development and production Oracle databases in UNIX and NT/2000 environments for Corning Peoplesoft Finance and PeopleSoft HR businesses.
• People Soft Experience - Patches, Fixes, and Migration of projects, Refreshes & Security.
• Support Peoplesoft finance modules (AP, AR, AM, Billing, Budgets, GL, Inventory, Project costing, purchasing) and HR tax and payroll.
• Documented standard operating procedures for Corning’s Peoplesoft Finance and HR business-detailing steps related to Oracle installations on Unix/NT
• Regularly monitored backups and resource utilization. Managed objects and performed activities such as: granting and revoking access to users, and audited database usage as required
• Played a major role in the configuration, design and implementation of Corning’s Data Warehouse environment.
• developed and documented standards and check-lists to be used by DBAs as guides for upgrade; demonstrated and provided hands-on testing of upgrade documentation on both NT and unix environments; delivered presentations to customers and team members on the business justification (financial and technical) of project, insured availability of resources (documentation, test environments) to guarantee deadlines are met. Regularly organized bi-weekly meetings to present updates on project status.
• Interfaced with Oracle worldwide support directly or via Confidential to manage and resolve customer database related issues.
•  Oracle Database Migration/Consolidation Successfully led enterprise-wide project during which over 30 Oracle production and 20 development databases were migrated, upgraded and consolidated into fewer Oracle instances and servers. Developed detailed project plans, pre- and posts migration checklist, and technical documents to guide DBAs during project. Gave regular weekly project updates to sponsor, DBA staff, and also delivered detailed monthly presentation to stakeholders and customers. Coordinated resources and DBA tasks, and followed up with individual DBA's to ensure that timelines as stipulated in the project plan were strictly met.