Centraprise
DB2 UDB LUW
Centraprise, Newark, New Jersey, us, 07175
Requirements -
Candidate should be comfortable to work in Hybrid Model (2-3 Days a week in Newark, NJ Office).Top 3 Skillset required.DB2 UDB LUW 11xDB2 SQL developer & Shell Scriptingdatabase performance tuning including stored procedures.Table used for screening profiles for this position -Expectation from JD
Evaluation Result (0 to 5) 5 being highest
5-7 years' experience with DB2 UDB 11.x
5-7 years' experience as SQL developer.
Demonstrable experience with analysing complex stored procedures.
Extensive experience with database performance tuning including stored procedures.
Solid knowledge of IBM DB2 UDB and technical database concepts, such as: logical relational data modeling, physical data modeling, tuning large instances, resource management, data replication and backup/recovery techniques.
Experience evaluating and implementing new UDB features to address business requirements.
Experience in LINUX/UNIX Korn Shell scripting.
Agile experience expected.
Leadership skill/ Soft skills: Collaborative, team player. Self-starter. Curious about technology.
Industries: Financial services tech experience is a plus.
Job Description -Create and maintain databases and objects.Ensure business continuity by performing data maintenance, backup planning, recovery of table spaces and indexes, high availability and business continuation testing, statistic gathering, etc.Assist with resolving batch performance issues.Work with explains, copy, quiesce, recovery, statistics, loads and other online and offline utilities.Develop, maintain, and troubleshoot complex plans, stored procedures, packages and triggers.Grant and revoke authority to users/groups.Assist developers in database and application tuning for optimal performance.Be able to troubleshoot locks in environment and remove the connection holding the lock.Conduct major and emergency database releases.Work closely with production DBAs and infrastructure teams across the enterprise as needed.Automate database code deployments for continuous integration/development.Supported Environments and Platforms:
PrimarilyDB2 UDB 11.5,Other RDBMS experience helpfulSupport services include:
Strong analytical & mathematical skills, written & spoken communication skills; stored procedure development; LINUX/UNIX Korn Shell scripting, Autosys job management.Development DBA/Modeler with additional skills in Linux, Autosys, Cyberfusion, Jenkins, BitbucketThe ideal candidate must have:
7+ years of experience working with DB2 UDB.In-depth knowledge of database design and constructs.Experience maintaining data interfaces with various 3rd party applications.Keen customer focus, relationship-building skills, and the ability to deliver commitments on a timely basis.Ability to work both independently and as a team player.Strong analytical and problem-solving skills, with the ability to resolve problems and make decisions independently.Strong written and verbal communication skills.
Candidate should be comfortable to work in Hybrid Model (2-3 Days a week in Newark, NJ Office).Top 3 Skillset required.DB2 UDB LUW 11xDB2 SQL developer & Shell Scriptingdatabase performance tuning including stored procedures.Table used for screening profiles for this position -Expectation from JD
Evaluation Result (0 to 5) 5 being highest
5-7 years' experience with DB2 UDB 11.x
5-7 years' experience as SQL developer.
Demonstrable experience with analysing complex stored procedures.
Extensive experience with database performance tuning including stored procedures.
Solid knowledge of IBM DB2 UDB and technical database concepts, such as: logical relational data modeling, physical data modeling, tuning large instances, resource management, data replication and backup/recovery techniques.
Experience evaluating and implementing new UDB features to address business requirements.
Experience in LINUX/UNIX Korn Shell scripting.
Agile experience expected.
Leadership skill/ Soft skills: Collaborative, team player. Self-starter. Curious about technology.
Industries: Financial services tech experience is a plus.
Job Description -Create and maintain databases and objects.Ensure business continuity by performing data maintenance, backup planning, recovery of table spaces and indexes, high availability and business continuation testing, statistic gathering, etc.Assist with resolving batch performance issues.Work with explains, copy, quiesce, recovery, statistics, loads and other online and offline utilities.Develop, maintain, and troubleshoot complex plans, stored procedures, packages and triggers.Grant and revoke authority to users/groups.Assist developers in database and application tuning for optimal performance.Be able to troubleshoot locks in environment and remove the connection holding the lock.Conduct major and emergency database releases.Work closely with production DBAs and infrastructure teams across the enterprise as needed.Automate database code deployments for continuous integration/development.Supported Environments and Platforms:
PrimarilyDB2 UDB 11.5,Other RDBMS experience helpfulSupport services include:
Strong analytical & mathematical skills, written & spoken communication skills; stored procedure development; LINUX/UNIX Korn Shell scripting, Autosys job management.Development DBA/Modeler with additional skills in Linux, Autosys, Cyberfusion, Jenkins, BitbucketThe ideal candidate must have:
7+ years of experience working with DB2 UDB.In-depth knowledge of database design and constructs.Experience maintaining data interfaces with various 3rd party applications.Keen customer focus, relationship-building skills, and the ability to deliver commitments on a timely basis.Ability to work both independently and as a team player.Strong analytical and problem-solving skills, with the ability to resolve problems and make decisions independently.Strong written and verbal communication skills.