We provide IT Staff Augmentation Services!

Data Architecture And Analysis Resume Profile

Summary

Advanced Information Technology professional with over 16 years of Senior Database Administration experience. Current in all the latest releases of DB-2, MySQL, DB-2, SQL Server, Oracle, High Availability, RAC, Advanced Security, Data guard, Streams and Grid Controller, E-business Suite and Application Server. Big Data Development. Cloud Technology. Technical Leader, advisor to other projects DBA's. Specialize in managing large multi-tera byte Data Warehouses and Data marts, in high demand environments. Expertise includes Database Security and Performance Tuning. Strong Project Management Skills, and Data Architect experience. Strengths include developing process definition, infrastructure change and policy development. Solutions are secure, maximize performance and anticipate enterprise-wide implementation. Adept with Project Life Cycle approaches and Testing Methodology. Excellent people, instructional and organizational skills. Routinely deliver projects within budget and on schedule. Results driven, deliver information technology that achieves a competitive edge in the market place. Solid experience in a variety of industries.

Skill

Total Yrs Exp.

Yr Last Used

Rank 1-10

  • Data Warehouse Management

16

Current

10

  • Data Architecture and Analysis

16

Current

10

  • Big Data Development NoSQL, Cassandra, MongoDB, CouchDB

  • Apache Hadoop Cassandra

  • Cloud Development

  • Oracle Database Administrator 24 x 7 production support

6

6

8

16

Current

Current

Current

Current

10

10

10

10

  • Database Tuning

16

Current

10

  • Oracle Advanced Security Features

16

Current

10

  • Oracle Application Framework

10

Current

10

  • Oracle Cluster Ware. OCFS and ASM

8

Current

10

  • RMAN

11

Current

10

  • Object Oriented Languages

11

Current

10

  • Project Lead Life Cycle Development

16

Current

10

  • Agile Development Environment

5

Current

10

  • Testing/ Quality Assurance

16

Current

10

  • Oracle Database Admin High Availability RAC, Dataguard, Streams and Grid Controller

8

Current

10

  • Storage Management, Database Replication tools, EMC SRDF, Quest Shareplex, Veritas and IBM Propagator, Informatica, Golden Gate

8

Current

10

  • Support Seibel and PeopleSoft Environments

6

Current

10

  • All Advanced Data Security Modules, Data Vault, Audit Vault

8

Current

10

  • Oracle Identity Manager, Oracle Identity Federation, SUN Identity Manager, Oracle Context Manager,

  • OID, Single Sign On, Oracle Virtual Directory,

  • Oracle Access Manager, Geo-Spatial, XML, Real Application Testing, Change Management

8

Current

10

  • Oracle Application Server Admin High Availability, Apache and Tomcat

8

Current

10

  • Oracle Fusion Ware Layer

  • Oracle E-Business Suite Oracle Business Intelligence Informatica Peoplesoft Oracle Portal Exadata ODSI Admin Console

5

Current

10

  • Hyperion Financial Management, Planning, Financial Data Quality Management, Financial Reporting Studio, Smartview, Essbase

5

Current

10

  • C language

16

Current

10

  • Java

12

Current

8

  • MS SQL Server Database Admin/ High Availability

12

Current

10

  • Microsoft Active Directory

6

Current

10

  • MySQL Database Admin/ High Availability

16

Current

10

  • T-SQL

12

Current

10

  • .Net

5

2008

6

  • MS Analysis Server SSAS/ DTS packages/ Integration SSIS/ Reporting SSRS

12

Current

10

  • Share Point

4

Current

6

  • InfoPath

2

2006

6

  • DB2, Datastage

10

Current

10

  • Teradata, Teradata Viewpoint, TASM,UESM, UDM, Advanced Administration, Backup Recovery, Architectural Design, Performance Tuning, Advanced SQL

10

Current

10

  • Sybase

8

Current

9

  • Salesforce/Salesforce Developer

2

Current

2

  • AIX / HP-UX

8

Current

10

  • Linux/ Sun

16

Current

10

  • Windows NT/ Server

11

Current

8

  • VAX/VMS

2

2006

7

Technologies

  • C/C /C , Korn/Bourne Shell Scripting, Oracle Call Interface, Java, Perl, C , Oracle PL/SQL, MS T-SQL, .Net, Oracle Pro C, Oracle Call Interface, IBM SQL, ASP, JSP, HTML, J2EE, PHP, XML, knowledgeable with Cobol Visual Basic, Cold Fusion , Dreamweaver 2013
  • Oracle 12c , Real Application Clusters RAC, XML architect, Real Application Testing, Provisioning, Configuration Change Management, RMAN, Grid Controller, Data Pump, Data Guard, Flashback Database, Advanced Oracle Security, Advanced Replication, Partitions, Oracle Access Manager, Geospatial, Database Cloning, Golden Gate 12c, Transparent Data Implementations, Kerberos. Backup/Recovery, Application Patches, Exadata v3
  • MS SQL Server 2014, MS Reporting Analysis Services 2008, Oracle Migration Workbench, DB2 UDB 10.0, Data Stage ,Access 2007, DB3, MySql 6.0 High Availability, Informix 11.5, TeraData 13.0 and Sybase 12.5, Postgres 9.3, MongoDB 3.0, Oracle NoSQL, Apache Hadoop Cassandra 2.14, DataStax
  • HP-UX 11.0, AIX 7.0, LINUX, Red Hat 6.0, Sun Solaris 5.10, MS Windows 7, MS Windows Server 2012, MS Active Directory 2003, DEC VAX/VMS, SANS, Veritas, and EMC disk arrays
  • Webpage development,HTML, AJAX, eclipse IDE, SOAP, REST, JavaScript,, Cascading Style Sheets CSS DB2 Stored Procedure, SOA, Web development JSP, Servlet, JMS, JDBC, J2EE Security, Struts, JQuery
  • Oracle Identity Management 9.1.0.2, Web Logic Server 11g, Oracle Data Service Integrator, Hyperion Essebase 11g, Coherence 12.1.3, Oracle Internet Directory OID , Oracle Virtual Directory, Oracle Single Sign On SSO , Oracle Access Manager., Oracle Business Intelligence 11.1.3.5 Peoplesoft 9.2, Oracle E-Business Suite 12.1.3 Informatica Power Center 9.6 , Oracle Fusionware 12c, Oracle Application Server 12i Oracle 12i modules Financials, Customer Relations, Master Data, Procurement, Product Life Cycle Project Management JBoss 7.0 Sun Identity Manager 8.1, Oracle Waveset 8.1,5 Apache Tomcat 8.0 MS IIS Novell Network Oracle Net ssh LDAP ODBC telnet ftp and rpc
  • CA Identity and Access Management 12.5, DataStage 11.3, Agile, Erwin Data Modeler, TOAD for Oracle 12.6, Power Architect/Designer 12.5, Primavera 9.1, Power Builder, QMF, Syncsort, PVCS Version Control, SPSS 2015, MS Office Suite 2007, SAIS, Rogueware Software, Unified Modeling Language UML , Web Matrix, Code Charge, Oracle Forms 12c, Oracle Reports 12c, Oracle J-Developer 12c, Oracle SOA Suite, Oracle SQL Developer 4.1, MS Visual Developer, SharePoint Server 2007, InfoPath 2003, Microsoft Operations Manager, patrol, big brother, Cygwin, cacti, nagios and putty

Positions Held James E Nihill llc 01/2002 to current

Confidential

  • Project Description Sybase, Senior Oracle 11g, Data Architect, High Availability, Advanced Oracle Security and Performance Tuning, MS SQL Server 2012 Admin and Performance Tuning.
  • Developing Oracle 11.2 Hi-Available for key OTLP application's. Developing plsql orcle objects, query tunning. Developing normalized Data Architecture. Implementing advanced security featurs. Deployed audit and data vault. Performing Oracle sys support. Configured OIM 11g. Demonstrated Big Data Hadoop laaS and PaaS Developmnt. Deployed Datastax Enterprise, Openwave and Backupfy. Deployed Cassandra Database..
Confidential Project Description
  • Senior Oracle 11g, Data Architect, High Availability, Advanced Oracle Security and Performance Tuning,MS SQL Server Admin 2012 and 2014 and Performance Tuning.
  • Migrated SAP environments to exadata environment. Generating data architecture for an Oracle 11g environment. Generating pl/sql code to support ETL functiona, and maintain data architecture.Installed, configured and migrated Exadata release 3. Installed and Configured OIM 11g. Configured 6 exadata x3-2 data storage appliances. Configured backup and recovery of the DBFS file system and RECO recovery system. Made system modifications to improve performance. Assisted with resolution of production support. Installed Installed Oracle Enterprise Manager 12.1.0.1. DBA responsibility on 600 MS 2012 and 2014 environments
  • Developed and implemented Big Data Hadoop Solution to assist insurance company with managing large volume of documents. Deployed DataStax Enterprise, Openwave and Backupfy. Deployed Cassandra Databases.
Confidential Project Description
  • Teradata, Senior Oracle 11g, Data Architect, High Availability, Advanced Oracle Security and Performance,Tuning,MS SQL Server 2012 Admin and Performance Tuning.
  • Developing Web apps using Dreamweaver, Coldfusion 10. Web app supports high volumn US postal customers. Generating data architecture for an Oracle 11g environment. Generating pl/sql code to support ETL functiona, and maintain data architecture.Installed, configured and migrated Exadata release 3. Installed and configured OIM11g Demonstrated Big Data Hadoop soution to assist in managing large volumn of mail. Deployed Cassandra, and Backupfy.
Confidential Project Description
  • Senior Oracle 11g, Data Architect, High Availability, Advanced Oracle Security and Performance Tuning,MS SQL Server 2012 Admin and Performance Tuning.
  • Migrated Oracle Forms and Reports Server 10g, onto Oracle Forms and Reports 11g. Upgraded Oracle 10g to Oracle 11g Database Server. Migrated 80 legacy forms and tested. Configure Oracle High Avalability. System ran on Windows 2008 R2 Database Server.

Confidential

  • Project Description Teradata, DB2, Senior Oracle 11g, Data Architect, High Availability, Advanced Oracle Security and Performance Tuning, Exadata , MS SQL Server 2012 Admin and Performance Tuning.
  • Developing Oracle 11.2 Hi-Available for key OTLP application's. Developing plsql orcle objects, query tunning. Developing normalized Data Architecture. Implementing advanced security featurs. Deployed audit and data vault. Utilizing BI Publisher to track key metrics, support quality improvement. Performing Oracle sys support. Configured OIM 11g.
  • Developed Big Data Hadoop solution to assist AT T to manage paper documents. Deployed Cassanra and DataStax Enterprise.

Confidential

  • Project Description Teradata, DB2, Senior Oracle 11g, Data Architect, High Availability, Advanced Oracle Security and Performance Tuning, Exadata, MS SQL Server 2008 Admin and Performance Tuning.
  • Deployed E-Business Suite 12.1.3 on AIX 6.3 Operating System. Delpoyed Oracle Business Intelligence Enterprise Edition 11.1.3.5 on AIX 6.3 Operating System. Installed Informatic 9.1 on AIX 6.3 environment. Deployed Oracle RDBMS 11.2 on 6.3 Operating System. Deployed Hyperion/Essbase. Installed OC4J Stand alone Server on AIX 6.3 environment. Overcame numerous hurddles, in the Oracle install software, that Oracle support had not considered. This allows Omnicare to leverage the most current E-Business and OBIEE technology. System included weblogic server 10.3.5, fusionware enterprise manager, BI server, BI publisher and real-time decisions.Installed Exadata v2 sorage appliance. Proposed architecture that streamed Oracle Databases, promises to reduce over head and costs by 75 . Installed, configured and migrated Exadata release 3. Implemented OIM11g
  • Developed and Implemented BigData Hadoop solution to manage large volume of paper documents in the PBM industry. Deployed Cassandra.

Confidential

  • Project Description Teradata, DB2, Senior Oracle 11g, DB-2, MySQL, Data Architect, High Availability, Advanced Oracle Security and Performance Tuning, MS SQL Server 2008 Admin and Performance Tuning.
  • Migrated dev, test and production 11.5.1 E-Business Suite Server between Oracle 10g onto Oracle 11g. HP-UX 11.0 servers. Developed migration plan to port data between the legacy system and the new database. Federal office utilized HR funtionalitly in the E-business Suite. Developed user acceptance plan. Incorporated ASM and Golden Gate functionality. Implemented OIM 11g.

Confidential

  • Project Description Teradata, DB2, Senior Oracle 11g, MySQL, Data Architect, High Availability, Advanced Oracle Security and Performance Tuning, Mult TB, Exadata, MS SQL Server 2008 Admin and Performance Tuning.
  • Developed a business continuation plan. Upgraded 9i Oracle environment to 11g. Implemented disaster recovery solution incorporating DataGuard, RAC, ASM and GoldenGate technologies. Datagard protects against unplanned outages, while goldengate facilitates planned outages. This database supports online transactional processing. small business users. Intuit offers a suite of web enabled accounting tools, database is about 500GB in size, and expect growth to approach 1TB. System ran on Solaris. Application tier ran Apache web servers. Instructed dba's on use of exadata v3 storage appliance. Coordinated with business users and developed user acceptance plans. Implemented OIM 11g .
  • Demonstrated and implemented a Big Data Hadoop Solution to assist Intuit in financial management. Deployed Cassandra.

Confidential

  • Project Description Teradata, Senior Oracle 11g, MySQL, DB-2, Data Architect, Indentify and Access Management, Advanced Oracle Security and Performance Tuning, Multi TB environment, Exadata, MS SQL Server 2008 Admin and Performance Tuning.
  • Database supports Oracle Identity Management and Access Management, Databases are running on Linux environments. Developing Identity management environment for Ally Financial Services and IBM, utilizing CA products. Overhauling IBM's Identity Management, meet compliance criteria. Assiting with system migration of GMAC resources into IBM managed environments. Oracle 11g High Available, RAC, Advanced Replication. Utilizing HP-UX, AIX, Solaris, Windows and Linux servers. EMC and Veritas Disk Arrays. Providing 24 x 7 production support. Implemented OIM 11g.
  • Demonstrated Big Data Hadoop capabilities . Deployed Cassandra.

Confidential

  • Project Description Teradata, Senior Oracle 11g, MySQL 5.0, DB-2, Data Architect, Advanced Oracle Security and Performance Tuning, Multi TB environment, MS SQL Server Admin 2008 and Performance Tuning.
  • UNFI provides warehouse and distribution for Whole Foods groceries. Database supports Manhattan Application software, with the functions of receiving and invoicing dry and perishable goods. Application utilizes bar code scanners and voice recognition software. Implemented advanced security including encryption, authentication and data integrity methodologies. Developing Fusion Middleware layer, Oracle Identity Management and Oracle Identity Federation, to provide enterprise wide user identity. Architecting and implementing an Oracle 11g High Available RAC System running on AIX 6L environment. EMC storage arrays. Implemented Golden Gate. Providing 24 x 7 Data Base administrative support. Implemented OIM 11g.
  • Demonstrated Big Data Hadoop Solution to help UNFI manage purchase orders and warehouse. Deployed Cassandra.
Confidential
  • Project Description Teradata, DB2, Senior Oracle 11g, DB-2, MySQL 5.0, Data Architect, Advanced Oracle Security and Performance Tuning. Exadata, Multi TB environment, MS SQL Server 2008, Admin and Performance Tuning.
  • Developing HIPPA compliance criteria. Independent Health provides medical insurance coverage. Supporting a Siebel 7.8 to 8.1 upgrade project. Implemented advanced security including encryption, authentication and data integrity methodologies. Developing Fusion Middleware layer, Oracle Identity Management and Oracle Identity Federation, to provide enterprise wide user identity. Architecting and implementing an Oracle 11g High Available RAC System running on AIX 6L environment. Utilized IBM storage arrays. Installed Audit Vault and Data Vault. Demonstrated Golden Gate. Providing 24 x 7 Data Base administrative support.
  • Developed and implemented Big Data Hadoop Solution to assist in the medical insurance management. Deployed Cassandra
Confidential
Project Description
  • Senior Oracle 11g,DB-2, Data Architect, Advanced Oracle Security and Performance Tuning, Multi TB environment
  • Providing application and development support for an Oracle 11.5.1 Financials environment. Supporting Accts payable, Accts Receivable, Project, HRMS, General Ledger and customed tailored financials interface. System running on AIX 5L environment. Implemented advanced security including encryption, authentication and data integrity methodologies Installed Audit Vault and Data Vault. Developing Fusion Middleware layer, Oracle Identity Management and Oracle Identity Federation, to provide enterprise wide user identity. Assisted MSD in meeting security criteria in their financial regulatory department. Demonstrated Golden Gate. Providing 24 x 7 Data Base administrative support.
Confidential

Project Description

  • Teradata, DB2, Senior Oracle 11g, MySQL 5.0, Data Architect, Advanced Oracle Security and Performance Tuning, Supported 10 TB's of data, MS SQL Server 2008 Admin and Performance Tuning.
  • Providing application and development support for an Oracle 11.5.1 Financials environment. Supporting Accts payable, Accts Receivable, Project, HRMS, General Ledger and customed tailored financials interface. System running on Solaris 10, M9000 environment and Exadata. Application supports SDDC, Transportation Command at Scott AFB. Implemented advanced security including encryption, authentication and data integrity methodologies. Developing Fusion Middleware layer, Oracle Identity Management and Oracle Identity Federation, to provide enterprise wide user identity. The application tracks accruals in the Billions of dollars. Additionally, the environment supports SECRET classified data. Assiting with a migration plan into Oracle 11g and 12i. additionally leveraging Oracles high availabilty and Web Logic. Recommended the use of Oracle's Unbreable Linux, and commodity based servers, to further reduce system OS and hardware costs by 70 to 80 . Providing Data Base administrative support.
Confidential

Project Description

  • Teradata, Senior Oracle 11g, DB-2, MySQL, Data Architect, Advanced Oracle Security and Performance Tuning, 10 TB's of data, Exadata, MS SQL Server 2008 Admin and Performance Tuning.
  • 15 Million project with the Constellation Brands to install RAC 11g and Application Servers onOracle Unbreakable Linux . MS SQL Server migration project, installed rdbms, clusterware, rman, real application testing, configuration change management, provisioning, dataguard, streams, xml, asm and advanced 11g High Availability functionality. Migrating 150 legacy applications into 11g RAC. Assisting Constellation Brands with the selection of E-Business Suite, JD Edwards, Siebel and Peoplesoft, applications to meet business needs. Implemented advanced security including encryption, authentication and data integrity methodologies. Leveraging Oracle Content Manager, Oracle Access Manager and Oracle Idenity Manager. About 10 tera-bytes involved in the migration. Performing 24 x 7 database support. Providing training on grid controller and 11g high availability functionality. Identified data architectural change, to leverage database efficiencies, and minimize millions in hardware costs. Demonstrated Golden Gate. Configured Oracle User Enterprise Security, OID in 11g environment. Installed Exadata v1 storage appliance. Implemented OIM 11g.

Confidential Project Description

  • Teradata, Senior Oracle 11g, DB-2, MySQL 5.0, Data Architect, Advanced Oracle Security and Performance Tuning, MS SQL Server Admin 2008 and Performance Tuning.
  • Deployed and tuned an Oracle XML Server for a defense Contractor in Washington, DC. Mentored Staff on its use and developed administration documentation. Implemented advanced security including encryption, authentication and data integrity methodologies. Installed Oracle Identity Federation Manager, for a Defense Contractor in Restin, VA. Mentored staff on its use and developed administration documentation. Implemented advanced security including encryption, authentication and data integrity methodologies

Confidential Project Description

  • Teradata, Senior Oracle 11g,DB-2, Data Architect, Advanced Oracle Security, Security and Performance Tuning, Supported 70 TB's of data, MS SQL Server 2008 Admin and Performance Tuning.
  • 5 Million project with the State of Michigan to install RAC 11g on Solaris 10 and Sun Clusters. Sun Oracle Database Machine and Exadata. 9i migration project, installed rdbms, clusterware, rman, real application testing, configuration change management, provisioning, dataguard, streams, xml, asm and advanced 11g High Availability functionality. Migrating 75 x 9i development and 35 x 9i production instances into 11g RAC. About 70 tera-bytes involved in the migration. Performing 24 x 7 database support. Providing training on grid controller and 11g high availability functionality. Identified data architectural change, to leverage database efficiencies, and minimize millions in hardware costs. Configured Golden Gate Replecation software, conducted proof of concept against Oracle Streams. Configured Oracle User Enterprise Security, OID in 11g environment.
Confidential

Project Description

  • Teradata, Senior Oracle 10g, DB-2, Data Architect, Advanced Oracle Security and Performance Tuning, Supported 70 TB's of data, MS SQL Server 2008 Admin and Performance Tuning.
  • 24 x 7 Production Support for Sql Server and Oracle. Developing 35 Million project to migrate 9i databases into Oracle 10g RAC and Linux. Sarbannes Oxely compliance. Prototyping RedHat Linux/ Oracle 10G RAC, utilizing EMC disk arrays. Developing migration plan to migrate over a 100 x Oracle 9i instances into Oracle 10G RAC. Currently, procurring hardware and software. Project plans to implement migration. Second phase facilitate migration across all of Citi's Data Centers. Identified oppurtunities to tighten database security. Administered Oracle 11i Application Servers and E-business suites. Oracle OID, Virtual Directory, SSO, Access Manager. MS Active Directory. Oracle Access Management. Proto-typed 11g RAC, high availability, asm and rdbms on AIX platforms. Configured Oracle User Enterprise Security, OID in 10g environment.
Confidential

Project Description

  • Teradata, Senior Systems Engineer, Data Architect, Oracle DBA, DB-2, MySQL 5.0, supported 15 TB's of data, MS SQL Server Admin 2008 and Performance Tuning.
  • Over saw development and deployment of Mobile Advertising application, that deliver banners to mobile phones. Brand new revenue stream for AT T and Yahoo. The jumptap application utilizes open source technologies including RedHat, Apache, Tomcat, MySQL and Oracle 10g RAC. Configured Database Backups, Replecation disaster recovery procedures. The open source technology generates considerable savings in licensing fees. These technologies provide comparable and even better performance in deference to thier licensed conterparts. Implemented monitoring services including patrol, cacti and nagios. Assisted with User Acceptance planning, insure service level agreements were being met. Efforts insured that application will reach production on schedule and under budget. Migrated 10g RAC into 11g RAC. Managed Golden Gate server, to replicate data off of primary database server to to support report processing. Configured Oracle User Enterprise Security, OID in 10g environment.

Hire Now