Data Architecture Metadata Management OLTP Data Modelling ERwin Specialist (Job   Requirement id 43277 Job title Specialist Job location in ROSEVILL, CA Skills required PL/SQL, T SQL, MS SQL, Data Architecture Metadata Management OL Open Date 12-Feb-2015 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Specialist: PL/SQL, T SQL, MS SQL, Data Architecture Metadata Management OL Works collaboratively with the Application team, including architects, developers and testers, to ensure project success. Collaborates with the Application Project manager to plan and manage the project activities and deliverables. Coaches less experienced team members. Participates in discussion with customers and peers to collect and analyze data requirements. Participates in solution development for projects. Participates in client meetings and presentations. Assists Data Architect or Team Leader to develop solutions by documenting components of the solution, defining deliverables and preparing estimates. Plans and Leads database development and maintenance of databases including: Design database environments and databases Design, develop, modify, test, release/deploy and maintain database objects Design database objects and supervise develop, modify, test, release/deploy and maintain by other DBAs Design, develop, modify, test, release/deploy and maintain database security and audit solutions Design, develop, modify, test, release/deploy and maintain database recovery solutions Manage database performance, capacity and availability Utilizing best practices, work plans, checklists and defined processes. Proactively supports application teams. Performs SQL tuning. Provides advice on application data issues. Participates in project technical reviews. Leads work product reviews. Develops and maintains database support documentation. Designs database monitoring solutions and assists others in monitoring and proactively anticipating or identifying issues. Takes ownership of complex database incidents and problems and provides resolutions in a timely manner. Engages SMEs or vendors to provide assistance to resolve more complex incidents as required. Produce and maintain logical and physical data models for databases and projects. Participates in the development and maintenance of enterprise data models for less complex enterprises. Participates in formal Data Modeling Reviews. May lead reviews of simple data models. Assist business and technical personnel in data analysis activities including using SQL queries. Performs Model Conversion (data mapping) to produce a data dictionary and data mapping matrix between the external software and the internal database for business function replacement. Performs in data quality analysis / data profiling, to produce a data quality assessment (and baseline). Requirements * 5+ yeas of recent experience with PL/SQL development with Oracle 10g or 11g. Must be able to manage schemas, create DDLs, optimize and develop complex queries and execute deployments to various environments. * 3 + years of experience with TSQL development in MS SQL Server environment * 3+ years of progressive experience in data architecture, logical and physical relational database modeling and design, metadata management, operational database * Experience with Oracle Database Administration to assist with routine DBA activities including RMAN, monitoring and maintenance. * Experience with all components of relational database design in a high-availability, transactional (OLTP) environment * Experience with working in UNIX environment and developing shell scripts * Work as part of a team to provide 24x7 support * Interface with Oracle technical support * Establish standards and best practices for SQL * Exceptional interpersonal skills, including teamwork, facilitation, and negotiation * Excellent analytical and technical skills * Excellent written and verbal communications skills * Excellent planning and organizational skills * Excellent data modeling and meta data management skills ERWin exper   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 43277 while calling.   Other jobs in CA: Anaheim (4), Brea (3), Brisbane (2), Carlsbad (3), Concord (1), Culver City (1), Cupertino (5), Downtown Los Angeles (3), El Monte (3), El Segundo (1), Foothill Ranch (2), Irvine (1), La Jolla (2), Lake Forest (1), Larkspur Landing (1), Long Island (1), Los Angeles (27), Newport (1), Newport Beach (3), Orange (2), Orange County (7), Pasadena (1), Poway (5), Rancho Cordova (1), Redwood City (3), Sacrament (1), Sacramento (19), San Diego (87), San Francisco (24), San Jose (4), Simi Valley (1), South San Francisco (1), Westlake Village (2),    PL/SQL job openings in other states Jobs List VDOT Programmer Analyst 4/Datawarehouse (747993) Create date: 23-Oct-2024 **Hybrid Max Submittals by Vendor : 2 Start date : 11/18/2024 End Date : 06/30/2025 Submission deadline : 10/28/2024 Client Info : VDOT Description : ------------------------------------------------------ Data architect to provide data intake, data governance, data transfor.... (This job is for - datawarehouseSQL Jobs in VA Richmond Analyst - (in Richmond, VA)) NC FAST Senior Data Engineer (743008) Create date: 30-Jul-2024 Hybrid No of Submissions : 1 start date :08/12/2024 End date :08/08/2025 submission deadline : 08/06/2024 client info : NCDHHS-NCFAST Note: * Agency Interview Type: Either Webcam Interview or In Person * DHHS-ITD requires the services of Specialists in the ro.... (This job is for - job Jobs in NC Durham Engineer - (in Durham, NC)) GDOT Esri ArcGIS Developer 2 (740541) Create date: 26-Jul-2024 * Hybrid No of Submissions : 2 Start date : 08/26/2024 End Date : 06/30/2025 Submission deadline : 08/09/2024 Client Info : GDOT - IT App Note: * Agency Interview Type : Either Web Cam or In Person Description : The Georgia Dept. of Transportation (GD.... (This job is for - job Jobs in GA Atlanta Developer - (in Atlanta, GA)) GDOT Esri ArcGIS Developer 3 (740540) Create date: 26-Jul-2024 No of Submissions :2 Start date :08/26/2024 End Date :06/30/2025 Submission deadline :08/09/2024 Client Info :GDOT - IT App Note: * Agency Interview Type:Either Web Cam or In Person * Hybrid Description : The Georgia Dept. of Transportation (GDOT) is seeki.... (This job is for - job Jobs in GA Atlanta Developer - (in Atlanta, GA)) NC FAST Data Engineer (735339) Create date: 28-May-2024 Hybrid No of Submissions : 1 start date :06/17/2024 End date :06/20/2025 submission deadline : 06/03/2024 client info : NCDHHS-NCFAST Description : The Department of Health and Human Services (DHHS) requires the a.... (This job is for - Oracle Jobs in NC Durham Engineer - (in Durham, NC))    PL/SQL job openings in CA Jobs List IT - Software Engineer/27/TEC131 - 69599 Create date: 23-Nov-2020 Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : Primary Responsibilities: Maintenance of an Oracle e-Business Suite Application (R12). This includes system analysis, design, development, & deployment of Oracle EBS components, with the foc.... (This job is for - Oracle Jobs in CA CYPRESS Engineer - (in CYPRESS, CA)) Java Developer - 63680 Create date: 29-May-2020 Note: * Candidate must be your W2 Employee. Job Description : Technology sets IT strategy; enhances the design, development, and operations of our systems; optimizes the Wells Fargo infrastructure footprint; provides information security; and enables continuous banking access through in-store, online, ATM, and o.... (This job is for - job Jobs in CA SanFrancisco Developer - (in San Francisco, CA)) Informatica Developer Create date: 02-Dec-2019 Description: Summary: Develops, supports and maintains moderately complex application development projects according to appropriate specifications. Assists in analyzing and writing specifications. Essential Job Functions Codes, tests, documents and implements programs according to the specifications provided. <.... (This job is for - ETL Jobs in CA Pleasanton Developer - (in Pleasanton, CA)) Oracle PLSQL Engineer - 55577 Create date: 13-Nov-2019 client info:Sony Pictures Candidate must be our W2 Employee Job Description: The Lead Engineer for a Legacy Financial Application will be overseeing a team of full stack engineers working closely with Oracle and PLSQL Stored Procedures to keep the lights on for this application. This individual will be responsible .... (This job is for - Engineering Oracle Jobs in CA CulverCity Engineer - (in Culver City, CA)) Oracle Database Administrator - 50185 Create date: 23-Jul-2019 Candidate must be our W2 Employee We should submit only GC, GC EAD, L2 EAD, H4 EAD and Citizens. Description: Must have deep understanding of Oracles Engineered Systems platforms such as Oracle Database Appliance, ZFS Storage Appliance Deep knowledge in several of the following areas: Databas.... (This job is for - OracleDBA Jobs in CA LosAngeles Administrator - (in Los Angeles, CA)) (Specialist: PL/SQL, T SQL, MS SQL, Data Architecture Metadata Management OL in ROSEVILL, CA)

Featured Jobs Z/Os Specialist (Jobs in Raleigh, North Carolina) Problem Analyst (Jobs in Chelsea, Massachusetts) SQL PostgreSQL Analyst (Jobs in Atlanta, Georgia) PEOPLESOFT Customer Analyst (Jobs in Atlanta, Georgia) TCL Consultant (Jobs in Jackson, Mississippi) Email Supervision Administrator (Jobs in Nashville, Tennessee) LMS MS Developer (Jobs in Durham, North Carolina) Communication Process Manager (Jobs in Lincoln, Nebraska) Healthcare Specialist (Jobs in Raleigh, North Carolina) Oracle Architect (Jobs in Madison, Wisconsin)