|
|
|
|
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
|
CHIEF ENTERPRISE ARCHITECT |
| Company |
www.ostechnical.com |
| Date Posted |
3/1/10 |
| Status |
Open |
|
Description
|
Outsource Technical is currently seeking a Chief Enterprise Architect for a client in the South Bay.
- We are at the very beginning stage of a massive enterprise architecture initiative that will involve 5 division technology operations spanning the U.S.
- The initial focus for our CEA will be:
- Global Suite Architecture (Institutionalizing next gen technology)
- Microsoft Office component architecture
- Platform strategy review (SaaS, Cloud Computing, S+S and mobile / un-tethered)
- Security modeling
- Technology / product standardization.
- Our CEA will have 2 direct reports, both enterprise architects.
Technology Focus:
- We are a Microsoft-centric, SQL Server, Agile, SaaS environment first…..and an open source environment second. Since our product architecture is significantly Microsoft-centric, it is very important for our CEA to have experience architecting solutions under the .NET framework, SQL Server, Silverlight, Smartclient, etc. While this is a Director level position, extensive hands-on Microsoft-centric experience will be crucial to success in this role. With our forays into different markets, such as the corporate & consumer markets, additional non-Microsoft based technologies come into play (more open source, J2EE, Oracle, AJAX, etc). The perfect mix between Microsoft technology and non-MS should probably be 70/30 or 80/20 split.
- SaaS definition: Software as a service is a model of software deployment whereby a provider licenses an application to customers for use as a service on demand. SaaS software vendors (such as CyberShift or SalesForce.com) may host the application on their own web servers or upload the application to the consumer device, disabling it after use or after the on-demand contract expires. The on-demand function may be handled internally to share licenses within a firm or by a third-party application service provider (ASP) sharing licenses between firms.
CEA Tactical Focus:
- Increased innovation
- Decreased product & organizational cost
- Improved agility – faster execution - decreased cycle time to market
- Enhanced customer experience – ease of use – improved functionality – more intuitive
- Software reusability
- Standardization of technology stack
- Decreased number of software defects – improved quality / reliability
- Decreased number and severity of support calls
- Seamless integration with PMO model
- Optimize vendor & partner relationships
- Improved ease of installation & upgrade
- Improved internal and 3rd party integration
- Optimize product performance
- Consistent / compliant security
- Support of different deployment models (SaaS, ASP, on-premise)
- Leverage global scope, scale and localization
Ideal Candidate Profile:
- This is a Director level EA position, so the selected candidate must have strategic / division-level EA experience involving long term planning, building road maps, and acting as a highly credible catalyst for change at a multi-location divisional level. They must also have recent solutions architecture and application architecture experience…..so they can’t be too strategic (as would a CTO or VP of Technology) and they can’t be too hands-on (as would a Solution Architect that hasn’t been involved at the enterprise level making strategic calls).
- We prefer to pull candidates from software products companies. Our CEA must understand the business processes of our customers (what they do and what they want from CCH). Our customers belong to certain market segments, and their market needs must be met and reflected in our software products and technology selection.
- Microsoft-centric experience is extremely important, but we do not require Microsoft certification.
- We are only interested in high level EA candidates where the focus has been external customer-facing software systems.
|
|
Contact
|
Bri Pang | Office 310 658 7137 | Mobile 949 903 3292 bpang@ostechnical.com |
|
Job Title
|
Long Term Contract for SQL Developer/DBA (50/50) in Los Angeles, CA |
| Company |
www.ispace.com |
| Date Posted |
2/19/10 |
| Status |
Open |
|
Description
|
Must be senior in the following areas:
· Triggers
· Stored Procedures
· Back-up/Recovery
· SSRS/SSIS |
|
Contact
|
Please forward your resume to: dianna.takeuchi@ispace.com or call 310-563-3844 |
|
Job Title
|
SQL DBA – SQL Server Install in Greater Los Aneles Area, CA |
| Company |
MTM Technologies, Inc. www.mtm.com |
| Date Posted |
2/18/10 |
| Status |
Open |
|
Description
|
Skills Required:
-SQL 2005/2008 Server
-SQL 2005/2008 Server clustering
-Windows Server 2003/2008
Position Description: Seeking a talented SQL DBA who has experience with SQL 2005 Server clustering and SQL 2005 Server. The candidate must be able to install a SQL Server 2005 and verify functionality. Candidate must be familiar with Industry best practices.
Our client is seeking to add a SQL server to their environment using MS SQL 2005. Our client is seeking a consultant to assist in assessing their needs, securing and helping install the box. They are seeking a very experienced resource to help with this effort. Candidate will be expected to explain install to staff, train staff, and document install.
If you are interested in this opportunity please email cmanning@mtm.com with the following information today!
1. (updated) Word formatted Resume
2. Brief summary of skills related to the position
3. Eligibility to work within the United States without sponsorship
4a. Desired Hourly contract rate (1099 or Corp-to-Corp)
4b. Desired Full-Time Salary
5. Availability for Phone Interview
6. Availability for Onsite Interview
7. Start Date Availability
8. Any other questions, comments or concerns you might have.
9. Three employment references (to be checked post-interview) |
|
Contact
|
Casey Manning, Jr. - P 415.762.3317 - C 415.412.1373 - F 415.348.0472 - E cmanning@mtm.com |
|
Job Title
|
Database Engineer - 12 Months Contract Position - Los Angeles , CA |
| Company |
Infotree Service Inc. |
| Date Posted |
2/18/10 |
| Status |
Open |
|
Description
|
· Responsible for activities involved in the analysis, design, development, troubleshooting, debugging and maintenance of enterprise transactional systems.
· Also responsible for formulating and implementing the team's technical vision, providing hands-on insight into system architecture, data software development for transactional and batch systems.
· Establishes database management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical data model capacity planning, external data interface specs, data loading, data maintenance plan and security policies.
· Collaborates with data modelers and facilitate interaction between DBAs and data modelers for logical and physical data models. Determine appropriateness of data storage, archive, purge and backup strategies.
· Database designing, database performance, management and tuning experience. Enforce database standards and procedures. Provide technical leadership and mentoring to others on the team.
· Experience in Database development field. Experience leading large multi-resource teams with interdependent initiatives to successful completion. Capable of working proficiently at both strategic and tactical aspects of a project.
· Ability to code complex programs and derive logical processes.
· Commanding knowledge of current industry database standards such as Web Services, Object Oriented Development, Collaborative development techniques as well as knowledge of Project management discipline within Information Technology field.
· Capable of communicating in both verbal and written form to the level of published. 5-7 Years |
|
Contact
|
734-446-6948 rdhar@infotreeservice.com Rick Dhar |
|
Job Title
|
Director of Software Development and Technology
|
|
Company
|
|
|
Date Posted
|
2/3/10
|
|
Status
|
Open
|
|
Description
|
A CAREER WITH THE MMOG INNOVATOR AND DEVELOPER/PUBLISHER OF ONLINE FAMILY-FRIENDLY GAMES.
We are looking for a Director, Development that plans and implements technical services and solutions to support product development and production infrastructure. The incumbent may direct the installation, deployment, configuration and administration of games serving computing systems.
We are Nexon America Inc., the North American publishing arm of Nexon Group (1994), a pioneer of interactive entertainment software and the world’s leader in massive multiplayer online games which it developed and introduced in 1996.
Nexon America opened for business in Los Angeles in 2005 to bring the best of online entertainment to North American audiences. The company’s growing library of titles includes the world-famous franchise MapleStory, the role playing fantasy life of Mabinogi and the online multiplayer first-person shooter Combat Arms.
Responsibilities:
· Owning the technical relationship with one or more external partners
· Making certain reliable processes are in place to ensure quality and predictability
· Provide the best solution for technical problems in all areas(software, database, web)
· Provide technical due to diligence in support of finding great developers
· Directs and controls the technology and infrastructure function for product development, production and games serving.
· Accountable for developing and implementing technology and infrastructure plans, architecture and applications that support and anticipate developments in product development, production and online games operations.
· Ensures that architectures and applications can be applied efficiently to new products with minimal re-engineering or customization.
· Directs the research, design and implementation of state of the art applications and database technologies.
· Directs the evaluation of new games serving and related computing technologies.
· Directs the technical administration and support of servers and infrastructure.
· Directs systems programming, quality assurance and test server deployment configurations.
· May direct the development and deployment of systems security plan.
· Participates in ensuring that investments in technology infrastructure are appropriate to developments in the industry and deliver satisfactory returns.
· Sets and manages achievement of short-term operating objectives and provides input into the strategies and objectives
· Directs and assigns work to a staff of managers.
· Ensures the ongoing training and development of direct reports.
Qualifications:
· Bachelor’s degree in Engineering or a related field
· 10+ years professional applicable technical and leadership experience
· Experience leading an internal development teams
· Strong coding skills and ability to solve technical problems
· Technical vision and the ability to turn that vision into reality
· Ability to travel both domestically and internationally
· Experience leading an external development team
· Proven ability understand customer needs / pain points and create solutions to meet them
· Excellent communication skills
· Prior experience working for software development, code qualify control experience
· .NET based development experience (Plus)
· Proven capabilities for completion of complex projects on schedule and within budget
· Ability to identify and assign resources toward specific product initiatives
· Strong leadership skills (including active listening skills, presentation skills) and proven ability to work effectively in a collaborative environment
· Proven business acumen with general management perspective
· Demonstrated ability to manage internal and external “vendor” relationship
· High degree of initiative and self motivation
· Effective and motivational leader of others; team facilitation skills
Prior experience working in the online gaming industry, a plus
|
|
Contact
|
Qualified candidates please email your (1) Resume (2) Cover Letter and (3) Salary history/requirements to: now-hiring@nexon.netwith Director, Development in the subject line.
|
|
Job Title
|
Manager, Web Development
|
|
Company
|
|
|
Date Posted
|
2/3/10
|
|
Status
|
Open
|
|
Description
|
A CAREER WITH THE MMOG INNOVATOR AND DEVELOPER/PUBLISHER OF ONLINE FAMILY-FRIENDLY GAMES.
The Manager, Web Development will lead of a team of Web Developers and work closely with a cross-functional team of Software Engineers, Database Engineers, Web Designers, and Application Developers to design and create innovating cutting-edge features for casual games and e-commerce. The individual will direct the design and implementation of features from concept to completion, driving IT design and usability while addressing performance and scalability challenges. Manager and team of web developers will be responsible for tracking, documenting, reproducing and correcting problems, as well as versioning and building internal and external releases.
We are Nexon America Inc., the North American publishing arm of Nexon Group (1994), a pioneer of interactive entertainment software and the world’s leader in massive multiplayer online games which it developed and introduced in 1996.
Nexon America opened for business in Los Angeles in 2005 to bring the best of online entertainment to North American audiences. The company’s growing library of titles includes the world-famous franchise MapleStory, the role playing fantasy life of Mabinogi and the online multiplayer first-person shooter Combat Arms.
Responsibilities:
· Direct the design and creation of innovating cutting-edge features for casual games, portal and e-commerce.
· Direct the design and implementation of features from concept to completion
· Tracking, documenting, reproducing and correcting problems
· Act as a lead for Web Development team, ensuring overall projects/deadlines are met for all members of the team.
· Versioning and building internal and external releases
· Researching current and new technologies as necessary for designing and implementing new software components
· Perform special projects as directed by the Director, Web Services
Qualifications:
· Minimum 5-7 years experience of web development experience
· Minimum of 3 years experience in managing technical web development professionals
· Bachelors degree in Computer Science or related field
· Experience developing complex Web application as portal site
· Experience developing complex ASP.NET
· Experience building C# applications
· Strong knowledge of Web traffic optimization.
· Strong knowledge of HTML, XHTML, CSS
Ability to lead a team of web developers
|
|
Contact
|
Qualified candidates please email your resume and salary history to: now-hiring@nexon.net with Manager, Web Development in the subject line.
|
|
Job Title
|
Senior Database Administrator
|
|
Company
|
|
|
Date Posted
|
2/3/10
|
|
Status
|
Open
|
|
Description
|
A CAREER WITH THE MMOG INNOVATOR AND DEVELOPER/PUBLISHER OF ONLINE FAMILY-FRIENDLY GAMES.
The Senior Database Administrator is responsible for the planning, maintenance and development of a database. This person will ensure that data remains consistent across the database, it is clearly defined, users access data concurrently in a form that suits their needs, and there is provision for data security and recovery control. The Database Administrator is responsible for the environmental aspects of a database which include recoverability, integrity, security, availability, performance, and development and testing support. This person must have skills that are necessary to lead the organization in successful design, implementation, and administrator of SQL Server 2008 MySQL databases.
We are Nexon America Inc., the North American publishing arm of Nexon Group (1994), a pioneer of interactive entertainment software and the world’s leader in massive multiplayer online games which it developed and introduced in 1996.
Nexon America opened for business in Los Angeles in 2005 to bring the best of online entertainment to North American audiences. The company’s growing library of titles includes the world-famous franchise MapleStory, the role playing fantasy life of Mabinogi and the online multiplayer first-person shooter Combat Arms.
Responsibilities:
· Planning data flows for a new or revised database
· Mapping out the conceptual design for a planned database in outline
· Documentation for change management
· Considering both back end organization of data and front end accessibility for end users
· Testing new systems
· Maintaining data standards
· Controlling access permissions and privileges
· Ensuring that storage, archiving, backup and recovery procedures are functioning correctly
· Communication regularly with technical, applications, and operational staff to ensure the database integrity and security
· System Architecture and Data Modeling
· Other duties as assigned by the Development Manager
Qualifications:
· 5+ years relative experience, preferably with gaming industry experience
· 4 year college degree in Computer Science or related field
· Strong communication skills
· Ability to lead and train department employees to enhance their technical knowledge / skills
· Ability to utilize at least 2 different RDBMS to the fullest extent
· Proven hands on experience is required
Willingness to work additional hours and travel when needed
|
|
Contact
|
Qualified candidates please email your (1) Resume (2) Cover Letter and (3) Salary history/requirements to: now-hiring@nexon.net with SR. DBA in the subject line.
|
|
Job Title
|
Web Developer
|
|
Company
|
|
|
Date Posted
|
2/3/10
|
|
Status
|
Open
|
|
Description
|
A CAREER WITH THE MMOG INNOVATOR AND DEVELOPER/PUBLISHER OF ONLINE FAMILY-FRIENDLY GAMES.
The Web Developer will work directly with a cross-functional team of Software Engineers, Database Engineers as well as Application Developers to design and innovate cutting-edge features for casual games and e-commerce. This person will assist in designing and implementing features from concept to completion, driving IT design and usability while addressing performance and scalability challenges. He/she will be responsible for tracking, documenting, reproducing and correcting problems, as well as versioning and building internal and external releases. The Web Developer must stay current and learn new technology as necessary for designing and implementing new software components.
We are Nexon America Inc., the North American publishing arm of Nexon Group (1994), a pioneer of interactive entertainment software and the world’s leader in massive multiplayer online games which it developed and introduced in 1996.
Nexon America opened for business in Los Angeles in 2005 to bring the best of online entertainment to North American audiences. The company’s growing library of titles includes the world-famous franchise MapleStory, the role playing fantasy life of Mabinogi and the online multiplayer first-person shooter Combat Arms.
Responsibilities:
- Design and innovate cutting-edge features for e-commerce.
- Assist in designing and implementing features from concept to completion
- Tracking, documenting, reproducing and correcting problems
- Versioning and building internal and external releases
- Researching current and new technologies as necessary for designing and implementing new software components
- Perform special projects as directed by the Senior Software Engineer and Development Manager
Qualifications:
- Minimum 2-3 years of documented experience
- Bachelor’s degree in Computer Science or related field
- Experience developing complex ASP.NET and SQL systems
- Experience building C# applications (object oriented technical skills)
- Ability to do outstanding work both individually and as a part of a team
- Must be willing to work additional hours as necessary
- Strong willingness to enhance one’s technical knowledge base via self study methods
Strong communications skills
|
|
Contact
|
Qualified candidates please email your (1) Resume (2) Cover Letter and (3) Salary history/requirements to: now-hiring@nexon.netwith Web Developer in the subject line.
|
|
Job Title
|
Software Engineer – Game Platform
|
|
Company
|
|
|
Date Posted
|
2/3/10
|
|
Status
|
Open
|
|
Description
|
A CAREER WITH THE MMOG INNOVATOR AND DEVELOPER/PUBLISHER OF ONLINE FAMILY-FRIENDLY GAMES.
The Software Engineer is responsible for design, implementation, and support of engineering endeavors for Nexon’s online game server operation. The Software Engineer will design solutions to address performance and scalability challenges created by Nexon’s rapidly growing user base, and he/she will also be responsible for resolving various operation issues and building internal and external releases.
We are Nexon America Inc., the North American publishing arm of Nexon Group (1994), a pioneer of interactive entertainment software and the world’s leader in massive multiplayer online games which it developed and introduced in 1996.
Nexon America opened for business in Los Angeles in 2005 to bring the best of online entertainment to North American audiences. The company’s growing library of titles includes the world-famous franchise MapleStory, the role playing fantasy life of Mabinogi and the online multiplayer first-person shooter Combat Arms.
Responsibilities:
· Set up and maintain game servers and databases
· Optimize performance of servers by analyzing game server traffic, generating reports, and implementing optimization methods
· Troubleshoot errors and performance issues and work with senior members of the team for resolution
· Design and implement cutting-edge features for online games.
· Track, document, and resolve operation issues
· Build internal and external releases
· Perform special projects as directed by the Senior Software Engineer and Development Manager
Qualifications:
· BS in Computer Science or related field is a plus
· Strong knowledge of Windows OS and MS SQL server installation and configuration
· Good knowledge of TCP/IP networking, http, database and server optimization
· Ability to create, debug, and maintain complex scripts
· Familiarity with server performance analysis and tuning, QOS, and scalability issues
· Experience with popular MMO servers management desired
· Minimum 2-3 experience with object oriented programming in object oriented language
· Experience developing complex ASP.NET and SQL systems
· Experience building C# or C++ applications
· Experience administering and performance-tuning Windows systems, load balancers, etc.
· Strong troubleshooting skills
Strong communications skills
|
|
Contact
|
Qualified candidates please email your (1) Resume (2) Cover Letter and (3) Salary history/requirements to: now-hiring@nexon.net with SW Engineer Game Platform in the subject line.
|
|
Job Title
|
Sr. SQL Server DBA - Downtown Los Angeles - Fulltime Permanent Position |
| Company |
www.misicompany.com |
| Date Posted |
1/28/10 |
| Status |
Open |
|
Description
|
Hours: Monday-Friday 8:00am - 5:00pm (or 7am – 4pm; 9am – 6pm) on-call 7x24 (by rotation)
Position Summary:
The DBA will administrate all products and product family related to our Microsoft SQL Server environment, including SQL 2000, SQL 2005, and SQL 2008. General responsibility includes deploying migrations, ensuring server health, troubleshooting, applying service packs/hot fixes, manage and monitor server activities/processes, and performing database maintenance tasks. Provide developers design guidance, best practices, and design consideration for SQL Server related technology. Design and architect Disaster Recovery Planning structures for TCW and support the software implementations.
Aside from the overall administrative duties, the DBA will demonstrate his ability and aggressiveness in offering process improvement ideas and solutions. Constantly thinking of how to make our processes more efficient is the key to success in this position. Technical proficiency and constantly progressed in each area in Database Management and process automation has become a common philosophy the administrator should have.
Essential Job Responsibilities:
· Planning, commissioning, deploying software changes, performance monitoring and tuning, and maintenance of more than 50+ SQL Server instances. Provide 24/7 production support. Respond to request of database backup/restore, permission, change management, and deployments requests from Developers, Quality Assurance(QA) team, Business Analysts, and end users.
· Work with Windows OS, Storage, Network teams to perform database server commissioning, maintenance, problem analysis, and capacity planning for database growth. Perform database server upgrades and applying major services packs.
· Troubleshoot performance issues, provide recommendations on SQL Server Design schema and code changes.
· Design, implement, and support disaster recovery planning and implementation involving databases, including data replication using SQL Server log shipping, Database Mirroring, Database Replication, and 3rd party synchronization tools.
· Design, implement, and support SQL Server product family and technologies including Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Transact-SQL and batch development, scripting, SQL Server DTS, and SQL Agent environment. Perform monitoring and maintenance functions from backup/restore, index rebuilt, update statistics, to log and database size monitoring.
· Research and provide recommendations to other groups for technical solutions by providing facts through technical analysis and proactive thinking.
· Participate on major projects as member, responsible for critical project deliverable under minimal to no supervision.
· Responsible for designing, managing, and planning DBAs initiated projects and initiatives.
· Make recommendations on policy, procedure, and process improvement
Job Requirement:
· BA degree of Computer or IT related fields
· Minimum 6 years of IT experience and 5 year + as a developer or DBA
· Solid development experience with MS SQL Server 2000/05/08 product families including database design and data modeling.
Proficient experience with some of the following Microsoft SQL Server technologies:
o Analysis Services. (SSAS)
o Reporting Services. (SSRS)
o Data Transformation Services (DTS).
o Integration Services (SSIS)
o SQL Agent.
o Link Server.
o Replication.
o Database Mirroring
o Server Clustering.
· Scripting experience (T-SQL Query Language, VB, etc) required.
· Worked on all phases of software engineering/development lifecycle, from gathering requirements to writing design document, user manual, and migration plans.
· Must be an organized, accountable, self motivated individual, a self starter; enjoy working in a dynamic environment, team player, thorough and responsible. |
|
Contact
|
Robert Guan p: 323.261.3500 x 120 m: 626.274-7171 rguan@misicompany.com |
|
Job Title
|
Database Developer |
| Company |
www.ostechnical.com |
| Date Posted |
1/12/10 |
| Status |
Open |
|
Description
|
Outsource Technical is currently seeking a professional with SQL database expertise, as well as an Accounting background. This position will report to IT and work with the Accounting department to write SQL stored procedures to implement new functions for Accounting in Great Plains (consolidate billing, new revenue sharing, pay per sell invoicing, develop new GUI for invoicing). This position is responsible for designing and developing Schemas/Tables, Stored Procedures, Views, and queries against our various MS SQL Server databases.
Requirements include:
- Must have SQL experience writing SQL stored procedures
- Must have professional experience working in/with the Accounting department
- Great Plains experience is a plus
Essential Functions:
- Design and develop robust, scalable, database solutions
- Work with and develop the data warehouse for Great Plains and Accounting systems
- Create SSIS packages and ETL packages for data migration and streamline conversion
- Implement new business requirements and software changes as needed
- Assist with technical integration and test activities
Qualifications:
- 5+ years experience with SQL, T-SQL, Stored Procedures, Views, Schema design, and SQL Server 2005
- Solid experience with Great Plains is a desired
- ETL experience with SSIS or DTS is required
- Experienced implementation of SQL architecture and design principles
- Strong understanding of transaction isolation levels
- Strong Knowledge of SQL server replication
- Excellent understanding of the Microsoft SQL 2005 architecture.
- DBA level skills required (T-SQL, stored procedures/triggers, tuning)
- Strong verbal and written communications skills
- Solid teamwork and interpersonal skills
- Strong analytical, problem-solving and conceptual skills
Technical Experience:
- Great Plains Dynamics 10.0 is desired, but not required
- Business Intelligence / Data Warehouse
- SQL, Stored Procedures, Views, Triggers, Replication
- T-SQL
- .Net
|
|
Contact
|
Bri Pang | Office 310 658 7137 | Mobile 949 903 3292 bpang@ostechnical.com |
|
Job Title
|
SQL Server DBA - El Segundo, CA |
| Company |
Time Warner Cable |
| Date Posted |
1/6/10 |
| Status |
Open |
|
Description
|
Time Warner Cable in El Segundo, CA is currently looking for a Full/Time Database Administrator - SQL Server. The basic duties of this position are: administers a data warehouse environment including determining overall design, processes, procedures, safety/security, and storage/retrieval. Determines high-level business information needs and identifies system requirements.
Other Duties Include:
• Creates new MS 2000/2005/2008 databases including schema normalization, performance tuning, clustering, and load balancing. Works with reporting analysts, developers and other DBAs to plan, design, create and implement new databases. Resizes existing databases based on growth. Works with the application development and reporting teams to create in-line queries, stored procedures, indexes, triggers, DTS/SSIS packages. Provides recommendations around query methodology to ensure top performance.
• Performs all activities related to effectively maintaining and scaling the data warehouse to best meet end-user needs- from data sources through to end-user reporting and analytics.
• Creates reports using Microsoft Reporting Services, Analysis Services, and other standard and custom built reporting tools. Leads the design and implementation of reporting enhancements, as well as the building of data cubes.
• Ensures proper maintenance plans on all MS SQL databases including data backup, truncate logs, shrink databases. Determines optimal schedule for maintenance execution. Creates security policies for individual users and implements them with SQL Server Windows NT Authentication.
• 24X7 on-call support to respond to server outages and ensure system uptime and stability. Tracks progress of issues to ensure that any unresolved issues are completed in a timely manner or escalated to the appropriate individual based on established guidelines and procedures.
• Monitors server performance and health utilizing NT Performance Monitor, System Event log and other alerts to watch the database servers. Monitors important jobs through to completion after hours and on weekends.
• Performs migration of MS SQL databases and support jobs from SQL SQL 2000 to SQL 2005/2008. Converts DTS packages to SSIS packages.
• Installs and deploys new MS SQL database servers in stand-alone and clustered load balanced SAN environments on 32 bit and 64 bit servers. Creates and manages database servers with multiple instances of SQL server. Installs Oracle and other client tools. Designs and implements data extracts from multiple data sources (Oracle, SQL Server) for querying and import to MS SQL database systems.
The salary range begins at $59.4k - 89k annually- based on experience.~ We offer full benefits (medical, dental, vision, 401k and courtesy cable and internet and half off phone and much more). If you are interested, please visit our website at www.timewarnercable.com/careers to fill out an online application. |
|
Contact
|
Melissa Fernandes Melissa.Fernandes@twcable.com |
|
Job Title
|
Business Intelligence Analyst (Financial Analyst II), USC Care Medical Group |
| Company |
USC |
| Date Posted |
1/4/10 |
| Status |
Open |
|
Description
|
USC Care Medical Group is looking for a Business Intelligence Analyst with excellent analytic skills and the ability to quickly learn new technologies and concepts related to business performance management and reporting. This individual will join a highly skilled team currently developing a business intelligence platform that will be used to monitor and manage the critical business processes of a complex medical enterprise. USC Care Medical Group is the 600+ physician multispecialty private practice of the USC Keck School of Medicine. Together with our newly purchased facilities, University Hospital and the Norris Cancer Center, USC is creating a best of class medical enterprise. This new business structure is supported by an upgraded installation of our practice management system; a new consolidated accounting platform; and a business intelligence (BI) solution.
This position plays an integral role in the USC Care Business Intelligence unit. The BI analyst is responsible for developing analytic reports from relational and OLAP data sources reflecting key business indicators. The selected candidate will be actively involved in developing the analytic methods used in assessing business trends and patterns; and publishing interactive reports and report models to a web based enterprise business intelligence portal.
Core Responsibilities:
· Assist in developing key performance indicators for core USC Care business processes and design clear communication of performance measures via online reports, interactive analytic tools, and dashboards.
· Maintain an online catalog of strategic business reports including security updates and content changes.
· Assist in the development of training materials and programs for user groups accessing the USC Care BI system. Materials will be tailored to different user classifications based on security privileges and associated content.
· Conduct ad-hoc analyses for decision support related to strategic business issues.
Qualifications:
· Bachelor’s degree in Business Administration, Computer Information Systems/MIS, or other related discipline; Master’s degree preferred. Three to five years of experience in a business monitoring or reporting unit.
· Proven hands on experience working in an enterprise BI or data warehouse environment with a strong understanding of BI system development and best practices.
· Solid experience in the use of online report development systems, preferably MS Reporting Services.
· Strong understanding of the technologies and concepts involved in business intelligence system development with the MS SQL Server BI stack or a comparable software suite.
· Excellent written and verbal communication skills.
Interested candidates please contact William Bartlett, Director of BI: wbartlett@med.usc.edu |
|
Contact
|
William Bartlett 323.442.6913 wbartlett@med.usc.edu |
|
Job Title
|
MS SQL Server SSIS Opportunity |
| Company |
Capital Brands |
| Date Posted |
12/9/09 |
| Status |
Open |
|
Description
|
Capital Brands is seeking an experienced database developer for our team of professionals based in our West Los Angeles, CA office. The individual will work in a small team environment to develop mission critical OLTP Customer Service and OLAP financial reporting and Data Warehouse Custom Applications. All applications are written using thin-client architecture with a web front-end and SQL 2005 as the database back-end. The applicant can expect exposure to various classes of technology in solving challenging computing problems. The applicant will be involved throughout all phases of the software development lifecycle. This is not a DBA job and it is not a simple web application job - the focus is on data transformation, so strong Transact SQL skills and experience with SSIS are a must.
Technical Requirements:
* Minimum 3 years of Transact SQL experience
* Minimum 2 year of VB Script or VB.Net experience
* Minimum 2 years of web programming experience
* Knowledge and understanding of SQL Server Management Studio, Microsoft Visual Studio, Enterprise Manager, Query Analyzer and other MS SQL tools
* Highly motivated with a strong initiative
* Ability to complete work assignments quickly, accurately and on time
* Advanced troubleshooting and debugging skills
Functional Requirements:
* Excellent written and verbal communication and organizational skills to effectively work with all the members of the team.
* Ability to manage several projects with minimal supervision.
* Ability to work effectively under deadline pressure and meet customer expectations in a demanding environment.
* Willingness and ability to rapidly learn new skills
* Demonstrated success in creative problem resolution
* BS in Computer Science or related field or MCSD or MCDBA |
|
Contact
|
itjobs@capitalbrands.com |
|
Job Title
|
Sr. SQL Server Database Developer (near Santa Barbara) - $90,000-$120,000 plus employee benefits |
| Company |
Confidential |
| Date Posted |
12/7/09 |
| Status |
Open |
|
Description
|
Leading developer of online training solutions is looking for a Sr. SQL Server Database Developer (full-time position).
Job responsibilities include all tasks associated with being a SQL Server Developer, Administrator, Data Warehouse architect, and Reporting Services developer.
Key Requirements:
- 5+ years SQL Server 2005/2008 programming and administration for a high traffic e-commerce website
- Data Warehouse design and development
- Developing SSIS packages and developing reports using Reporting Services
- Designing star schemas and cubes
- SQL programming, T-SQL, triggers, stored procedures
- Building/maintaining SQL Server database replications
- Enhancing SQL Server database performance |
|
Contact
|
kathy.magel@yahoo.com |
|
Job Title
|
SQL DB Developer role working with SSRS, SSIS. This is a Contract position – pay rate is ideally $60/hr +/- DOE. |
| Company |
Confidential |
| Date Posted |
12/7/09 |
| Status |
Open |
|
Description
|
Ideally this person would have a problem solving mentality and be able to create tables and do some data mapping. The client would love someone who has experience working with SQL 2005/08, and who has experience working on 1TB + sized databases. |
|
Contact
|
Howard Braithwaite hbraithwaite@surrex.com |
|
Job Title
|
DATA ANALYST |
| Company |
Sony Pictures Entertainment http://www.sonypictures.com/ |
| Date Posted |
11/19/09 |
| Status |
Open |
|
Description
|
Sony Pictures Entertainment is a leading creator and distributor of entertainment products, services and technology. Our global operations encompass motion picture production and distribution, television programming and syndication, home video acquisitions and distribution, operation of studio facilities, development of new entertainment technologies and distribution of filmed entertainment in over 67 countries.
The DATA ANALYST will work within multiple databases to build queries and perform inventory analyses in support of the DISCOVER initiative.
DISCOVER (Data Integrity Supporting COntent Verification to Enhance Revenue) will manage multiple simultaneous initiatives to:
- Collaborate with mastering groups and the Digital Backbone Ingest Team to develop workflows to support SPE*s new component requirement for automated fulfillment
- Collaborate with the Lines Of Business (LOBs) and Worldwide Product Fulfillment (WPF) to review WPF*s current inventory and identify key manufacturing components (aka *componentization*) in support of sales & fulfillment
- Componentize, verify, and complete inventory metadata in the GOLD inventory management / ordering system
- Identify and backfill key manufacturing inventory missing from GOLD to support all WPF and Distribution Backbone workflows
* Translate business rules and practices into scripted queries
* Build complex data queries using corporate reporting tools to analyze inventory and identify key manufacturing components
* Perform inventory analysis, assist in determining asset record prioritization, and offer support with data entry
* Recommend data solutions to PM and GOLD Support based on findings
* Write SQL scripts to update asset inventory based on DISCOVER findings
* Create data compliance reports to ensure clean data after completion of DISCOVER projects
* Minimum 5 years data querying and analysis
* Ability to work with very large amounts of data
* Experience with report creation and the ability to present reports in various forms
* Software: Some programming knowledge, and expert skills in MS Access, Business Objects XI, Excel and MS Office package
* Ability to quickly learn business processes and understand department and manufacturing / post-production business rules
* Knowledge and understanding of the pioneering world of new media, digital workflows, and related technologies is desired
* Bachelor's degree preferred
As a global leader in creativity and innovation, Sony Pictures Entertainment draws upon the diverse backgrounds and perspectives or our workforce for continued success. Our respect for employee differences and focus on employee development encourages a progressive and rewarding work environment. In addition, SPE offers excellent benefits: medical, dental, vision, 401k, 10 paid holidays, plus much more. |
|
Contact
|
Damon_nicholls@spe.sony.com |
|
Job Title
|
SQL Server DBA - Downtown Los Angeles - Fulltime Permanent Position |
| Company |
www.misicompany.com |
| Date Posted |
11/5/09 |
| Status |
Open |
|
Description
|
Job Description:
We are seeking to hire a Jr. to Mid Level DBA with strong SQL programming and scripting background. The DBA will be part of a team that is responsible for the administration of 40+ MS SQL Servers. Administration tasks include daily monitoring routines, proactive monitoring of SQL Servers states, software patch management, query analysis, performance tuning, migrations of code to QA & Production, Disaster Recovery support, and server recovery. The DBA will assist in system design efforts with the development of system designs (both in-house and third party) and their integration into the routine maintenance and administrative schedules.
Duties:
- Administer Microsoft SQL Server 2000, 2005 and 2008 and related products. Ensure data availability, integrity, security and database server performance and efficiency. Design and implement disaster recovery processes and business continuity procedures, backup, restore and maintenance. Deploy application and database migrations.
- Provide 24/7 production support. Respond to database backup/restore, permission change, migration deployments requests from Developers, QA, Business Analysts and end users.
- Work with WOS, Storage, Network teams to perform database server maintenance, analysis and plan for database storage requirements, and perform database server upgrades and migrations.
- Troubleshoot performance issues, provide recommendations on schema and code changes.
- Design, implement and support disaster recovery with log shipping, mirroring, replication, and nightly sync processes.
- Design, implement and support DTS, SSIS and SQL Agent jobs to perform database backup, nightly and weekly maintenance.
- Research on new technologies. Install and test new software.
Experience:
- Minimum 2 years of SQL DBA experience; prior programming background preferred.
- Expert in T-SQL language; understand data modeling and physical database design for SQL Server required.
- Knowledge of SSIS, ETL tools or .NET programming experience.
- Experience with SQL Server log shipping, Replication, Reporting Services linked servers, Clustering, DTS packages, basic backup/recovery procedures, and SQL Server database and server configurations required. |
|
Contact
|
Robert Guan 323.261.3500 x 120 rguan@misicompany.com |
|
Job Title
|
Business Intelligence Contractor - San Fernando Valley, CA |
| Company |
http://www.omnikron.com/ |
| Date Posted |
11/4/09 |
| Status |
Open |
|
Description
|
Location: Predominantly Camarillo, Burbank and N. Hollywood - will be required to move between sites as needs demand
EXPERIENCE:
o At least two years of hands-on experience with Business Objects Webi XI
o At least three years IT experience
o Very good written and verbal communication
RESPONSIBILITIES:
o User support for N. America Home Entertainment and Creative Services applications. Business Objects Web Intelligence (Webi) version XI
o Troubleshooting reports and recommending improvements/fixes.
o Reporting and analytic requirements gathering & documentation (from end-user interviews)
o Business Objects Webi XI report development
o Business Objects Universe development
o Integrated testing of reports |
|
Contact
|
douglas.taylor@omnikron.com 818-223-4107 |
|
Job Title
|
SQL Server Database Administrator / Database Developer in Westlake Village |
| Company |
http://www.prosum.com/ |
| Date Posted |
11/3/09 |
| Status |
Open |
|
Description
|
This position's primary responsibility are: installation of new software, configuration of hardware and software, security administration, data analysis, database design, data modeling, database performance tuning and optimization, replications, backups and recovery, patches, proactively monitor systems for optimum performance and capacity constraints; develop layer of stored procedures that will represent core business logic, write complex SQL queries, develop database triggers and functions, establish standards and best practices for SQL; monitor and support BI systems and Data Warehouse (OBIEE), schedule ETLs, make changes to ETLs and monitor BI performance.
(30%) MS SQL DBA
(30%) MS SQL Developer
(10%) OBIEE DBA
(10%) Work with outsource companies.
Build and maintain relationships with software development vendors
Database administration/design experience with RDBMS
Experience with MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008.
Experience with additional RDBMS
Experience with MS SQL Server backup and recovery techniques
Proven experience in maintenance of SQL Server
Proven experience using Transact SQL, Stored Procedure and UDF
Experience with MS SQL Server DTS
Familiarity with SQL Server replication services and SQL Server clustered environment
Experience designing and implementing data warehouses, including experience with MS SQL OLAP services and Oracle OBIEE
Demonstrated experience in troubleshooting and resolving database problems
Demonstrated experience in tuning database and its objects
Understanding of databases indexes
Understanding of database design practices, including database normalization concepts
Prefer background in Microsoft networking
Proven ability to work within a team environment
Must be able to drive safely for local business travel
Must be able to sit for long periods of time
Bachelor's degree in Computer Science, Mathematics, Business Administration, Engineering or a related field. Appropriate additional experience beyond the minimum required experience may be substituted for education.
10+ years experience as MS SQL DBA
6+ years experience with SQL development, dynamic queries
3+ years experience designing, developing, and supporting data warehouses
Exposure to Oracle and OBIEE
5+ years experience with .NET environment
3+ year's practical experience in Data Modeling |
|
Contact
|
Jeff.Starling@prosum.com 949-732-1117 |
|
Job Title
|
Project Manager - Permanent Position - Universal City - Salary: 90-120k |
| Company |
http://www.partnersconsulting.com/ |
| Date Posted |
10/12/09 |
| Status |
Open |
|
Description
|
Ideal candidate must have the following skill set:
· Ability to manage complex software development projects and effectively report back to executive team
· Experience architecting and defining platform roadmaps
· Extensive experience developing web applications on ASP.NET in C#
· Extensive experience with Web Services (JSON, XML, SOAP, WCF, REST)
· Extensive experience with 3rd party APIs (web service APIs & proprietary .Net APIs)
· Strong understanding of Design Patterns & Practices
· Strong understanding of OOP
· Strong understanding of custom server controls
· Experience with CMS and CRM
· Visual Studio 2008 / SQL 2005 / .NET 3.5
Preferred:
· Experience managing and/or coordinating a diverse team of engineers across various departments
· Experience with projects in fast-paced, high traffic environment
· Experience with social network syndication and integration
· Experience with Subversion (Tortoise SVN & Ankh SVN)
· Solid frontend development skills (Javascript, jQuery, Ajax, CSS)
· Good understanding of ASP.NET MVC Framework
· Agile software development / Extreme Programming methodology
· Ability to work under pressure and tight schedules
· Experience working within the Entertainment industry; experience with Music Business a plus
Responsibilities:
- Define, develop and architect solutions related to in-house infrastructure and third-party commerce platform
- Manage and lead development of various engineering projects pertaining to core platform development
- Provide engineering/development expertise for various other projects/platforms related to distribution of UMG metadata and media assets
- Provide technical due dilegence oversight across various online and mobile initiatives
- Co-develop additional platform solutions related to various Label needs and priorities
- Establish and communicate best practices and serve as primary contact for development projects underway within the corporate group vis-a-vis each Label group.
- Manage cross-label and cross-department weekly technical meetings as well as associated project roadmaps and schedules |
|
Contact
|
Chris Hill, Sr. Technical Recruiter, 800-732-4680 x711 CHill@PartnersConsulting.com |
|
Job Title
|
SQL Server DBA - Irvine, California |
| Company |
Dynamic Healthcare Systems in Orange County |
| Date Posted |
10/7/09 |
| Status |
Open |
|
Description
|
Dynamic Healthcare Systems is one of the leading healthcare information technology companies. We are a fast-paced environment, located in Irvine, close to John Wayne Airport.
This position will be responsible for ensuring the quality of data from customers and monitoring the data as it is processed by the Voyager application. In addition, this position will also handle data translation requirements, testing and software configurations.
The ideal candidate will have 2+ years experience querying and managing data in a relational database, at least one year data mapping and translational skills experience, coupled with at least one year of creating and maintaining ACCESS and SQL databases. The successful candidate will be competent with MS-SQL. Experience with Pervasive Data Loader is valued, but not required. This person will thrive in an environment of empowerment and teamwork, while enjoying a stimulating and casual work environment where commitment and drive are rewarded. |
|
Contact
|
Andrea Larsen andrea@innovativeics.com (949) 310-1215 (mobile) |
|
|
|
|
|
|
| DotNetNuke® is copyright 2002-2010 by DotNetNuke Corporation |
|