Wednesday, April 07, 2010

Cricket Communications - Engineer Software III Database

Cricket Communications, a subsidiary of Leap Wireless headquartered in San Diego, CA, is an affordable wireless service providing flat-rate unlimited products over high-quality, all-digital wireless networks that feature the latest technology. Cricket serves customers across the United States and is a pioneer of unlimited wireless services with no long-term commitments or credit checks required. Cricket offers customers access to a variety of the latest phones and mobile applications such as unlimited text, instant and picture messaging, Mobile Web, popular games and ring-tones.
We are a fast growing, entrepreneurial, fast-paced, fun place to work. We offer competitive pay; performance-based bonuses; free mobile phone and service; paid time off; and advancement opportunities.
Cricket values diversity and inclusion - when everyone is included, the possibilities are UNLIMITED! To learn more about other career opportunities, Cricket Culture and benefits please visit: http://www.mycricket.com/aboutcricket/careers/.

Job Summary

This position involves designing and developing database objects (e.g. tables, views, functions) to support front end OLTP and reporting applications. The ideal developer will have thorough knowledge of SQL (T-SQL, PL/pgSQL), experience with at least one other SQL language (e.g. PL/Perl), and extensive experience with complex functions, code optimization, and index tuning in SQL. This position requires a senior level developer with extensive database design and coding experience to help architect, design and develop databases using Microsoft SQL Server technologies. Must have the ability to effectively communicate with customer managers and executives on technical and business issues, and work with other disciplines (Program Management, QA Team, Technical Operations, other Software Development Engineers, and various business owners) in implementation of analytical and technical solutions; review project plans, development and test specifications; communicating implementation limitations; and data-driven solutions with all levels of project team and management. Qualifications must include thorough experience with Microsoft SQL Server in a mission-critical environment. Relies on experience and judgment to plan and accomplish goals. May lead and direct the work of others. A wide degree of creativity and latitude is expected.

Essential Functions

System Design. Designs database applications to support business priorities such as online customer provisioning and customer support.

•Defines functional requirements from business requirements.

•Intermediate creation of logical data models.

•Translates logical data models into physical database designs.

•Implements efficient databases, including specifying physical characteristics, designs efficient indexes and maps database objects to physical storage devices.

•Analyzes data access and modification requirements to ensure efficient SQL and optimal database design.

•Develops alternate designs and analyzes trade-offs that trigger iteration of the design process.

•Creates prototypes.

•Intermediate creation of design and interface documents for application development

Programming and Implementation. Develops, refactors, tests, and deploys database applications following the Software Development Life Cycle.

•Intermediate development of robust and fault tolerant database objects to include stored procedures, User defined functions, and triggers.

•Implements best practices to incorporate data related requests into enterprise applications.

•Manages configuration/source code for all application code developed.

•Intermediate inspections of code and code documentation, revising as necessary to meet standards.

•Leads small project teams; may delegate tasks to junior team members and contractors.

•Advanced development of database deployment and rollback scripting.

Project Management. Develops comprehensive project plans coordinating with parties internal and external to IT.

•Basic development of requirements definition, work breakdown structure, GANNT charts, and other project documents associated with the management of requirements, tasks, schedule, milestones, dependencies, and resources.

•Basic management of project, coordinating and executing project plans.

•Responsible for the successful completion of the project.

System Analysis and Architecture Planning. Plans application functionality, working with Senior IT Management team.

•Intermediate coordination with business users, managers, and other system designers/developers

•Understands and translates conceptual business ideas into technology architecture and specifications

•Intermediate architecture of logical, modular designs and physical systems.

•Intermediate definition of system interfaces, working in conjunction with other technology groups.

•Basic planning and technical direction for projects.

•Recommends and evaluates new products and technologies

System Operations. Develops operations support requirements, standard operating procedures, operations guides, checklists, and other process related documents to enable the operations team to support any applications developed.

Standards of Practice. Develops standards and procedures for applications - software, programming, testing, documentation, and security. Follows standards of practice and best practices for application design. Also, assists in the development of long and short range planning.

Education

Required: BS degree in CS, related discipline or relevant work experience


Industry Experience

Required: Telecom or related High Tech

Preferred: Telecom, Wireless, High Tech


Job Experience

•3-5 years experience in development of MS SQL Server Stored Procedures and other T-SQL code.

•3-5 years hands on experience in logical and physical data modeling.

•3-5 years experience in architecting, engineering, and designing large scale database applications, including a strong understanding of SDLC.

•3-5 years experience designing and writing robust, extensible, high-quality SQL code that meets business, technical and quality requirements.

•Intermediate skills in database performance tuning.

•Intermediate skills using replication in a MS SQL Server environment.

•Intermediate skills in database development methodologies, design and implementation.

•Intermediate project management experience including planning, scheduling and tracking projects.

•Technical writing/documentation skills including data structures, application code, user manuals, etc.

•Intermediate organizational, communication, and interpersonal skills and ability to communicate with managerial, administrative and technical staff to determine information needs, process/data flows and systems definitions

•Intermediate Knowledge of:

•T-SQL

•MS SQL Server 2000/2005

•Visual Studio 2005

•ERWin

•Redgate

•XML, XSD

•CVS, SubVersion, DOORS, Synergy


Preferred

•Experience in a management or team lead role

•Experience with Windows Server environments.

•Experience with database clustering, and other high availability best practices.

•Experience with database high availability design and best practices.

•SQL Server Integration Services

•SQL Server Reporting Services

•C#, ADO.NET Development, LINQ

•Oracle, Oracle 10G, PostgreSQL, Enterprise DB, MS SQL Server 2008.

•Visual Studio Team Foundation for Database Professionals.

•PL/PGSql

•UNIX (Solaris, FreeBSD)

•Linux (Redhat, Ubuntu, Debian)

•Hands on experience in a Services Oriented Architecture or ESB environment.

•Hands on experience with test driven development

Our full-time employees enjoy the following benefits:


•Medical, Dental and Vision

•Domestic Partner Coverage

•Company Paid Life Insurance

•Company Paid Dependent Life

•Company Paid Disability

•3 Weeks Vacation

•Sick time

•Holiday Pay

•Jury Duty Pay

•Travel Accident Insurance

•401(k) with Company Match

•Employee Assistance Program

•Tuition Assistance

•Flexible Spending Accounts

•Adoption Assistance

•Fitness Reimbursement

•Group Auto & Home Insurance Discount

•Discounted Phones & Service for Immediate Family

We are proud to be an EEO employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing.

We are proud to be an EEO employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing.