Hi Assoc, Warm Greetings from Entellects Corp!
Our client is looking to fill the position mentioned below. Kindly go ahead and revert me back if you have someone suitable. Response Time: Immediate Requirement: Title: SQL Server DBA (Locals/Nearbys Only) Position: 2 Duration: 12 months Location: Chicago, IL Interview: Immediate Description: We are looking for a Senior SQL Server Database Administrator. The right candidate will possess expert understanding of the SQL Server architecture, administration and security arenas and will demonstrate a solid grasp of advanced SQL query techniques in addition to experience with large OLTP and OLAP environments. Primary job duties will include support for business intelligence developers as well as maintenance and administration of the live production SQL Server instances including data warehouse and other offsite instances related to live production. Responsibilities: - Ensures accurate, appropriate and effective use of data; including data definition, structure, documentation, long-range requirements, and operational guidelines. - Augments application development support including updates to data models, creation and maintenance of data access code (typically stored procedures), optimization of existing SQL. - Performs quality control audits to ensure accuracy completeness and proper usage of data in tables and support tools, such as database dictionaries. - Reviews database design and integration of systems and makes recommendations for enhancements or improvements. - Monitors transaction activity and utilization, with particular strengths in performance tuning highly transactional databases in both the development and production environments including remotely located servers. - Ensures data replication is scheduled and optimized. - Has excellent communication (oral and written) and interpersonal skills, is a proficient problem solver, has the ability to acquire new skills quickly, and thrive in a collaborative team environment. - Provide 24x7 on-call support for production systems. Knowledge, Skills And Abilities: - Bachelor of Science in Computer Science or equivalent experience. - 5+ years DBA experience with Microsoft SQL Server in revenue bearing production environment. - 3+ year experience with SSIS / SSRS / SSAS. - 3+ year experience in database and ETL development. - Experience working in agile environment including creating of automated build, integration and data refresh processes. - Expertise with configuring, implementing and supporting large high availability SQL Server environments, including experience with replication, log shipping, and database mirroring. - Deep understanding of database design principals. - Excellent understanding of query execution plans. - Expert in Stored Procedures and SQL coding. - Expert in query, index and DB I/O performance tuning. - Ability to proactively identify, troubleshoot and resolve live database systems issues. - Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore. - Thorough knowledge of current hardware systems, RAID and disk subsystems commonly used in fault tolerant production environments. - Ability to manage all DB maintenance plan activities including backups, indexing, integrity and consistency checks, etc. - Experience running and supporting very large databases under high transaction rates (OLTP, VLDB) - Experience running and supporting very large data warehouse databases (OLAP, Big Data) - Knowledge of 3rd party solutions including Idera's SQLSafe, SQL Compliance Manager and Diagnostic Manager or similar. Thanks & Regards Acer Mc Entellects Corp. Mailto: [email protected] | (V) 847-483-1814 ------------------------------------------------------------------------------------------ We respect your email and Internet privacy. If you have received this email in error or wish to be removed from our email list, please reply to us with the word "REMOVE" in the subject line and your ID will be removed from our mailing list immediately. We apologize for any inconvenience caused. -- You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en.
<<clip_image002.jpg>>
