Compunnel jobs - SQL Database Administrator

2015-03-02 Thread Arpit
Please reply to:- v...@compunnel.comJob Details:-  Job Title : SQL Database AdministratorLocation : Bartlesville, OKExpected Duration of Project : 5 MonthsStart Date : 03/16/2015Interview Type : Telephonic Duties & Responsibilites : It is mandatory for all the vendors to provide the details below while sharing the resume

Consultant Name:
Current Location: 
Phone: 
Email: 
Work Authorization : 
Rate: 


The SQL Database Administrator may be responsible for:
-Providing SQL Server database administration, application tuning, database security and production support 
-Installing, upgrading and maintaining SQL Server databases 
-Planning and executing database backup and recovery 
-Providing database tuning for performance and stability 
-This position participates in an on-call rotation with other DBA's to provide 24X7 coverage

Basic Qualification:
-High School Diploma or equivalent 
-Three years of direct DBA experience working with SQL Server 
-Five years of direct IT experience providing server support, database support or application programming 
-Ability and willingness to perform tasks outside normal business hours and on weekends as well as carry an on call pager for at least one week every 6 to 8 weeks
-Bachelor's degree in Computer Science, MIS or other IT/IS related major 
-Excellent oral and written communication skills 
-Expert diagnostic, troubleshooting, and problem solving for SQL Server 
-Ability to work effectively across time zones and geography
-Self-directed and self-motivated to solve problems quickly and creatively 
-Ability to work effectively in a team environment to encourage collaboration, innovation, and continuous improvement 
-Applications support experience 
-Infrastructure support

Required Skills:
-Five years of direct IT experience providing server support, database support or application programmingClick here to see details and upload resume for this job.Click here to see all jobs on jobs.compunnel.com.



-- 
You received this message because you are subscribed to the Google Groups American Vendor--IT Consulting group.
To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com.
To post to this group, send email to sap-vendor@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/d/optout.


Compunnel jobs - SQL Database Administrator

2014-12-01 Thread Arpit
Please reply to:- Barretto,Vinita / vbarre...@compunnel.com / 609-606-9010 Ext.# 1413Job Details:-  Job Title : SQL Database AdministratorLocation : DES MOINES, IAExpected Duration of Project : 12 MonthsStart Date : 12/01/2014Interview Type : Telephonic Duties & Responsibilites : -The Department is currently implementing a new Eligibility system for Medicaid, TANF (Financial Assistance) and Food Assistance programs.
-Department systems used in support of the new eligibility system in need of upgrading to meet the Federal Service Oriented Architecture guidance. -Many of the remaining systems are mainframe systems that are being moved into the Client Server domain. 
-Our Client Server environment is predominately Web (IIS/.Net) and SQL Server. 
-The SQL environment is being upgraded to SQL 2012.
-We are in need of an experienced SQL developer. 
-The experience should be centered around design, development and implementation of databases used to support web-based transactional applications
-Additional experience using LINK would be beneficial. The activities this person will be involved with include database design (normalized/de-normalized) using core database objects and application/functional specific schema’s. 

The day to day activities include;
-Working with web (.Net) developers interacting with the database in the design and development of the application.
-Database schema/table/column design and development.
-Creating database objects used within the application.
-Developing/editing and implementing stored procedures and other executable's.
-Developing database maintenance plans
-Developing automation of database batches where necessary. It will likely involve developing SQL Server Integration Services packages and working with batch schedulers to implement in Control M scheduling software.

REQUIRED EXPERIENCE:
Creating database objects used within the application. Required 5 Years
Experience using LINK Required 5 Years
Developing/editing and implementing stored procedures and other executable;s Required 5 Years
Developing database maintenance plans Required 5 Years
Experience SQL Server Integration Services packages - SSIS Required 5 Years
Work with batch schedulers to implement in Control M scheduling software Highly desired 1 Years

INTERVIEW PROCESS:
In PersonClick here to see details and upload resume for this job.Click here to see all jobs on jobs.compunnel.com.



-- 
You received this message because you are subscribed to the Google Groups American Vendor--IT Consulting group.
To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com.
To post to this group, send email to sap-vendor@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/d/optout.


Compunnel jobs - SQL Database Administrator

2014-12-01 Thread Arpit
Please reply to:- Barretto,Vinita / vbarre...@compunnel.com / 609-606-9010 Ext.# 1413Job Details:-  Job Title : SQL Database AdministratorLocation : DES MOINES, IAExpected Duration of Project : 12 MonthsStart Date : 12/01/2014Interview Type : Telephonic, Personal Duties & Responsibilites : -The Department is currently implementing a new Eligibility system for Medicaid, TANF (Financial Assistance) and Food Assistance programs.
-Department systems used in support of the new eligibility system in need of upgrading to meet the Federal Service Oriented Architecture guidance. -Many of the remaining systems are mainframe systems that are being moved into the Client Server domain. 
-Our Client Server environment is predominately Web (IIS/.Net) and SQL Server. 
-The SQL environment is being upgraded to SQL 2012.
-We are in need of an experienced SQL developer. 
-The experience should be centered around design, development and implementation of databases used to support web-based transactional applications
-Additional experience using LINK would be beneficial. The activities this person will be involved with include database design (normalized/de-normalized) using core database objects and application/functional specific schema’s. 

The day to day activities include;
-Working with web (.Net) developers interacting with the database in the design and development of the application.
-Database schema/table/column design and development.
-Creating database objects used within the application.
-Developing/editing and implementing stored procedures and other executable's.
-Developing database maintenance plans
-Developing automation of database batches where necessary. It will likely involve developing SQL Server Integration Services packages and working with batch schedulers to implement in Control M scheduling software.

REQUIRED EXPERIENCE:
Creating database objects used within the application. Required 5 Years
Experience using LINK Required 5 Years
Developing/editing and implementing stored procedures and other executable;s Required 5 Years
Developing database maintenance plans Required 5 Years
Experience SQL Server Integration Services packages - SSIS Required 5 Years
Work with batch schedulers to implement in Control M scheduling software Highly desired 1 Years

INTERVIEW PROCESS:
In PersonClick here to see details and upload resume for this job.Click here to see all jobs on jobs.compunnel.com.



-- 
You received this message because you are subscribed to the Google Groups American Vendor--IT Consulting group.
To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com.
To post to this group, send email to sap-vendor@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/d/optout.


Compunnel jobs - SQL Database Administrator

2014-11-20 Thread Arpit
Please reply to:- Bahadur,Arti / abaha...@compunnel.com / 609-606-9010 Ext.# 1411Job Details:-  Job Title : SQL Database AdministratorLocation : Bartlesville, OKExpected Duration of Project : 3 MonthsStart Date : 12/01/2014Interview Type : Telephonic Duties & Responsibilites : • Providing SQL Server database administration, application tuning, database security and production support 
• Installing, upgrading and maintaining SQL Server databases
• Planning and executing database backup and recovery 
• Providing database tuning for performance and stability 
• Using the clients change management processes to prevent production disruptions and outages 
• This position participates in an on-call rotation with other DBA's to provide 24X7 coverageBasic
• Ability and willingness to perform tasks outside normal business hours and on weekends as well as carry an on call pager for at least one week every 6 to 8 weeks
• Ability to work effectively in a team environment to encourage collaboration, innovation, and continuous improvement
• Excellent oral and written communication skills
• Expert diagnostic, troubleshooting, and problem solving for SQL Server
• Ability to work effectively across time zones and geography 
• Self-directed and self-motivated to solve problems quickly and creatively

REQUIRED EXPERIENCE:
• Bachelor's degree in Computer Science, MIS or other IT/IS related major 
• Three years of direct DBA experience working with SQL Server 
• Five years of direct IT experience providing server support, database support or application programming
• Applications support experience 
• Infrastructure supportClick here to see details and upload resume for this job.Click here to see all jobs on jobs.compunnel.com.



-- 
You received this message because you are subscribed to the Google Groups American Vendor--IT Consulting group.
To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com.
To post to this group, send email to sap-vendor@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/d/optout.


Compunnel jobs - SQL Database Administrator

2014-10-14 Thread Arpit
Please reply to:- Sophia Menezes,Abigail / amene...@compunnel.com / 609-606-9010 Ext.# 1421Job Details:-  Job Title : SQL Database AdministratorLocation : Little Rock, ARExpected Duration of Project : 8 MonthsStart Date : 10/27/2014Interview Type : Telephonic, Personal Duties & Responsibilites : The SQL DBA will be responsible for data analysis and database management. The DBA will also be responsible for maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning.
-Maintains central data repository.
-Experience and knowledge in supporting application system development life cycle. 
-Responsible for data dictionary backup and recovery. 
-Responsible for definition of standards of data dictionaries. 
-May program dictionary analysis and maintenance software.
-Perform performance tuning.
-Monitor database performance and space requirements.
-Schedule and monitor end of day data warehousing jobs.
-Assist in coordinating software releases.
-Communicate accurate and useful status updates.
-Manage and report time spent on all work activities.
-Follow quality standards.
-Ability to work in a team environment
-Complete assigned tasks.
-Strong communication skills; both written and spoken Plus the following:
-Business systems analysis and design experience.
-Logical data modeling techniques.
-Production environment Tools/Utilities.
-Knowledgeable in data analysis and database management techniques.
-Execution of all responsibilities with little direct supervision of Team Lead.
-Administration and scripting experience in relative platform.
-Supervise performance tuning.
-Author shell scripts to perform back up, restore, and monitoring tasks.
-Anticipate and resolve issues specific to the team.
-Determine time estimates and schedule for own work and resolve issues in a timely manner.
-Identify and track issues, risks and action items. Plus the following: Highly skilled at database design, installations, conversions.
-Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management.
-Participates in Database Management System selection and maintains database performance.
-Expertise in specific Database Management Systems.
-Knowledge of various Database Management System products.
-Provide status of work to Project Team Lead.
-Engage in ongoing process improvement.


-In addition, this person will be also be responsible for developing and qualifying database release management/deployment procedures and collaborating with the Software Development, Quality Assurance, and Support teams.
Qualifications:
-Bachelors Degree in Computer Science or related technical field
-Microsoft SQL Server Database Administration experience (3+ years), managing multiple MS SQL 2000,2005, 2008,2012 instances
-Experience in data modeling and design including strong knowledge of SQL (T-SQL  ANSI SQL)
-Thorough knowledge of data backup/recovery/rollback 
-Hands-on replication server knowledge (setup and troubleshooting)
-SQL Server 2000, 2005, 2008,2012 optimization, fine-tuning, and scalability techniques
-Data security and strong knowledge of network architecture and topology
-Large-scale data migration experience (SQL Server 2000 - 2005)
-DBA certification (i.e. MCDBA or otherwise) a plus.
-Experience/knowledge of Data Warehousing concepts a plus
-Experience in a fast-paced web development environment a strong plus
-Familiarity with MySQL, UDB on LUW and PostgreSQL a plus.

REQUIRED SKILLS:
-SQL DBA Required 7 Years
-T-SQL  ANSI SQL Required 4 Years
-SQL Server 2000,2005, 2008, 2012 Required 4 Years
-Large-scale data migration experience Required 4 Years
-Server 2008/2012 optimization Required 4 Years
-Data Warehousing concepts Highly desired
-MySQL, UDB on LUW and Postgre SQL Highly desired
-MCDBA Required

INTERVIEW PROCESS:
In PersonClick here to see details and upload resume for this job.Click here to see all jobs on jobs.compunnel.com.



-- 
You received this message because you are subscribed to the Google Groups American Vendor--IT Consulting group.
To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com.
To post to this group, send email to sap-vendor@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/d/optout.


Compunnel jobs - SQL Database Administrator

2014-10-13 Thread Arpit
Please reply to:- Rajneet Singh Bharaj / rsi...@compunnel.com / 609-606-9010Job Details:-  Job Title : SQL Database AdministratorLocation : Little Rock, ARExpected Duration of Project : 14 MonthsStart Date : 11/03/2014Interview Type : Telephonic, Personal, Webcam Duties & Responsibilites : Local Candidate Preferred
-The DBA will be responsible for maintaining multiple databases 
-Installing and Upgrading SQL Servers including applying Service Packs
-Monitoring the Database Server’s Health and Tuning
 -Optimal server performance 
 -Monitor the error log or event log for database errors 
 -Routine database maintenance, and the overall system maintenance
-Maintaining and Managing SQL Server Disk Space to make sure the storage utilized properly
-Performing Backup and recovery
 -Establishing standards and schedules for database backups 
 -Developing recovery procedures for each database 
 -Making sure that the backup schedules meet the recovery requirements 
-Managing Database Users and Security 
-Working with Developers to tune queries, how to use indexes etc.
-Log shipping Transaction Log 
-Transferring Data – Importing and Exporting data to and from the SQL Server.
-Create and Scheduling SQL Server Jobs to perform database maintenance activity
-Establishing and Enforcing Standards 
-Create and Test Disaster Recovery Plan
-Providing 24 Hours support
-The Client is using GenTax Software for this project. Any previous experience with GenTax would be very helpful, but not required.
REQUIRED EXPERIENCE:
Years of Experience: 3 to 5 years 
Education: 4 year college degree or equivalent technical study
Other Responsibilities:
-Knowledge of using FTP Software to transfer files to and from FTP Servers

SQL Server RDMS Knowledge :
-SQL Server Version: SQL Server 2008 R2, 2012-
-Good understanding of SQL Server Databases
-How to do disk backup as well as TAPE backup
-Knowledge of restoring databases with point in time recovery
-Knowledge of Transaction Log shipping
-Knowledge of SQL Server Profiler to run Trace to indentify performance issue
-Index tuning 
-Knowledge of using SQL Server Jobs and Scheduling
-How to create Database Mail Profile, alerts and operators
-Knowledge of Linked Servers 
-Knowledge of how to use integration services or SSIS Packages to import and export data from/to sql server database
-Good TSQL Knowledge 
Software Knowledge:
-Windows Server 2008 R2
-SQL Server 2008 R2 and SQL Server 2012
-Quest Lightspeed backup software

Strong communication skills; both written and spoken 
-Execution of all responsibilities with little direct supervision of Team Lead.


RequiredExperience
-SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012 Required 5 Years
-TSQL Programming Required 5 Years
-Transaction Log shipping Required 3 Years
-SQL Server Profiler to run Trace to indentify performance issue Required 3 Years
-Index tuning Required 3 Years
-SQL Server Jobs and Scheduling Required 3 Years
-Integration services or SSIS Packages to import and export data from/to sql Required 3 Years
-Restoring databases with point in time recovery Required 3 Years
-GenTax Application, Services, and Tools Highly desired

INTERVIEWPROCESS:
InPerson


Click here to see details and upload resume for this job.Click here to see all jobs on jobs.compunnel.com.



-- 
You received this message because you are subscribed to the Google Groups American Vendor--IT Consulting group.
To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com.
To post to this group, send email to sap-vendor@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/d/optout.


Compunnel jobs - SQL Database Administrator

2014-07-28 Thread Arpit
Please reply to:- Philip,Shisa / sh...@compunnel.com / 609-606-9010 Ext.# 1418Job Details:-  Job Title : SQL Database AdministratorLocation : Army Post Road, Suite 32, IAExpected Duration of Project : 12 MonthsStart Date : 08/04/2014Interview Type : Telephonic Duties & Responsibilites : 

Required Skills:
-Experience in working with SQL Server 2005 and 2008 R2, Familiarity with SQL 2012-Required-5 Years
-Expert knowledge of T-SQL-Required-5 Years
-Experience in developing and optimizing complex stored procedures-Required-5Years
-Experience developing data extract (SSIS) packages from source normalized databases.-Required-5 Years
-Database modeling and design, specifically dimensional database modeling/STAR Schema’s-Required-5 Years
-Knowledge of SQL best practices-Required-5 Years
-Knowledge of SQL best practices in regards Data Warehousing and Decision Support-Required-5 Years
-Experience in building ETL processes using SQL Server Integration Services(SSIS)-Required-5 Years
-Excellent problem solving skills (for debugging problem reports)-Required-5 Years
-Experience in working with big databases ( over 100 GB)-Required-5 Years
-Experience in working closely with Analytics developers-Required-5 Years
-Knowledge of Business Intelligence Tools (e.g. OBIEE, Business Objects)-Required-5 Years
-Experience with SDLC and Agile development practices-Required-5 Years

Interview Process:
In personClick here to see details and upload resume for this job.Click here to see all jobs on jobs.compunnel.com.



-- 
You received this message because you are subscribed to the Google Groups American Vendor--IT Consulting group.
To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com.
To post to this group, send email to sap-vendor@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/d/optout.


Compunnel jobs - SQL Database Administrator

2013-03-12 Thread Arpit
Please reply to:- Pereira, Roxana Da Silva / rpere...@compunnel.com / 609-606-9010 Ext.# 1407Job Details:-  Job Title : SQL Database AdministratorLocation : Salem, ORExpected Duration of Project : 6 MonthsStart Date : 03/19/2013Interview Type : Telephonic, Personal Duties & Responsibilites : May require a bachelor's degree in a related area and at least 6 years or equivalent experience in the field or in a related area
Expert level skills with Microsoft SQL Server, relational database design and development, and T-SQL stored procedures. 
In addition, the candidate should have solid skills in software design, development, user interface, data access, reporting and implementation.
Specific experience should include:

5+ years commercial development experience with Microsoft SQL Server and T-SQL.
2+ years experience with MS SQL Server 2008
2+ years experience with C#, ASP.NET, Visual Studio.NET, LINQ and/or Entity Framework
Complex relational database design, database administration, and T-SQL stored procedures
Experience with IIS, HTML, XML
Experience with SubVersion (SVN) and Rally.
Experience with Telerik controls and components.
Excellent communication skills.
DB2 Would be a nice to have

Click here to see details and upload resume for this job.Click here to see all jobs on jobs.compunnel.com.



-- 
You received this message because you are subscribed to the Google Groups American Vendor--IT Consulting group.
To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com.
To post to this group, send email to sap-vendor@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-vendor?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Compunnel jobs - SQL Database Administrator

2013-01-17 Thread Arpit
Please reply to:- Pereira, Roxana Da Silva / rpereira@compunn / 609-606-9010 Ext.# 1407Job Details:-  Job Title : SQL Database AdministratorLocation : Beaverton, ORExpected Duration of Project : 5 MonthsStart Date : 01/24/2013Interview Type : Duties & Responsibilites : 

Must have SQL 2008 R2 Experience 

Manage SQL R2 maintenance plan -

Oversee system performance and tuning including compacting database regularly 

Monitor backup jobs; test to ensure working correctly; define and test recovery process 

Facilitate recovery of the database by staff and the software vendor, in the event of a database crash. 

Monitor server logs, disks, services, memory, scheduled tasks. Make recommendations for improvement, if necessary. 

Ensure SQL server is set-up to best practice standards as defined by software vendor or to optimal standards based on need. 

Troubleshoot and repair Microsoft failure of SQL 2008 R2 Scheduled Task for current vendor electronic batch file electronic order 

Act as a liaison between BSD-IT and software vendor (Horizon) to identify and fix any gaps in server maintenance and support. 

Analyze and manage preventative diagnostics for hardware 

Assist in creation of and facilitate any future electronic order systems with new vendors. 

Please answer questions listed below:



1) Explain the purpose of a maintenance plan and what you would set up in a typical maintenance plan.





2) Describe how SQL merge replication works


3) We are experiencing long delays with SQL on the client replicating to the up-stream database server. Explain how what areas you would look at and how you would troubleshoot those areas.









Click here to see details and upload resume for this job.Click here to see all jobs on jobs.compunnel.com.



-- 
You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group.
To post to this group, send email to sap-vendor@googlegroups.com.
To unsubscribe from this group, send email to sap-vendor+unsubscr...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/sap-vendor?hl=en.