Friday, August 27, 2010

Cricket - Admin Database IV

Cricket Communications is a leading provider of innovative and value-driven wireless communications services. Headquartered in San Diego, with a commitment to predictability, simplicity and value as the foundation of our business, Leap pioneered Cricket® service, a simple and affordable wireless alternative to traditional landline service.

We believe the future is bright for Cricket and look forward to the challenges as we execute our plans to support the growth of our business. Cricket Communications has multiple opportunities for individuals looking to contribute to an organization that rewards your success.

Position Overview :

Responsible for designs, installs, maintains and upgrades development, test and production databases using expertise in database administration, database monitoring, tuning, logical data modeling, and physical database design for Oracle. Successful candidate understands the principles, theories, practices and techniques of the systems development life cycle, database design, routine maintenance, process scheduling, security, and backup/recovery. This position is accountable for the overall performance of the enterprise's database environments. Works closely with multiple departments including application developers to define and resolve information flow and content issues.

1) Responsible for basic management and support of high performance and highly available database platforms and systems. Managing multiple Production, Development and Test Oracle database environments of different releases. Proactively monitors the database systems to ensure secure services with minimum downtime
2) Responsible for troubleshooting and problem solving of Oracle development including code reviews to ensure that developed database code is in compliance with the Cricket standards. Responsible for implementation and release of database changes according to CCB
3) Responsible for Oracle database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance. Responsible for ensuring availability and performance of the databases that is the backbone for Cricket's success.
4) Responsible for the installation, configuration and maintenance of database instances including backup and recovery
5) Produces reports and queries on ad hoc basis. Validates the findings and results against requirements and ensures proper scope and access to data. Confirms and documents positive destruction of obsolete data.

Required : Bachelors' degree in Computer Science, technical discipline, or relative work experience
Administration and design in a large 24x7 SQL Database environment

Preferred : MSDBA, Wireless, telecommunications, high tech, distributed corporate environment

• 7+ years experience with Oracle and strong knowledge of Oracle 10G/11gR2
• Experience with performing database administration tasks including Oracle installs and patches, setting Oracle configuration parameters
• 2 + years experience with Enterprise Billing Systems, Point of Sales and Order Management
• Must have Oracle backup and recovery experience
• Excellent Performance Tuning Experience
• Familiarity with Oracle 10G/9i features
• Understanding of UNIX and Linux Operating systems and shell scripts
• Organizational, communication, and interpersonal skills. Candidate must be able to work both independently and as part of a of a development team to accomplish overall plans and objectives.
• Experience with troubleshooting & monitoring OLTP/Data warehouse Oracle servers
• Database upgrade/migration
• 24 x 7 production support and support functions such as checking for table free space, checking for fragmentation, checking on nightly/weekly backup status on a rotating schedule
• Capacity planning experience
• Have prior knowledge of change control systems
• 2+ years of Oracle RAC experience
• Extensive experience in setup/configuration/maintenance of physical standby databases and Data guard switch over/fail over scenarios
• experience in administering large databases (TB in size)
• Must have a solid understanding of Oracle streams / advanced replication.

Preferred :

• Experience with Data Integrator and Business objects would be definite plus
• Understanding of Linux and Unix operating systems
• Understanding of SOX compliance and scope