Software Guidance & Assistance, Inc., (SGA), is searching for a DBA (Journey Level) for a Right to Hire assignment with one of our premier financial clients in Jersey City, NJ.
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

Required Skills:  


* 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.


SGA is a Certified Womans Business Enterprise (WBE) celebrating over thirty years of service to our national client base. We offer a variety of benefit options including but not limited to health & dental insurance, paid vacation, timely payment via direct deposit in addition to transferring H1B Visa sponsorship. Please inquire about our referral program if you would like to submit a candidate for any of our open or future job opportunities. To view all of our available job postings and/or to learn more about SGA please visit us online at www.sgainc.com.