SQL DBA / DEVELOPER in Chicago, IL
Our client in Downtown Chicago requires a SQL DBA /Developer. The Database Administrator’s primary responsibility is to provide hands-on support in the design and development of all Relational Database Management Systems. This includes all development, staging and production database servers and applications. Responsible for SQL Server 2000 installations including setup, configuration and service pack and hot fix installation. Applying knowledge of the latest enterprise security concepts to production systems. Managing database performance optimization and capacity planning and look for tuning opportunities. Installing and configuring SQL Server software onto new servers and upgrade existing SQL Server software to newer versions and/or Service Pack Levels. Maintaining database security, integrity, and availability. Setting up and monitoring alerts, operators, SQL Mail, linked server connections, DTS packages, and scheduled jobs that perform specific database tasks. Assisting with the extraction, transformation, and loading (ETL) of data from disparate sources and ensure its integrity. Interface with the IS Infrastructure team for hardware upgrades and builds. Administering periodic backups of databases and transaction logs. Developing and maintaining database recovery plan. Collaborating with developers on creating, debugging and deploying Stored Procedures, Custom DTS Jobs, tables, indexes, triggers etc. Creating automated TSQL scripts to process summary database transactions that run off-hours. Running ad-hoc reports from the databases. Creating, Monitoring and managing the periodic EXCEL spreadsheets that deliver data to the various business owners. This is an ongoing recruiting effort by Robert Half Technology.
<br/><br/>All applicants applying for U.S. job openings must be authorized to work in the United States. All applicants applying for Canadian job openings must be authorized to work in Canada.
Experience: A Bachelors degree in computer science or related discipline, or equivalent experience is required. A minimum of 3-5 years of Database Administration experience with SQL Server 2005 is preferred. 5 years DBA experience with Microsoft SQL Server 2000 in an operations environment. Experience supporting and implementing complex logical database designs and relational database concepts. A minimum of 3 years Transact SQL experience with an advanced ability to analyze and architect data and data models/schema. Candidates should also have 5 years of SQL Server administrative experience including managing multiple database servers. Data modeling experience (ERWIN) or equivalent preferred. Excellent written and verbal communication and presentation skills. Effective analyst able to work closely with non-technical users. Previous experience in a professional society, trade association or healthcare management preferred. Ability to explain complex subjects to the audience with wide variety of technical skills. Be driven by the desire to achieve measurable, specific results within tight time frames. Commitment to excellence in customer service is required.
To Apply to this job go to http://www.GadBall.com or click here