Oracle DBA

Susan L. Brower

E: *********@*****.***, ********@*****.*** • M: 707-***-**** •

A: 109 Poe Ct, Napa, CA 94558 • Linkedin: https://www.linkedin.com/in/susan-brower-053b541

Experience Summary

Over thirty years of Information Technology experience including roles covering every phase of application development with emphasis on database administration. Fifteen years of database administration experience including logical and physical database design, installation, implementation, upgrading. patching and support of MS SQL, Oracle, and Sybase database platforms on Windows, Solaris and AIX Unix and Linux.

Relevant Work Experience

Teksystems (Contactor) 1/2015 – 6/2015

http://www.teksystems.com

Williams-Sonoma Inc. 6/2015 – 11/2016

http://www.williams-sonoma.com

100 North Point, San Francisco, CA 94133 415-***-****

Oracle 11g and 12c DBA – My responsibilities included installation, monitoring and upgrading/patching Oracle 11g and 12c Enterprise Databases on AIX Unix hardware, writing unix KSH and BSH scripts and configuration and monitoring of Oracle Streams Replication. I assisted developers with design and tuning of database queries and changes to database physical structures. Database environments supported included very large (over 10TB) OLTP and Reporting production, development and user acceptance testing databases. Most of the Oracle databases use ASM storage and some are RAC/Clustered.

MS SQL Server 2000-2012 DBA – My responsibilities included monitoring existing databases and batch jobs and executing what was required to create or modify user security on the databases. I was the 24X7 on call DBA for a month at a time which included executing implementation change requests, replying and addressing calls to the on call pager and verifying MS SQL environments after the Windows Server Administrators had applied security patches and rebooted the servers.

Accruent (formerly Siterra Corp) 8/2005 – 10/2014

http://www.accruent.com

11500 Alterra Parkway, Suite 110, Austin, TX 78758 – 512-***-****

Oracle 9i, 10g and 11g DBA – Responsibilities included installation, monitoring and upgrading Oracle 9i, 10g and 11g Enterprise Databases on Windows and Linux platforms, writing Linux KSH scripts and configuration and monitoring of Oracle Streams and CDC Replication and assisting developers with design and tuning of database queries. I also trained and educated others to support the database environments. Database environments supported include very large OLTP and DataWarehouse production, development and user acceptance testing databases.

Introduced table partitioning of the larger Siterra database tables (larger than 10GB) and indexes, by using a method to minimize the amount of down time required to implement the modifications.

MS SQL 2000 and SQL 6.5 DBA - Responsibilities include installation, monitoring and upgrading Windows (2000 and 2003) enterprise edition SQL Servers (including clusters); migrating database object changes; configuring and maintaining the disaster recovery database environment; and installation, configuration and maintenance of MS SQL Replication.

Oracle and MS SQL DBA roles included being oncall 24 X 7.

Northern Natural Gas Co. (NNG) 1/2003 – 8/2005

http://www.northernnaturalgas.com/

1111 South 103rd Street, Omaha NE 68124 – 877-***-****

DBA and technical leader of the NNG DBA team – Responsibilities included budgeting, training and scheduling work assignments for a team of three DBA’s and one ETL specialist, writing and performing semi-annual performance appraisals and salary reviews for team members, and communicating and reporting team status to Infrastructure Director and IT Vice President. I was also responsible for creating and maintaining the NNG DBA Service Level Agreement, standards, and migration procedures and policies.

MS SQL 2000 and SQL 6.5 DBA - Responsibilities include installation, monitoring and upgrading Windows (2000 and 2003) enterprise edition SQL Servers (including clusters); migrating database object changes; configuring and maintaining the disaster recovery database environment; and installation, configuration and maintenance of MS SQL Replication as well as carrying a pager and being on call 24 X 7 with the other NNG DBA’s. Also, development of two Datawarehouses and extensive development and use of MS SQL DTS packages for ETL processing. I also implemented the Quest Litespeed database backup software on all NNG SQL Servers.

Lead DBA for migration of the NNG data center servers to Omaha, NE from Houston, TX.

Enron Transportation Services (ETS) 6/1997 - 12/2002

Company no longer exists – no contact information

First as an EDS employee and then as an Enron employee, provided DBA support for production, model office, and development databases of the ETS business applications. ETS databases included two RDBMS': Sybase (versions 4.9 through 11.0) running on Sun Solaris and MS SQL (versions 6.5 and 2000) running on Compaq NT and Windows 2000 (including clustered servers.) Responsibilities include monitoring and upgrading servers; migrating database object changes; configuring and maintaining the disaster recovery database environment; and installation, configuration and maintenance of both Sybase Replication and MS SQL Replication.

Electronic Data Systems (EDS) 4/1985 - 6/1997

EDS was purchased by Hewlett Packard in 2008

Developed and supported various applications at various client sites. Roles included programmer, application designer, database designer, application implementer, technical leader, supervisor, DBA.

dbINTELLECT – Data Warehouse Consultants 6/1996 – 4/1997

Xprt-Natural Gas Marketing Software Development Product 11/1992 – 6/1996

Exxon USA Marketing Re-Systemization (MARS) Group 1/1987 – 11/1992

EDS, GM Buick Financial Division 6/1985 - 12/1987

Software\Hardware\Operating System Experience

(most recent to least recent in each category)

Programming Languages SQL, UNIX C and KSH shell script, ISPF, TSO Clists, Cobol II, PL/I, Cobol

DBMS' Oracle 12c, 11g, 10g, and 9i, MS SQL 2000-2012, MS SQL 6.5, Sybase, DB2, VSAM, IMS

Development, Support and

Monitoring Tools JIRA, SQL Diagnostic Manager, DB Artisan, Erwin, Litespeed

Powerbuilder, S-Designor, Telon

Operating Systems AIX 7.2, Linux Red Hat 6.5, Windows 95, 98, and 2003 NT. 2000 and 2003, Windows 3.1, UNIX - SUN Solaris OS 2.6, IBM TSO

Education

California State University, Chico – 9/81 12/84

400 W. 1st St., Chico CA 95929 530-***-****

Computer Science, Business Applications Specialty - Major

Business Administration - Minor

College of the Sequoias – 9/79 5/81

915 S. Mooney Blvd., Visalia, CA 559-***-****

Liberal Arts AA

Contact this candidate