Database Architect

Database Architect

Length of assignment: 12 Months

Hours: 8

Location: MD

 

Scope of Position:

The Database Architect will design, maintain and build conceptual, logical and physical database models. The Database Architect will be responsible for database architecture, design, and creation, optimization, deriving conversion and migration methods for existing data, and developing automated conversion and migration methods. The Database Architect will be responsible for the planning, installation, configuration, maintenance and production monitoring of database instances.

 

Main Responsibilities:

1.      Meet with business stakeholders and other technical team members to gather and analyze application requirements

2.      Design database solutions to satisfy application (business and technical) requirements

3.      Implement database solutions using available database development tools

4.      Provide first level operational support for development and production database systems

5.      Provide written status reports to management regarding project status, task, and issues/risks

 

Required Skills:

1.      Bachelor’s degree or Master’s degree in Computer Science, or equivalent experience

2.      5 years working experience in Oracle, SQL Server, Sybase, or other relational database

3.      Oracle RAC 11g experience from the development perspective (database and application), PL/SQL, Solaris, etc.

4.      Ability to analyze existing ETL code in both PL/SQL and shell script, and determine impacts and remediation.

5.      Ability to analyze existing database schema DDL/instance layout and determine impacts migrating to new target schema/instance environment.

6.      Strong experience in Informatica ETL tools

7.      Strong experience in Business Process Modeling (BPM)

8.      Ability to provide guidance to offshore developers and to lead certain design activities.

9.      Ability to interact with external DBAs and help develop approach.

10.  Proficiency in relational database design, data warehousing and database administration

11.  Experience in Oracle Designer, Oracle Developer, Oracle Enterprise Management Tools

12.  Experience in C, C++, Unix Shell Scripts

13.  Experience in configuration management and code version control

14.  Experience in database performance tuning

15.  Experience with Sun Solaris

16.  Good written and verbal communication skills

17.  Good technical and problem solving skills; knowledge of Oracle database server, SQL, PL/SQL, XML, SQL Server, UNIX, shell scripting

Desired Skills:

Experience in financial service industry is a plus

 

 

 

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.