*Good day Partners,*
*We need* *MS SQL DBA* in *Sacramento, CA for duration of 6 to 12 Months**.* *If you are Interested and available for the Job, Please revert back with latest resume, expected pay rate, availability and other details required for submission to * *msha...@tech-netinc.com* <msha...@tech-netinc.com>* (MKM Shahid).* *Role: MS **SQL DBA* *Location: Sacramento, CA* *Duration: 6 to 12 Months* *Minimum Experience required 9 years* *Local to California Candidates preferred* *Submission of H1 copy is a must**, VISA Transfer Cases please do not submit.* *JOB PURPOSE *Performs professional technical system support and maintenance for CLIENT’s databases in the areas of design, development, installation, operation, maintenance and support to ensure CLIENT’s use of technology supports its current and future business practices. *NATURE AND SCOPE *Serves as a resource in a relevant professional discipline; works independently on projects of minor to moderate complexity; exercises independent judgment and discretion within established broad guidelines. *ESSENTIAL FUNCTIONS *Work may include, but is not limited to, the following: (NOTE: While in general all the functions and requirements listed are essential, individual positions and/or locations may not require all duties be performed.) · Supports CLIENT’s strategic information technology goals and direction by serving as a technical lead on application database projects; designs, develops, implements and maintains the database systems. · Ensures CLIENT’s database systems meet and serve CLIENT’s current and future business needs; conducts feasibility and needs assessment studies; defines functional system requirements and specifications including conducting business process and data analysis; develops technical standards and procedures and system design; recommends improvements and modifications to new and existing database system software to improve business processes. · Maintains and operates systems; monitors and troubleshoots moderately complex problems using established processes and methods. · Provides technical solutions, support and user training on software issues to ensure database users optimize the database infrastructure; provides technical consultation to business units to minimize downtime; troubleshoots hardware, software and applications problems; documents problems and fixes; provides 24-hours on-call support. · Assists in planning, reviewing and conducting work activities and researching required project information associated with department internal/external projects in accordance with established task objectives and schedule as outlined in the project plan/contract. · Performs related duties as required. *Mandatory Requirements* ü Minimum five (5) years of progressively responsible relevant work experience in the design, development, implementation, maintenance and support of application databases utilizing MS SQL Server. ü Minimum three (3) years of progressively responsible relevant work experience in the design, development, implementation, maintenance and support of application databases utilizing Microsoft Windows Server Clusters. *Technical Requirements* *Knowledge of:* · Principals and concepts of relational and network data base management. · DBMS performance tuning and troubleshooting techniques. · Principals and concepts of data management; operating concepts for multi-user, multitasking operating systems. · Concepts and principles related to implementing technology solutions. · Methods and techniques of data access. · Techniques and practices for problem research and resolution. · Techniques and practices for resolving complex technical issues · Concepts of centralized and distributed computing; characteristics and operational needs of various organizational units. · Methods and techniques for planning, organizing and overseeing work activities. · Procedures and practices for monitoring and managing projects. · Methods and techniques for training staff. · Basic principles and practices of budget preparation and administration. · Office procedures, methods, and equipment including computers and applicable software applications such as word processing, spreadsheets, and databases. · English usage, spelling, grammar, and punctuation; safety policies, practices and procedures. *Skill to:* · Plan, develop and implement automated solutions for business functions · Build, maintain and test corporate database environments · Plan the installation of new releases of database software · Install and maintain database management software such as DB2, MS SQL Server and Oracle · Ensure the integrity of all physical database objects · Establish database procedures · Create storage groups, databases, tables and views · Assist in establishing backup, recovery and restart procedures · Analyze procedures/systems and develop/implement operational improvements using information technology systems software, tools and processes · Utilize logic and analysis to identify the advantages and disadvantages of different approaches · Read and interpret plans, diagrams specifications, program languages and contracts · Develop an estimation of how a system should work under ideal conditions; · Analyze and model business processes and data · Conduct feasibilities studies · Identify and assess training needs for staff · Express ideas/facts clearly and concisely to individual or groups, taking into account the audience and nature of information · Stay abreast of new IT technology, tools and methods to develop and support business applications · Plan and organize work to meet changing priorities and deadlines; operate office equipment including computer terminal, systems and software relevant to the job · Compile and prepare technical, statistical and/or analytical reports and presentations · Communicate effectively orally and in writing internally/externally · Establish and maintain effective working relationships internally. *Desirable Qualifications *1. Three (3) or more years of progressively responsible relevant work experience in the design, development, implementation, maintenance and support of application databases utilizing Oracle and/or DB2. 2. Three (3) or more years of progressively responsible relevant work experience in the design, development, implementation, maintenance and support of application databases utilizing AlwaysOn Availability Groups. *Thanks & Regards,* *Shahid MKM* Staffing Manager *Tech - Net Inc* Email: msha...@tech-netinc.com Direct: 916-673-3107 Board: 916-458-4390 Ext: 101 101 Parkshore Dr. Suite #100, Folsom, CA 95630 web: http://www.tech-netinc.com *A WMBE certified company* -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-source-erp-crm+unsubscr...@googlegroups.com. To post to this group, send email to open-source-erp-crm@googlegroups.com. Visit this group at https://groups.google.com/group/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.
