Apply Now    

Database Management

Req #: 180017317
Location: New York, NY, US
Job Category: Technology
Job Description:
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
  • Computer Science degree or equivalent experience.
  • Proven 5+ years of DB2 Database Administration experience out of which minimum 1+ should be on DB2 10.x versions.
  • Some practical experience on Oracle Databases is desired (though not required).
  • Strong knowledge and hand-on experience on Q-replication is required.
  • 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.
Apply Now    
Link for schema

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Other Information

Apply Using LinkedIn

You can also apply using your LinkedIn® profile. It may save you some time because your information will be automatically transferred into our system. Just click on the LinkedIn logo when you get to the application screen and follow the directions.

Submit an Updated Résumé

During the application process, be sure you have an up-to-date copy of your Résumé, your cover letter and any other documentation you would like to submit.