PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator \ System Architect

Responsibilities:

• Accountable for all aspects of providing a highly - available (200+) database environment to a national client base for association management SaaS product (Association Anywhere) while working within an AGILE business methodology. Instrumental in designing new full-technology stack for complete datacenter migration to Rackspace’s Cloud platform.
• Key accomplishments: Architecting and creating system-wide solutions (Solaris, Red Hat Linux) allowing client base to scale out, creating massive, fully-automated Perl and PL/SQL programs to perform complete Oracle database migration, seamlessly incorporating Oracle Application Express (APEX) product into entire database environment, recovering (near-)entire database environment from hardware disaster within timeframe of service-level-agreements, fully automating data feeds between client databases and third-party environments.
• Routine responsibilities: Performance tuning of Oracle databases, configuring client integrations with third-party vendors, conducting database benchmarking using HammerDB, performing capacity planning, navigating multiple UNIX platforms (Solaris, Linux and AIX), refreshing development databases with production data, creating Perl code to automate routine\ancillary tasks, creating and decommissioning databases, monitoring database backups, detecting and solving database bottlenecks using Quest Spotlight, providing leadership to developers with PL/SQL coding problems, designing new database structures to assist ad-hoc reporting, generating and analyzing ER diagrams, translating business requirements into technical specifications.

Confidential

Oracle Database Administrator

Responsibilities:

• Responsible for support, creation and maintenance of Oracle databases in a large (100+ instance) Application Development Organization. Environment includes both data warehouse- and OLTP-styled databases.
• Primary responsibilities include: Developing and modifying PL\SQL procedures, implementing application changes through execution of SQL and PL\SQL code, performing data loads into data warehouses, performing disk space management of very large databases (VLDBs), creating and maintaining Perl programs to automate routine administrative tasks, troubleshooting instance failures, applying federal government security standards to databases, creating and monitoring database backup procedures (using RMAN and Netbackup), pruning spurious data from production databases, managing Oracle user rights\roles for staff and users, performing database recoveries using either logical (export) or physical (RMAN) backups, assisting developers with database schema comparisons and reconciliations, tuning the performance of databases, debugging PL\SQL programs, monitoring critical database events with Oracle 10g Grid Control, performing administrative tasks specific to Oracle RAC technology, coordinating server-to-server database migrations.

Confidential

Oracle Database Administrator

Responsibilities:

• Performed administration and maintenance of large (45+ instance) Oracle database environment which provided data storage to a full range of business applications (i.e. manufacturing, accounting, validation, etc.) for a commercial pharmaceutical corporation.
• Responsibilities included: Instance creation and configuration, creating and monitoring database backup procedures (using RMAN and OS-level methods), tuning the performance of databases, creation of SQL and PL\SQL code for administrative and maintenance purposes, providing data retrieval solutions to developers, providing client-level assistance to tier-1 support, analyzing and recovering from instance failures, troubleshooting long-running queries, disk space management, log monitoring, performing data migrations from server to server (across various platforms), upgrading and patching databases, installation and configuration of Enterprise Manager 10g (Grid Control), automating routine tasks through creation of Perl code, monitoring critical events through Enterprise Manager, data consolidation, database design and development.
• Additional responsibilities included: Providing UNIX (Solaris) and Linux (SuSE) support, sustaining several MS SQL Server (2005) databases by; refreshing support databases with production data, performing database backups and recoveries, maintaining T-SQL procedure code.

Confidential

Oracle Database Administrator / UNIX System Administrator

Responsibilities:

• Performed Oracle (8i & 9i) database administration and UNIX (AIX 5.1 & 5.3) system administration of a highly available 24\7 production database, and several non-production databases, which supported a Cerner Millennium (2005.02) clinical information system.
• Oracle (8i & 9i) database administration skills and responsibilities included: Instance configuration, backup and recovery using RMAN, performance tuning, creating\editing SQL & PL\SQL scripts, providing data retrieval support to analysts, troubleshooting and recovering from failures, disk space and tablespace management, Net8 network configuration, log monitoring, managing Oracle with OPS (Oracle Parallel Server) & RAC (Real Application Clusters).
• UNIX (AIX 5.1 & 5.3) system administration skills and responsibilities included: Programming using Perl and Korn shell languages, system-level user account creation and maintenance, print queue creation and maintenance, FasT Turbo disk cluster management and configuration using IBM’s Storage Manager software, installation of OS patches and updates (APARs), management of high-availability cluster failover software (HACMP 5.1), creation of cron jobs for scheduled tasks, performing OS-level backups and recoveries using IBM’s Tivoli solution.
• Also responsible for the maintenance of a Cerner Millennium (2005.02) system including: Installation and maintenance of Service Packs (OCDs or SPs), creation and maintenance of OPS jobs, performing refreshes and replications of multiple system environments, troubleshooting and recovering from system failures, assisting analysts with application-level problems, creation of print devices, creation and maintenance of Citrix-level “Published Applications”, synchronization of application code using Cerner Desktop Manager on middle tiers, user management through Citrix (CMC).