Role : Mainframe DBA DB2 Lead Location : Remote Long Term - Manages all operational technical aspects of database related projects or prioritized business initiatives; analyzes systems, evaluates business requirements and develops action plans from a set of formally communicated specifications.
- Performs capacity and performance analysis to provide management with timely and accurate information predicting future resource requirements as well as ensuring database have sufficient current resource capacity (i.e. data storage, connections, memory, etc.).
- Operates and continuously monitors advanced database high availability service capabilities with clustering, mirroring, replication, and archiving of data.
- Demonstrates ability to work and be accountable in cross functional Agile (Kanban) teams on large corporate technology initiatives.
- Participates in continuous service delivery improvements for internal operations seeking discreet opportunities for automation of services or aspects of services.
- Schedules and performs maintenance on databases to keep them running at peak performance.
- Has a strong working knowledge of SQL constructs, features, performance, and tuning.
- Creates and maintains physical database objects such as: tables, tablespaces, views, indexes, triggers, stored procedures ensuring data integrity, privatization, and peak performance.
- Refreshes database environments as necessary.
- Proactively analyzes access patterns by business processes and makes appropriate tuning adjustments.
- Performs/schedules maintenance on databases to keep them running at peak performance
- Responsible for ITIL Service Management processes with Incident, Problem, Service Request, Change & Release Management with respect to defined service accountability.
- Develops, implements, and tests database backup and recovery policies and procedures.
- Creates and maintains documentation for database policies, procedures, and processes.
- Has operational oversight for advanced database capabilities such as high availability and data replication.
- Has operational oversight for data privatization (i.e. data encryption, activity monitoring).
- Proactively and continuously looks to improve their technical skills with informal and formal training opportunities, keeping abreast of the database technical landscape
- Actively participates in an on-call rotation, one week on (evening and overnight hours) and multiple weeks off.
- The ability to partner with data analysts, application developers, and business partners to analyze, design and implement physical design changes to DB2 databas
Thanks & Regards, Sanju TekLeaders Inc 9300 John Hickman Parkway, Suite # 801 Frisco, TX 75035 Mob: 214-758-7541 Email: sanju@tekleaders.com | Arun Kajipeta , Business Development Manager | P : 2149749573 | A : 4975 Preston Park Blvd, Suite 500 Plano, TX 75093 | W : tekleaders.com E : arun@tekleaders.com | | | | | |
Comments
Post a Comment
Thanks