Database Architect

Eset San Diego , CA 92140

Posted 4 weeks ago

Job posting title

Database Architect

Job summary

The Database Architect/Administrator is responsible for designing, developing, testing, architecting and implementing various SQL related data and data warehouse projects. This position requires excellent written and verbal communication skills. The DBA's role is to set the technology strategy of the data warehouse, design enhancements and implement data driven processes across the organization, while ensuring high levels of data availability and integrity

Job description

In this role, the Database Architect/Administrator is responsible for the following: Define data warehouse system, strategy, reports, OLAP cube and application requirements by consulting with system users and department heads about the types of information needed Determine how data should be organized, who should have access to different data and how it should be displayed Design and develop data models and database architecture. Act as an internal consultant to answering challenging data questions from disparate data sources Proactively monitor the data subsystems for application performance and availability and take corrective action where needed Write, update, and maintain data processes to handle specific jobs such as tracking, reporting, and ETL Design, develop and document physical data models, structures, OLAP cubes and database architecture Develop and enhance stored procedures, triggers, functions, views Meet with internal clients to gather requirements to implement new application data models Develop scripts to automate administration and management of the environment Database administration support including backups, recovery, security, tuning and monitoring Resolving database production issues, code troubleshooting Create technical specifications and support documentation Provide technical guidance to application development team members for working with the data model Provide regular status updates on projects, including progress updates and identification of issues associated with assigned tasks Research and introduce new database technologies Proactively plan for data contingencies, and design, recommend, implement, and manage changes under the guidance of Director of Finance Operations Recommend long-term data solutions in accordance with an understanding of the methodology, architecture, business needs, and strategic success of the organization Lead and facilitate the development and implementation of data solutions across technology and business areas. Assist management with the selection of a technology solution that is in alignment with enterprise-wide architecture/technology, creation of cost and time estimates, task identification, and sequencing of project events Other responsibilities as necessary (Maintain existing SSIS packages, Maintain SSRS reports or Create SSIS packages to load, transform and process data) Requirements and

BS Degree in Computer Science or Engineering 8-10 years database development and administration using Microsoft SQL Server (2008 R2, 2014, 2016) 5+ years experience architecting, designing and developing an enterprise data warehouse including data modeling, data analysis, cubes and reporting 5+ years experience with physical layer (storage, allocations, virtualization, partitioning) Hands on experience managing data, writing star schemas and developing ETL processes Knowledge of MS SQL system stored procedure and tables In depth T-SQL knowledge is required, including advanced tuning skills Must have knowledge in Business Intelligence Platform (SAP, Qlikview/Sense, SAS, SSAS)

Job requisition

JR-01030 Database Architect (Open)

Primary location

San Diego

Additional locations

Time type

Full time

Number of openings

icon no score

See how you match
to the job

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
Sr Database Devops Manager

Teradata Corporation

Posted 3 days ago

VIEW JOBS 4/22/2019 12:00:00 AM 2019-07-21T00:00 With all the investments made in analytics, it's time to stop buying into partial solutions that overpromise and underdeliver. It's time to invest in answers. Only Teradata leverages all of the data, all of the time, so that customers can analyze anything, deploy anywhere, and deliver analytics that matter most to them. And we do it at scale, on-premises, in the Cloud, or anywhere in between. We call this Pervasive Data Intelligence. It's the answer to the complexity, cost, and inadequacy of today's analytics. And it's the way Teradata transforms how businesses work and people live through the power of data throughout the world. Join us and help create the era of Pervasive Data Intelligence. Sr. Database DevOps Manager Location: San Diego, CA Are you a problem solver? Does the prospect of solving the world's toughest problems with Data and Analytics in the Cloud excite you? Would you like to work side-by-side with the brightest analytical and engineering minds in the industry to help organizations innovate and solve their Analytics needs with Cloud based solutions? If yes, you belong here at Teradata IntelliCloud. Teradata is an enterprise software company that provides cutting-edge Big Data Analytics and Discovery technology helping Fortune 1000 organizations be efficient and innovative by uncovering new opportunities to grow revenues and cut costs. From large financial services organizations to global communication services providers to healthcare providers to auto manufacturers to online gaming, the largest organizations globally are using our Big Data Analytics Platform to make sense of petabyte scale multi-structured data to better understand customer behaviors, anticipate customer needs and develop better products and solutions. We're looking for a Sr. Database DevOps Manager to work in our Teradata IntelliCloud group. We are looking for candidates who are passionate about automating and leveraging DevOps principles to deliver an Analytics Platform as a Service and owning that service from end to end. You will be working in highly distributed and dynamic Hybrid Cloud environment and that enables fast paced development and deployments while achieving high availability. Along with a systemic discipline we are also looking for candidates who are open and passionate about exploring new technologies to improve our overall environment. Responsibilities * Promote and establish DevOps culture and practices. * Automation is in your DNA. * Metric driven and focused on continual improvement. * Comfortable collaborating and working with distributed teams. * Help design and operate highly available as a Service platform in large distributed and virtual environments. * Manage small to medium-sized projects and/or portions of large projects and assist in resolving issues and planning for new services and connectivity. * Develop, implement, and support highly available platforms on which to deploy Teradata Database systems and supporting ecosystems in a multi-tenant cloud environment. * Automate the deployment, configuration, and supportability of the Teradata Database and supporting ecosystem. * Collaborate with product teams to continually improve and optimize the Teradata products for cloud environments. * Strong expertise in leveraging a wide variety of open source technologies. * Drive problem resolution to root cause and take initiative in identifying and fixing broken processes. * Perform proactive analysis to prevent exposure to known software issues. Minimum Requirements * Bachelor's Degree in Engineering, Computer Science, or equivalent. * 5+ years' relevant management experience. * 5+ years' experience of Teradata Database and supporting ecosystem. * 7+ years' experience designing, deploying, and supporting large scale, customer facing database systems. * Working knowledge of Linux and Windows operating systems. * Fundamental knowledge of compute, storage, and networking. * Working knowledge of virtualization technologies, such as VMware and Containers / Kubernetes. * Working knowledge of Configuration Management tools such as Ansible, Terraforms, Chef, Puppet. * Working knowledge of Build and Integration systems, such as Jenkins, TeamCity, Maven, Ant. * Working knowledge of Agile frameworks. * Strong quantitative and qualitative reasoning skills. * Strong interpersonal, presentation and communication skills. * Strong organizational skills and detail oriented. Preferred Requirements * Experience deploying and supporting database systems in a multi-tenant cloud environment. * Experience Designing, deploying, and supporting a Service from end to end. * Advanced Knowledge of Teradata Database and supporting ecosystem. * Understanding of security best practices and regulations. * Working knowledge of quality and test systems, such as Selenium, Casper, Cypress. * Working knowledge of Hadoop. * Familiarity of 3rd party ecosystem applications, such as Microstrategy, Protegrity, Informatica. Teradata Corporation San Diego CA

Database Architect