Mark D. Pedreira

**** ****** ******

Las Vegas, Nevada 89123

E-mail: adxyke@r.postjobfree.com

702-***-****

PROFESSIONAL OBJECTIVE

A position with an organization providing the opportunity to contribute by utilizing and expanding upon my experience, training, and capabilities in Database Administration, PeopleSoft Administration and Software Development.

QUALIFICATIONS PROFILE

Database Administration:

Analyzed server requirements.

Installed database servers (hardware and software).

Monitored and performed database and SQL query tuning.

Developed maintenance scripts, stored procedures and back up procedures.

Maintained customer databases and database servers.

Applied server patches and upgrades.

Performed database recoveries after system failures.

Installed and maintained Data Warehouse application.

Databases:

Oracle 8i-19c

Microsoft SQL Server 2008-2019.

Sybase SQL Server.

Progress

PeopleSoft Administration:

Supported and upgraded Financials,HCM, EPM and Portal Applications on Linux/NT environments.

Supported and upgraded PeopleTools.

Applied various software upgrades, tax updates, etc.

Supported and upgraded Weblogic and Tuxedo.

Experience with Change Assistant and PUM images.

Configured SSO and LDAP.

Setup system monitoring scripts on Linux and NT servers.

Experience with ElasticSearch, Kibana and Logstash.

Software Development:

Worked in all areas of software development cycle.

Developed software requirements with end-users.

Analyzed software requirements.

Designed software solutions.

Wrote, tested and debugged code.

Performed program maintenance.

Tuned Database Queries.

Managed a group of programmers and programmer/analysts.

Programming Languages:

PL/SQL / T-SQL.

Perl

KSH / BSH

Powershell

Customer/Technical Support:

Assessed customer needs.

Worked with customers on new product implementation, technical support, and performance improvements.

Managed group of application support personnel.

Responsible for distributing software updates to over 65 remote sites.

Worked with hardware maintenance vendors to resolve hardware related problems.

Provided customers with cost estimates, schedules and delivery dates on projects.

Developed project test plans.

Job Experience:

City of Henderson – Henderson, Nevada September 2005 to Present.

oDatabase Administrator

Database Administrator for Oracle (9i-19c) on Solaris, Linux and ODA.

SQL Server Database Administrator for versions 2005-2019.

Setup SQL Server Clustered Environment and Always On.

Experience with SSRS, SSAS and SSIS.

oPeopleSoft Server Administrator

Installed, supported and upgraded Financials and HCM Applications up to 9.2.

Installed, supported and upgraded PeopleTools versions from 8.1 to 8.59.

Applied various software upgrades, tax updates, etc.

Installed, supported and upgraded Weblogic and Tuxedo previously with opatch and currently with PT-Infra DPK for PeopleTools.

Experience with Change Assistant and PUM images.

Developed refresh scripts to refresh Dev/Test and QA environments from Production.

Configured SSO and LDAP.

Bechtel/SAIC – Las Vegas, Nevada July 2002 to September 2005.

oDatabase Administrator / PeopleSoft Administrator

Preformed various Database Administration tasks including installing database servers (Oracle 8i and SQL Server 2000), applying upgrades and patches, monitoring, tuning, and writing PL/SQL scripts and stored procedures.

Developed Unix and Perl scripts to backup databases, purge archive logs and trace files, monitor tablespace and disk space usage, and send emails to alert DBA of problems with instances.

Installed Peoplesoft environment including database, web server, application server, and batch servers. Database Administrator / PeopleSoft Administrator for the implementation and support of Human Resource system.

Database Administrator for MetaPower’s Corrective Action Program (CAP) system, Bechtel Standard Applications (BSAP), and the CA-WEB application.

PurchasePro – Las Vegas, Nevada March 2002 to April 2002

oDatabase Analyst (Contract)

Developed queries and reports using PL/SQL and Oracle Discoverer. Converted existing Cognos and Crystal Reports to Oracle Discoverer.

PurchasePro – Las Vegas, Nevada August 2000 to December 2001.

oOracle Database Administrator

Preformed various Database Administration tasks including installing database servers (Oracle 8i) on Sun Solaris, Compaq Tru64 and Windows NT platforms, applying upgrades and patches, monitoring, tuning, and writing PL/SQL scripts and stored procedures.

Provided internal users with SQL query and tuning assistance.

Worked on migrating database triggers, functions, packages, and table modifications from development to different production environments.

Preformed backup/recovery (RMAN), database refreshes, database cloning and moving of specific data from production environments to development and QA databases for testing purposes.

Responsible for data warehouse database, created procedures to populate database and consolidate information for reporting purposes utilizing Informatica PowerMart, SQL-LOADER and PL/SQL.

Created Oracle function based indexes, materialized views, index organized tables, partitioned tables, and stored procedures for data warehouse.

Converted data warehouse database to locally managed tablespaces.

Developed procedures to perform clean up of client information utilizing Trillium, SQL-LOADER and PL/SQL.

Applied upgrades and patches to Oracle Financials.

Installed and maintained Designer 6i repository.

Worked on project to migrate existing reports and queries from Crystal Reports and Cognos to Oracle Discoverer.

Developed and maintained an application to migrate packages and procedures from Visual Source Safe to different Oracle production environments. (Perl)

Datanamics Inc. – Las Vegas, Nevada October 1979 to August 2000.

oDatabase Administrator / Email Administrator / Consultant (1997-2000):

Worked on miscellaneous internal and external projects ranging from installing database servers, writing SQL scripts, thresholds, triggers, back up procedures, and preformed database monitoring and tuning on RS/6000 and Windows NT platforms with Sybase 10/11 and Microsoft SQL Server 6.5.

Designed / Developed and maintained centralized Travel Agency Commission and Reporting system using Sybase 10 on the RS/6000 platform for a major hotel chain. (TSQL, C)

Installed RS/6000 hardware and operating system software at customer sites.

Consultant/DBA on project to install and support Quintus help desk system on RS/6000 platform using Sybase 10/11.

Wrote Excel VBA functions for Corporate Financial Reporting system to allow users to pull database information directly into spreadsheets from Sybase 10/11 database. (ODBC, VBA)

Consultant/DBA on a project to replace a legacy system with the ATS Claims system on Windows NT platform. Worked with vendor to develop field mapping, conversion, and test plan documentation. (SQL Server)

Installed and maintained email servers at over 100 locations nation-wide.

Designed and maintained applications in Visual Basic to centralize management of Post Office master directory entries. Automated Post Office maintenance and back up functions, recovered corrupted databases.

Implemented internal and Internet email systems using Lotus ccMail and Microsoft Exchange.

Worked on project using Powerbuilder and Sybase to create web site for a client to allow their customers to book tour packages over the Internet.

oManager of Programming and Support (1988-1997):

Managed a group of 12 programmers and support personnel to maintain and support a Hotel Back Office system.

Responsible for working with users to determine system requirements, performing detailed designs, providing cost estimates, delivery dates and installation schedules.

Developed and implemented programming and documentation standards for programming and support groups.

Responsible for migrating Hotel Back Office System from legacy hardware to the RS/6000 platform.

Designed/developed and migrated Corporate Financial Reporting system from legacy hardware and software to RS/6000 Sybase 10 platform. (T-SQL, C)

oProgrammer/Analyst (1982-1988):

Worked on a Hotel Back Office system for a client with over 65 hotels nationwide. The applications included Payroll, Time and Attendance, Human Resources, General Ledger, Accounts Payable, Accounts Receivable, Pension, Thrift/401K Valuation system, Corporate Financial Reporting, and a Travel Agency Commission Payment / Reporting systems. Responsibilities varied from getting requirements from the end-users, designing the application or program modifications, to coding and testing the change. (Assembler)

Contact this candidate