Welcome to H1BSupport.Com, please Ask a Question and an H1B Expert will provide an answer within 24 Hours!
Ask a question:

Oracle DBA Sample H1B Specialty Occupation Job Description

2,275 views 4 comments
posted Jan 18, 2016 in H1B Visa RFEs by dan (24,504 points)

The Sample Job Description may be used as an Oracle DBA Job Description to Evident that a DBA falls under the "Specialty Occupation" This description is general in nature for Oracle DBA/Apps DBA/SOA, please make changes as necessary.

JOB DESCRIPTION

As a Database Administrator (Internal: ORACLE SOA Administrator “Service-Oriented-Architecture”), Database administrators use software to store and organize data, such as financial information and customer shipping records. They make sure that data are available to users and are secure from unauthorized access.

General Job Duties

Database administrators typically do the following:

•    Identify user needs to create and administer databases
•    Ensure that the database operates efficiently and without error
•    Make and test modifications to the database structure when needed
•    Maintain the database and update permissions
•    Merge old databases into new ones
•    Backup and restore data to prevent data loss

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. DBAs sometimes work with an organization’s management to understand the company’s data needs and to plan the goals of the database. 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. They typically have a background in system architecture and ensure that the database in a firm’s computer systems works properly.

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. 

We all are familiar with the fact that the “Database Administration” is the toughest of job in the industry. 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. DBA`s plans for security measures by implementing backups, data integrity and security. 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. So that in case of any type of error such as hardware/software failure, data corruption, virus etc. 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.

Specific Job Duties of Oracle SOA Administrator

As part of Oracle SOA Administration role, We need to build and deploy an application in Oracle SOA Suite product which in turn uses the repository as Oracle Database for physical location of the artifacts which is called as Metadata Schema (MDS). We need to configure the Database before configuring the SOA and also we need to do the DBA activities such as Purging, Backup, Verifying, and Dropping Partitions in the Database. We need to actively monitor the long running queries in the Database and DB logs for tuning the SOA environment. Periodical DB activities such as DB Dehydration and Defragmentation have to be performed along with SOA Application Administration duties.

  • Installation of Oracle Software and Databases.
  • Maintaining strong database level security.
  • Troubleshooting Oracle errors.
  • Upgrading and Patching Oracle software and databases.
  • Deployment of strong disaster recovery plans as per SLA.
  • Performance Tuning and proactive database tasks.
  • Maintain proper documentation for future usage.
  • Deploy SOA Suite code following documented deployment procedures.
  • Support development and testing teams to resolve issues.
  • Implement SOA Suite solutions in clustered environments.
  • Occasional requirement to align work hours with Europe test resources.
  • SOA Suite installation and support experience.
  • Work with J2EE technologies.
  • Strong knowledge and experience with Oracle’s Fusion Middleware11g and SOA  technologies like BPEL,           ESB, OSB, WSM, WSDL, and JMS.
  • Experience installing and administering Oracle Fusion Middleware 11g.
  • Strong knowledge and exposure to Oracle AIA FoundationPack.
  • Strong experience and exposure to Oracle jDeveloper11g.
  • Strong knowledge and experience with Oracle WebLogic Server 11g.
  • Able to analyze problems from many different perspectives and work with others to implement new, creative        and powerful solutions.
  • Experience with Oracle Data Integrator 11g a plus.
  • Deploy SOA Suite code following documented deployment procedures.
  • Support development and testing teams to resolve issues.
  • Implement SOA Suite solutions in clustered environments.
  • Occasional requirement to align work hours with Europe test resources.
  • Understand the processes and procedures for computer hardware and software maintenance and                         installation. 
  • Ensures that the technical environment is updated with current, stable versions of software products that comply with approved architecture and system standards. 
  • Ensures availability and performance of SOA environment. 
  • Conducts proactive/reactive performance monitoring / analysis to identify system errors and bottlenecks to assist in tuning 
  • Plans, coordinates, tests and implements installations / upgrades / releases of systems, software and hardware.
  • Determines change specifications, input/output processes, and working parameters for hardware/software compatibility, etc.
  • Monitoring servers using Grid Control and other monitoring tools and handling alerts, notifications.
  • Coordinate Activities with Other Teams
  • Create and Maintain Accurate Documentation
  • Documents and maintains installation procedures, problem resolutions, and environment configurations.
  • Document and maintains Disaster Recovery procedures.
  • Contributes to the development of policies and procedures related to installation, maintenance and inventory.
  • Documents and maintains procedures and requirements for external integration into applications. 
  • Lead Production Support issues/problems as required. Respond to and resolve production support issues. 
  • Work closely with other technicians to diagnose and resolve issues related to the design and maintenance of infrastructure, hardware and software
  • Determines when appropriate to escalate to external vendors 
  • Oracle Infrastructure SME to the application development teams tasked with providing guidelines and direction for application development.
  • Responsible as SME for Oracle infrastructure providing direction to application development teams. 
  • Evaluate software packages, ensuring that they fit within architecture and infrastructure. 
  • Provide timely and accurate on-call support for production infrastructure components. 
  • Administer SOA environments for several in-house-developed and vendor-supplied applications. 
  • Provide training or mentoring to other team members on tools or architecture concepts as needed.

The position offered is in a Specialty occupation.

 “8 C.F.R. § 214.2(h)(4)(iii)(A). In order to perform services in a specialty occupation, an alien must meet one of the following criteria: (1) hold a United States baccalaureate or higher degree as required by the specialty occupation from an accredited college or university; (2) possess a foreign degree determined to be equivalent to a United States baccalaureate or higher degree as required by the specialty occupation from an accredited college or university; (3) have any required license or other official permission to practice the occupation (for example, architect, surveyor, physical therapist) in the state in which employment is sought; or (4) have, as determined by USCIS, the equivalent of the degree required by the specialty occupation acquired through a combination of education, training, and/or experience. Specialty occupations may include, but are not limited to, computer systems analysts and programmers, physicians, professors, engineers, and accountants.”

A specialty occupation requires theoretical and practical application of a body of specialized knowledge along with at least a bachelor’s degree or its equivalent. 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.

4 Comments

commented Jan 21, 2016 by .net developer
Please post a Description for .NET Developers
commented Jan 21, 2016 by Artem
Dear Sirs,
    My favorite technology is PL/SQL and I have a 15 years’ experience of using it.
I participated   in the development/ implementation /maintenance of HW/SW solutions using Oracle
        I have experience of cooperation with native and foreign IT-companies, so and experience in counseling on Oracle DB based software: code development, security, code optimization, industrial automatic monitoring processes etc.
   Currently looking for job opportunity in US with H1B relocation.
H1B Visa sponsorship  required.
replied Jan 22, 2016 by dan (24,504 points)
Please send resume to monica@h1bsupport.com, we will send to Employers. Please note that we do not endorse any Employers!
commented Apr 6 by XYZ
Can you please do share similar Job duties list for SQL Server DBA ?
Name
Email

If you are looking for a Project or an H1B Visa Transfer, with Immediate GC Process, please call us at (800) 693-8939 or h1btransfer@hireitpeople.com

...