Company Name : KRONOS SOLUTIONS INDIA PRIVATE LTD
Designation: Technical Consultant II
Job Description:
• The Managed Services Technology Consultant:
• Installs, tests, documents, and troubleshoots Workforce Central software installations
• Delivers managed service offerings to Workforce Central customers requiring ongoing support
• Delivers database management services
• Installs and monitors hosting or remotely managed customers
• Delivers technical application of service packs and upgrades
• Communicates effectively to both technical and non-technical individuals at various levels of customer organizations, as well as internally.
• Uses consultative techniques and skills in their consulting services delivery
Shift work required
The successful applicant will demonstrate how they can apply their skills acquired as a seasoned, experienced professional with a full understanding of industry practices and company policies and procedures. They will be expected to resolve a wide range of issues through imaginative as well as practical evaluation of identifiable factors. They will demonstrate good judgment in selecting methods and techniques for obtaining solutions. They will possess strong consultative abilities and communication skills which they will leverage to tie their technical recommendations to business benefits and process change. After initial training they normally require little instruction on their day-to-day work.
Keywords: SQL Server, Data Migration, Tuning
Company Profile:
It started off with a simple idea: there had to be an easier way to record employee time transactions. And then one innovation led to another and that idea grew into something we now call workforce management. What does that really mean? Plainly put, we help organisations across a variety of industries manage their most valuable, and expensive, strategic asset — their workforce.
Desired Profile:
Education/Experience:
BE/B.Tech/MCA degree in Computer Science or related discipline or equivalent experience and a minimum of 3 years related work experience (ideally in a consulting or project-centric role). They will have strong technical knowledge in the following areas:
Must have at least 3 years work experience with the below mentioned technologies.
Willing to work in Shifts.
• Excellent programming knowledge in Pl/SQL and Oracle DB database structures
• Installation, configuration and maintenance of SQL 2005, SQL 2008,Oracle 10g, Oracle 11g databases.
• Up gradation of database from SQL 2005 to SQL 2008 / oracle 10g to Oracle 11g.
• Must have Good knowledge of database table structures, relationships, data types.
• Must have good experience in requirement gathering and analysis.
• Ability to design tables, user functions, stored procedures, views etc.
• Ability to take backup, restore, copy database from one server to another server.
• Ability to tune SQL queries, including indexing best practices, hints, SQL query formation, and optimization tools etc.
• Sound knowledge on Windows 2003 / Windows 2008 OS and troubleshooting
• Ability to install, configure and troubleshoot of IIS, Apache.
• VMware (ESX and Workstation)
• The following skills are preferred but not required:
• Experience in implementing Workforce Central applications and knowledge of the underlying Workforce Central application architecture
• Familiarity with application and infrastructure hosting and monitoring; and client-side troubleshooting techniques
• Solid knowledge of Connect or other interface technologies
• Knowledge of WAN and LAN network architecture, potential issues, and troubleshooting tools and techniques
• Disaster Recovery Planning
• Custom Report design and programming
• Hosting / data center architecture design and support
Experience: 3 - 5 Years
Role: DBA
Functional Area: Application Programming, Maintenance
Education:
UG - Any Graduate - Any Specialization
PG - Any PG Course
Location: Noida