What are the responsibilities and job description for the DB2 DBA position at Emonics, LLC?
-Title : DB2 DBA
Location : Albany NY
Job Type : Fulltime
Job Description:
Experience required:
Technical/ Functional Skills:
Roles and responsibilities:
Location : Albany NY
Job Type : Fulltime
Job Description:
Experience required:
- 8 years
Technical/ Functional Skills:
- IBM DB2 Administration
- Data Modeling,
- Erwin,
- Linux
- Desired: IBM InfoSphere DataStage
Roles and responsibilities:
- 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.
Java Architect with DB2
Donato Technologies, Inc. -
Albany, NY
Java Architect (13 plus) with DB2 with State Experience
Sligo Software Solutions Inc. -
Albany, NY
SQL Server DBA
ACS Consultancy Services, Inc -
Albany, NY
