This position is located in Jersey City, NJ. Princeton Information is seeking a Database Architect for the following - Job Description: - Key Accountabilities/Activities:
- Design and build database structure and objects that best support operational and analytics application
- Assess and analyze data requirements for applications and/or problems
- Translate data requirements into database structures for optimal performance and availability
- Implement, test and debug physical database objects for performance and troubleshooting
- Design and implement optimal star and snowflake schema in the database
- Communicate and collaborate with team members and management on the designed database structures and schemas
- Write and present eloquently with the appropriate audience perspective in mind
- Support troubleshooting of production issues of existing application as warranted
- Participate in collaborative discussions with team members to monitor progress against enhancement queue and bug resolution.
- Stay proactive in identifying potential risks/issues due to the overall application design and make recommendations for improvements
- Design and implement highly available and scalable architecture for database environment and its required SLAs
- Develop and implement strategies for data partitioning to support applications' scalability and availability needs
- Develop and implement strategies for data federation, replication and virtualization
- Develop and implement strategies for data archival and recovery (for both primary and remote sites)
- Ensure alignment of objects design with the enterprise defined data governance and architecture principles
- Support the specification and construction of the designed objects to completed solution
- Research and select appropriate database technology and tools for effective management and troubleshooting
- Define and develop reusable database strategies to be leveraged across enterprise database management systems
- Continue to expand the knowledge and specialization in the evolving database technology and architecture
Position Requirements: - Key Skills
- Core Competency:
- Excellent oral & written communication skills; Proficient with SDLC
- Self motivated, goal oriented, and organized; team player; works independently with self prioritization of activities to support organization objectives
- Demonstrated analytical and strong innovative ability with wide implementation skills; Good technical and problem solving skills
- Project management responsibilities include identifying the scope of assigned projects, generating solutions to technical issues, and providing deliverables in a timely and efficient manner.
- Technology:
- Oracle 11g/10g RAC; Oracle Partitioning, Oracle OLAP, Star Schema configuration, Materialized views, Replication, Oracle Data Guard, GoldenGate; Enterprise Manager - Tuning & Monitoring Packs;
- Working knowledge of warehouse Oracle functions (e.g. Roullup etc.), Star Schema design using Bitmap indexes is a must
- Operating Systems- AIX, Solaris, RedHat Linux
- Data Virtualization/Federation technology – preferably MetaMatrix
- 10+ years experience as a Oracle Database Architect/Administrator in a Global Enterprise – preferably in financial industry and 3+ years experience in a team lead role
- Oracle Certified Professional (OCP) credentials
- Good understanding of design principles of master data management, operational stores, data marts, data warehouse system
.
Thank you,
Christy Zuppa
.........................
If you are not currently seeking employment, or if you would prefer I contact you at some later date, please indicate your date of availability so that I may honor your request. In any event, I respectfully recommend you continue to avail yourself to the employment options and job market information we provide with our e-mail notices.
Thanks again.
Christy
............................ Princeton Information 100 Harborside Financial Center, 11th Floor Jersey City, NJ 07311 201-604-9900
christy.zuppa@princetoninformation.com
MIS Ntwk Assoc Mtg Dates:
Feb 22nd - Tues Reg Mtg - 6 pm - Berman Larson Kane Offices, Paramus - DO NOT use GPS for directions - Bring 15 copies of your resume
Mar 29th - Tues Dinner Mtg - Recruiter Night Out - Moderator - Bob Larson Berman Larson Kane
|
No comments:
Post a Comment