What are the responsibilities and job description for the IBM DB2 LUW DBA Albany - NY - New York position at Sierra Business Solution LLC?
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 incrementalfull 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.
TriggersStored procedureFunctionsindexes 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 bashshell scripting and cron scheduling.
Basic knowledge of ETL and associated processes.
Generic Managerial Skills
Good to have team management skills to lead the initiative if required.
Education
Bachelor of EngineeringTechnology
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
Role Descriptions: Mandatory: IBM DB2 Administration Data Modeling LinuxDesired: IBM InfoSphere DataStage Google Cloud Platform
Essential 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 incrementalfull 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.TriggersStored procedureFunctionsindexes 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 bashshell scripting and cron scheduling.Basic knowledge of ETL and associated processes.
Desirable Skills:
Keyword:
Skills: Database Administration (DBMS)Unix Linux Basics and Commands
Experience Required: 6-8
Salary : $45