Hello
Hope you are doing well,
Please go through the below role, this is complete onsite job in Albany, NY, if you are interested please share your updated resume.
DB2 DBA
Albany, NY.
Please note this is an onsite only role and the candidate will be expected from Building 12, Albany from day 1.
Opening for a seasoned DB2 DBA with min 7+ years of experience. Please share resumes at the earliest based on the following job description.
Job Title
DB2 Database Administrator
Relevant Experience
(in Yrs)
7+ exp
Technical/Functional Skills
Mandatory: IBM DB2 Administration, Data Modeling, Linux
Desired: IBM InfoSphere DataStage, GCP
Experience Required
7+ Exp
Roles & Responsibilities
Technical skills:
DB2 LUW Database server installation, configuration and upgrade on Linux servers.
Database disaster recovery setup (HADR).
Database server encryption using DB2 native encryption and IBM Guardium.
Manage database authentication and authorization.
Database monitoring and performance optimization; db2expln, db2advis, db2top, db2diag, db2pd etc.
Database backup and log management; database restoration from incremental/full backup image.
Database storage space (tablespaces) and memory (bufferpools) management; database capacity planning.
Design and implement database changes according to business requirement; roll-out changes to various database environments with releases.
Data movement across various database environments.
Triggers/Stored procedure/Functions/indexes creation based on application requirement.
Logical data modelling and ERD generation using Erwin.
Data loading and error resolution using load and import utilities.
Data Profiling and cleansing using SQL statements.
Perform database maintenance activities such as runstats, reorg, snapshots, prun logs etc.
Knowledge of bash/shell scripting and cron scheduling.
Basic knowledge of ETL and associated processes.
Education
Bachelor of Engineering/Technology
Start date (dd-mmm-yy)
ASAP
Duration of assignment (in Months)
12 months
Work Location
Albany, NY
Key words to search in resume
IBM DB2 Database Administrator, Linux
| Location | Albany, NY |
| Job Type | Contractor |