SQL Server Developer/DBA

Emmis Interactive is seeking an experienced Database Developer / DBA with a minimum of 5 years experience, to participate in the development of new online products and services supporting the company’s various media properties/affiliates.

Responsibilities

• Create, implement, and maintain database tables, stored procedures, and user defined-functions using Microsoft SQL Server 2005/2008 to provide the all of the database functionality in an n-tier environment supporting online real time applications and batch-oriented processing.
• Work closely with our team of Web developers (using an Agile development process) to assist in the development of the data tier of online real time applications.
• Importing structured and unstructured data from various sources.
• Ensure that development, QA and Production systems are available and in the correct configuration with the correct data for standard Development / QA / Production life cycle.
• Ensure data integrity, data retention, backups, and disaster planning in support of all applications and database environments.
• Participate in rotating on-call emergency support schedule and occasional late-night system maintenance and code deployment events.

Requirements

• Bachelor of Science degree in Computer Science or related field.
• Minimum of 5 years progressive responsibilities in Microsoft SQL Server database administration, maintenance, and development.
• Must be experienced creating databases, tables, stored procedures, and user-defined functions.
• Must be experienced at importing exporting data in multiple formats using SSIS, DTS, T-SQL, and bcp.
• Demonstrated expertise in query optimization and tuning, including cross database and cross server queries.
• Experience with Visual Studio Team System for Database Professionals / Visual Studio Team System Database Edition 2008 preferred.
• Experience participating in a formal software development lifecycle, preferably using an Agile methodology.
• Experience working with SQL Server Reporting Services and other standard reporting mechanisms.
• Experience working with data warehouses/data marts using Microsoft Business Intelligence technologies.
• Solid understanding of Microsoft SQL Server Architecture (SQL Server 2005/2008).
• Ability to manage all database maintenance activities including backups, indexing, integrity and consistency checking.
• Knowledge and experience in administration of SQL Server database environments (optimization/tuning/backup/recovery), including SQL Server Integration Services, clustering, log shipping, replication and other advanced SQL Server implementations.
• Experience running and supporting large scale database environments (1+ TB size) under high transaction volumes.
• Experience in database administration in 24x7x365 high traffic Internet applications environment.
• Thorough knowledge of current hardware systems, RAID and disk subsystems (including SAN technologies and blade server systems) commonly used in fault tolerant production environments.
• Knowledge of Windows Server 2003/2008 operating systems.
• MCDBA preferred.

Advanced Profile

• Strong analytical skills and ability to create and maintain a database environment to support business requirements.
• Ability to work independently with minimal supervision.
• Must be a team player and able to meet deadline requirements.
• Good oral and written communication skills.
• Able to quickly isolate and resolve production performance problems.
• Strong initiative and problem solving skills.
• Experience participating in multiple projects simultaneously on diverse timelines.
• Clear and concise communication with management and other team members.

Click here for more details, and to send your information.