Data Warehouse DBA

Data Warehouse DBA

Duration: 4+ months

Location:  NY 

 

 

Job Description:

Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database. Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues. May require a bachelor's degree in a related area and 6 - 8 years of experience in the field or in a related area.

The Data Warehouse Database Administrator partners with the System Engineers, Middleware Group, Database Design Group and Application Teams to ensure the availability, performance, security and maintenance of the PBG Enterprise Data Warehouse.

When not directly responsible for project work, the DWH DBA is responsible for assessing the impact of all project work performed against the DWH enforcing compliance with Architectural and Database standards as well as ensuring maximum performance.

While the Database Designers and Application teams are focused on specific projects, the Database Administrators are focused on the Data Warehouse as a whole.
Review , approve and implement physical design changes provided by the Database Design Team ensuring complicance with the current architecture as well as maximum performance from the design Provide code reviews and make performance recommendations to application and ETL teams Architect and implement backup/recovery procedures Monitor the health of the Data Warehouse on an ongoing basis proactively discovering performance opportunities and potential threats to system stability.

Resolve production database issues and determine root cause of all failures

 Required Skills:
 DB2
 Oracle
 SQL
 UNIX

 

 

 

 

Best Regards,

Venkatesh

Softpath Systems, Inc.

75 Maiden Lane,

Suite # 903,

New York. NY-10038.

Ph: 212-405-1894 x 104

Fax: (212)-405-1895

www.softpathsystems.com.

 

This message contains privileged and confidential information and is intended only for the individual named. If you are not the intended recipient you should not disseminate, distribute store, print, copy or deliver this message. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system's-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.