*Job Title: Sr. SQL Database DBA/Developer* *Location: Mountain View, CA *
*MAX Rate is $40-50/hr C2C* *Job Description:* ? BE or BS Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred? 2 -3 years IT operation with strong understanding of database structures, theories, principles, and practices? 3-5 years Microsoft SQL Server 2008 experience? Understanding of, and experience with, server-client computing and relational database environments? Experience with data management and data processing flowcharting techniques? Knowledge of reporting and query tools and practices? Good understanding of the organizations goals and objectives? Good interpersonal, written, and oral communication skills? Technical documentation skills? Ability to present ideas in user-friendly language? Self motivated and directed, with keen attention to detail? Able to prioritize and execute tasks in a high-pressure environment? Experience working in a team-oriented, collaborative environment? Good written and o Skill and Experience Details: -->Database Internals and Architecture(L2)-All of Level 1 capabilities, with thorough understanding of atleast onerelational database system, Concepts around OLTP and Decision processor;Ability to design and implement features as required for the database -->Database Architecting(L1)-Responsible for suggesting new and emerging technologies and translating thesame into business applicability. Ability to manage complex database back-upand recovery systems. Conduct trend analysis on performance and growth. Conducttraining for users and DBAs on organization-wide programs and best practices.Responsible for refining the 'logical design' so that it can be translated intoa specific data model and further refining the 'physical design' to meet systemstorage requirements. Plan data flows for a new or revised database. -->SQL Server(L2)-RDBMS - Exposure to Basic Relational Database Concepts - basic types ofdatabases, data integrity, the relational model,etc Ability to understandbasics of DB Design , Logical modeling , Normalization & De-NormalizationTechniques MS SQL - SQL Constructs Ablility to understand and implement DataTypes, Basic SQL SELECT Statements, Restricting and Sorting Data, SystemFunctions, Joins, Sub-Queries, Creating & Managing DB Objects, ManipulatingData (DML), Constraints, Views SQL Query Tuning Basics: Understanding ofconcepts like Tuning Methodology, SQL Statement Processing, SHOWPLAN,Introduction to the Optimizer, Indexes and Basic Access Methods, GatheringStatistics, Optimizer Hints, Monitoring queries, Optimizing queries. Adv SQL: COMPUTE Clause, Advanced INSERT, Transact-SQL conditions and expressions,Dealing with collation sequences, Using scalar and aggregate functions,Multiple Table Queries Tools Level 1 usage T-SQL Programming - DatabaseProgramming Basics: Ability to understand and implement Declaring Variables,Building Blocks, Control Structures, Cursors, Error Handing, CreatingProcedures and Creating Database Triggers Adv Database Programming: Ability tounderstand and implement programming with locks and isolation and working withtemporary tables Exposure to Basic Relational Database Concepts - basic typesof databases, data integrity, the relational model,etc Ability to understandbasics of DB Design , Logical modeling , Normalization & De-NormalizationTechniques Woking knowledge of DB Design/Modeling techniques(Logical andPhysical DB modeling) SQL Constructs Ablility to understand and implement DataTypes, Basic SQL SELECT Statements, Restricting and Sorting Data, SystemFunctions, Joins, Sub-Queries, Creating & Managing DB Objects, ManipulatingData (DML), Constraints, Views SQL Query Tuning Basics: Understanding ofconcepts like Tuning Methodology, SQL Statement Processing, SHOWPLAN,Introduction to the Optimizer, Indexes and Basic Access Methods, GatheringStatistics, Optimizer Hints, Monitoring queries, Optimizing queries. Adv SQL: COMPUTE Clause, Advanced INSERT, Transact-SQL conditions and expressions,Dealing with collation sequences, Using scalar and aggregate functions,Multiple Table Queries Tools Level 1 usage Adv SQL & SQL Tuning Techniques: Able to implement Executing full-text searches, Managing Data and Concurrency,Writing Scripts and Batches, querying System tables Ability to implementTunning Concepts/Techniques like Show Plan, Managing Optimizer Statistics,Indexes, Plan Stability, Application Tracing Tools SQL Access Advisor DatabaseProgramming Basics: Ability to understand and implement Declaring Variables,Building Blocks, Control Structures, Explicit Cursors, Handling Exceptions,Creating Procedures, Creating Functions, Creating Database Triggers andTransaction Management. Adv Database Programming: Ability to understand andimplement Dynamic SQL Usage, Programming w *=====================================================================================* *Application Packager* *Houston, TX* *MAX Rate is $45-50/hr C2C* *Job Description:* Sr. Technical Lead Job Description SKILLS SUMMARY (highly desirable):VIRTUALIZATION:Virtual Machine Manager, Virtual Desktop Infrastructure (VDI)VMware ESX, ESXi, VSphere, Workstation, Server, Player,Microsoft Virtual Server, Hyper-V, APP-V 4.6 and 5.0, VDICitrix Xen.org Xen, XenServer.OPERATING SYSTEMS:Windows Server 2008 R2, Windows Server 2003, Windows 2000 Server, Windows 8 (Preview Release) Windows 7, Windows XP, Windows Vista, Windows 2000 ProfessionalSystems Center Configuration Manager (SCCM)SCCM 2007, SCCM 2012, SCOM 2007, MDT 2010, MDT 2012, Service Manager, Orchestrator, Virtual Machine Manager, and Data Protection Manager HARDWARE: HP Server HardwareApplication Packaging and Scripting: Flexera formally InstallShield AdminStudio, Premier, APP-V Sequencing InstallAnywhere, WorkFlow Manager, Wise PackageStudio, Wise Script, Vbscript, Perl, PowerShellDATA BASES:Oracle 10g, Oracle 9i, Microsoft SQL Server 6.5, Microso Skill and Experience Details: -->Application Packaging(L3)-Works on applications that is extremely complex in nature where a high degreeof independent judgment, initiative and technical knowledge are required toresolve problems. Works independently and has ability to handle most uniquesituations. Ownes thechnical assessment, troubleshooting, and coordinating withcustomer teams for any technical dicussions. Participates and provides inputstowards implementation of various hardware and software policies andprocedures. Be able to learn new technologies and then train and lead resourceson the technical procedures required for deployment . Acts as a teamlead/mentor for new joinees, participates in training sessions as a faculty forfreshers. -->Infrastructure Services - Build Engineering(L3)-Works on applications that is extremely complex in nature where a high degreeof independent judgment, initiative and technical knowledge are required toresolve problems. Works independently and has ability to handle most uniquesituations. Ownes thechnical assessment, troubleshooting, and coordinating withcustomer teams for any technical dicussions. Participates and provides inputstowards implementation of various hardware and software policies andprocedures. Be able to learn new technologies and then train and lead resourceson the technical procedures required for deployment . Acts as a teamlead/mentor for new joinees, participates in training sessions as a faculty forfreshers. -->Packaging tools(L1)-Knowledge of Wise Package Studo or Installshield, Repackaging Methods andprocess Transform creation Simple Custom Actions, Properties modificationHandles Simple,Medium Packages -->Packaging tools(L3)-Test applications for standards and functionality HandlesSimple,Medium,Complex Handles TroubleShooting Complex Issues Writing ComplexCustomAction -->Desktop Imaging(L1)-Provide technical consultancy and solution support Client Engineering anddesktop deployment space.Proficient in Desktop imaging and image managementsolutions including deployment. Inkstands the end user deployment scenario andsuggest solutions and best practices for Zero touch and light touchmigrations.Process review and implementation of best practices the end usertechnology. Anchor consulting engagements and work with various stakeholdersin developing solutions around the same.Trouble shoot resolved high end technical issues. -->Desktop deployment(L3)-Management Console Develop deployment plan and Strategy roll back deploymentAutomate deployment process -->Application Packaging(L2)-Work independently in applicaiton packaging or application compatibilitytesting, Capable of handling medium and complex category requests. Thisinvolves, package creation and Applicaiton compatibility testing. Expertknowledge on tools such as wise package studio, installshield and the varioustrouble shooting tools. In-depth knowledge of technical skills in hardware, MSOperating Systems, Network, Remote Connectivity and process knowledge to ensurequality in Delivery. Good knowledge of trouble shooting application relatedissues and able to remediate applications as part of application compatiblitytesting and remediation. *Thanks,* *Jay Chauhan* *Technical Recruiter, **e**Team, Inc. **“**ACCELERATED HIRES**”* *efficiency. synergy. expertise* *732-248-1900 X 522* <732-248-1900%20X%20522>* (T)* *908-757-0800* <908-757-0800>* (F)* [email protected] <[email protected]> www.eteaminc.com -- You received this message because you are subscribed to the Google Groups "Associate Programs" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/associate_programs. For more options, visit https://groups.google.com/groups/opt_out.
