Troubleshooting And Debugging Performance Optimization VB Scripting SQL Plus MS Of   Requirement id 16474 Job title Analyst Job location in Pasadena, CA Skills required SSRS And SSIS, SQL Server Administration, Database Development, Troubleshooting And Debugging Performanc Open Date 21-Nov-2013 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Analyst: SSRS And SSIS, SQL Server Administration, Database Development, Troubleshooting And Debugging Performanc This is an urgent position. Please submit YOUR H1B candidates only. NO layers. Position: DBA ETL Analyst Location: Pasadena, CA Duration: 1 year plus Interview: Phone/Skype (in-person not required) Job Description: Position Summary: This is a DBA ETL Analyst with the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with databases to come up with strategic solutions to recurring problems. This SQL DBA role requires a service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes. Position Requirements: We are looking for a person who: SSIS, SSRS Required Pragmatic Works experience requested. Has 3+ years of experience in database development and support in MS SQL Server environments. Strong experience in Database Administration in SQL Server Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention. Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication. Experience in implementing operational automation. Knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively. Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SSIS, SSRS, SAC, SSCM, PerfMon, DMVs, system sprocs) SQL Development ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints ) Solid acquaintance with windows server, security delegation, SPNs, storage components. Documentation skills for processes and procedures SQL Database Operational support to tech users Preferred candidates would also meet the following criteria: Participates in the design, modeling, development and support of Database Management Systems (DBMS). Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops and optimizes database schema design to meet system(s) requirements. Gathers, analyzes, and normalizes relevant information related to and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Create new stored procedures, functions and tables using T-SQL. Modify existing ones to meet requirements. Monitor or update existing processes daily, weekly and monthly. Extract and load data to database from various files such as tab-delimited or csv format. Work with clients to produce customized reports. Minimum 3-5 years experience in the real estate information industry Knowledge of 3rd party DBA tools and applications MCDBA /   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 16474 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), SSRS And SSIS job openings in Pasadena, CA Jobs List SSIS Developer - J-10-846-015 Create date: 21-Nov-2013 This is an urgent position. Please submit YOUR H1B candidates only. NO layers. Position: SSIS Developer Location: Pasadena, CA Duration: 1 year plus Interview: Phone/Skype Job Description: Administers new databases for Reload, handles creating/porting SQL tables/views/SSIS packages to integrate .... (This job is for - SQL Jobs in CA PASADENA Developer - (in Pasadena, CA))    SSRS And SSIS job openings in other states Jobs List SYSTEMS SOFTWARE PROGRAMMER - CONSULTANT - 10662-1 Create date: 08-Dec-2022 start date : JANUARY 18, 2023 End date : 1 YEAR from the start date submission deadline : 12/15/2022 client info : Department of Social Services Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? - Interview will be by phone and will be c.... (This job is for - SQL Server 2005 Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) SYSTEMS SOFTWARE PROGRAMMER -PROJECT LEAD - 9708-1 Create date: 29-Jan-2021 Start Date :02/22/2021 Submission Deadline :02/05/2021 Client Info : Department of Social Services Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? Interview will be by phone and will be conducted by a team of 3 – 5 developers and or Proj.... (This job is for - job Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) SYSTEMS SOFTWARE PROGRAMMER-PROJECT LEAD - 9616-1 Create date: 25-Nov-2020 Start Date :12/21/2020 Submission Deadline :12/02/2020 Client Info : Department of Social Services Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? Interview will be by phone and will be conducted by a team of 3 – 5 developers and or Proj.... (This job is for - job Jobs in SC COLUMBIA TeamLead - (in Columbia, SC)) ITS63 SQL Server Database Developer -SP Create date: 25-Feb-2020 Note: Email Submission Interview: Initial contact by phone, interview may be in person Note: Total number of positions sought: 1 Note: Maximum number of resumes per ITS63 Vendor: 3 Submission Deadline: 3/10/2020 4:00 PM EST Start Date: 3/20/2020 End Date: 6/30/2021 Client: Boston Police Departmen.... (This job is for - SSAS Jobs in MA Boston Developer - (in Boston, MA)) NJDHS-DDD DBMA4 (DBA) (616421) Create date: 14-Jan-2020 Note : It is anticipated that this contract will renew for a full year after the end of this State fiscal year. Start Date :02/03/2019 End Date :06/30/2020 Submission Deadline :1/17/2020 Description : This is a position for a Database Manager with the NJ Division of Develop.... (This job is for - Sql Server 2008 Jobs in NJ Trenton Consultant - (in Trenton, NJ))     (Analyst: SSRS And SSIS, SQL Server Administration, Database Development, Troubleshooting And Debugging Performanc in Pasadena, CA)

Featured Jobs IT Specialist (Jobs in Raleigh, North Carolina) IT Specialist (Jobs in Raleigh, North Carolina) Systems Specialist (Jobs in Raleigh, North Carolina) Functional Analyst (Jobs in Madison, Wisconsin) Biztalk PowerShell XSLT Developer (Jobs in Hartford, Connecticut) DFS DHCP Active Engineer (Jobs in Madison, Wisconsin) Team Developer (Jobs in Hartford, Connecticut) Quality Assurance Ms Consultant (Jobs in Durham, North Carolina) PMP PMI Agile Manager (Jobs in Richmond, Virginia) TSQL Specialist (Jobs in Raleigh, North Carolina)