Job Description

Hello,

I hope you are doing well.

My name is Aryan and I work as a Recruiter for Akkodis .

Akkodis is seeking an IT Systems Analyst III - DB2 DBA

Job Title: IT Systems Analyst III - DB2 DBA

Job location: Syracuse NY 13202

Job type: Contract

Pay rate/ Salary: $50/hr. -$60/hr. on W2

JOB DETAILS:

Responsible for the performance, integrity and the security of National Grid’s Production and Test Logical DB2 environment for our critical Customer Service System (CSS) that consists of 638 Production DB2 tables and support of 16 test environments. Our DB2 environment is split between logical and physical support. For this position will be to manage the DB2 logical environment and support the physical DB2 DBA within our supplier group.

Our department is a fast-paced critical environment that requires strong analytical skills once an issue occurs to analyze the issue quickly and help provide a resolve and work within a multi-supplier environment for full resolution.

Key Accountabilities for Logical Database Activities

• Create/Update application DB objects (tables, function, index, procedures, etc.)
• Application specific SQL tuning, diagnostics, recommended changes
• Data repairs SQL verification
• SQL code implementation for Production and test environments
• Health checks
• Manage/monitors database events (batch jobs)
• Database growth tracking
• Batch execution support (Production and test environments)
• Support of Customer Service System (CSS) production push support
• Database backups and restores (Production and test environments)
• Index, partition recommendations and implementation
• Archival Strategy recommendations and implementation
• Manage database event monitors
• Application Database growth tracking and management
• Data provisioning and management of SOX controls
• Manage application data auditing
• Manage application database links
• Support System Administrator Physical DBA
• Support installation, upgrade and patching of DB2 database environment
• Maintain DB2 database environments, ensuring optimal performance and data integrity
• Work with Physical DB2 DBA on capacity planning and management
• Respond to requests and incidents related to the logical environment quickly and efficiently
• Writing database documentation, including data standards, procedures and definitions for the data dictionary
• Testing and modifying databases to ensure they operate reliably
• Manage database access accurately and within SOX regulations
• Ability to analyze and solve complex database issues using exceptional problem-solving skill quickly and efficiently
• Recovery and restoration in case of any data loss

Qualifications

Mandatory Qualifications

• Proven work experience as a DB2 Database Administrator
• Firm grasp on DB2 database management and deployment
• Experience with DB2 diagnostic tools
• Strong command over SQL and DB2 related scripting
• Excellent understanding of data administration and management function (collection, analysis, distribution, etc.)
• Proficient in database security administration
• 5+ years of experience in being a DB2 database administrator
• Degree-level qualification in a relevant discipline (e.g. Computer Science, Information Technology or similar)
• Experience of working in a multi-vendor outsourced environment and with remote offshore teams
• Exposure and knowledge of compliance and controls frameworks like SOX, NACHA, PCI and others.
• Ability to influence stakeholders and work closely with them to determine acceptable solutions
• Excellent communication skills to work within a multi supplier environment
• Experience with performance tuning and capacity planning to optimize database performance and ensure efficient resource usage
• Excellent problem-solving skills
• Knowledge of DB2 Replication

Preferred Qualifications

• Professional Certification for DB2 Database Administration

Benefits:

Equal Opportunity Employer/Veterans/Disabled

Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, an EAP program, commuter benefits, and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs that are direct hires to a client.

To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:

· The California Fair Chance Act

· Los Angeles City Fair Chance Ordinance

· Los Angeles County Fair Chance Ordinance for Employers

· San Francisco Fair Chance Ordinance

Best Regards,

Aryan Kumar Gaurav

Resource Development Manager

D: 610-632-8567

E: aryan.gaurav@akkodisgroup.com

Akkodis

Enterprise Solutions

World Leader in IT and Engineering Workforce Solutions

( An Adecco Group Company )

This message is intended only for the designated recipient(s). It may contain confidential or proprietary information and may be subject to other contractual or confidentiality protection. If you are not a designated recipient, you may not review, copy or distribute this message. If you receive this message in error, please notify the sender by reply email and delete this message.­­

Akkodis, part of The Adecco Group North America located at 4800 Deerwood Campus Parkway, Building 800, Jacksonville, FL 32246, is committed to data privacy compliance. To learn more about how we collect and process personal information, please read our located on the website above.

Job Tags

Similar Jobs