US-CA-FOSTER CITY: Database Engineer/Administrator

To see other opportunities, please visit http://dba.fyicenter.com/
Date: 31-Mar-2008

Database Engineer/Administrator

Essential Duties and Responsibilities

* Design, implement, and maintain high-performance, scalable database applications.

* Research and resolve technical issues raised by application developers, testers, or customer support.

* Performance tuning and optimization of software applications and databases.

* Design and develop data migration procedures for application version upgrades.

* Perform data modeling, logical and physical database design based on knowledge of modeling techniques, modeling tools available on the project, and business functions of the system.

* Create system documentation, for use by engineering and customer support teams.

* Work with team members to evaluate new database features.

* Perform periodic MS SQL Server 2005 database administration including tasks such as implementing and maintaining database instances, loading data, managing data security and user access, performance monitoring and tuning, data integrity, backup, recovery, and user support.

* Software development about 50%, performance and scalability about 25%, and database administration about 25%.

Skills and Qualifications

Technical/Functional Requirements

* Experience writing stored procedures, triggers, and views.

* Data modeling experience, with attention to normalization, data element names, and data types.

* Competent at creating documentation for database tables and SQL procedures.

* Experience troubleshooting performance issues: performance monitoring, fine tuning stored procedures and SQL, application performance optimization, scalability testing, and database tuning.

* Experience developing ETL to migrate data from legacy data stores and SQL databases.

* Experience with migration tools such as DTS, DBArtisan, Informatica, or others.

* Experience in installing, configuring, and administering MS SQL Server databases in development and production environments.

* Experience in job scheduler, data transformation services, SQL connectivity technologies, and SQL query analyzer.

* Experience in backup and restore plan and experience in troubleshooting and monitoring SQL Server. Writing scripts and creating scheduler jobs to automate these tasks.

* Experience in sizing databases for transaction and data volumes.

* Experience with software source control tools.

* Experience working with XML data and tools.

Desired Technical/Functional Experience

* Experience with C# ASP.NET, and the .NET framework a plus.

* Reporting Services experience a plus.

* Analysis Services experience a plus.

* MS Windows Server OS experience a plus.

* Database and OS security experience a plus.

* Experience in setting up disaster recovery a plus.

* Experience with clustering/load balancing and replicating MS SQL Server databases a plus.

Job Experience Requirements

* Six or more years of experience in relational database design, application development, and database administration.

* Four or more years of experience with MS SQL Server 2000/2005.

* Experience working with large production databases, on the order of one terabyte.

* Experience working with both OLTP and OLAP systems.

* Two or more years experience in data warehousing

Education

* BA/BS in Computer Science or Software Engineering (or equivalent experience)

To apply for this position, please visit this Website.

Thank you,
DBA FYI Center
http://dba.fyicenter.com/