Duration: 6 months
Location: Jersey City, NJ
Job Title: DB2 DBA
As a DBA, the ideal candidate would be responsible for installing DB2 software and maintenance of enterprise databases; testing and applying DB2 fixpack updates; monitoring, managing, and maintaining backup and recovery schedules for database servers; and design and maintain data access control policies and ensure compliance with company audit policies. The job also entails monitoring database performance and working with other team members to remove bottlenecks and improve overall performance, enforcing database policies and procedures, providing database administration for developers and team members.
Duties and Responsibilities:
- Install ibm db2 software.
- Assist in performing data migration from oracle platform to DB2 platform.
- Create practice and maintain standard installation and setup procedures for database servers.
- Maintain and facilitate standard backup procedures, retention plans, and restore testing.
- Assist with data migration between systems including regular data refreshes and making production data anonymous for use in testing environments
- Work pro-actively to gauge the performance of the application & database and provide recommendations to achieve the optimal architecture
- Assess impact on performance with different changes and review scalability of the infrastructure.
- Maintain standard procedural documentation related to all aspects of operating the database platforms.
- Participate in incident resolution as an escalation point for database incidents.
- Document known errors or workarounds in the shared Knowledge Base.
- Consult with vendors & other teams to recommend best practices and tune software during the development cycle.
- Recommend and maintain standards for monitoring and event management to be used in production databases.
- Assist in tuning SQL in stored procedures.
- Perform testing and production builds involving data changes and stored procedure building while following established change management procedures
- Assume all DBA duties in testing and development environments, maintaining design and data consistency throughout
Skills Required:
- Computer Science degree or equivalent experience.
- 6+ years of DB2 Database Administration experience out of which minimum 1+ should be on DB2 9.x versions.
- Experience on HADR and QREP technologies will be a plus.
- Must know AIX versions 5.x and 6.x and specifics of DB2 operations on AIX
- History of managing multiple RDBMS in large environments in AIX environments.
- Experience with redundancy and resiliency applied to create a high availability service.
- Practical experience in monitoring and tuning a database.
- Experience in working in a 24X7 environments and on-call support.
- Strong interpersonal skills.
No comments:
Post a Comment