Database Administrator - Chicago in Chicago, IL
Analyzes, develops, tests and implements database designs in support of corporate and client area technology requirements. Performs data modeling, logical and physical database design. Includes maintenance of database dictionaries, monitoring of standards and procedures, access methods and time, validation checks, organization and statistical methods. Responsible for data loading, security, performance monitoring and tuning, capacity planning, and backup and recovery. Executes database software installation, database creations/configurations and loads.
Responsibilities: As a Database Administrator, you will administer, maintain and utilize policies and procedures for ensuring the security and integrity of the databases. Support production DBA in daily or emergency procedures to resolve issues. Lead the efforts of installing and maintaining database management software. Provide 7x24 DBA production support, work with DBA team for production oncall support rotation. Implement Database Change Controls & Service Requests. Resolve Database related trouble tickets assigned to the DBA group. You will work with the Information Architect and Database Designer to help implement the physical data model. Help develop and validate the database implementation plan. Create database objects and maintain their physical organization/relationships. Support the data loads into the databases. Ensure that the application, and any enhancements, interact efficiently with the database. Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities. Create/Implement database maintenance plan to ensure data integrity. Manage the on-site backup and recovery process and/or support the off-site backup and recovery teams. Plan for and execute any required database upgrades and migration (patches etc.)
Experience: Minimum 3 to 4 years of work experience as a Database Administrator for MSSQL.
. Experience with MSSQL 2005 and MSSQL 2000 products & MSSQL Replication server needed.
. Solid skills in database performance factors, monitoring tools and tuning procedures
. Strong Database Management skills, including backup and recovery procedures
. Solid skills in productivity factors and ability to understand impact of problem on overall database performance
. Knowledge of fault detection and resolution processes
. Solid skills with one or more programming language and design technique is desirable
To apply: http://www.gadball.com/job/20067315/database-administrator--chicago/?sid=18