If you're a recruiter or a hiring manager and would like to post a job on this site, please send a brief description (with 5-6 bullet points) to jobs@sql.la and our jobs coordinator will have it posted for you.
DISCLAIMER:
We provide these employment opportunities as a free service to our members and sponsors. We keep employment opportunities listed for about 90 days from the date posted, or until we are notified the position is no longer available. All information listed here is provided "as is" and SQL.LA is not responsible for its accuracy.
|
|
|
Job Title
|
SQL Server Developers
Location: Los Angeles
One position is available as a full time permanent employee and 2 positions open as Contract to Hire
Salary: $65-70K + 10% Bonus
Rate: $25-35/hr DOE C2C/1099
Duration: 3-6 months contract to hire
Candidate should be local to Los Angeles.
Company can transfer H1 Visas
|
|
Company
|
|
|
Date Posted
|
5/22/2013
|
|
Status
|
Open
|
|
Description
|
A $1 billion global healthcare company is looking for 3 SQL Developers (1 FTE and 2 C2H). The SQL/T-SQL Developer will primarily be responsible for extracting data in various formats from external sources and their internal clinical software systems and loading the data into SQL Server 2005 and 2008R2 databases running on Windows 2008. The SQL/T-SQL Developer will write SQL and T-SQL statements, queries, stored procedures and triggers to the SQL Server 2008 production databases. Furthermore, the SQL/T-SQL Developer will be responsible for pulling data from the production database in an on demand basis to create ad hoc reports.
For a more senior level position and if the candidate’s skill set allows, the SQL developer will be responsible for designing and developing reports utilizing SSRS (or Business Objects / BO) and performing analysis utilizing Microsoft’s SSAS.
Position reports to the Director of Data Warehouse and Business Intelligence
The company offers full benefits (PPO & HMO) including dental and vision, matching 403 (b), 2 weeks of vacation, paid sick/personal days, Short and Long Term Disability, Life Insurance, Employee Assistance Program, casual dress and flexible work hours that all start upon employment.
Requirements:
2-4+ years of T-SQL Development
SQL Server 2005 (experience with SQL Server 2008R2/2012 a plus)
Plus (NOT mandatory):
SSRS
SSAS
VBA
Any healthcare experience
HIPAA
Business Objects
*Company cannot perform corp to corp contracts for H1 Visa holders*
With your resume submittal, please answer the following questions:
Are you a U.S. citizen or green card or H1 Visa holder?
If a Visa holder, can your Visa be permanently transferred to my client for a full time permanent position? (This is not a C2C contract or contract to hire).
Do you prefer a permanent or contract position?
What is your current base salary or contract rate (W-2 or 1099)?
What salary range are you considering (please do not respond *negotiable* or similar).
Why did you leave your last 3 employers?
If you are not located in Southern California, when are you confirmed to be in Southern Ca?
If applicable, do you require relocation assistance?
|
|
Contact
|
Al Karaptian
Phone: 310.937.3388
|
|
Job Title
|
SSIS Developer, Sherman Oaks, CA
|
|
Company
|
|
|
Date Posted
|
5/10/13
|
|
Status
|
Open
|
|
Description
|
· Must have 10+ years of experience in SQL Development primarily in SSIS technology, with good knowledge in Database Administration and Data Modelling
· Design and develop data movements using SQL Server Integration Services, TSQL and Stored Procedures.
· Consult with the business to determine logical design for new business solutions
· Perform code reviews, analyze execution plans, and re-factor inefficient code
· Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes
· Work with Jr. SSIS developers and guide as needed
· Good knowledge of VBScript, .Net and C#
· Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements
· Collaborate with IT operations and testing organizations to ensure timely releases of projects and make sure database environments are sustainable
· Collaborate with IT operations to perform root cause analysis
· Support IT staff and business users in the development, usage and troubleshooting of database-driven applications
· Participate in special projects as needed and performs other duties as assigned.
· Ensure SDLC process is followed
Technical Skill Sets Required:
· 8+ years of SQL Server programming experience primarily SSIS technology, including Database Administration, and Data Modeling (OLTP/OLAP)
· Data warehouse / Data mart development experience
· SQL Server 2005 and SQL Server 2008R2
· Knowledge of physical database administration with SQL Server a plus.
· Excellent written and verbal communications skills required.
· Must be able to work in a fast paced team environment.
Education
· Bachelor’s Degree with over 10 years of experience or Master Degree with over 8 years of experience in database and data warehouse field.
|
|
Contact
|
Chris Hill
Sr. Technical Recruiter
Partners Consulting - a Calance Company
800/732-4680 x711
Chill@partnersconsulting.com
|
|
Job Title
|
Sr. BI Engineer / ETL Developer (Beverly Hills, CA) - Fulltime
|
|
Company
|
Rouse Asset Services
|
|
Date Posted
|
4/23/2013
|
|
Status
|
Open
|
|
Description
|
|
Rouse Asset Services is looking for a strong BI Engineer with a strong mind and will for architecting and implementing scalable and robust BI solutions from end to end. This role would be accountable for each sub-system in the Business Intelligence paradigm and would be a critical role in designing and implementing all sub-systems as well as the data exchanges between these sub-systems. This is a highly hands on role that would include both architectural considerations as well as the associated implementation tasks.
-* ‘Own’ the BI and Analytics processes and systems
· * Lead the architecture effort around designing scalable BI solutions including but not limited to:
· - Data Acquisition: source system (OLTP) to Warehouse ETL design, mapping, and implementation
· - Dimensional Model architecture, implementation, and re-factoring to meet changing business needs
· - Assist in the architecture and implementation of future hardware and Enterprise BI Systems to support appropriate scaling requirements
· - Architect and implement data workflow automation
· - Design and implement appropriate ETL processes in support of these components
· - Assist in the design and review of analytical models around the presentation layer
· - Assist in the design and review of Data Quality and cleansing efforts
· - Troubleshoot presentation layer bottlenecks through the entire system
· - Assist in the maintenance and troubleshooting of critical BI systems and components
|
|
|
Contact
|
Please follow the online application link below.
|
|
Scott Tate
Rouse Asset Services
Scott.Tate@rouseservices.com
|
|
Job Title
|
Sr. Production Database Administrator (El Segundo, CA) - Fulltime
|
|
Company
|
Leads360
|
|
Date Posted
|
4/16/2013
|
|
Status
|
Open
|
|
Description
|
We are seeking a Sr. Production Database Administrator to join our growing Application Operations team. This role will be responsible for maintaining high-level performance of a quickly-growing mission-critical data tier while looking for creative ways to help internal customers to access data for reporting needs. The ideal candidate is someone who is always looking for ways to improve our system and helping to educate the organization on how to implement improvements.
- Has 5+ years of experience in database development and production support of medium- to large-scale mission-critical MS SQL Server environments (multi- terabyte).
- Strong hands-on experience in Database Administration in SQL Server (2008+) and familiarity with SS2012
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Ability to understand data structures and provide data extracts / reports to Leads360 executives.
- Strong knowledge and experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
|
|
Contact
|
Please follow the online application link below.
|
|
Kevin Beach
Leads360
|
|
Job Title
|
SQL Server Database Developer - fulltime
Orange County, CA
|
|
Company
|
CGS Business Solutions
|
|
Date Posted
|
4/4/13
|
|
Status
|
Open
|
|
Description
|
The SQL developer is to have experience working with business applications using SQL, Stored Procedure, SSIS. The candidate development experience should include developing stored procedure and SSIS packages working with large volume of data. The candidate should have a good grasp of the data model he has worked with. The candidate should be able to take a complex data model along with design specification and develop/support processes using the technical skills as outlined for this position. The Software Engineer will work on processing large amount of data and complex logic in SQL queries/code and create solutions by analyzing, designing, developing, implementing, testing and maintaining application.
The candidate in this position will....
· Develop/Support SSIS packages
· Develop/Support SQL queries/procedure etc.
· Produce quality code on schedule
· Participate in Code Reviews and brainstorming activities
· Identify and solve problems of moderate to high complexity
· Work in a team environment
· Work on multiple assignments
Qualifications
Preferred candidate will have:
· BS in Computer Science or related discipline with 4+ years of experience in business application software development
· 4+ years of development experience in SQL and SSIS working with SQL server 2005/2008
· Working experience in application and database performance optimization techniques
· Understanding of SDLC methodologies
· Experience in data modeling, database design
|
|
Contact
|
Nick Chavis
CGS
949-683-9866
|
|
Job Title
|
SQL Database Administrator - fulltime
Orange County, CA
|
|
Company
|
CGS Business Solutions
|
|
Date Posted
|
4/4/13
|
|
Status
|
Open
|
|
Description
|
The DBA will be responsible for the following:
- Install, configure, and patch Microsoft SQL Server
- Manage backup and recovery operations
- Own, track, and resolve database related incidents
- Review and respond to service related reports (e.g. database backups, maintenance, monitoring) on a daily basis
- Design and implement database security
- Database server capacity planning
- Provide database design, development and project support to business technology teams within the organization
- Respond to database related alerts and escalations
- Work with other technology and business teams to devise strategic solutions to business problems
- Database management reporting and documentation
Qualifications:
- Knowledge of other MS SQL Server services (Reporting, Analysis, Integration)
- Knowledge of high availability and disaster recovery options for MSSQL Server
- Knowledge of indexes, index management, and statistics
- Willingness to provide after-hours support
- Must be able to work in a team environment as well as independently with minimal supervision
- Possess strong communication and documentation skills and have the ability to interact professionally with all levels of internal and external employees in both written and verbal communications
- Strong commitment to producing quality work and attention to detail to ensure work is delivered completely, accurately, and on time.
- Qualified candidates will be team players, self-motivated, innovative, organized, and solution minded
- Excellent time management skills and ability to flourish in a challenging, fast-paced professional environment is essential
|
|
Contact
|
Nick Chavis
CGS
949-683-9866
|
|
Job Title
|
Implementation Analyst positions with HMS in Irvine, CA
|
|
Company
|
HMS
|
|
Date Posted
|
4/2/13
|
|
Status
|
Open
|
|
Description
|
Job Description
This position is responsible for implementing new clients into our Fraud, Waste and Abuse service; performing detailed data analysis/mapping, development of inbound/outbound procedures, and management of new client customization's/changes.
Responsibilities
Analyzing client business requirements and implementing core business logic in SQL stored procedures, views, functions and triggers
Perform detailed data gap analysis identifying missing data components or issues with client data
Develop solutions or workarounds with any client related issues or limitations of the data
Collaboration with other technical groups to satisfy business needs and requirements
Work with client to make minor/major changes in data file layouts
Required Skills
Strong background with T-SQL
Strong data analytical skills
Ability to develop complex stored procedures for data loading
Experience with Business Intelligence Development Studio (BIDS)/Visual Studio
Strong ability to communicate effectively verbally, in writing, and fluently in English.
Strong ability to provide a high level of problem solving and technical troubleshooting skills.
Ability to work independently to meet objectives.
Ability to communicate technology into business terms with customers at all levels.
Strong ability to actively collaborate with other support teams for problem resolution.
Strong ability to analyze information and use logic and process to address work-related issues and problems.
Ability to provide careful attention to detail.
Ability to multi-task and prioritize workload.
Ability to perform well in a team environment, with staff at all levels, to achieve business goals.
Maintain and secure sensitive/confidential information.
Required Experience
Advanced data analysis techniques
Gathering business requirements
Communication with client regarding deliverables and timeframes
Exposure to large data volumes (>1TB)
General technology skills, including networking, hardware, protocols, security
Advanced knowledge of Excel/Access
Preferred experience in the “healthcare claims processing” field
|
|
Contact
|
Please follow the online application link below.
|
|
|
|
Job Title
|
Data Analyst with HMS in Irvine, CA
|
|
Company
|
HMS
|
|
Date Posted
|
4/2/13
|
|
Status
|
Open
|
|
Description
|
Job Description
This position is responsible for the successful on-boarding of data, communicating with internal and external clients concerning job status, issues and metrics.
Responsibilities
Manage process, coordination and scheduling of ETL data loads
Provide support for ensuring proper data loading and processing (24x7)
Provide monitoring and support for the intake and export of data within HMS
Report issues or delays with data loads to internal/external clients
Troubleshoot and identify issues with ETL data, file formats and jobs
Perform data quality checks and report to internal/external clients
Maintain documentation of ETL process and support procedures for each client
Work with client to make minor changes in data file layouts
Maintain, streamline and improve SSIS packages
Required Skills
Strong background with T-SQL
Ability to develop complex stored procedures for data loading
Ability to create/modify SQL Server Integration Services (SSIS) packages or other ETL tools
Experience with Business Intelligence Development Studio (BIDS)/Visual Studio
Strong ability to communicate effectively verbally, in writing, and fluently in English.
Strong ability to provide a high level of problem solving and technical troubleshooting skills.
Ability to work independently to meet objectives.
Ability to communicate technology into business terms with customers at all levels.
Strong ability to actively collaborate with other support teams for problem resolution.
Strong ability to analyze information and use logic and process to address work-related issues and problems.
Ability to provide careful attention to detail.
Ability to multi-task and prioritize workload.
Ability to perform well in a team environment, with staff at all levels, to achieve business goals.
Maintain and secure sensitive/confidential information.
Required Experience
Advanced data analysis techniques
Exposure to large data volumes (>1TB)
Prior usage of 3rd party ETL tools
General technology skills, including networking, hardware, protocols, security
Advanced knowledge of Excel/Access
Preferred experience in the “healthcare claims processing” field
|
|
Contact
|
Please follow the online application link below.
|
|
|
|
Job Title
|
Database Administrator with HMS in Irvine, CA
|
|
Company
|
HMS
|
|
Date Posted
|
4/2/13
|
|
Status
|
Open
|
|
Description
|
Job Description
Responsible for planning, developing and managing databases and procedures to support enterprise applications and business functions.
Responsibilities
Configures and upgrades database software.
Evaluates database features and related products.
Performs database application tuning and performance monitoring. Perform Database Patch Management and Version Control.
Provides consultation and trouble shooting for the development team.
Designs and implements databases in conjunction with the application development and Enterprise Data Analyst teams.
Establishes and maintains sound backup and recovery policies and procedures in conjunction with the system administrators.
Sets up and maintains database documentation and standards.
Interfaces with database vendors for technical support.
Implements and maintains database security.
Plans database growth and changes (capacity planning).
Provides 24x7 database support for production databases.
Developing ad-hoc reports as required, including the creation of Excel pivot tables.
Required Skills
Strong background with T-SQL
Ability to develop and manage complex stored procedures
Experience with Business Intelligence Development Studio (BIDS)/Visual Studio
Strong ability to communicate effectively verbally, in writing, and fluently in English.
Strong ability to provide a high level of problem solving and technical troubleshooting skills.
Ability to work independently to meet objectives.
Ability to communicate technology into business terms with customers at all levels.
Strong ability to actively collaborate with other support teams for problem resolution.
Strong ability to analyze information and use logic and process to address work-related issues and problems.
Ability to provide careful attention to detail.
Ability to multi-task and prioritize workload.
Ability to perform well in a team environment, with staff at all levels, to achieve business goals.
Maintain and secure sensitive/confidential information.
Required Experience
2-plus years of experience in SQL Server database administration
Experience with optimization and troubleshooting techniques to address performance problems on SQL Server 2008 R2.
Solid database-administration experience.
|
|
Contact
|
Please follow the online application link below.
|
|
|
|
Job Title
|
Fulltime/perm Business Intelligence Manager position in Pasadena
|
|
Company
|
Partners Consulting - A Calance Company
|
|
Date Posted
|
4/1/2013
|
|
Status
|
Open
|
|
Description
|
Our client has an immediate need for a Business Intelligence Manager. If interested or know someone who is interested and fit the criteria, please email your updated RESUME with a DAYTIME CONTACT #
Job Title: Business Intelligence Manager
Duration: Permanent
Location: Pasadena, CA (1-2 months initially in Sherman Oaks location and then the rest in Pasadena)
Start: ASAP
Salary: $120-135k plus 10-15% yearly bonus
Requirements:
· Must have 10+ years of experience in Data Warehouse, Data Marts, Reporting, OLAP, and Business Intelligence solutions, with at least 2 years in a managerial role
· Must have led the design and architecture of at least one data warehouse and data marts
· Must be hands-on experience; must have performed roles such as data modeler, data analyst, report developer, BI architect, and BI project manager
· Work with business leaders and stakeholders to strategize and define organization-wide business intelligence and reporting needs and integrate them into a cohesive delivery roadmap.
· Ability to work well in a matrix organization, driving/leading teams to consensus decisions on complex business and technical data challenges
· Provide BI and analytics thought leadership by keeping abreast of the latest in the BI domain
· Evaluate, select, and implement new technologies and development tools for reporting, dashboards, BI application design, development, testing, and documentation
· Periodically review and ensure that industry best practices (policies, standards, processes, quality assurance) are institutionalized in the organization.
· The candidate will be driving the current and future Data Warehouse and database direction
· Establishing development standards/best practices related to business intelligence and reporting. .
· Must be able to interface effectively with all levels of the organization.
· Must have excellent interpersonal skills and be strong and effective communicator.
· Must have experience building and managing offshore teams.
· Committed to deliver on time according to requirements and business needs.
· Able and willing to effectively mentor junior team members and contribute to a collaborative team environment.
· Responsible for hiring, salary adjustments/recommendations, and performance reviews.
Technical Skill Sets Required:
· Strong experience with Microsoft SQL Server 200X, and SSRS.
· Good knowledge of OBIEE and Hyperion
· Design and development of data warehouse and data marts.
· Design and development of ETL processes and OLAP cubes.
Education
· Bachelor’s Degree in computer science, information technology or related fields.
|
|
Contact
|
|
|
Job Title
|
Data Analyst SQL Developer with HMS in Irvine, CA
|
|
Company
|
HMS
|
|
Date Posted
|
3/31/13
|
|
Status
|
Open
|
|
Description
|
Job Description
The Data Analyst/SQL Developer is responsible for overall maintenance and development of HMS' Core/ACE Rule Engine, including rule logic and auxiliary data management.
Required Skills
- Strong communication skills, both written and verbal
- Ability to communicate effectively and approach problems proactively
- Very strong technical foundation and the ability to collaborate well with others
- Strong attention to detail
- Well organized, with a strong desire to document accurately
- High-energy, self-motivated, creative SQL Developer
- Strong ability to solve business problems through creative and analytical set based logic
Required Experience
- BS in Computer Science, Computer Information Systems (preferred) or a related field, or equivalent (minimum)
- 3+ years working with T-SQL and/or PL-SQL, relational database modeling
- MS SQL 2005+ and /or Oracle, MySQL
- Experience in writing and tuning SQL queries for maximum performance in a large data volume environment (strong plus)
- Experience in the "Healthcare Claims Processing" field (strong plus)
- Advanced knowledge of Excel/Access
- Familiar with Team Foundation Server / Business Intelligence Development Studio (BIDS)/Visual Studio 2010 is a plus
- Familiar with Agile development is a plus
|
|
Contact
|
Please follow the online application link below.
|
|
|
|
Job Title
|
SQL DBA - Los Angeles
|
|
Company
|
|
|
Date Posted
|
3/8/13
|
|
Status
|
Open
|
|
Description
|
Responsibilities:
* Install, configure, and administer SQL Server Databases to ensure high availability
* Design and develop data model and flow
* Create and manage DB instances, stored procedures, and functions
* Fine tune scripts to optimize performance and utilization
* Assistance to the development team in projects and trouble shooting
* Identify process improvements via version upgrades, new tools or reengineering of existing solutions
* Deploy SQL server databases service packs / patches, applications, ETL solutions, and hot fixes.
* Create and manage all production related jobs set up and maintenance. Set up monitoring jobs and alerts.
* Ensure periodic backups on production / staging / qa servers on both local and networking storage. Provide support for the database restore and refreshing process.
* Set up / monitor transactions, production log-shipping, and database mirroring to DR site.
* Implement access control and ensure data security and availability
* Assist the project leader and/or engagement manager to establish project quality standards, monitor project status and maintain project plans on schedule
* Be available on call for off hours for production support of scheduled changes and issue resolution
Requirements:
* 5 - 7 years experiences in Database scripting.
* 5 – 7 years of administration of Microsoft SQL Server, including MS SQL 2008 R2 in clustered environment.
* Bachelor's Degree in computer science or related areas.
* Expert in SSIS, T-SQL, stored procedures, functions, performance tuning and data modeling.
Preferred Qualifications:
* Experience with administrating Marklogic database server a plus.
* Experience with MySQL administration a plus
* Excellent written and verbal communication skills
|
|
Contact
|
Nicole Noonan
Associate Partner
Prosum Technology Services
direct 949.732.1118 | fax 949.732.1111
|
|
Job Title
|
Senior Database Developer
|
|
Company
|
Houlihan Lokey
10250 Constellation Blvd.
5th Floor
Los Angeles, CA 90067
|
|
Date Posted
|
2/25/13
|
|
Status
|
Open
|
|
Description
|
The Senior Database Developer’s role is to design, develop, and maintain database systems in support of various applications. This individual is also responsible for the daily database operations and management of the system resources to assure high levels of data availability.
Responsibilities
• Develop T-SQL scripts and ETL processes
• Design and develop Data Warehouses and Data Marts
• Design, develop, and provide support for inbound and outbound data feeds
• Design and Develop reports in using Microsoft SQL Server Reporting Services (SSRS) 2008
• Collaborate with developers, project managers and business analysts in conceptualizing and developing new software applications and enhancements.
• Support and assist in on-going maintenance of production databases and new databases to ensure performance with minimal downtime
• Document and share knowledge gain with the development team
• Troubleshoot database issues and provide optimal solutions
• Communicate problems and resolutions to Project Management
• Implement database changes and application changes as needed
• Maintain database standards and ensure that database standards are followed
Qualifications
• Bachelor’s degree in Computer Science or related fields
• 5+ years of experience with database development and database administration
• 3+ years of experience with SSRS and SSIS
• 3+ years of experience in building Data Warehouses using Microsoft SQL tools and technologies
• 5+ years of database design and support
• Must possess strong knowledge of SQL Server 2008
• Must be familiar with TFS and Visual Studio Database projects
• Experience with SQL Server performance tuning, execution plans, and indexing
• Experience with database replication and synchronization (Linked Servers, Mirroring, Log Shipping, and replication)
• Flexible and adaptable in regards of learning new technologies
• Attention to detail and the ability to multi-task
• Highly self-motivated and directed
• Outstanding communication skills (verbal and written) and organization skills
Preferred Qualifications
• Experience managing backup and restore SharePoint databases
• Experience running SQL on VM
• Web programming experience is a plus
|
|
Contact
|
To apply for the position, one can just go to this link:
|
|
Job Title
|
SQL/ .Net Developer
12 month plus contract, located in Torrance, CA
|
|
Company
|
|
|
Date Posted
|
2/23/13
|
|
Status
|
Open
|
|
Description
|
We are looking for a highly skilled SQL Developer who also has experience working on UI development. This developer will be spending 55% of his/her time on DB development related activities and 45% of .Net web development activities. This client is going to be migrating from SQL 2005 to SQL 2008 as they are centralizing all their legacy DTS to SSIS. Hence, this client will have a ton of DTS packages that will need to be converted over to SSIS which will be one of the primary tasks for this developer.
This is a minimum of a one year contract assignment with a strong possibility of an extension. The working environment is absolutely wonderful. If you are looking to get back that work/life balance and work a true 8 hour work day, this is a great opportunity as you will seldom work extremely long hours and will be able to enjoy your job as well as spend that much needed time with family and friends. There are a lot of exciting new initiatives taking place within this organization so this is a wonderful time to join this growing Development team and get in on the action packed development projects.
Required Skills and Expertise:
• Minimum of 6 years of recent experience as a SQL Developer
• Very strong experience with SQL including SQL 2005 and 2008 including creating stored procedures
• Experience with SSIS, DTS
• Must have experience working with ETL as this developer will be tasked with ETL Processing and bringing in data from outside sights.
• Excellent skill set in troubleshooting database issues
• Requirements gathering experience
• Secondary skill set in the UI/Web Development area creating applications using Microsoft Web Technologies ideally supporting web development for applications used by a large audience base. This development experience should include the following:
o ASP.Net 4.0 experience
o Experience working with JQuery and JSON
o HTML, .NET Framework 1.1, 2.0, and 3.5, VB.NET, VB Script, JavaScript, XML, XSLT, and .NET Web Services.
• Willingness to work with and coordinate development efforts with a mix of onsite and offshore resources when needed
• Required software usage knowledge includes MS .NET Studio 2003, and MS Office 2003 Tools
• Handling daily project operations
• Communication skills are required to document and report on technical specifications as required.
• Needs to be very reliable and be able to commit to a 12 month consulting engagement
|
|
Contact
|
Jiten Sonkamble | Talent Acquisition Specialist
El Segundo Office: Suite 110, 2381 Rosecrans Ave, El Segundo, California 90245
Irvine Office: Suite 210, 2100 Main Street, Irvine, California 92614 |
Direct Line: 310-405-6197 |Fax: 310-563-3801| jiten.sonkamble@ispace.com
|
|
Job Title
|
SQL Developer - Required Skills: TSQL, ASP.NET, C#, XML, HTML
|
|
Company
|
ETC Global Holdings, Inc.
|
|
Date Posted
|
2/4/13
|
|
Status
|
Open
|
|
Description
|
Wall Street firm, located in the heart of Downtown Los Angeles with easy access to Metrolink. Firm offers a creative and enterprising work environment with benefits including medical, dental, vision, paid parking, company sponsored Friday lunches and great opportunity for advancement.
Position Overview:
Responsible for the design, development, enhancement, maintenance, integration and testing of internal and external applications. These applications may be browser based or self-running depending on the specified requirements. Applications may also range in complexity from simple static web sites to more Complex, distributed architecture data driven applications. This individual will work with various internal and external teams to create and update applications. Additional responsibilities will include maintaining the firm's network, internal and external communications and providing some end-user support.
Primary Duties and Responsibilities:
- Candidate must have strong project management and time management skills.
- Strong SQL Server and SQL Command skills
- Investigate software integration solutions followed by purchase recommendations for all software development projects.
- Design and development of ASP.NET applications using in MS SQL Server in an IIS environment
- Portal environments for our internal web site. Must be able to develop programming requirements based on user input.
- Must create testing and deployment methodologies to minimize downtime and disruption.
- Produce timelines and develop project scopes based on input from Sr. Management
- Primary point of project communication between firm and external technology vendors.
Skills, Knowledge and Abilities:
- Strong critical thinking, analytical, problem-solving, and reasoning skills
- Strong project management skills to direct projects of broad scope and having significant financial and operational impact.
- Strong verbal, written, oral communication and presentation skills with proven experience with direct end-user contact & documentation.
- Disciplined work ethic and organizational skills to meet deadlines and commitments with limited direction.
- An understanding of broker / dealer operations and clearing and settlements is desirable
- Experience with MS Visual Studio, Visual SourceSafe, C#, ASP.NET, ADO.NET, XML, HTML, DHTML, JavaScript, ASP, VB.NET, SOAP, AJAX, XML, .NET
- Experience using SQL triggers, stored procedures, custom functions
- Basic knowledge of database-driven site design
- Must possess Software troubleshooting and testing skills
Education/Experience:
- BS Information Technology, Computer Science, or equivalent experience.
- Understanding of inter-system communication methods (TCP/IP, HTTP, FTP).
- 5 + years experience SQL Server
- 5 + years experience web developer
|
|
Contact
|
Luz Favela
213-402-1570 Ext 1582
|
|
Job Title
|
Sr. SQL DBA/Developer
|
|
Company
|
|
|
Date Posted
|
1/24/13
|
|
Status
|
Open
|
|
Description
|
Position
Technology Team is searching for a results-oriented Senior DBA/Developer with at least 5-7 years of SQL Server and database development experience. The position will require a strong technical background, coupled with an ability to interact effectively with end users. The individual will have the autonomy to work independently and as a team player in our downtown LA offices. This team member will report to our IT Applications Director and will work closely with the developers, analysts, and our existing support team.
Responsibilities
• Technical ownership of SQL Server databases, which is used for the ERP and Fulfillment systems.
• Daily monitoring of the database performance, replication, and successful completion of scheduled jobs, such as the interfaces between the ERP, eCommerce, and Fulfillment systems.
• Responsible for configuration and maintenance of a fault tolerant database solution, which includes replication and failover solution.
• Responsible for setting up database monitoring and alert tools.
• Development and support of interfaces, using stored procedures, triggers, and other database objects.
• Designs and creates schemas to support new initiatives.
• Development of user reports using SQL Server Reporting Services, SQL views, Excel, and possibly other reporting tools.
Requirements
• Minimum of 5-7+ years of experience working on administration, development, configuration and support of database applications.
• BA or BS degree preferred.
• Expertise in Microsoft SQL Server 2008 R2.
• Expertise in SQL Server database administration, monitoring, and performance tuning.
• Expertise in configuring and maintaining a fault tolerant database solution, which includes replication and failover.
• Expertise in SQL Server development, including stored procedures, functions, triggers, and views.
• Expertise in writing SQL, including creation of queries for data analysis and reporting views.
|
|
Contact
|
Nicole Bonilla
310.988.4948 Office
|
|
Job Title
|
Release Engineer in Redlands, CA
Full Time
|
|
Company
|
|
|
Date Posted
|
1/14/2013
|
|
Status
|
Open
|
|
Description
|
Do you have a passion for and a desire to focus on the latest computing technology? Help us test, release, and certify our products on a wide array of iOS and Android devices, smart phones, and tablets. In this work, we design, build, and release sophisticatedapplications for smart phones and the latest digital devices used by millions of people throughout our user community. These apps enable our users to apply intelligent online maps and apps to support the work of businesses, governments, and communities worldwide.
Responsibilities:
- Participate in the release of high quality software; certify the overall quality of the system and ensure each release is ready to ship
- Work closely with product development teams to identify, prioritize, and ensure key issues are fixed for a release
- Support internal and external customers in addressing issues related to released software
- Continually update release methods based on rapidly changing technology
- Perform daily testing, analysis, investigation, and identification of software problems
- Report daily on the quality and stability of the software system
Requirements:
- Bachelor’s or master’s in information technology, GIS, computer science, or related field, depending on position level
- Experience with QA processes, commercial test frameworks, test design strategies, and writing test cases and automating tests
- Working knowledge of the software development process
- Experience with multiple platforms and/or devices (iPhone, Android, MacOS, Windows Mobile, etc.)
- Strong problem-solving skills with a strong interest in finding and diagnosing software issues
- Strong communication and organizational skills
- Excellent interpersonal skills and a "customer first" attitude
Recommended Qualifications:
- Experience with mobile testing of either iOS, Android, or Windows Phone applications
- Experience with JavaScript, Adobe Flex, Microsoft Silverlight, and/or Python
- Experience using web programming frameworks (XML, SOAP, SOA, REST)
- Knowledge of SQL and/or a relational database management system at the administrator level
- Familiarity with GIS and/or Esri ArcGIS products
|
|
Contact
|
Melinda M. Malone | Human Resources
Esri | 380 New York Street | Redlands, CA 92373 | USA
|
|
Job Title
|
Enterprise Geodatabase Product Engineer in Redlands, CA
Full Time
|
|
Company
|
|
|
Date Posted
|
1/14/2013
|
|
Status
|
Open
|
|
Description
|
Are you especially talented at solving complex database problems for GIS implementations? We are looking for motivated and self-directed individuals to join our development team dedicated to solving complex enterprise problems and ensuring client success by designing, building, certifying, and supporting the software used for creating enterprise solutions for ArcGIS.
Responsibilities:
- Influence product design, functionality, and usability for enterprise GIS
- Work closely with customers and partners to identify and design key GIS workflows; certify those workflows for the ArcGIS product suite
- Ensure key workflows perform satisfactorily in multi-user environments
- Define and develop methods to enhance product quality
- Communicate best practices for building and maintaining enterprise geodatabases
- Gather and document requirements for future development based on client feedback
Requirements:
- Bachelor's or master's in computer science, GIS, or related field, depending on position level
- Five or more years of experience implementing, administrating, and applying GIS in various advanced customer environments
- Strong DBMS expertise in a commercial RDBMS
- Proficiency with SQL
- Exceptional verbal and written communication skills for interacting with clients and making presentations
- Ability to work with multiple teams and to prioritize requirements
Recommended Qualifications:
- Strong, in-depth understanding of ArcGIS for Desktop or ArcGIS for Server
- Experience administering PostgreSQL
- Familiarity with programming languages such as .NET or Java
- Analytical problem solving abilities
- Experience with Amazon cloud
- Comfortable working on multiple projects simultaneously
|
|
Contact
|
Melinda M. Malone | Human Resources
Esri | 380 New York Street | Redlands, CA 92373 | USA
|
|
Job Title
|
SQL DBA in the Malibu area
|
|
Company
|
|
|
Date Posted
|
1/7/13
|
|
Status
|
Open
|
|
Description
|
Looking for a top performing DBA to own and manage its extensive proprietary database. The position will be responsible for the development, production and maintenance of all SQL Server systems within the company. The primary responsibilities will be to ensure the stability, security and reliability of all SQL Server systems, as well as assist development teams with best practices and code optimization as needed.
More Specifically*
* Maintain and monitor large database environments for 24/7 availability
* Manage and execute daily operational jobs, including backups, index / statistics updates, defrags, etc.
* Develop alerts, reports and automated processes for failed jobs
* Store, trend and analyze database and system performance measurements over time
* Optimize procedures, indexes and table schemas according to trending data
* Develop QA audits of ETL data, trending for sudden changes in key metrics
* Ensure security measures and policies are in place by minimizing scope of exposure to logins, updating security patches, separating service accounts for administrative jobs and performing necessary security audits
* Plan, design and implement the database capacity, physical and logical modeling for a large .NET applications
* Responsible for reviewing the design and deployment of any data objects from development/staging to production
* Act as first contact in a rotating, on-call schedule for database support
* Maintain consistency of naming conventions for all database objects
* Full involvement in deployment of applications when needed
REQUIREMENTS/QUALIFICATIONS
* 5+ years experience as a dedicated DBA, administrating large production database environments working with SQL 2008 or 2012
* Working knowledge of DMVs, DTA and SQL Profiler required
* Experience monitoring and administrating an H/A Fail-Over environment
* General understanding and basic work experience with DTS / SSIS
* Experience in installing, upgrading / patching, and configuring SQL 2005/08
* Strong T-SQL development skills and in-depth knowledge of SQL internals
* Ability to automate routine processes with NET or PowerShell
* Advanced experience in mirroring and replication
* Extensive experience designing and implementing backup and recovery strategies
* Understanding of multi-tier architecture environment or Service Oriented Architecture
* MUST have experience with a high performance, high traffic and large database environments
* Advanced knowledge of 3rd party backup and performance diagnosis and monitoring tools a plus
* Knowledge of SSRS and SharePoint integration a plus
* Experience with SAN / Storage technologies a plus!
* Experience developing and administrating OLAP / SSAS Data Warehouse solutions a plus!
PERSONAL ATTRIBUTES
* Energetic and fast paced individual who thrives in a high growth, entrepreneurial environment
* Organized and motivated team player, with the ability to manage multiple projects while paying close attention to detail
* Highly responsible, self-motivated, and able to work with minimal supervision
* Resource oriented persona with the ability to adapt to a constantly changing technical environment
* Strong communication (both verbal and written) skills are a must
* Above all, ethical, fair and of high integrity
|
|
Contact
|
Nicole Noonan
Associate Partner
Prosum Technology Services
direct 949.732.1118 | fax 949.732.1111
|
|
Job Title
|
MS SQL Server Database Administrator
San Luis Obispo, CA
Full-time with benefits
|
|
Company
|
|
|
Date Posted
|
12/21/12
|
|
Status
|
Open
|
|
Description
|
This is a MSSQL Server DBA role largely responsible for providing operational database services to the organization. Some of 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 other colleagues in Engineering to come up with strategic solutions to recurring problems.
This role requires good communication skills. If you have a blog then please pass along the URL so we can review your work. If you do not actively blog that is fine, but you should be prepared to show us an example of something you have written previously if we should happen to ask.
Essential Qualifications and Requirements:
4 years of MSSQL database administration experience (SQL 2008 preferred).
BS in Computer Science or equivalent education / professional experience.
Ability to create and follow written procedures.
Experience in troubleshooting and resolving database problems.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Experience with backups, restores and database recovery models.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
Ability to independently learn new technologies through research and vendor provided documentation.
Ability to work independently and proactively with a minimum of supervision.
Desired Skills or Qualities:
Experience in implementing operational automation (PowerShell 2.0 and/or C# are preferred).
Knowledge of indexes, index management, and statistics.
Experience working with Windows server, including Active Directory and proper disk configurations.
Experience with designing and troubleshooting DTS packages.
Good communication and documentation skills.
Involvement with the MSSQL Server Community; membership in PASS, active in forums or newsgroups.
Certification is a plus: MCTS, MCITP, MVP
|
|
Contact
|
Emily Quinn
Technical Recruiter (Contract)
O 831.531.8901
C 831.331.9866
Skype QuinnE19
MINDBODY, Inc.
4051 Broad Street, Suite 220
San Luis Obispo, CA 93401
|
|
Job Title
|
Bank Of America is looking strong SQL candidate with minimum 5 years of experience.
Previous experience in any financial organization is preferable.
Location: Thousand Oaks, Agoura Hills.
Rate: Open
Tax Term: W2
|
|
Company
|
Bank Of America
|
|
Date Posted
|
11/29/12
|
|
Status
|
Open
|
|
Description
|
- Application Development (coding) experience in SQL and other languages
- Strong data analysis
- Experience with SDLC, Data management methodologies, data standards, and related tools.
- Strong expertise in SAS, SQL and relational database architecture
- Understanding and some working knowledge of data dictionary and data mapping schemes.
- Extensive experience (7-10 yrs) in implementing multiple development projects, data consistency and data comprehensiveness.
- Knowledge of a QC methodology, data mining, standards and tools
- Highly structured to work independently and with direction.
- Excellent verbal and written communication skills to deliver the message objectivity
- Excellent technical and business writing communication skills (7-9 yrs) to document requirements, specification, planning document, and testing documents.
- Strong presentational skills and ability to communicate complex material (5-7 yrs)
- Strong interpersonal skills and ability to objectively communicate and also solicit input from others
- Great listening skills
- Some understanding and work experience with DMAIC (2-4 yrs)
Job Description:
- This is a newly created role that has scope over: testing logic of technical reports. Also developing and conducting quality controls efforts to maintain consistency and stability of business reports through review of report format for accuracy, and ensure compliance with reporting standards as well as applicable regulatory guidelines.
- Conduct QC review of production reports for compliance, based on defined set of quality attributes.
- Produce assessments for remediation that will be executed by reporting teams and other related partners.
- Initial focus is to help with design of a Quality Control model (QC) to assess key reports.
- Regularly schedule, plan and test existing reports (from active inventory of key reports) then document findings. Based on input from Reporting Data Governance, Reporting Standards, and other applicable guidelines (using approved QC metrics and targets).
- Communicate QC assessment to key partners for remediation. Key partners include: Report Managers; Reporting Standards; Reporting Data Governance, Audit, Policy & Procedures; business units.
- Provide input on to a quarterly dashboard for management to check QC progress status on key business reports.
|
|
Contact
|
Pavel Ghosh
Recruiter
+1-408-498-5903
|
|
Job Title
|
T-SQL CONTRACTOR
Hourly Rate: Open
Location of position: Westlake Village
Length of Project: 3 -4 months ++
|
|
Company
|
|
|
Date Posted
|
11/26/2012
|
|
Status
|
Open
|
|
Description
|
Our client is a medical billing company with an immediate need for a SQL Contractor. The company is going through a certification process and has an immediate need for a Transact-SQL developer to create the back end of a standalone project for Medicare Billing applications, run queries, and validate data.
MUST HAVE: NCQA and HEDIS Measures
Background Check and Drug Testing required for this position.
|
|
Contact
|
For immediate consideration, please forward your resume as a word doc resume (preferred) to:
Lee Schwing
Recruiting Partner
|
|
Job Title
|
SQL Applications Developer
FTE - Direct Hire with Client
Salary: Market
Location of position: Westlake Village
|
|
Company
|
|
|
Date Posted
|
11/26/2012
|
|
Status
|
Open
|
|
Description
|
Our client is a fast growing software company specializing in the medical billing industry. The company is seeking a SQL Applications Developer to join a growing team. Work on SQL development, testing and queries.
Company works in a highly regulated environment and prefers a background in healthcare, biotech or pharmaceutical applications.
Must have outstanding analytical skills. Must have solid communication and interpersonal skills for frequent meetings with internal team members. This is an outstanding work environment where your skills and talent will be appreciated.
Background Check and Drug Testing required for this position.
As this is a direct hire position with the client, we can't accept corp-to-corp or H1 candidates.
|
|
Contact
|
For immediate consideration, please forward your resume as a word doc resume (preferred) to:
Lee Schwing
Recruiting Partner
|
|
Job Title
|
SSRS Specialist
80-90K
Location of position: Torrance
Senior level SSRS specialist at a fast paced, high tech firm in Southern LA County
|
|
Company
|
|
|
Date Posted
|
11/17/12
|
|
Status
|
Open
|
|
Description
|
Requirements:
- Technology:
- Experience using SSMS (Microsoft SQL Server Management Studios).
- 3+ years’ experience using SSRS to develop, test, debug, and deploy simple to moderately complex reports.
- 3+ years’ experience BIDS (Microsoft Visual Studio, SQL Server Business Intelligence Development Studio).
- Work Environment:
- Able to work in a high pressure environment where tasks priorities change often.
- Able to communicate effectively with non-technical individuals to determine needs/issues when creating and fixing reports.
- Able to manage multiple projects/tasks simultaneously to meet objectives and/or key deadlines.
- US citizen.
Pluses:
- Experience with complex and very complex SSRS reports.
- Experience in .NET Development (C#, VB, ASPX)
Education:
- Bachelors (or better) in Computer Science or related field.
About HarborObjects:
Since 1990, the success of HarborObjects has been built by our winning team of developers and architects, each with deep experience in various technologies. We are a proven innovator of strategic software solutions for growing businesses and Fortune 500 companies. We value technological diversity. We create innovative solutions using a wide range of both proven and emerging tools, with deep proficiency in multi-language and multi-platform technologies. And we guarantee our work.
|
|
Contact
|
|
|
Job Title
|
Data Warehouse Architect
|
|
Company
|
UCLA IT Services
|
|
Date Posted
|
11/16/12
|
|
Status
|
Open
|
|
Description
|
Job Summary
Working as a member of the IT Services' Information & Data Strategy Team, the Data Warehouse Architect is responsible for the analysis and design of data marts for the Campus Data Warehouse. Major responsibilities include engagement of stakeholders and customers to gather requirements for the design and development of data models and design specifications using star schema techniques; analyze and create Extract-Transform-Load (ETL) specifications; collaborate with Business Intelligence Analysts, conduct system performance analysis and problem resolution. The person in this position will also evaluate and analyze emerging technologies, solutions, methods and best practices to continuously improve the delivery of Data Warehouse and Business Intelligence Solutions.
SKACs Required:
- 5+ years of relevant experience in the design, development and implementation of Enterprise Data Warehouses and data marts using star schema and Erwin for data modeling, possess analytic skills to understand existing data structures.
- Advanced skill in creating indexes, aggregations, and stored procedures using TSQL, SQL programming, and data analytics; skilled in the development of Extract-Transform-Load (ETL) specifications.
- Experience using SQL Server 2008 including expertise with associated architecture, tools and security.
- Demonstrated knowledge of Kimball Lifecycle Methodology for Data Warehouse and Business Intelligence solutions.
- Communication skills sufficient to effectively convey complex technical topics orally and in writing to audiences with disparate background and levels.
- Sufficient interpersonal skills to work effectively with people at all levels and experience; possess motivation and skill to meet project goals with creative and collaborative solutions.
- Bachelor's degree in Computer Science, Engineering, Information Systems, MIS (or similar) OR equivalent relevant professional experience.
Preferred:
Experience working within a higher-education information technology organization with emphasis on Data Warehousing.
Full information concerning the job qualifications are listed on the official UCLA job posting
How to Apply:
Qualified applicants may apply for this position using the UCLA Career Opportunities website.
UCLA is an Equal Opportunity/Affirmative Action Employer
|
|
Contact
|
Donna M. Capraro
Director Information and Data Strategy
UCLA IT Services
Campus Data Warehouse
310 206-1624
|
|
Job Title
|
SQL Server DBA position
|
|
Company
|
|
|
Date Posted
|
11/2/12
|
|
Status
|
Open
|
|
Description
|
PADI, the global leader in Scuba Diving Education, is seeking an experienced and dynamic MSSQL DATABASE ADMINISTRATOR to join the team at our corporate headquarters in Rancho Santa Margarita, CA. PADI offers its employees a unique, dynamic and fun work environment, competitive salary, excellent benefits and generous time off. We believe in creating an environment where our employees can thrive and grow. PADI is an Equal Opportunity Employer and has been voted one of the Top Workplaces in Orange County in 2008, 2009, 2010 and 2011.
ABOUT THE JOB
The MSSQL Database Administrator creates, modifies, maintains and documents data storage needs of the company and codes, tests, implements and maintains physical databases.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
* Responsible for the design, capacity, and maintenance of MSSQL databases.
* Assist I.T. staff with database administration.
* Assist with design, build, test and rollout of BI/DW databases.
* Assure integrity of data by developing scanning programs to verify data validity.
* Develop and maintain business continuance strategy of databases; options to consider are clustering, mirroring, replication, tape backup, etc.
* To stay on the leading edge with new technologies made available by upgrades to SQL server; bring new ideas to the company based on these new opportunities.
* Manage capacity planning of the SQL databases to include upgrades to new versions of SQL and/or new hardware requirements.
* Responsible for the optimization of all SQL servers via performance tuning.
* Assist in the planning and implementation of different methods to make data available to the end user.
* Analyze, develop, code, test and maintain MSSQL Server stored procedures and views.
* Assist programmers in resolving application specific questions on the MSSQL Server.
* Analyze current database design and offer suggestions for necessary changes due to new projects.
* Provide support in all above mentioned duties for company and/or jointly owned offices located worldwide.
EDUCATION and/or EXPERIENCE
* Post secondary degree in Computer Science or equivalent experience in computer technology and/or computer programming.
* MCDBA 2005 or 2008 Certified with experience in Analysis Services, MS Reporting Services, Window 2003/2008 Server.
* Three years plus experience of system lifecycle development and system analysts and design.
*Experience as a database administrator developing and supporting Data Warehouse, OLTP and/or OLAP enterprise systems.
* Experience in interacting with .Net based Web technologies.
* Highly proficient in performance tuning MSSQL and TSQL.
* Familiarity with project life cycle methodology and the DBA role, as well as other development project roles within the methodology.
* Knowledge of best practices for efficient and secure database accesss.
* Experience supporting ERP applications preferred.
* 3-5 years of experience in database design and administration on MSSQL including experience in installation, replication, stored procedures and design.
* Strong knowledge of Disaster Recovery and implementation methodologies.
* A demonstrated track record of strong teamwork and interpersonal skills.
OTHER SKILLS AND ABILITIES
* Typing skills of 30 words per minute.
* Familiarity with general computer terminology and procedures.
* Strong project management abilities.
*Use of Microsoft Word, Excel, and Outlook
* Working knowledge of .net, XML and visual basic preferred.
TO APPLY FOR THIS POSITION, submit your resume online WITH SALARY REQUIREMENTS or via fax to 949.267.2125. Relocation is not available for this position. To learn more about PADI go to www.padi.com.
|
|
Contact
|
Janet Callahan
HR Manager
PADI
30151 Tomas
Rancho Santa Margarita, CA 92688
|
|
Job Title
|
SQL Programmer Analyst
Location: Remote
Salary: 80-100k
|
|
Company
|
|
|
Date Posted
|
10/26/2012
|
|
Status
|
Open
|
|
Description
|
We are looking for a SQL Developer with good communication and customer facing skills to join our development team. As our new SQL Developer, you will work on the team responsible for the development of our existing product line. Our applications are written in Gupta SQLWindows, C# (Web Services, Winforms), and Silverlight utilizing an Oracle database.
An ideal candidate must have extensive knowledge of Gupta SQLWindows and have experience with the complete software lifecycle. Knowledge of .NET, Silverlight, and PL/SQL is a major plus.
Qualified candidates must be able to work in a fast-paced, customer-oriented environment. You must have excellent written and verbal communication skills and be able to prioritize, multi-task and adapt to change.
Responsibilities:
- Design and implement various features across our complete product line
- Work with Product Management to flush out specifications and requirements
- Work with QA to assist in the testing process
- Assist the Technology department to troubleshoot production issues
- Be a source of reference to the Support department
Required Skills and Experience:
- 5+ years experience developing client/server software
- 3+ years of Gupta SQLWindows experience (.NET experience a plus)
- Database design experience
- SQL
Optional Skills and Experience:
- Oracle database experience
- Experience working with SVN or other version control systems
- Experience working with XML
- .NET WebServices
- Crystal Reports
- Academic, accounting or fund-raising software experience
|
|
Contact
|
John Thompson
Recruiting Manager
Robert Half Technology
ph. 310.209.6838
|
|
Job Title
|
Reporting Engineer / Duration: 5 Months / Location: Pasadena, CA / Start: ASAP
Pay Rate/Hr: $40 - $55/hr
|
|
Company
|
Partners Consulting - A Calance Company
|
|
Date Posted
|
10/26/2012
|
|
Status
|
Open
|
|
Description
|
Under general direction, the Reporting Engineer participates in the construction, implementation and support of software products that meet established specifications, design criteria, quality standards and business requirements. Responsible for designing reporting solution based upon business requirements documentation and architectural designs.
RESPONSIBILITIES:
· Designs and develops reporting models to meet business requirements.
· Creates ad hoc queries to support business decisions.
· Creates Stored Procedures, Data Transformation Services (DTS) and/or SQL Server Integration Services (SSIS) packages to Extract, Transform and Load (ETL) data from transaction systems into the reporting environment.
· Supports and maintains the reporting and data warehouse environments.
· Contributes to matrix teams designing and developing reporting and data warehouse solutions.
· Prepares and maintains complete programming specifications, functional designs, and both high and detail level technical design documents.
· Conducts code and security code reviews.
· Creates deployment scripts.
· Performs troubleshooting and analysis to assess root causes of reporting and data warehouse issues.
· Maintains a high degree of knowledge on current technologies and tools.
· Makes recommendations to improve operating efficiency and functionality of assigned systems areas.
Benefits:
Skills/Experience:
· Two plus years overall software and/or application development experience performing data analyst tasks.
· Two plus years’ experience with knowledge of T-SQL and Stored Procedures, Data Transformation Services (DTS) using Microsoft SQL Server.
· Two plus years’ experience with managing large volumes of data, extraction of data from SQL Server tables.
· Understanding of theoretical and practical aspects of decision support system design (ETL, Architecture, Metadata, Data Access, etc.)
· Ability of work well in a team environment and brainstorm with other developers/senior developers on ideas, work flow and technologies.
· Strong technical, logical, analytical, and problem solving skills.
· Strong communication/technical writing skills.
· Experience in software lifecycles, software configuration management and change control.
· Excellent interpersonal skills with the ability to develop cohesive working relationships with internal and external clients.
· Ability to manage multiple deliverables in a highly energized and fast-paced environment within a framework of constantly shifting deadlines and deliverables.
· Flexibility to adapt to change and willing to learn and develop new skill sets as applicable.
|
|
Contact
|
Andy Ballantyne
Sr Technical Recruiter
Partners Consulting - A Calance Company
800-732-4680 x709
aballantyne@partnersconsulting.com
|
|
Job Title
|
ETL Developer, Beverly Hills, CA
|
|
Company
|
|
|
Date Posted
|
10/22/12
|
|
Status
|
Open
|
|
Description
|
Local candidate preferred
Rouse Asset Services has a full-time opportunity available for an ETL/BI Developer in our Beverly Hills, CA office. The successful candidate must have the following skills:
- Excellent T-SQL skills 4+ years
- 2+ years with SQL Server Integration Services (SSIS)
- 2+ years with SQL Server Reporting Services (SSRS)
- Architectural concepts and processes within a Data Warehousing environment (Kimball experience a plus)
- ETL process exception handling, event triggering, and event notification
- SQL Server stored procedures, SSIS scripting, and performance tuning
- Data quality assessment and data cleaning transformations using SSIS
- SSIS package configuration
|
|
Contact
|
Hasan Hboubati
Director of IT
Rouse Asset Services
8383 Wilshire Boulevard, Suite 900
Beverly Hills, CA 90211
|
|
Job Title
|
Applications Integration Consultant SQL/Java - Los Angeles, CA - Contract Full-Time
Position ID: 21519
|
|
Company
|
|
|
Date Posted
|
10/15/12
|
|
Status
|
Open
|
|
Description
|
Outstanding financial services firm located near LAX has an immediate consulting opportunity for an accomplished Application Integration Developer with service development skills using SQL server and Java in the middle and back end tier. This is a challenging, fast paced environment for an ongoing, to possibly full time position as follows:
Requirements:
- Bachelor's degree in computer science, engineering or the equivalent is preferred.
- Experience with N-Tier application development.
- Minimum of 3-5 years hands-on experience with SQL Server database development and management including performance monitoring and optimization; creating stored-procedures, queries, views, and triggers.
- Ability to manage large scale database for high performance and availability
- In depth SQL knowledge is required, including advanced tuning skills.
- Java service development experience is required. WCF experience desired.
- Ability to troubleshoot issues from front end to back end.
- Knowledge of XML, .NET Framework and C# technologies.
- Strong communication skills and the ability to share ideas and work well in small teams.
- Possesses excellent problem solving capabilities.
- Independent and self-motivated.
- Finance/investment experience is a major plus
- Knowledge of WPF and other front end technology is a plus
If you are passionate and motivated; Driven, with an entrepreneurial spirit; Resourceful, innovative, forward thinking and committed and seriously interested for this role, then please respond by forwarding your resume in MS Word format.
|
|
Contact
|
Jon Buschke
Director of Human Capital
Surrex Solutions Corporation
Phone (310) 765-7803
Cell (805) 813-1647
Fax (866) 578-4432
|
|
Job Title
|
Senior Database Administrator
|
|
Company
|
CO-OP Financial Services (Rancho Cucamonga, CA)
|
|
Date Posted
|
10/14/12
|
|
Status
|
Open
|
|
Description
|
CO-OP Financial Services, the nation’s largest credit union owned EFT network and processor, is looking for a Sr. Database Administrator at our corporate headquarters in Rancho Cucamonga, CA.
The Sr. Database Administrator (DBA) is responsible for providing technical support for the database environment including overseeing the creation and organization of the databases, assessment and implementation of new technologies, and providing a long-term perspective on the relationship of database technology to the strategic business initiatives. The person in this role must be able to work with analysts, application developers, network engineers and other staff to create and maintain a state-of-the-art environment that meets current and future business objectives.
Condensed list of Duties and Responsibilities:
- Create performance tuning plan and pro-actively manage database Performance Tuning and Optimization (PTO)
- Create new databases, tables, views, indexes, scheduled jobs, triggers, logins, etc. based on system specifications
- Perform index management
- Troubleshoot and resolve database issues
- Manage database backup and restore schedule
- Implement and maintain High Availability (HA) database servers and Disaster Recovery (DR) plans
- Plan and implement Microsoft SQL server upgrades
- Implement scripts for operational automation
|
|
Contact
|
|
|
Job Title
|
Senior SQL Server DBA (Torrance CA)
|
|
Company
|
|
|
Date Posted
|
10/11/12
|
|
Status
|
Open
|
|
Description
|
HarborObjects an elite Microsoft partner is seeking a capable and enthusiastic SQL Server DBA to join us as a senior member of our software development and consulting team.
This is a full-time employment opportunity. The initial assignment for this position will be working as a member of our consulting team at our client's site in Torrance CA. That client is a well-known fast paced high tech company.
Requirements:
- 5+ years' Experience using SSMS (Microsoft SQL Server Management Studios) and other related SQL Server administration tools such as Profiler and PerfMon
- Strong experience in Database Administration in SQL Server ( 2005 and 2008 )
- Able to work in a high pressure environment where tasks priorities change often.
- Able to communicate effectively with non-technical individuals to determine needs/issues when creating and fixing reports.
- Able to manage multiple projects/tasks simultaneously to meet objectives and/or key deadlines.
- 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.
- Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
- Strong 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.
- Bachelors (or better) in Computer Science or related field.
- US citizen.
Pluses:
- Solid acquaintance with windows server, security delegation, SPNs, storage components.
- Experience with SSRS reports and SSIS packages.
About HarborObjects:
Since 1990, the success of HarborObjects has been built by our winning team of developers and architects, each with deep experience in various technologies. We are a proven innovator of strategic software solutions for growing businesses and Fortune 500 companies. We value technological diversity. We create innovative solutions using a wide range of both proven and emerging tools, with deep proficiency in multi-language and multi-platform technologies. And we guarantee our work.
|
|
Contact
|
|
|
|
|
|