Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Sr. Database Architect/Engineer

Expired Job

Themesoft Inc Secaucus , NJ 07094

Posted 4 months ago

Job Title: Sr. Database Architect/Engineer
Location: West Norristown, PA or Secaucus, NJ
Duration: Contract

Job Description:

Overall 10+ years working in IT, as Database/DW professional
Played pivotal roles as Lead engineer and support staff across various database technologies
Knowledgeable in database technologies Oracle, MS SQL Server, MySQL, DB2, cache etc.
Exposure to commercial platform Database technologies from providers such as Oracle (Exadata), Cloud Platform like ExaCloud, Netezza etc.
Has experience in DevOps tools to enable DBaaS (Database As a Service)
Must have experience with Oracle 11g/12c, MS SQL 2012/14/16, Oracle RAC, Oracle ASO, Partitioning, ASM, OEM, AlwaysOn etc.
Must have some understanding of data integration technologies and methodologies (API driven, ETL tools like Data Stage, Golden gate, Oracle Data Integrator etc.)
Be very comfortable with Agile methodologies in order to be able to arrive at difficult engineering decisions quickly
Must have had experience creating solutions or solution concepts and defending these with technology councils / architect groups
Worked in projects to integrate enterprise data with high volume and velocity 2nd or 3rd party data from other sources such as Social channels or 3rd party sources
Should have experience of working in Healthcare Industry (or similar) to understand the data security requirements like PCI/HIPPA/NIST/SOX etc.

Role Details
Leverage technical and business acumen in an effort to provide superior development and production support for our Database environments. In addition, will drive and participate in efforts to ensure platform stability in an effort to maximize performance of our environments. Partner with application owners/teams to understand application and business needs and SLO. Participate on LOE (Level of Estimate) design process to provide appropriate solution and level of estimates for execution for database solutions
The primary focus will be on choosing optimal database (Oracle, MS SQL, MySQL, DB2, Cache etc.) solution to use based on business requirements, then designing, maintaining/supporting, implementing, monitoring and optimizing them. You will also be responsible for integrating them with the architecture used across the company.
Design strategies for enterprise database systems and set standards for operations, programming, scalability, reliability and security. Design and construct large relational databases. Integrate new systems with existing warehouse structure and refine system performance and functionality.
Oversee the work being done by other Database engineers working on the team, coordinating team activities with other teams and product groups, maintaining Database architecture standards.
Contributes in leading and directing database engineering resources to ensure timely and quality delivery of services.
Identify, evaluate and recommend hardware or software technologies to achieve desired database performance. Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
Work with Customers, end users and development partners to define and assess technical requirements and understand the current state of technology to define opportunities that create business value.
Work with other architects to define the technical architecture structure to ensure that the products and components work together to meet the objectives and performance goals as required by the customer.
Provide ownership of all database objects in DB schema (tables, partitions, indexes, views, procedures)
Using database expertise and leadership experience to identify and drive improvement efforts related to our database portfolio
Participate in Change Advisory Board and provide guidance governance on Database changes. Performing problem resolution for complex issues including root cause analysis, and outlining resolution options
Providing full-lifecycle support for complex database environments
Consulting with development teams to advise on physical database architecture and application use
Providing off-hours support, when required, for critical production issues.
Ensuring system documentation is complete per Quest standards
Automate Infrastructure components leveraging understanding of scripting, coding and automation using one or more of the following: PowerShell, Microsoft DSC, Chef, Puppet, Ruby, Terraform, OEM or others
Have familiarity with SDLC models and best practices and use of source control and testing tools such as GIT, Jenkins, Chef, Terraform, RAT etc.
Leverage and learn open source operating systems and tools
Bring a technology agnostic and open perspective in technical recommendations and decision making, being able to articulate and advocate for best technical solution that meets big picture business needs
Fully understand the capabilities and limitations of the technical environments.
Work with the third party support team (on-shore and off-shore) and application support teams to educate and guide them for steady-state supporting database infrastructure related technologies.

Soft Skills:
Very good English language skills (verbal & written).
Leadership skills
Achievement orientation, creative thinking and enthusiasm
Open-minded, strong in communication
Very good presentation skills
Strong organizational skills
Self-motivated, ability to pick up things quickly

Oracle,MySQL,DB2,MS SQL Server,Database/DW,Oracle (Exadata),Cloud Platform like ExaCloud,Netezza,Oracle 11g/12c,MS SQL 2012/14/16,Oracle RAC
Long Term

upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Oracle Senior Engineer


Posted 4 days ago

VIEW JOBS 1/13/2019 12:00:00 AM 2019-04-13T00:00 Oracle Senior EngineerReq I D RL-0113 Rate Primary Skills Description The Oracle Senior Engineer is accountable for proactively and holistically leading or supporting EA activities that create deliverables that guide the direction and drive targeted business outcomes. Oracle Senior Engineer role is focused on Architect, defining and implementing Oracle Cloud solutions addressing business requirements and priorities for the Oracle Domain & Fusion Cloud applications process area. Oracle Senior Engineer provides the leadership around analysis and design tasks required for the architecture landscape. They work towards the Architecture spike to assess & gather artifacts towards the current state architecture and propose future state architecture for the application. Oracle Senior Engineer will ensure application stability to Scholastic business towards related business system applications and prepare guidelines to support Scholastic events without causing any impact to revenue. In the context of a project, the Oracle Senior Engineer reports into Director, Oracle Fusion Cloud Applications & Business Systems Architecture and partners closely with the Project Manager to ensure requirements are clearly understood, and translates these requirements into necessary application and technology components that meet the business need. The Oracle Senior Engineer is responsible for ensuring that their solutions meet both the functional and technical requirements outlined for the project. The candidate must have strong communication skills, full life-cycle experience as well as excellent skills in architecture and designing robust yet pragmatic solutions using Oracle Fusion Cloud SaaS/PaaS software. Scope of Activities * Work with Enterprise Architect peers (e.g., enterprise, business, information and solutions architects) to analyze and derive the technology architecture future state. * Understand technology trends and the practical application of existing, new and emerging technologies to enable new and evolving business and operating models. * Lead the analysis of the current technology environment to detect critical deficiencies and recommend solutions for improvement. * Coach, mentor and collaborate with technical subject matter experts and EA peers to develop technology architecture that enables and drives new business capabilities and operating models. * Assist with designing the governance and technology standards associated with ensuring enterprise technology architecture compliance. * Oversee and facilitate the research, evaluation, and selection of hardware and software technology and product standards, as well as the design of standard configurations. * Document necessary enterprise technology architecture artifacts, design and analysis work, possibly including project postmortem documentation and metric collection. * Collaborate with business constituents, other EA team members, project teams and staff in various IT functional areas as needed to fulfill the responsibilities described above. * Perform Architecture assessment analysis and provide High Level Design for requested changes. * Provide application/technology expertise within the assigned function including conducting In-depth quality reviews on design and testing. * Complete understanding of the SDLC and Change Management process. * Excellent interpersonal skills with the ability to meet common objectives through teamwork. * Excellent Problem Analysis, Customization design, Integration Testing, and System Testing. * Ability to meet and discuss with functional team users to identify opportunities for business improvement and to provide optimized solutions. * Primary technology liaison to the Business groups regarding application systems architecture landscape. * Coordinate cross functionally within IT teams to deliver Strategic projects. * Troubleshoot and diagnose complex business problems and recommend solutions. * Keep abreast of latest tools / applications / techniques in the assigned area. * Accomplish effort estimation of scope, provide Architecture guidelines & solution designs and recommend best approach for the business requirement. * Have In-depth application expertise for Oracle Cloud Order Management & Supply Chain and Other Business systems. * Review, recommend and influence 3rd party software solutions and adherence to technology standards. * Analyze business needs to help ensure Oracle solution meets the business objectives by combining industry best practices, product knowledge, and business acumen. * Analyze, review, and refactor system architecture boundaries to increase efficiency or to adapt to new program and technology requirements. * Participate in requirement gathering and provide high level and detailed Architecture/Solution Designs. * Understand governance and policy concepts. Use the experience to create processes and policies and establish governance infrastructures. * Effectively resolve problems and roadblocks as they occur, consistently following through on details while driving innovation as well as issue resolution. * Collaborate with Program Managers, Developers, Testers and Production Support teams to implement innovative technical solutions via iterative approach reducing time to delivery. * Mentor development and support teams by guiding with SOA development standards/guidelines and insights into domain architecture. * Works towards application stability and restoration of service and prevents problems and roadblocks. * Provide architectural leadership on adoption of open source applications, selection of packaged and SaaS applications, and integration of applications with other systems and the overall enterprise. * Build and maintain the Current state, Interim state and Future state architecture views for the domain and enterprise systems - SOA architectures (Hybrid & SaaS approach). * Effectively collaborates across all delivery teams including Customer, Oracle team, System Integrators, Third Parties. * Responsible for assessing, defining and championing the IT architecture strategies, principles, policies and standards in alignment with the IT strategy and governing their use. * Responsible for the research, evaluation, and selection of application, technology, and infrastructure standards. * Leads the analysis of the technology environment to detect critical deficiencies and recommend solutions for improvement. * Creates project and technology roadmaps and define migration plans to mitigate the gaps between the current and future state. * Develops standards for the specific function or technology domain and defines design patterns and configurations that can be reused as building blocks for other solutions. * Leads and facilitates the creation of governing principles to manage change and guide solution decisions for the enterprise. * Collaborates with IT stakeholders to apply IT strategy to architecture future state architecture and develops roadmaps to realize future state. Collaborates with project teams to understand requested capabilities and recommends the right set of technologies to meet the needs. * Provides infrastructure capacity recommendations for new applications and systems. Credentials and Experience * Bachelor's degree in Computer science, system analysis or a related study, or equivalent experience * Minimum of five years of Architecture, Solutions design & Implementation experience in IT, with a deep knowledge in a minimum of two of the following technical disciplines: Solutions design, Application configuration, Application Integrations, Middleware Tech stack (On-Premise & Cloud), Servers and storage, Database management, and Operations. Skills * Experience in Oracle SaaS/PaaS Cloud applications (Financials, SCM, GOP, OTC, DOO (Distributed Order Orchestration), PPM/EPM Suite and Architect the Process/Integration touch points using Oracle Fusion Middleware Techstack using Oracle API's and FBDI). * Experience in SaaS/PaaS integrations into Oracle Fusion Cloud applications. * Proficient in Functional concepts and understanding of Oracle Fusion Cloud SaaS Financials/SCM/PPM/EPM applications. * Experience in processing EDI Transactions (using CMK & JusTransform) to and from our Suppliers, Customers, the integration of supply chain data to other applications and all SCM reporting needs. * Experience with Oracle Fusion Middleware Architecture and supporting technologies, defining services, establishing the service usage patterns within the enterprise including orchestration, composition, messaging patterns. * Experience with modern Middleware technology based architectures and supporting their implementation in a large technology eco-system. * Expertise in Integration technologies and coordinating work effort using Oracle Fusion Middleware (On-Premise & PaaS Techstack) Web Services. * Architect, design, and implement Middleware solutions to accommodate cross domain integrations. * Experience in providing Architectural solutions for a Hybrid Integration approach using Oracle Fusion Cloud SaaS Applications and On-Premise Applications. * Conduct architecture assessments and define solutions to produce a detailed technical design document for custom development and integration requirements. * Experience with system development life cycle methodologies (such as True Cloud, Agile & Waterfall software development…) * Provide integration solutions for new systems / enhancements in accordance with agreed architectural designs and provides development guidance to technical team. * Expertise with leveraging Oracle Fusion Cloud delivered Web Services/API's. * Ability to understand requirements and efficiently review the Functional and Technical documents. Ability to communicate the architecture & design changes as needed. * Experience with Oracle Fusion Cloud Security administrative functions - RBAC (Role Based Access Control). Competencies * Ability to understand the long-term ("big picture") and short-term perspectives of situations and how they relate to achieving targeted business outcomes * Ability to estimate the financial impact of technology alternatives * Ability to coordinate with cross domain team architects to discuss dependencies * Ability to apply multiple Technology solutions to enable future-state business capabilities that, in turn, drive targeted business outcomes * Ability to quickly comprehend the functions and capabilities of existing, new and emerging technologies that enable and drive new business designs and models * Demonstrated ability to work well with others and be respected as a leader. Characteristics * Organizationally savvy, with understanding of the political climate of the enterprise and how to navigate obstacles and politics. * Ability to balance the long-term (big picture) and short-term implications of individual decisions * Motivated and driven by achieving long-term business outcomes * Independent contributor, Team player and collaborative work strengths. Varite Secaucus NJ

Sr. Database Architect/Engineer

Expired Job

Themesoft Inc