Oracle Database Architect - Georgia IT Inc.
Alpharetta, GA
About the Job
Job Title: Oracle Database Architect
Location: Merrimack, NH Smithfield, RI Boston, MA Westlake, TX
Job Type: Contract 6 Months (Probably going permanent)
Work Status: US Citizen/Green Card/GC-EAD
Rate: DOE (W2 only)
This role will be a longer-term (starts 6-months but likely to be converted to perm.) contract role that can be based in either Westlake, TX, Smithfield, RI, Boston, MA, or Merrimack, NH. Ideally we'd like to see local candidates for this but we're open to candidates if they can confirm that they will relocate for this position.
Must Have's:
-Oracle 12c
-Be more than a DBA/Architect, must be an Architect.
-Experience with Cloud technologies
-Someone who has Managed/Architected Large databases
Big Pluses:
-Big Data Experience
Overview:
This Fidelity group was established in 2008 to provide integrated technology solutions to enterprise wide business functions including Corporate Finance & Accounting, Human Resources, Enterprise Communications, Records Management, Compliance, Legal, Risk and Security. Information Management and Analytics are at the center of IT Strategy to enable business capabilities delivered by this group for Managerial Finance, Compliance, Fraud Detection, and Human Capital Management
This role will be part of the Data Architecture group and works in collaboration with Database Operation and Architecture Groups. This role reports to Director/Head of Data Architecture and will have a dotted line relationship to the Director of Database Operations
Responsibilities:
Define database physical structure and functional capabilities, security, high availability, back-up, and recovery specifications
Identify database consolidation opportunity and help define roadmap, develop approach & implementation plan in partnership with Data Architecture, Database Services & Application teams.
Lead database consolidation and environment optimization efforts and guide DBA team on these efforts
Recommend end to end database hosting solution for all environments. Lead database capacity planning and maintain DB hosting/utilization related metrics
Define Database Performance best practices, Partitioning and Indexing strategy
Define database design standards and offer consulting to app. Dev teams on design for performance
Define Database Encryption, Masking and Information lifecycle management solutions related to privacy, storage, compression and archiving
Design DBaaS Database-as-a-Service) and optimized database architecture for on-demand scale and automated provisioning
Keep abreast of industry knowledge, combined with comprehensive, practical experience and knowledge in the Data Management and strategy domain
Assist in query and system tuning and monitors performance bottlenecks as needed
Develop/maintain relationships with DB platform vendors and stays current with of roadmap and solutions
Conducts PoC on new DB platforms, technology and tools in collaboration with Data/Product/Infrastructure Architecture and Database Services Groups
Enable DevOps (CI/CD) through common database deployment, automation and lifecycle management
Work with Data Modelers/Architects to define physical data models and database design for a given application/projects
Support Product Architecture, Infrastructure Architecture and Application teams on actionable Database Architecture, Design and Development Practices
Partner with other Fidelity business technology teams championing priorities and potential reuse through personal influence and persuasion
Skills/Knowledge:
10+ years of demonstrated experience in database administration Performance design/tuning, backup, recovery, high availability and security
Minimum 4-5 years' experience in Database Architecture and design.
Hands on experience with Oracle database platform and Oracle Enterprise Manager
Expertise in automated storage management and grid management
Expert in system and sql tuning. Quick in trouble shooting performance related production issues
Relevant experience in doing capacity planning
Some hands on experience on any appliance like Oracle Exadata, Netezza or Teradata
Working knowledge of Hadoop/NoSQL or other emerging Big Data Platforms
Demonstrated capability developing, maintaining relationship with DB vendors with respect to current product offerings, future roadmap and hardware solutions
Capable of providing thought leadership and abstract thinking
The ability to quickly understand and incorporate new technologies
Experience using Fidelity preferred technologies: Oracle DB, Informatica, PL/SQL
Education/Skills:
Minimum 12 years of relevant IT experience
Bachelor degree in Computer Science or Information Technology
Certification: Oracle certified : DBA/Professional/Master DBA
Extra credit for Cloudera Certification
Location: Merrimack, NH Smithfield, RI Boston, MA Westlake, TX
Job Type: Contract 6 Months (Probably going permanent)
Work Status: US Citizen/Green Card/GC-EAD
Rate: DOE (W2 only)
This role will be a longer-term (starts 6-months but likely to be converted to perm.) contract role that can be based in either Westlake, TX, Smithfield, RI, Boston, MA, or Merrimack, NH. Ideally we'd like to see local candidates for this but we're open to candidates if they can confirm that they will relocate for this position.
Must Have's:
-Oracle 12c
-Be more than a DBA/Architect, must be an Architect.
-Experience with Cloud technologies
-Someone who has Managed/Architected Large databases
Big Pluses:
-Big Data Experience
Overview:
This Fidelity group was established in 2008 to provide integrated technology solutions to enterprise wide business functions including Corporate Finance & Accounting, Human Resources, Enterprise Communications, Records Management, Compliance, Legal, Risk and Security. Information Management and Analytics are at the center of IT Strategy to enable business capabilities delivered by this group for Managerial Finance, Compliance, Fraud Detection, and Human Capital Management
This role will be part of the Data Architecture group and works in collaboration with Database Operation and Architecture Groups. This role reports to Director/Head of Data Architecture and will have a dotted line relationship to the Director of Database Operations
Responsibilities:
Define database physical structure and functional capabilities, security, high availability, back-up, and recovery specifications
Identify database consolidation opportunity and help define roadmap, develop approach & implementation plan in partnership with Data Architecture, Database Services & Application teams.
Lead database consolidation and environment optimization efforts and guide DBA team on these efforts
Recommend end to end database hosting solution for all environments. Lead database capacity planning and maintain DB hosting/utilization related metrics
Define Database Performance best practices, Partitioning and Indexing strategy
Define database design standards and offer consulting to app. Dev teams on design for performance
Define Database Encryption, Masking and Information lifecycle management solutions related to privacy, storage, compression and archiving
Design DBaaS Database-as-a-Service) and optimized database architecture for on-demand scale and automated provisioning
Keep abreast of industry knowledge, combined with comprehensive, practical experience and knowledge in the Data Management and strategy domain
Assist in query and system tuning and monitors performance bottlenecks as needed
Develop/maintain relationships with DB platform vendors and stays current with of roadmap and solutions
Conducts PoC on new DB platforms, technology and tools in collaboration with Data/Product/Infrastructure Architecture and Database Services Groups
Enable DevOps (CI/CD) through common database deployment, automation and lifecycle management
Work with Data Modelers/Architects to define physical data models and database design for a given application/projects
Support Product Architecture, Infrastructure Architecture and Application teams on actionable Database Architecture, Design and Development Practices
Partner with other Fidelity business technology teams championing priorities and potential reuse through personal influence and persuasion
Skills/Knowledge:
10+ years of demonstrated experience in database administration Performance design/tuning, backup, recovery, high availability and security
Minimum 4-5 years' experience in Database Architecture and design.
Hands on experience with Oracle database platform and Oracle Enterprise Manager
Expertise in automated storage management and grid management
Expert in system and sql tuning. Quick in trouble shooting performance related production issues
Relevant experience in doing capacity planning
Some hands on experience on any appliance like Oracle Exadata, Netezza or Teradata
Working knowledge of Hadoop/NoSQL or other emerging Big Data Platforms
Demonstrated capability developing, maintaining relationship with DB vendors with respect to current product offerings, future roadmap and hardware solutions
Capable of providing thought leadership and abstract thinking
The ability to quickly understand and incorporate new technologies
Experience using Fidelity preferred technologies: Oracle DB, Informatica, PL/SQL
Education/Skills:
Minimum 12 years of relevant IT experience
Bachelor degree in Computer Science or Information Technology
Certification: Oracle certified : DBA/Professional/Master DBA
Extra credit for Cloudera Certification
Source : Georgia IT Inc.