SUMMARY:

• Successfully started consultancy in 2003 focused on database implementations using Oracle and DB2 UDB.
• Has worked on database implementations on AIX, Linux, Solaris, and Windows.
• Has worked in both OLTP and data warehouse environments.
• Fluent in both UNIX Shell scripting, SQL, and PL/SQL.
• Has worked in all areas of database support, including installation, monitoring, SQL writing, support, upgrading, and patching.
• Has maintained a high level of satisfaction with customers, has been offered fulltime positions with all major customers, and has provided deep technical implementation expertise with project leadership.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Architected/deployed/supported Dataguard environment for all databases.
• Architected/deployed/supported RMAN environment for all databases with RMAN catalog.
• Deployed/converted Transparent Data Encryption ( Confidential ) for tablespace/table encryption.
• Used Datapump Export/Import.
• Used SQLLoader.
• Installed databases, including setting up Linux environment.
• Patched databases with OPatch.
• Upgraded (inplace) databases from V11 to V12.
• Integrated backups with NetBackup and Data Domain.
• Deployed/debugged application changes.
• Performance tuning diagnosis and resolution.
• .Net application interface tracing and diagnosis.
• Built replication environment based on materialized views.
• Built all user/grants/role/authentication/tnsnames/listeners/database link objects as required.
• Built all normal tablespace/schema/table/partitioned - table/index/constraint objects as required by applications.
• Supported on-call issues, including support issues with Oracle.
• Managed (changes/patches/installs) development environment in AWS.

Confidential

Responsibilities:

• Converted (inplace) single-instance databases to RAC, making all necessary parm file, redo, thread, listener/SCAN, UNDO tablespace, and catclust changes necessary for conversion.
• Migrated RAC database to single instance database, making all necessary changes to parm file and using a restore process.
• Deployed ASM infrastructure and migrated filesystem databases to ASM.
• Maintained all ASM disks, disk groups, files, and storage as requirements evolved in environments.
• Integrated RMAN with ASM.
• Managed all operations (start/stop/srvctl configuration) of RAC database environment.
• Performed troubleshooting of RAC production issues/installations/server infrastructure.
• Installed Grid infrastructure software.
• Patched Grid environment.
• Implemented Linux Hugepages

Confidential

Responsibilities:

• Built single-path replication environment used for OLTP-OLTP and OLTP-Data Warehouse replication.
• Built Active-Active replication environment.
• Built both classic and integrated Goldengate replication environments.
• Built processes for adding tables to existing replication environments.
• Built failover process integrated with Dataguard to move Goldengate processing from Primary to Standby databases.
• Built processes for adding columns to existing tables in existing replication environment.
• Built initial replicated environments with no downtime to source environments.
• Enabled Confidential integration with Goldengate on Extract component.
• Used Goldengate ENCKEYS encryption for encrypting passwords in parameter files.
• Wrote monitor for sending alerts of Goldengate issues at Extract or Replicat servers.
• Architected naming convention used for enterprise deployment.
• Integrated Goldengate with RAC environment.
• Converted Goldengate environment from single-instance databases to RAC-enabled databases.
• Upgraded Goldengate environment.
• Supported on-call issues with Goldengate.
• Built process to resolve broken replication from last replicated transaction.
• Used logdump for transaction inspection.
• Used Goldengate for data migration and conversion.
• Stress-tested Goldengate using home-grown data generation scripts and Goldengate reports.
• Piloted Oracle-MS SQL Server Goldengate replication.

Confidential

Responsibilities:

• Fluent in UNIX Shell programming. Have written/supported scripts/programs for:
• ETL processes.
• Performance monitoring.
• Automated problem recovery.
• Automated stop/start of application queueing infrastructure.
• User termination.
• Report generation and distribution.
• PL/SQL and SQL programming. Have written/supported code for:
• Application packages/procedures/triggers/functions.
• Load processes.
• Apex applications.
• Database metric collection.
• Integrated with shell programs.
• Apex development support
• Wrote application changes for existing applications.
• Wrote processes and code to resolve data issues.
• Perl development
• Wrote entire ETL process to move banking database from DB2 to Oracle.

Confidential

Responsibilities:

• Operated in Redhat/Oracle Linux environment.
• Operated in Windows Server environment.
• Fluent in Linux layout, use, operation, Yum update, and base performance tools.
• Used OEM for Oracle infrastructure monitoring.
• Used Toad for database monitoring, object interrogation, and data inspection/operation.
• Used Redgate for data synchronization.
• Built/Wrote Redgate processes for atomic table synchronization from Dev->QA->Stage->Prod environments.
• Deployed Web Server infrastructure for Oracle Apex Web applications.
• Deployed all SSL infrastructure/certificates to support Apex and OEM Web Servers.

Confidential

Responsibilities:

• At Safeguard, within 2 years of starting contract, was elevated from initial hire to contract team lead.
• Performed technical interviews for fulltime hire brought in as team lead.
• Documented all major architectures, designs, processes, and changes for future reference and teaching materials to other DBAs.
• Interfaced to all levels of management up to CIO, as required.
• Documented and performed database move to new dual datacenters.
• Interfaced directly with application teams, network team, storage team, and server team for smooth and coordinated changes, deployments, and operations.
• Provided advanced storage capacity requirements to enable no issues for production usage, system migrations, and environment refreshes.

Confidential

Responsibilities:

• Installed databases, including setting up UNIX environment.
• Patched databases.
• Upgraded database versions.
• Integrated database with Active Directory.
• Integrated database with AIX HACMP.
• Architected tablespace/storage infrastructure.
• Integrated backups with Tivoli Storage Manager and NetBackup.
• Performed Export and Import processing as required.
• Architected and deployed HADR (High-Availability replication).
• Built all user/grant/authentication objects as required.
• Supported on-call issues, including support issues with Confidential .
• Supported SQL Replication infrastructure.
• Wrote scripted process for modifying SQL Replication.
• Conducted storage performance analysis with DB2.
• Wrote standard deployment process for DB2.
• Built/support DB2 with Distributed Partitioning Feature (for multi-node systems).
• Performed snapshots and snapshot analyses.
• Performed backups and restores as required.
• Setup automated backup and archive log purging.

Confidential

Responsibilities:

• Installed Confidential Content Manager with DB2.
• Tested and wrote upgrade process for Confidential Content Manager from version 8.4.3->8.5->8.6.
• Reverse engineered Confidential Content Manager control tables and wrote purge process for data and documents.
• Installed Confidential Content Manager OnDemand.
• Deployed pilot system on Confidential Content Manager OnDemand.