I have a strong understanding of both relational and dimensional modeling and experience with working on large database systems 5 Terabytes. During my years of experience, I have been involved in the design, development, migration, and implementation of software solutions utilizing my proficiencies in Oracle Database Engineering and Administration Application DBA and Operation DBA , Data Modeling, and Data Warehousing. Oracle Certified Professional OCP with 16 years of professional experience in the Information Technology industry, I have gained knowledge in all phases of software development life cycle. I’m not aware of any reason to still use the old version, unless maybe you need a specific ojdbc version but presumably there are use cases or it wouldn’t still be listed prominently for. It doesn’t matter if the database you’re connecting to is still 10g, you can use the 11g client. The 11gR2 64-bit instant client works on 10.8.5.
Oracle 10G Client Mac OS XIts Oracles UCM 10g) and it always throws an exception like this: An.Download the latest version of Oracle 10g for Mac - Database solution for Mac OS X Server. Oracle Database Companion CD Installation Guide 10 g Release 1 (10.1) for Apple MAC OS X.Oracle8i/9/i10g/11g/12c, Oracle 11g Real Application Cluster RAC , Oracle Data Guard 11g , Recovery Manager RMAN , Oracle Automatic Storage Management ASM , Automatic Workload Repository AWR , Enterprise Manager 12c OEM /Grid Control, Oracle E-Business Suite 12.1.1, Oracle GoldenGate 11g, UNIX/LINUX Shell Scripting, PL/SQL, SQL, SQL Loader, Oracle Data Pump, Erwin, Oracle Warehouse Builder OWB , SQL Developer, TOAD, MYSQL, SQL Server, MS Access , Visual Basic, ASP, HTML, and JavaScript.The data is uploaded as zip files to Oracle UCM, which is processed by the HCM. Oracle Database Client Quick Installation Guide 10 g Release 1 (10.1.0.3) for Apple MAC OS X.Introduction to UNIX Programming 2001 Global Knowledge Oracle Programming PL/SQL 2001 Learning Tree International Oracle Warehouse Builder 9i 2004 Oracle University Oracle 10g Database Administration 2006 Learning Tree International Installed and configured Oracle 11gR2 Grid Infrastructure/Real Application Cluster RAC , Oracle 11gR2 and Oracle 12c RDBMS, Enterprise Manager 12c, and GoldenGate 11g. Recommend and implement Oracle Database partitioning and indexing strategy, perform capacity planning, monitor database usage, configure and manage ASM disks, identify and resolve performance issues, address defragmented objects, and enable resumable space allocation to facilitate batch loads. Responsible for providing all aspects of Database Engineering and Administration support for multiple environments development, test, and production. Both FDsys and ePassport resides on a LINUX / Oracle 11g RAC with Automatic Storage Management ASM architecture platform configured with a physical standby database using Oracle Data Guard. Oracle Database Architect/DBA for the Federal Digital System FDsys and Electronic Passport ePassport project for the Government Printing Office GPO.Clone database onto different environments with different ASM configuration using RMAN, transfer Oracle datafiles from file system storage to ASM storage, migrate Oracle managed files from with 32k blocksize to an environment with different 8k blocksize using transportable tablespace, and create restore points to flashback database. Maintain data model using ERWIN and ensure both logical and physical data model conforms to FINCEN's naming standards. Implement partitioning, indexing, parallelism, and database backup strategies for all environments cold backups and RMAN. Responsible for providing Oracle engineering and Database Administration support, maintaining both the logical and physical data model, recommending data warehouse best practices for fast data loads, database design, and database configuration. Hyundai tucson 2013 dashboard symbols and meaningsSignificantly improve the performance for SFCDM by recommending best indexing and partitioning strategies, utilizing parallelism, creating materialized views, and formulating solutions for fast data refresh and data loads. Provide Oracle Database Engineering and Administrative support, data modeling, and data warehouse expertise to improve the overall design and performance of SFCDM. The SFCDM data mart is on a LINUX / Oracle 11g RAC with Automatic Storage Management ASM architecture platform with 5 terabytes of data. Solution Architect/DBA for the Single Family Credit Data Mart SFCDM project for Freddie Mac. Create and maintain Oracle objects and thresholds, generate AWR snapshots and ADDM reports, and resolve database performance issues using Oracle Grid Control. Developed and automated a migration script using Unix Shell and PL/SQL to ensure all database objects are synchronized in each environment, reviewed, corrected, and performance tuned developer's scripts SQL, PL/SQL , and managed all migration efforts while following the CM process. Responsible for the overall design, development, and maintenance of both physical and logical model for both CRMIS Case Review Management Information System and MIS Management Information System Data Warehouse System for CMS Center for Medicare and Medicaid using dimensional modeling, recommend data warehouse best practices and data load strategies, provide Oracle Database Administration support, and produce project documents database design document, system design document, and operation and maintenance manual documentation. Provide data warehouse proficiency, data modeling, and Oracle database administrative support for various projects for CGI's Business Intelligent Group. Performance tune, monitor, and resolve application related issue with E-Business Suite R11 EBS. Analyze and monitor multiple Oracle 11g RAC database using Oracle Grid Control. Install patch on Oracle 11g RAC /Automatic Storage Management ASM. Created a project plan to meet both short-term and long-term strategies to extend and improve SFCDM project at the database architecture layer, application layer, database design layer, and infrastructure layer. Provide database administrative support to Avanco projects. Designed developed, and implemented an Enterprise Data Warehouse System for the EMDS Enterprise Management Decision Support project for Deputy Under Secretary of the Army Business Transformation DUSA-BT. Ensure both LDM and PDM conforms to CMS's data architectural guidelines. Develop and implement database backup strategies for both CGI and CMS's environment using RMAN. Analyzed US Army KEYVIEW Data warehouse for restructuring and modernizing into a dimensional data warehouse. Designed and developed KEYSTONE Data Warehouse System using Erwin Data modeling tool, Oracle Warehouse Builder 10g OWB , PL/SQL, and Oracle 10g database. Defined methodologies and business rules, established performance and technical standards, and interact with customer and team to formulate system architect. Responsible for the design, development, maintenance of both physical and logical data model for EMDS using dimensional modeling, analyze both business requirements and Army data to translate into technical design, develop and performance tune ETL mappings, develop refresh strategies, and develop PL/SQL procedures/functions and dimensional objects utilizing the OLAP catalogue. Provided data migration support and recommended data load strategies for Total Force Data Warehouse TFDW on LINUX/Oracle9i platform system for the United States Marine Corp using Oracle Warehouse Builder 9.2. Lead and mentored development team to design and develop efficient ETL mappings and data warehouse process. Install and configure Oracle 10.1 database, perform database backups, create and manage oracle objects DDL, sequence, indexes, and tablespaces , and performance tuned both database and ETL mappings. Responsible for all database administrative tasks.
0 Comments
Leave a Reply. |
AuthorElpotrero ArchivesCategories |