Surfline logo

Database Administrator

Huntington Beach, Calif.
No longer accepting applications
Visit the pageSurfline

Date Posted: April 17, 2003

Job Description

This is a hit the ground running type of position with lots of daily demands. Most of the people that are missing the mark are overqualified generalists not DBAs. We need someone that is the groove with SQL. Operating in the DBA capacity
now and wanting to focus in that role going forward. And experience in a high transaction volume environment would be great.

We don't want network administrators or software developers, unless they are developing database software apps. We are open to people out of work, but if they have been out too long, they could be too rusty for us.

The following is a detailed job description that will assist you in deciding if you meet the more particular qualifications.

GENERAL SUMMARY: The Database Administrator will work within the IT and Engineering teams to maintain all database systems supporting the Surfline Network. Candidates for this position will need to be ready for extremely high levels of transaction processing (OLTP) and complex database interaction. As a Database Administrator you will be responsible for making sure schemas are normalized properly, data integrity is enforced, queries, SPs and indexes are optimized, archiving is on track, and data transfers happen consistently and reliably. Also, the DBA will be responsible for scheduling Backup and Maintenance Plans, as well as integrating the database with other non-SQL-based systems. The Database Administrator will take full responsibility for setting and maintaining security levels and policies within the databases, as well as for maintaining their consistency while also allowing for flexibility in supporting various applications and users.


ESSENTIAL DUTIES & RESPONSIBILITIES:

·Maintain 24x7x365 uptime with a goal of 99.999% transaction availability
·The Database Administrator must be available 24/7 for emergencies or scheduled maintenance
·Tweak and Optimize database systems
·Schedule and perform all data transfers and data recovery
·Lead/contribute to implementation of in-house projects to support corporate and site wide initiatives
·Ensure Quality Assurance during final phases of testing to make sure that Database components of new features and software are ready and optimized for release. Implementation of (DTS).
·Write ad-hoc SQL queries to support management and other users
·Provide operational support for the database and as it relates to business objectives
·Learn the business rules enforced through the database (via stored procedures, DTS packages and cold fusion code) and ensure the data in the database is matching those rules.


ORGANIZATIONAL RELATIONSHIPS:

Although primary responsibilities are geared towards the development and maintenance of databases, it is not uncommon for the DBA to help with minor programming tasks, such as for Admin Tools, etc. Often supporting the needs of Surfline content editors, this person will need to provide the DBMS knowledge and services to help maintain existing applications. In the event of system downtime, this person communicates with equipment and Networking services vendors to ensure speedy resolution of issues.

REQUIRED QUALIFICATIONS:

1) Knowledge, skills & abilities:

·Strong T-SQL skills
·Experience creating and maintaining Stored Procedures and DTS packages is a must
·Proficiency in networking concepts (Windows NT 4.0 and Windows 2000 Server) required
·Knowledge of Object Oriented programming concepts/languages preferred
·Data modeling tools such as Erwin and OOD/UML tools such as Rational Rose a plus
·Experience in Cold Fusion programming
·Some familiarity with Solaris and Linux operating systems preferred
·Solid communications, team and interpersonal skills required.

2)Minimum education level:
·BA/BS in CS/EE or other technical discipline required
·Certification in SQL 7 strongly preferred.

3)Experience:
·2-4 years experience with MS SQL Server 7 required
·1-2 years experience with web programming technologies, such as ASP, VBScript, JavaScript, CGI, Perl preferred.

This position description intends to describe the general nature and level of work being performed by people assigned to this job. It is not intended to include all duties and responsibilities. The order in which duties and responsibilities are listed is not significant.

Please send resumes through Malakye.com