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 :- 30th Sep 2024
The Database Administrator is responsible for data analysis and database management. Involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Knowledge of the utilities and production tools used for data storage management to support the Application Team. Coordinates physical changes to computer databases; codes, tests, and implements physical database, applying knowledge of data base management system. Designs logical and physical databases reviews description of changes to database design to understand how changes to be made affect physical data base. Establishes physical database parameters. Uses structured query language (SQL) to define database objects using database definition language (DDL) and control access to database objects using data control language (DCL). Calculates optimum values for database parameters, such as amount of computer memory to be used by database, following manuals, and using calculator. Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data. Specifies which users can access data bases and what data can be accessed by user. Tests and corrects errors, and refines changes to database. Uses database utility programs and 3rd party utilities to monitor database performance, such as distribution of records and amount of available memory. Modifies data base programs to increase processing performance, referred to as performance tuning.
Skill
Required / Desired
Amount
Actual years used
Last Years used
Experience managing Oracle DB and client requirements as an Admin
Required
5
Experience Migrating Oracle 12c - Oracle 19c
Required
3
Experience writing shell scripts for automation of backup scripts
Required
3
Experience with Oracle 12 c and Oracle 19c archive scripting
Required
3
Experience Oracle 19c migration testing
Required
3
Experience Documenting Database migration activities
Required
3
Managing Database on Unix Operating System
Required
4
Managing Database on Windows Operating System
Required
4
Experience Migrating sql server database 2014 to SQL Server 2019 database
Highly desired
2
Experience Testing and validating Always on migration 2014 to Always on 2022
Highly desired
2
Experience with SQL Server Administration
Highly desired
2
Bachelor’s Degree
Required