JANICE L. WARD
35 Elk Lane
Littleton, Colorado 80127
(303) 973-9669

JaniceLPlatt@msn.com

Summary
Oracle DBA with over 11 years Oracle experience up to 11g, UNIX System Administrator, additional years as a Microsoft SQL Server 2000 DBA and MySQL. Experience includes system architectural design, client/server creation, installation, upgrades, monitoring, tuning, migration, maintenance, backup/recovery, customer interface, application development and documentation client/server and PL/SQL and TSQL applications. 24x7 support of Development, Test and Production databases.

RDBMS: Oracle 11g, 10g, Oracle9i, Oracle8i, SQL Server 2000, MySQL, Sybase

Platforms: Solaris, AIX, Windows, HP, NT, MVS.
Languages: SQL, PL/SQL, SQL*Plus, TSQL, UNIX Shell scripting, SED/AWK, XML, HTML, Java.
Products: Oracle Designer 2000, Toad, Toad Modeler, OEM, DBArtisan, Erwin, ER/Studio, Iplanet, SunOne Webserver.

GIS: ESRI products - ArcSDE, ArcIMS, ArcCatalog, ArcServer

PROFESSIONAL EXPERIENCE:

ClickBank

Production Database Administrator 08/06 – 01/09

MySQL Database administrator for production, development, test and web servers. All tasks are performed under the Agile Software Development process. Duties include backup and recovery for all MySQL databases. Administer replication (slaving) within MySQL, including configuring new replication servers, masters and slaves throughout the total environment. Monitor data consistency, system critical components, and overall system performance including disk space, memory usage, application web servers to assure online/operational functionality across all masters/slaves. Analyze and tune both MyISAM and Innodb MySQL database engines for memory, performance, scalability, and replication. Responsible for SQL application query monitoring, analyzing and tuning for optimal performance. Participated in implementing a "data warehouse" analytical and historical schemas, automated scripts/jobs to store and capture business data.

TekSystems (Contracting Company @ Sports Authority)

Database Administrator 04/06 – 08/06

Production and test support of Oracle 8i, 9i and 10g and MS SQL 2000 databases operating in a 24x7 environment. Provide technical support for Oracle application development and tuning as required. Tasks including but not limited to SGA tuning, SQL and PL/SQL tuning, Parallel Query, Partitioning, Data warehouse, etc. Proactive monitoring of Oracle/SQL Server environments for performance, space utilization, backup and problem resolution using Oracle/SQL Server utilities and Quest (Toad and Foglight) monitoring tools. Problem resolution, documentation and follow-up with both internal and support staff. Coordinate with other departments for database change and system control requests and software implementations. Other functions include: RMAN backup support and problem resolution, K-shell, C-shell, and Bourne shell maintenance and development. Databases are supported on UNIX, Linux, and Windows environments.

Lockheed Martin at Bureau of Indian Affairs, Department of Interior

Database Analyst Staff/UNIX Administrator 10/04 – 04/06

Oracle DBA and Solaris UNIX system administrator responsible for software installations, upgrades, patches, and security enhancements and application installations. Experience includes administration of 7 Solaris servers hosting Oracle 9i databases, Web Servers, and GIS applications of ArcSDE and ArcIMS, including raster and vector data. Monitor and tune databases and operating systems to achieve optimal performance with databases and application software. Conduct routine hardware and software audits and maintenance for compliance with established procedures and security requirements.

Responsible for all standard database and UNIX administration tasks including: proactive performance tuning and monitoring, trouble-shooting, backup and recovery, installation, configurations, including production, development and test environments. Create UNIX shell scripts to automate DBA tasks such as monitoring and house keeping.

Installation, migration, upgrades of Oracle databases in UNIX and Windows environment. Designs, models documents and guides the logical and physical and conceptual relationship of large-scale Oracle GIS databases. Scheduled system backups and database archive operations.

Analyze needs and requirements of existing and proposed systems, and develop technical, structural and organizational specifications. Review design and integration of systems and make recommendations regarding enhancements and/or improvements. Formulate policies, procedure, and standards relating to database management.

Project management skills to set realistic expectations with users and customer for high customer satisfaction. Excellent interpersonal skills and strong written and verbal communications skills. Communicate information in a positive manner. Work well in team environment as well as independently. Provide training and documentation.

Synergetics Inc. at USDA

Database Analyst/Project Lead 08/04 – 10/04

Develop PL/SQL scripts to ensure and validate data integrity between Oracle9i database, J2EE and Web Forms. Coordinate all PL/SQL, Java, XML and Web Forms to track critical mission data. Develop and manage project plans, control scope, manage risk, track issues, attend key meetings, report status, and conduct post mortems. Validate user requirements, functional/technical designs, gap analysis, and other documentation to ensure that all tasks are captured and are within scope. Coordinate with Release Team on development/test environment refreshes, downtimes, production install requests, patch installs, etc. Ensure technical infrastructure, scheduled jobs, messaging, and other technical support activities are in place for User Acceptance Test cycles. Develop, enhance, roll-out and practice Project Management Office (PMO) standards, templates, and processes to continuously improve overall project delivery for customer.

IQNavigator,
Oracle Senior Database Administrator 05/04 – 07/04

Senior Oracle database administrator for set up and operation multiple production-caliber databases on UNIX based Sun Solaris. Administer multiple production, test and development Oracle8i and 9i database environments. Administer Oracle Financials, including upgrades, migrations, user assistance, and data feeds. Write and modify robust scripts to automate backup, data transfer, and other administer tasks using SQL, PL/SQL. On call 24x7x356.

Qwest Communications,
Lead Database Administrator 10/00 – 05/04

Lead Oracle and SQL Server Database Administrator for development telecommunications environment projects. Supporting Oracle 7.34 – 9i, 60+ databases, sizes from 10G-100G on UNIX. Accountable to team members for database support, 7x24 pager support, response within 15 minutes. Responsible for database conversion and consolidation to Oracle9i and Oracle8i versions. Designs logical and physical databases using modeling tools of Oracle Designer and Erwin. Performance tuning configuration of databases, SQL, PL/SQL, TSQL code tuning, installation and upgrading of Oracle and SQL Servers, plan storage requirements, modify existing database structure, backup and recovery. Project management and planning of database information systems upgrades and consolidations. All work done in a rapid development XP (Extreme Programming) environment. Responsible for SQL Server 2000 database administration, security patches, and service pack installations. Responsible for backup and recovery and assisting customers with SQL Server application issues and resolving problems. Backup database administrator on Sybase applications.

EDUCATION:
Master of Computer Information Systems, Master Certificates of Study in Data Processing Management and Computer Systems Management: University of Denver.
Bachelor of Arts in Geography: University of Denver.

Oracle 11g Database Administration – Oracle class 05/09, OCA and OCP in progress.
Oracle Masters Certificate of Database Administrator Oracle7: Oracle Education.

Microsoft: SQL Server 2000 MCDBA Certification Courses 2003.

United States PATENTS:
P5132 Database Migration, Sun Microsystems, May 11, 2000.
P5187 Automated Oracle Web Base Reports, Sun Microsystems, May 26, 2000.

PROFESSIONAL CERTIFICATIONS:

Microsoft: SQL Server 2000 MCDBA Certification Courses 2003.
Oracle, UNIX, SQL, Java Brainbench Certifications in 2001-2002
CLEARANCE:
Have held the following: Department of Energy: 'Top Secret', Department of Defense: 'Secret'.