They make sure that data are available to users and are secure from unauthorized access. Database administrators, often called DBAs, make sure that data analysts can easily use the database to find the information they need and that the system performs as it should. Database administrators often plan security measures, making sure that data are secure from unauthorized access.
Many databases contain personal or financial information, making security important. Database administrators are responsible for backing up systems in case of a power outage or other disaster.
They also ensure the integrity of the database, guaranteeing that the data stored in it come from reliable sources. Many database administrators are general-purpose DBAs and have all these duties.
However, some DBAs specialize in certain tasks that vary with the organization and its needs. Two common specialties are as follows:. System DBAs are responsible for the physical and technical aspects of a database, such as installing upgrades and patches to fix program bugs. Application DBAs support a database that has been designed for a specific application or a set of applications, such as customer service software.
Using complex programming languages, they may write or debug programs and must be able to manage the aspects of the applications that work with the database. They also do all the tasks of a general DBA, but only for their particular application. Database Administration involves tasks from Installing, Configuring and Maintaining databases to the tasks of managing, organizing, storing, and retrieving stored data efficiently, and providing databases with high security etc. Here Database Administrator plays very crucial role and has lot of responsibilities in managing database.
In case of any data loss due to data corruption or any such failure, DBA take on recovery measures. Various roles and responsibilities of oracle database administrator from planning database to rolling out include:. He or she should have knowledge of both front-end and back end. Design database data model by mapping logical design and guide the designing team about performance requirements. Evaluate hardware and software requirements. Write data structure, procedure and various important documents for databases.
Control access and permissions to the database users. DBA has to enroll user and privileges to users. Database administrator are responsible for data analysis and provide best query execution plan and resolve the performance issues by proper indexing, data retrieval and storage mechanisms.
Manage database parameters and monitor performance of the database. He has need to Maintaining data format and standards. Database Administrator is able to Implementing Backup Policies for disaster management. In this case database administrator must recover database and make it available to users. Optimizing database for its better performance, provide database resource management features that can help controlling resource allocation.
Performance tuning. After installation and configuration, downloading and installing patches on regular basis. If you have multiple production database systems or create testing and development database system similar to your production database systems, then DBA has to roll out existing installation to other hosts. Creating and developing strong disaster management policy as per requirement of SLA and company.
Specialty occupations may include, but are not limited to, computer systems analysts and programmers, physicians, professors, engineers, and accountants. For example, architecture, engineering, mathematics, physical sciences, social sciences, medicine and health, education, business specialties, accounting, law, theology, and the arts are specialty occupations.
The nature of the specific duties of the position offered are so specialized and complex that the knowledge required to perform the duties is attained only through a baccalaureate or higher degree. Our Company requires this degree or its equivalent as minimum requirement for entry into this specialty occupation, and this degree requirement is common to the industry in parallel position among similar organization.
I think this articles is actually about the Oracle Database and different kinds of sample relation with H1B. The whole website is actually about the Oracle which is good development language.Members may download one copy of our sample forms and templates for your personal use within your organization. Neither members nor non-members may reproduce such samples in any other way e.
Scrutiny of cap-subject H-1B petitions—especially of job duties, worker qualifications and wages—has increased since President Donald Trump's "Buy American, Hire American" executive order took effect last spring. Through AugustU. It appeared that USCIS officers were learning new ways to apply the executive order and related training.
These requests for more information are no trifling matter. RFEs will delay approvals, which in turn could delay start dates," Storch said.
The H-1B visa is generally reserved for jobs that require at least a bachelor's degree. Last year "there was a tightening of what occupations qualify, as USCIS issued RFEs questioning the job classification and whether a degree was required for the role," Grunblatt said.
Job descriptions need to be as specific as possible and be very closely related to the Standard Occupational Classification SOC code that is used on the petition's labor condition application, said Beth Carlson, an immigration attorney and counsel in the Minneapolis office of law firm Faegre Baker Daniels. Including special skills, technologies and possible coursework related to the job can be helpful to the specialty occupation argument.
USCIS has been questioning whether foreign nationals' degrees and experience qualifies them for the job. Specifically, "USCIS focused on cases where the degree was not clearly related to the occupation or where the foreign national did not have an equivalent of a U. Long explained that if the foreign worker has a degree in an unrelated or a somewhat-related field but many years of work experience in a field related to the job, the employer should obtain an evaluation that determines that the education plus the work experience is equivalent to the requirements requested by the position.
It's important for employers to document why the salary is appropriate for an entry-level position and why an entry-level position still meets the specialty occupation standard because many H-1B hires are indeed recent graduates filling entry-level positions with salaries falling under Level 1 or Level 2 on the DOL wage scale. In other words, employers will have to demonstrate that the position is complex enough to qualify for an H-1B, but still suitable for Level 1 or Level 2 wages.
Was this article useful? SHRM offers thousands of tools, templates and other exclusive member benefits, including compliance updates, sample policies, HR expert advice, education discounts, a growing online member community and much more.
You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page. By Roy Maurer February 7, Reuse Permissions. Image Caption. Specialty Occupation "The most common form of RFEs seen recently are those related to whether a job qualifies as a 'specialty occupation,' particularly when it is associated with an entry-level wage," Storch said. You have successfully saved this page as a bookmark.
OK My Bookmarks. Please confirm that you want to proceed with deleting bookmark. Delete Cancel. You have successfully removed bookmark. Delete canceled. Please log in as a SHRM member before saving bookmarks. OK Proceed. Your session has expired. Please log in as a SHRM member.
Job Description Sample
Thread starter nrsud Start date Sep 30, My company is in the process of starting my GC process. I have a masters degree in computer science. Could someone please post a sample job description for a software engineer to be qualified in the EB2 category. I would greatly appreciate your help. Confer with systems analysts, engineers, programmers and others to design system and to obtain information on project limitations and capabilities, performance requirements and interfaces. Modify existing software to correct errors, allow it to adapt to new hardware, or to improve its performance.
Analyze user needs and software requirements to determine feasibility of design within time and cost constraints. Consult with customers about software system design and maintenance.
Coordinate software system installation and monitor equipment functioning to ensure specifications are met. Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design. Develop and direct software system testing and validation procedures, programming, and documentation. Analyze information to determine, recommend, and plan computer specifications and layouts, and peripheral equipment modifications.
Supervise the work of programmers, technologists and technicians and other engineering and scientific personnel.Big Story - Covid-19 set to hit H-1B visa aspirants
Obtain and evaluate information on factors such as reporting formats required, costs, and security needs to determine hardware configuration. Analyze user needs and develop software solutions. Design software or customize software for client use with the aim of optimizing operational efficiency. May analyze and design databases within an application area, working individually or coordinating database development as part of a team.
Engineering and Technology — Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services. Mathematics — Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications. Telecommunications — Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.
English Language — Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar. Design — Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models. Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
Complex Problem Solving — Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions. Active Learning — Understanding the implications of new information for both current and future problem-solving and decision-making. Troubleshooting — Determining causes of operating errors and deciding what to do about it.Could someone share a sample document to help me prepare a response. I will list them below:.
Position Description: Provide a more detailed description of the work to be performed by the Beneficiary for the entire requested period of validity.
Include specific job duties, the percentage of time to be spent on each duty, level of responsibility, hours per week of work, and the minimum education, training, and experience necessary to do the job. Also, explain why the work to be performed requires the services of a person who has a college degree or its equivalent in the occupational field.
Industry-Wide Job Postings: Provide evidence to establish a degree requirement is common to the industry in parallel positions among similar organizations. More importantly, the listings must clearly show the specific educational background required to perform the duties of the proffered position. Please provide any more up-to-date announcements than we presently have on record. Employees in Same or Similar Positions: Provide a list of current or previous employees holding the proffered role listed above or similar positions with your company.
H-1B Discussion Forum
Just to add to details, i have a Bachelor of Engineering in electronics and the proffered position is in IT, although i have few days less than 5 yrs of experience in IT. Any help is highly appreciated, and i am running out of time so, the sooner i have something substantial the better.
Can someone please share how to respond? These highly technical questions are designed to establish the specific professional reasons why an H1B deserves to be in the US; nobody but the H1B can answer this question effectively. The answers should be detailed and direct. Generic terms hard working, sincere, capable, leadership skills etc must be avoided as they raise a red flag. H1B Visa. PR February 23,am 1. I will list them below: Position Description: Provide a more detailed description of the work to be performed by the Beneficiary for the entire requested period of validity.
Satpat February 23,am 2. Have you got any response from uscis? I also have same kind of rfe. Cheers, Raghu.Please use this template to provide an explanation on how an H1B Specialty Occupation job duties matches the courses taken by the beneficiary including experience.
Released June 1, You can post now and register later. If you have an account, sign in now to post with your account. Paste as plain text instead. Only 75 emoji are allowed. Display as a link instead. Clear editor. Upload or insert images from URL. By Facebook User Started 20 hours ago. By Facebook User Started 21 hours ago. Search In. About This File Please use this template to provide an explanation on how an H1B Specialty Occupation job duties matches the courses taken by the beneficiary including experience.
Released June 1, No changelog available for this version. Join the conversation You can post now and register later. Your email address Required This will not be shown to other users. Add a review Insert image from URL. Add review.
H1B Itinerary of Services Template. Is the consulate in Toronto accepting visa appointments for H-1B stamping?
I work for the same employer same client for 6 years. H1B amendment denied on Mar 23rd. Yet to receive denial notice from uscis. Have valid I94 till July. Since its been 3 weekswait till I get the notice?O-1 Entertainment Visas. L1 Visas for Managers and Executives. Investment Visas. Acquiring Asylum in the United States. Deportation Defense. Cancellation of Removal. Deferred Action. Fraud Waiver Adjustments. Adjustment of Status through Marriage. I with Provisional Waiver.
K1-K3 Marriage Visas. Obtaining Green Cards Through Marriage. Removal of Green Card Conditions. Parents of US Citizens. Provisional Unlawful Presence Waiver. Same Sex Marriage Sibling Immigration. Expiring I Green Cards. Immigration Options for Victims of Crimes. Options for Abused Spouses, Children and Parents. U-Visa Immigration. VAWA Petitions. Human Resources HR and Professionals. Visiting the U. Permanent Residency for Foreign Nationals. Read our Blog.
Obtaining an H-1B visa as an employer or a qualified foreign national worker can be very challenging, especially since the U. It is crucial to meet the eligibility requirements and to file the appropriate documentation as soon as possible to ensure the success of your application.Forgot your password? Please include specific job duties, the percentage of time to be spent on each duty, level of responsibility, hours per week of work, and the minimum education, training, and experience necessary to do the job.
Also, the letter should provide an explanation as to why the work to be performed requires the services of a person who has a baccalaureate degree or its equivalent in the occupation field. I have approximately 5 years of work experience. Can somebody please help me file this response? One that required Bachelors degree. You need to be a member in order to leave a comment. Sign up for a new account in our community.
It's easy! Already have an account? Sign in here. All posts are moderated, so it will take time for your post to appear! Search In. Recommended Posts. Report post. Posted November 17, Share this post Link to post. Posted November 20, edited. Is your attorney providing any guidance? Edited November 20, by preety Create an account or sign in to comment You need to be a member in order to leave a comment Create an account Sign up for a new account in our community. Register a new account.
Sign in Already have an account? Sign In Now.