• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 11th Jan 2024

• This position is needed to maintain minimum staffing needs of the Oracle Database Services team.
• The IOT Oracle team manages the data for the majority of the State’s agency applications.
• DOR, DWD and DOT are just some of the agencies that have systems which are dependent upon this team for the maintenance of their back-end data.
• Agency applications are dependent upon timely response to accurate and secure data.
• Successful candidates will have extensive experience with the latest releases of Oracle RDBMS and be proficient with Oracle - both in Standalone and RAC clustered environments.
• The candidate should be a self-starter, have excellent communication skills and work seamlessly in a

team environment as well as independently.

• As the Database Analyst Senior, you will support Oracle databases to ensure data integrity, security, and

stability.

• In this position, you will be responsible to provide adequate computer resources and up-to-date software environment to our various customers.
• This position will be responsible for monitoring and tuning database performance. It ensures that data is appropriately protected via database backup and related strategies.
• The position loads, or assists in loading of, database software, upgrade and patching.
• This position will assist with the evaluation and selection of infrastructure components and provide operational support for the database, ensuring data integrity, database availability, and performance.
• The Senior Database Analyst is needed to provide the degree of support that our agency

customers currently expect and to meet their future needs.

 

The essential elements of the job duties:

• Develop and advise on standards, guidelines, policies, and procedures designed to ensure the

integrity of the database environment.

• Evaluate technology and products to determine the feasibility of adding to agency standards.
• Develop work plans for assigned projects and manage the execution.
• Design and implement logical and physical databases of a moderately to large complex nature.
• Determine aggregation, partitioning and indexing strategies for physical data.
• Monitor and tune database performance, including SQL scripts, hints, execution plans, and

materialized views.

• Administer end-user access and security at the database level.
• Ensure that data is appropriately protected via database backup and related strategies.
• The job profile is not designed to cover or contain a comprehensive listing of activities, duties or

responsibilities that are required of the employee. Other duties, responsibilities and activities may

change or be assigned at any time with or without notice.

 

 

Skill

Required / Desired

Amount

of Experience

Strong experience working with Oracle versions 11gR1/2, 12c and 19c in a Windows and / or Linux environment

Required

8

Years

 

 

 

Extensive work experience with Oracle Database version 19c

Required

3

Years

Good observational and analytical skills to help identify and resolve issues with the systems and deployments before and after they occur

Required

8

Years

 

Oracle DBA Experience with strong understanding of database architecture and performance tuning

Required

8

Years

Experience with Backup and Recovery using Oracle Recovery Manager (RMAN)

Required

8

Years

 

Experience with Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Active Data Guard

Required

8

Years

Experience with Oracle Enterprise Manager (OEM) and Golden Gate replication

Required

5

Years

 

Experience with virtualization platforms such as VMware, Citrix, App-V and Terminal Services

Required

3

Years

Self-starter, have excellent communication skills and work seamlessly in a team environment as well as independently

Required

5

Years

 

Expert experience administering various multi-Terabyte, 24x7 uptime Oracle databases as a Systems/Infrastructure Database Administrator

Required

8

Years

Experience with Oracle Data Modeling and database design

Required

2

Years

 

Experience with performing and deployment of database code objects to Test and Production databases and troubleshooting issues

Required

8

Years

Ability to manage database security, users, groups, roles, and permissions

Required

8

Years

 

Extensive knowledge in software and utilities related to supported DBMS such as Reorg, Backup, Recovery, Load and Unload

Required

8

Years

Extensive knowledge of relational database and data warehouse design techniques and dimensional modeling processes

Required

6

Years

 

Extensive knowledge of capacity planning and disaster recovery

Required

5

Years

Bachelor's degree from an accredited college/university with a major in computer sciences or management information systems or equivalent work exp.

Required

5

Years

 

Teamwork is a key element of the position. Ability to collaborate with the DBA team, but also with the developers and system owners

Required

5

Years

Ability to manage multiple hardware and software projects and priorities

Required

8

Years

 

Proven ability to work creatively and analytically in a problem-solving environment

Required

4

Years