Specialist-Technology Services

Job Description

Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex IBM DB2/LUW databases from version 10.1 to 11.5/12.1 on AIX and RedHat Linux Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance. Identifies and resolves problem utilizing structured tools and techniques. Provides technical assistance and mentoring to team in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance. Basic knowledge in writing scripts to automate DBA routine tasks. Education, Technical Skills & Other Critical Requirement Education Bachelor s degree in computer science, Information Systems, or another related field with 3+ years of IT and Infrastructure engineering work experience. Experience (In Years) 3+ Years Total IT experience & 2+ Years relevant experience in UDB database administration Technical Skills 2+ years of related work experience with database design, installation configuration and implementation. Limited knowledge of all key IBM DB2/LUW utilities such as HADR, Reorg, run stats, Load on (Linux/Unix/Windows) At least 1+ years of experience working on Unix and Linux operating systems. Basic experience in database Upgrades and Patching Basic experience in cloud computing (Azure, AWS RDS, IBM Cloud PAK) Experience administering IBM Informix databases is a Big Plus. Working knowledge of backup and recovery utilities like Rubrik, Networker Management of database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers, and declarative integrity constraints Working knowledges in IBM db2 LUW replication (Db2 SQL replication and Q Replication, a Queue -based Replication) as well as Using Third party tools for Replications. Handling data security (User Access, Groups and Roles). Should have ability to work closely with IBM-PMR to resolve any ongoing production issues. Knowledge of the ITSM process with Change, Incident, Problem, Service Management using ServiceNow tools. Good database analytical skills to improve application and database performance. Other Critical Requirements Automation tools and programming such as Ansible, Shell scripting and MS PowerShell is preferrable. Basic Database monitoring with Observability tools (Elastic) is preferable. Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders. Basic Project management experience in creating document and presentation. Demonstrate ability to work independently and in a team environment Ability to work 24*7 rotational shift to support for production, development, and test databases