Sql server architect

-
loading
Ads with pictures

ACCENTURE IS HIRING B.TECH CS/IT/ECE

For Details to apply call Mr. Souvik Chowdhury @ Accenture Hiring Software Developers For Engineering Graduates on Sep @ Across India Company Name Accenture Services Pvt Ltd Company www.accenture.com Experience 0 3 Years Salary Not Mentioned Qualification BE/ B.Tech Computers Skills Cloud Open Stack Architect Job Role Software Developers Job Location Across India Job Type Apply Last date to apply Sep About Company: Accenture is a global management consulting, technology services and outsourcing company. Combining unparalleled experience, comprehensive capabilities acrossindustries and business functions, and extensive research on the world s most successful companies, Accenture collaborates with clients to help them become high-performance businesses and governments. Description: Role: Cloud Open Stack Architect Eligibility Criteria: BE /B.Tech/MCA (Full time course only) 60% and above in graduation No Current Backlog Not more than 2 years of gap in education. Candidate working with Accenture on contractual basis will not be eligible to participate in this drive. Foreign national should mandatorily have OCI / PIO card else candidate will not be eligible to participate in this drive. Pan Card is mandatory Candidates must be willing to work on shift basis, willing to relocate as per business demand & fixable to work on call taking roles. Knowledge and Skills Familiarity with IT Systems Ability to be flexible and work analytically in a problem-solving environment Good communication (written and oral) and interpersonal skills Good Voice & Accent Ability to resolve technical issues and escalate issues when appropriate Good Attitude and willingness to learn Job Responsibilities: Responsible for supporting the Service Desk/ IT Infrastructure Monitoring/ Other Infrastructure jobs to ensure services are delivered to meet customer business needs and expectations Skill: Cloud Open Stack Architect Minimum Skill Requirement: Extensive knowledge on Cloud Open stack Platform. Should be involved in the planning, design, and deployment of Cloud solutions. The ideal candidate will have an understanding of WAN, LAN, TCP/IP, VPN, networking, and Infrastructure as a Service (IaaS). Should be able to perform cost analysis for websites, virtual machines, storage, cloud services, data management within Azure platform Preferred Certification in the relevant Skill Eligibility: Will provide system logical view, network diagram with multi-tier architecture Should be able to build solution in patch management for OS, COTS, etc. Deliver design and system configuration detail information to Project Team with support documents and Q and A sessions. Should have worked on Cloud Administration tasks such as creating Affinity Group, Storage Accounts, Cloud Services, VPN, DNS server and VPN connectivity. Conversant in using Microsoft Azure VPN client to set up point-to-site VPN connection. Should be able to set up site to site VPN connection between client data center and Azure cloud Should be able to create VMs, install CentOS Linux OS on VM servers, Create user accounts and Linux security required access control for web server, application server, Hadoop server, graph database server, patch server. Build MS SQL Server and create SQL database in data tier. Install Apache on web server with Linux OS in web tier. Experienced in integrating web server, application server, Hadoop server, graph database server and SQL server with required firewall ports. Should have set up Geo-Replication. Provide maintenance support (weekly patch install, start/shut down VM servers, services, install COTS). Document end-to-end system configuration, setup, and baseline configuration in detail. Should be able to analyze data and take decisions 16. Should be able to plan the deliverables and execute on time Good to Have: Good presentation and documentation skill Good inter-personal and analytical skill ITIL Process knowledge Good in stakeholder management, risk & issue management Project Management Skill Due-diligence Experience Transition Experience
India

ACCENTURE IS HIRING SOFTWARE DEVELOPER

Accenture Hiring Software Developers For Engineering Graduates on Sep @ Across India Company Name Accenture Services Pvt Ltd Company www.accenture.com Experience 0 3 Years Salary Not Mentioned Qualification BE/ B.Tech Computers Skills Cloud Open Stack Architect Job Role Software Developers Job Location Across India Job Type Apply Last date to apply Sep About Company: Accenture is a global management consulting, technology services and outsourcing company. Combining unparalleled experience, comprehensive capabilities acrossindustries and business functions, and extensive research on the world s most successful companies, Accenture collaborates with clients to help them become high-performance businesses and governments. Description: Role: Cloud Open Stack Architect Eligibility Criteria: BE /B.Tech/MCA (Full time course only) 60% and above in graduation No Current Backlog Not more than 2 years of gap in education. Candidate working with Accenture on contractual basis will not be eligible to participate in this drive. Foreign national should mandatorily have OCI / PIO card else candidate will not be eligible to participate in this drive. Pan Card is mandatory Candidates must be willing to work on shift basis, willing to relocate as per business demand & fixable to work on call taking roles. Knowledge and Skills Familiarity with IT Systems Ability to be flexible and work analytically in a problem-solving environment Good communication (written and oral) and interpersonal skills Good Voice & Accent Ability to resolve technical issues and escalate issues when appropriate Good Attitude and willingness to learn Job Responsibilities: Responsible for supporting the Service Desk/ IT Infrastructure Monitoring/ Other Infrastructure jobs to ensure services are delivered to meet customer business needs and expectations Skill: Cloud Open Stack Architect Minimum Skill Requirement: Extensive knowledge on Cloud Open stack Platform. Should be involved in the planning, design, and deployment of Cloud solutions. The ideal candidate will have an understanding of WAN, LAN, TCP/IP, VPN, networking, and Infrastructure as a Service (IaaS). Should be able to perform cost analysis for websites, virtual machines, storage, cloud services, data management within Azure platform Preferred Certification in the relevant Skill Eligibility: Will provide system logical view, network diagram with multi-tier architecture Should be able to build solution in patch management for OS, COTS, etc. Deliver design and system configuration detail information to Project Team with support documents and Q and A sessions. Should have worked on Cloud Administration tasks such as creating Affinity Group, Storage Accounts, Cloud Services, VPN, DNS server and VPN connectivity. Conversant in using Microsoft Azure VPN client to set up point-to-site VPN connection. Should be able to set up site to site VPN connection between client data center and Azure cloud Should be able to create VMs, install CentOS Linux OS on VM servers, Create user accounts and Linux security required access control for web server, application server, Hadoop server, graph database server, patch server. Build MS SQL Server and create SQL database in data tier. Install Apache on web server with Linux OS in web tier. Experienced in integrating web server, application server, Hadoop server, graph database server and SQL server with required firewall ports. Should have set up Geo-Replication. Provide maintenance support (weekly patch install, start/shut down VM servers, services, install COTS). Document end-to-end system configuration, setup, and baseline configuration in detail. Should be able to analyze data and take decisions 16. Should be able to plan the deliverables and execute on time Good to Have: Good presentation and documentation skill Good inter-personal and analytical skill ITIL Process knowledge Good in stakeholder management, risk & issue management Project Management Skill Due-diligence Experience Transition Experience For Details call @ Souvik Chowdhury
India

SOFTWARE ENGINEER IN ACCENTURE SERVICES.

Description: Role: Cloud Open Stack Architect Eligibility Criteria: BE /B.Tech/MCA (Full time course only) 60% and above in graduation No Current Backlog Not more than 2 years of gap in education. Candidate working with Accenture on contractual basis will not be eligible to participate in this drive. Foreign national should mandatorily have OCI / PIO card else candidate will not be eligible to participate in this drive. Pan Card is mandatory Candidates must be willing to work on shift basis, willing to relocate as per business demand & fixable to work on call taking roles. Knowledge and Skills Familiarity with IT Systems Ability to be flexible and work analytically in a problem-solving environment Good communication (written and oral) and interpersonal skills Good Voice & Accent Ability to resolve technical issues and escalate issues when appropriate Good Attitude and willingness to learn Job Responsibilities: Responsible for supporting the Service Desk/ IT Infrastructure Monitoring/ Other Infrastructure jobs to ensure services are delivered to meet customer business needs and expectations Skill: Cloud Open Stack Architect Minimum Skill Requirement: Extensive knowledge on Cloud Open stack Platform. Should be involved in the planning, design, and deployment of Cloud solutions. The ideal candidate will have an understanding of WAN, LAN, TCP/IP, VPN, networking, and Infrastructure as a Service (IaaS). Should be able to perform cost analysis for websites, virtual machines, storage, cloud services, data management within Azure platform Preferred Certification in the relevant Skill Eligibility: Will provide system logical view, network diagram with multi-tier architecture Should be able to build solution in patch management for OS, COTS, etc. Deliver design and system configuration detail information to Project Team with support documents and Q and A sessions. Should have worked on Cloud Administration tasks such as creating Affinity Group, Storage Accounts, Cloud Services, VPN, DNS server and VPN connectivity. Conversant in using Microsoft Azure VPN client to set up point-to-site VPN connection. Should be able to set up site to site VPN connection between client data center and Azure cloud Should be able to create VMs, install CentOS Linux OS on VM servers, Create user accounts and Linux security required access control for web server, application server, Hadoop server, graph database server, patch server. Build MS SQL Server and create SQL database in data tier. Install Apache on web server with Linux OS in web tier. Experienced in integrating web server, application server, Hadoop server, graph database server and SQL server with required firewall ports. Should have set up Geo-Replication. Provide maintenance support (weekly patch install, start/shut down VM servers, services, install COTS). Document end-to-end system configuration, setup, and baseline configuration in detail. Should be able to analyze data and take decisions 16. Should be able to plan the deliverables and execute on time Good to Have: Good presentation and documentation skill Good inter-personal and analytical skill ITIL Process knowledge Good in stakeholder management, risk & issue management Project Management Skill Due-diligence Experience Transition Experience For Details call @ Souvik Chowdhury
India

VERY URGENT REQUIREMENT PROJECT MANAGER (IT FIELD)

Skills and Qualifications: Technical Management, Technical Understanding, Analyzing Information, Informing Others, Staffing, Problem Solving, Data Center Management, Developing Budgets, Coordination, Strategic Planning, Quality Management. 3 - 8 years of total experience. 2+ years of. Net development experience on latest technologies. 2+ years of experience on managing team & project. Hands-on Project Lead with strong experience in projects delivery utilizing C#, ASP. Net, SQL Server. Possess competence in web application design, development, deployment, system analysis and Implementation of various applications, including client/ server application development using various tools like. NET Framework 4. x, Visual Studio 2010/ 2013, ASP. NET, C#, SQL Server 2008 R2/ 2012, BI, experience in TFS, Microsoft Project, Enterprise Architect, Visio. Hands on experience in designing, development and deployment of web & mobile applications. NET, ASP. NET MVC & Web Forms, C#, WCF, LINQ, JavaScript/ jQuery, AJAX, XML, JSON. Comprehensive experience in software development/ IT industry, implementation of business applications/ solutions within preset budgets and deadlines. Develop project test management plan, direct and manage test execution, monitor and control project work, integrated change control management. Extensive experience in a product-based environment in the capacity of a technically hands-on project manager on the Microsoft technologies platform. Manage software production support, data migration and maintenance of existing applications.
India

SENIOR SOFTWARE ENGINEER (.NET MVC) PROFILE

Dear All, Greetings from DCHS InfoTech Pvt. Ltd., Pune We are having urgent opening for senior software engineer (.NET MVC) profile with our client Company. Please find below details Description We are looking for a strong.NET developer for our medical services product. You will work with a team of developers and help build a state-of-the-art.NET MVC software system. We’re looking for an experienced developer with a solid track record of shipping scalable, high-quality, enterprise-grade web applications and services. Requirements: • At least 5 years of experience in developing.NET MVC applications • Experienced in writing WCF services • Hands on work experience in architect and design • Interact with Quality Assurance staff and members of the software development team to ensure the product meets functional requirements prior to distribution to clients Qualifications: • Strong experience in MVC 3 or 4 projects implementation using.NET 3 or 4 • Strong experience in WCF services, Ajax, DHTML, CSS and JavaScript • Strong skills in MS SQL Server including procedures, views, handling complex queries, etc. • Experience in SSRS Reporting Services • Strong knowledge of cross-browser compatibility concerns and performance • Knowledge of website security best practices. • Strong analytical skills. • Software development experience with public facing websites, multi-tier development. • Strong testing and debugging skills • Software architecture experience is a plus. • Follow version control practices • Have worked on enterprise level projects, able to work independently and in a team • Education: B.E/B.Tech, MCA If interested, kindly share your resume at, or give us call at, . Regards, Kaveri Parit DCHS InfoTech Ltd., Pune
India

FOREST SURVEY OF INDIA RECRUITMENT

Forest Survey of India (FSI) Dehradun invites applications for engagement of Technical Professionals for DIP / GIS / MIS related work under various Projects/ Plan Scheme. The last date for submission of applications is 4th September . About: Forest Survey of India (FSI) is a national organization under the Ministry of Environment, Forests & CC, Government of India and is responsible for forest resource assessment of the country. Name of the Post: Technical Associates No of Vacancies: 28 Emoluments (Per Month): % HRA) Name of the Post: Solution Architect (Application/ Software's) No of Vacancies: /- All inclusive Name of the Post: Senior Developer -GIS Expert No of Vacancies: 01 Emoluments (Per Month): /- All inclusive Name of the Post: Database Administrator No of Vacancies: 01 Emoluments (Per Month): /- All inclusive Name of the Post: Softwares Supports Executives (Application) No of Vacancies: 01 Emoluments (Per Month): /- All inclusive Name of the Post: GIS Analyst No of Vacancies: 01 Emoluments (Per Month): /- All inclusive Age Limit: The upper age limit is 30 years as on the last date of submission on online application. The upper age limit is relaxable upto 5 year in the case of candidates belonging to SC/ST/OBC/PH. Educational Qualifications: Technical Associate -> Post Graduate in Science/ Environmental Science/ Applied Science/ M.A Geography OR Post Graduate/ Diploma in RS & GIS from a recognised University/Institution. Working knowledge of DIP/GIS. Solution Architect (Application/ Softwares) -> Essential - Must have a graduation degree in Engineering or MCA or M. Tech. Must have a minimum 8+ years' experience in Solution Design. Desirable - Should be responsible for creating or selecting the most appropriate architecture for a system (or systems), such that it suits the needs, satisfies user requirements, and achieves the desired results under given constraints. Senior Developer/ GIS expert -> Essential - Should have a Post Graduation degree in Geo-Sciences/ Geo-Informatics/MCA. Minimum 7 years technical experience working within the GIS domain. Desirable - Should have Expert in GIS solutions like: ArcGIS Server and extensions Desktop and extensions, ArcGIS Mobile, AGOL/PFA, ArcGIS Pro,Other GIS Software's. Database Administrator -> Essential - Should have a graduation degree in Engineering or MCA or M. Tech with relevant industry certifications Should have a minimum 7+ years' experience in Database Administration. Desirable - Must have experience in managing 2-3 GIS technology Projects / Spatial databases. Software Support Executive -> Should be B.E./B.Tech. Computers Science / M.C.A. 6+ Years of Experience as a programming and testing for GIS technology solutions. Skilled in Flex,.NET,php frame work. Desirable - Knowledge of using relational database, Microsoft SQL, Postgre SQL, MySQL. GIS Analyst -> Essential - Should be Masters in Science/Geography / Remote Sensing / Computer Science/Geo informatics / Geology/ Environmental Science. Must have an experience of 4+ years in performing GIS related work, on server & Desktop Applications. Desirable - Experience handling Spatial Data bases / Remote Sensing / Image processing / Socio-economic data with GIS applications and Working in reputed organisation. Selection Process: The short listed candidates will have to produce the original application form duly signed and photograph affixed on it on the day of selection test. The candidates will have to produce all their original documents on the day of selection test. The selection test may comprise of a written test and/or hands on test and/or interview. Selection will be done on the basis of their qualification, experience and their performance in the written test and/or hands on test and/or interview. Decision of the Director General, FSI will be final. No TA/ DA will be paid for appearing in the test/ interview. The short listed candidates will be intimated over phone and/or e-mail for a selection test which is tentatively scheduled in the third / fourth week of September, . How To Apply: The duly filled up application form after signature has to be scanned and sent as e-mail attachment to FSI (e-mail: ). The scanned copy of the application form along with attested copy of experience certificate should reach FSI through e-mail latest by 5.30 pm of . Detailed Advertisement: http://fsi.nic.in/uploads/documents/doc__requirement_of_ technical_professionals_at_fsi-.pdf Download Application Format: http://fsi.nic.in/uploads/documents/doc__application_for _technical_professionals_at_fsi-.pdf
India

PROFESSIONAL TRAINING ON ORACLE 11G DBA: 3RI TECHNOLOGIES, P

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.
India

PROFESSIONAL TRAINING ON ORACLE 11G DBA: 3RI TECHNOLOGIES, P

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email at Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.
India

PROFESSIONAL TRAINING ON ORACLE 11G DBA: 3RI TECHNOLOGIES,

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.
India


Free Classified ads - buy and sell cheap items in India | CLASF - copyright ©2019 www.clasf.in.