Department: SQL DBA
Job Type: Contract and Full Time
Location: Westchester (near Oakbrook)
Overview of Database Administrator:
The Database Administrator (DBA) is responsible for the SQL Server administration and support of Microsoft SQL Server Databases, Database Instances and SQL Servers. Perform Backup and Recovery as required. Identify and resolve specific problems in the use and performance of systems. Provide DBA design and support services for establishing, upgrading and maintaining the Database environments. Candidate must know SQL DBA Fundamentals including basic troubleshooting, performance tuning, back-up, indexing, etc.. Perform SQL database administration tasks: - Monitoring and tuning all SQL databases to ensure high availability - Monitoring production databases and data processing jobs - Implementing and administering database replication - Troubleshooting performance issues and fine-tuning queries and stored procedures - Coordinating database checkpoint frequencies, archive logging, resource usage with programmers and system administrators - Creating capacity planning forecast - Establishing and maintaining custom-tailored backup/restore procedures and disaster recovery plans for Production Servers. - Enhancing system availability - Support and/or participate in 7 X 24 hour production support Provide support to Application Development Groups in the following ways: - Providing logical database structures alternatives - Creating a physical database design - Helping with construction, testing and installation - Ensuring application performance, integrity and availability - Proficient with system development techniques and tools SQL Server Software Maintenance: - Installing, configuring, securing SQL Production servers - Upgrading and upsizing databases from earlier versions to the latest versions - Applying and testing maintenance fixes - Providing technical support to the application developers - Reviewing new databases that come with purchased packages
Equal Employment Opportunity
DataFactZ employment does not discriminate on the basis of race, religion, gender, sexual orientation, age or any other basis as covered by federal, state, or local law.
Employment decisions are based solely on qualifications, merit and business needs.