Create database perform data

In our previous videos we have discussed about how to create a project in Python? If you didn't saw just click here Setting up a Python Project. In this video we are discussing about how to create a Database and how we can perform data migration. This is the second step after creation of project in Python. We are offering mini project along with our online data science certification training. Within our expert faculty guidance candidate can know the fundamental concept and a good hands-on knowledge how to deal with real time challenges. If you are a beginner you need to follow the basic and necessary steps as we have mentioned below: Install pycharm Install Python Xampp Postgresql What is Pycharm? The PyCharm IDE is one of the most popular editors used by professional Python developers and programmers. if you are a beginner our experts can help you to create Python projects using PyCharm and what are the basic features can help more efficiently. If you are just starting to learn Python our expert can help you to build a project as one to one mentorship. You can easily understand the concepts and terminology how to build a python Data Science project?

DATA ENTRY FRESHER EGMORE LOCATION JOB SKILLS: Transfer data from paper formats into database systems Type in data provided directly from customers or other parties Create and manage spreadsheets with large numbers of figures Verify data by comparing it to source documents Update existing data Produce reports Retrieve data as requested Perform regular backups to ensure data preservation Sort, organize and store paperwork after entering data Location: Chennai Role: Data Entry Qualification: Any Degree SALARY: 10 K TO 15 K FURTHER MORE CONTACT DETAILS: HR.DEVI

DATA ENTRY FRESHER EGMORE LOCATION JOB SKILLS: Transfer data from paper formats into database systems Type in data provided directly from customers or other parties Create and manage spreadsheets with large numbers of figures Verify data by comparing it to source documents Update existing data Produce reports Retrieve data as requested Perform regular backups to ensure data preservation Sort, organize and store paperwork after entering data Location: Chennai Role: Data Entry Qualification: Any Degree SALARY: 10 K TO 15 K FURTHER MORE CONTACT DETAILS: HR.DEVI PH. 91760 AND 74708

Job Description: We're looking for a Data Entry Operator for Data Entry Job in Hyderabad to update and maintain information on our databases and systems. Data Entry Operator responsibilities include collecting and entering data in databases and maintaining accurate records of valuable company information. Our ideal candidate has essential data skills, like fast typing with an eye for detail and familiarity with spreadsheets, MS word, mathematical formulas, and online forms. Responsibilities: Insert customer and account data by inputting text-based and numerical information from source documents within time limits. Review data for deficiencies or errors, correct any incompatibilities if possible, and check the output. Apply data program techniques and procedures. Makes appropriate changes to the documentation, as needed. Responding to the user requests and problems Retrieve data as requested. Create and manage spreadsheets with large numbers of figures Verify data by comparing it to source documents Update existing data Produce reports Perform regular backups to ensure data preservation Sort, organize and store paperwork after entering data. The Profile You possess strong analytical skills and are comfortable dealing with numerical data Proven data entry work experience as a Data Entry Operator. Experience with MS Office and data programs. You pay strong attention to detail and deliver work that is of a high standard You are adaptable and thrive in changing environments Role: Administration - Other Industry Type: IT & ITES Functional Area: Administration & Facilities Employment Type: Full Time, Permanent Role Category: Administration Education UG: Any Graduate PG: Any Postgraduate Key Skills Typing, Word, Numerical, Spreadsheets, Computer Operating, Data Processing, Career Development, MS Office, Data Entry Operation, Deep Learning

Tell customer of estimated delivery schedule, service contracts, warranty, or other information pertaining to purchased products. Attend conferences to discover new products or machines. Perform extensive research. Test machines to ensure they are functioning properly. Create a list of sales leads.

Database Administrator Spectrum Softtech Solutions is looking for Senior MySQL Database Administrator to join our team. The profile of Sr. DBA include job responsibilities as; Job Profile The MySQL database administrator candidate will participate in the design, implementation, automation, optimization and ongoing administration of MySQL infrastructure and operations. Works hard to deliver top-notch support for all of the MySQL functionality, scalability, availability, performance and reliability for both in-house and cloud deployments. Designing, modeling, developing and supporting Database Management Systems (DBMS). Work with developers to design and optimize SQL queries and schema to participate in application deployments. Create and modify queries, stored procedures and scripts inside of MySQL Analyzing data requirements, data dictionaries, application and processing architectures, and database schema(s). Then design, develop, amend, optimize, and certify database schema(s) to meet system requirements. Coordinating day-to-day management, support, and troubleshooting activities of the team. Experience with database performance tuning and capacity planning. Provide database administration support, oversee environment management, monitor database health, resource planning, perform database upgrades and patching, backup/recovery, and make recommendations regarding enhancements and/or improvements Gather, analyze, and normalize relevant information related to and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Perform duties associated with data stewardship, data security, data integration, and data standards. Database mirroring and replications. Develop and manage daily operational procedures. Contribute to database planning efforts such as disaster recovery design, tool selection, warehousing and scaling initiatives Baseline activities include project management, development of best practices, repeatable procedures for deploying databases, day-to-day operational activities (break/fix, space management, backup/recovery and database replication setup/management). Create automated processes related to database administration, space management, security, monitoring, and performance Adhere to all required PCI/SDLC procedures, Ensuring database systems procedures adhere to regulatory requirements. Support required application maintenance windows, and support on-call. Perform installation, upgrades, and patching of database software. Troubleshoot and solve complex database problems through research, analysis and collaboration with team members. Desired candidate profile · 2+ years in database administration (DBA) with MySQL Database · Knowledge and experience of MySQL query’s, views and Store procedures, with a proven track record · Knowledge and experience in managing relational databases · Solid functional experience in Linux. · Good scripting ability and working knowledge of Shell Scripts · Strong organization, interpersonal, and team-leading skills · Strong multi-tasking abilities, ability to work under pressure, and make priority decisions, · Pro-active, dedicated, committed and responsible. Send your resume to or call

Database Administrator Spectrum Softtech Solutions is looking for Senior MySQL Database Administrator to join our team. The profile of Sr. DBA include job responsibilities as; Job Profile The MySQL database administrator candidate will participate in the design, implementation, automation, optimization and ongoing administration of MySQL infrastructure and operations. Works hard to deliver top-notch support for all of the MySQL functionality, scalability, availability, performance and reliability for both in-house and cloud deployments. Designing, modeling, developing and supporting Database Management Systems (DBMS). Work with developers to design and optimize SQL queries and schema to participate in application deployments. Create and modify queries, stored procedures and scripts inside of MySQL Analyzing data requirements, data dictionaries, application and processing architectures, and database schema(s). Then design, develop, amend, optimize, and certify database schema(s) to meet system requirements. Coordinating day-to-day management, support, and troubleshooting activities of the team. Experience with database performance tuning and capacity planning. Provide database administration support, oversee environment management, monitor database health, resource planning, perform database upgrades and patching, backup/recovery, and make recommendations regarding enhancements and/or improvements Gather, analyze, and normalize relevant information related to and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Perform duties associated with data stewardship, data security, data integration, and data standards. Database mirroring and replications. Develop and manage daily operational procedures. Contribute to database planning efforts such as disaster recovery design, tool selection, warehousing and scaling initiatives Baseline activities include project management, development of best practices, repeatable procedures for deploying databases, day-to-day operational activities (break/fix, space management, backup/recovery and database replication setup/management). Create automated processes related to database administration, space management, security, monitoring, and performance Adhere to all required PCI/SDLC procedures, Ensuring database systems procedures adhere to regulatory requirements. Support required application maintenance windows, and support on-call. Perform installation, upgrades, and patching of database software. Troubleshoot and solve complex database problems through research, analysis and collaboration with team members. Desired candidate profile · 2+ years in database administration (DBA) with MySQL Database ·Knowledge and experience of MySQL query’s, views and Store procedures, with a proven track record · Knowledge and experience in managing relational databases ·Solid functional experience in Linux. · Good scripting ability and working knowledge of Shell Scripts · Strong organization, interpersonal, and team-leading skills ·Strong multi-tasking abilities, ability to work under pressure, and make priority decisions, ·Pro-active, dedicated, committed and responsible.

Create spreadsheets with large numbers of figures without mistakes Verify data by comparing it to source documents Update existing data Retrieve data from the database or electronic files as requested Perform regular backups to ensure data preservation Sort and organize paperwork after entering data to ensure it is not lost

Create spreadsheets with large numbers of figures without mistakes Verify data by comparing it to source documents Update existing data Retrieve data from the database or electronic files as requested Perform regular backups to ensure data preservation

We are looking for a Data Entry Clerk to type information into our database from paper documents. The ideal candidate will be computer savvy and a fast typist with a keen eye for detail. You will report to a data manager or another senior data team member. Understanding of data confidentiality principles is compulsory. The company will rely on you for having accurate and updated data that are easily accessible through a digital database. Responsibilities Transfer data from paper formats into computer files or database systems using keyboards, data recorders or optical scanners Type in data provided directly from customers Create spreadsheets with large numbers of figures without mistakes Verify data by comparing it to source documents Update existing data Retrieve data from the database or electronic files as requested Perform regular backups to ensure data preservation Sort and organize paperwork after entering data to ensure it is not lost Requirements Proven experience as data entry clerk Fast typing skills; Knowledge of touch typing system is strongly preferred Excellent knowledge of word processing tools and spreadsheets (MS Office Word, Excel etc.) Working knowledge of office equipment and computer hardware and peripheral devices Basic understanding of databases Good command of English both oral and written and customer service skills Great attention to detail High school degree or equivalent Regards Nandhini-HR 9962321948

Transfer data from paper formats into computer files or database systems using keyboards, data recorders or optical scanners Type in data provided directly from customers Create spreadsheets with large numbers of figures without mistakes Verify data by comparing it to source documents Update existing data Retrieve data from the database or electronic files as requested Perform regular backups to ensure data preservation Sort and organize paperwork after entering data to ensure it is not lost

Responsibilities: Perform installation, configuration and upgradation of Database on all environments. Implement distributed queuing on various platforms and clustering mechanism to reduce the administrative tasks. Work on triggering on both channel and application triggering by configuring channel initiators and trigger monitors. Manage database objects like tablespace, user, table, Index, roles, privileges, profiles, DB Links, materialized views, partitioning, synonyms, sequences, views and indexes and other database objects etc... Create a physical/logical standby database and performing switch-over and fail-over. Drive performance & tuning, monitoring the performance using tools. Candidate Profile: Minimum 4 + years of experience is SQL DBA with the versions 2005 / 2008 / 2008R2 / 2012 / 2014 / 2016 / 2017. Experience in installation, configuration and Patch up-gradation administration on SQL Server. Proficient in implementing and monitoring Log-Shipping as a high availability solution Ability to install, configure on SQL DBA Clustering and fix support packs on all OS platforms. Experience in configuring Reporting service for report data collection Demonstrated ability to implement High Availability, Work Load Management and Fail Over, Disaster recovery and performance tuning. Experience in Always on and Clustering is desirable. Ambitious individual who can work under their own direction towards agreed targets/goals and with a creative approach to work. Good Communication Skills and should be willing to work in US time.

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

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

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

Project Description : The Project is in large quantity forms for create database Input Data : Work create database in given excel sheet offline Output Data : After the data has been feuded into the software database need to be loaded into the server of the client which completes the work delivery of the day. Seats Required : Minimum seat capacity should be 8 seats per slot. Payout : Rs.6 per Form, 12 Row per form Turnaround Time : 30 days in a month Billing Cycle : Monthly Workload : Unlimited work load, 2,800 form have to complete per seat Tools Used : Software tool provided by company Contract Period : 11 Months Challenges Faced : 10% royalty for 6 Months. Document Requirement • Company should be Pvt. Ltd. • Last 6 Months Bank Statement, ITR of last 1 years • Company profile with pictures of existing infrastructure • Pan Card (Company & Director both). • Center has to pay Rs. 2 Lac Procurement fee + Service Tax. • Contact Us. • Josoft Technologies Pvt Ltd. • Ph No :- 05224069893 • Mob No :- +919026209005 • E-mail :- info@josoftech.com • Website :- http://www.josoftech.com

Project Description : The Project is in large quantity form to be create database Input Data : Will be available in SBI Site Output Data : After the data has been feuded into the software database needed to be loaded into the server of the client which completed the work delivery of the day. Seats Required : Minimum Seat capacity should be 25 seats per slot Payout : Rs. 6 per form, 15 Row per form Turnaround Time : 30 days in a month Billing Cycle : Monthly Tools Used : Software tools provided by company Document Requirement • Company should be Private Limited. • Certification, Last 6 months bank statement, ITR of last 1 year. • Company profile with pictures of existing infrastructure. • Pan Card (Company & Director both). • Center has to pay Rs. 2.5 Lac Procurement fee and Rs. 20,000 consultancy charges + Service Tax. • Contact Us. • Josoft Technologies Pvt Ltd. • Ph No :- 05224069893 • Mob No :- +919026209005 • E-mail :- info@josoftech.com • Website :- http://www.josoftech.com

One of our client has got requirement for Advanced Python Developer Please go through the following job details Job Title(position): Advanced Python Developer Company Profile:- Delhi based emerging startup – Thought Chimp, we are handpicking best of the programmer to work exclusively for International client and be a part of future product of social media space. Place Of joining: Malviya Nagar, Delhi Qualification: Graduate and above Shift (Job timing): Day Shift(10AM-7PM) working days(All days except Sunday) Experience: 1-3 Year experience Per Month Salary (Breakup) Fixed(Not based on target):- Variable(based on Target):- 25k – 40k(fixed Others/ Perks/Etc:- Work Details & Responsibilities Python Web Developer responsible for building web apps integrating various social media APIs. Your primary focus will be the development of all server-side logic, integrating various social media API for fetching data, ensuring high performance and responsiveness to requests from the front-end. Writing reusable, testable, and efficient code Design and implementation of low-latency, high-availability, and performance applications Integration with database (MongoDB or mysql) Skills required Expert in Python, with knowledge of Django Python web framework Able to integrate multiple data sources and databases into one system Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3 Knowledge of user authentication and authorization between multiple systems, servers, and environments Understanding of fundamental design principles behind a scalable application Understanding of the differences between multiple delivery platforms, such as mobile vs desktop, and optimizing output to match the specific platform Able to create database schemas that represent and support business processes Interested candidates can send resume to space.pradnya@ gmail.com with subject line python developer or call