SUMMARY:

• Database Administrator and Manager with demonstrated success designing and implementing database solutions that improve business functionality.
• I have a diversified technical and management background with enterprise and engineered systems to include architecture, implementation, and administration of multiple database technologies with focus on high availability performance, security, and disaster recovery.

TECHNICAL SKILLS:

• Oracle 8i to 12c
• Advanced Replication
• Business Suite
• Advanced Security
• Linux/ UNIX
• Exadata
• RAC 9iR2 to 12c
• Oracle Streams
• PeopleSoft
• Oracle DB Vault
• Oracle VM/ OVM
• Database Appliance
• ASM 10gR2 to 12c
• Oracle Golden Gate
• Oracle DB Firewall
• Grid Infrastructure
• 12c Multitenancy
• Oracle Audit Vault
• CISSP
• Performance Tuning
• SQL Server

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

• Design, Implement, and Administrate all custom application databases as well as legacy ‘off the shelf’ Oracle Databases (12c, 11g).
• Work on a modernization team consisting of COBOL and Java developers to replace custom mainframe ERP system with Oracle and Exadata.
• Designed and administrate all Oracle infrastructure to work with an interface with the organization’s open systems infrastructure.
• Administrate all Oracle Engineered Systems as well as legacy AIX Oracle environments.
• ASM, ACFS, RAC, and Cell Storage Administration.
• Oracle 12c/11g database and Exadata performance tuning.
• Administrate 12c and 13c Enterprise Manager.
• RMAN Backup and Recovery with 12c database Multitenancy.
• Oversee all Oracle development and operations.

Confidential

Database Security Architect Consultant

Responsibilities:

• Designed solutions around client’s needs for compliance and security.
• Implementation of Oracle Database Security products.
• Database hardening, auditing, and penetration testing.
• Migration of data for E - Business Suite and Transparent Data Encryption.
• Scripting and automation for implementation of PeopleSoft OneCommand and Transparent Data Encryption.
• Comprehensive documentation included requirements, detailed design, project plans, and implementation run books.

Confidential, Minnesota

Sr. Oracle DBA Consultant

Responsibilities:

• Architecture, design, and development of all Oracle hardware and database products including Oracle Linux virtualization.
• Developed, implemented, and administered Oracle Linux environments and Oracle Database Appliances.
• Implemented Oracle 11gR2 RAC for high availability.
• Implemented Oracle Virtual Machine.
• Implemented and configured virtualization option for Oracle Database appliances.
• Implemented Disaster Recovery and replication with Oracle Data Guard and Oracle Golden Gate.
• Developed, implemented, and administered data warehouse and data mart including ETL jobs.
• Architecture and development of data warehouse, from gathering business requirements to logical and physical data modeling.
• Security, performance tuning, and high availability for all environments.
• Created documentation for all products and software setup and configurations delivered.

Confidential

Sr. Oracle DBA Consultant

Responsibilities:

• Architecture, design, and development of Oracle database, security, and hardware products for Minnesota’s Health Information Exchange ( Confidential ) project for the Affordable Health Care Act.
• Developed, implemented, and administered Oracle Golden Gate, Database Vault, Database Firewall, and Audit Vault for the Confidential project.
• Oracle Exadata Server configuration and administration.
• Oracle RAC administration on 4 node Exadata Appliances, 11gR2.
• Performed and supported any data transfers or ETL operations needed for development, validation, integration, and production.
• Developed and wrote shell and database scripts and procedure needed for integration.
• Created documentation for all products and software delivered.

Confidential

Database Technologies Tower Lead

Responsibilities:

• Assisted in the architecture and design of multiple database products and initiatives to be delivered to Target Corporation. Lead a team of resources to fulfill Target’s requested needs. Recommended tools, options, as well as analysis to senior Target management.
• Identified, hired, and managed 8 team resources for various Target database technologies (Oracle, SQL Server, UDB/DB2, and Teradata).
• Managed all phases of projects and deliverables to Target database technologies group. Managed performance metrics, as well as cost expectations with Target management, Confidential sales, marketing, and program managers.
• Projects included:
• Reducing SAS footprint by shrinking the user base and keeping data in warehouses instead of SAS where appropriate.
• Consolidation of reporting in to the right tools instead of business supporting a large number of adhoc access warehouses across the organization.
• SQL Server replication and ETL to propagate to all Target Stores nationwide.
• Oracle indexing and performance tuning for Distribution Centers nationwide.
• SQL Server new stores system plans for Target Canada project.
• Recommended and implemented Multi Datacenter, High Availability plan for critical Oracle based databases and applications.
• Assisted my resources when needed regarding: audits, scripting, indexing, performance tuning, PL/SQL/ T-SQL, and data modeling.

Confidential

Senior Principal Consultant

Responsibilities:

• Assisted in the architecture design and development of Oracle products for US DoD and Intelligence agency customers.
• Developed and implemented Oracle Golden Gate as well as other replication solutions according to customer needs.
• Deployed Oracle technologies such as 11g Grid Control, Golden Gate, and Oracle Internet Directory.
• Integrated Oracle replication technologies to run in RAC environments.
• Perform and support any data transfers or ETL operations needed for integration.
• Develop and write any Linux/ UNIX shell or database scripts needed for integration and implementation.
• Create documentation for all products and software delivered.

Confidential

Senior Oracle/ PostGreSQL Database Administrator

Responsibilities:

• Responsible for all Oracle and PostGreSQL Server databases for the organization (Confidentiality, Integrity, and Availability). Includes over 50 servers for Confidential web site and Publishing Services.
• Developed, implemented, and administrated Red Hat Linux Advanced Server environment 5.x, for the organization's web site and publishing services.
• Developed, implemented, and administered an Oracle Recovery Manager (RMAN) repository for all Oracle databases to provide faster recovery and restoration for all registered Oracle database instances for events, such as corrupted data files, or disaster based scenarios.
• Implemented and administered Oracle 11g Grid Control (OEM).

Confidential

Database Administrator

Responsibilities:

• Responsible for all Oracle and MS SQL Server databases for the organization.
• Implemented and administrated a three-node Oracle Real Application Cluster (RAC) environment on Red Hat Linux for the organization's 24/7 mission critical system.
• Developed, implemented, and administrated a hot Disaster Recovery (DR) site utilizing Oracle Data Guard for standby and fail-over of the organization's mission critical Oracle RAC environment, as well as single- instance databases.
• Developed and implemented UNIX and Linux shell scripts which performed tasks such as running scheduled stored procedures, cold backups, and RMAN jobs.
• Extensive experience with SCHEMA, DDL, and DML replication with Oracle Golden Gate within homogenous and heterogeneous environments.
• Developed, implemented, and maintained multiple MS SQL Integration Services (SSIS) jobs which extract, transform and load (ETL) via access to data from multiple data sources for real time reporting and intranet updates.
• Installed and administrated MS SQL Server 2000, 2005 & 2008 clustered database instances for fail-over and disaster recovery at organization's primary site.
• Migrated MS Great Plains databases from MS SQL Server 2000 to MS SQL Server 2005 clustered environment.
• Administrated MS Great Plains for organizational finance, payroll, Human Resources, and Quality Assurance.
• Developed and maintained MS SQL Maintenance Plans for all MS SQL Servers.

Confidential

Senior Database Administrator/ Systems Administrator

Responsibilities:

• Security Clearance with US Department of Justice.
• Responsible for resolution of escalated Oracle 8 and 9i database issues.
• Responsible for client disaster recovery and backup solutions.
• Oversaw development of SQL scripts and procedures to assist the Confidential Team.
• Created and designed stored procedures and functions.
• Restored and resynchronized Data Acquisition Stations with regional correlation servers (Oracle Advanced Replication).
• Responsible for troubleshooting all UNIX, SGI-IRIX, and LINUX issues.
• Proposed and coordinated on-site service and solutions.
• Assisted engineering in gathering data to resolve propriety application issues.
• Installed, upgraded and configured Oracle client workstations and servers at client sites.
• Wrote ISO compliant documentation for all database procedures, reference guides, and administration guides for Confidential Team.
• Traveled extensively to international and domestic client sites to resolve escalated issues.
• Supported 30+ internal users, installing, upgrading, and maintaining desktops (Windows NT, Windows 2000 Professional, Windows XP), and server administration (NT Server and Red Hat Linux).
• Responsible for monitoring performance, data integrity, access control, and security of all internal servers.
• Installed and configured Cisco switches and routers.